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)); }