using SqlSugar;
using System;
using System.Linq;

namespace HL_FristAidPlatform_Help
{
    public class BaseDB
    {
        public static SqlSugarClient GetClient()
        {
            try
            {
                string ConnStr = BaseDBConfig.GetConfig("ConnectionStrings:DB");
                SqlSugarClient db = new SqlSugarClient(
                    new ConnectionConfig()
                    {
                        ConnectionString = ConnStr,
                        DbType = DbType.SqlServer,
                        IsAutoCloseConnection = true,//自动释放数据务，如果存在事务，在事务结束后释放
                        InitKeyType = InitKeyType.Attribute//从实体特性中读取主键自增列信息
                    }
                );
                db.Aop.OnLogExecuting = (sql, pars) =>
                {
                    string sqlText = sql + "\r\n" + db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value));
                    Console.WriteLine(sql + "\r\n" + db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value)));
                    Console.WriteLine();
                };
                return db;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }
}