/// <summary> /// 关闭连接 清除事务占用的资源 /// </summary> private void ReleaseTransaction() { if (TransConnectionObj == null) { return; } DbConnection conn = TransConnectionObj.DBTransaction.Connection; TransConnectionObj.DBTransaction.Dispose(); TransConnectionObj = null; DisposeConn(conn); }
//#region ExecutePaging //public DataTable ExecutePagingDataTable(CommandType cmdType,string tableName, string cmdText, int pageIndex, int pageSize, string orderInfo, params DbParameter[] parameterValues) //{ // StDbQueryParameter q=new StDbQueryParameter(tableName,) // cmdText = StDbSqlFunction.GetQuerySql(DbType, null); // //cmdText = DBClient.GetPagingSql(cmdText, pageIndex, pageSize, orderInfo); // return ExecuteDataTable(CommandType.Text, cmdText, parameterValues); //} //public DbDataReader ExecutePagingReader(CommandType cmdType, string cmdText, int pageIndex, int pageSize, string orderInfo, params DbParameter[] parameterValues) //{ // cmdText = DBClient.GetPagingSql(cmdText, pageIndex, pageSize, orderInfo); // return ExecuteReader(CommandType.Text, cmdText, parameterValues); //} //#endregion #region Transaction /// <summary> /// 开始该帮助类创建的事务 /// </summary> public void BeginTransaction() { if (TransConnectionObj == null) { DbConnection conn = _dbDriveType.CreateDbConnection(_connectionString); OpenConn(conn); DbTransaction trans = conn.BeginTransaction(); TransConnectionObj = new TransConnection(); TransConnectionObj.DBTransaction = trans; } else { TransConnectionObj.Deeps += 1; } }