/// <summary> /// 搜索医生 /// </summary> /// <param name="request"></param> /// <returns></returns> public async Task <GetHospitalPageResponseDto> GetHospitalPageAsync(GetHospitalPageRequestDto request) { var sqlWhere = $@"1 = 1"; if (!string.IsNullOrWhiteSpace(request.Name)) { sqlWhere = $"{sqlWhere} AND (hos_name like @Name)"; } if (request.RegisteredBeginDate != null) { request.RegisteredBeginDate = request.RegisteredBeginDate?.Date; sqlWhere = $"{sqlWhere} AND Registered_Date > @RegisteredBeginDate"; } if (request.RegisteredEndDate != null) { request.RegisteredEndDate = request.RegisteredEndDate?.AddDays(1).Date; sqlWhere = $"{sqlWhere} AND Registered_Date < @RegisteredEndDate"; } 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 {sqlWhere} ORDER BY creation_date" ; request.Name = $"%{request.Name}%"; return(await MySqlHelper.QueryByPageAsync <GetHospitalPageRequestDto, GetHospitalPageResponseDto, GetHospitalPageItemDto>(sql, request)); }
public async Task <IActionResult> GetHospitalPageAsync([FromBody] GetHospitalPageRequestDto request) { var response = await new HospitalBiz().GetHospitalPageAsync(request); return(Success(response)); }