/// <summary> /// 总积分 /// </summary> /// <param name="userGuid">用户GUID</param> /// <param name="requestDto">查询Dto</param> /// <param name="userType">用户类型</param> /// <returns></returns> private async Task <int?> GetVariationAll(string userGuid, GetDoctorScoreAllInfoRequestDto requestDto, UserType userType) { StringBuilder sb = new StringBuilder("select sum(variation) from t_utility_score where 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.QuerySingleAsync <int?>(sb.ToString(), parameters)); } }