public IQueryable <sline_article> GetPage(ArticleQueryParam pageParam)
{
try
{
var db = new LTHWMysqlModel();
var articles = from a in db.sline_article
select a;
if (!string.IsNullOrEmpty(pageParam.title))
{
articles = articles.Where(p => p.title.Contains(pageParam.title));
}
if (!string.IsNullOrEmpty(pageParam.themelist))
{
articles = articles.Where(p => ("," + p.themelist + ",").Contains(("," + pageParam.themelist + ",")));
}
if (!string.IsNullOrEmpty(pageParam.kindlist))
{
articles = articles.Where(p => ("," + p.kindlist + ",").Contains(("," + pageParam.kindlist + ",")));
}
if (!string.IsNullOrEmpty(pageParam.attrid))
{
articles = articles.Where(p => ("," + p.attrid + ",").Contains(("," + pageParam.attrid + ",")));
}
pageParam.total = articles.Count();
if (pageParam.isDesc)
{
articles = articles.OrderByDescending(c => c.modtime).Skip(pageParam.size * (pageParam.page - 1)).Take(pageParam.size);
}
else
{
articles = articles.OrderBy(c => c.modtime).Skip(pageParam.size * (pageParam.page - 1)).Take(pageParam.size);
}
return(articles);
}
catch (Exception ex)
{
LogHelper.Error(this, ("文章：" + ex.Message + ex.InnerException.Message));
return(null);
}
}
public ResponseBody <PageEntity <List <sline_article> > > PostPage([FromBody] ArticleQueryParam pageParam)
{
try
{
var list = _IArticleBLL.GetPage(pageParam);
return(new ResponseBody <PageEntity <List <sline_article> > > {
Result = new PageEntity <List <sline_article> > {
data = list, total = pageParam.total
}, Code = "", Message = ""
});
}
catch (Exception ex)
{
LogHelper.Error(this, ex.Message + ex.InnerException.Message);
return(null);
}
}
public List <sline_article> GetPage(ArticleQueryParam pageParam)
{
return(_IArticleDAL.GetPage(pageParam).ToList <sline_article>());
}
