public override IEnumerable <string> GetOrderEnumerable(TableMapperAttribute tableMapper)
{
return(new[]
{
SqlCharConst.DefaultOrder
});
}
public override IEnumerable <string> GetFieldEnumerable(TableMapperAttribute tableMapper)
{
var list = EntityTools.GetFields <CommentInfo>().ToList();
// list.Add($@"
//(
// {SqlCharConst.SELECT} {SqlCharConst.COUNT}(0)
// {SqlCharConst.FROM} {EntityTools.GetTableName<CommentInfo>()}
// {SqlCharConst.WHERE} {EntityTools.GetField<CommentInfo>(nameof(CommentInfo.ReplyId))} = {tableMapper.Alias}.{nameof(BaseModel.Id)}
// {SqlCharConst.AND} {EntityTools.GetField<CommentInfo>(nameof(CommentInfo.ValidFlag))} = {(int)ValidFlagMenu.UseFul}
// {SqlCharConst.AND} {EntityTools.GetField<CommentInfo>(nameof(CommentInfo.CommentType))} = {(int)CommentTypeMenu.Article}
//)
// AS {EntityTools.GetField<CommentDto>(nameof(CommentDto.ReplyCount))}
//");
list.Add($@"
(
SELECT displayName FROM user_info
WHERE id = (
SELECT actionUser FROM comment_info
WHERE id = {tableMapper.Alias}.replyId
)
) AS {nameof(CommentDto.ReplyUserName)}
");
return(list);
}
public abstract IEnumerable <string> GetOrderEnumerable(TableMapperAttribute tableMapper);
public override IEnumerable <string> GetFieldEnumerable(TableMapperAttribute tableMapper)
{
return(EntityTools.GetFields <CommentInfo>());
}
