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