public async Task <IActionResult> GetHospitalRecommendDoctorListAsync([FromBody] GetHospitalRecommendDoctorListRequestDto requestDto) { var result = await new DoctorBiz().GetHospitalRecommendDoctorListAsync(requestDto); return(Success(result)); }
/// <summary> /// 获取医院下推荐医生列表 /// </summary> /// <param name="requestDto"></param> /// <returns></returns> public async Task <GetHospitalRecommendDoctorListResponseDto> GetHospitalRecommendDoctorListAsync(GetHospitalRecommendDoctorListRequestDto 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, CONCAT( d.base_path, d.relative_path ) AS hospital_logo 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 AND a.hospital_guid = @HospitalGuid" ; return(await MySqlHelper.QueryByPageAsync <GetHospitalRecommendDoctorListRequestDto, GetHospitalRecommendDoctorListResponseDto, GetHospitalRecommendDoctorListItemDto>(sql, requestDto)); }