////////获取当前赛事的球队信息 /* * 查询数据库中的球队的基本信息,并且返回到一个线性表中 */ public static List<Schedule> getScheduleInfo(SeasonOfMatch season) { //声明实例 List<Schedule> list = new List<Schedule>(); //执行查询数据库操作 DBUtility dbutility = new DBUtility(); string SQL = "select seasonId,matchId,turn,gameDate,homeTeamName,guestTeamName from schedule where seasonId= " + season.getNumOfSeason(); try { dbutility.openConnection(); MySqlDataReader rd = dbutility.ExecuteQuery(SQL); while (rd.Read()) { Schedule s = new Schedule(); s.setSeasonId(Convert.ToInt32(rd[0])); s.setMatchId(Convert.ToInt32(rd[1])); s.setTurn(Convert.ToInt32(rd[2])); s.setGameDate(Convert.ToString(rd[3])); s.setHomeTeam(Convert.ToString(rd[4])); s.setGuestTeam(Convert.ToString(rd[5])); list.Add(s); } } catch (MySqlException ex) { Console.WriteLine(ex.ToString()); } finally { dbutility.Close(); } return list; }
//显示赛事的基本信息 public void showSeasonData() { //先清除DataGridView中的数据 if (dataGridView_seasons.Rows.Count > 0) { dataGridView_seasons.Rows.Clear(); } //取出数据 //此处应该判断一下当前选择赛事与赛季没有 List<SeasonOfMatch> list = SeasonInfoDAO.getSeasonsOfCertainMatch(SystemParam.getMatch().getName()); //往dataGridView中添加数据 for (int i = 0; i < list.Count; i++) { season = list[i]; //取出线性表中的赛事的信息 dataGridView_seasons.Rows.Add(season.getId().ToString(), season.getmatchName(), season.getSeasonDescription(), season.getNumOfSeason().ToString() ); } }
//添加一个赛事的新赛季记录, private void addNewSeasonInfo( ) { if(textBox_numOfSeason.Text!=""){ if (checkSwitchResult.checkStringSwitchInteger(textBox_numOfSeason.Text)) { } if(this.textBox_NumOfTurn.Text!="" ){ { int numOfseason = Convert.ToInt32(textBox_numOfSeason.Text); string seasonMatchName = textBox_MatchName.Text.Trim(); string description = textBox_seasonDescInfo.Text; int numOfTurn = Convert.ToInt32(this.textBox_NumOfTurn.Text); SeasonOfMatch newSeason = new SeasonOfMatch(seasonMatchName,numOfseason); newSeason.setSeasonDescription(description); newSeason.setNumOfTurn(numOfTurn); SeasonInfoDAO.getMaxId(); newSeason.setId(SeasonInfoDAO.getMaxId()+1); SeasonInfoDAO.addNewSeasonInfo(newSeason); //弹出对话框,提示是否继续添加 if (MessageBox.Show("添加赛季信息成功,!", "添加新赛季成功", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { //清空其他 //textBox_MatchName.Text = ""; int num=SeasonInfoDAO.getMaxSeasonNumOfMatch(SystemParam.getMatch().getName()) + 1; label_numHelp.Text = "* 最近赛季为第" + (num - 1) + "季"; textBox_numOfSeason.Text =Convert.ToString(num); textBox_seasonDescInfo.Text = ""; } else { this.Close(); } } } else{ MessageBox.Show("没有填写赛季的比赛轮次数目!"); } } else { MessageBox.Show("没有填写当前赛季届数"); } }
/**** *** 新增某一个赛季的信息 ****/ public static void addNewSeasonInfo(SeasonOfMatch season) { DBUtility dbutility = new DBUtility(); string sql = "insert into gameseason(id,matchname,numofseason,seasondescription,isCurrentSeason,numOfTurn) values('" + season.getId() +"','" + season.getmatchName() + "','" + season.getNumOfSeason() + "','" + season.getSeasonDescription() + "',"+1+","+season.getNumOfTurn()+")"; try { dbutility.openConnection(); dbutility.ExecuteUpdate(sql); } catch (MySqlException ex) { Console.WriteLine(ex.ToString()); } finally { dbutility.Close(); } }
//当前选定的赛季 public static void setCurrentSelectedSeason(SeasonOfMatch currentSelecteSeason) { _currentSelectedSeason = currentSelecteSeason; }
//选择的值改变,则下边的赛季描述改变 private void listBox_Seasons_SelectedIndexChanged(object sender, EventArgs e) { if(seasonList.Count>0){ foreach (SeasonOfMatch s in seasonList) { if (listBox_Seasons.SelectedItem.ToString().Trim() == ("第" + s.getNumOfSeason() + "赛季")) //此处仍然存在空值问题 { season = s; //作为选定的赛季 richTextBox_SeasonDescription.Text = season.getSeasonDescription(); } } } }