public IActionResult GetUserList(GeneralRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbITMContext)
{
var school = _dbITMContext.Orgs.FirstOrDefault(x => x.SchoolName == payload.Kw);
var query = _dbITMContext.Users.Where(x => x.OrganizationId == school.OrganizationId && x.DutyId != 0 && x.DutyId != null);
var usernum = query.Count();
var user = query.Where(x => x.DutyId != 118);
var gly = query.Where(x => x.DutyId == 118);
var noglynum = usernum - gly.Count();
var reality = user.Where(x => x.HealthStatus == 1).Count();
if (!string.IsNullOrEmpty(payload.kw1))
{
user = user.Where(x => x.Name.Contains(payload.kw1));
gly = gly.Where(x => x.Name.Contains(payload.kw1));
}
user = user.OrderBy(x => x.Name);
gly = gly.OrderBy(x => x.Name);
var userlist = user.ToList();
var glylist = gly.ToList();
response.SetData(new { userlist, glylist, usernum, noglynum, reality });
return(Ok(response));
}
}
public IActionResult GetList(GeneralRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var query = _dbContext.ArticleManage.Where(x => x.IsDelete == 0).Select(x => new
{
x.SchoolUuid,
x.AddTime,
x.Title,
x.Image,
x.ArticleUuid
});
if (AuthContextService.CurrentUser.SchoolGuid != null)
{
query = query.Where(x => x.SchoolUuid == AuthContextService.CurrentUser.SchoolGuid);
}
if (payload.FirstSort != null)
{
query = query.OrderByDescending(x => x.AddTime);
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
response.SetData(list, totalCount);
return(Ok(response));
}
}
