public async Task <ArticleDetailDto> QueryArticleDetail(ArticleDetailQueryParam param)
{
return(await _dbAdapter.QueryFirstOrDefault <ArticleDetailDto>(@"SELECT ar.Id
,ar.Title
,ar.Slug
,ar.Summary
,ar.Cover
,us.UserName AS Author
,ch.Name AS ChannelName
,ct.TEXT AS Content
,ar.CreatedAtUtc
,ar.UpdatedAtUtc
,ct.Id AS ContentId
FROM Articles AS ar
JOIN Contents AS ct ON ar.ContentId = ct.Id
JOIN AspNetUsers AS us ON ar.CreatedBy = us.Id
JOIN Channels AS ch ON ar.ChannelId = ch.Id
WHERE ar.Slug = @Slug
AND us.UserName = @UserName" , param));
}
public async Task <ArticleDetailDto> QueryArticleDetail(ArticleDetailQueryParam param)
{
var result = await _articleStorage.QueryArticleDetail(param);
return(result);
}
