关于解析json的总结

1 有时候返回的是对象例如  {result:1,list[]}

则接收到的首先是一个对象

利用   Newtonsoft.Json.Linq.JObject jo = (Newtonsoft.Json.Linq.JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(status_return);  

可以得到list 的数组 接着对list数组解析

 List<Slaughterhouse> list = DeserializeJsonToList<Slaughterhouse>(jo["result"].ToString());

或者

List<truck_car> list = JsonConvert.DeserializeObject<List<truck_car>>(status_return);

如果list 只是一个对象可以使用

Slaughterhouse Slaughterhousemodel = JsonConvert.DeserializeObject<Slaughterhouse>(jo["result"].ToString());

如果返回的直接就是数组直接用DeserializeJsonToList  或者 JsonConvert.DeserializeObject<List<truck_car>>(status_return);

 

public static List<T> DeserializeJsonToList<T>(string json)
        {
            JsonSerializer serializer = new JsonSerializer();
            StringReader sr = new StringReader(json);
            object obj = serializer.Deserialize(new JsonTextReader(sr), typeof(List<T>));
            List<T> list = obj as List<T>;
            return list;
        }

  

 实体转换为json 返回  

JsonConvert.SerializeObject(projEntity)  object 类型

 

C#解析JSON数组

 

方式一#

第一步:使用前,需下载:Newtonsoft.Json.dll#

没有的,请到我百度云盘下载

链接:https://pan.baidu.com/s/1JBkee4qhtW7XOyYFiGOL2Q 
提取码:b5uq

第二步:引入命名空间:using Newtonsoft.Json;#

第三步:封装一个函数,方便以后使用#

待解析JSON数组

.net4 类转json .net json转数组_List

函数:

 

public static Newtonsoft.Json.Linq.JArray GetToJsonList(string json)
         {
             Newtonsoft.Json.Linq.JArray jsonArr = (Newtonsoft.Json.Linq.JArray)JsonConvert.DeserializeObject(json);
             return jsonArr;
         }

 

实现:

.net4 类转json .net json转数组_List_02

搞定~

方式二(推荐):#

  第一步就是要根据这个JSON来写出对应的实体类。用来存放数据。这个实体类如何写的?其实非常简单。因为一般不需要手动自己写,当然,你要是喜欢也可以自己写。不过我一般使用网站直接转换。自己百度 查一下,JSON转C#实体类,就会有很多网站给你转。

  我使用的是这个网站:http://www.bejson.com/convert/json2csharp/

{"message":"ok","nu":"367847964498","ischeck":"1","condition":"F00","com":"shunfeng","status":"200","state":"3","data":[{"time":"2017-09-21 09:33:09","ftime":"2017-09-21 09:33:09","context":"已签收,感谢使用顺丰,期待再次为您服务","location":""},{"time":"2017-09-21 09:09:48","ftime":"2017-09-21 09:09:48","context":"快件交给巩向涛,正在派送途中(联系电话:18806439871)","location":""},{"time":"2017-09-21 07:02:41","ftime":"2017-09-21 07:02:41","context":"快件到达 【淄博市桓台田庄速运营业点 】","location":""},{"time":"2017-09-20 15:32:00","ftime":"2017-09-20 15:32:00","context":"快件在【淄博市桓台县工业街营业点】已装车,准备发往下一站","location":""},{"time":"2017-09-20 13:37:08","ftime":"2017-09-20 13:37:08","context":"快件到达 【淄博市桓台县工业街营业点】","location":""},{"time":"2017-09-20 10:47:07","ftime":"2017-09-20 10:47:07","context":"快件在【淄博高新集散中心】已装车,准备发往下一站","location":""},{"time":"2017-09-20 10:15:47","ftime":"2017-09-20 10:15:47","context":"快件到达 【淄博高新集散中心】","location":""},{"time":"2017-09-19 23:20:18","ftime":"2017-09-19 23:20:18","context":"快件在【深圳总集散中心】已装车,准备发往下一站","location":""},{"time":"2017-09-19 22:39:27","ftime":"2017-09-19 22:39:27","context":"快件到达 【深圳总集散中心】","location":""},{"time":"2017-09-19 18:57:33","ftime":"2017-09-19 18:57:33","context":"快件在【深圳龙华新区华联社区营业部】已装车,准备发往下一站","location":""},{"time":"2017-09-19 16:12:21","ftime":"2017-09-19 16:12:21","context":"顺丰速运 已收取快件","location":""}]}

   只需将JSON放到这个网站,自动给我们生成实体类即可

实体类:

 

using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Text;
 
 namespace WindowsFormsApplication1
 {
 
     /// <summary>
     /// JSON数据的实体类
     /// </summary>
     public class Root
     {
         /// <summary>
         /// 
         /// </summary>
         public string message { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string nu { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string ischeck { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string condition { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string com { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string status { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string state { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public List<DataItem> data { get; set; }
     }
     public class DataItem
     {
         /// <summary>
         /// 
         /// </summary>
         public string time { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string ftime { get; set; }
         /// <summary>
         /// 已签收,感谢使用顺丰,期待再次为您服务
         /// </summary>
         public string context { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string location { get; set; }
     }
 
 }

 

实体类创建好后,我们还需要一个DLL文件,Newtonsoft.Json.DLL,看方式一

封装一个方法

 

/// <summary>
         /// 将JSON转字符串(包括数组)
         /// </summary>
         /// <typeparam name="T"></typeparam>
         /// <param name="json"></param>
         /// <returns></returns>
         public static T JsonConvertObject<T>(string json)
         {
             return JsonConvert.DeserializeObject<T>(json);
         }

 

调用即可

 

以下JSON帮助类

 

using System.Collections.Generic;
 using System.IO;
 using Newtonsoft.Json;
 using Newtonsoft.Json.Linq;
 using System.Data;
 using System.Reflection;
 using System;
 
 namespace Sam.OA.Common
 {
     /// <summary>
     /// Json帮助类
     /// 使用前需引用开源项目类库:Newtonsoft.Json.dll
     /// </summary>
     public sealed class JsonHelper
     {
         /// <summary>
         /// 将对象序列化为json格式
         /// </summary>
         /// <param name="obj">序列化对象</param>
         /// <returns>json字符串</returns>
         public static string SerializeObjct(object obj)
         {            
             return JsonConvert.SerializeObject(obj);
         }
         /// <summary>
         /// 解析JSON字符串生成对象实体
         /// </summary>
         /// <typeparam name="T">实体类</typeparam>
         /// <param name="json">JSON字符串</param>
         /// <returns></returns>
         public static T JsonConvertObject<T>(string json)
         {
             return JsonConvert.DeserializeObject<T>(json);
         }
         /// <summary>
         /// 解析JSON字符串生成对象实体
         /// </summary>
         /// <typeparam name="T">对象类型</typeparam>
         /// <param name="json">json字符串</param>
         /// <returns></returns>
         public static T DeserializeJsonToObject<T>(string json) where T:class
         {
             JsonSerializer serializer = new JsonSerializer();
             StringReader sr = new StringReader(json);
             object obj = serializer.Deserialize(new JsonTextReader(sr), typeof(T));
             T t = obj as T;
             return t;
         }
         /// <summary>
         /// 解析JSON数组生成对象实体集合
         /// </summary>
         /// <typeparam name="T">对象类型</typeparam>
         /// <param name="json">json数组</param>
         /// <returns>对象实体集合</returns>
         public static List<T> DeserializeJsonToList<T>(string json) where T : class
         {
             JsonSerializer serializer = new JsonSerializer();
             StringReader sr = new StringReader(json);
             object obj = serializer.Deserialize(new JsonTextReader(sr), typeof(List<T>));
             List<T> list = obj as List<T>;
             return list;
         }
         /// <summary>
         /// 将JSON转数组
         /// 用法:jsonArr[0]["xxxx"]
         /// </summary>
         /// <param name="json">json字符串</param>
         /// <returns></returns>
         public static JArray GetToJsonList(string json)
         {
             JArray jsonArr = (JArray)JsonConvert.DeserializeObject(json);
             return jsonArr;
         }
         /// <summary>
         /// 将DataTable转换成实体类
         /// </summary>
         /// <typeparam name="T">实体类</typeparam>
         /// <param name="dt">DataTable</param>
         /// <returns></returns>
         public static List<T> DtConvertToModel<T>(DataTable dt) where T : new()
         {
             List<T> ts = new List<T>();
             foreach (DataRow dr in dt.Rows)
             {
                 T t = new T();
                 foreach (PropertyInfo pi in t.GetType().GetProperties())
                 {
                     if (dt.Columns.Contains(pi.Name))
                     {
                         if (!pi.CanWrite) continue;
                         var value = dr[pi.Name];
                         if (value != DBNull.Value)
                         {
                             switch (pi.PropertyType.FullName)
                             {
                                 case "System.Decimal":
                                     pi.SetValue(t, decimal.Parse(value.ToString()), null);
                                     break;
                                 case "System.String":
                                     pi.SetValue(t, value.ToString(), null);
                                     break;
                                 case "System.Int32":
                                     pi.SetValue(t, int.Parse(value.ToString()), null);
                                     break;
                                 default:
                                     pi.SetValue(t, value, null);
                                     break;
                             }
                         }
                     }
                 }
                 ts.Add(t);
             }
             return ts;
         }
     }
 }

111111




方式一#

第一步:使用前,需下载:Newtonsoft.Json.dll#

没有的,请到我百度云盘下载

链接:https://pan.baidu.com/s/1JBkee4qhtW7XOyYFiGOL2Q 
提取码:b5uq

第二步:引入命名空间:using Newtonsoft.Json;#

第三步:封装一个函数,方便以后使用#

待解析JSON数组

.net4 类转json .net json转数组_List

函数:

 

public static Newtonsoft.Json.Linq.JArray GetToJsonList(string json)
         {
             Newtonsoft.Json.Linq.JArray jsonArr = (Newtonsoft.Json.Linq.JArray)JsonConvert.DeserializeObject(json);
             return jsonArr;
         }

 

实现:

.net4 类转json .net json转数组_List_02

搞定~

方式二(推荐):#

  第一步就是要根据这个JSON来写出对应的实体类。用来存放数据。这个实体类如何写的?其实非常简单。因为一般不需要手动自己写,当然,你要是喜欢也可以自己写。不过我一般使用网站直接转换。自己百度 查一下,JSON转C#实体类,就会有很多网站给你转。

  我使用的是这个网站:http://www.bejson.com/convert/json2csharp/

{"message":"ok","nu":"367847964498","ischeck":"1","condition":"F00","com":"shunfeng","status":"200","state":"3","data":[{"time":"2017-09-21 09:33:09","ftime":"2017-09-21 09:33:09","context":"已签收,感谢使用顺丰,期待再次为您服务","location":""},{"time":"2017-09-21 09:09:48","ftime":"2017-09-21 09:09:48","context":"快件交给巩向涛,正在派送途中(联系电话:18806439871)","location":""},{"time":"2017-09-21 07:02:41","ftime":"2017-09-21 07:02:41","context":"快件到达 【淄博市桓台田庄速运营业点 】","location":""},{"time":"2017-09-20 15:32:00","ftime":"2017-09-20 15:32:00","context":"快件在【淄博市桓台县工业街营业点】已装车,准备发往下一站","location":""},{"time":"2017-09-20 13:37:08","ftime":"2017-09-20 13:37:08","context":"快件到达 【淄博市桓台县工业街营业点】","location":""},{"time":"2017-09-20 10:47:07","ftime":"2017-09-20 10:47:07","context":"快件在【淄博高新集散中心】已装车,准备发往下一站","location":""},{"time":"2017-09-20 10:15:47","ftime":"2017-09-20 10:15:47","context":"快件到达 【淄博高新集散中心】","location":""},{"time":"2017-09-19 23:20:18","ftime":"2017-09-19 23:20:18","context":"快件在【深圳总集散中心】已装车,准备发往下一站","location":""},{"time":"2017-09-19 22:39:27","ftime":"2017-09-19 22:39:27","context":"快件到达 【深圳总集散中心】","location":""},{"time":"2017-09-19 18:57:33","ftime":"2017-09-19 18:57:33","context":"快件在【深圳龙华新区华联社区营业部】已装车,准备发往下一站","location":""},{"time":"2017-09-19 16:12:21","ftime":"2017-09-19 16:12:21","context":"顺丰速运 已收取快件","location":""}]}

   只需将JSON放到这个网站,自动给我们生成实体类即可

实体类:

 

using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Text;
 
 namespace WindowsFormsApplication1
 {
 
     /// <summary>
     /// JSON数据的实体类
     /// </summary>
     public class Root
     {
         /// <summary>
         /// 
         /// </summary>
         public string message { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string nu { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string ischeck { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string condition { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string com { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string status { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string state { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public List<DataItem> data { get; set; }
     }
     public class DataItem
     {
         /// <summary>
         /// 
         /// </summary>
         public string time { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string ftime { get; set; }
         /// <summary>
         /// 已签收,感谢使用顺丰,期待再次为您服务
         /// </summary>
         public string context { get; set; }
         /// <summary>
         /// 
         /// </summary>
         public string location { get; set; }
     }
 
 }

 

实体类创建好后,我们还需要一个DLL文件,Newtonsoft.Json.DLL,看方式一

封装一个方法

 

/// <summary>
         /// 将JSON转字符串(包括数组)
         /// </summary>
         /// <typeparam name="T"></typeparam>
         /// <param name="json"></param>
         /// <returns></returns>
         public static T JsonConvertObject<T>(string json)
         {
             return JsonConvert.DeserializeObject<T>(json);
         }

 

调用即可

 

以下JSON帮助类

 

using System.Collections.Generic;
 using System.IO;
 using Newtonsoft.Json;
 using Newtonsoft.Json.Linq;
 using System.Data;
 using System.Reflection;
 using System;
 
 namespace Sam.OA.Common
 {
     /// <summary>
     /// Json帮助类
     /// 使用前需引用开源项目类库:Newtonsoft.Json.dll
     /// </summary>
     public sealed class JsonHelper
     {
         /// <summary>
         /// 将对象序列化为json格式
         /// </summary>
         /// <param name="obj">序列化对象</param>
         /// <returns>json字符串</returns>
         public static string SerializeObjct(object obj)
         {            
             return JsonConvert.SerializeObject(obj);
         }
         /// <summary>
         /// 解析JSON字符串生成对象实体
         /// </summary>
         /// <typeparam name="T">实体类</typeparam>
         /// <param name="json">JSON字符串</param>
         /// <returns></returns>
         public static T JsonConvertObject<T>(string json)
         {
             return JsonConvert.DeserializeObject<T>(json);
         }
         /// <summary>
         /// 解析JSON字符串生成对象实体
         /// </summary>
         /// <typeparam name="T">对象类型</typeparam>
         /// <param name="json">json字符串</param>
         /// <returns></returns>
         public static T DeserializeJsonToObject<T>(string json) where T:class
         {
             JsonSerializer serializer = new JsonSerializer();
             StringReader sr = new StringReader(json);
             object obj = serializer.Deserialize(new JsonTextReader(sr), typeof(T));
             T t = obj as T;
             return t;
         }
         /// <summary>
         /// 解析JSON数组生成对象实体集合
         /// </summary>
         /// <typeparam name="T">对象类型</typeparam>
         /// <param name="json">json数组</param>
         /// <returns>对象实体集合</returns>
         public static List<T> DeserializeJsonToList<T>(string json) where T : class
         {
             JsonSerializer serializer = new JsonSerializer();
             StringReader sr = new StringReader(json);
             object obj = serializer.Deserialize(new JsonTextReader(sr), typeof(List<T>));
             List<T> list = obj as List<T>;
             return list;
         }
         /// <summary>
         /// 将JSON转数组
         /// 用法:jsonArr[0]["xxxx"]
         /// </summary>
         /// <param name="json">json字符串</param>
         /// <returns></returns>
         public static JArray GetToJsonList(string json)
         {
             JArray jsonArr = (JArray)JsonConvert.DeserializeObject(json);
             return jsonArr;
         }
         /// <summary>
         /// 将DataTable转换成实体类
         /// </summary>
         /// <typeparam name="T">实体类</typeparam>
         /// <param name="dt">DataTable</param>
         /// <returns></returns>
         public static List<T> DtConvertToModel<T>(DataTable dt) where T : new()
         {
             List<T> ts = new List<T>();
             foreach (DataRow dr in dt.Rows)
             {
                 T t = new T();
                 foreach (PropertyInfo pi in t.GetType().GetProperties())
                 {
                     if (dt.Columns.Contains(pi.Name))
                     {
                         if (!pi.CanWrite) continue;
                         var value = dr[pi.Name];
                         if (value != DBNull.Value)
                         {
                             switch (pi.PropertyType.FullName)
                             {
                                 case "System.Decimal":
                                     pi.SetValue(t, decimal.Parse(value.ToString()), null);
                                     break;
                                 case "System.String":
                                     pi.SetValue(t, value.ToString(), null);
                                     break;
                                 case "System.Int32":
                                     pi.SetValue(t, int.Parse(value.ToString()), null);
                                     break;
                                 default:
                                     pi.SetValue(t, value, null);
                                     break;
                             }
                         }
                     }
                 }
                 ts.Add(t);
             }
             return ts;
         }
     }
 }