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