////////获取当前赛事的球队信息
/*
* 查询数据库中的球队的基本信息，并且返回到一个线性表中
*/
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();
}
}
}
}
