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);
}
