public async Task <ActionResult> UpdateModule(string id) { //获取菜单已经绑定的按钮 var menubuttons = await SysMenuButtonDAL.QueryAsync(u => u.MenuID == Convert.ToInt32(id), null, null); //回去权限按钮字典 (List <SysDictionary> list, long count)buttons = await SysDictionaryDAL.QueryAsync(w => w.Status == 1 && w.Parent.DictNo == AuthorizeName.PermissionButton); ViewBag.ButtonList = buttons.list.Select(s => new SelectListItem { Text = s.DictName, Value = s.DictNo.ToString(), Selected = menubuttons.list.Exists(e => e.ButtonCode == s.DictNo) }).ToList(); (List <SysMenu> list, long count)menus = await SysMenuDAL.QueryAsync(w => w.Status == 1); ViewBag.SysMenuList = menus.list.Select(s => new SelectListItem { Text = s.MenuName, Value = s.Id.ToString() }).ToList(); SysMenuView model = new SysMenuView() { }; if (!string.IsNullOrEmpty(id) && id != "0") { int _id = Convert.ToInt32(id); var tempModel = await new SysMenuDAL().GetByOneAsync(w => w.Id == _id); model = _mapper.Map <SysMenuView>(tempModel); } return(View(model)); }
public async Task <ActionResult> CreateModule(string id, string parentid = "") { (List <SysDictionary> list, long count)buttons = await SysDictionaryDAL.QueryAsync(w => w.Status == 1 && w.Parent.DictNo == AuthorizeName.PermissionButton); ViewBag.ButtonList = buttons.list.Select(s => new SelectListItem { Text = s.DictName, Value = s.DictNo.ToString() }).ToList(); (List <SysMenu> list, long count)menus = await SysMenuDAL.QueryAsync(w => w.Status == 1); //var lists = menus.list.Select(s => new SysMenuTreeNode //{ // name = s.MenuName, // id = s.Id.ToString() //}).ToList(); ViewBag.SysMenuList = menus.list.Select(s => new SelectListItem { Text = s.MenuName, Value = s.Id.ToString() }).ToList(); SysMenuView model = new SysMenuView() { Status = 1 }; if (!string.IsNullOrEmpty(parentid)) { model.ParentID = Convert.ToInt32(parentid); } return(View(model)); }
public async Task <ActionResult> UpdateModule(string id) { var roleMenus = await SysRoleMenuDAL.QueryUserRole(u => u.RoleId == Convert.ToInt32(id), null, null); (List <SysMenu> list, long count)menus = await SysMenuDAL.QueryAsync(w => w.Status == 1); ViewBag.Menus = menus.list.Select(s => new SelectListItem { Selected = roleMenus.list.Exists(ss => ss.RoleId == s.Id), Text = s.MenuName, Value = s.Id.ToString() }).ToList(); SysRole model = new SysRole() { }; if (!string.IsNullOrEmpty(id) && id != "0") { int _id = Convert.ToInt32(id); model = await SysRoleDAL.GetByOneAsync(w => w.Id == _id); } return(View(model)); }
public async Task <ActionResult> GetTree(long id, int type = 1) { //已授权的角色菜单 var roleMenus = await SysRoleMenuDAL.QueryUserRole(u => u.RoleId == Convert.ToInt32(id), null, null); var roleButtons = await SysRoleButtonDAL.QueryAsync(u => u.RoleId == Convert.ToInt32(id), null, null); //所有状态为有效的菜单 (List <SysMenu> list, long count)menus = await SysMenuDAL.QueryAsync(w => w.Status == 1); var lists = menus.list.Select(s => { var btns = s.SysMenuButtons ?? new List <SysMenuButton>(); var newBtns = btns.Select(b => new TreeNode { id = b.Id.ToString(), name = b.ButtonCode, title = b.ButtonName, ischecked = roleButtons.list.Exists(e => e.ButtonId == b.Id) }).ToList(); var strbtns = Newtonsoft.Json.JsonConvert.SerializeObject(newBtns); return(new SysMenuTreeNode { ischecked = roleMenus.list.Exists(ss => ss.MenuId == s.Id), name = s.MenuName, title = s.MenuName, pid = (s.ParentID ?? 0).ToString(), id = s.Id.ToString(), //buttons = newBtns, jsonButtons = strbtns }); }).ToList(); return(Json(lists)); }
public SysMenuBLL() { handle = new SysMenuDAL(); }
public void Initialize() { var sysUserDAL = new SysUserDAL(); var sysMenuDAL = new SysMenuDAL(); var sysDictionary = new SysDictionaryDAL(); var siteInfoDAL = new SiteInfoDAL(); if (sysUserDAL.Count() == 0) { //初始化用户 sysUserDAL.Insert(new Entity.SysUser { UserName = "******", Password = "******", UserType = Entity.Enum.UserType.SuperUser, CreateBy = "admin", CreateDt = DateTime.Now, Email = "*****@*****.**" }); } if (sysMenuDAL.Count() == 0) { var menuList = new List <SysMenu>(); var menuid1 = sysMenuDAL.Insert(new SysMenu { MenuName = "权限管理", ParentID = 0, Description = "", MenuUrl = "#", IconUrl = "#", Sort = 1, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); var menuList1 = new List <SysMenu>(); menuList1.Add(new SysMenu { MenuName = "用户管理", ParentID = menuid1, Description = "", MenuUrl = "/Admin/SysUser/Index", IconUrl = "#", Sort = 2, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList1.Add(new SysMenu { MenuName = "角色管理", ParentID = menuid1, Description = "", MenuUrl = "/Admin/SysRole/Index", IconUrl = "#", Sort = 3, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList1.Add(new SysMenu { MenuName = "菜单管理", ParentID = menuid1, Description = "", MenuUrl = "/Admin/SysMenu/Index", IconUrl = "#", Sort = 4, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); sysMenuDAL.BatchInsert(menuList1); var menuList2 = new List <SysMenu>(); var menuid2 = sysMenuDAL.Insert(new SysMenu { MenuName = "文章管理", ParentID = 0, Description = "", MenuUrl = "#", IconUrl = "#", Sort = 1, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList2.Add(new SysMenu { MenuName = "文章列表", ParentID = menuid2, Description = "", MenuUrl = "/Admin/Article/Index", IconUrl = "#", Sort = 6, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList2.Add(new SysMenu { MenuName = "文章分类", ParentID = menuid2, Description = "", MenuUrl = "/Admin/ArticleType/Index", IconUrl = "#", Sort = 7, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); sysMenuDAL.BatchInsert(menuList2); var menuList3 = new List <SysMenu>(); var menuid3 = sysMenuDAL.Insert(new SysMenu { MenuName = "系统设置", ParentID = 0, Description = "", MenuUrl = "#", IconUrl = "#", Sort = 99, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList3.Add(new SysMenu { MenuName = "字典管理", ParentID = menuid3, Description = "", MenuUrl = "/Admin/SysDictionary/Index", IconUrl = "#", Sort = 9, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList3.Add(new SysMenu { MenuName = "站点信息", ParentID = menuid3, Description = "", MenuUrl = "/Admin/SiteInfo/Index", IconUrl = "#", Sort = 9, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); menuList3.Add(new SysMenu { MenuName = "更新日志", ParentID = menuid3, Description = "", MenuUrl = "/Admin/SysUpdateLog/Index", IconUrl = "#", Sort = 9, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); sysMenuDAL.BatchInsert(menuList3); } if (sysDictionary.Count() == 0) { var dic1 = (new SysDictionary { DictName = "权限按钮", DictNo = "PermissionButton", ParentID = 0, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); long id1 = sysDictionary.Insert(dic1); var dicList = new List <SysDictionary>(); dicList.Add(new SysDictionary { DictName = "新增", DictNo = "add", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "修改", DictNo = "update", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "删除", DictNo = "delete", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "导出", DictNo = "export", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "导入", DictNo = "import", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "打印", DictNo = "Print", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "审核", DictNo = "Auth", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList.Add(new SysDictionary { DictName = "查看", DictNo = "show", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); sysDictionary.BatchInsert(dicList); var dic2 = (new SysDictionary { DictName = "站点设置", DictNo = "SiteSetting", ParentID = 0, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); long id2 = sysDictionary.Insert(dic2); var dic3 = (new SysDictionary { DictName = "简语描述", DictNo = "Index_Sketch", ParentID = id2, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); long id3 = sysDictionary.Insert(dic3); var dicList2 = new List <SysDictionary>(); dicList2.Add(new SysDictionary { DictName = "字典配置1", DictNo = "01", ParentID = id3, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList2.Add(new SysDictionary { DictName = "字典配置2", DictNo = "02", ParentID = id3, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); dicList2.Add(new SysDictionary { DictName = "字典配置3", DictNo = "03", ParentID = id3, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin" }); sysDictionary.BatchInsert(dicList2); } if (siteInfoDAL.Count() == 0) { var siteinfo = (new SiteInfo { SiteName = "FreeSql", Status = 1, Headline = ".NETCore最方便的ORM", Abstract = "FreeSql 是一个功能强大的 .NETStandard 库,用于对象关系映射程序(O/RM),支持 .NETCore 2.1+ 或 .NETFramework 4.6.1+", CreateDt = DateTime.Now, CreateBy = "admin" }); siteInfoDAL.Insert(siteinfo); } }
public SysMenuBLL() { dal = new SysMenuDAL(); }