public async Task <IActionResult> GetFamousRecommendDoctorListAsync([FromQuery] GetFamousRecommendDoctorListRequestDto requestDto)
{
var result = await new DoctorBiz().GetFamousRecommendDoctorListAsync(requestDto);
return(Success(result));
}
/// <summary>
/// 获取名医推荐医生列表
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <GetFamousRecommendDoctorListResponseDto> GetFamousRecommendDoctorListAsync(GetFamousRecommendDoctorListRequestDto requestDto)
{
var sql = @"SELECT
a.doctor_guid,
b.user_name AS doctor_name,
a.hospital_guid,
a.hospital_name,
a.office_guid,
a.office_name,
a.adept_tags,
dic.config_name as title,
CONCAT( c.base_path, c.relative_path ) AS portrait
FROM
t_doctor a
INNER JOIN t_utility_user b ON a.doctor_guid = b.user_guid
INNER JOIN t_doctor_hospital h ON h.hospital_guid = a.hospital_guid
LEFT JOIN t_utility_accessory c ON c.accessory_guid = a.portrait_guid
LEFT JOIN t_utility_accessory d ON d.accessory_guid = h.logo_guid
left join t_manager_dictionary dic on dic.dic_guid=a.title_guid
WHERE
a.`enable` = 1
AND a.is_recommend = 1
order by a.recommend_sort desc" ;
return(await MySqlHelper.QueryByPageAsync <GetFamousRecommendDoctorListRequestDto, GetFamousRecommendDoctorListResponseDto, GetFamousRecommendDoctorListItemDto>(sql, requestDto));
}
