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

namespace TProduct.DAL
{
    /// <summary>
    /// 数据库访问基类
    /// </summary>
    /// <typeparam name="T">实体类类型</typeparam>
    public partial class BaseLiteSqlDAL<T> where T : Entity.BaseEntity, new()
    {
        /// <summary>
        /// ID 
        /// </summary>
        protected const string IDKey = "id";

        /// <summary>
        /// 构造函数
        /// </summary>
        public BaseLiteSqlDAL()
        {
            this.TableName = EntityHelper.GetTableName<T>();
        }

        /// <summary>
        /// 对象的表名
        /// </summary>
        public virtual string TableName { get; set; }

        /// <summary>
        /// 数据库连接
        /// </summary>
        public virtual ISqlSugarClient Connection
        {
            get
            {
                var connection = ConnectionFactory.CreateConnection<T>();
                return connection;
            }
        }

        #region Insert

        /// <summary>
        /// 插入指定对象到数据库中
        /// </summary>
        public virtual long Insert(T entity)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Insertable(entity).ExecuteReturnSnowflakeId();
            }
        }

        /// <summary>
        /// 插入指定对象集合到数据库中
        /// </summary>
        public virtual bool Inserts(List<T> list)
        {
            using (ISqlSugarClient db = Connection)
            {
                try
                {
                    db.Ado.BeginTran();
                    var snowflakeIds = db.Insertable(list).ExecuteReturnSnowflakeIdList();
                    if (snowflakeIds.Count < list.Count)
                    {
                        db.Ado.RollbackTran();
                        return default;
                    }
                    if (snowflakeIds == null || snowflakeIds.Count < 1)
                    {
                        db.Ado.RollbackTran();
                        return default;
                    }
                    db.Ado.CommitTran();
                    return true;
                }
                catch
                {
                    db.Ado.RollbackTran();
                    throw;
                }
            }
        }

        /// <summary>
        /// 插入并返回
        /// </summary>
        public virtual List<long> InsertsR(List<T> list)
        {
            if (list == null || list.Count() < 1)
                return default;
            using (ISqlSugarClient db = Connection)
            {
                try
                {
                    db.Ado.BeginTran();
                    var snowflakeIds = db.Insertable(list).ExecuteReturnSnowflakeIdList();
                    if (snowflakeIds.Count < list.Count)
                    {
                        db.Ado.RollbackTran();
                        return default;
                    }
                    if (snowflakeIds == null || snowflakeIds.Count < 1)
                    {
                        db.Ado.RollbackTran();
                        return default;
                    }
                    db.Ado.CommitTran();
                    return snowflakeIds;
                }
                catch
                {
                    db.Ado.RollbackTran();
                    throw;
                }
            }
        }

        #endregion

        #region Update

        /// <summary>
        /// 更新对象属性到数据库中
        /// </summary>
        public virtual bool Update(T entity)
        {
            using (ISqlSugarClient db = Connection)
            {
                var result = db.Updateable(entity).ExecuteCommandHasChange();
                return result;
            }
        }

        /// <summary>
        /// 更新部分
        /// </summary>
        public virtual bool UpdatePart(T entity, List<string> pros)
        {
            using (ISqlSugarClient db = Connection)
            {
                var result = db.Updateable(entity).UpdateColumns(pros.ToArray()).ExecuteCommandHasChange();//更新单 条根据ID
                return result;
            }
        }

        /// <summary>
        /// 更新指定对象集合到数据库中
        /// </summary>
        public virtual bool Updates(List<T> list)
        {
            using (ISqlSugarClient db = Connection)
            {
                try
                {
                    db.Ado.BeginTran();
                    var result = db.Updateable(list).ExecuteCommandHasChange();
                    db.Ado.CommitTran();
                    return result;
                }
                catch
                {
                    db.Ado.RollbackTran();
                    throw;
                }
            }
        }

        /// <summary>
        /// 批量更新部分
        /// </summary>
        public virtual bool UpdatesPart(List<T> list, List<string> pros)
        {
            using (ISqlSugarClient db = Connection)
            {
                try
                {
                    db.Ado.BeginTran();
                    var result = db.Updateable(list).UpdateColumns(pros.ToArray()).ExecuteCommandHasChange();
                    db.Ado.CommitTran();
                    return result;
                }
                catch
                {
                    db.Ado.RollbackTran();
                    throw;
                }
            }
        }

        #endregion

        #region Delete

        /// <summary>
        /// 从数据库中删除指定对象
        /// </summary>
        public virtual bool Delete(T entity)
        {
            using (ISqlSugarClient db = Connection)
            {
                var result = db.Deleteable(entity).ExecuteCommand();
                return true;
            }
        }

        /// <summary>
        /// 从数据库中删除指定对象集合
        /// </summary>
        public virtual bool Deletes(List<T> list)
        {
            using (ISqlSugarClient db = Connection)
            {
                try
                {
                    db.Ado.BeginTran();
                    var result = db.Deleteable(list).ExecuteCommand();
                    db.Ado.CommitTran();
                    return true;
                }
                catch
                {
                    db.Ado.RollbackTran();
                    throw;
                }
            }
        }

        /// <summary>
        /// 根据指定对象的ID,从数据库中删除指定对象
        /// </summary>
        public virtual bool DeleteByID(long ID)
        {
            using (ISqlSugarClient db = Connection)
            {
                var result = db.Deleteable<T>(ID).ExecuteCommandHasChange();
                return result;
            }
        }

        /// <summary>
        /// 通过id列表删除
        /// </summary>
        public virtual bool DeleteByIds(List<long> ids)
        {
            using (ISqlSugarClient db = Connection)
            {
                try
                {
                    db.Ado.BeginTran();
                    var result = db.Deleteable<T>(ids).ExecuteCommandHasChange(); //批量删除
                    db.Ado.CommitTran();
                    return result;
                }
                catch
                {
                    db.Ado.RollbackTran();
                    throw;
                }
            }
        }

        /// <summary>
        /// 从数据库中删除所有对象
        /// </summary>
        public virtual bool DeleteAll()
        {
            using (ISqlSugarClient db = Connection)
            {
                try
                {
                    db.Ado.BeginTran();
                    var result = db.Deleteable<T>().ExecuteCommandHasChange();
                    db.Ado.CommitTran();
                    return result;
                }
                catch
                {
                    db.Ado.RollbackTran();
                    throw;
                }
            }
        }
        #endregion

        #region Query

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

        /// <summary>
        /// 查询数据库,返回指定ID的对象
        /// </summary>
        public virtual T GetByID(long id)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<T>().Single(x => x.ID == id);
            }
        }

        /// <summary>
        /// 通拓id列表获取
        /// </summary>
        /// <returns></returns>
        public virtual List<T> GetByIds(List<long> ids)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<T>().Where(x => ids.Contains(x.ID))?.ToList();
            }
        }

        #endregion

        #region Count

        /// <summary>
        /// 获取数量
        /// </summary>
        public virtual long GetCount()
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.Queryable<T>().Count();
            }
        }

        #endregion

        #region 分页数据

        /// <summary>
        ///  分页获取数据
        /// </summary>
        public virtual List<T> GetPageList(int PageIndex, int PageSize, ref int Total)
        {
            using (var conn = Connection)
            {
                int skip = 1;
                if (PageIndex > 0)
                {
                    skip = (PageIndex - 1) * PageSize + 1;
                }
                using (ISqlSugarClient db = Connection)
                {
                    var page = db.Queryable<T>().ToPageList(PageIndex, PageSize, ref Total);
                    return page;
                }
            }
        }
        #endregion


        /// <summary>
        /// 表是否存在
        /// </summary>
        /// <returns></returns>
        public bool IsExistTable()
        {
            using (ISqlSugarClient db = Connection)
            {
                //怎么获取sqlsugar实体类中的表名
                //((SugarTable<T>)).TableName;
                return db.DbMaintenance.IsAnyTable(this.TableName);
            }
        }
        /// <summary>
        /// 列是否存在
        /// </summary>
        /// <param name="TableName"></param>
        /// <returns></returns>
        public bool IsExistColumn(string columnName)
        {
            using (ISqlSugarClient db = Connection)
            {
                return db.DbMaintenance.IsAnyColumn(this.TableName, columnName);
            }
        }




    }
}