public async Task <IActionResult> GetHealthManagerFllowupRecords([FromQuery] GetHealthManagerFllowupRecordsRequestDto request) { var managerBiz = new HealthManagerBiz(); var response = await managerBiz.GetHealthManagerFllowupRecords(request); return(Success(response)); }
/// <summary> /// 查询指定会员随访记录分页列表 /// </summary> /// <param name="requestDto"></param> /// <returns></returns> public async Task <GetHealthManagerFllowupRecordsResponseDto> GetHealthManagerFllowupRecords(GetHealthManagerFllowupRecordsRequestDto requestDto) { var sql = @"SELECT m.user_name,m.phone,f.content,f.suggestion,f.followup_time FROM t_health_manager_followup_record as f INNER JOIN t_health_manager as m ON m.manager_guid = f.health_manager_guid WHERE f.consumer_guid = @ConsumerGuid"; if (!string.IsNullOrEmpty(requestDto.KeyWord)) { sql = $"{sql} and (m.user_name like '%{requestDto.KeyWord}%' or m.phone like '%{requestDto.KeyWord}%')"; } if (requestDto.FollowUpTime.HasValue && requestDto.EndTime.HasValue) { requestDto.EndTime = requestDto.EndTime.Value.AddDays(1); sql = $"{sql} and f.followup_time >= @FollowUpTime and f.followup_time < @EndTime"; } sql = $"{sql} order by f.followup_time desc"; return(await MySqlHelper.QueryByPageAsync <GetHealthManagerFllowupRecordsRequestDto, GetHealthManagerFllowupRecordsResponseDto, GetHealthManagerFllowupRecordsItem>(sql, requestDto)); }