using System.Data;
|
using System.Data.Common;
|
|
namespace CSFramework.DB
|
{
|
/// <summary>
|
/// 参数操作工具
|
/// </summary>
|
public static class ParameterHelper
|
{
|
/// <summary>
|
/// 添加参数
|
/// </summary>
|
/// <param name="cmd"></param>
|
/// <param name="ParameterName"></param>
|
/// <param name="ParameterValue"></param>
|
/// <param name="dbType"></param>
|
/// <returns></returns>
|
public static DbParameter AddParameter(DbCommand cmd,
|
string ParameterName, object ParameterValue, DbType dbType)
|
{
|
var dbp = cmd.CreateParameter();
|
dbp.ParameterName = ParameterName;
|
dbp.Value = ParameterValue;
|
dbp.DbType = dbType;
|
cmd.Parameters.Add(dbp);
|
return dbp;
|
}
|
|
/// <summary>
|
/// 添加参数
|
/// </summary>
|
/// <param name="cmd">命令</param>
|
/// <param name="parameters">对象(匹配参数名称和对象的属性名称)</param>
|
/// <param name="paramPrefix">参数前缀,如：@,?,:</param>
|
public static void AddParameter(DbCommand cmd, object parameters,
|
string paramPrefix)
|
{
|
if (parameters != null)
|
{
|
var T = parameters.GetType();
|
var properties = T.GetProperties();
|
foreach (var property in properties)
|
{
|
var value = property.GetValue(parameters, null);
|
var paramName = paramPrefix + property.Name;
|
if (value != null && !cmd.Parameters.Contains(paramName))
|
{
|
var dbp = cmd.CreateParameter();
|
dbp.ParameterName = paramName;
|
dbp.Value = value;
|
dbp.DbType =
|
DBDataTypes.GetDbType(property.PropertyType);
|
cmd.Parameters.Add(dbp);
|
|
if (dbp.DbType == DbType.DateTime)
|
if (CommonMethods.ToSqlDateTime(value) <=
|
CommonMethods.MinSqlDate)
|
dbp.Value = CommonMethods.MinSqlDate;
|
|
if (dbp.DbType == DbType.Int16 ||
|
dbp.DbType == DbType.Int32 ||
|
dbp.DbType == DbType.Int64
|
|| dbp.DbType == DbType.Single ||
|
dbp.DbType == DbType.Double ||
|
dbp.DbType == DbType.Decimal)
|
if (CommonMethods.ToDecimal(value) == 0)
|
dbp.Value = 0;
|
}
|
}
|
}
|
}
|
}
|
}
|
