public static void CreateWinningPools(float PrizeRate, int prizeCount, int gameId) { List <int> pool = GetPool(GetGamePrizeListsByGameId(gameId).ToList <GamePrizeInfo>()); int num = (int)(((float)prizeCount) / (PrizeRate / 100f)); float num2 = ((float)prizeCount) % (PrizeRate / 100f); for (int i = 1; i < (num + 1); i++) { GameWinningPoolInfo model = new GameWinningPoolInfo { GameId = gameId, Number = i, GamePrizeId = (i < (prizeCount + 1)) ? pool[i - 1] : 0, IsReceive = 0 }; CreateWinningPool(model); } if (num2 > 0f) { GameWinningPoolInfo info2 = new GameWinningPoolInfo { GameId = gameId, Number = num + 1, GamePrizeId = 0, IsReceive = 0 }; CreateWinningPool(info2); } }
public static void CreateWinningPools(float PrizeRate, int prizeCount, int gameId) { GameWinningPoolInfo gameWinningPoolInfo; IList <GamePrizeInfo> gamePrizeListsByGameId = GameHelper.GetGamePrizeListsByGameId(gameId); List <int> pool = GameHelper.GetPool(gamePrizeListsByGameId.ToList <GamePrizeInfo>()); int num = (int)((float)prizeCount / (PrizeRate / 100f)); float single = (float)prizeCount % (PrizeRate / 100f); for (int i = 1; i < num + 1; i++) { gameWinningPoolInfo = new GameWinningPoolInfo() { GameId = gameId, Number = i, GamePrizeId = (i < prizeCount + 1 ? pool[i - 1] : 0), IsReceive = 0 }; GameHelper.CreateWinningPool(gameWinningPoolInfo); } if (single > 0f) { gameWinningPoolInfo = new GameWinningPoolInfo() { GameId = gameId, Number = num + 1, GamePrizeId = 0, IsReceive = 0 }; GameHelper.CreateWinningPool(gameWinningPoolInfo); } }
public static bool CreateWinningPool(GameWinningPoolInfo model) { if (model == null) { throw new ArgumentNullException("model参数不能为null"); } return(new GamePrizeDao().CreateWinningPool(model)); }
public bool CreateWinningPool(GameWinningPoolInfo model) { string query = "INSERT INTO [Hishop_PromotionWinningPool]\r\n ([GameId]\r\n ,[Number]\r\n ,[GamePrizeId]\r\n ,[IsReceive])\r\n VALUES\r\n (@GameId\r\n ,@Number\r\n ,@GamePrizeId\r\n ,@IsReceive);"; DbCommand sqlStringCommand = this._db.GetSqlStringCommand(query); this._db.AddInParameter(sqlStringCommand, "@GameId", DbType.Int32, model.GameId); this._db.AddInParameter(sqlStringCommand, "@Number", DbType.Int32, model.Number); this._db.AddInParameter(sqlStringCommand, "@GamePrizeId", DbType.Int32, model.GamePrizeId); this._db.AddInParameter(sqlStringCommand, "@IsReceive", DbType.Decimal, model.IsReceive); return(this._db.ExecuteNonQuery(sqlStringCommand) > 0); }