/// <summary>
/// 获取博客标签列表
/// </summary>
/// <returns></returns>
public Task <PageModel <BlogQueryModel> > QueryBlogList(BlogQueryParam param)
{
WebManager webManager = this.DbSession.GetRequiredService <WebManager>();
var query = from b in Db.Set <T_Blog>().AsNoTracking()
join u in Db.Set <T_UserInfo>().AsNoTracking() on b.UserId equals u.Id
where b.Publish == ConstKey.Yes &&
b.Delete == ConstKey.No &&
u.Delete == ConstKey.No
select new BlogQueryModel
{
Id = b.Id.ToString(),
NickName = u.NickName,
UserName = u.UserName,
Title = b.Title,
Content = b.Content,
ReadCount = b.ReadCount,
CmtCount = b.CmtCount,
PublishDate = b.PublishDate,
AvatarUrl = webManager.GetFullUrl(u.AvatarUrl)
};
if (string.IsNullOrEmpty(param.SortKey))
{
param.SortKey = nameof(BlogQueryModel.PublishDate);
param.SortType = SortTypeEnum.DESC;
}
return(query.ToOrderAndPageListAsync(param));
}
public async Task <PageModel <BlogQueryModel> > QueryBlogList(BlogQueryParam param)
{
var result = await blogService.QueryBlogList(param);
return(result);
}
