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(Models.SysUserRole.Edit vm)
{
using (var db = new XkSystem.Models.DbContext())
{
var error = new List <string>();
if (error.Count == decimal.Zero)
{
if (vm.SysUserRoleEdit.Id == 0)
{
var tb = new Sys.Entity.tbSysUserRole();
tb.tbSysRole = db.Set <Sys.Entity.tbSysRole>().Find("");
tb.tbSysUser = db.Set <Sys.Entity.tbSysUser>().Find("");
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();
}
}
else
{
var tb = (from p in db.Table <Sys.Entity.tbSysUserRole>()
where p.Id == vm.SysUserRoleEdit.Id
select p).FirstOrDefault();
if (tb != null)
{
tb.tbSysRole = db.Set <Sys.Entity.tbSysRole>().Find("");
tb.tbSysUser = db.Set <Sys.Entity.tbSysUser>().Find("");
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("更新用户角色");
}
}
else
{
error.AddError(Resources.LocalizedText.MsgNotFound);
}
}
}
return(Code.MvcHelper.Post(error));
}
}
