public IActionResult minsuList(WxStrategyRequestPayload payload)
{
using (_dbContext)
{
//查询民俗文化所属uuid
var nameuuid = _dbContext.ArticleType.FirstOrDefault(x => x.Name == "民俗文化").ArticleTypeUuid;
var query = from a in _dbContext.ArticlesManagement
where a.IsDelete == 0 && a.IsRelease == 1 && a.ArticleTypeUuid == nameuuid
orderby a.Id descending
select new
{
a.ArticleUuid,
a.ArticleTitle, //文章标题
a.CoverPhoto, //封面图片
a.AddPeople,
articleName = gettext(a.ArticleName),
Count = a.Count == null?0:a.Count,
Arturl = a.CoverPhoto,
};
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.ArticleTitle.Contains(payload.Kw.Trim()));
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult List2(WxStrategyRequestPayload payload)
{
using (_dbContext)
{
var query = from p in _dbContext.Strategy
where p.Isdelete == 0 && p.ThroughStaues == 0 && p.AuditStaues == 1 && p.PlayType == "2"
orderby p.Id descending
select new
{
p.StrategyUuid,
p.Title,
p.PhotoUrl,
Count = p.Count == null ? 0 : p.Count,
p.AddPeople,
//Count=100,
Arturl = "https://cdn.uviewui.com/uview/example/fade.jpg"
};
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.Title.Contains(payload.Kw.Trim()));
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
