/// <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); }