using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace IStation.Service
|
{
|
/// <summary>
|
/// 能效标准(单)记录
|
/// </summary>
|
public partial class EtaStandardSingleRecord
|
{
|
#region 时记录
|
|
#region Query
|
|
/// <summary>
|
/// 通过对象获取时记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleHourRecord> GetHourByObject(long CorpID, string ObjectType, long ObjectID)
|
{
|
var dal=new DAL.EtaStandardSingleHourRecord();
|
var entity_list = dal.GetByObject(CorpID, ObjectType, ObjectID);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某日的时记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleHourRecord> GetHourByObjectOfDay(long CorpID, string ObjectType, long ObjectID, DateTime Day)
|
{
|
var dal=new DAL.EtaStandardSingleHourRecord();
|
var entity_list = dal.GetByObjectOfDay(CorpID, ObjectType, ObjectID, Day.Date);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某时的时记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleHourRecord> GetHourByObjectOfHour(long CorpID, string ObjectType, long ObjectID, DateTime Day, int Hour)
|
{
|
var dal=new DAL.EtaStandardSingleHourRecord();
|
var entity_list = dal.GetByObjectOfHour(CorpID, ObjectType, ObjectID, Day.Date, Hour);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取日期区间内的时记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleHourRecord> GetHourByObjectOfDayRange(long CorpID, string ObjectType, long ObjectID, DateTime StartDay, DateTime EndDay)
|
{
|
if (StartDay.Date > EndDay.Date)
|
return default;
|
var dal=new DAL.EtaStandardSingleHourRecord();
|
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.EtaStandardSingleHourRecord> 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.EtaStandardSingleHourRecord();
|
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.EtaStandardSingleHourRecord model)
|
{
|
if (model == null)
|
return default;
|
var dal=new DAL.EtaStandardSingleHourRecord();
|
var entity = Model2Entity(model);
|
var id = dal.Insert(entity);
|
return id;
|
}
|
|
/// <summary>
|
/// 批量插入
|
/// </summary>
|
public bool Inserts(IEnumerable<Model.EtaStandardSingleHourRecord> list)
|
{
|
if (list == null || list.Count() < 1)
|
return default;
|
var dal=new DAL.EtaStandardSingleHourRecord();
|
var entity_list = Model2Entities(list.ToList());
|
var bol = dal.Inserts(entity_list);
|
return bol;
|
}
|
|
#endregion
|
|
|
#endregion
|
|
#region 日记录
|
|
#region Query
|
|
/// <summary>
|
/// 通过对象获取日记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleDayRecord> GetDayByObject(long CorpID, string ObjectType, long ObjectID)
|
{
|
var dal=new DAL.EtaStandardSingleDayRecord();
|
var entity_list = dal.GetByObject(CorpID, ObjectType, ObjectID);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某日的日记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleDayRecord> GetDayByObjectOfDay(long CorpID, string ObjectType, long ObjectID, DateTime Day)
|
{
|
var dal=new DAL.EtaStandardSingleDayRecord();
|
var entity_list = dal.GetByObjectOfDay(CorpID, ObjectType, ObjectID, Day.Date);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过 CorpID 获取日期区间内的日记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleDayRecord> GetDayByCorpIDOfDayRange(long CorpID, DateTime StartDay, DateTime EndDay)
|
{
|
if (StartDay.Date > EndDay.Date)
|
return default;
|
var dal = new DAL.EtaStandardSingleDayRecord();
|
var entity_list = dal.GetByCorpIDOfDayRange(CorpID, StartDay.Date, EndDay.Date);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取日期区间内的日记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleDayRecord> GetDayByObjectOfDayRange(long CorpID, string ObjectType, long ObjectID, DateTime StartDay, DateTime EndDay)
|
{
|
if (StartDay.Date > EndDay.Date)
|
return default;
|
var dal=new DAL.EtaStandardSingleDayRecord();
|
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.EtaStandardSingleDayRecord> 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);
|
}
|
|
|
#endregion
|
|
#region Insert
|
|
/// <summary>
|
/// 插入一条
|
/// </summary>
|
public long Insert(Model.EtaStandardSingleDayRecord model)
|
{
|
if (model == null)
|
return default;
|
var dal=new DAL.EtaStandardSingleDayRecord();
|
var entity = Model2Entity(model);
|
var id = dal.Insert(entity);
|
return id;
|
}
|
|
/// <summary>
|
/// 批量插入
|
/// </summary>
|
public bool Inserts(IEnumerable<Model.EtaStandardSingleDayRecord> list)
|
{
|
if (list == null || list.Count() < 1)
|
return default;
|
var dal=new DAL.EtaStandardSingleDayRecord();
|
var entity_list = Model2Entities(list.ToList());
|
var bol = dal.Inserts(entity_list);
|
return bol;
|
}
|
|
#endregion
|
|
#endregion
|
|
#region 周记录
|
|
#region Query
|
|
/// <summary>
|
/// 通过对象获取周记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleWeekRecord> GetWeekByObject(long CorpID, string ObjectType, long ObjectID)
|
{
|
var dal = new DAL.EtaStandardSingleWeekRecord();
|
var entity_list = dal.GetByObject(CorpID, ObjectType, ObjectID);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某周的周记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleWeekRecord> GetWeekByObjectOfWeek(long CorpID, string ObjectType, long ObjectID, DateTime StartDay, DateTime EndDay)
|
{
|
if (StartDay.Date > EndDay.Date)
|
return default;
|
var dal = new DAL.EtaStandardSingleWeekRecord();
|
var entity_list = dal.GetByObjectOfWeek(CorpID, ObjectType, ObjectID, StartDay.Date, EndDay.Date);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取日期区间内的周记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleWeekRecord> GetWeekByObjectOfDayRange(long CorpID, string ObjectType, long ObjectID, DateTime StartDay, DateTime EndDay)
|
{
|
if (StartDay.Date > EndDay.Date)
|
return default;
|
var dal = new DAL.EtaStandardSingleWeekRecord();
|
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.EtaStandardSingleWeekRecord model)
|
{
|
if (model == null)
|
return default;
|
var dal = new DAL.EtaStandardSingleWeekRecord();
|
var entity = Model2Entity(model);
|
var id = dal.Insert(entity);
|
return id;
|
}
|
|
/// <summary>
|
/// 批量插入
|
/// </summary>
|
public bool Inserts(IEnumerable<Model.EtaStandardSingleWeekRecord> list)
|
{
|
if (list == null || list.Count() < 1)
|
return default;
|
var dal = new DAL.EtaStandardSingleWeekRecord();
|
var entity_list = Model2Entities(list.ToList());
|
var bol = dal.Inserts(entity_list);
|
return bol;
|
}
|
|
#endregion
|
|
#endregion
|
|
#region 月记录
|
|
#region Query
|
|
/// <summary>
|
/// 通过对象获取月记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleMonthRecord> GetMonthByObject(long CorpID, string ObjectType, long ObjectID)
|
{
|
var dal = new DAL.EtaStandardSingleMonthRecord();
|
var entity_list = dal.GetByObject(CorpID, ObjectType, ObjectID);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过 CorpID 获取某年的月记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleMonthRecord> GetMonthByCorpIDOfYear(long CorpID, int Year)
|
{
|
var dal = new DAL.EtaStandardSingleMonthRecord();
|
var entity_list = dal.GetByCorpIDOfYear(CorpID, Year);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某年的月记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleMonthRecord> GetMonthByObjectOfYear(long CorpID, string ObjectType, long ObjectID, int Year)
|
{
|
var dal = new DAL.EtaStandardSingleMonthRecord();
|
var entity_list = dal.GetByObjectOfYear(CorpID, ObjectType, ObjectID, Year);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某月的月记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleMonthRecord> GetMonthByObjectOfMonth(long CorpID, string ObjectType, long ObjectID, int Year, int Month)
|
{
|
var dal = new DAL.EtaStandardSingleMonthRecord();
|
var entity_list = dal.GetByObjectOfMonth(CorpID, ObjectType, ObjectID, Year, Month);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取年区间内的月记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleMonthRecord> GetMonthByObjectOfYearRange(long CorpID, string ObjectType, long ObjectID, int StartYear, int EndYear)
|
{
|
if (StartYear > EndYear)
|
return default;
|
var dal = new DAL.EtaStandardSingleMonthRecord();
|
var entity_list = dal.GetByObjectOfYearRange(CorpID, ObjectType, ObjectID, StartYear, EndYear);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取月区间内的月记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleMonthRecord> 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.EtaStandardSingleMonthRecord();
|
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.EtaStandardSingleMonthRecord model)
|
{
|
if (model == null)
|
return default;
|
var dal = new DAL.EtaStandardSingleMonthRecord();
|
var entity = Model2Entity(model);
|
var id = dal.Insert(entity);
|
return id;
|
}
|
|
/// <summary>
|
/// 批量插入
|
/// </summary>
|
public bool Inserts(IEnumerable<Model.EtaStandardSingleMonthRecord> list)
|
{
|
if (list == null || list.Count() < 1)
|
return default;
|
var dal = new DAL.EtaStandardSingleMonthRecord();
|
var entity_list = Model2Entities(list.ToList());
|
var bol = dal.Inserts(entity_list);
|
return bol;
|
}
|
|
#endregion
|
|
#endregion
|
|
#region 年记录
|
|
#region Query
|
|
/// <summary>
|
/// 通过对象获取年记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleYearRecord> GetYearByObject(long CorpID, string ObjectType, long ObjectID)
|
{
|
var dal = new DAL.EtaStandardSingleYearRecord();
|
var entity_list = dal.GetByObject(CorpID, ObjectType, ObjectID);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取某年的年记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleYearRecord> GetYearByObjectOfYear(long CorpID, string ObjectType, long ObjectID, int Year)
|
{
|
var dal = new DAL.EtaStandardSingleYearRecord();
|
var entity_list = dal.GetByObjectOfYear(CorpID, ObjectType, ObjectID, Year);
|
var model_list = Entity2Models(entity_list);
|
return model_list;
|
}
|
|
/// <summary>
|
/// 通过对象获取年区间内的年记录数据
|
/// </summary>
|
public List<Model.EtaStandardSingleYearRecord> GetYearByObjectOfYearRange(long CorpID, string ObjectType, long ObjectID, int StartYear, int EndYear)
|
{
|
if (StartYear > EndYear)
|
return default;
|
var dal = new DAL.EtaStandardSingleYearRecord();
|
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.EtaStandardSingleYearRecord model)
|
{
|
if (model == null)
|
return default;
|
var dal = new DAL.EtaStandardSingleYearRecord();
|
var entity = Model2Entity(model);
|
var id = dal.Insert(entity);
|
return id;
|
}
|
|
/// <summary>
|
/// 批量插入
|
/// </summary>
|
public bool Inserts(IEnumerable<Model.EtaStandardSingleYearRecord> list)
|
{
|
if (list == null || list.Count() < 1)
|
return default;
|
var dal = new DAL.EtaStandardSingleYearRecord();
|
var entity_list = Model2Entities(list.ToList());
|
var bol = dal.Inserts(entity_list);
|
return bol;
|
}
|
|
#endregion
|
|
#endregion
|
}
|
}
|
