/// <summary>
/// 根据配置文件中所配置的数据库类型
/// 来创建相应数据库的参数对象
/// </summary>
/// <returns></returns>
public static DbParameter CreateDbParameter(string paramName, object value, int size)
{
DbParameter param = DbFactory.CreateDbParameter();
param.ParameterName = paramName;
param.Value = value;
param.Size = size;
return(param);
}
/// <summary>
/// 根据配置文件中所配置的数据库类型
/// 来创建相应数据库的参数对象
/// </summary>
/// <returns></returns>
public static DbParameter CreateDbOutParameter(string paramName, int size)
{
DbParameter param = DbFactory.CreateDbParameter();
param.Direction = ParameterDirection.Output;
param.ParameterName = paramName;
param.Size = size;
return(param);
}
/// <summary>
/// 根据配置文件中所配置的数据库类型
/// 来创建相应数据库的参数对象
/// </summary>
/// <returns></returns>
public static DbParameter CreateDbParameter(string paramName, object value, DbType dbType)
{
DbParameter param = DbFactory.CreateDbParameter();
param.DbType = dbType;
param.ParameterName = paramName;
param.Value = value;
return(param);
}
/// <summary>
/// 对象参数转换DbParameter
/// </summary>
/// <returns></returns>
public static DbParameter[] GetParameter <T>(T entity)
{
IList <DbParameter> parameter = new List <DbParameter>();
DbType dbtype = new DbType();
Type type = entity.GetType();
PropertyInfo[] props = type.GetProperties();
foreach (PropertyInfo pi in props)
{
if (pi.GetValue(entity, null) != null)
{
switch (pi.PropertyType.ToString())
{
case "System.Nullable`1[System.Int32]":
dbtype = DbType.Int32;
break;
case "System.Int32":
dbtype = DbType.Int32;
break;
case "System.Nullable`1[System.Decimal]":
dbtype = DbType.Decimal;
break;
case "System.Decimal":
dbtype = DbType.Decimal;
break;
case "System.Nullable`1[System.DateTime]":
dbtype = DbType.DateTime;
break;
default:
dbtype = DbType.String;
break;
}
parameter.Add(DbFactory.CreateDbParameter(DbHelper.DbParmChar + pi.Name,
(pi.GetValue(entity, null).Equals(" ") || pi.GetValue(entity, null).ToString().Trim() == string.Empty
? DBNull.Value
: pi.GetValue(entity, null)),
dbtype));
}
}
return(parameter.ToArray());
}
/// <summary>
/// 对象参数转换DbParameter
/// </summary>
/// <returns></returns>
public static DbParameter[] GetParameter(Hashtable ht)
{
IList <DbParameter> parameter = new List <DbParameter>();
DbType dbtype = new DbType();
foreach (string key in ht.Keys)
{
if (ht[key] is DateTime)
{
dbtype = DbType.DateTime;
}
else
{
dbtype = DbType.String;
}
parameter.Add(DbFactory.CreateDbParameter(DbHelper.DbParmChar + key, ht[key], dbtype));
}
return(parameter.ToArray());
}
