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 Edit(int id = 0) { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.SysUser.Edit(); vm.SexList = Dict.Controllers.DictSexController.SelectList(); if (id != 0) { var tb = (from p in db.Table <Sys.Entity.tbSysUser>() where p.Id == id select new Dto.SysUser.Edit { Id = p.Id, Email = p.Email, IdentityNumber = p.IdentityNumber, IsDisable = p.IsDisable, IsLock = p.IsLock, Mobile = p.Mobile, Qq = p.Qq, SexId = p.tbSex.Id, UserCode = p.UserCode, UserName = p.UserName }).FirstOrDefault(); if (tb != null) { vm.UserEdit = tb; } } return(View(vm)); } }
public ActionResult Edit(Models.SysUser.Edit vm) { using (var db = new XkSystem.Models.DbContext()) { var error = new List <string>(); if (error.Count == decimal.Zero) { var tb = (from p in db.Table <Sys.Entity.tbSysUser>() .Include(d => d.tbSex) where p.Id == vm.UserEdit.Id select p).FirstOrDefault(); if (tb != null) { tb.UserCode = vm.UserEdit.UserCode; tb.UserName = vm.UserEdit.UserName; tb.tbSex = db.Set <Dict.Entity.tbDictSex>().Find(vm.UserEdit.SexId); tb.IdentityNumber = vm.UserEdit.IdentityNumber; tb.Email = vm.UserEdit.Email; tb.Mobile = vm.UserEdit.Mobile; tb.Qq = vm.UserEdit.Qq; tb.IsDisable = vm.UserEdit.IsDisable; tb.IsLock = vm.UserEdit.IsLock; if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改用户"); } } else { error.AddError(Resources.LocalizedText.MsgNotFound); } } return(Code.MvcHelper.Post(error)); } }