public GambleStoneInningRunner(GambleStoneRoundInfo roundInfo, GambleStoneInningInfo inning, GambleStoneDailyScheme dailyScheme, ReferBetInInningInfo referInfo) { this._roundInfo = roundInfo; this._inningInfo = inning; this._dailyScheme = dailyScheme; this._referInfo = referInfo; }
public void LoadFromDB() { DateTime nowDate = DateTime.Now; GambleStoneDailyScheme lastDailyScheme = DBProvider.GambleStoneDBProvider.GetLastGambleStoneDailyScheme(); if (lastDailyScheme != null && lastDailyScheme.Date != null && lastDailyScheme.Date.Year == nowDate.Year && lastDailyScheme.Date.Month == nowDate.Month && lastDailyScheme.Date.Day == nowDate.Day) { this.DailyScheme = lastDailyScheme; } else { CreateNewDailyScheme(lastDailyScheme); } GambleStoneRoundInfo lastRound = DBProvider.GambleStoneDBProvider.GetLastGambleStoneRoundInfo(); if (lastRound != null && lastRound.FinishedInningCount < GlobalConfig.GameConfig.GambleStone_Round_InningCount) { this.RoundInfo = lastRound; } else { this.RoundInfo = CreateNewRound(lastRound); } }
public bool AddGambleStoneDailyScheme(GambleStoneDailyScheme dailyScheme) { return(MyDBHelper.Instance.ConnectionCommandExecuteNonQuery(mycmd => { string sqlText = "insert into gamblestonedailyscheme (`Date`,`ProfitStoneObjective`,`AllBetInStone`,`AllWinnedOutStone` ) " + " values ( @Date,@ProfitStoneObjective,@AllBetInStone,@AllWinnedOutStone ) "; mycmd.CommandText = sqlText; mycmd.Parameters.AddWithValue("@Date", dailyScheme.Date.ToDateTime()); mycmd.Parameters.AddWithValue("@ProfitStoneObjective", dailyScheme.ProfitStoneObjective); mycmd.Parameters.AddWithValue("@AllBetInStone", dailyScheme.AllBetInStone); mycmd.Parameters.AddWithValue("@AllWinnedOutStone", dailyScheme.AllWinnedOutStone); mycmd.ExecuteNonQuery(); })); }
private void CreateNewDailyScheme(GambleStoneDailyScheme lastDailyScheme) { if (lastDailyScheme != null) { int allProfit = lastDailyScheme.AllWinnedOutStone - lastDailyScheme.AllBetInStone; } DateTime nowDate = DateTime.Now; GambleStoneDailyScheme newDailyScheme = new GambleStoneDailyScheme() { Date = new MyDateTime(nowDate), ProfitStoneObjective = GlobalConfig.GameConfig.GambleStone_DailyProfitStoneObjective, }; DBProvider.GambleStoneDBProvider.AddGambleStoneDailyScheme(newDailyScheme); this.DailyScheme = newDailyScheme; }
public bool UpdateGambleStoneDailyScheme(GambleStoneDailyScheme dailyScheme) { return(MyDBHelper.Instance.ConnectionCommandExecuteNonQuery(mycmd => { string sqlText = "update gamblestonedailyscheme set `Date`=@Date,`ProfitStoneObjective`=@ProfitStoneObjective,`AllBetInStone`=@AllBetInStone,`AllWinnedOutStone`=@AllWinnedOutStone " + " where id = @ID "; mycmd.CommandText = sqlText; mycmd.Parameters.AddWithValue("@Date", dailyScheme.Date.ToDateTime()); mycmd.Parameters.AddWithValue("@ProfitStoneObjective", dailyScheme.ProfitStoneObjective); mycmd.Parameters.AddWithValue("@AllBetInStone", dailyScheme.AllBetInStone); mycmd.Parameters.AddWithValue("@AllWinnedOutStone", dailyScheme.AllWinnedOutStone); mycmd.Parameters.AddWithValue("@ID", dailyScheme.ID); mycmd.ExecuteNonQuery(); })); }
public GambleStoneDailyScheme GetLastGambleStoneDailyScheme() { GambleStoneDailyScheme lastScheme = null; MyDBHelper.Instance.ConnectionCommandSelect(mycmd => { string sqlText = "select * from gamblestonedailyscheme order by id desc limit 1"; mycmd.CommandText = sqlText; DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd); adapter.Fill(table); GambleStoneDailyScheme[] schemes = MetaDBAdapter <GambleStoneDailyScheme> .GetGambleStoneDailySchemeFromDataTable(table); if (schemes != null && schemes.Length == 1) { lastScheme = schemes[0]; } table.Clear(); table.Dispose(); adapter.Dispose(); }); return(lastScheme); }