/// <summary> /// /// </summary> public void SaveBetRecords() { try { using (var db = new SQLiteDB()) { //var max = db.BetScoreRecords.Max(b => b.SessionIndex); //var last_acc = db.FrontAccounts.FirstOrDefault(a => a.IsClear == false); //if (last_acc != null) //{ // var time = last_acc.CreateTime; // if (max >= 29) // { // var range = db.BetScoreRecords.Where(b => (max - b.SessionIndex) > 0 // && b.CreateTime < time); // if (range != null) // { // db.BetScoreRecords.RemoveRange(range); // } // } //} var live_data = Game.Instance.BetBackLiveData; var record = new BetScoreRecord() { CreateTime = DateTime.Now, SessionIndex = live_data.SessionIndex, RoundIndex = live_data.RoundIndex, DeskBanker = live_data.DeskBanker, DeskPlayer = live_data.DeskPlayer, DeskTie = live_data.DeskTie, Winner = live_data.Winner, JsonPlayerScores = live_data.JsonPlayerScores }; var history = db.BetScoreRecords.FirstOrDefault(b => b.SessionIndex == record.SessionIndex && b.RoundIndex == record.RoundIndex); if (history != null) { db.BetScoreRecords.Remove(history); } db.BetScoreRecords.Add(record); //db.BetScoreRecords.Add(record); db.SaveChanges(); } } catch (Exception ex) { #if DEBUG MessageBox.Show(ex.Message + ex.StackTrace); #endif MessageBox.Show("程序数据库故障,重启游戏或联系工程师"); } }
public void SaveNewSession(Session session) { if (session == null) { return; } try { using (var db = new SQLiteDB()) { foreach (var round in session.RoundsOfSession) { var record = new BetScoreRecord() { CreateTime = DateTime.Now, SessionIndex = session.SessionId, RoundIndex = session.RoundsOfSession.IndexOf(round), DeskBanker = 0, DeskPlayer = 0, DeskTie = 0, Winner = (int)round.Winner.Item1, JsonPlayerScores = "" }; var history = db.BetScoreRecords.FirstOrDefault(b => b.SessionIndex == record.SessionIndex && b.RoundIndex == record.RoundIndex); if (history != null) { db.BetScoreRecords.Remove(history); } db.BetScoreRecords.Add(record); } db.SaveChanges(); } } catch (Exception ex) { MessageBox.Show(ex.Message + ex.StackTrace + ex.InnerException.Message); } }