/// <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); }