/// <summary>
/// 获取积分Model
/// </summary>
/// <param name="requestDto">医生积分查询dto</param>
/// <returns></returns>
public async Task <ScorePageDto <GetDoctorScoreResponseDto> > GetScoreModels(GetDoctorScoreRequestDto requestDto)
{
StringBuilder sb = new StringBuilder("select creation_date as CreationDate,variation as Variation,reason as Reason from t_utility_score where user_guid=@userId and user_type_guid=@userType ");
if (!string.IsNullOrWhiteSpace(requestDto.UserActionGuid))
{
sb.Append(@" and rules_guid = @UserActionGuid ");
requestDto.UserActionGuid = $"{requestDto.UserActionGuid}";
}
if (requestDto.startTime != null)
{
sb.Append(" and creation_date>@startTime ");
}
if (requestDto.endTime != null)
{
sb.Append(" and creation_date<@endTime ");
}
sb.Append(" order by creation_date desc ");
using (MySql.Data.MySqlClient.MySqlConnection conn = MySqlHelper.GetConnection())
{
return(await MySqlHelper.QueryByPageAsync <GetDoctorScoreRequestDto, ScorePageDto <GetDoctorScoreResponseDto>, GetDoctorScoreResponseDto>(sb.ToString(), requestDto));
}
}
/// <summary>
/// 获取医生积分Dto
/// </summary>
/// <param name="doctorGuid">医生GUID</param>
/// <param name="requestDto">医生积分查询dto</param>
/// <returns></returns>
public async Task <ScorePageDto <GetDoctorScoreResponseDto> > GetDoctorScoreResponseDtoList(string doctorGuid, GetDoctorScoreRequestDto requestDto)
{
ScorePageDto <GetDoctorScoreResponseDto> result = new ScorePageDto <GetDoctorScoreResponseDto>();
UserModel user = new Utility.UserBiz().GetUser(doctorGuid);
DoctorModel doctor = new DoctorBiz().GetDoctor(doctorGuid);
if (doctor != null)
{
requestDto.userId = doctorGuid;
requestDto.userType = UserType.Doctor.ToString();
requestDto.startTime = GetStartDate(requestDto.startTime);
requestDto.endTime = GetEndDate(requestDto.endTime);
result = await GetScoreModels(requestDto);
foreach (var item in result.CurrentPage)
{
if (item.Variation > 0)
{
item.IncomeVariation = item.Variation;
}
else
{
item.OutlayVariation = item.Variation;
}
}
}
return(result);
}
public async Task <IActionResult> GetDoctorScore([FromBody] GetDoctorScoreRequestDto requestDto)
{
return(Success(await new DoctorScoreBiz().GetDoctorScoreResponseDtoList(this.UserID, requestDto)));
}
