public ResponseBody <PageEntity <List <SightListEntity> > > PostPage([FromBody] SightQueryParam pageParam) { var list = _ISightBLL.GetPage(pageParam); return(new ResponseBody <PageEntity <List <SightListEntity> > > { Result = new PageEntity <List <SightListEntity> > { data = list, total = pageParam.total }, Code = "", Message = "" }); }
public IQueryable <SightListEntity> GetPage(SightQueryParam pageParam) { var db = new LTHWMysqlModel(); var sights = from b in db.sline_spot_ticket join a in db.sline_spot on b.spotid equals a.id select new SightListEntity { id = b.id, spotid = b.spotid, sellprice = b.sellprice, ourprice = b.ourprice, address = a.address, friendtip = a.friendtip, getway = a.getway, modtime = a.modtime, piclist = a.piclist, sellpoint = a.sellpoint, shortname = a.shortname, title = a.title, attrid = a.attrid, bookcount = a.bookcount, recommendnum = a.recommendnum, satisfyscore = a.satisfyscore, lat = a.lat, lng = a.lng, litpic = a.litpic, kindlist = a.kindlist }; if (!string.IsNullOrEmpty(pageParam.title)) { sights = sights.Where(p => p.title.Contains(pageParam.title)); } if (!string.IsNullOrEmpty(pageParam.kindlist)) { sights = sights.Where(p => ("," + p.kindlist + ",").Contains(("," + pageParam.kindlist + ","))); } if (!string.IsNullOrEmpty(pageParam.attrid)) { sights = sights.Where(p => ("," + p.attrid + ",").Contains(("," + pageParam.attrid + ","))); } pageParam.total = sights.Count(); if (!string.IsNullOrEmpty(pageParam.orderprice)) { if (pageParam.isDesc) { sights = sights.OrderByDescending(c => c.ourprice).Skip(pageParam.size * (pageParam.page - 1)).Take(pageParam.size); } else { sights = sights.OrderBy(c => c.ourprice).Skip(pageParam.size * (pageParam.page - 1)).Take(pageParam.size); } } else { if (pageParam.isDesc) { sights = sights.OrderByDescending(c => c.modtime).Skip(pageParam.size * (pageParam.page - 1)).Take(pageParam.size); } else { sights = sights.OrderBy(c => c.modtime).Skip(pageParam.size * (pageParam.page - 1)).Take(pageParam.size); } } return(sights); }
public List <SightListEntity> GetPage(SightQueryParam pageParam) { return(_ISightDAL.GetPage(pageParam).ToList <SightListEntity>()); }