using System.Data;
namespace Bosera.Common.DB
{
/// <summary>
/// 参数类,用于存储参数信息
/// </summary>
public class DBParameter
{
public DBParameter()
{
IsOutput = false;
}
/// <summary>
/// 输入参数初始化,如果不指定类型默认为字符串
/// </summary>
/// <param name="name">参数名</param>
/// <param name="value">参数值</param>
public DBParameter(string name)
{
Name = name;
DbType = DbType.String;
IsOutput = false;
}
/// <summary>
/// 输入参数初始化,如果不指定类型默认为字符串
/// </summary>
/// <param name="name">参数名</param>
/// <param name="value">参数值</param>
public DBParameter(string name,DbType dbType)
{
Name = name;
DbType = dbType;
IsOutput = false;
}
/// <summary>
/// 输入参数初始化,如果不指定类型默认为字符串
/// </summary>
/// <param name="name">参数名</param>
/// <param name="value">参数值</param>
public DBParameter(string name, object value)
{
Name = name;
Value = value;
DbType = DbType.String;
IsOutput = false;
}
/// <summary>
/// 输入参数初始化
/// </summary>
/// <param name="name">参数名</param>
/// <param name="value">参数值</param>
/// <param name="dbType">参数类型</param>
public DBParameter(string name,object value,DbType dbType)
{
Name = name;
Value = value;
DbType = dbType;
IsOutput = false;
}
/// <summary>
/// 输出参数初始化
/// </summary>
/// <param name="name">参数名</param>
/// <param name="dbType">参数类型</param>
/// <param name="size">参数长度</param>
public DBParameter(string name, DbType dbType,int size)
{
Name = name;
DbType = dbType;
Size = size;
IsOutput = true;
}
/// <summary>
/// 参数名
/// </summary>
public string Name { get; set; }
/// <summary>
/// 参数类型
/// </summary>
public DbType DbType { get; set; }
/// <summary>
/// 参数值,如果是输出参数不用设置,输入参数要设置,使用Update方法时Value为原列
/// </summary>
public object Value { get; set; }
/// <summary>
/// 是否为输出参数,默认为false
/// </summary>
public bool IsOutput { get; set; }
/// <summary>
/// 参数长度,如果是输入参数不用设置,输出参数要设置
/// </summary>
public int Size { get; set; }
}
}