using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace IStation.Calculation
|
{
|
/// <summary>
|
/// 能效汇总业务时辅助类
|
/// </summary>
|
public class EtaSumLogicHourHelper
|
{
|
/// <summary>
|
/// 汇总
|
/// </summary>
|
/// <returns></returns>
|
public static List<Model.EtaSumLogicHourRecord> Sum
|
(
|
long CorpID,
|
string ObjectType,
|
long ObjectID,
|
DateTime Day,
|
IEnumerable<Model.EtaLogicRealRecord> list
|
)
|
{
|
if (list == null || list.Count() < 1)
|
return default;
|
var result = new List<Model.EtaSumLogicHourRecord>();
|
for (int i = 0; i < 24; i++)
|
{
|
var hour_list = list.Where(x => x.DataTime >= Day.Date.AddHours(i) && x.DataTime < Day.Date.AddHours(i + 1)).ToList();
|
var normal_hour_list = hour_list.Where(x => x.AnalyStatus == Model.Eta.eAnalyStatus.Normal).ToList();
|
var model = new Model.EtaSumLogicHourRecord();
|
model.CorpID = CorpID;
|
model.ObjectType = ObjectType;
|
model.ObjectID = ObjectID;
|
model.DataDay = Day.Date;
|
model.DataHour = i + 1;
|
model.DataTime = DateTime.Now;
|
model.Qt= hour_list.Sum(x => (x.Qa ?? 0) * x.Duration) / 3600f;
|
model.Dt = hour_list.Sum(x => (x.Pa ?? 0) * x.Duration) / 3600f;
|
model.PointCount = hour_list.Count();
|
|
if (normal_hour_list!=null&& normal_hour_list.Count > 0)
|
{
|
model.Qmin = normal_hour_list.Where(x=>x.Qa.HasValue).Min(x=>x.Qa.Value);
|
model.Qmax = normal_hour_list.Where(x => x.Qa.HasValue).Max(x => x.Qa.Value);
|
model.Qavg = normal_hour_list.Where(x => x.Qa.HasValue).Average(x => x.Qa.Value);
|
|
model.Hmin = normal_hour_list.Where(x => x.Ha.HasValue).Min(x=>x.Ha.Value);
|
model.Hmax= normal_hour_list.Where(x => x.Ha.HasValue).Max(x=>x.Ha.Value);
|
model.Havg= normal_hour_list.Where(x => x.Ha.HasValue).Average(x=>x.Ha.Value);
|
|
model.Emin= normal_hour_list.Where(x => x.Ea.HasValue).Min(x=>x.Ea.Value);
|
model.Emax= normal_hour_list.Where(x => x.Ea.HasValue).Max(x=>x.Ea.Value);
|
model.Eavg= normal_hour_list.Where(x => x.Ea.HasValue).Average(x=>x.Ea.Value);
|
|
model.Pmin= normal_hour_list.Where(x => x.Pa.HasValue).Min(x=>x.Pa.Value);
|
model.Pmax= normal_hour_list.Where(x => x.Pa.HasValue).Max(x=>x.Pa.Value);
|
model.Pavg= normal_hour_list.Where(x => x.Pa.HasValue).Average(x=>x.Pa.Value);
|
|
model.WPmin= normal_hour_list.Where(x => x.WPa.HasValue).Min(x=>x.WPa.Value);
|
model.WPmax = normal_hour_list.Where(x => x.WPa.HasValue).Max(x=>x.WPa.Value);
|
model.WPavg = normal_hour_list.Where(x => x.WPa.HasValue).Average(x=>x.WPa.Value);
|
|
model.UWPmin = normal_hour_list.Where(x => x.UWPa.HasValue).Min(x=>x.UWPa.Value);
|
model.UWPmax = normal_hour_list.Where(x => x.UWPa.HasValue).Max(x=>x.UWPa.Value);
|
model.UWPavg = normal_hour_list.Where(x => x.UWPa.HasValue).Average(x=>x.UWPa.Value);
|
}
|
|
result.Add(model);
|
}
|
|
return result;
|
}
|
|
|
|
}
|
}
|
