using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;


namespace IStation.DAL
{
    /// <summary>
    /// 时监测记录
    /// </summary>
    public partial class MonitorHourRecord : CorpDAL<Entity.MonitorHourRecord>
    {
        /// <summary>
        /// 
        /// </summary>
        public override ConnectionConfig ConnectionConfig
        {
            get { return ConfigHelper.MonitorRecordConnectionConfig; }
        }

        #region 通过 MonitorPointID 获取

        /// <summary>
        /// 通过 MonitorPointID 获取
        /// </summary>
        public List<Entity.MonitorHourRecord> GetByMonitorPointID(long CorpID, long MonitorPointID)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorHourRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID)
                    .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }

        /// <summary>
        /// 通过 MonitorPointID 获取某天的数据
        /// </summary>
        public List<Entity.MonitorHourRecord> GetByMonitorPointIDOfDay(long CorpID, long MonitorPointID, DateTime Day)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorHourRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.DataDay == Day.Date)
                    .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }

        /// <summary>
        /// 通过 MonitorPointID 获取日期区间的数据
        /// </summary>
        public List<Entity.MonitorHourRecord> GetByMonitorPointIDOfDayRange(long CorpID, long MonitorPointID, DateTime StartDay, DateTime EndDay)
        {
            if (StartDay.Date > EndDay.Date)
                return default;
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorHourRecord>()
                        .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.DataDay >= StartDay.Date && x.DataDay <= EndDay.Date)
                        .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }

        /// <summary>
        /// 通过 MonitorPointID 获取区间的数据
        /// </summary>
        public List<Entity.MonitorHourRecord> GetByMonitorPointIDOfHourRange(long CorpID, long MonitorPointID, DateTime StartDay, int StartHour, DateTime EndDay, int EndHour)
        {
            if (StartDay.Date > EndDay.Date)
                return default;

            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorHourRecord>()
                        .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID)
                        .Where(x => (x.DataDay > StartDay.Date && x.DataDay < EndDay.Date)
                            || (x.DataDay == StartDay.Date && x.DataDay < EndDay.Date && x.DataHour >= StartHour)
                            || (x.DataDay == EndDay.Date && x.DataDay > StartDay.Date && x.DataHour <= EndHour)
                            || (x.DataDay == StartDay.Date && x.DataDay == EndDay.Date && x.DataHour >= StartHour && x.DataHour <= EndHour))
                        .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }

        #endregion

        #region 通过 SignalID 获取

        /// <summary>
        /// 通过 SignalID 获取
        /// </summary>
        public List<Entity.MonitorHourRecord> GetBySignalID(long CorpID, long MonitorPointID, long SignalID)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorHourRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.SignalID == SignalID)
                    .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }

        /// <summary>
        /// 通过 SignalID 获取某天的数据
        /// </summary>
        public List<Entity.MonitorHourRecord> GetBySignalIDOfDay(long CorpID, long MonitorPointID, long SignalID, DateTime Day)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorHourRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.SignalID == SignalID && x.DataDay == Day.Date)
                    .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }

        /// <summary>
        /// 通过 SignalID 获取某时的数据
        /// </summary>
        public Entity.MonitorHourRecord GetBySignalIDOfHour(long CorpID, long MonitorPointID, long SignalID, DateTime DataDay, int DataHour)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorHourRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.SignalID == SignalID)
                    .Where(x => x.DataDay == DataDay.Date && x.DataHour == DataHour)
                    .First();
            }
        }

        /// <summary>
        /// 通过 SignalID 获取日期区间的数据
        /// </summary>
        public List<Entity.MonitorHourRecord> GetBySignalIDOfDayRange(long CorpID, long MonitorPointID, long SignalID, DateTime StartDay, DateTime EndDay)
        {
            if (StartDay.Date > EndDay.Date)
                return default;
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorHourRecord>()
                        .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.SignalID == SignalID && x.DataDay >= StartDay.Date && x.DataDay <= EndDay.Date)
                        .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }

        /// <summary>
        /// 通过 SignalID 获取区间的数据
        /// </summary>
        public List<Entity.MonitorHourRecord> GetBySignalIDOfHourRange(long CorpID, long MonitorPointID, long SignalID, DateTime StartDay, int StartHour, DateTime EndDay, int EndHour)
        {
            if (StartDay.Date > EndDay.Date)
                return default;

            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorHourRecord>()
                        .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.SignalID == SignalID)
                        .Where(x => (x.DataDay > StartDay.Date && x.DataDay < EndDay.Date)
                            || (x.DataDay == StartDay.Date && x.DataDay < EndDay.Date && x.DataHour >= StartHour)
                            || (x.DataDay == EndDay.Date && x.DataDay > StartDay.Date && x.DataHour <= EndHour)
                            || (x.DataDay == StartDay.Date && x.DataDay == EndDay.Date && x.DataHour >= StartHour && x.DataHour <= EndHour))
                        .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }

        #endregion


        #region Delete

        /// <summary>
        /// 通过 SignalID 删除小时下的数据
        /// </summary>
        public bool DeleteBySignalIDOfHour(long CorpID, long MonitorPointID, long SignalID, DateTime DataDay, int DataHour)
        {
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Deleteable<Entity.MonitorHourRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.SignalID == SignalID)
                    .Where(x => x.DataDay == DataDay.Date && x.DataHour == DataHour)
                    .ExecuteCommand() > 0;
            }
        }

        /// <summary>
        /// 通过 SignalID 删除时区间的数据
        /// </summary>
        public bool DeleteBySignalIDOfHourRange(long CorpID, long MonitorPointID, long SignalID, DateTime StartDay, int StartHour, DateTime EndDay, int EndHour)
        {
            if (StartDay.Date > EndDay.Date)
                return false;

            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Deleteable<Entity.MonitorHourRecord>()
                        .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.SignalID == SignalID)
                        .Where(x => (x.DataDay > StartDay.Date && x.DataDay < EndDay.Date)
                            || (x.DataDay == StartDay.Date && x.DataDay < EndDay.Date && x.DataHour >= StartHour)
                            || (x.DataDay == EndDay.Date && x.DataDay > StartDay.Date && x.DataHour <= EndHour)
                            || (x.DataDay == StartDay.Date && x.DataDay == EndDay.Date && x.DataHour >= StartHour && x.DataHour <= EndHour))
                        .ExecuteCommand() > 0;
            }
        }


        #endregion


    }
}