public int Add(string strSQL)
{
int intReturn = 0;
try
{
dllOracle _dllOracle = new dllOracle();
return _dllOracle.AddData(strSQL);
}
catch (Exception)
{
throw;
}
}
public int GetTableId(string strSQL)
{
int intTableId = 0;
try
{
dllOracle _dllOracle = new dllOracle();
return _dllOracle.GetTableMaxId(strSQL);
}
catch (Exception)
{
throw;
}
}
public DataTable GetDataTable(string strSQL)
{
try
{
dllOracle _dllOracle = new dllOracle();
return _dllOracle.GetDataTable(strSQL);
}
catch (Exception)
{
throw;
}
}
public DataTable ExecuteQueryToDataTable()
{
OracleParameter param = new OracleParameter("po_cursor", OracleType.Cursor);
param.Direction = ParameterDirection.Output;
parameterList.Add(param);
dllOracle _dllOracle = new dllOracle();
return _dllOracle.ExecuteStoredProcedureDataTable(this.ProcedureName, this.ParameterList);
}
public void ExecuteNonQuery(DBTransaction transaction)
{
if (transaction == null)
{
ExecuteNonQuery();
}
else
{
dllOracle _dllOracle = new dllOracle();
_dllOracle.ExecuteNonQueryStoredProcedure(this.ProcedureName, this.ParameterList, transaction.CurrentTransaction.Connection, transaction.CurrentTransaction);
}
}
public void ExecuteNonQuery()
{
dllOracle _dllOracle = new dllOracle();
_dllOracle.ExecuteNonQueryStoredProcedure(this.ProcedureName, this.ParameterList);
}