private static SpParameter GetSpParam(string name, DbType dbType, ParameterDirection direction, object value, int?size, byte?precision, byte?scale)
{
var spParam = new SpParameter()
{
Name = name,
DbType = dbType,
Direction = direction,
Value = value
};
if (size.HasValue)
{
spParam.Size = size.Value;
}
if (precision.HasValue)
{
spParam.Precision = precision.Value;
}
if (scale.HasValue)
{
spParam.Scale = scale.Value;
}
return(spParam);
}
public void SetReturn(string name, DbType dbType, int?size = null, byte?precision = null, byte?scale = null)
{
m_return = GetSpParam(name, dbType, ParameterDirection.ReturnValue, null, size, precision, scale);
}
