C#处理JSON 数据

时间：2023-03-08 17:49:13

网络中数据传输经常是xml或者json，现在做的一个项目之前调其他系统接口都是返回的xml格式，刚刚遇到一个返回json格式数据的接口，通过例子由易到难总结一下处理过程，希望能帮到和我一样开始不会的朋友。
一、C#处理简单json数据
json数据：

{"result":"","res_info":"ok","queryorder_info":"info"}

我这里是以jsonmy1.txt文件的形式保存在d盘json文件夹下。

构造对象：

 public struct ToJsonMy

 {

    public string result { get; set; }  //属性的名字，必须与json格式字符串中的"key"值一样。

    public string res_info { get; set; }

    public string queryorder_info { get; set; }

 }
public static void JsonMy()

{

    string json = Jsonstr("D:\\json\\jsonmy1.txt");//Jsonstr函数读取json数据的文本txt          　　　　　　

    JavaScriptSerializer js = new JavaScriptSerializer();   //实例化一个能够序列化数据的类

    ToJsonMy list = js.Deserialize<ToJsonMy>(json);    //将json数据转化为对象类型并赋值给list

    string result = list.result;      　　　　　　　

    string res_info = list.res_info;

    string queryorder_info = list.res_info;

}

二、C#处理包含对象的json数据
json数据：jsonmy2.txt

{"result":"","res_info":"ok","queryorder_info":{"order_num":"","orderdetail":"ok"}}

构造对象：

public struct ToJsonMy2

{

    public string result { get; set; }

    public string res_info { get; set; }

    public queryorder_info queryorder_info;

}

public struct queryorder_info

{

    public string order_num { get; set; }

    public string orderdetail { get; set; }

};

转换过程：

public static void JsonMy2()

{

    string json = Jsonstr("D:\\json\\jsonmy2.txt");

    JavaScriptSerializer js = new JavaScriptSerializer();   //实例化一个能够序列化数据的类

    ToJsonMy2 list = js.Deserialize<ToJsonMy2>(json);    //将json数据转化为对象类型并赋值给list

    string result = list.result;

    string res_info = list.res_info;

    string order_num = list.queryorder_info.order_num;

    string orderdetail = list.queryorder_info.orderdetail;

}

三、C#处理包含对象、数组的json数据
json数据：jsonmy4.txt

{"result":"","res_info":"ok","queryorder_info":{"order_num":"","orderdetail":[{"CFTUin":"","CancelDeadline":"2013-09-12 23:00:00","CheckInDate":"2013-09-12 00:00:00","CheckOutDate":"2013-09-13 00:00:00","CityID":"","CurrencyCode":"RMB","HotelID":"","HotelName":"乐家连锁（北京天坛南门店）（原速8酒店（北京天坛南门店）","ListID":"","PayAmt":"","PayType":"","RommsCnt":"","SPTransID":"","State":""},{"CFTUin":"","CancelDeadline":"2013-10-13 23:00:00","CheckInDate":"2013-10-13 00:00:00","CheckOutDate":"2013-10-18 00:00:00","CityID":"","CurrencyCode":"RMB","HotelID":"","HotelName":"上海凯顿酒店","ListID":"","PayAmt":"","PayType":"","RommsCnt":"","SPTransID":"","State":""}]}}

构造对象：

public struct ToJsonMy3

{

    public string result { get; set; }

    public string res_info { get; set; }

    public queryorder_info queryorder_info;

}

public struct queryorder_info

{

    public string order_num { get; set; }

    public List<orderdetail> orderdetail;//数组处理

};

public struct orderdetail

{

    public string CFTUin { get; set; }

    public string CancelDeadline { get; set; }

    public string CheckInDate { get; set; }

    public string CheckOutDate { get; set; }

    public string CityID { get; set; }

    public string CurrencyCode { get; set; }

    public string HotelID { get; set; }

    public string HotelName { get; set; }

    public string ListID { get; set; }

    public string PayAmt { get; set; }

    public string PayType { get; set; }

    public string RommsCnt { get; set; }

    public string SPTransID { get; set; }

    public string State { get; set; }

};

转换过程：

public static void JsonMy4()

