//分页搜索
public async Task <PagedResult <CameraPathDto> > SearchAsync(CameraPathFilters filters)
{
//throw new NotImplementedException();
if (filters == null)
{
return(new PagedResult <CameraPathDto>(0, 0));
}
var dbset = _context.CameraPaths;
var query = dbset.Where(item => !item.IsDeleted);
if (filters.keywords.IsNotBlank())
{
query = query.Where(item => item.PumpRoomName.Contains(filters.keywords));
}
return(await query.OrderByDescending(item => item.CreateDateTime)
.Select(item => new CameraPathDto
{
Id = item.Id,
Ip = item.Ip,
Port = item.Port,
Pwd = item.Pwd,
LoginName = item.LoginName,
info = item.info,
PumpRoomId = item.PumpRoomId,
PumpRoomName = item.PumpRoomName
}).PagingAsync(filters.page, filters.rows));
}
public async Task <IActionResult> GetListWithPager(CameraPathFilters filters)
{
var result = await _cameraPathService.SearchAsync(filters);
return(Json(result));
}
