/// <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;
}
}
