예제 #1
0
        public async Task <IActionResult> GetFamousRecommendDoctorListAsync([FromQuery] GetFamousRecommendDoctorListRequestDto requestDto)
        {
            var result = await new DoctorBiz().GetFamousRecommendDoctorListAsync(requestDto);

            return(Success(result));
        }
예제 #2
0
        /// <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));
        }