public async Task <SearchOfficeResponseDto> SearchOfficeAsync(SearchOfficeRequestDto request)
{
var whereSql = "where 1=1";
if (!string.IsNullOrWhiteSpace(request.Keyword))
{
whereSql = $"{whereSql} and (office_name like @Keyword or parentName like @Keyword or hospital_name like @Keyword)";
}
var sql = $@"
SELECT * FROM (
SELECT DISTINCT
a.office_guid,
a.office_name,
a.hospital_name,
a.sort,
a.ENABLE,
a.creation_date,
b.office_name AS parentName
FROM
t_doctor_office a
LEFT JOIN t_doctor_office b ON a.parent_office_guid = b.office_guid
)___T
{whereSql}
ORDER BY sort DESC";
request.Keyword = $"%{request.Keyword}%";
return(await MySqlHelper.QueryByPageAsync <SearchOfficeRequestDto, SearchOfficeResponseDto, SearchOfficeItemDto>(sql, request));
}
public async Task <IActionResult> SearchOfficeAsync([FromBody] SearchOfficeRequestDto request)
{
OfficeBiz officeBiz = new OfficeBiz();
var officeModels = await officeBiz.SearchOfficeAsync(request);
return(Success(officeModels));
}
