예제 #1
0
        /// <summary>
        /// 收入总积分
        /// </summary>
        /// <param name="userGuid">用户GUID</param>
        /// <param name="requestDto">查询Dto</param>
        /// <param name="userType">用户类型</param>
        /// <returns></returns>
        private async Task <int?> GetOutlayVariationAll(string userGuid, GetDoctorScoreAllInfoRequestDto requestDto, UserType userType)
        {
            StringBuilder     sb         = new StringBuilder("select sum(variation) from t_utility_score where variation<0 and user_guid=@user_guid and user_type_guid=@userType");
            DynamicParameters parameters = new DynamicParameters();

            parameters.Add("user_guid", userGuid, System.Data.DbType.String);
            parameters.Add("userType", userType.ToString(), System.Data.DbType.String);

            if (requestDto.startTime != null)
            {
                sb.Append(" and creation_date>@startTime ");
                parameters.Add("startTime", requestDto.startTime, System.Data.DbType.DateTime);
            }
            if (requestDto.endTime != null)
            {
                sb.Append(" and creation_date<@endTime ");
                parameters.Add("endTime", requestDto.endTime, System.Data.DbType.DateTime);
            }
            using (MySql.Data.MySqlClient.MySqlConnection conn = MySqlHelper.GetConnection())
            {
                return(await conn.QueryFirstAsync <int?>(sb.ToString(), parameters));
            }
        }
예제 #2
0
        /// <summary>
        /// 获取医生积分所有信息
        /// </summary>
        /// <param name="userID">医生GUID</param>
        /// <param name="requestDto">医生积分查询dto</param>
        /// <returns></returns>
        public async Task <GetDoctorScoreAllInfoResponseDto> GetDoctorScoreAllInfo(string userID, GetDoctorScoreAllInfoRequestDto requestDto)
        {
            GetDoctorScoreAllInfoResponseDto scoreAll = new GetDoctorScoreAllInfoResponseDto();

            requestDto.startTime = GetStartDate(requestDto.startTime);
            requestDto.endTime   = GetEndDate(requestDto.endTime);

            scoreAll.AllVariation = await GetVariationAll(userID, requestDto, UserType.Doctor) ?? 0;

            scoreAll.IncomeALLVariation = await GetIncomeVariationAll(userID, requestDto, UserType.Doctor) ?? 0;

            scoreAll.OutlayALLVariation = await GetOutlayVariationAll(userID, requestDto, UserType.Doctor) ?? 0;

            return(scoreAll);
        }
예제 #3
0
 public async Task <IActionResult> GetDoctorScoreAllInfo([FromBody] GetDoctorScoreAllInfoRequestDto requestDto)
 {
     return(Success(await new DoctorScoreBiz().GetDoctorScoreAllInfo(this.UserID, requestDto)));
 }