public OperatePageResult GetUserList(QueryUserReq pageSize) { var query = from u in _context.SysUsers.AsNoTracking().Where(w => w.OrgFullPath.StartsWith(pageSize.fullpath)) join o in _context.Orgs.AsNoTracking() on u.OrgId equals o.Id into temp from tp in temp.DefaultIfEmpty() select new UserView() { Id = u.Id, Account = u.Account, CreateTime = u.CreateTime ?? DateTime.Now, CreateUser = u.Creator, OrganizationIds = u.OrgId ?? 0, Organizations = tp.Name, Name = u.Name, Sex = u.Sex ?? 0, Status = u.Status ?? 0, }; if (pageSize.orgId > 0) { query = query.Where(w => w.OrganizationIds == pageSize.orgId); } OperatePageResult result = new OperatePageResult { count = query.Count(), data = query.OrderBy(o => o.Name).Skip((pageSize.page - 1) * pageSize.limit).Take(pageSize.limit).ToList() }; return(result); }
public IActionResult QueryUsers([FromQuery] QueryUserReq queryUser) { try { var reply = Client.QueryUsers(queryUser); return(Json(new JsonResultModel(ReturnCode.Success, "User information query successful.", reply))); } catch (RpcException ex) { return(Json(new JsonResultModel(ReturnCode.QueryError, ex.Status.Detail))); } }
public string GetUserList(QueryUserReq request) { request.fullpath = CurrentUser.OrgFullPath; return(JsonHelper.Instance.Serialize(_userService.GetUserList(request))); }