/// <summary>
/// 获取医生粉丝列表
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <List <GetDoctorFansListItemDto> > GetDoctorFansListAsync(GetDoctorFansListRequestDto requestDto)
{
using (var conn = MySqlHelper.GetConnection())
{
var keywordWhere = "";
if (!string.IsNullOrWhiteSpace(requestDto.Keyword))
{
keywordWhere = $" and b.nick_name like @Keyword";
requestDto.Keyword = $"%{requestDto.Keyword}%";
}
var sql = $@"SELECT
b.user_guid as UserGuid,
b.user_name as UserName,
IFNULL(d.alias_name,b.nick_name) AS NickName,
CONCAT( c.base_path, c.relative_path ) AS PortraitUrl
FROM
t_consumer_collection a
INNER JOIN t_utility_user b ON a.user_guid = b.user_guid
LEFT JOIN t_utility_accessory c ON b.portrait_guid = c.accessory_guid
AND c.`enable` = 1
left join t_utility_alias d on d.user_guid=a.target_guid and d.target_guid=a.user_guid
WHERE
a.target_guid = @DoctorGuid
AND a.`enable` = 1
AND b.`enable` = 1
{keywordWhere}
order by NickName";
var result = await conn.QueryAsync <GetDoctorFansListItemDto>(sql, requestDto);
return(result?.ToList());
}
}
public async Task <IActionResult> GetDoctorFansListAsync([FromQuery] GetDoctorFansListRequestDto requestDto)
{
var result = await new DoctorBiz().GetDoctorFansListAsync(requestDto);
return(Success(result));
}
