目的,是要把查詢后的JSON轉換成樹結構的選單.
資料庫的選單結構如下:
AuthID AuthName ParentID type AuthUrl Icon
1 系統管理 0 menu /System/UserInfoList 
2 用戶管理 1 menu /System/UserInfoList 
3 選單管理 1 menu /System/GetMenuList 
4 采購管理 0 menu /System/GetMenuList 
5 采購申請 4 menu /System/GetMenuList 
#region 獲取選單權限串列資訊
public ActionResult GetMenu()
{
//查詢所有選單資料
var AuthorizeInfo = authorize.Select(u => true);
var tempdata = from a in AuthorizeInfo
select new
{
Authid=a.AuthID,
ParentID = a.ParentID,
title = a.AuthName,
href = a.AuthUrl,
icon = a.Icon,
spread=false,
children=a.ParentID
};
return Json(tempdata, JsonRequestBehavior.AllowGet);
}
#endregion
查詢后,得到的JSON格式為:
[{"Authid":1,"ParentID":0,"title":"系統管理","href":"/System/UserInfoList","icon":"\u0026#xe716;","spread":false,"children":0},{"Authid":2,"ParentID":1,"title":"用戶管理","href":"/System/UserInfoList","icon":"\u0026#xe770;","spread":false,"children":1},{"Authid":3,"ParentID":1,"title":"選單管理","href":"/System/GetMenuList","icon":"\u0026#xe66b;","spread":false,"children":1},{"Authid":4,"ParentID":0,"title":"采購管理","href":"/System/GetMenuList","icon":"\u0026#xe657;","spread":false,"children":0},{"Authid":5,"ParentID":4,"title":"采購申請","href":"/System/GetMenuList","icon":"\u0026#xe657;","spread":false,"children":4}]
我想要的json格式為:
[
{
"title": "系統管理",
"icon": "",
"href": "",
"spread": false,
"children": [
{
"title": "用戶管理",
"icon": "",
"href": "/System/UserInfoList",
"spread": false
},
{
"title": "選單管理",
"icon": "",
"href": "/System/GetMenuList",
"spread": false
}
]
}
]
這里帶不出children下面的節點關系
求各位大神幫忙一下,謝謝
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/97802.html
標籤：ASP.NET