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