本文共 1025 字，大约阅读时间需要 3 分钟。

 由于将mysql的数据进行分组显示在树形结构中。所以使用了下面的查询方式。由于数据库设计的不好，感觉代码比较乱

public string Get()        {             string result = "";            using (var edm = new wlcloudEntities())            {                 var query1 = edm.group.GroupJoin(edm.project, a => a.Project, ch => ch.ID, (a, ch) => new                {                    id = a.ID,                    text = a.Name,                    children = ch.Select(order  => new { id = a.ID + "_"+ order.ID, text =order.Name }).ToList()                }).ToList();                result = JsonConvert.SerializeObject(query1);              }            return result;          }

这是返回的json数据 

[   {    "Groupid": 6,    "groupName": "主楼",    "children": []  },   {    "Groupid": 8,    "groupName": "主配电室",    "children": []  },  {    "Groupid": 9,    "groupName": "主配电室",    "children": [      {        "id": "9_6",        "Name": "风电项目"      }    ]  },   {    "Groupid": 13,    "groupName": "深井泵",    "children": [      {        "id": "13_8",        "Name": "210万吨焦化项目"      }    ]  }]

转载地址：http://tmumf.baihongyu.com/