using IStation.CalcModel.Tide; using IStation.Common; using IStation.Dto; using IStation.Model; using IStation.ZyModel; using System; using System.Collections.Generic; using System.Linq; using System.Security.Policy; using System.Threading.Tasks; using System.Web.Http; using System.Web.Http.Results; namespace IStation.WebApi.Controllers { /// /// 泵运行时间 /// [RoutePrefix("PumpRun")] public class PumpRunController : ApiController { bool isdebug = true; /// /// 获取泵实际运行参数(一天) /// /// /// [Route("GetByOneDay")] [HttpGet] public async Task< IStation.Dto.ApiResult> GetByOneDay(string startday) { if (startday == null) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day null" }; } DateTime d; if (!DateTime.TryParse(startday, out d)) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day 格式不正确" }; } if (d > DateTime.Now.AddDays(1)) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "天数不正确" }; } RunParasData result = null; PumpRunParasHelper pumpRunParasHelper = new PumpRunParasHelper(); result = Common.PumpRunParasHelper.ReadPumpRunParas(d); string geterroer=null; if (result != null&& isdebug) { result.Electric = Math.Round(result.Electric, 2); result.Money = Math.Round(result.Money, 2); result.FlowIn = Math.Round(result.FlowIn, 2); if (result.Pump1.Count != 0) { foreach (var item in result.Pump1) { item.Electric = Math.Round(item.Electric, 2); item.Money = Math.Round(item.Money, 2); item.FlowIn = Math.Round(item.FlowIn, 2); } } if (result.Pump2.Count != 0) { foreach (var item in result.Pump2) { item.Electric = Math.Round(item.Electric, 2); item.Money = Math.Round(item.Money, 2); item.FlowIn = Math.Round(item.FlowIn, 2); } } if (result.Pump3.Count != 0) { foreach (var item in result.Pump3) { item.Electric = Math.Round(item.Electric, 2); item.Money = Math.Round(item.Money, 2); item.FlowIn = Math.Round(item.FlowIn, 2); } } if (result.Pump4.Count != 0) { foreach (var item in result.Pump4) { item.Electric = Math.Round(item.Electric, 2); item.Money = Math.Round(item.Money, 2); item.FlowIn = Math.Round(item.FlowIn, 2); } } if (result.Pump5.Count != 0) { foreach (var item in result.Pump5) { item.Electric = Math.Round(item.Electric, 2); item.Money = Math.Round(item.Money, 2); item.FlowIn = Math.Round(item.FlowIn, 2); } } } else { var PumpTotalElecty = await ZyConnectHelper.GetPumpTotalElectricity(d, d); //获取某段时间的用电量 var PumpState = await ZyConnectHelper.GetPumpOpenStatusBySingleDay(d); //获取泵的开机情况 var TotalWater = await ZyConnectHelper.GetTotalWaterByDayTimeRange_In(d, d); //取水量 /* PumpHistoryDataFileHelper pumpHistoryDataFileHelper=new PumpHistoryDataFileHelper(); var TotalWater = pumpHistoryDataFileHelper.GetAllWaterData(); var PumpState = pumpHistoryDataFileHelper.getpumpstate(); var PumpTotalElecty = pumpHistoryDataFileHelper.GetAllEleData();*/ result = pumpRunParasHelper.GetRunParasDatas(PumpState, TotalWater, PumpTotalElecty, d,out geterroer); } if (result != null) { pumpRunParasHelper.Save(result, out string error); // LogHelper.Info(error); } if (geterroer != null) { LogHelper.Info(geterroer); } return new IStation.Dto.ApiResult(result) { Code = ApiResultCode.Success, Message = "Success" }; } /// /// 获取泵历史运行参数 /// /// /// [Route("GetByHistoryOneDay")] [HttpGet] public IStation.Dto.ApiResult GetByHistoryOneDay(string day) { if (day == null) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day null" }; } DateTime d; if (!DateTime.TryParse(day, out d)) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day 格式不正确" }; } var history = Common.PumpRunParasHelper.ReadPumpRunParas(d); if (history == null) return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "Data null" }; history.Electric = Math.Round(history.Electric, 2); history.Money = Math.Round(history.Money, 2); history.FlowIn = Math.Round(history.FlowIn, 2); if (history.Pump1.Count != 0) { foreach (var item in history.Pump1) { item.Electric = Math.Round(item.Electric, 2); item.Money = Math.Round(item.Money, 2); item.FlowIn = Math.Round(item.FlowIn, 2); } } if (history.Pump2.Count != 0) { foreach (var item in history.Pump2) { item.Electric = Math.Round(item.Electric, 2); item.Money = Math.Round(item.Money, 2); item.FlowIn = Math.Round(item.FlowIn, 2); } } if (history.Pump3.Count != 0) { foreach (var item in history.Pump3) { item.Electric = Math.Round(item.Electric, 2); item.Money = Math.Round(item.Money, 2); item.FlowIn = Math.Round(item.FlowIn, 2); } } if (history.Pump4.Count != 0) { foreach (var item in history.Pump4) { item.Electric = Math.Round(item.Electric, 2); item.Money = Math.Round(item.Money, 2); item.FlowIn = Math.Round(item.FlowIn, 2); } } if (history.Pump5.Count != 0) { foreach (var item in history.Pump5) { item.Electric = Math.Round(item.Electric, 2); item.Money = Math.Round(item.Money, 2); item.FlowIn = Math.Round(item.FlowIn, 2); } } return new IStation.Dto.ApiResult(history) { Code = ApiResultCode.Success, Message = "Success" }; } /// /// 一天内的总取水量和用电量 /// /// /// [Route("GetOneDayData")] [HttpGet] public IStation.Dto.ApiResult GetOneDayPumpWaterData(string day) { if (day == null) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day null" }; } DateTime d; if (!DateTime.TryParse(day, out d)) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day 格式不正确" }; } var WaterParas = Common.PumpRunParasHelper.ReadPumpWaterParas(d); return new IStation.Dto.ApiResult>(WaterParas) { Code = ApiResultCode.Success, Message = "Success" }; } /// /// 获取时间段内的单管道供水数据 /// /// /// /// /// [Route("GetPumpOutDayWater")] [HttpGet] public IStation.Dto.ApiResult GetPumpOutWater(string startday,string endday,int sign) { if (startday == null||endday==null) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day null" }; } DateTime Start; if (!DateTime.TryParse(startday, out Start)) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day 格式不正确" }; } DateTime End; if (!DateTime.TryParse(endday, out End)) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day 格式不正确" }; } var WaterParas = Common.PumpRunParasHelper.ReadPumpOutWater(Start,End, sign); return new IStation.Dto.ApiResult>(WaterParas) { Code = ApiResultCode.Success, Message = "Success" }; } /// /// 获取所有的月合计数据(单管道) /// /// [Route("GetPumpOutMonthWater")] [HttpGet] public IStation.Dto.ApiResult GetPumpOutMonthWater() { var WaterParas = Common.PumpRunParasHelper.ReadPumpMonthOutWater(); return new IStation.Dto.ApiResult>(WaterParas) { Code = ApiResultCode.Success, Message = "Success" }; } /// /// 获取天的合并供水瞬时数据(总管) /// /// 开始日期 /// 结束日期 /// [Route("GetPumpTotalDayOutWater")] [HttpGet] public IStation.Dto.ApiResult GetPumpTotalDayOutWater(string startday, string endday) { if (startday == null || endday == null) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day null" }; } DateTime Start; if (!DateTime.TryParse(startday, out Start)) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day 格式不正确" }; } DateTime End; if (!DateTime.TryParse(endday, out End)) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day 格式不正确" }; } var WaterParas = Common.PumpRunParasHelper.ReadPumpAllDayOutWater(Start,End); return new IStation.Dto.ApiResult>(WaterParas) { Code = ApiResultCode.Success, Message = "Success" }; } /// /// 获取天的合并供水累计数据(总管) /// /// 开始日期 /// 结束日期 /// [Route("GetPumpTotalDayAccOutWater")] [HttpGet] public IStation.Dto.ApiResult GetPumpTotalDayAccOutWater(string startday, string endday) { if (startday == null || endday == null) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day null" }; } DateTime Start; if (!DateTime.TryParse(startday, out Start)) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day 格式不正确" }; } DateTime End; if (!DateTime.TryParse(endday, out End)) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day 格式不正确" }; } var WaterParas = Common.PumpRunParasHelper.ReadPumpAllDayOutAccWater(Start, End); return new IStation.Dto.ApiResult>(WaterParas) { Code = ApiResultCode.Success, Message = "Success" }; } /// /// 获取给预测水位用的数据的历史取水量 (从众毅) /// /// 开始日期 /// 结束日期 /// [Route("GetPumpHistoryData")] [HttpGet] public async Task< IStation.Dto.ApiResult > GetPumpHistoryData(string startday, string endday) { if (startday == null || endday == null) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day null" }; } DateTime Start; if (!DateTime.TryParse(startday, out Start)) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day 格式不正确" }; } DateTime d; if (!DateTime.TryParse(endday, out d)) { return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day 格式不正确" }; } var TotalWater = await ZyConnectHelper.GetTotalWaterByDayTimeRange_In(d, d); //取水量 // ReadPumpAllDayOutAccWater // var TotalWater = PumpRunParasHelper.ReadPumpAllDayOutAccWater(d, d.AddDays(1)); var totalSumByTimePoint = TotalWater .SelectMany(otdl => otdl.MonitorRecords) .GroupBy(totalDay => totalDay.Time.TimeOfDay) // 按照小时和分钟进行分组 .Select(group => { var time = group.First().Time.TimeOfDay; // 从组中获取时间 var totalSumForTimePoint = group.Sum(totalDay => totalDay.Value); // 在时间点分组中计算总和 return new { Time = time, Total = totalSumForTimePoint }; }); /* var totalSumByTimePoint = TotalWater .SelectMany(otdl => otdl.pumpOutWater) .GroupBy(totalDay => totalDay.DateTime.TimeOfDay) // 按照小时和分钟进行分组 .Select(group => { var time = group.First().DateTime.TimeOfDay; // 从组中获取时间 var totalSumForTimePoint = group.Sum(totalDay => totalDay.Total); // 在时间点分组中计算总和 return new { Time = time, Total = totalSumForTimePoint }; });*/ List< TotalOneDay > totalOneDays = new List< TotalOneDay >(); foreach (var item in totalSumByTimePoint) { totalOneDays.Add(new TotalOneDay() { DateTime = d + item.Time, Total = (double)item.Total }); } return new IStation.Dto.ApiResult>(totalOneDays) { Code = ApiResultCode.Success, Message = "Success" }; } } }