public async Task <IActionResult> GetReviewDoctorPageAsync([FromBody] GetReviewDoctorPageRequestDto request) { var response = await new DoctorBiz().GetReviewDoctorPageAsync(request); foreach (var item in response.CurrentPage) { if (item.Status == DoctorModel.StatusEnum.Submit.ToString()) { item.LastUpdatedDate = null; } ; } return(Success(response)); }
/// <summary> /// 审核医生列表 /// </summary> /// <param name="request"></param> /// <returns></returns> public async Task <GetReviewDoctorPageResponseDto> GetReviewDoctorPageAsync(GetReviewDoctorPageRequestDto request) { var sqlWhere = $@"1=1 ";//and enable=1 if (!string.IsNullOrWhiteSpace(request.Name)) { sqlWhere = $"{sqlWhere} AND user_name like @Name"; } if (!string.IsNullOrWhiteSpace(request.Status)) { sqlWhere = $"{sqlWhere} AND status = @Status"; } if (request.BeginDate != null) { request.BeginDate = request.BeginDate?.Date; sqlWhere = $"{sqlWhere} AND creation_date > @BeginDate"; } if (request.EndDate != null) { request.EndDate = request.EndDate?.AddDays(1).Date; sqlWhere = $"{sqlWhere} AND creation_date < @EndDate"; } var sql = $@" SELECT * FROM( SELECT A.*, CONCAT( B.base_path, B.relative_path ) AS PortraitUrl, CONCAT( D.base_path, D.relative_path ) AS signatureUrl, C.user_name, C.Gender FROM t_doctor A LEFT JOIN t_utility_accessory B ON B.accessory_guid = A.portrait_guid LEFT JOIN t_utility_accessory D ON D.accessory_guid = A.signature_guid LEFT JOIN t_utility_user C ON C.user_guid = A.doctor_guid ) t WHERE {sqlWhere} ORDER BY creation_date desc" ; request.Name = $"%{request.Name}%"; return(await MySqlHelper.QueryByPageAsync <GetReviewDoctorPageRequestDto, GetReviewDoctorPageResponseDto, GetReviewDoctorPageItemDto>(sql, request)); }