{

    string json = Jsonstr("D:\\json\\jsonmy4.txt");

    JavaScriptSerializer js = new JavaScriptSerializer();   //实例化一个能够序列化数据的类

    ToJsonMy3 list = js.Deserialize<ToJsonMy3>(json);    //将json数据转化为对象类型并赋值给list

    string result = list.result;

    string res_info = list.res_info;

    string order_num = list.queryorder_info.order_num;

    List<orderdetail> orderdetail = list.queryorder_info.orderdetail;

    string CFTUin = orderdetail[].CFTUin;

    string HotelName = orderdetail[].HotelName;

    string ListID = orderdetail[].ListID;

    string State = orderdetail[].State;

}

以上代码来自：http://www.jb51.net/article/48027.htm

在项目中也遇到了使用JSON的情况，就把转化过程写一下。

1.从数据库获取的json数据为：

[{"ACTIONVALUE":"-1","CONTENT":"","DEVID":"","DEVNAME":"#1空调","DEVTYPE":"","EVENTTYPE":"","GRIDCODE":"","ISAUTO":"false","MEASURENAME":"通用.低风","MEASURETAG":"GEN.CtrlLowWind","STREAMTYPE":null,"TIMESPAN":""},{"ACTIONVALUE":"","CONTENT":"","DEVID":"","DEVNAME":"#1风机","DEVTYPE":"","EVENTTYPE":"","GRIDCODE":"","ISAUTO":"false","MEASURENAME":"风机开关","MEASURETAG":"GEN.UnibitCtrl","STREAMTYPE":null,"TIMESPAN":""},{"ACTIONVALUE":"","CONTENT":"","DEVID":"","DEVNAME":"#1警笛","DEVTYPE":"","EVENTTYPE":"","GRIDCODE":"","ISAUTO":"false","MEASURENAME":"警笛开关","MEASURETAG":"GEN.UnibitCtrl","STREAMTYPE":null,"TIMESPAN":""},{"ACTIONVALUE":"","CONTENT":"","DEVID":"","DEVNAME":"#1灯光","DEVTYPE":"","EVENTTYPE":"","GRIDCODE":"","ISAUTO":"true","MEASURENAME":"灯光开光","MEASURETAG":"GEN.UnibitCtrl","STREAMTYPE":null,"TIMESPAN":""},{"ACTIONVALUE":"","CONTENT":"","DEVID":"","DEVNAME":"hik1","DEVTYPE":"","EVENTTYPE":"","GRIDCODE":"","ISAUTO":"true","MEASURENAME":"","MEASURETAG":"GEN.PreSet","STREAMTYPE":"","TIMESPAN":""},{"ACTIONVALUE":"-1","CONTENT":"","DEVID":"","DEVNAME":"hik1","DEVTYPE":"","EVENTTYPE":"","GRIDCODE":"","ISAUTO":"true","MEASURENAME":"","MEASURETAG":"GEN.VideoRecord","STREAMTYPE":"","TIMESPAN":""}]

2.构造实体对象：

 public class ActionParam

    {

        //[{"ACTIONVALUE":"1","CONTENT":"","DEVID":"30000449660708","DEVNAME":"#1灯光","DEVTYPE":"45","EVENTTYPE":"","GRIDCODE":"","ISAUTO":"true","MEASURENAME":"灯光开光","MEASURETAG":"GEN.UnibitCtrl","STREAMTYPE":null,"TIMESPAN":""}]

        public int ACTIONVALUE { get; set; }

        public string CONTENT { get; set; }

        public string DEVID { get; set; }

        public string DEVNAME { get; set; }

        public string DEVTYPE { get; set; }

        public string EVENTTYPE { get; set; }

        public string GRIDCODE { get; set; }

        public bool ISAUTO { get; set; }

        public string MEASURENAME { get; set; }

        public string MEASURETAG { get; set; }

        public string STREAMTYPE { get; set; }

        public string TIMESPAN { get; set; }

    }

3.转化为C#中声明的数据格式：

 JavaScriptSerializer js = new JavaScriptSerializer();   //实例化一个能够序列化数据的类

 List<ActionParam> listDetail = js.Deserialize<List<ActionParam>>(actionParam);

以为json字符串是数组格式，所以js.Deserialize<T>()泛型中使用List<ActionParam>.

相关文章