using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace IStation.Service
|
{
|
/// <summary>
|
/// 能效汇总业务记录
|
/// </summary>
|
public partial class EtaSumLogicRecord
|
{
|
#region 时记录
|
|
#region Query
|
|
/// <summary>
|
/// 通过对象获取时记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicHourRecord> GetHourByObject(long CorpID, string ObjectType, long ObjectID)
|
{
|
var dal=new DAL.EtaSumLogicHourRecord();
|
var entity_list = dal.GetByObject(CorpID, ObjectType, ObjectID);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某日的时记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicHourRecord> GetHourByObjectOfDay(long CorpID, string ObjectType, long ObjectID, DateTime Day)
|
{
|
var dal=new DAL.EtaSumLogicHourRecord();
|
var entity_list = dal.GetByObjectOfDay(CorpID, ObjectType, ObjectID, Day.Date);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某时的时记录数据
|
/// </summary>
|
public Model.EtaSumLogicHourRecord GetHourByObjectOfHour(long CorpID, string ObjectType, long ObjectID, DateTime Day, int Hour)
|
{
|
var dal=new DAL.EtaSumLogicHourRecord();
|
var entity_list = dal.GetByObjectOfHour(CorpID, ObjectType, ObjectID, Day.Date, Hour);
|
var entity = entity_list?.OrderByDescending(x => x.DataTime).FirstOrDefault();
|
var model = Entity2Model(entity);
|
return model;
|
}
|
|
/// <summary>
|
/// 通过对象获取日期区间内的时记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicHourRecord> GetHourByObjectOfDayRange(long CorpID, string ObjectType, long ObjectID, DateTime StartDay, DateTime EndDay)
|
{
|
if (StartDay.Date > EndDay.Date)
|
return default;
|
var dal=new DAL.EtaSumLogicHourRecord();
|
var entity_list = dal.GetByObjectOfDayRange(CorpID, ObjectType, ObjectID, StartDay.Date, EndDay.Date);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取时区间内的时记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicHourRecord> GetHourByObjectOfHourRange
|
(long CorpID, string ObjectType, long ObjectID, DateTime StartDay, int StartHour, DateTime EndDay, int EndHour)
|
{
|
var day_start = StartDay.Date;
|
var day_end = EndDay.Date;
|
if (day_start > day_end)
|
return default;
|
if (day_start == day_end)
|
{
|
if (StartHour > EndHour)
|
return default;
|
}
|
var dal=new DAL.EtaSumLogicHourRecord();
|
var entity_list = dal.GetByObjectOfHourRange(CorpID, ObjectType, ObjectID, day_start, StartHour, day_end, EndHour);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
#endregion
|
|
#region Insert
|
|
/// <summary>
|
/// 插入一条
|
/// </summary>
|
public long Insert(Model.EtaSumLogicHourRecord model)
|
{
|
if (model == null)
|
return default;
|
var dal=new DAL.EtaSumLogicHourRecord();
|
var entity = Model2Entity(model);
|
var id = dal.Insert(entity);
|
return id;
|
}
|
|
/// <summary>
|
/// 批量插入
|
/// </summary>
|
public bool Inserts(IEnumerable<Model.EtaSumLogicHourRecord> list)
|
{
|
if (list == null || list.Count() < 1)
|
return default;
|
var dal=new DAL.EtaSumLogicHourRecord();
|
var entity_list = Model2Entities(list.ToList());
|
var bol = dal.Inserts(entity_list);
|
return bol;
|
}
|
|
#endregion
|
|
|
#endregion
|
|
#region 日记录
|
|
#region Query
|
|
/// <summary>
|
/// 通过 CorpID 获取某日的数据
|
/// </summary>
|
public List<Model.EtaSumLogicDayRecord> GetDayByCorpIDOfDay(long CorpID, DateTime Day)
|
{
|
var dal = new DAL.EtaSumLogicDayRecord();
|
var entity_list = dal.GetByCorpIDOfDay(CorpID, Day);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取日记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicDayRecord> GetDayByObject(long CorpID, string ObjectType, long ObjectID)
|
{
|
var dal = new DAL.EtaSumLogicDayRecord();
|
var entity_list = dal.GetByObject(CorpID, ObjectType, ObjectID);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某日的日记录数据
|
/// </summary>
|
public Model.EtaSumLogicDayRecord GetDayByObjectOfDay(long CorpID, string ObjectType, long ObjectID, DateTime Day)
|
{
|
var dal = new DAL.EtaSumLogicDayRecord();
|
var entity_list = dal.GetByObjectOfDay(CorpID, ObjectType, ObjectID, Day.Date);
|
var entity = entity_list?.OrderByDescending(x => x.DataTime).FirstOrDefault();
|
var model = Entity2Model(entity);
|
return model;
|
}
|
|
/// <summary>
|
/// 通过 CorpID 获取日期区间内的日记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicDayRecord> GetDayByCorpIDOfDayRange(long CorpID, DateTime StartDay, DateTime EndDay)
|
{
|
if (StartDay.Date > EndDay.Date)
|
return default;
|
var dal = new DAL.EtaSumLogicDayRecord();
|
var entity_list = dal.GetByCorpIDOfDayRange(CorpID, StartDay.Date, EndDay.Date);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
|
/// <summary>
|
/// 通过对象获取日期区间内的日记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicDayRecord> GetDayByObjectOfDayRange(long CorpID, string ObjectType, long ObjectID, DateTime StartDay, DateTime EndDay)
|
{
|
if (StartDay.Date > EndDay.Date)
|
return default;
|
var dal = new DAL.EtaSumLogicDayRecord();
|
var entity_list = dal.GetByObjectOfDayRange(CorpID, ObjectType, ObjectID, StartDay.Date, EndDay.Date);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某月的日记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicDayRecord> GetDayByObjectOfYM(long CorpID, string ObjectType, long ObjectID, int Year, int Month)
|
{
|
var startDay = new DateTime(Year, Month, 1);
|
var endDay = startDay.AddMonths(1).AddDays(-1);
|
return GetDayByObjectOfDayRange(CorpID, ObjectType, ObjectID, startDay, endDay);
|
}
|
|
/// <summary>
|
/// 通过对象获取日期区间内最大供水量的日记录数据
|
/// </summary>
|
public Model.EtaSumLogicDayRecord GetMaxQtDayByObjectOfDayRange(long CorpID, string ObjectType, long ObjectID, DateTime StartDay, DateTime EndDay)
|
{
|
if (StartDay.Date > EndDay.Date)
|
return default;
|
var dal = new DAL.EtaSumLogicDayRecord();
|
var entity = dal.GetMaxQtByObjectOfDayRange(CorpID, ObjectType, ObjectID, StartDay.Date, EndDay.Date);
|
var model = Entity2Model(entity);
|
return model;
|
}
|
|
/// <summary>
|
/// 通过对象获取某年内最大供水量的日记录数据
|
/// </summary>
|
public Model.EtaSumLogicDayRecord GetMaxQtDayByObjectOfYear(long CorpID, string ObjectType, long ObjectID, int Year)
|
{
|
var startDay = new DateTime(Year, 1, 1);
|
var endDay = new DateTime(Year, 12, 31);
|
return GetMaxQtDayByObjectOfDayRange(CorpID, ObjectType, ObjectID, startDay, endDay);
|
}
|
|
#endregion
|
|
#region Insert
|
|
/// <summary>
|
/// 插入一条
|
/// </summary>
|
public long Insert(Model.EtaSumLogicDayRecord model)
|
{
|
if (model == null)
|
return default;
|
var dal = new DAL.EtaSumLogicDayRecord();
|
var entity = Model2Entity(model);
|
var id = dal.Insert(entity);
|
return id;
|
}
|
|
/// <summary>
|
/// 批量插入
|
/// </summary>
|
public bool Inserts(IEnumerable<Model.EtaSumLogicDayRecord> list)
|
{
|
if (list == null || list.Count() < 1)
|
return default;
|
var dal = new DAL.EtaSumLogicDayRecord();
|
var entity_list = Model2Entities(list.ToList());
|
var bol = dal.Inserts(entity_list);
|
return bol;
|
}
|
|
#endregion
|
|
#region Update
|
|
/// <summary>
|
/// 更新一条
|
/// </summary>
|
public bool Update(Model.EtaSumLogicDayRecord model)
|
{
|
if (model == null)
|
return default;
|
var dal = new DAL.EtaSumLogicDayRecord();
|
var entity = Model2Entity(model);
|
var bol = dal.Update(entity);
|
return bol;
|
}
|
|
|
/// <summary>
|
/// 批量更新
|
/// </summary>
|
public bool Updates(IEnumerable<Model.EtaSumLogicDayRecord> list)
|
{
|
if (list == null || list.Count() < 1)
|
return default;
|
var dal = new DAL.EtaSumLogicDayRecord();
|
var entity_list = Model2Entities(list.ToList());
|
var bol = dal.Updates(entity_list);
|
return bol;
|
}
|
|
#endregion
|
#endregion
|
|
#region 周记录
|
|
#region Query
|
|
/// <summary>
|
/// 通过对象获取周记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicWeekRecord> GetWeekByObject(long CorpID, string ObjectType, long ObjectID)
|
{
|
var dal=new DAL.EtaSumLogicWeekRecord();
|
var entity_list = dal.GetByObject(CorpID, ObjectType, ObjectID);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某周的周记录数据
|
/// </summary>
|
public Model.EtaSumLogicWeekRecord GetWeekByObjectOfWeek(long CorpID, string ObjectType, long ObjectID, DateTime StartDay, DateTime EndDay)
|
{
|
if (StartDay.Date > EndDay.Date)
|
return default;
|
var dal=new DAL.EtaSumLogicWeekRecord();
|
var entity_list = dal.GetByObjectOfWeek(CorpID, ObjectType, ObjectID, StartDay.Date, EndDay.Date);
|
var entity = entity_list?.OrderByDescending(x => x.DataTime).FirstOrDefault();
|
var model = Entity2Model(entity);
|
return model;
|
}
|
|
/// <summary>
|
/// 通过对象获取日期区间内的周记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicWeekRecord> GetWeekByObjectOfDayRange(long CorpID, string ObjectType, long ObjectID, DateTime StartDay, DateTime EndDay)
|
{
|
if (StartDay.Date > EndDay.Date)
|
return default;
|
var dal=new DAL.EtaSumLogicWeekRecord();
|
var entity_list = dal.GetByObjectOfDayRange(CorpID, ObjectType, ObjectID, StartDay.Date, EndDay.Date);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
#endregion
|
|
#region Insert
|
|
/// <summary>
|
/// 插入一条
|
/// </summary>
|
public long Insert(Model.EtaSumLogicWeekRecord model)
|
{
|
if (model == null)
|
return default;
|
var dal=new DAL.EtaSumLogicWeekRecord();
|
var entity = Model2Entity(model);
|
var id = dal.Insert(entity);
|
return id;
|
}
|
|
/// <summary>
|
/// 批量插入
|
/// </summary>
|
public bool Inserts(IEnumerable<Model.EtaSumLogicWeekRecord> list)
|
{
|
if (list == null || list.Count() < 1)
|
return default;
|
var dal=new DAL.EtaSumLogicWeekRecord();
|
var entity_list = Model2Entities(list.ToList());
|
var bol = dal.Inserts(entity_list);
|
return bol;
|
}
|
|
#endregion
|
|
#endregion
|
|
#region 月记录
|
|
#region Query
|
|
/// <summary>
|
/// 通过对象获取月记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicMonthRecord> GetMonthByObject(long CorpID, string ObjectType, long ObjectID)
|
{
|
var dal = new DAL.EtaSumLogicMonthRecord();
|
var entity_list = dal.GetByObject(CorpID, ObjectType, ObjectID);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过 CorpID 获取某年的月记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicMonthRecord> GetMonthByCorpIDOfYear(long CorpID, int Year)
|
{
|
var dal = new DAL.EtaSumLogicMonthRecord();
|
var entity_list = dal.GetByCorpIDOfYear(CorpID, Year);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某年的月记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicMonthRecord> GetMonthByObjectOfYear(long CorpID, string ObjectType, long ObjectID, int Year)
|
{
|
var dal = new DAL.EtaSumLogicMonthRecord();
|
var entity_list = dal.GetByObjectOfYear(CorpID, ObjectType, ObjectID, Year);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某月的月记录数据
|
/// </summary>
|
public Model.EtaSumLogicMonthRecord GetMonthByObjectOfMonth(long CorpID, string ObjectType, long ObjectID, int Year, int Month)
|
{
|
var dal = new DAL.EtaSumLogicMonthRecord();
|
var entity_list = dal.GetByObjectOfMonth(CorpID, ObjectType, ObjectID, Year, Month);
|
var entity = entity_list?.OrderByDescending(x => x.DataTime).FirstOrDefault();
|
var model = Entity2Model(entity);
|
return model;
|
}
|
|
/// <summary>
|
/// 通过对象获取年区间内的月记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicMonthRecord> GetMonthByObjectOfYearRange(long CorpID, string ObjectType, long ObjectID, int StartYear, int EndYear)
|
{
|
if (StartYear > EndYear)
|
return default;
|
var dal = new DAL.EtaSumLogicMonthRecord();
|
var entity_list = dal.GetByObjectOfYearRange(CorpID, ObjectType, ObjectID, StartYear, EndYear);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取月区间内的月记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicMonthRecord> GetMonthByObjectOfMonthRange(long CorpID, string ObjectType, long ObjectID, int StartYear, int StartMonth, int EndYear, int EndMonth)
|
{
|
if (StartYear > EndYear)
|
return default;
|
if (StartYear == EndYear)
|
{
|
if (StartMonth > EndMonth)
|
return default;
|
}
|
var dal = new DAL.EtaSumLogicMonthRecord();
|
var entity_list = dal.GetByObjectOfMonthRange(CorpID, ObjectType, ObjectID, StartYear, StartMonth, EndYear, EndMonth);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
#endregion
|
|
#region Insert
|
|
/// <summary>
|
/// 插入一条
|
/// </summary>
|
public long Insert(Model.EtaSumLogicMonthRecord model)
|
{
|
if (model == null)
|
return default;
|
var dal = new DAL.EtaSumLogicMonthRecord();
|
var entity = Model2Entity(model);
|
var id = dal.Insert(entity);
|
return id;
|
}
|
|
/// <summary>
|
/// 批量插入
|
/// </summary>
|
public bool Inserts(IEnumerable<Model.EtaSumLogicMonthRecord> list)
|
{
|
if (list == null || list.Count() < 1)
|
return default;
|
var dal = new DAL.EtaSumLogicMonthRecord();
|
var entity_list = Model2Entities(list.ToList());
|
var bol = dal.Inserts(entity_list);
|
return bol;
|
}
|
|
#endregion
|
|
#endregion
|
|
#region 年记录
|
|
#region Query
|
|
/// <summary>
|
/// 通过对象获取年记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicYearRecord> GetYearByObject(long CorpID, string ObjectType, long ObjectID)
|
{
|
var dal = new DAL.EtaSumLogicYearRecord();
|
var entity_list = dal.GetByObject(CorpID, ObjectType, ObjectID);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某年的年记录数据
|
/// </summary>
|
public Model.EtaSumLogicYearRecord GetYearByObjectOfYear(long CorpID, string ObjectType, long ObjectID, int Year)
|
{
|
var dal = new DAL.EtaSumLogicYearRecord();
|
var entity_list = dal.GetByObjectOfYear(CorpID, ObjectType, ObjectID, Year);
|
var entity = entity_list?.OrderByDescending(x => x.DataTime).FirstOrDefault();
|
var model = Entity2Model(entity);
|
return model;
|
}
|
|
/// <summary>
|
/// 通过对象获取年区间内的年记录数据
|
/// </summary>
|
public List<Model.EtaSumLogicYearRecord> GetYearByObjectOfYearRange(long CorpID, string ObjectType, long ObjectID, int StartYear, int EndYear)
|
{
|
if (StartYear > EndYear)
|
return default;
|
var dal = new DAL.EtaSumLogicYearRecord();
|
var entity_list = dal.GetByObjectOfYearRange(CorpID, ObjectType, ObjectID, StartYear, EndYear);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
#endregion
|
|
#region Insert
|
|
/// <summary>
|
/// 插入一条
|
/// </summary>
|
public long Insert(Model.EtaSumLogicYearRecord model)
|
{
|
if (model == null)
|
return default;
|
var dal = new DAL.EtaSumLogicYearRecord();
|
var entity = Model2Entity(model);
|
var id = dal.Insert(entity);
|
return id;
|
}
|
|
/// <summary>
|
/// 批量插入
|
/// </summary>
|
public bool Inserts(IEnumerable<Model.EtaSumLogicYearRecord> list)
|
{
|
if (list == null || list.Count() < 1)
|
return default;
|
var dal = new DAL.EtaSumLogicYearRecord();
|
var entity_list = Model2Entities(list.ToList());
|
var bol = dal.Inserts(entity_list);
|
return bol;
|
}
|
|
#endregion
|
|
#endregion
|
|
}
|
}
|
