From 36a0ce55799c95821f39aab5c13566a5f238970b Mon Sep 17 00:00:00 2001
From: duheng <2784771470@qq.com>
Date: 星期二, 11 二月 2025 12:56:55 +0800
Subject: [PATCH] 修复预测接口问题
---
WebApi/Controllers/PumpRunController.cs | 76 +++++++++++++++++++++++++++++++++++---
1 files changed, 70 insertions(+), 6 deletions(-)
diff --git a/WebApi/Controllers/PumpRunController.cs b/WebApi/Controllers/PumpRunController.cs
index 454d279..b082193 100644
--- a/WebApi/Controllers/PumpRunController.cs
+++ b/WebApi/Controllers/PumpRunController.cs
@@ -20,8 +20,6 @@
[RoutePrefix("PumpRun")]
public class PumpRunController : ApiController
{
- private bool isdebug = true;
-
/// <summary>
/// 鑾峰彇娉靛疄闄呰繍琛屽弬鏁�(涓�澶�)
/// </summary>
@@ -48,7 +46,7 @@
PumpRunParasHelper pumpRunParasHelper = new PumpRunParasHelper();
result = Common.PumpRunParasHelper.ReadPumpRunParas(d);
string geterroer = null;
- if (result != null && isdebug)
+ if (result != null)
{
result.Electric = Math.Round(result.Electric, 2);
result.Money = Math.Round(result.Money, 2);
@@ -103,7 +101,7 @@
{
var PumpTotalElecty = await ZyConnectHelper.GetPumpTotalElectricity(d, d); //鑾峰彇鏌愭鏃堕棿鐨勭敤鐢甸噺
var PumpState = await ZyConnectHelper.GetPumpOpenStatusBySingleDay(d); //鑾峰彇娉电殑寮�鏈烘儏鍐�
- var TotalWater = await ZyConnectHelper.GetTotalWaterByDayTimeRange_In(d, d); //鍙栨按閲�
+ var TotalWater = await ZyConnectHelper.GetTotalWaterByDayTimeRange_In(d.AddDays(-1), d); //鍙栨按閲�
/* PumpHistoryDataFileHelper pumpHistoryDataFileHelper=new PumpHistoryDataFileHelper();
var TotalWater = pumpHistoryDataFileHelper.GetAllWaterData();
@@ -325,7 +323,7 @@
/// <returns></returns>
[Route("GetPumpHistoryData")]
[HttpGet]
- public async Task<IStation.Dto.ApiResult> GetPumpHistoryData(string startday, string endday)
+ public async Task<IStation.Dto.ApiResult> GetPumpHistoryData(string startday, string endday, string resolution)
{
if (startday == null || endday == null)
{
@@ -341,7 +339,7 @@
{
return new IStation.Dto.ApiResult() { Code = ApiResultCode.Error, Message = "day 鏍煎紡涓嶆纭�" };
}
- var TotalWater = await ZyConnectHelper.GetTotalWaterByDayTimeRange_In(Start, d, "3600s"); //鍙栨按閲�
+ var TotalWater = await ZyConnectHelper.GetTotalWaterByTimeRange_Out(Start, d, resolution); //鍙栨按閲�
/* var one = TotalWater
.SelectMany(otdl => otdl.MonitorRecords);
var two = one.GroupBy(totalDay => totalDay.Time);
@@ -376,5 +374,71 @@
}
return new IStation.Dto.ApiResult<List<SSAData>>(totalOneDays) { Code = ApiResultCode.Success, Message = "Success" };
}
+
+ /// <summary>
+ /// 鑾峰彇渚涙按寮�鏈虹姸鎬�
+ /// </summary>
+ /// <param name="startday"></param> 寮�濮嬫棩鏈�
+ /// <param name="endday"></param> 缁撴潫鏃ユ湡
+ /// <returns></returns>
+ [Route("GetPumpOpenState")]
+ [HttpGet]
+ public async Task<IStation.Dto.ApiResult> GetPumpOpenState(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 result = await ZyConnectHelper.GetPumpOpenStatusDay(Start, d, "1h");
+ var totalSumByTimePoint = result
+ .SelectMany(otdl => otdl.MonitorRecords)
+ .GroupBy(totalDay => totalDay.Time) // 鎸夌収灏忔椂鍜屽垎閽熻繘琛屽垎缁�
+ .Select(group =>
+ {
+ var time = group.First().Time; // 浠庣粍涓幏鍙栨椂闂�
+ var totalSumForTimePoint = group.Sum(totalDay => totalDay.Value); // 鍦ㄦ椂闂寸偣鍒嗙粍涓绠楁�诲拰
+ return new { Time = time, Total = totalSumForTimePoint };
+ });
+ List<SSAData> totalOneDays = new List<SSAData>();
+ foreach (var item in totalSumByTimePoint)
+ {
+ totalOneDays.Add(new SSAData() { DateTime = item.Time, Total = (double)item.Total });
+ }
+ return new IStation.Dto.ApiResult<List<SSAData>>(totalOneDays) { Code = ApiResultCode.Success, Message = "Success" };
+ }
+
+
+
+ [Route("GetPumpRealData")]
+ [HttpGet]
+ public async Task<IStation.Dto.ApiResult> GetPumpRealData(string startday, string endday, string resolution)
+ {
+ 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.GetTotalWaterByTimeRange_Out(Start, d, resolution); //鍙栨按閲�
+ return new IStation.Dto.ApiResult<List<RealScadaData>>(TotalWater) { Code = ApiResultCode.Success, Message = "Success" };
+ }
}
}
\ No newline at end of file
--
Gitblit v1.9.3