#region 根据传入的字典 自动生成 SqlParameter
/// <summary>
/// 根据传入的字典 自动生成 SqlParameter
/// </summary>
/// <param name="prms"></param>
public static SqlParameter[] CreateSqlParameterByDictionary(Dictionary<string, object> prms)
{
List<SqlParameter> listParas = new List<SqlParameter>();
foreach (var item in prms)
{
listParas.Add(new SqlParameter(item.Key, item.Value));
}
SqlParameter[] paras = listParas.ToArray();
return paras;
}
public object XXX(Dictionary<string, object> prms)
{
SqlParameter[] parms = {
new SqlParameter("@id", prms["@id"]),
new SqlParameter("@name", prms["@name"])
};
//等价于
CreateSqlParameterByDictionary(prms);
}
#endregion