private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) { if (treeView1.SelectedNode == treeView1.Nodes[0])//增删查改用户 { CapForm sub = new CapForm(); sub.TopLevel = false; sub.Dock = DockStyle.Fill;//把子窗体设置为控件 PanelRightMain.Controls.Clear(); PanelRightMain.Controls.Add(sub); sub.Show(); ToolStripButton tsb = new ToolStripButton("盒码采集"); toolStrip1.Items.Clear(); toolStrip1.Items.Add(tsb); } else if (treeView1.SelectedNode == treeView1.Nodes[1])//增删查改用户 { Upload sub = new Upload(); sub.TopLevel = false; sub.Dock = DockStyle.Fill;//把子窗体设置为控件 PanelRightMain.Controls.Clear(); PanelRightMain.Controls.Add(sub); sub.Show(); ToolStripButton tsb = new ToolStripButton("上传箱号"); toolStrip1.Items.Clear(); toolStrip1.Items.Add(tsb); } else if (treeView1.SelectedNode == treeView1.Nodes[2])//增删查改用户 { CapCaseAndBox sub = new CapCaseAndBox(); sub.TopLevel = false; sub.Dock = DockStyle.Fill;//把子窗体设置为控件 PanelRightMain.Controls.Clear(); PanelRightMain.Controls.Add(sub); sub.Show(); ToolStripButton tsb = new ToolStripButton("上传箱号"); toolStrip1.Items.Clear(); toolStrip1.Items.Add(tsb); } }
private void btnCommit_Click(object sender, EventArgs e) { using (var Content = new DataClassesDataContext()) { if (dtpGameDate.Value == GetLastUploadGameDate()) { MessageBox.Show("An upload for this game date has already occured", "Cannot Proceed", MessageBoxButtons.OK); return; } //create a new upload var newUpload = new Upload(); newUpload.GameDate = dtpGameDate.Value; newUpload.UploadDate = DateTime.Now.Date; newUpload.SeasonID = _SeasonID; Content.Uploads.InsertOnSubmit(newUpload); Content.SubmitChanges(); foreach (var teamModel in Teams) { //Update or create record var record = Content.Records.FirstOrDefault(x => x.TeamID == teamModel.TeamID && x.SeasonID == _SeasonID); if (record == null) { record = new Record(); record.TeamID = teamModel.TeamID; record.SeasonID = _SeasonID; record.Wins = teamModel.Wins; record.Losses = teamModel.Losses; record.PythWins = teamModel.PythWins; record.PythLosses = teamModel.PythLosses; record.DateModified = DateTime.Now.Date; Content.Records.InsertOnSubmit(record); Content.SubmitChanges(); } else { record.Wins = teamModel.Wins; record.Losses = teamModel.Losses; record.PythWins = teamModel.PythWins; record.PythLosses = teamModel.PythLosses; record.DateModified = DateTime.Now.Date; Content.SubmitChanges(); } //Update or create opponentrecords foreach (var opponentModel in teamModel.OpponentsList) { if (opponentModel.WinsVersus != 0 || opponentModel.LossesVersus != 0) { var opponentRecord = Content.OpponentsRecords.FirstOrDefault( x => x.TeamID == teamModel.TeamID && x.OpponentTeamID == opponentModel.OpponentTeamID && x.SeasonID == _SeasonID); if (opponentRecord == null) { opponentRecord = new OpponentsRecord(); opponentRecord.SeasonID = _SeasonID; opponentRecord.TeamID = teamModel.TeamID; opponentRecord.OpponentTeamID = opponentModel.OpponentTeamID; opponentRecord.WinsAgainst = opponentModel.WinsVersus; opponentRecord.LossesAgainst = opponentModel.LossesVersus; opponentRecord.DateModified = DateTime.Now.Date; Content.OpponentsRecords.InsertOnSubmit(opponentRecord); Content.SubmitChanges(); } else { opponentRecord.WinsAgainst = opponentModel.WinsVersus; opponentRecord.LossesAgainst = opponentModel.LossesVersus; opponentRecord.DateModified = DateTime.Now.Date; Content.SubmitChanges(); } } } //Insert team calculations - new for each upload var calculations = new TeamCalculation(); calculations.UploadID = newUpload.UploadID; calculations.SeasonID = _SeasonID; calculations.TeamID = teamModel.TeamID; calculations.WP = teamModel.WinningPercentage; calculations.OWP = teamModel.OpponentsWinPercentage; calculations.OOWP = teamModel.OpponentsOpponentWinPercentage; calculations.SoS = teamModel.StrengthOfSchedule; calculations.RPI = teamModel.RPI; calculations.PythOOWP = teamModel.PythOpponentsOpponentWinPercentage; calculations.PythOWP = teamModel.PythOpponentsWinPercentage; calculations.PythRPI = teamModel.PythRPI; calculations.PythWP = teamModel.PythWinPercentage; calculations.DateCreated = DateTime.Now.Date; Content.TeamCalculations.InsertOnSubmit(calculations); Content.SubmitChanges(); } } this.Close(); }