private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t314_idusuario:
paramName = "@t314_idusuario";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t448_idaviso:
paramName = "@t448_idaviso";
paramType = SqlDbType.Int;
paramSize = 4;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private static SqlParameter Param(IB.sqldblib.SqlServerSP cDblib, enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t010_idoficina:
paramName = "@t010_idoficina";
paramType = SqlDbType.SmallInt;
paramSize = 2;
break;
case enumDBFields.app:
paramName = "@app";
paramType = SqlDbType.VarChar;
paramSize = 20;
break;
case enumDBFields.hostName:
paramName = "@hostName";
paramType = SqlDbType.VarChar;
paramSize = 20;
break;
case enumDBFields.proxy:
paramName = "@proxy";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
case enumDBFields.tabRows:
paramName = "@tabRows";
paramType = SqlDbType.Structured;
paramSize = 0;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}