/// <summary>
/// 创建 <see cref="ArticleResultList"/>
/// </summary>
/// <param name="keyword">搜索关键字</param>
/// <param name="dbContext"><see cref="KeylolDbContext"/></param>
/// <param name="cachedData"><see cref="CachedDataProvider"/></param>
/// <param name="searchAll">是否查询全部</param>
public static async Task <ArticlePage> CreateAsync(string keyword, [Injected] KeylolDbContext dbContext,
[Injected] CachedDataProvider cachedData, bool searchAll = true)
{
return(new ArticlePage
{
Results = await ArticleResultList.CreateAsync(keyword, dbContext, cachedData, 1, searchAll)
});
}
/// <summary>
/// 创建 <see cref="ArticleResultList"/>
/// </summary>
/// <param name="keyword">搜索关键字</param>
/// <param name="dbContext"><see cref="KeylolDbContext"/></param>
/// <param name="cachedData"><see cref="CachedDataProvider"/></param>
/// <param name="page">分页页码</param>
/// <param name="searchAll">是否查询全部</param>
public static async Task <ArticleResultList> CreateAsync(string keyword, [Injected] KeylolDbContext dbContext,
[Injected] CachedDataProvider cachedData, int page, bool searchAll = true)
{
var take = searchAll ? 10 : 5;
var skip = (page - 1) * take;
var searchResult = await dbContext.Database.SqlQuery <ArticleResult>(@"SELECT
*
FROM (SELECT
[t1].*,
[t2].*,
[t5].[IdCode] AS PointIdCode,
[t5].[AvatarImage] AS PointAvatarImage,
[t5].[ChineseName] AS PointChineseName,
[t5].[EnglishName] AS PointEnglishName,
[t6].[UserName] AS AuthorUserName,
[t6].[IdCode] AS AuthorIdCode,
[t6].[AvatarImage] AS AuthorAvatarImage
FROM [dbo].[Articles] AS [t1]
INNER JOIN (SELECT
*
FROM FREETEXTTABLE([dbo].[Articles], ([Title], [Subtitle], [UnstyledContent]), {0})) AS [t2]
ON [t1].[Sid] = [t2].[KEY]
INNER JOIN [dbo].[Points] AS [t5]
ON [t1].[TargetPointId] = [t5].[Id]
INNER JOIN [dbo].[KeylolUsers] AS [t6]
ON [t1].[AuthorId] = [t6].[Id]
WHERE [t1].[Archived] = 0 AND [t1].[Rejected] = 0) AS [t3]
ORDER BY [t3].[RANK] DESC OFFSET {1} ROWS FETCH NEXT {2} ROWS ONLY",
keyword, skip, take).ToListAsync();
var result = new ArticleResultList(searchResult.Count);
foreach (var a in searchResult)
{
result.Add(new ArticleResult
{
Title = a.Title,
SubTitle = a.SubTitle,
AuthorIdCode = a.AuthorIdCode,
AuthorUserName = searchAll ? a.AuthorUserName : null,
AuthorAvatarImage = searchAll ? a.AuthorAvatarImage : null,
SidForAuthor = a.SidForAuthor,
PointChineseName = searchAll ? a.PointChineseName : null,
PointEnglishName = searchAll ? a.PointEnglishName : null,
PointAvatarImage = searchAll ? a.PointAvatarImage : null,
PointIdCode = searchAll ? a.PointIdCode : null,
LikeCount = await cachedData.Likes.GetTargetLikeCountAsync(a.Id, LikeTargetType.Article),
CommentCount =
searchAll ? await cachedData.ArticleComments.GetArticleCommentCountAsync(a.Id) : (long?)null,
PublishTime = searchAll ? a.PublishTime : null
});
}
return(result);
}
