namespace IStation.Service { /// /// 监测记录 /// public partial class MonitorRecord { #region 最近记录 /// /// 获取最近一条记录 /// public List GetLastRecord() { //var lcacheHelper = LCacheCreateHelper.CreateLCache3(); //var records = lcacheHelper.GetLastRealRecord(); //return records; return default; } /// /// 获取最近一条记录 /// public Model.MonitorRecord GetLastRecord(string DataCode) { //var lcacheHelper = LCacheCreateHelper.CreateLCache3(); //var record = lcacheHelper.GetLastRealRecord(DataCode); //return record; return default; } /// /// 获取最近一条记录 /// public List GetLastRecord(List SignalIds) { //if (SignalIds == null || !SignalIds.Any()) // return default; //var lcacheHelper = LCacheCreateHelper.CreateLCache3(); //var records = lcacheHelper.GetLastRealRecord(SignalIds); //return records; return default; } #endregion #region 历史记录 /// /// 查询时间区间内的数据 /// public List GetByTimeRange(DateTime StartTime, DateTime EndTime) { if (StartTime > EndTime) return default; var dal = DALCreateHelper.CreateDAL(); var entity_list = dal.GetByTimeRange(StartTime, EndTime); var model_list = Entity2Models(entity_list); return model_list?.OrderBy(x => x.DataTime).ToList(); } /// /// 查询接收时间区间内的数据 /// public List GetByReceiptTimeRange(DateTime StartTime, DateTime EndTime) { if (StartTime > EndTime) return default; var dal = DALCreateHelper.CreateDAL(); var entity_list = dal.GetByReceiptTimeRange(StartTime, EndTime); var model_list = Entity2Models(entity_list); return model_list?.OrderBy(x => x.ReceiptTime).ToList(); } #region 时间区间 /// /// 通过 DataCode 查询时间区间内的数据 /// public List GetByDataCodeOfTimeRange(string DataCode, DateTime StartTime, DateTime EndTime) { if (StartTime > EndTime) return default; var dal = DALCreateHelper.CreateDAL(); var entity_list = dal.GetByDataCodeOfTimeRange(DataCode, StartTime, EndTime); var model_list = Entity2Models(entity_list); return model_list?.OrderBy(x => x.DataTime).ToList(); } /// /// 通过 DataCode 查询时间区间内的第一条数据 /// public Model.MonitorRecord GetFirstByDataCodeOfTimeRange(string DataCode, DateTime StartTime, DateTime EndTime) { if (StartTime > EndTime) return default; var dal = DALCreateHelper.CreateDAL(); var entity = dal.GetFirstByDataCodeOfTimeRange(DataCode, StartTime, EndTime); var model = Entity2Model(entity); return model; } /// /// 通过 DataCode 查询时间区间内的最后一条数据 /// public Model.MonitorRecord GetLastByDataCodeOfTimeRange(string DataCode, DateTime StartTime, DateTime EndTime) { if (StartTime > EndTime) return default; var dal = DALCreateHelper.CreateDAL(); var entity = dal.GetLastByDataCodeOfTimeRange(DataCode, StartTime, EndTime); var model = Entity2Model(entity); return model; } /// /// 通过 DataCode 查询时间区间内受限的数据 /// public List GetLimitByDataCodeOfTimeRange(string DataCode, DateTime StartTime, DateTime EndTime, int Limit) { if (StartTime > EndTime) return default; var dal = DALCreateHelper.CreateDAL(); var entity_list = dal.GetLimitByDataCodeOfTimeRange(DataCode, StartTime, EndTime, Limit); var model_list = Entity2Models(entity_list); return model_list?.OrderBy(x => x.DataTime).ToList(); } #endregion #region 日期区间 /// /// 通过 DataCode 查询日期区间内的数据 /// public List GetByDataCodeOfDayRange(string DataCode, DateTime StartDay, DateTime EndDay) { if (StartDay.Date > EndDay.Date) return default; var dal = DALCreateHelper.CreateDAL(); var entity_list = dal.GetByDataCodeOfDayRange(DataCode, StartDay, EndDay); var model_list = Entity2Models(entity_list); return model_list?.OrderBy(x => x.DataTime).ToList(); } /// /// 通过 DataCode 查询日期区间内的第一条数据 /// public Model.MonitorRecord GetFirstByDataCodeOfDayRange(string DataCode, DateTime StartDay, DateTime EndDay) { if (StartDay.Date > EndDay.Date) return default; var dal = DALCreateHelper.CreateDAL(); var entity = dal.GetFirstByDataCodeOfDayRange(DataCode, StartDay, EndDay); var model = Entity2Model(entity); return model; } /// /// 通过 DataCode 查询日期区间内的最后一条数据 /// public Model.MonitorRecord GetLastByDataCodeOfDayRange(string DataCode, DateTime StartDay, DateTime EndDay) { if (StartDay.Date > EndDay.Date) return default; var dal = DALCreateHelper.CreateDAL(); var entity = dal.GetLastByDataCodeOfDayRange(DataCode, StartDay, EndDay); var model = Entity2Model(entity); return model; } /// /// 通过 DataCode 查询日期区间内受限的数据 /// public List GetLimitByDataCodeOfDayRange(string DataCode, DateTime StartDay, DateTime EndDay, int Limit) { if (StartDay.Date > EndDay.Date) return default; var dal = DALCreateHelper.CreateDAL(); var entity_list = dal.GetLimitByDataCodeOfDayRange(DataCode, StartDay, EndDay, Limit); var model_list = Entity2Models(entity_list); return model_list?.OrderBy(x => x.DataTime).ToList(); } #endregion #region 日期 /// /// 通过 DataCode 获取某日的数据 /// public List GetByDataCodeOfDay(string DataCode, DateTime Day) { var dal = DALCreateHelper.CreateDAL(); var entity_list = dal.GetByDataCodeOfDay(DataCode, Day); var model_list = Entity2Models(entity_list); return model_list?.OrderBy(x => x.DataTime).ToList(); } /// /// 通过 DataCode 获取某日的第一条数据 /// public Model.MonitorRecord GetFirstByDataCodeOfDay(string DataCode, DateTime Day) { var dal = DALCreateHelper.CreateDAL(); var entity = dal.GetFirstByDataCodeOfDay(DataCode, Day); var model = Entity2Model(entity); return model; } /// /// 通过 DataCode 获取某日的最后一条数据 /// public Model.MonitorRecord GetLastByDataCodeOfDay(string DataCode, DateTime Day) { var dal = DALCreateHelper.CreateDAL(); var entity = dal.GetLastByDataCodeOfDay(DataCode, Day); var model = Entity2Model(entity); return model; } /// /// 通过 DataCode 获取某日受限的数据 /// public List GetLimitByDataCodeOfDay(string DataCode, DateTime Day, int Limit) { var dal = DALCreateHelper.CreateDAL(); var entity_list = dal.GetLimitByDataCodeOfDay(DataCode, Day, Limit); var model_list = Entity2Models(entity_list); return model_list?.OrderBy(x => x.DataTime).ToList(); } #endregion #region 时间 /// /// 通过时间获取 /// public Model.MonitorRecord GetByDataCodeOfTime(string DataCode, DateTime Time) { var dal = DALCreateHelper.CreateDAL(); var entity = dal.GetByDataCodeOfTime(DataCode, Time); var model = Entity2Model(entity); return model; } #endregion #endregion #region Insert /// /// 插入一条 /// public bool Insert(Model.MonitorRecord model) { if (model == null) { return default; } var dal = DALCreateHelper.CreateDAL(); var entity = Model2Entity(model); var bol = dal.InsertOrUpdate(entity); return bol; } /// /// 插入多条 /// public bool Inserts(List list) { if (list == null || !list.Any()) { return default; } var dal = DALCreateHelper.CreateDAL(); var entity_list = Model2Entities(list); var bol = dal.InsertOrUpdate(entity_list); return bol; } #endregion } }