/// <summary>
/// Inserv_ts a new Parameter at the given Index for the Command
/// </summary>
/// <param name="oCmd">The Command</param>
/// <param name="iParameterIndex">The Index</param>
/// <param name="sParameterName">Paramter Name</param>
/// <param name="oParameterValue">Parameter Value</param>
/// <param name="DbType">Parameter Type</param>
public static void InsertParameter(System.Data.IDbCommand oCmd, int iParameterIndex, string sParameterName, object oParameterValue, XDbType DbType)
{
XrDbCommand o = (XrDbCommand)oCmd;
XrDbParameter oParam = CreateParameter(sParameterName, oParameterValue, DbType, 0, System.Data.ParameterDirection.Input);
o.Parameters.Insert(iParameterIndex, oParam);
}
/// <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>
/// <param name="DbType">Parameter Type</param>
/// <param name="iSize">Data Size</param>
/// <param name="pdDirection">Parameter Direction</param>
public static void AddParameter(System.Data.IDbCommand oCmd, string sParameterName, object oParameterValue, XDbType DbType, int iSize, System.Data.ParameterDirection pdDirection)
{
XrDbCommand o = (XrDbCommand)oCmd;
XrDbParameter oParam = CreateParameter(sParameterName, oParameterValue, DbType, iSize, pdDirection);
// Replace or Add
if (o.Parameters.Contains(sParameterName))
{
o.Parameters[sParameterName] = oParam;
}
else
{
o.Parameters.Add(oParam);
}
}
protected static XrDbParameter CreateParameter(string sParameterName, object oParameterValue, XDbType DbType, int iSize, System.Data.ParameterDirection direction)
{
XrDbParameter oParam;
if (iSize != 0)
{
oParam = new XrDbParameter(sParameterName, (XrDbType)DbType, iSize);
}
else
{
oParam = new XrDbParameter(sParameterName, (XrDbType)DbType);
}
oParam.Direction = direction;
oParam.Value = oParameterValue;
return(oParam);
}
