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