如何构造树状 JSON 数据 JSON-Tree-阿里云开发者社区

开发者社区> 大数据> 正文

如何构造树状 JSON 数据 JSON-Tree

简介: 十年河东,十年河西,莫欺骚年穷...打错一个字哈、~_~ 接着上一篇博客,上一篇博客是=使用数据库结合LINQ构造的,为了方便理解,本篇采用泛型分组进行构造。 有兴趣的小虎斑可以参考上一篇博客:如何构造分层次的 Json 数据 本篇很简单,直接上代码 using Newtonsoft.

十年河东,十年河西,莫欺骚年穷...打错一个字哈、~_~

接着上一篇博客,上一篇博客是=使用数据库结合LINQ构造的,为了方便理解,本篇采用泛型分组进行构造。

有兴趣的小虎斑可以参考上一篇博客:如何构造分层次的 Json 数据

本篇很简单,直接上代码

using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;

namespace DFS
{
    class Program
    {
        static void Main(string[] args)
        {
            List<HelloChinaModel> MList = new List<HelloChinaModel>()
            {
                new HelloChinaModel(){ Id=1,Province="河南省",City="商丘市",District="永城市",OrgName="薛湖镇",AddTime=DateTime.Now},
                new HelloChinaModel(){ Id=1,Province="河南省",City="商丘市",District="夏邑县",OrgName="火店乡",AddTime=DateTime.Now},
                new HelloChinaModel(){ Id=1,Province="河南省",City="商丘市",District="睢阳区",OrgName="龙华小区",AddTime=DateTime.Now},
                new HelloChinaModel(){ Id=1,Province="河南省",City="平顶山市",District="新华区",OrgName="河南城建学院",AddTime=DateTime.Now},
                new HelloChinaModel(){ Id=1,Province="河南省",City="平顶山市",District="鲁山县",OrgName="炉山镇",AddTime=DateTime.Now},
                new HelloChinaModel(){ Id=1,Province="河南省",City="洛阳市",District="阳逻县",OrgName="大杨镇",AddTime=DateTime.Now},

                new HelloChinaModel(){ Id=1,Province="江苏省",City="苏州市",District="张家港市",OrgName="乐余镇",AddTime=DateTime.Now},
                new HelloChinaModel(){ Id=1,Province="江苏省",City="苏州市",District="昆山市",OrgName="小上海镇",AddTime=DateTime.Now},
                new HelloChinaModel(){ Id=1,Province="江苏省",City="南京市",District="雨花台区",OrgName="雨花台小区",AddTime=DateTime.Now},
                new HelloChinaModel(){ Id=1,Province="江苏省",City="徐州市",District="沛县",OrgName="王文学镇",AddTime=DateTime.Now},

                new HelloChinaModel(){ Id=1,Province="山东省",City="日照市",District="花果山县",OrgName="猴子镇",AddTime=DateTime.Now},
                new HelloChinaModel(){ Id=1,Province="山东省",City="青岛市",District="青岛啤酒县",OrgName="扎啤镇",AddTime=DateTime.Now},
            };
            // 首先根据省份分组
            var P_ls = MList.GroupBy(a =>  a.Province ).Select(g => (new { Province = g.Key, Citys = g })).ToList();//省份列表
            //
             List<Model_P> PList = new List<Model_P>();
            foreach (var item in P_ls)
            {
                Model_P P = new Model_P();
                //
              
                //
                List<Model_C> CList = new List<Model_C>();
                //获取各个分组
                var Province = item.Province;//省份的名称
                var CitysList = item.Citys;//省份对应的市 列表
                var C_ls = CitysList.GroupBy(a => a.City ).Select(g => new { City = g.Key, Districts = g }) ;//市/区列表
                foreach (var Citem in C_ls)
                {
                    List<Model_D> DList = new List<Model_D>();
                    Model_C C = new Model_C();
                    //
                    var DistrictsLsit = Citem.Districts;//
                    var D_ls = DistrictsLsit.GroupBy(a => a.District ).Select(g => new { Districts = g.Key, OrgNames = g });//县/区列表
                    foreach (var Ditem in D_ls)
                    {
                        List<Model_O> OList = new List<Model_O>();
                        Model_D D = new Model_D();
                      
                        var OrgNamesList = Ditem.OrgNames.ToList();
                        var O_ls = OrgNamesList.GroupBy(a =>a.OrgName ).Select(g => new { OrgName = g.Key });//乡镇列表/没有下级了
                       
                        foreach (var Oitem in O_ls)
                        {
                           
                            Model_O O = new Model_O();
                            string orgName = Oitem.OrgName.ToString();
                            O.OrgName = orgName;
                            OList.Add(O);
                            D.nodes = OList;
                        }
                        string Dname = Ditem.Districts.ToString();
                        D.District = Dname;

                        DList.Add(D); C.nodes = DList;
                    }
                    string Cname = Citem.City.ToString();
                   
                    C.City=Cname;
                    CList.Add(C); 
                    P.nodes = CList;
                }
                P.Province = item.Province.ToString();
               
                PList.Add(P);
            }
            string Json = JsonConvert.SerializeObject(PList);
            Console.WriteLine(Json);

            Console.ReadKey();
        }
    }

