public async Task <QuestionDetailDto> QueryQuestionDetail(QuestionDetailQueryParam param)
{
return(await _dbAdapter.QueryFirstOrDefault <QuestionDetailDto>(@"SELECT qs.Id
, qs.Title
, qs.Slug
, us.UserName AS Author
, ct.TEXT AS Content
, qs.CreatedAtUtc
, qs.UpdatedAtUtc
, ct.Id AS ContentId
FROM Questions AS qs
JOIN Contents AS ct ON qs.ContentId = ct.Id
JOIN AspNetUsers AS us ON qs.CreatedBy = us.Id
WHERE qs.Slug = @Slug
AND us.UserName = @UserName", param));
}
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));
}
