/// <summary>
/// Libera todos os recursos utilizado na transações
/// </summary>
public void Dispose()
{
SqlCommand.Parameters.Clear();
SqlCommand.Dispose();
SqlCommand.Connection.Close();
if (SqlTran != null)
{
SqlTran.Dispose();
SqlTran = null;
}
}
/// <summary>
/// 事务回滚
/// </summary>
public void RollBack()
{
try
{
SqlTran.Rollback();
SqlTransactionFlag = false;
}
catch (Exception ex)
{
throw ex;
}
finally
{
SqlCon.Close();
SqlCon.Dispose();
}
}
/// <summary>
/// 提交事务
/// </summary>
public void Commit()
{
try
{
if (SqlTran != null)
{
SqlTran.Commit();
SqlTransactionFlag = false;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
SqlCon.Close();
SqlCon.Dispose();
}
}
