public static Result <NanHuArticle> QueryPageList(ReqNanHuArticle req)
{
var dbContext = new DbContext();
Expression <Func <NanHuArticle, bool> > fun = r => true;
if (req.Title.IsNotNullOrEmpty())
{
fun = (r) => SqlFunc.Contains(r.Title, req.Title);
//fun.AndAlso(r => SqlFunc.Contains(r.Title, req.Title));
}
if (req.CategoryId > 0)
{
var prefix = fun.Compile();
fun = (r) => prefix(r) && r.CategoryId == req.CategoryId;
// fun.AndAlso(r => r.CategoryId == req.CategoryId);
}
var result = dbContext.NanHuArticleDb.GetPages(req.ConvertData(), fun, req.PageInfo);
if (result.TotalCount > 0)
{
result.Results.ForEach(r =>
{
r.CategoryName = ModuleSubBLL.GetById(r.CategoryId)?.Name;
});
}
return(result);
}
public ResponseResult Get([FromQuery] ReqNanHuArticle req)
{
req.PageInfo = HttpContext.Request.GetPageInfo();
return(new ResponseResult(0, "", BLL.NanHuArticleBLL.QueryPageList(req)));
}
