//查询按钮
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);
}
}
}
public void StuManage_Load(object sender, EventArgs e)
{
label1.BackColor = Color.Transparent;
label2.BackColor = Color.Transparent;
pictureBox1.BackColor = Color.Transparent;
string sql = "select userName as 考生姓名,userSex as 考生性别,userAcc as 准考证号 ,isTest as 是否考试 from UserInfo where userIde=0";
DataClass.DataGridViewBing(dataGridView1, sql);
dataGridView1.AllowUserToAddRows = false;//禁止显示最后一行
}
private void QueSc_Load(object sender, EventArgs e)
{
string sql = "select userName as 考生姓名,userID as 准考证号 ,selRes as 选择题,judRes as 判断题,allRes as 总分 from ExamResult ";
DataClass.DataGridViewBing(dataGridView1, sql);
//设置控件的底色透明
groupBox1.BackColor = Color.Transparent;
label1.BackColor = Color.Transparent;
label2.BackColor = Color.Transparent;
label3.BackColor = Color.Transparent;
}
public static StuManage stum; //声明静态公有变量
public void Admin_Load(object sender, EventArgs e)
{
stum = new StuManage(); //创建”学生管理“窗体的实例
menuStrip1.BackColor = Color.Transparent;
statusStrip1.BackColor = Color.Transparent; //设置底色透明
dataGridView1.AllowUserToAddRows = false;
dataGridView2.AllowUserToAddRows = false; //禁止显示最后一行
toolStripStatusLabel1.Text = "姓名：" + ComVal.userName + " 身份：管理员";
string sql =
"select ID as 系统编号,question as 选择题题目,A as 选项A ,B as 选项B ,C as 选项C ,D as 选项D ,rightKey as 正确选项 from TestInfo where testType=0";
DataClass.DataGridViewBing(dataGridView1, sql);//显示选择题
string sql1 = "select ID as 系统编号,question as 判断题题目,rightKey as 真假判断 from TestInfo where testType=1";
DataClass.DataGridViewBing(dataGridView2, sql1);//显示判断题
//设置dataGridView的显示大小
dataGridView1.Columns[1].Width = dataGridView1.Columns[2].Width = dataGridView1.Columns[3].Width = dataGridView1.Columns[4].Width = dataGridView1.Columns[5].Width = 170;
dataGridView2.Columns[0].Width = 80; //设置第一列宽度
dataGridView2.Columns[1].Width = 910; //设置第二例宽度
dataGridView2.Columns[2].Width = 80; //设置第二例宽度
}
