private int CallProcRecordBannerProbabilities( MySqlConnection connection, MySqlTransaction transaction, DataGachaSeriesItemDetails itemDetails, uint SeriesID, bool isJP) { Decimal num1 = !itemDetails.ProbabilityByRarity.OneStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.OneStar.Value; Decimal num2 = !itemDetails.ProbabilityByRarity.TwoStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.TwoStar.Value; Decimal num3 = !itemDetails.ProbabilityByRarity.ThreeStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.ThreeStar.Value; Decimal num4 = !itemDetails.ProbabilityByRarity.FourStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.FourStar.Value; Decimal num5 = !itemDetails.ProbabilityByRarity.FiveStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.FiveStar.Value; Decimal num6 = !itemDetails.ProbabilityByRarity.SixStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.SixStar.Value; Decimal num7 = !itemDetails.ProbabilityByRarity.SevenStar.HasValue ? 0M : itemDetails.ProbabilityByRarity.SevenStar.Value; using (MySqlCommand mySqlCommand = new MySqlCommand("record_banner_probabilities", connection, transaction)) { mySqlCommand.CommandType = CommandType.StoredProcedure; mySqlCommand.Parameters.AddWithValue("@bid", (object)SeriesID); mySqlCommand.Parameters.AddWithValue("@isjp", (object)isJP); mySqlCommand.Parameters.AddWithValue("@r1", (object)num1); mySqlCommand.Parameters.AddWithValue("@r2", (object)num2); mySqlCommand.Parameters.AddWithValue("@r3", (object)num3); mySqlCommand.Parameters.AddWithValue("@r4", (object)num4); mySqlCommand.Parameters.AddWithValue("@r5", (object)num5); mySqlCommand.Parameters.AddWithValue("@r6", (object)num6); mySqlCommand.Parameters.AddWithValue("@r7", (object)num7); mySqlCommand.Parameters.AddWithValue("@assuredrarity", (object)itemDetails.AssuredRarity); mySqlCommand.Parameters.AddWithValue("@boostrate", (object)itemDetails.BoostRateAssured); mySqlCommand.Parameters.AddWithValue("@equalprob", (object)itemDetails.EqualProbInRarity); return(mySqlCommand.ExecuteNonQuery()); } }
public DbOpRecordGachaProbabilities( DataGachaSeriesItemDetails itemDetails, uint seriesID, ulong serverTime) { this.mItemDetails = itemDetails; this.mSeriesID = seriesID; this.serverTime = serverTime; }