public void AddParameters(int index, string paramName, StoredProcedureParameterDirection parameterDirection, DbType type, int size)
{
//if (this.providerType == DataProvider.Oracle)
//{
// OracleParameter param = new OracleParameter(paramName, OracleType.Cursor);
//}
if (index < idbParameters.Length)
{
idbParameters[index].ParameterName = paramName;
idbParameters[index].DbType = type;
idbParameters[index].Size = size;
switch (parameterDirection)
{
case StoredProcedureParameterDirection.Input:
idbParameters[index].Direction = System.Data.ParameterDirection.Input;
break;
case StoredProcedureParameterDirection.Output:
idbParameters[index].Direction = System.Data.ParameterDirection.Output;
break;
case StoredProcedureParameterDirection.InputOutput:
idbParameters[index].Direction = System.Data.ParameterDirection.InputOutput;
break;
case StoredProcedureParameterDirection.ReturnValue:
idbParameters[index].Direction = System.Data.ParameterDirection.ReturnValue;
break;
}
}
}
public void AddParameters(int index, string paramName, object objValue, StoredProcedureParameterDirection parameterDirection, DbType dbType, int size)
{
if (index < idbParameters.Length)
{
idbParameters[index].ParameterName = paramName;
idbParameters[index].Value = objValue;
idbParameters[index].Size = size;
idbParameters[index].DbType = dbType;
switch (parameterDirection)
{
case StoredProcedureParameterDirection.Input:
idbParameters[index].Direction = System.Data.ParameterDirection.Input;
break;
case StoredProcedureParameterDirection.Output:
idbParameters[index].Direction = System.Data.ParameterDirection.Output;
break;
case StoredProcedureParameterDirection.InputOutput:
idbParameters[index].Direction = System.Data.ParameterDirection.InputOutput;
break;
case StoredProcedureParameterDirection.ReturnValue:
idbParameters[index].Direction = System.Data.ParameterDirection.ReturnValue;
break;
}
}
}
public void AddParameters(int index, string paramName, StoredProcedureParameterDirection parameterDirection)
{
if (index < idbParameters.Length)
{
idbParameters[index].ParameterName = paramName;
switch (parameterDirection)
{
case StoredProcedureParameterDirection.Input:
idbParameters[index].Direction = System.Data.ParameterDirection.Input;
break;
case StoredProcedureParameterDirection.Output:
idbParameters[index].Direction = System.Data.ParameterDirection.Output;
break;
case StoredProcedureParameterDirection.InputOutput:
idbParameters[index].Direction = System.Data.ParameterDirection.InputOutput;
break;
case StoredProcedureParameterDirection.ReturnValue:
idbParameters[index].Direction = System.Data.ParameterDirection.ReturnValue;
break;
}
}
}
public StoredProcedureParameter(
string parameterName,
ColumnType parameterType,
object defaultValue,
StoredProcedureParameterDirection direction)
{
this.ParameterName = parameterName;
this.ParameterType = parameterType;
this.DefaultValue = defaultValue;
this.Direction = direction;
}
protected StoredProcedureSchema AddParameter(string parameterName, ColumnType parameterType, object defaultValue = null, StoredProcedureParameterDirection direction = StoredProcedureParameterDirection.IN)
{
this.Parameters[parameterName] = new StoredProcedureParameter(parameterName, parameterType, defaultValue, direction);
return(this);
}
