public IQueryable <TripListEntity> GetPage(TripQueryParam pageParam)
{
var db = new LTHWMysqlModel();
var trips = from a in db.sline_line
select new TripListEntity
{
id = a.id,
attrid = a.attrid,
kindlist = a.kindlist,
lineday = a.lineday,
litpic = a.litpic,
storeprice = a.storeprice,
title = a.title,
modtime = a.modtime
};
if (!string.IsNullOrEmpty(pageParam.title))
{
trips = trips.Where(p => p.title.Contains(pageParam.title));
}
if (!string.IsNullOrEmpty(pageParam.kindlist))
{
trips = trips.Where(p => ("," + p.kindlist + ",").Contains(("," + pageParam.kindlist + ",")));
}
if (!string.IsNullOrEmpty(pageParam.attrid))
{
trips = trips.Where(p => ("," + p.attrid + ",").Contains(("," + pageParam.attrid + ",")));
}
pageParam.total = trips.Count();
if (!string.IsNullOrEmpty(pageParam.orderprice))
{
if (pageParam.isDesc)
{
trips = trips.OrderByDescending(c => c.storeprice).Skip(pageParam.size * (pageParam.page - 1)).Take(pageParam.size);
}
else
{
trips = trips.OrderBy(c => c.storeprice).Skip(pageParam.size * (pageParam.page - 1)).Take(pageParam.size);
}
}
else
{
if (pageParam.isDesc)
{
trips = trips.OrderByDescending(c => c.modtime).Skip(pageParam.size * (pageParam.page - 1)).Take(pageParam.size);
}
else
{
trips = trips.OrderBy(c => c.modtime).Skip(pageParam.size * (pageParam.page - 1)).Take(pageParam.size);
}
}
return(trips);
}
public ResponseBody <PageEntity <List <TripListEntity> > > PostPage([FromBody] TripQueryParam pageParam)
{
var list = _ITripsBLL.GetPage(pageParam);
return(new ResponseBody <PageEntity <List <TripListEntity> > > {
Result = new PageEntity <List <TripListEntity> > {
data = list, total = pageParam.total
}, Code = "", Message = ""
});
}
public List <TripListEntity> GetPage(TripQueryParam pageParam)
{
return(_ITripsDAL.GetPage(pageParam).ToList <TripListEntity>());
}
