Ejemplo n.º 1
0
        /// <summary>
        /// 分页获取医院列表
        /// </summary>
        /// <param name="requestDto"></param>
        /// <returns></returns>
        public async Task <GetHospitalPageListResponseDto> GetHospitalPageListAsync(GetHospitalPageListRequestDto requestDto)
        {
            var sql    = @"SELECT
	                        a.hospital_guid,
	                        a.hos_name,
	                        a.hos_abstract,
	                        a.hos_tag,
                            a.external_link,
	                        CONCAT(b.base_path,b.relative_path) as logo_url
                        FROM
	                        t_doctor_hospital a
	                        LEFT JOIN t_utility_accessory b ON a.logo_guid = b.accessory_guid
                        where a.`enable`=1 order by a.sort desc";
            var result = await MySqlHelper.QueryByPageAsync <GetHospitalPageListRequestDto, GetHospitalPageListResponseDto, GetHospitalPageListItemDto>(sql, requestDto);

            return(result);
        }
Ejemplo n.º 2
0
        public async Task <IActionResult> GetHospitalPageListAsync([FromBody] GetHospitalPageListRequestDto requestDto)
        {
            var response = await new HospitalBiz().GetHospitalPageListAsync(requestDto);

            return(Success(response));
        }