public void ExecuteNonQuery(string command)
{
try
{
using (var orclDbManager = new OrclDBManager())
{
using (var orclTranManager = new OrclTranManager(orclDbManager, OrclTranOption.None))
{
try
{
orclTranManager.CommandType = CommandType.Text;
orclTranManager.CommandText = command;
orclTranManager.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
}
catch (Exception)
{
throw;
}
}
public DataTable GetDatatable(string command)
{
DataSet dataSet;
try
{
using (var orclDbManager = new OrclDBManager())
{
using (var orclTranManager = new OrclTranManager(orclDbManager, OrclTranOption.None))
{
try
{
orclTranManager.CommandType = CommandType.Text;
orclTranManager.CommandText = command;
dataSet = orclTranManager.GetData();
}
catch (Exception)
{
throw;
}
}
}
}
catch (Exception ex)
{
throw;
}
if (dataSet.Tables.Count == 0)
{
return new DataTable();
}
return dataSet.Tables[0];
}
public OrclTranManager(OrclDBManager dBManager, OrclTranOption tranOption)
{
_dBManager = dBManager;
_tranOption = tranOption;
_orclCommand = new OracleCommand();
_orclCommand.Connection = _dBManager.Connection;
switch (_tranOption)
{
case OrclTranOption.Require:
_orclTransaction = _dBManager.Connection.BeginTransaction();
_orclCommand.Transaction = _orclTransaction;
break;
default:
break;
}
}