C#.NET MVC树形节点

最新推荐文章于 2019-03-17 16:51:00 发布

蓝田*梦里@

最新推荐文章于 2019-03-17 16:51:00 发布

阅读量1k

点赞数 1

本文链接：https://blog.csdn.net/weixin_43276383/article/details/87896987

版权

本文介绍如何在C#.NET MVC框架下利用Bootstrap创建树形节点，包括Controller层和视图层的设计，展示了最终的交互效果。

摘要由CSDN通过智能技术生成

开发工具：Visual Studio、 SQL Server
技术架构：C# .NET MVC、Bootstrap
Controller层

/// <summary>
        /// 查询前台科室
        /// </summary>
        /// <returns></returns>
        public ActionResult SelectDepartmentType()
        {
            List<SelectVo> list = (from tb in myModels.S_Administrative
                                   where tb.PositionID == 1//前台
                                   select new SelectVo
                                   {
                                       id = tb.AdministrativeID,
                                       text = tb.AdministrativeName
                                   }).ToList();
            list = Common.Tools.SetSelectJson(list);
            return Json(list, JsonRequestBehavior.AllowGet);
        }
        /// <summary>
        /// 查询后台科室
        /// </summary>
        /// <returns></returns>
        public ActionResult SelectDepartment()
        {
            List<SelectVo> list = (from tb in myModels.S_Administrative
                                   where tb.PositionID == 2//后台
                                   select new SelectVo
                                   {
                                       id = tb.AdministrativeID,
                                       text = tb.AdministrativeName
                                   }).ToList();
            list = Common.Tools.SetSelectJson(list);
            return Json(list, JsonRequestBehavior.AllowGet);
        }
        /// <summary>
        /// 系统角色树形
        /// </summary>
        int l = 0;
        int v = 0;
        string strfujie = "";
        public ActionResult SelectSystemRole()
        {
            List<TreeVo> listNoticeType = new List<TreeVo>();
            List<TreeVo> listNoticeType1 = new List<TreeVo>();
            var listZhiWei = (from tb in myModels.S_ComboboxDetail
                              where tb.ComboboxID == 1//1 为前台职位或后台职位
                              select new TreeVo
                              {
                                  id = "1",//当前的id
                                  idp = tb.ComboboxDetailID,//数据库的id
                                  name = tb.ComboboxDetailMC.Trim(),
                                  isParent = true,//是否为父节点
                                  open = true,//打开节点
                                  pId = "0"//父id
                              }).ToList();
            for (int i = 0; i < listZhiWei.Count; i++)
            {
                listZhiWei[i].id = (i + 1).ToString();
                listNoticeType.Add(listZhiWei[i]);
                DepartmentType(listZhiWei[i].idp);
                listNoticeType1 = Session["sss"] as List<TreeVo>;
                for (int j = 0; j < listNoticeType1.Count; j++)
                {
                    listNoticeType.Add(listNoticeType1[j]);
                }
            }

            return Json(listNoticeType, JsonRequestBehavior.AllowGet);
        }
        /// <summary>
        /// 新增角色
        /// </summary>
        /// <param name="pwRoleTypeTable"></param>
        /// <returns></returns>
        public ActionResult InserRole(S_RoleType pwRoleTypeTable)
        {
            string str = "";
            try
            {
                myModels.S_RoleType.Add(pwRoleTypeTable);
                myModels.SaveChanges();//保存角色类型表
                S_IllnessTypeDetail pwDiseaseDetailTable = new S_IllnessTypeDetail();//疾病明细表
                var list = (from tb in myModels.S_IllnessType//疾病表
                            select tb).ToList();
                for (int i = 0; i < list.Count; i++)
                {
                    pwDiseaseDetailTable.RoleTypeID = pwRoleTypeTable.RoleTypeID;//角色类型id
                    pwDiseaseDetailTable.IllnessTypeID = 0;//疾病ID  0为没有该权限
                    if (pwDiseaseDetailTable.RoleTypeID > 0 && pwDiseaseDetailTable.IllnessTypeID != null)
                    {
                        myModels.S_IllnessTypeDetail.Add(pwDiseaseDetailTable);

                        myModels.SaveChanges();//保存疾病明细表
                    }
                }
                S_Authority pwRoleAutTable = new S_Authority();//角色权限表
                var listAuthorizationTable = (from tb in myModels.S_Modular//权限表
                                              select tb).ToList();
                for (int z = 0; z < listAuthorizationTable.Count; z++)
                {
                    pwRoleAutTable.RoleTypeID = pwRoleTypeTable.RoleTypeID;//角色类型id

                    pwRoleAutTable.ModularID = 0;//权限id
                    if (pwRoleAutTable.RoleTypeID > 0 && pwRoleAutTable.ModularID != null)
                    {
                        myModels.S_Authority.Add(pwRoleAutTable);
                        myModels.SaveChanges();//保存角色权限表
                    }
                }
                str = "添加成功";
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                str = "数据异常，请检查";
            }
            return Json(str, JsonRequestBehavior.AllowGet);
        }
        public string DepartmentType(int PositionID)
        {
            l++;
            List<TreeVo> listNoticeType = new List<TreeVo>();
            string ssss = "";
            if (l == 1)
            {
                strfujie = "1";
            }
            else
            {
                strfujie = "2";
            }
            List<TreeVo> listNoticeType1 = new List<TreeVo>();
            List<TreeVo> listDepartmentType = (from tb in myModels.S_Administrative
                                                       where tb.PositionID == PositionID
                                                       select new TreeVo
                                                       {
                                                           id = "11",
                                                           idp = tb.AdministrativeID,
                                                           name = tb.AdministrativeName.Trim(),
                                                           isParent = true,
                                                           pId = strfujie
                                                       }).ToList();
            for (int z = 0; z < listDepartmentType.Count; z++)
            {
                if (strfujie == "1")
                {