using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace IStation.Calculation { /// /// 能效汇总业务时辅助类 /// public class EtaSumLogicHourHelper { /// /// 汇总 /// /// public static List Sum ( long CorpID, string ObjectType, long ObjectID, DateTime Day, IEnumerable list ) { if (list == null || list.Count() < 1) return default; var result = new List(); 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; } } }