/// <summary> /// 创建 <see cref="DiscoveryPage"/> /// </summary> /// <param name="currentUserId">当前登录用户 ID</param> /// <param name="dbContext"><see cref="KeylolDbContext"/></param> /// <param name="cachedData"><see cref="CachedDataProvider"/></param> /// <returns><see cref="DiscoveryPage"/></returns> public static async Task <DiscoveryPage> CreateAsync(string currentUserId, KeylolDbContext dbContext, CachedDataProvider cachedData) { var onSalePoints = await OnSalePointList.CreateAsync(currentUserId, 1, true, true, dbContext, cachedData); var latestArticles = await LatestArticleList.CreateAsync(1, true, true, dbContext, cachedData); return(new DiscoveryPage { SlideshowEntries = await SlideshowEntryList.CreateAsync(1, 4, dbContext), SpotlightPoints = await SpotlightPointList.CreateAsync(currentUserId, 1, 30, dbContext, cachedData), SpotlightReviews = await SpotlightArticleList.CreateAsync(currentUserId, 1, 4, SpotlightArticleStream.ArticleCategory.Review, dbContext, cachedData), SpotlightStudies = await SpotlightArticleList.CreateAsync(currentUserId, 1, 4, SpotlightArticleStream.ArticleCategory.Study, dbContext, cachedData), OnSalePointHeaderImage = onSalePoints.Item3, OnSalePointPageCount = onSalePoints.Item2, OnSalePoints = onSalePoints.Item1, SpotlightStories = await SpotlightArticleList.CreateAsync(currentUserId, 1, 4, SpotlightArticleStream.ArticleCategory.Story, dbContext, cachedData), LatestArticleHeaderImage = latestArticles.Item3, LatestArticlePageCount = latestArticles.Item2, LatestArticles = latestArticles.Item1, LatestActivityHeaderImage = onSalePoints.Item4, LatestActivities = await TimelineCardList.CreateAsync(LatestActivityStream.Name, currentUserId, 12, false, dbContext, cachedData) }); }
/// <summary> /// 获取精选谈论 /// </summary> /// <param name="page">分页页码</param> /// <param name="dbContext"><see cref="KeylolDbContext"/></param> /// <param name="cachedData"><see cref="CachedDataProvider"/></param> /// <returns><see cref="SpotlightArticleList"/></returns> public static async Task <SpotlightArticleList> GetSpotlightStories(int page, [Injected] KeylolDbContext dbContext, [Injected] CachedDataProvider cachedData) { return(await SpotlightArticleList.CreateAsync(StateTreeHelper.GetCurrentUserId(), page, 12, SpotlightArticleStream.ArticleCategory.Story, dbContext, cachedData)); }
/// <summary> /// 创建 <see cref="SpotlightArticleList"/> /// </summary> /// <param name="currentUserId">当前登录用户 ID</param> /// <param name="page">分页页码</param> /// <param name="recordsPerPage">每页数量</param> /// <param name="spotlightArticleCategory">文章分类</param> /// <param name="dbContext"><see cref="KeylolDbContext"/></param> /// <param name="cachedData"><see cref="CachedDataProvider"/></param> /// <returns><see cref="SpotlightArticleList"/></returns> public static async Task <SpotlightArticleList> CreateAsync(string currentUserId, int page, int recordsPerPage, SpotlightArticleStream.ArticleCategory spotlightArticleCategory, KeylolDbContext dbContext, CachedDataProvider cachedData) { var streamName = SpotlightArticleStream.Name(spotlightArticleCategory); var queryResult = await(from feed in dbContext.Feeds where feed.StreamName == streamName join article in dbContext.Articles on feed.Entry equals article.Id where article.Rejected == false && article.Archived == ArchivedState.None orderby feed.Id descending select new { article.Id, FeedId = feed.Id, FeedProperties = feed.Properties, article.AuthorId, AuthorIdCode = article.Author.IdCode, AuthorAvatarImage = article.Author.AvatarImage, AuthorUserName = article.Author.UserName, article.PublishTime, article.SidForAuthor, article.Title, article.Subtitle, article.CoverImage, PointIdCode = article.TargetPoint.IdCode, PointAvatarImage = article.TargetPoint.AvatarImage, PointType = article.TargetPoint.Type, PointChineseName = article.TargetPoint.ChineseName, PointEnglishName = article.TargetPoint.EnglishName, PointSteamAppId = article.TargetPoint.SteamAppId }) .TakePage(page, recordsPerPage) .ToListAsync(); var result = new SpotlightArticleList(queryResult.Count); foreach (var a in queryResult) { var p = JsonConvert.DeserializeObject <SpotlightArticleStream.FeedProperties>(a.FeedProperties); result.Add(new SpotlightArticle { Id = a.Id, FeedId = a.FeedId, AuthorIdCode = a.AuthorIdCode, AuthorAvatarImage = a.AuthorAvatarImage, AuthorUserName = a.AuthorUserName, AuthorIsFriend = string.IsNullOrWhiteSpace(currentUserId) ? (bool?)null : await cachedData.Users.IsFriendAsync(currentUserId, a.AuthorId), PublishTime = a.PublishTime, SidForAuthor = a.SidForAuthor, Title = p?.Title ?? a.Title, Subtitle = p?.Subtitle ?? a.Subtitle, CoverImage = a.CoverImage, PointIdCode = a.PointIdCode, PointAvatarImage = a.PointAvatarImage, PointType = a.PointType, PointChineseName = a.PointChineseName, PointEnglishName = a.PointEnglishName, PointInLibrary = string.IsNullOrWhiteSpace(currentUserId) || a.PointSteamAppId == null ? (bool?)null : await cachedData.Users.IsSteamAppInLibraryAsync(currentUserId, a.PointSteamAppId.Value) }); } return(result); }