using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using IStation.RedisCache; namespace IStation.Service { /// /// 周监测记录 /// public partial class MonitorWeekRecord { #region 最后一条记录 /// /// 获取最近一条记录 /// public Model.MonitorWeekRecordPure GetLastRecord(long CorpID, long MonitorPointID, long SignalID) { var redisHelper = new MonitorRecordCacheHelper(); var record = redisHelper.GetLastWeekRecord(CorpID, MonitorPointID, SignalID); return record; } /// /// 获取最近一条记录 /// public List GetLastRecord(long CorpID, long MonitorPointID, IEnumerable SignalIds) { if (SignalIds == null || SignalIds.Count() < 1) return default; var redisHelper = new MonitorRecordCacheHelper(); var records = redisHelper.GetLastWeekRecord(CorpID, MonitorPointID, SignalIds); return records; } /// /// 获取最近一条记录 /// public List GetLastRecord(long CorpID, Dictionary dict) { var redisHelper = new MonitorRecordCacheHelper(); var records = redisHelper.GetLastWeekRecord(CorpID, dict); return records; } /// /// 获取最近一条记录 /// public List GetLastRecord(long CorpID, long MonitorPointID) { var redisHelper = new MonitorRecordCacheHelper(); var records = redisHelper.GetLastWeekRecord(CorpID, MonitorPointID); return records; } /// /// 获取最近一条记录 /// public List GetLastRecord(long CorpID, IEnumerable MonitorPointIds) { if (MonitorPointIds == null || MonitorPointIds.Count() < 1) return default; var redisHelper = new MonitorRecordCacheHelper(); var records = redisHelper.GetLastWeekRecord(CorpID, MonitorPointIds); return records; } /// /// 获取最近一条正常记录 /// public Model.MonitorWeekRecordPure GetLastNormalRecord(long CorpID, long MonitorPointID, long SignalID) { var redisHelper = new MonitorRecordCacheHelper(); var record = redisHelper.GetLastNormalWeekRecord(CorpID, MonitorPointID, SignalID); return record; } /// /// 获取最近一条正常记录 /// public List GetLastNormalRecord(long CorpID, Dictionary dict) { if (dict == null || dict.Count < 1) return default; var redisHelper = new MonitorRecordCacheHelper(); var records = redisHelper.GetLastNormalWeekRecord(CorpID, dict); return records; } /// /// 获取最近一条正常记录 /// public List GetLastNormalRecord(long CorpID, long MonitorPointID) { var redisHelper = new MonitorRecordCacheHelper(); var records = redisHelper.GetLastNormalWeekRecord(CorpID, MonitorPointID); return records; } /// /// 获取最近一条正常记录 /// public List GetLastNormalRecord(long CorpID, IEnumerable MonitorPointIds) { if (MonitorPointIds == null || MonitorPointIds.Count() < 1) return default; var redisHelper = new MonitorRecordCacheHelper(); var records = redisHelper.GetLastNormalWeekRecord(CorpID, MonitorPointIds); return records; } #endregion #region 历史记录 /// /// 通过 MonitorPointID 获取 /// public List GetByMonitorPointID(long CorpID, long MonitorPointID) { var dal = new DAL.MonitorWeekRecord(); var entity_list = dal.GetByMonitorPointID(CorpID, MonitorPointID); var model_list = Entity2Models(entity_list); return model_list?.OrderBy(x=>x.StartDay).ToList(); } #endregion #region Insert /// /// 插入一条 /// public bool Insert(Model.MonitorWeekRecordPure model) { if (model == null) return default; var dal = new DAL.MonitorWeekRecord(); var entity = Model2Entity(new Model.MonitorWeekRecord(model)); var id = dal.Insert(entity); return id > 0; } /// /// 插入多条 /// public bool Inserts(List list) { if (list == null || list.Count() < 1) return default; var dal = new DAL.MonitorWeekRecord(); var entity_list = Model2Entities(list.Select(x => new Model.MonitorWeekRecord(x)).ToList()); var bol = dal.Inserts(entity_list); return bol; } /// /// 插入最近一条记录 /// public bool InsertLastRecord(Model.MonitorWeekRecordPure model) { if (model == null) return default; var dal = new DAL.MonitorWeekRecord(); var entity = Model2Entity(new Model.MonitorWeekRecord(model)); var bol = dal.Insert(entity) > 0; if (bol) { var redisHelper = new MonitorRecordCacheHelper(); redisHelper.SetLastWeekRecord(model); } return bol; } /// /// 插入最近多条记录 /// public bool InsertsLastRecord(List list) { if (list == null || list.Count() < 1) return default; var dal = new DAL.MonitorWeekRecord(); var entity_list = Model2Entities(list.Select(x => new Model.MonitorWeekRecord(x)).ToList()); var bol = dal.Inserts(entity_list); if (bol) { var redisHelper = new MonitorRecordCacheHelper(); redisHelper.SetLastWeekRecord(list); } return bol; } /// /// 补录一条 /// public bool InsertSupplement(Model.MonitorWeekRecordPure model) { if (model == null) return default; var dal = new DAL.MonitorWeekRecord(); var entity = Model2Entity(new Model.MonitorWeekRecord(model)); var id = dal.Insert(entity); return id>0; } /// /// 补录多条 /// public bool InsertsSupplement(List list) { if (list == null || list.Count() < 1) return default; var dal = new DAL.MonitorWeekRecord(); var entity_list = Model2Entities(list.Select(x=>new Model.MonitorWeekRecord(x)).ToList()); var bol = dal.Inserts(entity_list); return bol; } /// /// 重录一条 /// public bool InsertAgain(Model.MonitorWeekRecordPure model) { if (model == null) return false; var dal = new DAL.MonitorWeekRecord(); var result = dal.DeleteBySignalIDOfWeek(model.CorpID, model.MonitorPointID, model.SignalID, model.StartDay,model.EndDay); if (!result) { LogHelper.Info($"重录一条监测周记录中,CorpID:{model.CorpID},MonitorPointID:{model.MonitorPointID},SignalID:{model.SignalID},StartDay:{model.StartDay:yyyy-MM-dd},EndDay:{model.EndDay:yyyy-MM-dd},未检索到已存在记录!"); } var entity = Model2Entity(new Model.MonitorWeekRecord(model)); var id = dal.Insert(entity); return id > 0; } /// /// 重录多条 /// public bool InsertsAgain(List list) { if (list == null || list.Count < 1) return false; var corpIds = list.Select(x => x.CorpID).Distinct().ToList(); if (corpIds.Count > 1) { return default; } var groupList = list.GroupBy(x => new { x.CorpID, x.MonitorPointID, x.SignalID }).ToList(); var dal = new DAL.MonitorWeekRecord(); foreach (var group in groupList) { var startDay = group.Min(x => x.StartDay); var endDay = group.Max(x => x.EndDay); var result = dal.DeleteBySignalIDOfWeekRange(group.Key.CorpID, group.Key.MonitorPointID, group.Key.SignalID, startDay, endDay); if (!result) { LogHelper.Info($"重录多条监测周记录中,CorpID:{group.Key.CorpID},MonitorPointID:{group.Key.MonitorPointID},SignalID:{group.Key.SignalID},StartDay:{startDay:yyyy-MM-dd}, EndDay:{endDay:yyyy-MM-dd},未检索到已存在记录!"); } } var entityList = Model2Entities(list.Select(x => new Model.MonitorWeekRecord(x)).ToList()); var bol = dal.Inserts(entityList); return bol; } #endregion #region Update /// /// 更新一条 /// public bool Update(Model.MonitorWeekRecord model) { if (model == null) return default; var dal = new DAL.MonitorWeekRecord(); var entity = Model2Entity(model); var bol = dal.Update(entity); return bol; } /// /// 批量更新 /// public bool Updates(List list) { if (list == null || list.Count < 1) return default; var dal = new DAL.MonitorWeekRecord(); var entityList = Model2Entities(list); var bol = dal.Updates(entityList); return bol; } #endregion } }