/// <summary>
/// 搜索医院
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <SearchHospitalResponseDto> SearchHospitalAsync(SearchHospitalRequestDto request)
{
var sqlWhere = $@"AND ENABLE = 1 AND visibility = 1";
if (!string.IsNullOrWhiteSpace(request.Keyword))
{
sqlWhere = $"{sqlWhere} AND (hos_name like @Keyword OR hos_tag like @Keyword OR hos_abstract like @Keyword)";
}
var sql = $@"
SELECT * FROM(
SELECT
A.*,
CONCAT( B.base_path, B.relative_path ) AS LogoUrl
FROM
t_doctor_hospital A
LEFT JOIN t_utility_accessory B ON B.accessory_guid = A.logo_guid
)___T
WHERE
1 = 1 {sqlWhere}
ORDER BY
creation_date desc" ;
request.Keyword = $"%{request.Keyword}%";
return(await MySqlHelper.QueryByPageAsync <SearchHospitalRequestDto, SearchHospitalResponseDto, SearchHospitalItemDto>(sql, request));
}
public async Task <IActionResult> SearchHospitalAsync([FromBody] SearchHospitalRequestDto request)
{
var response = await new HospitalBiz().SearchHospitalAsync(request);
foreach (var item in response.CurrentPage)
{
item.HosLevel = GetHosLevelName(item.HosLevel);
}
return(Success(response));
}
public async Task <IActionResult> SearchHospitalAsync([FromBody] SearchHospitalRequestDto request)
{
CommonBiz commonBiz = new CommonBiz();
if (!string.IsNullOrEmpty(UserID))
{
commonBiz.SearchHistory(UserID, request.Keyword);
}
commonBiz.HotWordSearch(request.Keyword);
var response = await new HospitalBiz().SearchHospitalAsync(request);
foreach (var item in response.CurrentPage)
{
item.HosLevel = GetHosLevelName(item.HosLevel);
}
return(Success(response));
}
