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