public void ExecuteNonQuery(List <string> commandTexts)
{
using (AccessPoolManager.AccessPool pool = AccessPoolManager.Instance(this.connectionString))
{
using (OleDbTransaction transaction = pool.Connection.BeginTransaction())
{
using (OleDbCommand command = new OleDbCommand())
{
try
{
command.Connection = pool.Connection;
command.Transaction = transaction;
foreach (string str in commandTexts)
{
command.CommandText = str;
command.ExecuteNonQuery();
}
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
}
}
}
}
public OleDbDataReader ExecuteReader(string commandText, OleDbParameter[] pt)
{
AccessPoolManager.AccessPool pool = AccessPoolManager.Instance(this.connectionString);
using (OleDbCommand command = new OleDbCommand(commandText, pool.Connection))
{
if (pt != null)
{
command.Parameters.AddRange(pt);
}
return(command.ExecuteReader(CommandBehavior.CloseConnection));
}
}
public void ExecuteNonQuery(string commandText, OleDbParameter[] pt)
{
using (AccessPoolManager.AccessPool pool = AccessPoolManager.Instance(this.connectionString))
{
using (OleDbCommand command = new OleDbCommand(commandText, pool.Connection))
{
if (pt != null)
{
command.Parameters.AddRange(pt);
}
command.ExecuteNonQuery();
}
}
}
public void Dispose()
{
if (AccessPoolManager.pools.ContainsKey(this.id) && (AccessPoolManager.pools[this.id] != null))
{
AccessPoolManager.AccessPool pool = AccessPoolManager.pools[this.id];
pool.IsUsing = false;
TimeSpan span = (TimeSpan)(DateTime.Now - pool.StartTime);
if (span.TotalSeconds > AccessPoolManager.timeOut)
{
pool.Connection.Close();
AccessPoolManager.pools.Remove(this.id);
}
}
}
public DataTable ExecuteDataTable(string commandText, OleDbParameter[] pt)
{
DataTable dataTable = new DataTable();
using (AccessPoolManager.AccessPool pool = AccessPoolManager.Instance(this.connectionString))
{
using (OleDbDataAdapter adapter = new OleDbDataAdapter(commandText, pool.Connection))
{
if (pt != null)
{
adapter.SelectCommand.Parameters.AddRange(pt);
}
adapter.Fill(dataTable);
}
}
return(dataTable);
}
public object ExecuteScalar(string commandText, OleDbParameter[] pt)
{
object obj2;
using (AccessPoolManager.AccessPool pool = AccessPoolManager.Instance(this.connectionString))
{
using (OleDbCommand command = new OleDbCommand(commandText, pool.Connection))
{
if (pt != null)
{
command.Parameters.AddRange(pt);
}
obj2 = command.ExecuteScalar();
}
}
return(obj2);
}
