public JsonResult GetList() { int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]); int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]); ////字段排序 //String sortField = Request["sortField"]; //String sortOrder = Request["sortOrder"]; PageClass pc = new PageClass(); pc.sys_Fields = "*"; pc.sys_Key = "Id"; pc.sys_PageIndex = pageIndex; pc.sys_PageSize = pageSize; pc.sys_Table = "V_Role"; pc.sys_Where = "1=1"; pc.sys_Order = "Id"; if (!UserData.RoleId.ToString().Equals("fb38f312-0078-4f44-9cda-1183c8042db8"))//不是系统管理员,不请允许显示系统管理员 { pc.sys_Where += " and Id!='fb38f312-0078-4f44-9cda-1183c8042db8'"; } List <V_Role> list2 = RDBiz.GetPagingData <V_Role>(pc); Dictionary <string, object> dic = new Dictionary <string, object>(); // var mql = RMS_RoleSet.ControlId.NotEqual(""); dic.Add("rows", list2); dic.Add("total", pc.RCount); return(Json(dic, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取列 /// </summary> /// <returns></returns> public string GetBtnColumn() { string menus = " [\n"; var sql = RMS_ButtonsSet.SelectAll(); List <RMS_Buttons> list = RDBiz.GetOwnList <RMS_Buttons>(sql); if (list != null) { menus += "{ "; menus += "title:\"名称\",field:\"Name\", width: 100"; menus += "},"; menus += "{ "; menus += "title:\"浏览\",field:\"ControlId_Browse\", width: 30,editor:{type:'checkbox',options:{on:'1',off:'0'}}, formatter: formatCheck"; menus += "},"; foreach (RMS_Buttons item in list) { menus += "{ "; menus += "title:\"" + item.ButtonName + "\",field:\"ControlId_" + item.Id + "\", width: 30,editor:{type:'checkbox',options:{on:'1',off:'0'}}, formatter: formatCheck"; menus += "},"; } } menus = menus.Substring(0, menus.Length - 1); menus = menus + "]"; return(menus); }
public JsonResult DeleteInfo(string ID) { var mql2 = RMS_RoleSet.Id.Equal(ID); int f = RDBiz.Remove <RMS_RoleSet>(mql2); return(Json("OK", JsonRequestBehavior.AllowGet)); }
public JsonResult GetInfo(string ID) { var mql2 = RMS_RoleSet.SelectAll().Where(RMS_RoleSet.Id.Equal(ID)); RMS_Role Rmodel = RDBiz.GetEntity(mql2); // groupsBiz.Add(rol); return(Json(Rmodel, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteInfo(string ID) { var mql2 = RMS_RoleSet.Id.Equal(ID); int f = RDBiz.Remove <RMS_RoleSet>(mql2); SysOperateLogBiz.AddSysOperateLog(UserData.Id.ToString(), UserData.UserName, e3net.Mode.OperatEnumName.除, "角色管理--删除", true, WebClientIP, "角色管理"); return(Json("OK", JsonRequestBehavior.AllowGet)); }
public JsonResult EditInfo(RMS_Role RMS_RoleModle) { HttpReSultMode ReSultMode = new HttpReSultMode(); bool IsAdd = false; RMS_RoleModle.ModifyTime = DateTime.Now; if (!(RMS_RoleModle.Id != null && !RMS_RoleModle.Id.ToString().Equals("00000000-0000-0000-0000-000000000000")))//id为空,是添加 { IsAdd = true; RMS_RoleModle.CreateTime = DateTime.Now; RMS_RoleModle.Id = Guid.NewGuid(); } if (IsAdd) { RMS_RoleModle.ModifyBy = "1"; RMS_RoleModle.CreateBy = "1"; try { RDBiz.Add(RMS_RoleModle); ReSultMode.Code = 11; ReSultMode.Data = RMS_RoleModle.Id.ToString(); ReSultMode.Msg = "添加成功"; SysOperateLogBiz.AddSysOperateLog(UserData.Id.ToString(), UserData.UserName, e3net.Mode.OperatEnumName.新增, "角色管理--新增", true, WebClientIP, "角色管理"); } catch (Exception e) { ReSultMode.Code = -11; ReSultMode.Data = e.ToString(); ReSultMode.Msg = "添加失败"; SysOperateLogBiz.AddSysOperateLog(UserData.Id.ToString(), UserData.UserName, e3net.Mode.OperatEnumName.新增, "角色管理--新增", false, WebClientIP, "角色管理"); } } else { RMS_RoleModle.WhereExpression = RMS_RoleSet.Id.Equal(RMS_RoleModle.Id); RMS_RoleModle.ChangedMap.Remove("id");//移除主键值 if (RDBiz.Update(RMS_RoleModle) > 0) { ReSultMode.Code = 11; ReSultMode.Data = ""; ReSultMode.Msg = "修改成功"; SysOperateLogBiz.AddSysOperateLog(UserData.Id.ToString(), UserData.UserName, e3net.Mode.OperatEnumName.修改, "角色管理--修改", true, WebClientIP, "角色管理"); } else { ReSultMode.Code = -13; ReSultMode.Data = ""; ReSultMode.Msg = "修改失败"; SysOperateLogBiz.AddSysOperateLog(UserData.Id.ToString(), UserData.UserName, e3net.Mode.OperatEnumName.修改, "角色管理--修改", false, WebClientIP, "角色管理"); } } return(Json(ReSultMode, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取某个角色的权限 数据不要乱改啊!! /// </summary> /// <param name="Id">角色的Id</param> /// <returns></returns> public string GetManeOP(string Id) { string menus = " [\n"; var sql = RMS_MenusSet.SelectAll(); string SysRoleId = ConfigurationManager.AppSettings["SysRoleId"].ToString(); if (!UserData.RoleId.ToString().Equals(SysRoleId))//不是系统管理员的角色,只能返回自己的菜单 { sql = RMS_MenusSet.SelectAll().Where(RMS_MenusSet.Id.In(RMS_RoleManusSet.Select(RMS_RoleManusSet.ManuId).Where(RMS_RoleManusSet.RoleId.Equal(UserData.RoleId)))); } List <RMS_Menus> list = RDBiz.GetOwnList <RMS_Menus>(sql); //所有的菜单集 List <RMS_Buttons> listControlButtons = RDBiz.GetOwnList <RMS_Buttons>(RMS_ButtonsSet.SelectAll()); //所有的按钮 List <RMS_RoleManus> listRoleColumns = RDBiz.GetOwnList <RMS_RoleManus>(RMS_RoleManusSet.SelectAll().Where(RMS_RoleManusSet.RoleId.Equal(Id))); //这个角色已经添加的菜单 List <V_RoleManuButtons> listRoleMenuButtons = RDBiz.GetOwnList <V_RoleManuButtons>(V_RoleManuButtonsSet.SelectAll().Where(V_RoleManuButtonsSet.RoleId.Equal(Id))); //这个角色已经添加的角色按钮 for (int i = 0; i < list.Count; i++) { if (list.Find(p => p.Id == list[i].ParentManuId) == null)//此项没有父级 { menus += "{ \"MenuId\":\"" + list[i].Id + "\","; menus += string.Format(" \"Name\":\"{0}\",", list[i].ManuName); menus += string.Format(" \"iconCls\":\"{0}\",", list[i].Icon); string ControlId_Browse = "0"; RMS_RoleManus rcItem = listRoleColumns.Find(p => p.ManuId.Equals(list[i].Id)); if (rcItem != null) { ControlId_Browse = "1";//如果存在 } menus += string.Format(" \"ControlId_Browse\":\"{0}\",", ControlId_Browse); foreach (RMS_Buttons dd in listControlButtons)//添加列的数据 { string Ishave = "0"; V_RoleManuButtons rmbItem = listRoleMenuButtons.Find(p => p.Id.Equals(dd.Id) && p.ManuId.Equals(list[i].Id)); if (rmbItem != null) { Ishave = "1";//如果角色有此按钮存在 } menus += string.Format("\"ControlId_{0}\":\"{1}\",", dd.Id, Ishave); } menus += GetSonTreeManu(list, list[i], listControlButtons, listRoleColumns, listRoleMenuButtons);//添加children menus += "},"; } } menus = menus.Substring(0, menus.Length - 1); menus = menus + "]"; return(menus); }
/// <summary> /// 获取每个菜单有的按钮 /// </summary> /// <returns></returns> public JsonResult GetMenuButtonsData() { List <RMS_MenuButtons> listMenuButtons = RDBiz.GetOwnList <RMS_MenuButtons>(RMS_MenuButtonsSet.SelectAll());//所有的菜单的按钮 return(Json(listMenuButtons)); }