[HttpPost]//查询 public ViewModel List(VIEW_SYS_ROLE data) { int pageSize = int.Parse(data.rows); int pageIndex = int.Parse(data.page); string sort = data.sort; string order = data.order; //查询条件 IQueryable <SYS_ROLE> SYS_ROLEEntity = oc.BllSession.ISYS_ROLEService.Entities; if (data.NAME != null && data.NAME != "") { SYS_ROLEEntity = SYS_ROLEEntity.Where(u => u.NAME.IndexOf(data.NAME) > -1); } int total = 0; total = SYS_ROLEEntity.Count(); var listROLE = SYS_ROLEEntity.OrderBy(u => u.ROLE_ID) .Skip(pageSize * (pageIndex - 1)).Take(pageSize) .Select(mb => new { ROLE_ID = mb.ROLE_ID, name = mb.NAME, note = mb.NOTE }).ToList(); return(ObjToJson.ViewModelToJson(listROLE, total)); }
public AjaxMsgModel Del(VIEW_SYS_ROLE data) { return(Model_SYS_ROLE.Del(data.ROLE_ID)); }
public AjaxMsgModel Edit(VIEW_SYS_ROLE data) { AjaxMsgModel amm = new Message().NewAmm; try { /* * //获取不显示list以及opt radio的关于GIS的menu id * List<string> ListNoShowlistOptId = new List<string>(); * ListNoShowlistOptId.AddRange(Constant.GISOneMenu.Split(',').ToList()); * VIEW_SYS_ROLE role = oc.BllSession.ISYS_ROLEService.Entities.Where(u => u.ROLE_ID == data.ROLE_ID).OrderBy(u => u.ROLE_ID) * .Select(u => * new VIEW_SYS_ROLE * { * ROLE_ID = u.ROLE_ID, * NAME = u.NAME, * NOTE = u.NOTE, * NoShowlistOptId = ListNoShowlistOptId * } * ).FirstOrDefault(); * * if (role != null) * { * List<string> listMenuId = oc.BllSession.ISYS_ROLE_MENU_MAPService.Entities.Where(u => u.ROLE_ID == data.ROLE_ID && u.MENU_ID.Length < 7).Select(u => u.MENU_ID).ToList(); * role.MenuId = listMenuId; * List<string> listMenuOptId = oc.BllSession.ISYS_ROLE_MENUOPT_MAPService.Entities.Where(u => u.ROLE_ID == data.ROLE_ID && u.MENUOPT_ID.EndsWith("004")).Select(u => u.MENUOPT_ID.Substring(0, 6)).ToList(); * * role.MenuOptId = listMenuOptId; * amm.Statu = AjaxStatu.ok; * amm.Data = role; * return amm; * } * else * { * amm.Msg = string.Format(Message.NotFound, "角色"); * return amm; * }*/ VIEW_SYS_ROLE role = oc.BllSession.ISYS_ROLEService.Entities.Where(u => u.ROLE_ID == data.ROLE_ID).OrderBy(u => u.ROLE_ID) .Select(u => new VIEW_SYS_ROLE { ROLE_ID = u.ROLE_ID, NAME = u.NAME, NOTE = u.NOTE } ).FirstOrDefault(); if (role != null) { List <string> listMenuId = oc.BllSession.ISYS_ROLE_MENU_MAPService.Entities.Where(u => u.ROLE_ID == data.ROLE_ID).Select(u => u.MENU_ID).ToList(); role.MenuId = listMenuId; List <string> listMenuOptId = oc.BllSession.ISYS_ROLE_MENUOPT_MAPService.Entities.Where(u => u.ROLE_ID == data.ROLE_ID).Select(u => u.MENUOPT_ID).ToList(); role.MenuOptId = listMenuOptId; amm.Statu = AjaxStatu.ok; amm.Data = role; return(amm); } else { amm.Msg = string.Format(Message.NotFound, "角色"); return(amm); } } catch (Exception) { return(amm); } }