Master.CanYinWu.Utility/Infrastructure/ConnectionFactory.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System.Configuration;
using System.Data;
using System.Data.SqlClient;
namespace Master.CanYinWu.Utility
{
  public  class ConnectionFactory
    {
        private static readonly string ConnString = ConfigurationManager.ConnectionStrings["MSSQL_ItemDB"].ConnectionString;
        public static IDbConnection Connection()
        {
            IDbConnection connection = new SqlConnection(ConnString);
            if (connection.State==ConnectionState.Closed)
            {
                connection.Open();
            }      
            return connection;
        }


        #region  后面业务需要加的回滚方法
        public IDbConnection DbConnection { get; private set; }

        public IDbTransaction DbTransaction { get; private set; }

        public ConnectionFactory()
        {
            this.DbConnection = new SqlConnection(ConnString);
        }

        public  void BeginTrans()
        {
            if (this.DbConnection.State == ConnectionState.Closed)
            {
                this.DbConnection.Open();
            }
            this.DbTransaction = this.DbConnection.BeginTransaction();
        }

        public void CommitTrans()
        {
            this.DbTransaction.Commit();
            this.DbConnection.Close();
            this.DbTransaction.Dispose();
            this.DbTransaction = null;
        }

        public void RollbackTrans()
        {
            this.DbTransaction.Rollback();
            if (this.DbConnection.State == ConnectionState.Open)
            {
                this.DbConnection.Close();
            }
            this.DbTransaction.Dispose();
            this.DbTransaction = null;
        }
        #endregion