/// <summary>
/// 格式化为更新值查询
/// </summary>
/// <param name="setValue"></param>
/// <returns></returns>
string ForamtSetValue <T>(ParameCollection setValue) where T : IModel
{
string tableName = TypeCache.GetTableName(typeof(T));
string setString = "";
foreach (var pair in setValue)
{
string name = pair.Key;
object value = pair.Value;
value = ObjectConvert.SetNullValue(value);
if (name.StartsWith("$"))//直接按值拼接 c2["$SoldCount"] = "SoldCount+" + num;
{
name = name.Substring(1, name.Length - 1);
setString += string.Format(" {0}={1},", name, value);
}
else
{
setString += string.Format(" {0}=@{0},", name);
helper.AddParam(name, value);
}
}
setString = setString.Substring(0, setString.Length - 1);
return(setString);
}
/// <summary>
/// 设置参数
/// </summary>
/// <param name="name"></param>
/// <param name="value"></param>
public void SetParam(string name, object value)
{
value = ObjectConvert.SetNullValue(value);
helper.SetParam(name, value);
}
/// <summary>
/// 增加参数
/// </summary>
/// <param name="name"></param>
/// <param name="value"></param>
public void AddParam(string name, object value)
{
value = ObjectConvert.SetNullValue(value);
dbHelper.AddParam(name, value);
}