using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;

namespace TProduct.DAL
{
    public class TestProjectItemView
    {
        /// <summary>
        /// 
        /// </summary>
        public ISqlSugarClient Connection
        {
            get { return TProduct.DAL.SQLite.ConfigHelper.MainConn; }
        }
        /// <summary>
        /// 通拓id列表获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetByProjectID(long ProjectID)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>().Where(x => x.ProjectID == ProjectID)?.ToList();
            }
        }

        /// <summary>
        /// 通拓id列表获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetByProjectID(IEnumerable<long> ProjectID)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>().Where(x => ProjectID.Contains(x.ProjectID))?.ToList();
            }
        }
        /// <summary>
        /// 通过时间获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetByCreateTime(DateTime StartTime, DateTime EndTime)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>().Where(x =>
                x.ProjectCreateTime >= StartTime
                && x.ProjectCreateTime <= EndTime)?.ToList();
            }
        }

        /// <summary>
        /// 通过时间获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetAll( )
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>()?.ToList();
            }
        }
        /// <summary>
        /// 通过时间获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetByCreateTime(
            int TestType,
            DateTime StartTime,
            DateTime EndTime)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>().Where(x =>
                x.TestType == TestType &&
                x.ProjectCreateTime >= StartTime
                && x.ProjectCreateTime <= EndTime)?.ToList();
            }
        }
        /// <summary>
        /// 通过时间获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetByCreateTimePointNumber(
            int TestType,
            int PointNumber,
            DateTime StartTime,
            DateTime EndTime)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>().Where(x =>
                x.TestType == TestType &&
                x.PointNumber > PointNumber &&
                x.ProjectCreateTime >= StartTime
                && x.ProjectCreateTime <= EndTime)?.ToList();
            }
        }
        /// <summary>
        /// 通拓id列表获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetByProductType(int ProductType, List<long> ProductID, DateTime StartTime, DateTime EndTime)
        {
            if (ProductID == null || ProductID.Count() == 0)
            {
                return GetByProductType(ProductType, StartTime, EndTime);
            }
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x =>
                x.ProductType == ProductType
                && ProductID.Contains(x.ProductID)
                && x.ProjectCreateTime >= StartTime
                && x.ProjectCreateTime <= EndTime)?.ToList();
            }
        }

        /// <summary>
        /// 通拓id列表获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetByProductType(int ProductType, DateTime StartTime, DateTime EndTime)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x =>
                x.ProductType == ProductType
                && x.ProjectCreateTime >= StartTime
                && x.ProjectCreateTime <= EndTime)?.ToList();
            }
        }

        /// <summary>
        /// 通拓id列表获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetBySeriesID(long SeriesID)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x => x.SeriesID == SeriesID)?.ToList();
            }
        }

        /// <summary>
        /// 通拓id列表获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetByProductID(long ProductID)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x => x.ProductID == ProductID)?.ToList();
            }
        }
        /// <summary>
        /// 通拓id列表获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetByPartID(long PartID)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x => x.PartID == PartID)?.ToList();
            }
        }

        /// <summary>
        /// 通拓id列表获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetByPartID(long PartID,
            DateTime StartTime,
            int MinPtCount)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x => x.PartID == PartID && x.ProjectCreateTime > StartTime && x.PointNumber > MinPtCount)?.ToList();
            }
        }

        /// <summary>
        /// 通拓id列表获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetByPartID(List<long> PartID,
            DateTime StartTime,
            int MinPtCount)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x => PartID.Contains(x.PartID) && x.ProjectCreateTime > StartTime && x.PointNumber > MinPtCount)?.ToList();
            }
        }
        /// <summary>
        /// 通拓id列表获取
        /// </summary>
        /// <returns></returns>
        public List<Entity.TestProjectItemView> GetByPartID(IEnumerable<long> PartID)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x => PartID.Contains(x.PartID))?.ToList();
            }
        }
    }
}