public ActionResult Delete(List <int> ids) { using (var db = new XkSystem.Models.DbContext()) { var tb = (from p in db.Table <Sys.Entity.tbSysMenu>() where ids.Contains(p.Id) select p).ToList(); foreach (var a in tb) { a.IsDeleted = true; //级联删除相关菜单 } if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("删除菜单"); } var cache = System.Web.HttpContext.Current.Cache; cache["Power"] = SysRolePowerController.GetPower(); return(Code.MvcHelper.Post()); } }
public ActionResult Insert1(List <int> ids, int UserId) { using (var db = new XkSystem.Models.DbContext()) { var error = new List <string>(); var user = db.Set <Sys.Entity.tbSysUser>().Find(UserId); var userRoleList = db.Table <Sys.Entity.tbSysUserRole>() .Where(d => d.tbSysUser.Id == UserId).ToList(); foreach (var v in userRoleList) { v.IsDeleted = true; } var tbUserRoleList = new List <Sys.Entity.tbSysUserRole>(); foreach (var v in ids) { tbUserRoleList.Add(new Sys.Entity.tbSysUserRole() { tbSysRole = db.Set <Sys.Entity.tbSysRole>().Find(v), tbSysUser = user }); } db.Set <Sys.Entity.tbSysUserRole>().AddRange(tbUserRoleList); if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了角色成员"); System.Web.HttpContext.Current.Cache["Power"] = SysRolePowerController.GetPower(); } return(Code.MvcHelper.Post(error)); } }
public ActionResult Edit(Models.SysUserPower.Edit vm) { using (var db = new XkSystem.Models.DbContext()) { var power = (from p in db.Table <Sys.Entity.tbSysUserPower>() where p.tbSysUser.Id == vm.UserId select p).ToList(); foreach (var a in power) { a.IsDeleted = true; } var menuList = vm.Power.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(d => d.ConvertToInt()); foreach (var menu in menuList) { var temp = new Sys.Entity.tbSysUserPower(); temp.tbSysMenu = db.Set <Sys.Entity.tbSysMenu>().Find(menu); temp.tbSysUser = db.Set <Sys.Entity.tbSysUser>().Find(vm.UserId); db.Set <Sys.Entity.tbSysUserPower>().Add(temp); } if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加角色权限"); System.Web.HttpContext.Current.Cache["Power"] = SysRolePowerController.GetPower(); } return(Code.MvcHelper.Post()); } }
public ActionResult Insert(List <int> ids, int roleId) { using (var db = new XkSystem.Models.DbContext()) { var error = new List <string>(); var vm = new Models.SysUser.Edit(); var userRoleList = (from p in db.Table <Sys.Entity.tbSysUserRole>() where p.tbSysRole.Id == roleId select p.tbSysUser.Id).ToList(); var userList = (from p in db.Table <Sys.Entity.tbSysUser>() where ids.Contains(p.Id) && userRoleList.Contains(p.Id) == false select p).ToList(); foreach (var user in userList) { var tb = new Sys.Entity.tbSysUserRole(); tb.tbSysRole = db.Set <Sys.Entity.tbSysRole>().Find(roleId); tb.tbSysUser = user; db.Set <Sys.Entity.tbSysUserRole>().Add(tb); } if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了角色成员"); System.Web.HttpContext.Current.Cache["Power"] = SysRolePowerController.GetPower(); } return(Code.MvcHelper.Post(error)); } }
public ActionResult SetDisable(int RoleId, int MenuId, bool Status) { using (var db = new XkSystem.Models.DbContext()) { var menuIds = GetChildrenMenuId(MenuId); if (Status)//授权 { //如果菜单不是一级菜单,激活时同时激活它的一级菜单 if (db.Set <Entity.tbSysMenu>().Find(MenuId).tbMenuParent != null) { var id = db.Table <Entity.tbSysMenu>() .Include(d => d.tbMenuParent) .Where(d => d.Id == MenuId).FirstOrDefault().tbMenuParent.Id; menuIds.Add(id); } var tb = db.Table <Sys.Entity.tbSysRolePower>() .Include(d => d.tbSysMenu) .Where(d => d.tbSysRole.Id == RoleId).ToList(); var tempList = new List <Sys.Entity.tbSysRolePower>(); foreach (var v in menuIds) { if (tb.Where(d => d.tbSysMenu.Id == v).Count() == 0) { var temp = new Sys.Entity.tbSysRolePower() { tbSysMenu = db.Set <Sys.Entity.tbSysMenu>().Find(v), tbSysRole = db.Set <Sys.Entity.tbSysRole>().Find(RoleId) }; tempList.Add(temp); } } db.Set <Sys.Entity.tbSysRolePower>().AddRange(tempList); } else//取消授权 { var tb = db.Table <Sys.Entity.tbSysRolePower>() .Where(d => menuIds.Contains(d.tbSysMenu.Id) && d.tbSysRole.Id == RoleId).ToList(); foreach (var v in tb) { v.IsDeleted = true; } } if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改了角色权限"); System.Web.HttpContext.Current.Cache["Power"] = SysRolePowerController.GetPower(); } return(Code.MvcHelper.Post(null, Url.Action("MenuRoleList", new { MenuId = MenuId }))); } }
public ActionResult Edit(Models.SysRole.Edit vm) { using (var db = new XkSystem.Models.DbContext()) { var error = new List <string>(); if (error.Count == decimal.Zero) { if (db.Table <Sys.Entity.tbSysRole>().Where(d => d.RoleName == vm.RoleEdit.RoleName && d.Id != vm.RoleEdit.Id).Any()) { error.AddError("该角色已存在!"); } else { if (vm.RoleEdit.Id == 0) { var tb = new Sys.Entity.tbSysRole(); tb.RoleName = vm.RoleEdit.RoleName; db.Set <Sys.Entity.tbSysRole>().Add(tb); if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加角色"); System.Web.HttpContext.Current.Cache["Power"] = SysRolePowerController.GetPower(); } } else { var tb = (from p in db.Table <Sys.Entity.tbSysRole>() where p.Id == vm.RoleEdit.Id select p).FirstOrDefault(); if (tb != null) { tb.RoleName = vm.RoleEdit.RoleName; if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改角色"); } } else { error.AddError(Resources.LocalizedText.MsgNotFound); } } } } return(Code.MvcHelper.Post(error)); } }
public ActionResult Delete(List <int> ids) { using (var db = new XkSystem.Models.DbContext()) { var tb = (from p in db.Table <Sys.Entity.tbSysRole>() where ids.Contains(p.Id) select p).ToList(); var rolePowerList = (from p in db.Table <Sys.Entity.tbSysRolePower>() .Include(d => d.tbSysRole) where ids.Contains(p.tbSysRole.Id) select p).ToList(); var roleUserList = (from p in db.Table <Sys.Entity.tbSysUserRole>() .Include(d => d.tbSysRole) where ids.Contains(p.tbSysRole.Id) select p).ToList(); foreach (var a in tb) { a.IsDeleted = true; foreach (var power in rolePowerList.Where(d => d.tbSysRole.Id == a.Id)) { power.IsDeleted = true; } foreach (var user in roleUserList.Where(d => d.tbSysRole.Id == a.Id)) { user.IsDeleted = true; } } if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("删除角色"); System.Web.HttpContext.Current.Cache["Power"] = SysRolePowerController.GetPower(); } return(Code.MvcHelper.Post()); } }
public ActionResult SetShortcut(int id) { using (var db = new XkSystem.Models.DbContext()) { var tb = db.Set <Sys.Entity.tbSysMenu>().Find(id); if (tb != null) { tb.IsShortcut = !tb.IsShortcut; if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改菜单快捷"); } } var cache = System.Web.HttpContext.Current.Cache; cache["Power"] = SysRolePowerController.GetPower(); return(Code.MvcHelper.Post()); } }
public void RestartCache() { try { using (var db = new XkSystem.Models.DbContext()) { var cache = System.Web.HttpContext.Current.Cache; var tenant = (from p in db.TableRoot <Areas.Admin.Entity.tbTenant>() orderby p.IsDefault descending, p.No select new { p.TenantName, p.Title }).ToList(); if (tenant.Count > decimal.Zero) { cache["AppTitle"] = tenant.FirstOrDefault().Title; if (tenant.Count == 1) { cache["TenantName"] = tenant.FirstOrDefault().TenantName; } else { cache.Remove("TenantName"); } } cache["Config"] = Areas.Admin.Controllers.ConfigController.GetConfig(); cache["Power"] = SysRolePowerController.GetPower(); } } catch { } }
public ActionResult Edit(Models.SysMenu.Edit vm) { using (var db = new XkSystem.Models.DbContext()) { var error = new List <string>(); if (error.Count == decimal.Zero) { if (vm.MenuEdit.Id == 0) { var tb = new Sys.Entity.tbSysMenu(); tb.No = vm.MenuEdit.No == null?db.Table <Sys.Entity.tbSysMenu>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.MenuEdit.No; tb.MenuName = vm.MenuEdit.MenuName; tb.tbProgram = db.Set <Admin.Entity.tbProgram>().Find(Code.Common.ProgramId); tb.MenuUrl = vm.MenuEdit.MenuUrl; tb.tbMenuParent = db.Set <Sys.Entity.tbSysMenu>().Find(vm.MenuEdit.MenuParentId); tb.Icon = vm.MenuEdit.Icon; tb.IsDisable = vm.MenuEdit.IsDisable; tb.IsShortcut = vm.MenuEdit.IsShortcut; tb.Remark = vm.MenuEdit.Remark; db.Set <Sys.Entity.tbSysMenu>().Add(tb); if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加菜单"); } } else { var tb = (from p in db.Table <Sys.Entity.tbSysMenu>() where p.Id == vm.MenuEdit.Id select p).FirstOrDefault(); if (tb != null) { tb.No = vm.MenuEdit.No == null?db.Table <Sys.Entity.tbSysMenu>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.MenuEdit.No; tb.MenuName = vm.MenuEdit.MenuName; tb.tbProgram = db.Set <Admin.Entity.tbProgram>().Find(Code.Common.ProgramId); tb.MenuUrl = vm.MenuEdit.MenuUrl; tb.tbMenuParent = db.Set <Sys.Entity.tbSysMenu>().Find(vm.MenuEdit.MenuParentId); tb.Icon = vm.MenuEdit.Icon; tb.IsDisable = vm.MenuEdit.IsDisable; tb.IsShortcut = vm.MenuEdit.IsShortcut; tb.Remark = vm.MenuEdit.Remark; if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改菜单"); } } else { error.AddError(Resources.LocalizedText.MsgNotFound); } } } var cache = System.Web.HttpContext.Current.Cache; cache["Power"] = SysRolePowerController.GetPower(); return(Code.MvcHelper.Post(error)); } }