public teacher_check(ConnectionPool CP, teacher teacherDemo)
{
InitializeComponent();
pictureBox7.Hide();
label3.Hide();
this.CP = CP;
this.teacherDemo = teacherDemo;
string sql = $"select * from tb_apply where tutor_ID={teacherDemo.getTeacher_ID()} " +
$"or instructor_ID={teacherDemo.getTeacher_ID()}";
selecter selecterDemo = new selecter(CP, sql);
apply applyDemo;
MySqlDataReader reader = selecterDemo.execute();
while (reader.Read())
{
applyDemo = new apply();
applyDemo.setApply_ID(reader.GetInt32("apply_ID"));
applyDemo.setStu_ID(reader.GetInt32("stu_ID"));
applyDemo.setTutor_ID(reader.GetInt32("tutor_ID"));
applyDemo.setInstructor_ID(reader.GetInt32("instructor_ID"));
applyDemo.setApply_time(reader.GetDateTime("apply_time"));
applyDemo.setApply_start(reader.GetDateTime("apply_start"));
applyDemo.setApply_end(reader.GetDateTime("apply_end"));
applyDemo.setApply_reason(reader.GetString("apply_reason"));
applyDemo.setCheck_tutor(reader.GetInt32("check_tutor"));
applyDemo.setCheck_instructor(reader.GetInt32("check_instructor"));
if (teacherDemo.getTeacher_pos() == 1)
{
if (applyDemo.getCheck_tutor() == 0 && applyDemo.getTutor_ID() == teacherDemo.getTeacher_ID())
{
applyList.Add(applyDemo);
}
}
else
{
if (applyDemo.getCheck_instructor() == 0 && applyDemo.getCheck_tutor() == 1 && applyDemo.getInstructor_ID() == teacherDemo.getTeacher_ID())
{
applyList.Add(applyDemo);
}
}
}
selecterDemo.end();
sql_student ss = new sql_student(CP);
DataGridViewRow dr = new DataGridViewRow();
foreach (apply ap in applyList)
{
int index = dataGridView1.Rows.Add();
dataGridView1.Rows[index].Cells[0].Value = ss.getNumByID(ap.getStu_ID());
dataGridView1.Rows[index].Cells[1].Value = ss.getNameByID(ap.getStu_ID());
dataGridView1.Rows[index].Cells[2].Value = ap.getApply_start();
dataGridView1.Rows[index].Cells[3].Value = ap.getApply_end();
dataGridView1.Rows[index].Cells[4].Value = ap.getApply_reason();
dataGridView1.Rows[index].Cells[5].Value = ap.getApply_time();
}
}
public infor_stu(ConnectionPool CP, student studentDemo)
{
InitializeComponent();
this.CP = CP;
this.studentDemo = studentDemo;
List <apply> applyList = new List <apply>();
string sql = $"select * from tb_apply where stu_ID={studentDemo.getStu_ID()}";
selecter selecterDemo = new selecter(CP, sql);
apply applyDemo;
MySqlDataReader reader = selecterDemo.execute();
while (reader.Read())
{
applyDemo = new apply();
applyDemo.setApply_ID(reader.GetInt32("apply_ID"));
applyDemo.setStu_ID(reader.GetInt32("stu_ID"));
applyDemo.setTutor_ID(reader.GetInt32("tutor_ID"));
applyDemo.setInstructor_ID(reader.GetInt32("instructor_ID"));
applyDemo.setApply_time(reader.GetDateTime("apply_time"));
applyDemo.setApply_start(reader.GetDateTime("apply_start"));
applyDemo.setApply_end(reader.GetDateTime("apply_end"));
applyDemo.setApply_reason(reader.GetString("apply_reason"));
applyDemo.setCheck_tutor(reader.GetInt32("check_tutor"));
applyDemo.setCheck_instructor(reader.GetInt32("check_instructor"));
if (applyDemo.getCheck_tutor() == 2 || applyDemo.getCheck_instructor() == 2)
{
applyDemo.setApply_refuse(reader.GetString("apply_refuse"));
}
if (applyDemo.getCheck_tutor() == 1 && applyDemo.getCheck_instructor() == 1)
{
applyDemo.setApply_refuse("申请通过");
}
applyList.Add(applyDemo);
}
selecterDemo.end();
sql_student ss = new sql_student(CP);
foreach (apply ap in applyList)
{
int index = dataGridView1.Rows.Add();
dataGridView1.Rows[index].Cells[0].Value = ap.getApply_time();
dataGridView1.Rows[index].Cells[1].Value = ap.getApply_reason();
dataGridView1.Rows[index].Cells[2].Value = ap.getApply_start();
dataGridView1.Rows[index].Cells[3].Value = ap.getApply_end();
dataGridView1.Rows[index].Cells[4].Value = ss.getState_tutor(ap.getCheck_tutor());
dataGridView1.Rows[index].Cells[5].Value = ss.getState_instructor(ap.getCheck_tutor(), ap.getCheck_instructor());
dataGridView1.Rows[index].Cells[6].Value = ap.getApply_refuse();
}
}
public main_teacher(ConnectionPool CP, string user, string username)
{
InitializeComponent();
this.CP = CP;
label3.Text = username;
MySqlDataReader reader;
string sql = $"select * from tb_teacher where teacher_num={user}";
selecter selecterDemo = new selecter(CP, sql);
reader = selecterDemo.execute();
reader.Read();
teacherDemo.setTeacher_ID(reader.GetInt32("teacher_ID"));
teacherDemo.setTeacher_num(user);
teacherDemo.setTeacher_name(username);
teacherDemo.setTeacher_pos(reader.GetInt32("teacher_pos"));
teacherDemo.setTeacher_tel(reader.GetString("teacher_tel"));
selecterDemo.end();
}
private void button4_Click(object sender, EventArgs e)
{
string sql;
sql = "select count(*),clazz_name from tb_apply,tb_student,tb_clazz " +
"where tb_apply.stu_ID=tb_student.stu_ID and tb_student.clazz_ID=tb_clazz.clazz_ID " +
"GROUP BY clazz_name ORDER BY count(*)";
selecter selecterDemo = new selecter(CP, sql);
MySqlDataReader reader = selecterDemo.execute();
dataGridView1.Rows.Clear();
while (reader.Read())
{
int index = dataGridView1.Rows.Add();
dataGridView1.Rows[index].Cells[0].Value = reader.GetString("clazz_name");
dataGridView1.Rows[index].Cells[1].Value = reader.GetInt32("count(*)");
}
selecterDemo.end();
}
public apply_add(ConnectionPool CP, student studentDemo)
{
InitializeComponent();
this.CP = CP;
this.studentDemo = studentDemo;
pictureBox7.Hide();
label10.Hide();
pictureBox2.Hide();
label6.Hide();
sql_student ss = new sql_student(CP);
ss.getID(studentDemo);
string sql = $"select * from tb_student,tb_clazz where tb_student.clazz_ID=tb_clazz.clazz_ID and tb_student.stu_ID={studentDemo.getStu_ID()}";
selecter selecterDemo = new selecter(CP, sql);
MySqlDataReader reader = selecterDemo.execute();
reader.Read();
tutor_ID = reader.GetInt32("tutor_ID");
instructor_ID = reader.GetInt32("instructor_ID");
reader.Dispose();
selecterDemo.end();
}
public main_student(ConnectionPool CP, string user, string username)
{
InitializeComponent();
this.CP = CP;
label3.Text = username;
stu_num = user;
stu_name = username;
MySqlDataReader reader;
string sql = $"select * from tb_student where stu_num={stu_num}";
selecter selecterDemo = new selecter(CP, sql);
reader = selecterDemo.execute();
reader.Read();
studentDemo.setClazz_ID(reader.GetInt32("clazz_ID"));
studentDemo.setStu_ID(reader.GetInt32("stu_ID"));
studentDemo.setStu_num(reader.GetString("stu_num"));
studentDemo.setStu_name(reader.GetString("stu_name"));
studentDemo.setStu_sex(reader.GetInt32("stu_sex"));
studentDemo.setStu_tel(reader.GetString("stu_tel"));
studentDemo.setStu_password(reader.GetString("stu_password"));
selecterDemo.end();
}
public info_clazz(ConnectionPool CP)
{
InitializeComponent();
pictureBox7.Hide();
label3.Hide();
this.CP = CP;
string sql;
sql = "select count(*),clazz_name from tb_apply,tb_student,tb_clazz " +
"where tb_apply.stu_ID=tb_student.stu_ID and tb_student.clazz_ID=tb_clazz.clazz_ID " +
"GROUP BY clazz_name ORDER BY count(*)";
selecter selecterDemo = new selecter(CP, sql);
MySqlDataReader reader = selecterDemo.execute();
while (reader.Read())
{
int index = dataGridView1.Rows.Add();
dataGridView1.Rows[index].Cells[0].Value = reader.GetString("clazz_name");
dataGridView1.Rows[index].Cells[1].Value = reader.GetInt32("count(*)");
}
reader.Dispose();
selecterDemo.end();
string sql2;
sql2 = "select * from tb_apply";
selecterDemo = new selecter(CP, sql2);
reader = selecterDemo.execute();
apply applyDemo;
while (reader.Read())
{
applyDemo = new apply();
applyDemo.setApply_ID(reader.GetInt32("apply_ID"));
applyDemo.setStu_ID(reader.GetInt32("stu_ID"));
applyDemo.setTutor_ID(reader.GetInt32("tutor_ID"));
applyDemo.setInstructor_ID(reader.GetInt32("instructor_ID"));
applyDemo.setApply_time(reader.GetDateTime("apply_time"));
applyDemo.setApply_start(reader.GetDateTime("apply_start"));
applyDemo.setApply_end(reader.GetDateTime("apply_end"));
applyDemo.setApply_reason(reader.GetString("apply_reason"));
applyDemo.setCheck_tutor(reader.GetInt32("check_tutor"));
applyDemo.setCheck_instructor(reader.GetInt32("check_instructor"));
if (applyDemo.getCheck_tutor() == 0 || applyDemo.getCheck_instructor() == 0)
{
applyDemo.setApply_refuse("审核中");
}
if (applyDemo.getCheck_tutor() == 2 || applyDemo.getCheck_instructor() == 2)
{
applyDemo.setApply_refuse(reader.GetString("apply_refuse"));
}
if (applyDemo.getCheck_tutor() == 1 && applyDemo.getCheck_instructor() == 1)
{
applyDemo.setApply_refuse("申请通过");
}
applyList.Add(applyDemo);
}
selecterDemo.end();
sql_student ss = new sql_student(CP);
foreach (apply ap in applyList)
{
int index = dataGridView2.Rows.Add();
dataGridView2.Rows[index].Cells[0].Value = ss.getNumByID(ap.getStu_ID());
dataGridView2.Rows[index].Cells[1].Value = ss.getNameByID(ap.getStu_ID());
dataGridView2.Rows[index].Cells[2].Value = ap.getApply_time();
dataGridView2.Rows[index].Cells[3].Value = ap.getApply_reason();
dataGridView2.Rows[index].Cells[4].Value = ap.getApply_refuse();
}
}
private void pictureBox2_Click(object sender, EventArgs e)
{
Boolean flag;
flag = true;
student newstu = new student();
if (textBox3.Text != textBox4.Text)//判密码
{
pictureBox3.Show();
label11.Show();
flag = false;
return;
}
else
{
pictureBox3.Hide();
label11.Hide();
}
if (textBox3.Text == "")
{
flag = false;
pictureBox5.Show();
label13.Show();
return;
}
else
{
pictureBox5.Hide();
label13.Hide();
}
if (textBox5.Text.Length != 11 || textBox5.Text.Substring(0, 1) != "1")//验手机号
{
flag = false;
pictureBox4.Show();
label12.Show();
return;
}
else
{
pictureBox4.Hide();
label12.Hide();
}
string sql = $"select * from tb_student where stu_num = '{textBox1.Text}'";;
selecter selecterDemo = new selecter(CP, sql);
try
{
if (selecterDemo.getNum() != 0)
{
pictureBox7.Show();
label10.Show();
flag = false;
return;
}
else
{
pictureBox7.Hide();
label10.Hide();//到此成功注册
newstu.setClazz_ID(comboBox1.SelectedIndex + 1);
newstu.setStu_name(textBox2.Text);
newstu.setStu_num(textBox1.Text);
newstu.setStu_sex(comboBox2.SelectedIndex);
newstu.setStu_password(pw.lockstring(textBox3.Text));
newstu.setStu_tel(textBox5.Text);
newstu.setStu_addTime(DateTime.Now);
newstu.setStu_editTime(DateTime.Now);
}
}
finally
{
selecterDemo.end();
}
sql_student ss = new sql_student(CP);
int j = ss.insert(newstu);
this.Hide();
MessageBox.Show("注册成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
private void button1_Click(object sender, EventArgs e)
{
Boolean flag = true;
MySqlDataReader reader;
user = textBox1.Text;
string password;
if (!radioButton1.Checked && !radioButton2.Checked)
{
label4.Show();
pictureBox9.Show();
flag = false;
return;
}
else
{
label4.Hide();
pictureBox9.Hide();
}
if (radioButton2.Checked)//学生
{
string sql = $"select * from tb_student where stu_num = '{user}'";
selecter selecterDemo = new selecter(CP, sql);
try
{
if (0 == selecterDemo.getNum())
{
label3.Show();
pictureBox7.Show();
flag = false;
return;
}
else
{
label3.Hide();
pictureBox7.Hide();
}
reader = selecterDemo.execute();
reader.Read();
password = reader.GetString("stu_password");
username = reader.GetString("stu_name");
reader.Dispose();
if (pw.unlockstring(password) != textBox2.Text)
{
label2.Show();
pictureBox8.Show();
flag = false;
return;
}
else
{
label2.Hide();
pictureBox8.Hide();//到此学生成功登陆
}
}
finally
{
selecterDemo.end();
}
this.Hide();
main_student ms = new main_student(CP, user, username);
ms.ShowDialog(this);
this.Show();
}
if (radioButton1.Checked)//教师
{
string sql = $"select * from tb_teacher where teacher_num = '{user}'";
selecter selecterDemo = new selecter(CP, sql);
try
{
if (0 == selecterDemo.getNum())
{
label3.Show();
pictureBox7.Show();
flag = false;
return;
}
else
{
label3.Hide();
pictureBox7.Hide();
}
reader = selecterDemo.execute();
reader.Read();
password = reader.GetString("teacher_password");
username = reader.GetString("teacher_name");
reader.Dispose();
if (pw.unlockstring(password) != textBox2.Text)
{
label2.Show();
pictureBox8.Show();
flag = false;
return;
}
else
{
label2.Hide();
pictureBox8.Hide();//到此教师成功登陆
}
}
finally
{
selecterDemo.end();
}
this.Hide();
main_teacher mt = new main_teacher(CP, user, username);
mt.ShowDialog(this);
this.Show();
}
}