public void SetAutoCommit(System.Data.OleDb.OleDbConnection connection, bool boolean)
{
if (this[connection] != null)
{
ConnectionProperties Properties = ((ConnectionProperties)this[connection]);
Properties.AutoCommit = boolean;
if (!boolean)
{
System.Data.OleDb.OleDbTransaction transaction = Properties.Transaction;
if (Properties.TransactionLevel == 0)
{
transaction = connection.BeginTransaction();
}
else
{
transaction = connection.BeginTransaction(Properties.TransactionLevel);
}
}
}
else
{
ConnectionProperties TempProp = new ConnectionProperties();
TempProp.AutoCommit = boolean;
TempProp.TransactionLevel = 0;
if (boolean)
{
TempProp.Transaction = connection.BeginTransaction();
}
Add(connection, TempProp);
}
}
protected override void DataAdapterUpdate(System.Data.DataSet tabela, string strNomeTabela)
{
if (m_bUserCanUpdateDB)
{
OpenConnection();
if (m_Connection.State == System.Data.ConnectionState.Open)
{
if (tabela.GetChanges() != null)
{
m_Transaction = m_Connection.BeginTransaction();
m_CommandSelect.Transaction = m_Transaction;
try
{
m_DataAdapter.Update(tabela, strNomeTabela);
m_Transaction.Commit();
DataPersist = false;
}
catch (System.Exception eEcp)
{
m_excError = eEcp;
m_excError.Source = strNomeTabela;
m_Transaction.Rollback();
ShowDialogUpdateError(strNomeTabela);
}
}
}
CloseConnection();
}
}
public void RollBack(System.Data.OleDb.OleDbConnection connection)
{
if (this[connection] != null && ((ConnectionProperties)this[connection]).AutoCommit)
{
System.Data.OleDb.OleDbTransaction transaction = ((ConnectionProperties)this[connection]).Transaction;
transaction.Rollback();
}
}
/// <summary>
/// سازنده کلاس
/// </summary>
/// <param name="connection">کانکشن</param>
/// <param name="transaction">تراکنش</param>
public OleDataAccess(System.Data.OleDb.OleDbConnection connection, System.Data.OleDb.OleDbTransaction transaction)
{
this._Connection = connection;
this._Command = new System.Data.OleDb.OleDbCommand();
this._Command.Connection = this._Connection;
this._Adapter = new System.Data.OleDb.OleDbDataAdapter();
this._Adapter.SelectCommand = new System.Data.OleDb.OleDbCommand();
this._Adapter.SelectCommand.Connection = this._Connection;
this.Transaction = transaction;
}
public static void DBLogOut(UpdateLog[] logDatas)
{
if (System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"] == null)
{
return;
}
string connString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].Trim();
connString = BenQGuru.eMES.Common.Helper.EncryptionHelper.DESDecryption(connString);
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connString);
System.Data.OleDb.OleDbTransaction trans = null;
try
{
conn.Open();
System.Data.OleDb.OleDbCommand comm = conn.CreateCommand();
trans = conn.BeginTransaction();
comm.Transaction = trans;
foreach (UpdateLog log in logDatas)
{
string updateSQL = "INSERT INTO TBLUPDATELOG "
+ " (UPDATELOGID,FILENAME,VERSION,MACHINENAME,MACHINEIP,UPDATETIME,RESULT)"
+ " values ('" + log.PKID + "'"
+ " ,'" + log.FileName + "'"
+ " ,'" + log.Version + "'"
+ " ,'" + log.MachineName + "'"
+ " ,'" + log.MachineIP + "'"
+ " ,'" + log.UpdateTime + "'"
+ " ,'" + log.Result + "')";
comm.CommandText = updateSQL;
comm.CommandType = System.Data.CommandType.Text;
comm.ExecuteNonQuery();
}
trans.Commit();
}
catch (Exception ex)
{
if (trans != null)
{
trans.Rollback();
}
}
finally
{
conn.Close();
}
}
public static void DeshacerTransaccion()
{
if (transaccion != null)
try
{
transaccion.Rollback();
}
catch (System.Exception)
{
}
finally
{
transaccion = null;
Desconectar();
}
}
public static void EmpezarTransaccion()
{
Conectar();
if (transaccion != null)
{
return;
}
try
{
transaccion = cnx.BeginTransaction();
}
catch (System.Exception ex)
{
transaccion = null;
throw new System.Exception("Conexion: Error al empezar la transacci�n.", ex);
}
}
public static void ConfirmarTransaccion()
{
if (transaccion == null)
throw new System.Exception("Conexion: Error al confirmar la transacci�n.");
try
{
transaccion.Commit();
}
catch (System.Exception ex)
{
throw new System.Exception("Conexion: Error al confirmar la transacci�n.", ex);
}
finally
{
transaccion = null;
Desconectar();
}
}
public static void EmpezarTransaccion()
{
Conectar();
if (transaccion != null)
return;
try
{
transaccion = cnx.BeginTransaction();
}
catch (System.Exception ex)
{
transaccion = null;
throw new System.Exception("Conexion: Error al empezar la transacci�n.", ex);
}
}
public OleDbCommand(string cmdText, System.Data.OleDb.OleDbConnection connection, System.Data.OleDb.OleDbTransaction transaction)
{
}