    public partial class HelloChinaModel
    {
        public int Id { get; set; }
        public string Province { get; set; }
        public string City { get; set; }
        public string District { get; set; }
        public string OrgName { get; set; }
        public Nullable<System.DateTime> AddTime { get; set; }
    }

    /// <summary>
    ////// </summary>
    public class Model_P
    {
        public string Province { get; set; }
        public List<Model_C> nodes { get; set; }
    }
    /// <summary>
    /// 市/区
    /// </summary>
    public class Model_C
    {
        public string City { get; set; }
        public List<Model_D> nodes { get; set; }
    }
    /// <summary>
    /// 县(县级市)/区
    /// </summary>
    public class Model_D
    {

        public string District { get; set; }
        public List<Model_O> nodes { get; set; }
    }
    /// <summary>
    /// 镇/乡/其他
    /// </summary>
    public class Model_O
    {
        public string OrgName { get; set; }
    }

}
View Code

构造的数据如下:

[
    {
        "Province": "河南省",
        "nodes": [
            {
                "City": "商丘市",
                "nodes": [
                    {
                        "District": "永城市",
                        "nodes": [
                            {
                                "OrgName": "薛湖镇"
                            }
                        ]
                    },
                    {
                        "District": "夏邑县",
                        "nodes": [
                            {
                                "OrgName": "火店乡"
                            }
                        ]
                    },
                    {
                        "District": "睢阳区",
                        "nodes": [
                            {
                                "OrgName": "龙华小区"
                            }
                        ]
                    }
                ]
            },
            {
                "City": "平顶山市",
                "nodes": [
                    {
                        "District": "新华区",
                        "nodes": [
                            {
                                "OrgName": "河南城建学院"
                            }
                        ]
                    },
                    {
                        "District": "鲁山县",
                        "nodes": [
                            {
                                "OrgName": "炉山镇"
                            }
                        ]
                    }
                ]
            },
            {
                "City": "洛阳市",
                "nodes": [
                    {
                        "District": "阳逻县",
                        "nodes": [
                            {
                                "OrgName": "大杨镇"
                            }
                        ]
                    }
                ]
            }
        ]
    },
    {
        "Province": "江苏省",
        "nodes": [
            {
                "City": "苏州市",
                "nodes": [
                    {
                        "District": "张家港市",
                        "nodes": [
                            {
                                "OrgName": "乐余镇"
                            }
                        ]
                    },
                    {
                        "District": "昆山市",
                        "nodes": [
                            {
                                "OrgName": "小上海镇"
                            }
                        ]
                    }
                ]
            },
            {
                "City": "南京市",
                "nodes": [
                    {
                        "District": "雨花台区",
                        "nodes": [
                            {
                                "OrgName": "雨花台小区"
                            }
                        ]
                    }
                ]
            },
            {
                "City": "徐州市",
                "nodes": [
                    {
                        "District": "沛县",
                        "nodes": [
                            {
                                "OrgName": "王文学镇"
                            }
                        ]
                    }
                ]
            }
        ]
    },
    {
        "Province": "山东省",
        "nodes": [
            {
                "City": "日照市",
                "nodes": [
                    {
                        "District": "花果山县",
                        "nodes": [
                            {
                                "OrgName": "猴子镇"
                            }
                        ]
                    }
                ]
            },
            {
                "City": "青岛市",
                "nodes": [
                    {
                        "District": "青岛啤酒县",
                        "nodes": [
                            {
                                "OrgName": "扎啤镇"
                            }
                        ]
                    }
                ]
            }
        ]
    }
]

@陈卧龙的博客

版权声明:本文首发在云栖社区,遵循云栖社区版权声明:本文内容由互联网用户自发贡献,版权归用户作者所有,云栖社区不为本文内容承担相关法律责任。云栖社区已升级为阿里云开发者社区。如果您发现本文中有涉嫌抄袭的内容,欢迎发送邮件至:developer2020@service.aliyun.com 进行举报,并提供相关证据,一经查实,阿里云开发者社区将协助删除涉嫌侵权内容。

分享:
大数据
使用钉钉扫一扫加入圈子
+ 订阅

大数据计算实践乐园,近距离学习前沿技术

其他文章