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