C#解析JSON数组

C#解析JSON数组

方式一

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

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

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

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

第三步：封装一个函数，方便以后使用

待解析JSON数组

函数：

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

实现：

搞定~

方式二(推荐)：

　　第一步就是要根据这个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放到这个网站，自动给我们生成实体类即可

实体类：

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 
 6 namespace WindowsFormsApplication1
 7 {
 8 
 9     /// <summary>
10     /// JSON数据的实体类
11     /// </summary>
12     public class Root
13     {
14         /// <summary>
15         /// 
16         /// </summary>
17         public string message { get; set; }
18         /// <summary>
19         /// 
20         /// </summary>
21         public string nu { get; set; }
22         /// <summary>
23         /// 
24         /// </summary>
25         public string ischeck { get; set; }
26         /// <summary>
27         /// 
28         /// </summary>
29         public string condition { get; set; }
30         /// <summary>
31         /// 
32         /// </summary>
33         public string com { get; set; }
34         /// <summary>
35         /// 
36         /// </summary>
37         public string status { get; set; }
38         /// <summary>
39         /// 
40         /// </summary>
41         public string state { get; set; }
42         /// <summary>
43         /// 
44         /// </summary>
45         public List<DataItem> data { get; set; }
46     }
47     public class DataItem
48     {
49         /// <summary>
50         /// 
51         /// </summary>
52         public string time { get; set; }
53         /// <summary>
54         /// 
55         /// </summary>
56         public string ftime { get; set; }
57         /// <summary>
58         /// 已签收,感谢使用顺丰,期待再次为您服务
59         /// </summary>
60         public string context { get; set; }
61         /// <summary>
62         /// 
63         /// </summary>
64         public string location { get; set; }
65     }
66 
67 }

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

封装一个方法

 1         /// <summary>
 2         /// 将JSON转字符串(包括数组)
 3         /// </summary>
 4         /// <typeparam name="T"></typeparam>
 5         /// <param name="json"></param>
 6         /// <returns></returns>
 7         public static T JsonConvertObject<T>(string json)
 8         {
 9             return JsonConvert.DeserializeObject<T>(json);
10         }

调用即可

以下JSON帮助类

  1 using System.Collections.Generic;
  2 using System.IO;
  3 using Newtonsoft.Json;
  4 using Newtonsoft.Json.Linq;
  5 using System.Data;
  6 using System.Reflection;
  7 using System;
  8 
  9 namespace Sam.OA.Common
 10 {
 11     /// <summary>
 12     /// Json帮助类
 13     /// 使用前需引用开源项目类库：Newtonsoft.Json.dll
 14     /// </summary>
 15     public sealed class JsonHelper
 16     {
 17         /// <summary>
 18         /// 将对象序列化为json格式
 19         /// </summary>
 20         /// <param name="obj">序列化对象</param>
 21         /// <returns>json字符串</returns>
 22         public static string SerializeObjct(object obj)
 23         {            
 24             return JsonConvert.SerializeObject(obj);
 25         }
 26         /// <summary>
 27         /// 解析JSON字符串生成对象实体
 28         /// </summary>
 29         /// <typeparam name="T">实体类</typeparam>
 30         /// <param name="json">JSON字符串</param>
 31         /// <returns></returns>
 32         public static T JsonConvertObject<T>(string json)
 33         {
 34             return JsonConvert.DeserializeObject<T>(json);
 35         }
 36         /// <summary>
 37         /// 解析JSON字符串生成对象实体
 38         /// </summary>
 39         /// <typeparam name="T">对象类型</typeparam>
 40         /// <param name="json">json字符串</param>
 41         /// <returns></returns>
 42         public static T DeserializeJsonToObject<T>(string json) where T:class
 43         {
 44             JsonSerializer serializer = new JsonSerializer();
 45             StringReader sr = new StringReader(json);
 46             object obj = serializer.Deserialize(new JsonTextReader(sr), typeof(T));
 47             T t = obj as T;
 48             return t;
 49         }
 50         /// <summary>
 51         /// 解析JSON数组生成对象实体集合
 52         /// </summary>
 53         /// <typeparam name="T">对象类型</typeparam>
 54         /// <param name="json">json数组</param>
 55         /// <returns>对象实体集合</returns>
 56         public static List<T> DeserializeJsonToList<T>(string json) where T : class
 57         {
 58             JsonSerializer serializer = new JsonSerializer();
 59             StringReader sr = new StringReader(json);
 60             object obj = serializer.Deserialize(new JsonTextReader(sr), typeof(List<T>));
 61             List<T> list = obj as List<T>;
 62             return list;
 63         }
 64         /// <summary>
 65         /// 将JSON转数组
 66         /// 用法:jsonArr[0]["xxxx"]
 67         /// </summary>
 68         /// <param name="json">json字符串</param>
 69         /// <returns></returns>
 70         public static JArray GetToJsonList(string json)
 71         {
 72             JArray jsonArr = (JArray)JsonConvert.DeserializeObject(json);
 73             return jsonArr;
 74         }
 75         /// <summary>
 76         /// 将DataTable转换成实体类
 77         /// </summary>
 78         /// <typeparam name="T">实体类</typeparam>
 79         /// <param name="dt">DataTable</param>
 80         /// <returns></returns>
 81         public static List<T> DtConvertToModel<T>(DataTable dt) where T : new()
 82         {
 83             List<T> ts = new List<T>();
 84             foreach (DataRow dr in dt.Rows)
 85             {
 86                 T t = new T();
 87                 foreach (PropertyInfo pi in t.GetType().GetProperties())
 88                 {
 89                     if (dt.Columns.Contains(pi.Name))
 90                     {
 91                         if (!pi.CanWrite) continue;
 92                         var value = dr[pi.Name];
 93                         if (value != DBNull.Value)
 94                         {
 95                             switch (pi.PropertyType.FullName)
 96                             {
 97                                 case "System.Decimal":
 98                                     pi.SetValue(t, decimal.Parse(value.ToString()), null);
 99                                     break;
100                                 case "System.String":
101                                     pi.SetValue(t, value.ToString(), null);
102                                     break;
103                                 case "System.Int32":
104                                     pi.SetValue(t, int.Parse(value.ToString()), null);
105                                     break;
106                                 default:
107                                     pi.SetValue(t, value, null);
108                                     break;
109                             }
110                         }
111                     }
112                 }
113                 ts.Add(t);
114             }
115             return ts;
116         }
117     }
118 }