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