//显示赛事的基本信息
public void showTeamData()
{
//先清除DataGridView中的数据
if (dataGridView_teamManage.Rows.Count > 0)
{
dataGridView_teamManage.Rows.Clear();
}
//取出数据
List<Team> list =TeamInfoDAO.getTeamInfoOfCertainMatch(SystemParam.getMatch());
//往dataGridView中添加数据
for (int i = 0; i < list.Count; i++)
{
team = list[i]; //取出线性表中的赛事的信息
dataGridView_teamManage.Rows.Add(team.getID().ToString(), team.getName(),team.getTeamFullName(),team.getMatchName(), team.getLocation(),team.getBirthDate().ToString(),team.getIntroduction(),team.getLeader(),team.getManager(),team.getCoach());
}
}
//往数据库中添加球队，返回是否添加成功的信息
public static bool addNewTeam(Team team)
{
DBUtility dbutility = new DBUtility();
string SQL = "insert into team(teamName,teamLeader,teamManager,teamCoach,teamFullName,birthDate,matchName,location,introduction) values('";
SQL = SQL + team.getName() + "','" + team.getLeader() + "','" + team.getManager() + "','" + team.getCoach() + "','" + team.getTeamFullName() +
"','" + team.getBirthDate() + "','" + team.getMatchName() + "','" + team.getLocation()+ "','" + team.getIntroduction() + "')";
try
{
dbutility.openConnection();
dbutility.ExecuteUpdate(SQL);
return true;
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
return false;
}
finally
{
dbutility.Close();
}
}