public DataTable ExecuteDataTableProc(string storedProcedureName, params object[] parameterValues)
{
OracleParameter[] commandParameters = OracleHelperParameterCache.GetSpParameterSet(connectionString, storedProcedureName);
AssignParameterValues(commandParameters, parameterValues);
DataTable dt = OracleHelper.ReadTable(connectionString, CommandType.StoredProcedure, storedProcedureName, commandParameters);
return(dt);
}
public List <T> ExecuteListProc <T>(string storedProcedureName, params object[] parameterValues)
{
OracleParameter[] commandParameters = OracleHelperParameterCache.GetSpParameterSet(connectionString, storedProcedureName);
AssignParameterValues(commandParameters, parameterValues);
OracleDataReader odr = OracleHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, storedProcedureName, commandParameters);
var result = Mapper.DynamicMap <IDataReader, List <T> >(odr);
odr.Close();
return(result);
}
public DataSet ReadDataSetProc(string storedProcedureName, Dictionary <string, object> commandParameters)
{
Dictionary <string, string> tmpIpMappingOp;
OracleParameter[] sqlParams = OracleHelperParameterCache.GetSpParameterSet(connectionString, storedProcedureName);
AssignParameterValues(sqlParams, commandParameters, out tmpIpMappingOp);
DataSet ds = OracleHelper.ReadDataSet(connectionString, CommandType.StoredProcedure, storedProcedureName, sqlParams);
SetOutParamValue(commandParameters, tmpIpMappingOp, sqlParams);
return(ds);
}
public DataTable ExecuteDataTableProc(string storedProcedureName, Dictionary <string, object> commandParameters)
{
Dictionary <string, string> tmpIpMappingOp;
//OracleParameter[] sqlParams = Dp2Op(this.GetOwner(), storedProcedureName, commandParameters, out tmpIpMappingOp);
OracleParameter[] sqlParams = OracleHelperParameterCache.GetSpParameterSet(connectionString, storedProcedureName);
AssignParameterValues(sqlParams, commandParameters, out tmpIpMappingOp);
DataTable dt = OracleHelper.ReadTable(connectionString, CommandType.StoredProcedure, storedProcedureName, sqlParams);
SetOutParamValue(commandParameters, tmpIpMappingOp, sqlParams);
return(dt);
}
/// <summary>
/// Executes the non query proc.
/// </summary>
/// <param name="owner">The owner.</param>
/// <param name="storedProcedureName">Name of the stored procedure.</param>
/// <param name="commandParameters">The command parameters.</param>
/// <returns></returns>
public int ExecuteNonQueryProc(string owner, string storedProcedureName, Dictionary <string, object> commandParameters)
{
Dictionary <string, string> tmpIpMappingOp;
//OracleParameter[] sqlParams = Dp2Op(owner, storedProcedureName, commandParameters, out tmpIpMappingOp);
OracleParameter[] sqlParams = OracleHelperParameterCache.GetSpParameterSet(connectionString, storedProcedureName);
AssignParameterValues(sqlParams, commandParameters, out tmpIpMappingOp);
if (sqlParams != null)
{
int result = OracleHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, owner + "." + storedProcedureName, sqlParams);
SetOutParamValue(commandParameters, tmpIpMappingOp, sqlParams);
return(result);
}
else
{
return(-1);
}
}
public List <T> ExecuteListProc <T>(string owner, string storedProcedureName, Dictionary <string, object> commandParameters)
{
Dictionary <string, string> tmpIpMappingOp;
//OracleParameter[] sqlParams = Dp2Op(owner, storedProcedureName, commandParameters, out tmpIpMappingOp);
OracleParameter[] sqlParams = OracleHelperParameterCache.GetSpParameterSet(connectionString, storedProcedureName);
AssignParameterValues(sqlParams, commandParameters, out tmpIpMappingOp);
if (sqlParams != null)
{
OracleDataReader odr = OracleHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, storedProcedureName, sqlParams);
SetOutParamValue(commandParameters, tmpIpMappingOp, sqlParams);
var result = Mapper.DynamicMap <IDataReader, List <T> >(odr);
odr.Close();
return(result);
}
else
{
return(null);
}
}
