/// <summary>
/// Adds a new Parameter to the Command
/// </summary>
/// <param name="oCmd">The Command</param>
/// <param name="sParameterName">Parameter Name</param>
/// <param name="oParameterValue">Parameter Value</param>
public static void AddParameter(System.Data.IDbCommand oCmd, string sParameterName, object oParameterValue)
{
Type tParameterValueType = oParameterValue.GetType();
X.Data.DB.XDbType xDbType = GetDbType(tParameterValueType);
AddParameter(oCmd, sParameterName, oParameterValue, xDbType, 0, ParameterDirection.Input);
}
/// <summary>
/// Returns an Initialized DataBase Function Command
/// </summary>
/// <param name="sConnectionString">The Connection String</param>
/// <param name="sCommandText">Usually the DataBase Function Name</param>
/// <param name="eReturnType">Return type</param>
/// <param name="iLength">Return length</param>
/// <returns>The DataBase Function Command</returns>
public static System.Data.IDbCommand GetFunctionCommand(string sConnectionString, string sCommandText, X.Data.DB.XDbType eReturnType, int iLength)
{
System.Data.IDbCommand oFuncCmd = X.Data.DB.DbFactory.GetCommand(sConnectionString, sCommandText);
X.Data.DB.DbFactory.AddParameter(oFuncCmd, "RETURN_VALUE", null, eReturnType, iLength, System.Data.ParameterDirection.ReturnValue);
return(oFuncCmd);
}
