[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);
}
}
