C# 遍历json数据并读出值

    科技2024-03-20  93

    1、观察已有的json数据组织方式

    如:

    [{“HX”:“7811DE”,“LO”:114.06334,“LA”:28.33131,“HE”:9190,“GV”:853,“CO”:280, “FN”:“CSC8154”,“FN2”:“3U8154”,“RE”:“B8683”,“FT”:“A320”,“TE”:"2020-09-25T11:25:54 ",“OA”:“NGB”,“DA”:“CTU”,“SC”:“7016”}, {“HX”:“780FFF”,“LO”:113.8112,“LA”:22.64231,“HE”:0,“GV”:54,“CO”:152, “FN”:“CHH6058”,“FN2”:“HU6058”,“RE”:“B7616”,“FT”:“B738”,“TE”:“2020-09-25T11:25:5 3”,“OA”:“CKG”,“DA”:“SZX”,“SC”:“6442”}, {“HX”:“7811FE”,“LO”:106.85432,“LA”:29.91939,“HE”:3223,“GV”:565,“CO”:114, “FN”:“GCR6517”,“FN2”:“GS6517”,“RE”:“B8389”,“FT”:“A321”,“TE”:“2020-09-25T11:25:5 3”,“OA”:“CKG”,“DA”:“SWA”,“SC”:“1543”}, {“HX”:“78137C”,“LO”:113.3327,“LA”:28.27364,“HE”:9174,“GV”:828,“CO”:263, “FN”:“CBJ5691”,“FN2”:“JD5691”,“RE”:“B1247”,“FT”:“A20N”,“TE”:"2020-09-25T11:25:53 ",“OA”:“HGH”,“DA”:“CKG”,“SC”:“5113”}]

    2、根据字符串的数据结构创建类

    public class Data { public string HX { get; set; } public double LO { get; set; } public double LA { get; set; } public int HE { get; set; } public int GV { get; set; } public int CO { get; set; } public int VS { get; set; } public string FN { get; set; } public string FN2 { get; set; } public string RE { get; set; } public string FT { get; set; } public string TE { get; set; } public string OA { get; set; } public string DA { get; set; } public string SC { get; set; } }

    3、反序列化json数组

    List<Data> jobInfoList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Data>>(strUnzip);

    4、读取值并输出

    List<Data> jobInfoList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Data>>(strUnzip); foreach (Data jobInfo in jobInfoList) { Console.Write(jobInfo.HX + "\t"); Console.Write(jobInfo.LO+"\t"); Console.Write(jobInfo.LA + "\t"); Console.Write(jobInfo.HE + "\t"); Console.Write(jobInfo.GV + "\t"); Console.Write(jobInfo.CO + "\t"); Console.Write(jobInfo.VS + "\t"); Console.Write(jobInfo.FN + "\t"); Console.Write(jobInfo.FN2 + "\t"); Console.Write(jobInfo.RE + "\t"); Console.Write(jobInfo.FT + "\t"); Console.Write(jobInfo.TE + "\t"); Console.Write(jobInfo.OA + "\t"); Console.Write(jobInfo.DA + "\t"); Console.Write(jobInfo.SC + "\n"); }

    5、输出结果

    Processed: 0.015, SQL: 8