//查询某一赛事的所有罚牌记录信息
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 static void addNewPlayerCardNum(PlayerCardRecord _playerCardNum)
{
DBUtility dbutility = new DBUtility();
string SQL = "insert into playerGetCardRecord(matchID,playerID,serialNum,yellowCardNum,redCardNum,";
SQL = SQL + "getDate) values(" + _playerCardNum.getMatchID() + "," + _playerCardNum.getPlayerID() + ",";
SQL = SQL + _playerCardNum.getSerialNum() + "," + _playerCardNum.getYellowCardNum() + ",";
SQL = SQL + _playerCardNum.getRedCardNum() + ",'" + _playerCardNum.getDateTime() + "')";
try
{
dbutility.openConnection();
dbutility.ExecuteUpdate(SQL);
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
}
private void addPlayerRecord()
{
//记录各个变量
int matchID; //比赛ID
int playerID; //球员ID
int matchSerial; //赛事轮次
int yellowCardNum; //黄牌数量
int redCardNum; //红牌数量
DateTime dateTime; //记录添加罚牌记录的日期
if (textBox_matchName.Text == "" || textBox_playerName.Text == "") //赛事名称和用户名称不能为空
{
MessageBox.Show("赛事名称或球员姓名不能为空","不能为空",MessageBoxButtons.OKCancel,MessageBoxIcon.Information);
}
else
{
matchID = _match.getID(); //记录赛事的编号
//查询并获取球员信息
_player = ContentDAO.getPlayerInfo(textBox_playerName.Text);
playerID = _player.getID();
if (textBox_matchSerial.Text != "") //当比赛场次不是空时
{
//检查是否是数字
if (!checkSwitchResult.checkStringSwitchInteger(textBox_matchSerial.Text))
{
MessageBox.Show("赛事轮次必须是数字", "非数字", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
return;
}
else //可以转换时
{
matchSerial = Convert.ToInt32(textBox_matchSerial.Text);
}
}
else //比赛轮次是空时，记录其值为0
{
matchSerial = 0;
}
if (textBox_yellowCardNum.Text != "") //当黄牌数量不是空时
{
//检查是否是数字
if (!checkSwitchResult.checkStringSwitchInteger(textBox_yellowCardNum.Text))
{
MessageBox.Show("黄牌数量必须是数字", "非数字", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
return;
}
else //可以转换时
{
yellowCardNum = Convert.ToInt32(textBox_yellowCardNum.Text);
}
}
else
{
yellowCardNum = 0;
}
if (textBox_redCardNum.Text != "") //红牌数量不是空时
{
//检查是否是数字
if (!checkSwitchResult.checkStringSwitchInteger(textBox_redCardNum.Text))
{
MessageBox.Show("红牌数量必须是数字", "非数字", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
return;
}
else //可以转换时
{
redCardNum = Convert.ToInt32(textBox_redCardNum.Text);
if (yellowCardNum != 0 && yellowCardNum % SystemParam.getSwitchNum() == 0)
{
yellowCardNum = 0;
}
}
}
else
{
redCardNum = 0;
if (yellowCardNum != 0 && yellowCardNum % SystemParam.getSwitchNum() == 0) //若添加的黄牌数量可以转换成红牌时，直接将黄牌数变为0
{
yellowCardNum = 0;
redCardNum = 1;
}
}
//记录日期
if (dateTimePicker_addCardRecord.Text != "") //日期文本不是空时
{
dateTime = dateTimePicker_addCardRecord.Value;
}
else //日期文本是空时，直接设定当前日期为默认日期
{
dateTime = DateTime.Today;
}
PlayerCardRecord _playerCardRecord = new PlayerCardRecord(matchID,playerID,matchSerial,yellowCardNum,redCardNum,dateTime);
//往数据库中添加记录
ContentDAO.addNewPlayerCardNum(_playerCardRecord);
if (MessageBox.Show("添加罚牌信息成功，是否继续添加？", "添加罚牌成功", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
textBox_matchSerial.Text = "";
textBox_playerName.Text = "";
textBox_yellowCardNum.Text = "";
textBox_redCardNum.Text = "";
}
else
{
this.Close();
}
}
}