public IActionResult List(ScenicSpotRequestPayload payload) { using (_dbContext) { var query = from p in _dbContext.Pointer select new { p.PointerUuid, p.PointerName, p.Address, p.PointerNum, p.IsDelete, p.Lon, p.Lat, }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.PointerName.Contains(payload.Kw.Trim()) || x.Address.Contains(payload.Kw.Trim())); } if (payload.IsDeleted > CommonEnum.IsDeleted.All) { query = query.Where(x => x.IsDelete == Convert.ToInt32(((CommonEnum.IsDeleted)payload.IsDeleted))); } 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)); } }
public IActionResult List(ScenicSpotRequestPayload payload) { using (_dbContext) { var query = from p in _dbContext.ScenicSpot select new { p.ScenicSpotUuid, p.Name, p.Address, p.OrderBy, ShopId = p.ShopId == null ? -1 : p.ShopId, PlayType = p.PlayType == "1" ? "古镇游" : "周边游", p.IsDelete, p.State }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.Name.Contains(payload.Kw.Trim()) || x.Address.Contains(payload.Kw.Trim())); } if (payload.State > -1) { query = query.Where(x => x.State == payload.State); } if (payload.IsDeleted > CommonEnum.IsDeleted.All) { query = query.Where(x => x.IsDelete == Convert.ToInt32(((CommonEnum.IsDeleted)payload.IsDeleted))); } query = query.OrderBy(x => x.OrderBy); 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)); } }