C#把insert跟Update的语句转化为json格式的数据

C#把insert和Update的语句转化为json格式的数据
就是把insert和update语句中的字段和value作为一个json的格式传输，然后在server端去根据相应的语句去解析出来到实体类。

有人做过吗？这个要求哦球好像很变态啊！



[解决办法]
拼JSON [{"Filed":"FiledName1","Value":"Value1"},{"Filed":"FiledName2","Value":"Value2"}]

接受List<实体类>

实体类 连个属性 Filed 、Value
[解决办法]
实体类 连个属性 Filed 、Value
[解决办法]

C# code

        /// <summary>        /// 转换对象为JSON格式数据        /// </summary>        /// <typeparam name="T">类</typeparam>        /// <param name="obj">对象</param>        /// <returns>字符格式的JSON数据</returns>        public static string GetJSON<T>(object obj)        {            string result = String.Empty;            try            {                System.Runtime.Serialization.Json.DataContractJsonSerializer serializer =                new System.Runtime.Serialization.Json.DataContractJsonSerializer(typeof(T));                using (System.IO.MemoryStream ms = new System.IO.MemoryStream())                {                    serializer.WriteObject(ms, obj);                    result = System.Text.Encoding.UTF8.GetString(ms.ToArray());                }            }            catch (Exception ex)            {                throw ex;            }            return result;        }        /// <summary>        /// 转换List<T>的数据为JSON格式        /// </summary>        /// <typeparam name="T">类</typeparam>        /// <param name="vals">列表值</param>        /// <returns>JSON格式数据</returns>        public static string JSON<T>(List<T> vals)        {            System.Text.StringBuilder st = new System.Text.StringBuilder();            try            {                System.Runtime.Serialization.Json.DataContractJsonSerializer s = new System.Runtime.Serialization.Json.DataContractJsonSerializer(typeof(T));                foreach (T city in vals)                {                    using (System.IO.MemoryStream ms = new System.IO.MemoryStream())                    {                        s.WriteObject(ms, city);                        st.Append(System.Text.Encoding.UTF8.GetString(ms.ToArray()));                    }                }            }            catch (Exception ex)            {                throw ex;            }            return st.ToString();        }        /// <summary>        /// JSON格式字符转换为T类型的对象        /// </summary>        /// <typeparam name="T"></typeparam>        /// <param name="jsonStr"></param>        /// <returns></returns>        public static T ParseFormByJson<T>(string jsonStr)        {            T obj = Activator.CreateInstance<T>();            using (System.IO.MemoryStream ms =            new System.IO.MemoryStream(System.Text.Encoding.UTF8.GetBytes(jsonStr)))            {                System.Runtime.Serialization.Json.DataContractJsonSerializer serializer =                new System.Runtime.Serialization.Json.DataContractJsonSerializer(typeof(T));                return (T)serializer.ReadObject(ms);            }        }
[解决办法]
参数化，用Proc处理多好.