/// <summary>
/// add parameter
/// </summary>
/// <param name="parameter"></param>
public void Add(ParameterItem parameter)
{
if (parameter == null)
{
return;
}
if (Parameters.ContainsKey(parameter.Name))
{
Parameters[parameter.Name] = parameter;
}
else
{
Parameters.Add(parameter.Name, parameter);
}
}
/// <summary>
/// add parameter
/// </summary>
/// <param name="name">parameter name</param>
/// <param name="value">parameter value</param>
/// <param name="dbType">dbtype</param>
/// <param name="direction">direction</param>
/// <param name="size">size</param>
/// <param name="precision">precision</param>
/// <param name="scale">scale</param>
public void Add(string name, object value = null, DbType?dbType = null, ParameterDirection?direction = null, int?size = null, byte?precision = null, byte?scale = null)
{
var item = new ParameterItem()
{
Name = name,
Value = value,
ParameterDirection = direction ?? ParameterDirection.Input,
DbType = dbType,
Size = size,
Precision = precision,
Scale = scale
};
Add(item);
}
