g.hnyhua.cn/Mtxfw.Utility/DbHelperSqlSugar.cs

using SqlSugar;

namespace Mtxfw.Utility
{
    public class DbHelperSqlSugar
    {
        /// <summary>
        /// 当前上下文操作对象
        /// </summary>
        // public SqlSugarClient db = null;
        public DbHelperSqlSugar()
        {
            // db = GetInstance();
        }
        public static string ConnectionString
        {
            get
            {
                string reval = DbConnection.connectionString;
                return reval;
            }
        }
        public SqlSugarClient Db => GetInstance();

        public void BeginTran()
        {
            Db.Ado.BeginTran();
        }
        public void CommitTran()
        {
            Db.Ado.CommitTran();
        }
        public void RollbackTran()
        {
            Db.Ado.RollbackTran();
        }
        private static SqlSugarClient GetInstance()
        {
            SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
            {
                ConnectionString = DbConnection.connectionString,
                DbType = DbType.SqlServer,
                IsAutoCloseConnection = true,
                //IsShardSameThread = true //设为true相同线程是同一个SqlSugarClient
            });
            db.Ado.IsEnableLogEvent = true;
            db.Aop.OnLogExecuted = (sql, pars) =>
            {
                //Console.WriteLine(sql + "\r\n" + db.RewritableMethods.SerializeObject(pars));
                //Console.WriteLine();
            };
            return db;
        }
    }
}