public IActionResult CarList(MonitoringRequestPayload payload)
{
using (_dbContext)
{
var query = from m in _dbContext.CarMonitoring
join c in _dbContext.Car
on m.CarUuid equals c.CarUuid
where c.IsDelete != 1 && m.IsDelete != 1
select new
{
m.CarUuid,
m.MonitoringNum,
m.Remark,
m.AddTime,
c.CarNum,
m.CarMonitoringUuid
};
//车牌号筛选
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.CarNum.Contains(payload.Kw));
}
//分页
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult GrabageList(MonitoringRequestPayload payload)
{
using (_dbContext)
{
var query = from m in _dbContext.GrabageMonitoring
join c in _dbContext.GrabageRoom
on m.GarbageRoomUuid equals c.GarbageRoomUuid into gr from g in gr.DefaultIfEmpty()
where g.IsDelete != "1" && m.IsDelete != 1
select new
{
m.Id,
m.GarbageRoomUuid,
m.MonitoringNum,
m.Remark,
m.AddTime,
m.JiankongName,
m.RegionId,
m.Latitude,
m.Longitude,
Ljname = g.Ljname,
m.GrabageMonitoringUuid,
m.VideoUrl
//c.VillageId
};
////街道筛选
//if (!string.IsNullOrEmpty(payload.street))
//{
// query = query.Where(x => x.JiankongName.Contains(payload.street));
//}
////社区筛选
//if (!string.IsNullOrEmpty(payload.ccmmunity))
//{
// query = query.Where(x => x.JiankongName.Contains(payload.ccmmunity));
//}
//车牌号筛选
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.JiankongName.Contains(payload.Kw));
}
//分页
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
