layui eleTree 写后台权限设置一

最新推荐文章于 2024-05-23 12:27:27 发布

置顶行走的生活

最新推荐文章于 2024-05-23 12:27:27 发布

阅读量395

点赞数

分类专栏： layui c# 文章标签： eleTree layui

本文链接：https://blog.csdn.net/qq_36694046/article/details/102819853

版权

c# 同时被 2 个专栏收录

13 篇文章 0 订阅

订阅专栏

layui

11 篇文章 0 订阅

订阅专栏

 public ActionResult GetTreeJson()
        {
            //查询一级菜单
            DataTable TreeOne = DBHelper.getDataTable("select * from menu where parentid=0 and status=1");
            //查询按钮
            DataTable Buttion = DBHelper.getDataTable("select * from button where status=1");
            var menuList = new List<TreeEntity>();
            foreach (DataRow item in TreeOne.Rows)
            {
                TreeEntity tree = new TreeEntity
                {
                    //icon = item["icon"].ToStr(),
                    id = "y:" + item["id"].ToInt32(),
                    label = item["mname"].ToStr(),
                    //sort = item["sort"].ToStr(),
                    pid = "0",
                    //url = item["path"].ToStr(),
                    //spread = true,
                };
                //查询二级菜单
                DataTable TreeTwo = DBHelper.getDataTable("select * from menu where parentid=?parentid and status=1", DBHelper.CreateParameter("parentid", item["id"].ToInt32()));
                var childrenList = new List<TreeEntity>();
                foreach (DataRow ChildItem in TreeTwo.Rows)
                {

                    TreeEntity ChindrenTree = new TreeEntity
                    {
                        //icon = ChildItem["icon"].ToStr(),
                        id = "e:" + ChildItem["id"].ToInt32() + ",y:" + item["id"].ToInt32(),
                        label = ChildItem["mname"].ToStr(),
                        // sort = ChildItem["sort"].ToStr(),
                        pid = ChildItem["parentid"].ToStr(),
                        //url = ChildItem["path"].ToStr(),
                        //children = null,
                        // spread = true,
                    };
                    var childrenButtons = new List<TreeEntity>();

                    foreach (DataRow btns in Buttion.Rows)
                    {
                        TreeEntity treebtn = new TreeEntity
                        {
                            id = "a:" + btns["id"].ToInt32() + ",e:" + ChildItem["id"].ToInt32(),
                            label = btns["btnname"].ToStr()
                        };
                        childrenButtons.Add(treebtn);
                    }
                    ChindrenTree.children = childrenButtons;
                    childrenList.Add(ChindrenTree);
                    //childrenButtons.Clear();
                }
                tree.children = childrenList;
                menuList.Add(tree);
            }
            string json = @"{""status"":""0"",""data"":" + JsonConvert.SerializeObject(menuList) + "}";
            var menuJson = Newtonsoft.Json.JsonConvert.SerializeObject(json);

            return Json(json);
        }

查询数据

后续