根据参数名自动创建参数数组SqlParameter []

   #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