public IHttpActionResult GetSelectList(string communityId)
{
if (communityId.IsBlank())
{
return(Ok(new
{
code = 0,
msg = "communityId不能为空"
}));
}
var req = new QueryDateReq();
req.page = 1;
req.pageSize = int.MaxValue;
req.communityId = communityId;
var table = deviceService.GetList(req);
return(Ok(new
{
code = 0,
msg = "",
data = table.list
}));
}
[HttpGet, Route("list")] //, RequestAuthorize("admin:entry:list")
public IHttpActionResult GetLogList([FromUri] QueryDateReq req)
{
if (null == req)
{
req = new QueryDateReq();
}
var table = _syncService.GetList(req);
return(Ok(new
{
code = 0,
msg = "success",
data = table
}));
}
public TableData GetList(QueryDateReq req)
{
var query = _alarmRepository.Table;
if (req.beginTime.HasValue)
{
query = query.Where(t => t.OccurTime >= req.beginTime.Value);
}
if (req.endTime.HasValue)
{
query = query.Where(t => t.OccurTime <= req.endTime.Value);
}
if (!req.keyword.IsBlank())
{
query = query.Where(a => a.Device.DeviceName.Contains(req.keyword));
}
query = query.OrderByDescending(o => o.CreateTime);
var pagedList = query.ToPagedList(req.page, req.pageSize);
var alarmList = new List <DeviceAlarmDto>();
foreach (var item in pagedList)
{
var dto = item.MapTo <DeviceAlarmDto>();
dto.DeviceName = item.Device != null ? item.Device.DeviceName : "";
dto.AlarmTypeName = item.AlarmTypeDict.DictName;
var community = _areaService.GetById(item.CommunityUUID);
dto.CommunityName = community != null? community.ChineseName:"";
alarmList.Add(dto);
}
return(new TableData
{
currPage = req.page,
pageSize = req.pageSize,
pageTotal = pagedList.TotalPageCount,
totalCount = pagedList.TotalItemCount,
list = alarmList
});
}
public TableData GetList(QueryDateReq req)
{
var query = _syncRepository.Table;
if (!req.communityId.IsBlank())
{
query = query.Where(a => a.CommunityId == req.communityId);
}
if (req.beginTime.HasValue)
{
query = query.Where(t => t.SyncTime >= req.beginTime.Value);
}
if (req.endTime.HasValue)
{
query = query.Where(t => t.SyncTime <= req.endTime.Value);
}
if (req.status.HasValue)
{
query = query.Where(a => a.SyncResult == req.status.Value);
}
query = query.OrderByDescending(o => o.SyncTime);
var pagedList = query.ToPagedList(req.page, req.pageSize);
return(new TableData
{
currPage = req.page,
pageSize = req.pageSize,
pageTotal = pagedList.TotalPageCount,
totalCount = pagedList.TotalItemCount,
list = pagedList
});
}
