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