//实现右键修改选中选择题的功能 private void 修改ToolStripMenuItem_Click(object sender, EventArgs e) { int MMid = Convert.ToInt32(dataGridView1.SelectedCells[0].Value); //获取选择试题的ID值 string sql = "select * from TestInfo where ID=" + MMid + ""; OleDbConnection con = DataClass.DBCon(); con.Open(); OleDbCommand com = new OleDbCommand(sql, con); OleDbDataReader re = com.ExecuteReader(); re.Read(); //传递选择题数据 ComVal.TeID = MMid; ComVal.seTi = re[2].ToString(); ComVal.seR = re[3].ToString(); ComVal.seA = re[4].ToString(); ComVal.seB = re[5].ToString(); ComVal.seC = re[6].ToString(); ComVal.seD = re[7].ToString(); re.Close(); con.Close(); //选择题窗体出现 AltSel se = new AltSel(); se.Show(); this.Hide(); //隐藏本窗体 }
//修改 private void 修改ToolStripMenuItem_Click(object sender, EventArgs e) { ComVal.StuNA = dataGridView1.SelectedCells[0].Value.ToString(); //获取考生姓名 string sql = "select * from UserInfo where userName='******'"; OleDbConnection con = DataClass.DBCon(); con.Open(); OleDbCommand com = new OleDbCommand(sql, con); OleDbDataReader re = com.ExecuteReader(); if (re.Read()) { //传递选中考生数据 ComVal.StuSex = re[7].ToString(); ComVal.StuID = re[3].ToString(); ComVal.Iste = Convert.ToInt32(re[5].ToString()); ComVal.StuPw = re[4].ToString(); ComVal.PicPath = re[6].ToString(); re.Close(); con.Close(); //修改窗体出现 SthInf st = new SthInf(); st.Show(); this.Hide();//隐藏本窗体 } }
//查询按钮 private void button1_Click(object sender, EventArgs e) { if (comboBox1.Text == "" || textBox1.Text == "") { MessageBox.Show("请输入完整数据!"); } else { string sql; if (comboBox1.Text == "姓名") { sql = "select userName as 考生姓名,userID as 准考证号 ,selRes as 选择题,judRes as 判断题,allRes as 总分 from ExamResult where userName like'%" + textBox1.Text + "%'"; } else { sql = "select userName as 考生姓名,userID as 准考证号 ,selRes as 选择题,judRes as 判断题,allRes as 总分 from ExamResult where userID='" + textBox1.Text + "'"; } OleDbConnection con = DataClass.DBCon(); con.Open(); OleDbCommand com = new OleDbCommand(sql, con); OleDbDataReader re = com.ExecuteReader(); //re.Read(); if (re.Read() == false) { MessageBox.Show("没有查询结果"); con.Close(); } else { DataClass.DataGridViewBing(dataGridView1, sql); } } }
//提交函数 private void Handin() { //提交选择题 string stuAns = ""; for (int aa = 0; aa < StudentAns.Length; aa++) //获取考生答案 { stuAns += StudentAns[aa].ToString(); } for (int i = 0; i < xzflag; i++) { //将考生答案与正确答案做比较 if (RightAns.Substring(i, 1).Equals(stuAns.Substring(i, 1))) { StuScore += xzFz; //如果答案正确加分 } } //提交判断题 string pdstuAns = ""; for (int aa = 0; aa < StudentAns1.Length; aa++) //获取考生答案 { pdstuAns += StudentAns1[aa].ToString(); } for (int i = 0; i < pdflag; i++) { //将考生答案与正确答案做比较 if (RightAns1.Substring(i, 1).Equals(pdstuAns.Substring(i, 1))) { StuScore1 += pdFz; //如果答案正确加分 } } int allscore = StuScore + StuScore1; //计算总分 //将考试分数上传数据库 _conn.Open(); _cmd = new OleDbCommand("update ExamResult set selRes='" + StuScore + "',judRes='" + StuScore1 + "', allRes='" + allscore + "' where userID='" + _studentNum + "'", _conn); if (_cmd.ExecuteNonQuery() > 0) { _conn.Close(); } else { _cmd = new OleDbCommand("insert into ExamResult(userID,selRes,judRes,allRes,userName) values('" + _studentNum + "','" + StuScore + "','" + StuScore1 + "','" + allscore + "','" + label2.Text + "')", _conn); _cmd.ExecuteNonQuery(); _conn.Close(); } string sql = "update UserInfo set IsTest=1 where userAcc='" + _studentNum + "'"; OleDbConnection conn = DataClass.DBCon(); conn.Open(); OleDbCommand cmd = new OleDbCommand(sql, conn); cmd.ExecuteNonQuery(); conn.Close(); }
private void timer1_Tick(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) {//如果没有选中考生,禁用右键 contextMenuStrip1.Enabled = false; } else { contextMenuStrip1.Enabled = true; StuNA = dataGridView1.SelectedCells[0].Value.ToString(); //获取考生姓名 string sql = "select * from UserInfo where userName='******'"; OleDbConnection con = DataClass.DBCon(); con.Open(); OleDbCommand com = new OleDbCommand(sql, con); OleDbDataReader re = com.ExecuteReader(); if (re.Read()) { //传递选中考生数据 label1.Text = re[2].ToString(); if (re[6].ToString() != "") { pictureBox1.ImageLocation = re[6].ToString(); } else { switch (label1.Text) { case "段隆婵": pictureBox1.Image = global::StudentTest.Properties.Resources.IMG_20170621_231841; break; case "武嘉敏": pictureBox1.Image = global::StudentTest.Properties.Resources.IMG_20170621_231946; break; case "邵美琪": pictureBox1.Image = global::StudentTest.Properties.Resources.img_c47071d89f960255ae10e2015ccdfc52; break; case "潘昱荣": pictureBox1.Image = global::StudentTest.Properties.Resources.img_3215a9af47ca2c38584ba19b2ca72599; break; default: pictureBox1.Image = null; break; } } re.Close(); con.Close(); } } }
//实现右键删除考生信息的功能 private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { string MMid = dataGridView1.SelectedCells[0].Value.ToString(); //获取考生姓名 OleDbConnection con = DataClass.DBCon(); con.Open(); OleDbCommand com = new OleDbCommand("delete * from ExamResult where userName='******'", con); com.ExecuteNonQuery(); //如果该考生有成绩记录,则一起删除 con.Close(); string sql = "delete * from UserInfo where userName='******' "; //声明SQL语句用于删除 DataClass.OperaData(sql); //调用DeleteData方法 StuManage_Load(sender, e); //刷新当前窗体 }
//读取原本的数据 private void ExSet_Load(object sender, EventArgs e) { label9.BackColor = Color.Transparent; OleDbConnection con = DataClass.DBCon(); con.Open(); string sql = "select * from ExamSet where ID=1"; OleDbCommand com = new OleDbCommand(sql, con); OleDbDataReader re = com.ExecuteReader(); re.Read(); coXR.Text = re[1].ToString(); coX.Text = re[2].ToString(); coPR.Text = re[3].ToString(); coP.Text = re[4].ToString(); texT.Text = re[5].ToString(); con.Close(); }
public static Exam ex = new Exam(); //声明静态全局变量 考试窗口实例 private void LogButt_Click(object sender, EventArgs e) { //判断是否选择登陆身份 if (useIdeTextBox.Text == "") { MessageBox.Show("请选择登陆身份!"); } else { //判断是否输入用户名和密码 if (accTextBox.Text == "" || pwdTxtBox.Text == "") { MessageBox.Show("请输入用户名和密码!"); } else { //如果是考生 if (useIdeTextBox.Text == "考生") { //判断用户名密码是否符合 OleDbConnection con = DataClass.DBCon(); con.Open(); OleDbCommand com = new OleDbCommand( "select * from UserInfo where userAcc='" + accTextBox.Text + "' and userPwd='" + pwdTxtBox.Text + "' and userIde=0", con); OleDbDataReader red = com.ExecuteReader(); red.Read(); if (red.HasRows) { ComVal.userPwd = pwdTxtBox.Text; ComVal.userAcc = accTextBox.Text; Exam._Useracc = ComVal.userAcc; //传递用户名 ex.Show(); //显示考试窗口 this.Hide(); } else { MessageBox.Show("用户名或密码错误!"); } con.Close(); } else { //如果不是学生,则判断管理员的身份是否符合 OleDbConnection con = DataClass.DBCon(); con.Open(); OleDbCommand com = new OleDbCommand( "select * from UserInfo where userIde=1 and userAcc='" + accTextBox.Text + "' and userPwd='" + pwdTxtBox.Text + "'", con); OleDbDataReader red = com.ExecuteReader(); red.Read(); if (red.HasRows) { //上传用户名密码 ComVal.userPwd = pwdTxtBox.Text; ComVal.userAcc = accTextBox.Text; ComVal.userName = red[2].ToString(); ad.Show();//显示管理员窗口 this.Hide(); } else { MessageBox.Show("用户名或密码错误!"); } con.Close(); } } } }