public int ExecuteNonQuery(DbCommand cmd, DbTrans t)
{
cmd.Connection = t.Connection;
if (t.Transaction != null)
{
cmd.Transaction = t.Transaction;
}
try
{
int ret = cmd.ExecuteNonQuery();
return(ret);
}
catch
{
throw;
}
}
public DbDataReader ExecuteReader(DbCommand cmd, DbTrans t)
{
cmd.Connection = t.Connection;
if (t.Transaction != null)
{
cmd.Transaction = t.Transaction;
}
try
{
DbDataReader reader = cmd.ExecuteReader();
return(reader);
}
catch
{
throw;
}
}
public object ExecuteScalar(DbCommand cmd, DbTrans t)
{
cmd.Connection = t.Connection;
if (t.Transaction != null)
{
cmd.Transaction = t.Transaction;
}
try
{
object ret = cmd.ExecuteScalar();
if (ret == DBNull.Value)
{
ret = null;
}
return(ret);
}
catch
{
throw;
}
}
public DataTable ExecuteDataTable(DbCommand cmd, DbTrans t)
{
cmd.Connection = t.Connection;
if (t.Transaction != null)
{
cmd.Transaction = t.Transaction;
}
try
{
using (DbDataAdapter dbDataAdapter = dbFactory.CreateDataAdapter())
{
dbDataAdapter.SelectCommand = cmd;
DataTable dataTable = new DataTable();
dbDataAdapter.Fill(dataTable);
return(dataTable);
}
}
catch
{
throw;
}
}
public object ExecuteScalar(DbCommand cmd, DbTrans trans)
{
//调整DbCommand;
PrepareCommand(cmd);
//写日志
WriteLog(cmd);
try
{
if (trans.Connection == null && trans.Transaction == null)
{
return(dbHelper.ExecuteScalar(cmd));
}
return(dbHelper.ExecuteScalar(cmd, trans));
}
catch (Exception ex)
{
WriteExceptionLog(ex, cmd);
throw ex;
}
}
private void InitSession(DbProvider dbProvider)
{
this.dbProvider = dbProvider;
this.dbProvider.SetEventHandler(Decrypt);
this.dbTrans = new DbTrans(dbProvider, false);
}
internal DbBatch(DbProvider dbProvider, DbTrans dbTran)
{
this.dbProvider = dbProvider;
this.dbTrans = dbTran;
this.useBatch = false;
}