/// <summary> /// 修改权限 /// </summary> /// <param name="model"></param> /// <param name="power"></param> /// <returns></returns> public int UpdateRoles(Role model, int[] power) { var role = db.Role.Where(m => m.RoleId == model.RoleId).FirstOrDefault(); if (role != null) { role.RoleName = model.RoleName; role.RoleContent = model.RoleContent; role.RolePid = model.RolePid; role.RoleModifyPeople = model.RoleModifyPeople; role.RoleModifyTime = model.RoleModifyTime; db.Database.ExecuteSqlCommand($"DELETE from rolepower where Role_Id={model.RoleId}"); List <Rolepower> rplist = new List <Rolepower>(); for (int i = 0; i < power.Length; i++) { Rolepower rp = new Rolepower(); rp.RoleId = model.RoleId; rp.PowerId = power[i]; rplist.Add(rp); } db.Rolepower.AddRange(rplist); return(db.SaveChanges()); } return(0); }
/// <summary> /// 添加角色 关联 /// </summary> /// <param name="rid"></param> /// <param name="power"></param> /// <returns></returns> public int AddRolepower(int rid, int[] power) { List <Rolepower> rplist = new List <Rolepower>(); for (int i = 0; i < power.Length; i++) { Rolepower rp = new Rolepower(); rp.RoleId = rid; rp.PowerId = power[i]; rplist.Add(rp); } db.Rolepower.AddRange(rplist); //db.Database.ExecuteSqlCommand("insert into rolepower(Role_Id,Power_Id) values(@RoleId,@RolePowerId)", rplist); return(db.SaveChanges()); }