private void Init() { try { DataTable dt = new DataTable(); DAGame daGame = new DAGame(); Game myGame = new Game(); int result = daGame.GetGameBySearch(dtpStart.Value, dtpEnd.Value, txtTeam.Text.Trim(), ref dt); if (result == -1) { MessageBox.Show("查询失败,请重新运行本程序再试一次。"); return; } dgvGame.DataSource = dt; dgvGame.Columns[0].HeaderText = "比赛时间"; dgvGame.Columns[0].Width = 150; dgvGame.Columns[1].Width = 90; dgvGame.Columns[2].Width = 110; dgvGame.Columns[3].Width = 110; dgvGame.Columns[1].HeaderText = "联赛"; dgvGame.Columns[2].HeaderText = "主队"; dgvGame.Columns[3].HeaderText = "客队"; dgvGame.Columns[4].Visible = false;; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void ShowGame(int gameSN) { DataTable dtGame = new DataTable(); DataTable dtGameDetail = new DataTable(); DAGame daGame = new DAGame(); int result = daGame.GetGameByKey(gameSN, ref dtGame); if (result == -1) { MessageBox.Show("查询失败,请重新运行本程序再试一次。"); return; } result = daGame.GetGameDetailByKey(gameSN, ref dtGameDetail); if (result == -1) { MessageBox.Show("查询失败,请重新运行本程序再试一次。"); return; } if (dtGame.Rows.Count > 0) { GameForRpt.SN = gameSN; GameForRpt.League = dtGame.Rows[0]["League"].ToString(); GameForRpt.Home = dtGame.Rows[0]["Home"].ToString(); GameForRpt.Visitor = dtGame.Rows[0]["Visitor"].ToString(); GameForRpt.GameTime = DateTime.Parse(dtGame.Rows[0]["Gametime"].ToString()); GameForRpt.Score = dtGame.Rows[0]["Score"].ToString(); GameForRpt.Result = dtGame.Rows[0]["Result"].ToString(); GameForRpt.FinalSP = dtGame.Rows[0]["FinalSP"].ToString(); } else { MessageBox.Show("查询失败,请重新运行本程序再试一次。"); return; } DtGameDetail = dtGameDetail; #region 显示在窗体中 lblLeague.Text = GameForRpt.League; lblHome.Text = GameForRpt.Home; lblVisitor.Text = GameForRpt.Visitor; lblGameTime.Text = GameForRpt.GameTime.ToString("yyyy-MM-dd HH:mm"); lblScore.Text = DateTime.Parse(GameForRpt.Score).ToString("HH:mm").TrimStart('0'); lblResult.Text = GameForRpt.Result; lblFinalSP.Text = GameForRpt.FinalSP; dgvDetail.DataSource = dtGameDetail; dgvDetail.Columns[0].HeaderText = "变化时间"; dgvDetail.Columns[0].Width = 170; dgvDetail.Columns[1].HeaderText = "胜"; dgvDetail.Columns[2].HeaderText = "平"; dgvDetail.Columns[3].HeaderText = "负"; dgvDetail.Columns[4].HeaderText = "分"; dgvDetail.Columns[4].Visible = false; dgvDetail.Columns[0].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm"; #endregion }
private void tsmClearDB_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("此操作将清空所有已经导入的数据,您确定吗?", "", MessageBoxButtons.OKCancel); if (result == DialogResult.OK) { DAGame daGame = new DAGame(); if (daGame.DeleteAllGame() == 0) { MessageBox.Show("清空数据库成功。"); } else { MessageBox.Show("清空数据库失败。"); } } }
private void btnImport_Click(object sender, EventArgs e) { if (txtFilePath.Text.Equals(string.Empty)) { MessageBox.Show("请先选择文件。"); return; } int sheetsCount = ExcelUtils.GetSheetsCount(txtFilePath.Text); DataTable dtGame = new DataTable();; DataTable dtGameDetail = new DataTable(); string errorMsg = string.Empty; DAGame daGame = new DAGame(); Game myGame = new Game(); DataTable dtGameList = new DataTable(); dtGameList.Columns.Add("ID"); dtGameList.Columns.Add("NAME"); DataRow dr = dtGameList.NewRow(); for (int i = 0; i <= sheetsCount - 1; i++) { //比赛信息 dtGame = new DataTable(); dtGame.Columns.Add("League"); dtGame.Columns.Add("Home"); dtGame.Columns.Add("Visitor"); dtGame.Columns.Add("Gametime"); dtGame.Columns.Add("Score"); dtGame.Columns.Add("Result"); dtGame.Columns.Add("FinalSP"); //赔率信息 dtGameDetail = new DataTable(); dtGameDetail.Columns.Add("Changetime"); dtGameDetail.Columns.Add("B"); dtGameDetail.Columns.Add("C"); dtGameDetail.Columns.Add("D"); dtGameDetail.Columns.Add("Win"); dtGameDetail.Columns.Add("Draw"); dtGameDetail.Columns.Add("Lose"); dtGameDetail.Columns.Add("Changeminute"); //读取比赛信息 try { ExcelUtils.headRowCount = 1; ExcelUtils.dataRowCount = 1; ExcelUtils.dataColCount = 7; ExcelUtils.dtExcel = dtGame; ExcelUtils.indexDatatimeCol = "3,4"; dtGame = ExcelUtils.TranslateToTable(txtFilePath.Text, i); } catch { errorMsg += (i + 1).ToString() + ","; continue; } //读取赔率信息 try { ExcelUtils.headRowCount = 4; ExcelUtils.dataRowCount = 0; ExcelUtils.dataColCount = 8; ExcelUtils.dtExcel = dtGameDetail; ExcelUtils.indexDatatimeCol = "0"; dtGameDetail = ExcelUtils.TranslateToTable(txtFilePath.Text, i); } catch { errorMsg += (i + 1).ToString() + ","; continue; } myGame = new Game(); int result = daGame.GetMaxGameSN(); if (result == -1) { errorMsg += (i + 1).ToString() + ","; continue; } myGame.SN = result + 1; myGame.League = dtGame.Rows[0]["League"].ToString(); myGame.Home = dtGame.Rows[0]["Home"].ToString(); myGame.Visitor = dtGame.Rows[0]["Visitor"].ToString(); myGame.GameTime = DateTime.Parse(dtGame.Rows[0]["Gametime"].ToString()); myGame.Score = dtGame.Rows[0]["Score"].ToString(); myGame.Result = dtGame.Rows[0]["Result"].ToString(); myGame.FinalSP = dtGame.Rows[0]["FinalSP"].ToString(); result = daGame.InsertGameInfo(myGame, dtGameDetail); if (result == -1) { errorMsg += (i + 1).ToString() + ","; continue; } dr = dtGameList.NewRow(); dr[0] = myGame.SN; dr[1] = (i + 1).ToString() + "," + myGame.League + "---" + myGame.Home + " VS " + myGame.Visitor; dtGameList.Rows.Add(dr); } SetCmbGame(dtGameList); if (!string.IsNullOrEmpty(errorMsg)) { MessageBox.Show("第 " + errorMsg.TrimEnd(',') + " 个Sheet导入失败。"); } }
private void btnImport_Click(object sender, EventArgs e) { if (txtFilePath.Text.Equals(string.Empty)) { MessageBox.Show("请先选择文件。"); return; } int sheetsCount = ExcelUtils.GetSheetsCount(txtFilePath.Text); DataTable dtGame = new DataTable(); ; DataTable dtGameDetail = new DataTable(); string errorMsg = string.Empty; DAGame daGame = new DAGame(); Game myGame = new Game(); DataTable dtGameList = new DataTable(); dtGameList.Columns.Add("ID"); dtGameList.Columns.Add("NAME"); DataRow dr = dtGameList.NewRow(); for (int i = 0; i <= sheetsCount - 1; i++) { //比赛信息 dtGame = new DataTable(); dtGame.Columns.Add("League"); dtGame.Columns.Add("Home"); dtGame.Columns.Add("Visitor"); dtGame.Columns.Add("Gametime"); dtGame.Columns.Add("Score"); dtGame.Columns.Add("Result"); dtGame.Columns.Add("FinalSP"); //赔率信息 dtGameDetail = new DataTable(); dtGameDetail.Columns.Add("Changetime"); dtGameDetail.Columns.Add("B"); dtGameDetail.Columns.Add("C"); dtGameDetail.Columns.Add("D"); dtGameDetail.Columns.Add("Win"); dtGameDetail.Columns.Add("Draw"); dtGameDetail.Columns.Add("Lose"); dtGameDetail.Columns.Add("Changeminute"); //读取比赛信息 try { ExcelUtils.headRowCount = 1; ExcelUtils.dataRowCount = 1; ExcelUtils.dataColCount = 7; ExcelUtils.dtExcel = dtGame; ExcelUtils.indexDatatimeCol = "3,4"; dtGame = ExcelUtils.TranslateToTable(txtFilePath.Text, i); } catch { errorMsg += (i + 1).ToString() + ","; continue; } //读取赔率信息 try { ExcelUtils.headRowCount = 4; ExcelUtils.dataRowCount = 0; ExcelUtils.dataColCount = 8; ExcelUtils.dtExcel = dtGameDetail; ExcelUtils.indexDatatimeCol = "0"; dtGameDetail = ExcelUtils.TranslateToTable(txtFilePath.Text, i); } catch { errorMsg += (i + 1).ToString() + ","; continue; } myGame = new Game(); int result = daGame.GetMaxGameSN(); if (result == -1) { errorMsg += (i + 1).ToString() + ","; continue; } myGame.SN = result + 1; myGame.League = dtGame.Rows[0]["League"].ToString(); myGame.Home = dtGame.Rows[0]["Home"].ToString(); myGame.Visitor = dtGame.Rows[0]["Visitor"].ToString(); myGame.GameTime = DateTime.Parse(dtGame.Rows[0]["Gametime"].ToString()); myGame.Score = dtGame.Rows[0]["Score"].ToString(); myGame.Result = dtGame.Rows[0]["Result"].ToString(); myGame.FinalSP = dtGame.Rows[0]["FinalSP"].ToString(); result = daGame.InsertGameInfo(myGame, dtGameDetail); if (result == -1) { errorMsg += (i + 1).ToString() + ","; continue; } dr = dtGameList.NewRow(); dr[0] = myGame.SN; dr[1] = (i + 1).ToString() + "," + myGame.League + "---" + myGame.Home + " VS " + myGame.Visitor; dtGameList.Rows.Add(dr); } SetCmbGame(dtGameList); if (!string.IsNullOrEmpty(errorMsg)) { MessageBox.Show("第 "+errorMsg.TrimEnd(',')+" 个Sheet导入失败。"); } }
private void Init() { try { DataTable dt = new DataTable(); DAGame daGame = new DAGame(); Game myGame = new Game(); int result = daGame.GetGameBySearch(dtpStart.Value, dtpEnd.Value, txtTeam.Text.Trim(), ref dt); if (result == -1) { MessageBox.Show("查询失败,请重新运行本程序再试一次。"); return; } dgvGame.DataSource = dt; dgvGame.Columns[0].HeaderText = "比赛时间"; dgvGame.Columns[0].Width = 150; dgvGame.Columns[1].Width = 90; dgvGame.Columns[2].Width = 110; dgvGame.Columns[3].Width = 110; dgvGame.Columns[1].HeaderText = "联赛"; dgvGame.Columns[2].HeaderText = "主队"; dgvGame.Columns[3].HeaderText = "客队"; dgvGame.Columns[4].Visible = false; ; } catch (Exception ex) { MessageBox.Show(ex.Message); } }