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