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