//获取某一球员在某一赛事中所有停赛记录的总和
public static int getPlayerSuspendedQuantity(int matchID, int playerID)
{
int quantity = 0;
DBUtility dbutility = new DBUtility();
//查询某个球员所有停赛记录，同一场球赛不能被停赛两次或两次以上
string sql = "select COUNT(DISTINCT gameNum) from suspendedrecord where matchID=" + matchID;
sql = sql + " and playerID=" + playerID;
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(sql);
while (rd.Read())
{
quantity = Convert.ToInt32(rd[0]);
}
}
catch (MySqlException ex)
{
Console.Write(ex.ToString());
}
finally
{
dbutility.Close();
}
return quantity;
}
//检查赛事名称是否存在
public static bool checkMatchNameExist(string name)
{
bool flag = false;
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select ID,seasonName,description from matchinfo where seasonName='" + name + "'";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
flag = true;
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return flag;
}
//检查某一赛事中某一比赛序号是否存在
public static bool checkGameNumExist(int matchID, int gameNum)
{
bool flag = false;
DBUtility dbutility = new DBUtility();
string sql = "select uniqueID,matchID,matchGameNum,gameName,homeTeam,guestTeam,gameWinner,";
sql = sql + "gameResult,gameAddress,gameDate from gameInfo where matchGameNum=" + gameNum + "";
sql = sql + " and matchID=" + matchID;
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(sql);
while (rd.Read())
{
flag = true;
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return flag;
}
public static List<SeasonOfMatch> AllSeasons()
{
List<SeasonOfMatch> list = new List<SeasonOfMatch>();
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select id,matchname,seasondescription,numofseason,numOfTurn from gameseason order by id";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
list.Add(new SeasonOfMatch(Convert.ToInt32(rd[0]), Convert.ToString(rd[1]), Convert.ToString(rd[2]), Convert.ToInt32(rd[3]), Convert.ToInt32(rd[4])));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return list;
}
//检查赛季表特定赛事的赛季是否为空,不为空返回false
public static bool checkSeasonOfCertainMatchIsNull(string matchName)
{
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select count(ID) from gameseason where matchname = '" + matchName + "' ";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
if (Convert.ToInt32(rd[0]) != 0)
return false;
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return true;
}
public static void getDefaultSet()
{
DBUtility dbutility = new DBUtility();
string sql = "select * from defaultset;";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(sql);
while (rd.Read())
{
DefaultSet.setDefaultSeason(Convert.ToString(rd[0]));
DefaultSet.setDedaultMatch(Convert.ToString(rd[1]));
DefaultSet.setDefaultTurn(Convert.ToInt32(rd[2]));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
// MessageBox.Show(ex.ToString());
}
finally
{
dbutility.Close();
}
}
//检查某一个赛事中，比赛数量是否满足条件
public static bool checkGameNumLegal(int matchID,int gameNum)
{
bool flag = false;
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select serialNum from matchinfo where ID=" + matchID + "";
int _gameNum = -1;
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
_gameNum = Convert.ToInt32(rd[0]);
}
//判断某一赛事中比赛的总量是否是大于新添加的比赛的比赛序号
if (gameNum <= _gameNum)
{
flag = true;
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return flag;
}
///
///<Summary> 用来处理球员停赛信息的数据库操作</Summary>
///
//检查某一场比赛中，某一个球员是否已经有停赛记录
public static bool checkPlayerSuspended(int playerID,int matchID,int gameNum)
{
bool flag = false;
DBUtility dbutility = new DBUtility();
string sql = "select * from suspendedrecord where matchID=" + matchID + " and gameNum=" + gameNum;
sql = sql + " and playerID=" + playerID;
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(sql);
while (rd.Read())
{
flag = true;
}
}
catch (MySqlException ex)
{
Console.Write(ex.ToString());
}
finally
{
dbutility.Close();
}
return flag;
}
////////获取当前赛事的球队信息
/*
* 查询数据库中的球队的基本信息，并且返回到一个线性表中
*/
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 static List<PlayerCardRecord> getMatchCardRecord(int matchID)
{
List<PlayerCardRecord> list = new List<PlayerCardRecord>();
DBUtility dbutility = new DBUtility();
string sql = "select playergetcardrecord.uniqueID,playergetcardrecord.matchID,matchinfo.seasonName,";
sql = sql + "playergetcardrecord.playerID,player.playerName,playergetcardrecord.yellowCardNum,";
sql = sql + "playergetcardrecord.redCardNum,playergetcardrecord.serialNum,playergetcardrecord.getDate,gameinfo.gameName from ";
sql = sql + "playergetcardrecord,player,matchinfo,gameinfo where playergetcardrecord.matchID=matchinfo.ID and ";
sql = sql + "gameinfo.matchID=playergetcardrecord.matchID and playergetcardrecord.serialNum=gameinfo.matchGameNum and ";
sql = sql + "playergetcardrecord.playerID=player.ID and playergetcardrecord.matchID=" + matchID;
sql = sql + " order by playergetcardrecord.serialNum";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(sql);
while (rd.Read())
{
PlayerCardRecord playerCardRecord = new PlayerCardRecord();
playerCardRecord.setUniqueID(Convert.ToInt32(rd[0]));
playerCardRecord.setMatchID(Convert.ToInt32(rd[1]));
playerCardRecord.setMatchName(Convert.ToString(rd[2]));
playerCardRecord.setPlayerID(Convert.ToInt32(rd[3]));
playerCardRecord.setPlayerName(Convert.ToString(rd[4]));
playerCardRecord.setYellowCardNum(Convert.ToInt32(rd[5]));
playerCardRecord.setRedCardNum(Convert.ToInt32(rd[6]));
playerCardRecord.setSerialNum(Convert.ToInt32(rd[7]));
playerCardRecord.setDateTime(Convert.ToDateTime(rd[8]));
playerCardRecord.setGameName(Convert.ToString(rd[9]));
list.Add(playerCardRecord);
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return list;
}
//自定义下拉列表的列表项
public void InitHomeTeamColumnsSet(string team)
{
DataTable teamTable = new DataTable();
DBUtility dbutility = new DBUtility();
string SQL = "select teamName from team where matchName='"+SystemParam.getMatch().getName()+"' order by ID";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
teamTable.Load(rd);
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
((DataGridViewComboBoxColumn)this.dataGridView1.Columns[team]).DataSource =teamTable;
((DataGridViewComboBoxColumn)this.dataGridView1.Columns[team]).DataPropertyName = "teamName";
((DataGridViewComboBoxColumn)this.dataGridView1.Columns[team]).DisplayMember = "teamName";
}
//获取某一球员在某一赛事中所有的停赛记录
public static List<SuspendedRecord> getPlayerSuspendedRecord(int matchID,int playerID)
{
List<SuspendedRecord> list = new List<SuspendedRecord>();
DBUtility dbutility = new DBUtility();
string sql = "select uniqueID,matchID,playerID,gameNum,Date from suspendedrecord where matchID=" + matchID;
sql = sql + " and playerID=" + playerID;
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(sql);
while (rd.Read())
{
//添加记录信息
list.Add(new SuspendedRecord(Convert.ToInt32(rd[0]),Convert.ToInt32(rd[1]),Convert.ToInt32(rd[2]),Convert.ToInt32(rd[3]),Convert.ToDateTime(rd[4])));
}
}
catch (MySqlException ex)
{
Console.Write(ex.ToString());
}
finally
{
dbutility.Close();
}
return list;
}
public static int getMaxSeasonNumOfMatch(string matchName)
{
int maxSeasonNum=0;
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select max(numofseason) from gameseason where matchname = '" + matchName + "' ";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
maxSeasonNum = Convert.ToInt32(Convert.ToString(rd[0]));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString()+"在这里出错！");
}
finally
{
dbutility.Close();
}
return maxSeasonNum;
}
/*
* 查询不属于某一个赛事的球员信息，但是这些球员信息必须是满足其所在球队已经在赛事球队表里面,
* 最终返回到一个线性表中
*/
public static List<FootballPlayer> getNotAssignedPlayerInfo(int matchID)
{
DBUtility dbutility = new DBUtility();
List<FootballPlayer> _list = new List<FootballPlayer>();
try
{
dbutility.openConnection();
string sql = "SELECT ID,playerName,number,postion,teamName,playerIDnum FROM player WHERE ID NOT IN";
sql=sql+"(SELECT playerID FROM matchplayerinfo WHERE matchID = "+matchID+")";
sql=sql+" AND teamName IN ( SELECT team.teamName FROM team,matchteaminfo WHERE";
sql=sql+" matchteaminfo.matchID = "+matchID+" AND team.ID = matchteaminfo.teamID)";
MySqlDataReader rd = dbutility.ExecuteQuery(sql);
while (rd.Read())
{
_list.Add(new FootballPlayer(Convert.ToInt32(rd[0]), Convert.ToString(rd[1]), Convert.ToInt32(rd[2]), Convert.ToString(rd[3]), Convert.ToString(rd[4]), Convert.ToString(rd[5])));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return _list;
}
//获取当前库中id值最大的一项，返回其id
public static int getMaxId()
{
int maxId = 0;
DBUtility dbutility = new DBUtility();
string sql = "select max(id) from gameseason;";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(sql);
while (rd.Read())
{
if (Convert.ToString(rd[0]) != "")
{
maxId = Convert.ToInt32(rd[0]);
}
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return maxId;
}
//取出不属于某一个赛事的所有球队信息，并且返回到一个线性表中
public static List<Team> getNotAssignedMatchTeamInfo(int matchID)
{
DBUtility dbutility = new DBUtility();
List<Team> _teamList = new List<Team>();
string sql = "SELECT ID,teamName,teamLeader,teamManager,teamCoach FROM team WHERE ID ";
sql = sql + "NOT IN (SELECT teamID FROM matchteaminfo WHERE matchID = " + matchID + ")";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(sql);
while (rd.Read())
{
_teamList.Add(new Team(Convert.ToInt32(rd[0]), Convert.ToString(rd[1]), Convert.ToString(rd[2]), Convert.ToString(rd[3]), Convert.ToString(rd[4])));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return _teamList;
}
//获取球队信息
public static Team getTeamInfo(string teamName)
{
Team team = new Team();
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select ID,teamName,teamLeader,teamManager,teamCoach from player where teamName='" + teamName+"'";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
team.setID(Convert.ToInt32(rd[0]));
team.setName(Convert.ToString(rd[1]));
team.setLeader(Convert.ToString(rd[2]));
team.setManager(Convert.ToString(rd[3]));
team.setCoach(Convert.ToString(rd[4]));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return team;
}
//查询球队信息
public static List<Team> getTeamInfo()
{
//声明实例
List<Team> list = new List<Team>();
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select ID,teamName,teamLeader,teamManager,teamCoach from team order by ID";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
list.Add(new Team(Convert.ToInt32(rd[0]), Convert.ToString(rd[1]), Convert.ToString(rd[2]), Convert.ToString(rd[3]), Convert.ToString(rd[4])));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return list;
}
//依据球员的姓名，返回球员信息
public static FootballPlayer getPlayerInfo(string playerName)
{
FootballPlayer player = new FootballPlayer();
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select ID,playerName,number,postion,teamName from player where playerName='" + playerName+"'";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
player.setPlayerID(Convert.ToInt32(rd[0]));
player.setPlayerName(Convert.ToString(rd[1]));
player.setPlayNumber(Convert.ToInt32(rd[2]));
player.setPostion(Convert.ToString(rd[3]));
player.setBelongTeam(Convert.ToString(rd[4]));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return player;
}
//查询某球队球员信息
public static List<FootballPlayer> getPlayerInfoOfCertainTeam(string teamName)
{
//声明实例
List<FootballPlayer> list = new List<FootballPlayer>();
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select ID,playerName,number,postion,teamName ,playerIDnum from player where teamName ='"+teamName+"' order by ID";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
list.Add(new FootballPlayer(Convert.ToInt32(rd[0]), Convert.ToString(rd[1]), Convert.ToInt32(rd[2]), Convert.ToString(rd[3]), Convert.ToString(rd[4]), Convert.ToString(rd[5])));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return list;
}
//依据赛事名称，返回赛事信息
public static SeasonMatch getMatchInfo(string matchName)
{
SeasonMatch match = new SeasonMatch();
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select ID,seasonName,description,switchNum,serialNum from matchinfo where seasonName='" + matchName + "'";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
match.setID(Convert.ToInt32(rd[0]));
match.setName(Convert.ToString(rd[1]));
match.setDescription(Convert.ToString(rd[2]));
match.setSwitchNum(Convert.ToInt32(rd[3]));
match.setSerialNum(Convert.ToInt32(rd[4]));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return match;
}
//获取某一赛事中黄牌转红牌的数量
public static int getMatchSwitchNum(int matchID)
{
int switchNum = 0;
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select switchNum from matchinfo where ID=" + matchID;
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
switchNum = Convert.ToInt32(rd[0]);
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return switchNum;
}
//查询特定赛事所属的球队
public static List<Team> getTeamInfoOfCertainMatch(SeasonMatch match)
{
//声明实例
List<Team> list = new List<Team>();
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
// string SQL = "select ID,teamName,teamLeader,teamManager,teamCoach from team order by ID";
string SQL = "select * from team where matchName= '"+match.getName()+"' order by ID";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
Team team = new Team(Convert.ToInt32(rd[0]), Convert.ToString(rd[1]), Convert.ToString(rd[2]),
Convert.ToString(rd[3]), Convert.ToString(rd[4]), Convert.ToString(rd[5]),
Convert.ToString(rd[6]), Convert.ToString(rd[7]), Convert.ToString(rd[8]),
Convert.ToString(rd[9]));
list.Add(team);
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return list;
}
//查询某一场比赛的信息
public static Game getGameInfo(int matchID,string gameName)
{
DBUtility dbutility = new DBUtility();
Game game = new Game();
string sql = "select uniqueID,matchID,matchGameNum,gameName,homeTeam,guestTeam,gameWinner,";
sql = sql + "gameResult,gameAddress,gameDate from gameInfo where gameName='" + gameName+"'";
sql = sql + " and matchID=" + matchID;
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(sql);
while (rd.Read())
{
game = new Game(Convert.ToInt32(rd[0]), Convert.ToInt32(rd[1]), Convert.ToInt32(rd[2]),
Convert.ToString(rd[3]), Convert.ToString(rd[4]), Convert.ToString(rd[5]), Convert.ToString(rd[6]),
Convert.ToString(rd[7]), Convert.ToString(rd[8]), Convert.ToDateTime(rd[9]));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return game;
}
//查询参加某个比赛的球员信息列表
public static List<FootballPlayer> getPlayerInfo(Game game)
{
//声明实例
List<FootballPlayer> list = new List<FootballPlayer>();
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL="";
try
{
dbutility.openConnection();
//取出比赛的参与球队，若两个球队相同时，只查询一次球队，然后返回到球员列表中
if (game.getHomeTeam() == game.getGuestTeam())
{
SQL = "select ID,playerName,number,postion,teamName,playerIDnum from player where teamName='" + game.getHomeTeam();
SQL = SQL + "' order by ID";
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
list.Add(new FootballPlayer(Convert.ToInt32(rd[0]), Convert.ToString(rd[1]), Convert.ToInt32(rd[2]), Convert.ToString(rd[3]), Convert.ToString(rd[4]), Convert.ToString(rd[5])));
}
}
else //当参加比赛的两个球队不相同时
{
SQL = "select ID,playerName,number,postion,teamName,playerIDnum from player where teamName='" + game.getHomeTeam();
SQL = SQL + "' order by ID";
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
list.Add(new FootballPlayer(Convert.ToInt32(rd[0]), Convert.ToString(rd[1]), Convert.ToInt32(rd[2]), Convert.ToString(rd[3]), Convert.ToString(rd[4]), Convert.ToString(rd[5])));
}
//查询客队球员信息
SQL = "select ID,playerName,number,postion,teamName,playerIDnum from player where teamName='" + game.getGuestTeam();
SQL = SQL + "' order by ID";
MySqlDataReader rds = dbutility.ExecuteQuery(SQL);
while (rds.Read())
{
list.Add(new FootballPlayer(Convert.ToInt32(rds[0]), Convert.ToString(rds[1]), Convert.ToInt32(rds[2]), Convert.ToString(rds[3]), Convert.ToString(rds[4]), Convert.ToString(rd[5])));
}
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return list;
}
//获取某一赛事中其最大的比赛序号的记录
public static int getMatchMaxGameNum(int matchID)
{
int _maxGameNum = 0; //记录最大的比赛序号
DBUtility dbutility = new DBUtility();
string sql = "select max(matchGameNum) from gameInfo where matchID=" + matchID;
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(sql);
while (rd.Read())
{
if (Convert.ToString(rd[0]) != "")
{
_maxGameNum = Convert.ToInt32(rd[0]);
}
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return _maxGameNum;
}
///
///记录一些基本的数据库查询事件
///
/*
* 查询数据库中的赛事的基本信息，并且返回到一个线性表中
*/
public static List<SeasonMatch> getMatchInfo()
{
//声明实例
List<SeasonMatch> list = new List<SeasonMatch>();
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select ID,seasonName,description,switchNum,serialNum from matchinfo order by ID";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
list.Add(new SeasonMatch(Convert.ToInt32(rd[0]),Convert.ToString(rd[1]),Convert.ToString(rd[2]),Convert.ToInt32(rd[3]),Convert.ToInt32(rd[4])));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return list;
}
//取出所有比赛信息
public static List<Game> getAllGameInfo()
{
DBUtility dbutility = new DBUtility();
List<Game> list = new List<Game>();
string sql = "select uniqueID,matchID,matchGameNum,gameName,homeTeam,guestTeam,gameWinner,";
sql = sql + "gameResult,gameAddress,gameDate from gameInfo ORDER BY uniqueID";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(sql);
while (rd.Read())
{
list.Add(new Game(Convert.ToInt32(rd[0]), Convert.ToInt32(rd[1]), Convert.ToInt32(rd[2]),
Convert.ToString(rd[3]), Convert.ToString(rd[4]), Convert.ToString(rd[5]), Convert.ToString(rd[6]),
Convert.ToString(rd[7]), Convert.ToString(rd[8]), Convert.ToDateTime(rd[9])));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return list;
}
//检查赛事表中是否为空,不为空返回true
public static bool checkMatchTableIsNull()
{
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select count(ID) from matchinfo ";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
if (Convert.ToInt32(rd[0]) != 0)
return true;
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return false;
}