public async Task <IActionResult> GetMedicationDictionaryPageListAsync([FromQuery] GetMedicationDictionaryRequestDto requestDto)
{
var response = await new MedicationDictionaryBiz().GetMedicationDictionaryPageListAsync(requestDto);
return(Success(response));
}
public async Task <GetMedicationDictionaryPageListResponseDto> GetMedicationDictionaryPageListAsync(GetMedicationDictionaryRequestDto requestDto)
{
var sqlWhere = string.Empty;
if (!string.IsNullOrWhiteSpace(requestDto.Name))
{
sqlWhere = $" and a.name like @Name";
requestDto.Name = $"%{requestDto.Name}%";
}
var sql = $@"SELECT
a.medication_guid,
a.name,
a.creation_date
FROM
t_doctor_medication_dictionary a
WHERE 1=1 {sqlWhere} and a.medication_type=@PrescriptionEnum and a.`enable`=1" ;
return(await MySqlHelper.QueryByPageAsync <GetMedicationDictionaryRequestDto, GetMedicationDictionaryPageListResponseDto, GetMedicationDictionaryItemDto>(sql, requestDto));
}
