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

    }
}