JSON帮助类-白红宇

JSON帮助类

阅读量：4352 次

发布时间：2019-06-07

本文共 17102 字，大约阅读时间需要 57 分钟。

using System;using System.Collections;using System.Collections.Generic;using System.Data;using System.Linq;using System.Reflection;using System.Text;using System.Text.RegularExpressions;using System.Threading.Tasks;using System.Runtime.Serialization.Json;using System.IO;namespace A_HDL_CLassToolDLL{    public class JSONTOOL    {        ///           /// 序列化集合对象          /// 
          public static string JsonSerializerByArrayData
     
      (T[] tArray)        {            DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(T[]));            MemoryStream ms = new MemoryStream();            ser.WriteObject(ms, tArray);            string jsonString = Encoding.UTF8.GetString(ms.ToArray());            ms.Close();            string p = @"\\/Date(\d+)\+\d+\\/";            MatchEvaluator matchEvaluator = new MatchEvaluator(ConvertJsonDateToDateString);            Regex reg = new Regex(p);            jsonString = reg.Replace(jsonString, matchEvaluator);            return jsonString;        }        /// 
                /// 序列化单个对象          /// 
          public static string JsonSerializerBySingleData
      
       (T t)        {            DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(T));            MemoryStream ms = new MemoryStream();            ser.WriteObject(ms, t);            string jsonString = Encoding.UTF8.GetString(ms.ToArray());            ms.Close();            string p = @"\\/Date(\d+)\+\d+\\/";            MatchEvaluator matchEvaluator = new MatchEvaluator(ConvertJsonDateToDateString);            Regex reg = new Regex(p);            jsonString = reg.Replace(jsonString, matchEvaluator);            return jsonString;        }        /// 
                  /// 反序列化单个对象          /// 
           public static T JsonDeserializeBySingleData
       
        (string jsonString)        {            //将"yyyy-MM-dd HH:mm:ss"格式的字符串转为"\/Date(1294499956278+0800)\/"格式                string p = @"\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}";            MatchEvaluator matchEvaluator = new MatchEvaluator(ConvertDateStringToJsonDate);            Regex reg = new Regex(p);            jsonString = reg.Replace(jsonString, matchEvaluator);            DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(T));            MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(jsonString));            T obj = (T)ser.ReadObject(ms);            return obj;        }        /// 
                   /// 反序列化集合对象          /// 
           public static T[] JsonDeserializeByArrayData
        
         (string jsonString)        {            //将"yyyy-MM-dd HH:mm:ss"格式的字符串转为"\/Date(1294499956278+0800)\/"格式                string p = @"\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}";            MatchEvaluator matchEvaluator = new MatchEvaluator(ConvertDateStringToJsonDate);            Regex reg = new Regex(p);            jsonString = reg.Replace(jsonString, matchEvaluator);            DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(T[]));            MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(jsonString));            T[] arrayObj = (T[])ser.ReadObject(ms);            return arrayObj;        }        /// 
                    /// 将Json序列化的时间由/Date(1294499956278+0800)转为字符串           /// 
           private static string ConvertJsonDateToDateString(Match m)        {            string result = string.Empty;            DateTime dt = new DateTime(1970, 1, 1);            dt = dt.AddMilliseconds(long.Parse(m.Groups[1].Value));            dt = dt.ToLocalTime();            result = dt.ToString("yyyy-MM-dd HH:mm:ss");            return result;        }        /// 
                     /// 将时间字符串转为Json时间           /// 
           private static string ConvertDateStringToJsonDate(Match m)        {            string result = string.Empty;            DateTime dt = DateTime.Parse(m.Groups[0].Value);            dt = dt.ToUniversalTime();            TimeSpan ts = dt - DateTime.Parse("1970-01-01");            result = string.Format("\\/Date({0}+0800)\\/", ts.TotalMilliseconds);            return result;        }        /// 
                   /// List转成json           /// 
          /// 
                   /// 
                   /// 
                   public static string ListToJson
         
          (IList
          
            list) { object obj = list[0]; return ListToJson
           
            (list, obj.GetType().Name); } /// 
             /// 对象转换为Json字符串 /// 
 /// 
            对象 /// 
            
             Json字符串
             public static string ToJson(object jsonObject) { try { StringBuilder jsonString = new StringBuilder(); jsonString.Append("{ "); PropertyInfo[] propertyInfo = jsonObject.GetType().GetProperties(); for (int i = 0; i < propertyInfo.Length; i++) { object objectValue = propertyInfo[i].GetGetMethod().Invoke(jsonObject, null); if (objectValue == null) { continue; } StringBuilder value = new StringBuilder(); if (objectValue is DateTime || objectValue is Guid || objectValue is TimeSpan) { value.Append("\"" + objectValue.ToString() + "\""); } else if (objectValue is string) { value.Append("\"" + objectValue.ToString() + "\""); } else if (objectValue is IEnumerable) { value.Append(ToJson((IEnumerable)objectValue)); } else { value.Append("\"" + objectValue.ToString() + "\""); } jsonString.Append("\"" + propertyInfo[i].Name + "\":" + value + ","); ; } return jsonString.ToString().TrimEnd(',') + "}"; } catch (Exception ex) { throw ex; } } /// 
             /// 对象集合转换Json /// 
 /// 
            集合对象 /// 
            
             Json字符串
             public static string ToJson(IEnumerable array) { string jsonString = "["; foreach (object item in array) { jsonString += ToJson(item) + ","; } if (jsonString.Length > 1) { jsonString.Remove(jsonString.Length - 1, jsonString.Length); } else { jsonString = "[]"; } return jsonString + "]"; } /// 
             /// 普通集合转换Json /// 
 /// 
            集合对象 /// 
            
             Json字符串
             public static string ToArrayString(IEnumerable array) { string jsonString = "["; foreach (object item in array) { jsonString = ToJson(item.ToString()) + ","; } jsonString.Remove(jsonString.Length - 1, jsonString.Length); return jsonString + "]"; } /// 
             /// Datatable转换为Json /// 
 /// 
            Datatable对象 /// 
            
             Json字符串
             public static string ToJson(DataTable dt) { StringBuilder jsonString = new StringBuilder(); jsonString.Append("["); DataRowCollection drc = dt.Rows; for (int i = 0; i < drc.Count; i++) { jsonString.Append("{ "); for (int j = 0; j < dt.Columns.Count; j++) { string strKey = dt.Columns[j].ColumnName; string strValue = drc[i][j].ToString(); Type type = dt.Columns[j].DataType; jsonString.Append("\"" + strKey + "\":"); //过滤数据 //strValue = StringFormat(strValue, type); if (j < dt.Columns.Count - 1) { jsonString.Append(strValue + ","); } else { jsonString.Append(strValue); } } jsonString.Append("},"); } jsonString.Remove(jsonString.Length - 1, 1); jsonString.Append("]"); if (jsonString.Length == 1) { return "[]"; } return jsonString.ToString(); } /// 
             /// List转成json /// 
 /// 
             /// 
             /// 
             /// 
             public static string ListToJson
            
             (IList
             
               list, string jsonName) { StringBuilder Json = new StringBuilder(); if (string.IsNullOrEmpty(jsonName)) jsonName = list[0].GetType().Name; Json.Append("{\"" + jsonName + "\":["); if (list.Count > 0) { for (int i = 0; i < list.Count; i++) { T obj = Activator.CreateInstance
              
               (); PropertyInfo[] pi = obj.GetType().GetProperties(); Json.Append("{ "); for (int j = 0; j < pi.Length; j++) { Type type; object o = pi[j].GetValue(list[i], null); string v = string.Empty; if (o != null) { type = o.GetType(); v = o.ToString(); } else { type = typeof(string); } Json.Append("\"" + pi[j].Name.ToString() + "\":" + v);//过滤数据// StringFormat(v, type)); if (j < pi.Length - 1) { Json.Append(","); } } Json.Append("}"); if (i < list.Count - 1) { Json.Append(","); } } } Json.Append("]}"); return Json.ToString(); } /// 
                /// DataSet转换为Json /// 
 /// 
               DataSet对象 /// 
               
                Json字符串
                public static string ToJson(DataSet dataSet) { string jsonString = "{ "; foreach (DataTable table in dataSet.Tables) { jsonString += "\"" + table.TableName + "\":" + ToJson(table) + ","; } jsonString = jsonString.TrimEnd(','); return jsonString + "}"; } /// 
                /// DataReader转换为Json /// 
 /// 
               DataReader对象 /// 
               
                Json字符串
                public static string ToJson(IDataReader dataReader) { try { StringBuilder jsonString = new StringBuilder(); jsonString.Append("["); while (dataReader.Read()) { jsonString.Append("{ "); for (int i = 0; i < dataReader.FieldCount; i++) { Type type = dataReader.GetFieldType(i); string strKey = dataReader.GetName(i); string strValue = dataReader[i].ToString(); jsonString.Append("\"" + strKey + "\":"); //过滤数据 //strValue = StringFormat(strValue, type); if (i < dataReader.FieldCount - 1) { jsonString.Append(strValue + ","); } else { jsonString.Append(strValue); } } jsonString.Append("},"); } if (!dataReader.IsClosed) { dataReader.Close(); } jsonString.Remove(jsonString.Length - 1, 1); jsonString.Append("]"); if (jsonString.Length == 1) { return "[]"; } return jsonString.ToString(); } catch (Exception ex) { throw ex; } } /// 
                /// DataTable转成Json /// 
 /// 
                /// 
                /// 
                public static string ToJson(DataTable dt, string jsonName) { StringBuilder Json = new StringBuilder(); if (string.IsNullOrEmpty(jsonName)) jsonName = dt.TableName; Json.Append("{\"" + jsonName + "\":["); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Json.Append("{ "); for (int j = 0; j < dt.Columns.Count; j++) { Type type = dt.Rows[i][j].GetType(); Json.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":"); //过滤数据 //+ StringFormat(dt.Rows[i][j] is DBNull ? string.Empty : dt.Rows[i][j].ToString(), type)); if (j < dt.Columns.Count - 1) { Json.Append(","); } } Json.Append("}"); if (i < dt.Rows.Count - 1) { Json.Append(","); } } } Json.Append("]}"); return Json.ToString(); } }}

using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Reflection;using System.Collections;using System.Data.Common;namespace DotNet.Utilities{    //JSON转换类    public class ConvertJson    {        #region 私有方法        ///         /// 过滤特殊字符        /// 
        private static string String2Json(String s)        {            StringBuilder sb = new StringBuilder();            for (int i = 0; i < s.Length; i++)            {                char c = s.ToCharArray()[i];                switch (c)                {                    case '\"':                        sb.Append("\\\""); break;                    case '\\':                        sb.Append("\\\\"); break;                    case '/':                        sb.Append("\\/"); break;                    case '\b':                        sb.Append("\\b"); break;                    case '\f':                        sb.Append("\\f"); break;                    case '\n':                        sb.Append("\\n"); break;                    case '\r':                        sb.Append("\\r"); break;                    case '\t':                        sb.Append("\\t"); break;                    default:                        sb.Append(c); break;                }            }            return sb.ToString();        }        ///         /// 格式化字符型、日期型、布尔型        /// 
        private static string StringFormat(string str, Type type)        {            if (type == typeof(string))            {                str = String2Json(str);                str = "\"" + str + "\"";            }            else if (type == typeof(DateTime))            {                str = "\"" + str + "\"";            }            else if (type == typeof(bool))            {                str = str.ToLower();            }            else if (type != typeof(string) && string.IsNullOrEmpty(str))            {                str = "\"" + str + "\"";            }            return str;        }        #endregion        #region List转换成Json        ///         /// List转换成Json        /// 
        public static string ListToJson
     
      (IList
      
        list)        {            object obj = list[0];            return ListToJson
       
        (list, obj.GetType().Name);        }        /// 
                /// List转换成Json         /// 
        public static string ListToJson
        
         (IList
         
           list, string jsonName)        {            StringBuilder Json = new StringBuilder();            if (string.IsNullOrEmpty(jsonName)) jsonName = list[0].GetType().Name;            Json.Append("{\"" + jsonName + "\":[");            if (list.Count > 0)            {                for (int i = 0; i < list.Count; i++)                {                    T obj = Activator.CreateInstance
          
           (); PropertyInfo[] pi = obj.GetType().GetProperties(); Json.Append("{ "); for (int j = 0; j < pi.Length; j++) { Type type = pi[j].GetValue(list[i], null).GetType(); Json.Append("\"" + pi[j].Name.ToString() + "\":" + StringFormat(pi[j].GetValue(list[i], null).ToString(), type)); if (j < pi.Length - 1) { Json.Append(","); } } Json.Append("}"); if (i < list.Count - 1) { Json.Append(","); } } } Json.Append("]}"); return Json.ToString(); } #endregion #region 对象转换为Json /// 
            /// 对象转换为Json /// 
 /// 
           对象 /// 
           
            Json字符串
            public static string ToJson(object jsonObject) { string jsonString = "{ "; PropertyInfo[] propertyInfo = jsonObject.GetType().GetProperties(); for (int i = 0; i < propertyInfo.Length; i++) { object objectValue = propertyInfo[i].GetGetMethod().Invoke(jsonObject, null); string value = string.Empty; if (objectValue is DateTime || objectValue is Guid || objectValue is TimeSpan) { value = "'" + objectValue.ToString() + "'"; } else if (objectValue is string) { value = "'" + ToJson(objectValue.ToString()) + "'"; } else if (objectValue is IEnumerable) { value = ToJson((IEnumerable)objectValue); } else { value = ToJson(objectValue.ToString()); } jsonString += "\"" + ToJson(propertyInfo[i].Name) + "\":" + value + ","; } jsonString.Remove(jsonString.Length - 1, jsonString.Length); return jsonString + "}"; } #endregion #region 对象集合转换Json /// 
            /// 对象集合转换Json /// 
 /// 
           集合对象 /// 
           
            Json字符串
            public static string ToJson(IEnumerable array) { string jsonString = "["; foreach (object item in array) { jsonString += ToJson(item) + ","; } jsonString.Remove(jsonString.Length - 1, jsonString.Length); return jsonString + "]"; } #endregion #region 普通集合转换Json /// 
            /// 普通集合转换Json /// 
 /// 
           集合对象 /// 
           
            Json字符串
            public static string ToArrayString(IEnumerable array) { string jsonString = "["; foreach (object item in array) { jsonString = ToJson(item.ToString()) + ","; } jsonString.Remove(jsonString.Length - 1, jsonString.Length); return jsonString + "]"; } #endregion #region DataSet转换为Json /// 
            /// DataSet转换为Json /// 
 /// 
           DataSet对象 /// 
           
            Json字符串
            public static string ToJson(DataSet dataSet) { string jsonString = "{ "; foreach (DataTable table in dataSet.Tables) { jsonString += "\"" + table.TableName + "\":" + ToJson(table) + ","; } jsonString = jsonString.TrimEnd(','); return jsonString + "}"; } #endregion #region Datatable转换为Json /// 
            /// Datatable转换为Json /// 
 /// 
           Datatable对象 /// 
           
            Json字符串
            public static string ToJson(DataTable dt) { StringBuilder jsonString = new StringBuilder(); jsonString.Append("["); DataRowCollection drc = dt.Rows; for (int i = 0; i < drc.Count; i++) { jsonString.Append("{ "); for (int j = 0; j < dt.Columns.Count; j++) { string strKey = dt.Columns[j].ColumnName; string strValue = drc[i][j].ToString(); Type type = dt.Columns[j].DataType; jsonString.Append("\"" + strKey + "\":"); strValue = StringFormat(strValue, type); if (j < dt.Columns.Count - 1) { jsonString.Append(strValue + ","); } else { jsonString.Append(strValue); } } jsonString.Append("},"); } jsonString.Remove(jsonString.Length - 1, 1); jsonString.Append("]"); return jsonString.ToString(); } /// 
            /// DataTable转换为Json /// 
 public static string ToJson(DataTable dt, string jsonName) { StringBuilder Json = new StringBuilder(); if (string.IsNullOrEmpty(jsonName)) jsonName = dt.TableName; Json.Append("{\"" + jsonName + "\":["); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Json.Append("{ "); for (int j = 0; j < dt.Columns.Count; j++) { Type type = dt.Rows[i][j].GetType(); Json.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":" + StringFormat(dt.Rows[i][j].ToString(), type)); if (j < dt.Columns.Count - 1) { Json.Append(","); } } Json.Append("}"); if (i < dt.Rows.Count - 1) { Json.Append(","); } } } Json.Append("]}"); return Json.ToString(); } #endregion #region DataReader转换为Json /// 
            /// DataReader转换为Json /// 
 /// 
           DataReader对象 /// 
           
            Json字符串
            public static string ToJson(DbDataReader dataReader) { StringBuilder jsonString = new StringBuilder(); jsonString.Append("["); while (dataReader.Read()) { jsonString.Append("{ "); for (int i = 0; i < dataReader.FieldCount; i++) { Type type = dataReader.GetFieldType(i); string strKey = dataReader.GetName(i); string strValue = dataReader[i].ToString(); jsonString.Append("\"" + strKey + "\":"); strValue = StringFormat(strValue, type); if (i < dataReader.FieldCount - 1) { jsonString.Append(strValue + ","); } else { jsonString.Append(strValue); } } jsonString.Append("},"); } dataReader.Close(); jsonString.Remove(jsonString.Length - 1, 1); jsonString.Append("]"); return jsonString.ToString(); } #endregion }}