|
/// <summary>
/// 添加一个Variant类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
public void AddParameters(string parname, object value)
{
cmd.Parameters.Add(parname, System.Data.SqlDbType.Variant).Value = value;
}
/// <summary>
/// 添加一个Bit类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
public void AddParameters(string parname, bool value)
{
cmd.Parameters.Add(parname, System.Data.SqlDbType.Bit).Value = value;
}
/// <summary>
/// 添加一个TinyInt类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
public void AddParameters(string parname, byte value)
{
cmd.Parameters.Add(parname, System.Data.SqlDbType.TinyInt).Value = value;
}
/// <summary>
/// 添加一个SmallInt类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
public void AddParameters(string parname, short value)
{
cmd.Parameters.Add(parname, System.Data.SqlDbType.SmallInt).Value = value;
}
/// <summary>
/// 添加一个Int类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
public void AddParameters(string parname, int value)
{
cmd.Parameters.Add(parname, System.Data.SqlDbType.Int).Value = value;
}
/// <summary>
/// 添加一个BigInt类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
public void AddParameters(string parname, long value)
{
cmd.Parameters.Add(parname, System.Data.SqlDbType.BigInt).Value = value;
}
/// <summary>
/// 添加一张图片
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
public void AddParameters(string parname, System.Drawing.Bitmap value)
{
System.IO.MemoryStream ms = new System.IO.MemoryStream();
value.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
AddParameters(parname, ms.ToArray(), ByteArrayFamily.Image);
}
/// <summary>
/// 添加一个Timestamp类型
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
public void AddParameters(string parname, byte[] value)
{
AddParameters(parname, value, ByteArrayFamily.Timestamp);
}
/// <summary>
/// 添加一个字节数组族类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
/// <param name="dateType"></param>
public void AddParameters(string parname, byte[] value, ByteArrayFamily dataType)
{
cmd.Parameters.Add(parname, DataTypeAdapter.ConvertSqlDbType(dataType)).Value = value;
}
/// <summary>
/// 添加一个字符类型数据，默认是NVarChar，长度是value.Length
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
public void AddParameters(string parname, string value)
{
AddParameters(parname, value, StringFamily.NVarChar, value.Length);
}
/// <summary>
/// 添加一个字符族类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
/// <param name="length"></param>
public void AddParameters(string parname, string value, int size)
{
AddParameters(parname, value, StringFamily.NVarChar, size);
}
/// <summary>
/// 添加一个字符族类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
/// <param name="dateType"></param>
/// <param name="length"></param>
public void AddParameters(string parname, string value, StringFamily dataType)
{
AddParameters(parname, value,dataType, value.Length);
}
/// <summary>
/// 添加一个字符族类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
/// <param name="dateType"></param>
/// <param name="size"></param>
public void AddParameters(string parname, string value, StringFamily dataType, int size)
{
cmd.Parameters.Add(parname, DataTypeAdapter.ConvertSqlDbType(dataType), size).Value = value;
}
/// <summary>
/// 添加一个SmallDateTime类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
public void AddParameters(string parname, DateTime value)
{
AddParameters(parname, value, DateFamily.SmallDateTime);
}
/// <summary>
/// 添加一个日期族类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
/// <param name="dateType"></param>
public void AddParameters(string parname, DateTime value, DateFamily dataType)
{
cmd.Parameters.Add(parname, DataTypeAdapter.ConvertSqlDbType(dataType)).Value = value;
}
/// <summary>
/// 添加一个Decimal类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
public void AddParameters(string parname, decimal value)
{
cmd.Parameters.Add(parname, System.Data.SqlDbType.Decimal).Value = value;
}
/// <summary>
/// 添加Float类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
public void AddParameters(string parname, float value)
{
cmd.Parameters.Add(parname, System.Data.SqlDbType.Float).Value = value;
}
/// <summary>
/// 添加一个UniqueIdentifier类型数据
/// </summary>
/// <param name="parname"></param>
/// <param name="value"></param>
public void AddParameters(string parname, System.Guid value)
{
cmd.Parameters.Add(parname, System.Data.SqlDbType.UniqueIdentifier).Value = value;
}
|