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 MonitorYearRecord : CorpDAL<Entity.MonitorYearRecord>
    {
        /// <summary>
        /// 
        /// </summary>
        public override ConnectionConfig ConnectionConfig
        {
            get { return ConfigHelper.MonitorRecordConnectionConfig; }
        }

        #region 通过 MonitorPointID 获取

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

        /// <summary>
        /// 通过 MonitorPointID 获取某年的数据
        /// </summary>
        public List<Entity.MonitorYearRecord> GetByMonitorPointIDOfYear(long CorpID, long MonitorPointID, int Year)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorYearRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID)
                    .Where(x => x.DataYear == Year)
                    .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }

        /// <summary>
        /// 通过 MonitorPointID 获取年区间的数据
        /// </summary>
        public List<Entity.MonitorYearRecord> GetByMonitorPointIDOfYearRange(long CorpID, long MonitorPointID, int StartYear, int EndYear)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorYearRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID)
                    .Where(x => x.DataYear >= StartYear && x.DataYear <= EndYear)
                    .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }

        #endregion

        #region 通过 SignalID 获取

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

        /// <summary>
        /// 通过 SignalID 获取某年的数据
        /// </summary>
        public Entity.MonitorYearRecord GetBySignalIDOfYear(long CorpID, long MonitorPointID, long SignalID, int Year)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorYearRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.SignalID == SignalID)
                    .Where(x => x.DataYear == Year)
                    .First();
            }
        }

        /// <summary>
        /// 通过 SignalID 获取年区间的数据
        /// </summary>
        public List<Entity.MonitorYearRecord> GetBySignalIDOfYearRange(long CorpID, long MonitorPointID, long SignalID, int StartYear, int EndYear)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.MonitorYearRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.SignalID == SignalID)
                    .Where(x => x.DataYear >= StartYear && x.DataYear <= EndYear)
                    .OrderBy(x => x.DataTime, OrderByType.Asc).ToList();
            }
        }

        #endregion

        #region Delete

        /// <summary>
        /// 通过 SignalID 删除某年的数据
        /// </summary>
        public bool DeleteBySignalIDOfYear(long CorpID, long MonitorPointID, long SignalID, int Year)
        {
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Deleteable<Entity.MonitorYearRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.SignalID == SignalID)
                    .Where(x => x.DataYear == Year)
                    .ExecuteCommand() > 0;
            }
        }

        /// <summary>
        /// 通过 SignalID 删除年区间的数据
        /// </summary>
        public bool DeleteBySignalIDOfYearRange(long CorpID, long MonitorPointID, long SignalID, int StartYear, int EndYear)
        {
            if (StartYear > EndYear) 
                return false;

            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Deleteable<Entity.MonitorYearRecord>()
                    .Where(x => x.CorpID == CorpID && x.MonitorPointID == MonitorPointID && x.SignalID == SignalID)
                    .Where(x => x.DataYear>=StartYear&&x.DataYear<=EndYear)
                    .ExecuteCommand() > 0;
            }
        }

        #endregion




    }
}