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>
    /// 数据库访问基类
    /// </summary>
    /// <typeparam name="T">实体类类型</typeparam>
    public partial class CorpDAL<T> where T : Entity.CorpEntity,new()
    {

        /// <summary>
        /// 连接配置
        /// </summary>
        public virtual ConnectionConfig ConnectionConfig
        {
            get
            {
                return default;
            }
        }

        #region Insert

        /// <summary>
        /// 插入指定对象到数据库中
        /// </summary>
        public virtual long Insert(T entity)
        {
            if (entity == null)
                return default;
            if (entity.CorpID < 1)
                return default;
         
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Insertable(entity).ExecuteReturnSnowflakeId();
            }
        }

        /// <summary>
        /// 插入指定对象集合到数据库中
        /// </summary>
        public virtual bool Inserts(List<T> list)
        {
            if (list == null || list.Count < 1)
                return default;
            var corpIds = list.Select(x => x.CorpID).Distinct().ToList();
            if (corpIds.Count() != 1 || corpIds[0] < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Insertable(list).ExecuteReturnSnowflakeIdList().Count() > 0;
            }
        }

        /// <summary>
        /// 插入并返回
        /// </summary>
        public virtual List<long> InsertsR(List<T> list)
        {
            if (list == null || list.Count < 1)
                return default;
            var corpIds = list.Select(x => x.CorpID).Distinct().ToList();
            if (corpIds.Count() != 1 || corpIds[0] < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Insertable(list).ExecuteReturnSnowflakeIdList();
            }
        }

        /// <summary>
        /// 大批量插入
        /// </summary>
        public virtual bool BulkInserts(List<T> list)
        {
            if (list == null || list.Count < 1)
                return default;
            list.ForEach(x => x.ID = SnowFlakeSingle.instance.NextId());
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Fastest<T>().BulkCopy(list) > 0;
            }
        }

        #endregion

        #region Update

        /// <summary>
        /// 更新对象属性到数据库中
        /// </summary>
        public virtual bool Update(T entity)
        {
            if (entity == null)
                return default;
            if (entity.CorpID < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable(entity).IgnoreColumns(it => new { it.CorpID }).ExecuteCommand() > 0;
            }
        }

        /// <summary>
        /// 更新部分
        /// </summary>
        public virtual bool UpdatePart(T entity, List<string> pros)
        {
            if (entity == null)
                return default;
            if (entity.CorpID < 1)
                return default;
            if (pros == null || pros.Count < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable(entity).UpdateColumns(pros.ToArray()).ExecuteCommand() > 0;
            }
        }

        /// <summary>
        /// 更新指定对象集合到数据库中
        /// </summary>
        public virtual bool Updates(List<T> list)
        {
            if (list == null || list.Count < 1)
                return default;
            var corpIds = list.Select(x => x.CorpID).Distinct().ToList();
            if (corpIds.Count() != 1 || corpIds[0] < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable(list).IgnoreColumns(it => new {  it.CorpID }).ExecuteCommand() > 0;
            }
        }

        /// <summary>
        /// 批量更新部分
        /// </summary>
        public virtual bool UpdatesPart(List<T> list, List<string> pros)
        {
            if (list == null || list.Count < 1)
                return default;
            var corpIds = list.Select(x => x.CorpID).Distinct().ToList();
            if (corpIds.Count() != 1 || corpIds[0] < 1)
                return default;
            if (pros == null || pros.Count < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable(list).UpdateColumns(pros.ToArray()).ExecuteCommand() > 0;
            }
        }

        /// <summary>
        /// 大批量更新
        /// </summary>
        public virtual bool BulkUpdates(List<T> list)
        {
            if (list == null || list.Count < 1)
                return default;
            var corpIds = list.Select(x => x.CorpID).Distinct().ToList();
            if (corpIds.Count() != 1 || corpIds[0] < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Fastest<T>().BulkUpdate(list) > 0;
            }
        }

        #endregion

        #region Delete

        /// <summary>
        /// 从数据库中删除指定对象
        /// </summary>
        public virtual bool Delete(T entity)
        {
            if (entity == null)
                return default;
            if (entity.ID < 1)
                return default;
            if (entity.CorpID < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Deleteable<T>().Where(entity).ExecuteCommand() > 0;
            }
        }

        /// <summary>
        /// 从数据库中删除指定对象集合
        /// </summary>
        public virtual bool Deletes(List<T> list)
        {
            if (list == null || list.Count < 1)
                return default;
            if (list.Exists(x => x.ID < 1))
                return default;
            var corpIds = list.Select(x => x.CorpID).Distinct().ToList();
            if (corpIds.Count() != 1 || corpIds[0] < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Deleteable<T>().Where(list).ExecuteCommand() > 0;
            }
        }

        /// <summary>
        /// 根据指定对象的ID,从数据库中删除指定对象
        /// </summary>
        public virtual bool DeleteByID(long CorpID, long ID)
        {
            if (ID < 1)
                return default;
            if (CorpID < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Deleteable<T>().Where(x =>x.CorpID==CorpID&&x.ID == ID).ExecuteCommand() > 0;
            }
        }

        /// <summary>
        /// 通过id列表删除
        /// </summary>
        public virtual bool DeleteByIds(long CorpID, List<long> ids)
        {
            if (ids == null || ids.Count < 1)
                return default;
            if (CorpID < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Deleteable<T>().Where(x =>x.CorpID==CorpID&&ids.Contains(x.ID)).ExecuteCommand() > 0;
            }
        }

        /// <summary>
        /// 通过 CorpID 删除
        /// </summary>
        public virtual bool DeleteByCorpID(long CorpID)
        {
            if (CorpID < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Deleteable<T>().Where(x => x.CorpID == CorpID).ExecuteCommand() > 0;
            }
        }

        /// <summary>
        /// 通过 CorpIds 列表删除
        /// </summary>
        public virtual bool DeleteByCorpIds(List<long> CorpIds)
        {
            if (CorpIds == null || CorpIds.Count() < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Deleteable<T>().Where(x => CorpIds.Contains(x.CorpID)).ExecuteCommand() > 0;
            }
        }

        /// <summary>
        /// 从数据库中删除所有对象
        /// </summary>
        public virtual bool DeleteAll()
        {
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.DbMaintenance.TruncateTable<T>();
            }
        }



        #endregion

        #region Query

        /// <summary>
        /// 返回数据库所有的对象集合
        /// </summary>
        public virtual List<T> GetAll()
        {
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<T>().ToList();
            }
        }

        /// <summary>
        /// 查询数据库,返回指定ID的对象
        /// </summary>
        public virtual T GetByID(long CorpID, long id)
        {
            if (CorpID < 1)
                return default;
            if (id < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<T>().First(x=>x.CorpID==CorpID&&x.ID==id);
            }
        }

        /// <summary>
        /// 通拓id列表获取
        /// </summary>
        /// <returns></returns>
        public virtual List<T> GetByIds(long CorpID, List<long> ids)
        {
            if (ids == null || ids.Count < 1)
                return default;
            if (CorpID < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<T>().OrderBy(x => x.ID).Where(x =>x.CorpID==CorpID&&ids.Contains(x.ID)).ToList();
            }
        }

        /// <summary>
        /// 通过 CorpID 获取
        /// </summary>
        public virtual List<T> GetByCorpID(long CorpID)
        {
            if (CorpID < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<T>().Where(x => x.CorpID == CorpID).ToList();
            }
        }

        /// <summary>
        /// 通过 CorpID 获取
        /// </summary>
        public virtual List<T> GetByCorpIds(List<long> CorpIds)
        {
            if (CorpIds == null || CorpIds.Count < 1)
                return default;
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<T>().Where(x => CorpIds.Contains(x.CorpID)).ToList();
            }
        }

        #endregion



    }
}