public IActionResult List2(SecurityPRequestpayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var query = _dbContext.SecurityReport.Where(x => x.IsDeleted == 0 && x.SecurityUuid == Guid.Parse(payload.Kw)).Select(x => new
{
x.IsDeleted,
x.Id,
x.SecurityReportUuid,
x.SecurityUuid,
x.Situation,
Time = x.Time.Value.ToString("yyyy-MM-dd"),
x.State,
});
//if (!string.IsNullOrEmpty(payload.Kw2))
//{
// query = query.Where(x => x.SecurityName.Contains(payload.Kw.Trim()));
//}
if (payload.FirstSort != null)
{
query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult List(SecurityPRequestpayload payload)
{
using (_dbContext)
{
var query = _dbContext.Security.Where(x => x.IsDeleted == 0);
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.SecurityName.Contains(payload.Kw.Trim()));
}
if (payload.FirstSort != null)
{
query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
ToLog.AddLog("查询", "成功:查询:安防人员信息数据", _dbContext);
return(Ok(response));
}
}
