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