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



namespace IStation.DAL
{
    /// <summary>
    /// MsSqlDAL RepairRequestFile
    /// </summary>
    public partial class ProductInspectionTemplateValue : BaseDAL<Entity.ProductInspectionTemplateValue>
    {
        /// <summary>
        /// 
        /// </summary>
        public override ConnectionConfig ConnectionConfig
        {
            get
            {
                return ConfigHelper.DefaultConnectionConfig;
            }
        }
        /// <summary>
        /// 插入指定对象到数据库中
        /// </summary>
        public override long Insert(Entity.ProductInspectionTemplateValue entity)
        {
            if (entity == null)
                return default;
            if (entity.ItemID < 1)
                return default;
            entity.CreateTime = DateTime.Now;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Insertable(entity).ExecuteReturnSnowflakeId();
            }
        }

        /// <summary>
        /// 插入指定对象集合到数据库中
        /// </summary>
        public override bool Inserts(List<Entity.ProductInspectionTemplateValue> list)
        {
            if (list == null || list.Count < 1)
                return default;
            var dt = DateTime.Now;
            foreach (var item in list)
                item.CreateTime = dt;
 
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Insertable(list).ExecuteReturnSnowflakeIdList().Count() > 0;
            }
        }

        /// <summary>
        /// 插入并返回
        /// </summary>
        public override List<long> InsertsR(List<Entity.ProductInspectionTemplateValue> list)
        {
            if (list == null || list.Count < 1)
                return default;
            var dt = DateTime.Now;
            foreach (var item in list)
                item.CreateTime = dt;
 
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Insertable(list).ExecuteReturnSnowflakeIdList();
            }
        }

        /// <summary>
        /// 更新对象属性到数据库中
        /// </summary>
        public override bool Update(Entity.ProductInspectionTemplateValue entity)
        {
            if (entity == null)
                return default;
            if (entity.ItemID < 1)
                return default;
            entity.UpdateTime = DateTime.Now;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable(entity).IgnoreColumns(it => new { it.CreateTime, it.CreateUserID, it.ItemID }).ExecuteCommand() > 0;
            }
        }
        /// <summary>
        /// 更新使用状态
        /// </summary>
        public virtual bool UpdateUseStatus(  long ID, int UseStatus, long UpdateUserID, DateTime UpdateTime)
        {
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable<Entity.ProductInspectionTemplateValue>()
                    .SetColumns(x => x.UseStatus == UseStatus)
                    .SetColumns(x => x.UpdateUserID == UpdateUserID)
                    .SetColumns(x => x.UpdateTime == UpdateTime)
                    .Where(x =>  x.ID == ID)
                    .ExecuteCommandHasChange();
            }
        }
        /// <summary>
        /// 更新指定对象集合到数据库中
        /// </summary>
        public override bool Updates(List<Entity.ProductInspectionTemplateValue> list)
        {
            if (list == null || list.Count < 1)
                return default;
            foreach(var item in list)
                item.UpdateTime = DateTime.Now;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable(list).IgnoreColumns(it => new { it.CreateTime, it.CreateUserID, it.ItemID }).ExecuteCommand() > 0;
            }
        }

        /// <summary>
        /// 通过ItemID获取
        /// </summary>
        /// <param name="ItemID"></param>
        /// <returns></returns>
        public List<Entity.ProductInspectionTemplateValue> GetByItemID(IEnumerable<long> ItemID)
        {
            if (ItemID == null || ItemID.Count() == 0)
                return null;

            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.ProductInspectionTemplateValue>()
                    .Where(x => ItemID.Contains(x.ItemID)).ToList();
            }
        }



        /// <summary>
        /// ItemID
        /// </summary>
        /// <param name="ItemID"></param>
        /// <returns></returns>
        public List<Entity.ProductInspectionTemplateValue> GetByItemID(long ItemID)
        {

            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.ProductInspectionTemplateValue>()
                    .Where(x => ItemID == x.ItemID).ToList();
            }
        }


        /// <summary>
        /// 更新排序
        /// </summary>
        public virtual bool UpdateSortCode(long CorpID, long ID, int SortCode, long UpdateUserID, DateTime UpdateTime)
        {
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable<Entity.ProductInspectionTemplateValue>()
                    .SetColumns(x => x.SortCode == SortCode)
                    .SetColumns(x => x.UpdateUserID == UpdateUserID)
                    .SetColumns(x => x.UpdateTime == UpdateTime)
                    .Where(x =>   x.ID == ID)
                    .ExecuteCommandHasChange();
            }
        }
        /// <summary>
        /// 更新排序
        /// </summary>
        public virtual bool UpdateSorter(long CorpID, List<Entity.TraceSorter> Sorters)
        {
            if (Sorters == null || Sorters.Count() < 1)
                return default;
            if (Sorters.Exists(x => x.ID < 1))
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable<Entity.ProductInspectionTemplateValue>(Sorters)
                    .UpdateColumns(nameof(Entity.ISorter.SortCode), nameof(Entity.TraceSorter.UpdateUserID), nameof(Entity.TraceSorter.UpdateTime)) 
                    .ExecuteCommandHasChange();
            }
        }
    }
}