/// <summary> /// 修改角色 /// </summary> /// <param name="pwRoleTypeTable"></param> /// <returns></returns> public ActionResult UpdateRole() { string str = ""; try { S_UserroleList pwRoleTypeTable = new S_UserroleList(); pwRoleTypeTable.UserroleID = Convert.ToInt32(Request.Form["UserroleID"]); pwRoleTypeTable.DepartmenttypeID = Convert.ToInt32(Request.Form["DepartmenttypeID"]); pwRoleTypeTable.Userrole = Request.Form["Userrole"]; MyModels.Entry(pwRoleTypeTable).State = System.Data.Entity.EntityState.Modified; MyModels.SaveChanges(); S_JournalList pwJournalTable = new S_JournalList(); pwJournalTable.usernameID = Convert.ToInt32(Session["usernameID"]); pwJournalTable.Operate = "修改角色"; pwJournalTable.OperateDate = DateTime.Now; MyModels.S_JournalList.Add(pwJournalTable); MyModels.SaveChanges(); str = "修改成功"; } catch (Exception e) { Console.WriteLine(e); str = "数据异常,请检查"; } return(Json(str, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 新增角色 /// </summary> /// <param name="pwRoleTypeTable"></param> /// <returns></returns> public ActionResult InserRole(S_UserroleList pwUserroleList) { string str = ""; try { MyModels.S_UserroleList.Add(pwUserroleList); MyModels.SaveChanges(); //保存角色类型表 B_DiseaseDetailList pwDiseaseDetailList = new B_DiseaseDetailList(); //疾病明细表 var list = (from tb in MyModels.S_DiseaseList //疾病表 select tb).ToList(); for (int i = 0; i < list.Count; i++) { pwDiseaseDetailList.UserroleID = pwUserroleList.UserroleID; //角色类型ID pwDiseaseDetailList.DiseaseID = 0; //疾病ID 0为没有该权限 if (pwDiseaseDetailList.UserroleID > 0 && pwDiseaseDetailList.DiseaseID != null) { MyModels.B_DiseaseDetailList.Add(pwDiseaseDetailList); MyModels.SaveChanges();//保存疾病明细表 } } B_RoleAuthorityList pwRoleAutTable = new B_RoleAuthorityList(); //角色权限表 var listAuthorizationTable = (from tb in MyModels.B_AuthorityList //权限表 select tb).ToList(); for (int z = 0; z < listAuthorizationTable.Count; z++) { pwRoleAutTable.UserroleID = pwUserroleList.UserroleID; //角色类型id pwRoleAutTable.authorityID = 0; //权限id if (pwRoleAutTable.UserroleID > 0 && pwRoleAutTable.authorityID != null) { MyModels.B_RoleAuthorityList.Add(pwRoleAutTable); MyModels.SaveChanges();//保存角色权限表 } } S_JournalList pwJournalTable = new S_JournalList(); pwJournalTable.usernameID = Convert.ToInt32(Session["usernameID"]); pwJournalTable.Operate = "添加角色"; pwJournalTable.OperateDate = DateTime.Now; MyModels.S_JournalList.Add(pwJournalTable); MyModels.SaveChanges(); str = "添加成功"; } catch (Exception e) { Console.WriteLine(e); str = "数据异常,请检查"; } return(Json(str, JsonRequestBehavior.AllowGet)); }