private void CreateNewRound()
{
this._currentRound = new RouletteRoundInfo()
{
StartTime = DateTime.Now,
Finished = false,
MustWinAwardItemID = ReStartLargeAwardExponent()
};
}
private void InitLastRouletteRoundInfoFromDB()
{
this._currentRound = DBProvider.GameRouletteDBProvider.GetLastRouletteRoundInfo();
if (this._currentRound == null || this._currentRound.Finished)
{
this._currentRound = new RouletteRoundInfo()
{
StartTime = DateTime.Now,
Finished = false,
MustWinAwardItemID = ReStartLargeAwardExponent()
};
}
else
{
if (!this._listLargeAwardID.Contains(this._currentRound.MustWinAwardItemID))
{
this._currentRound.MustWinAwardItemID = ReStartLargeAwardExponent();
}
}
}
public bool SaveRouletteRoundInfo(RouletteRoundInfo info)
{
bool isAdd = false;
var lastInfo = GetLastRouletteRoundInfo();
if (lastInfo == null)
{
isAdd = true;
}
else if (lastInfo.Finished)
{
isAdd = true;
}
else
{
isAdd = false;
}
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
mycmd = myconn.CreateCommand();
string sqlInsertText = "";
if (isAdd)
{
sqlInsertText = "insert into rouletteroundinfo " +
" (`AwardPoolSumStone`, `WinAwardSumYuan`, `StartTime`, `MustWinAwardItemID`, `Finished`) " +
" values (@AwardPoolSumStone, @WinAwardSumYuan, @StartTime, @MustWinAwardItemID, @Finished )";
}
else
{
sqlInsertText = "update rouletteroundinfo " +
" set `AwardPoolSumStone` = @AwardPoolSumStone, `WinAwardSumYuan` = @WinAwardSumYuan, `StartTime` = @StartTime, `MustWinAwardItemID` = @MustWinAwardItemID, `Finished` = @Finished " +
" where id = @id ;";
mycmd.Parameters.AddWithValue("@id", lastInfo.ID);
}
mycmd.CommandText = sqlInsertText;
mycmd.Parameters.AddWithValue("@AwardPoolSumStone", info.AwardPoolSumStone);
mycmd.Parameters.AddWithValue("@WinAwardSumYuan", info.WinAwardSumYuan);
mycmd.Parameters.AddWithValue("@StartTime", info.StartTime);
mycmd.Parameters.AddWithValue("@MustWinAwardItemID", info.MustWinAwardItemID);
mycmd.Parameters.AddWithValue("@Finished", info.Finished);
mycmd.ExecuteNonQuery();
mycmd.Dispose();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
if (myconn != null)
{
myconn.Close();
myconn.Dispose();
}
}
}
public RouletteRoundInfoUIModel(RouletteRoundInfo parent)
{
this.ParentObject = parent;
}
