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
}
}