public async Task <IActionResult> GetConsumerHealthReportPageList([FromQuery]
GetConsumerHealthReportPageListRequestDto request)
{
var healthBiz = new HealthBiz();
return(Success(await healthBiz.GetConsumerHealthReportPageList(request)));
}
/// <summary>
/// 获取会员检验报告列表
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <GetConsumerHealthReportPageListResponseDto> GetConsumerHealthReportPageList(GetConsumerHealthReportPageListRequestDto requestDto)
{
var sqlWhere = string.Empty;
if (!string.IsNullOrEmpty(requestDto.Name))
{
sqlWhere = "AND r.report_name LIKE @Name";
requestDto.Name = $"%{requestDto.Name}%";
}
var sql = $@"SELECT
r.report_guid as ReportGuid,
r.report_name as `Name`,
r.creation_date as UploadedDate,
r.last_updated_date as LastUpdatedDate
FROM t_consumer_health_report as r
WHERE r.user_guid = @UserGuid AND r.enable = 1 {sqlWhere}
ORDER BY r.last_updated_date DESC";
return(await MySqlHelper.QueryByPageAsync <GetConsumerHealthReportPageListRequestDto,
GetConsumerHealthReportPageListResponseDto,
GetConsumerHealthReportItem>(sql, requestDto));
}
