public IHttpActionResult UserMaintain([FromUri] UserMaintainModel model) { try { string name = model.SearchKey == null ? "" : model.SearchKey.ToString(); Expression <Func <v_Jusoft_PcSysUser, bool> > where = w => (string.IsNullOrEmpty(name) || w.Name.Contains(name)) || (string.IsNullOrEmpty(name) || w.PsnMobilePhone.Contains(name)) || (string.IsNullOrEmpty(name) || w.DepName.Contains(name)); var List = dbContext.v_Jusoft_PcSysUser.Where(where); var Data = List.Select(p => new { p.id, p.Name, p.DepName, p.PsnMobilePhone, p.LockoutEnabled, Roles = dbContext.AC_SysUsers.Where(o => o.Id == p.id).Select(k => new { roles = k.AC_SysRoles.Select(s => new { s.Name }).ToList() }), }).OrderBy(p => p.id).ToList().ToPagedList(model.PageIndex, model.PageSize); return(JsonResultHelper.JsonResult(Data)); } catch (Exception ex) { return(JsonResultHelper.JsonResult(1000, ex.Message)); } }
public object UserMaintain(UserMaintainModel model) { ResultPageData rs = new ResultPageData(); try { var List = dbContext.v_Jusoft_PcSysUser.Where(p => true); if (!string.IsNullOrEmpty(model.Name)) { List = List.Where(p => p.Name.Contains(model.Name)); } if (!string.IsNullOrEmpty(model.Phone)) { List = List.Where(p => p.PsnMobilePhone.Contains(model.Phone)); } var Data = List.Select(p => new { p.id, p.Name, p.DepName, p.PsnMobilePhone, p.LockoutEnabled, Roles = dbContext.AC_SysUsers.Where(o => o.Id == p.id).Select(k => new { roles = k.AC_SysRoles.Select(s => new { s.Name }).ToList() }), }).OrderBy(p => p.id).ToPagedList(model.PageIndex, model.PageSize); rs.Data = Data; rs.PageIndex = model.PageIndex; rs.PageCount = Data.PageCount; rs.HasNextPage = Data.HasNextPage; rs.TotalItemCount = Data.TotalItemCount; return(Json(rs)); } catch (Exception ex) { rs.Code = 1001; rs.strResult = ex.Message; return(Json(rs)); } }