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 apply_detail(ConnectionPool CP, apply app, teacher teacherDemo) { InitializeComponent(); pictureBox7.Hide(); label10.Hide(); this.CP = CP;; this.teacherDemo = teacherDemo; this.applyDemo = app; sql_student ss = new sql_student(CP); label4.Text = ss.getNumByID(applyDemo.getStu_ID()); label5.Text = ss.getNameByID(applyDemo.getStu_ID()); richTextBox1.Text = applyDemo.getApply_reason(); label6.Text = applyDemo.getApply_start().ToString() + "——" + applyDemo.getApply_end().ToString(); }
public int insert(apply applyDemo) { MySqlConnection conn = CP.getConnection(); string sql; sql = "insert into tb_apply(stu_ID,tutor_ID,instructor_ID,apply_time,apply_start,apply_end," + "apply_reason,check_tutor,check_instructor,apply_editTime) values" + $"({applyDemo.getStu_ID()},{applyDemo.getTutor_ID()},{applyDemo.getInstructor_ID()}," + $"'{applyDemo.getApply_time()}','{applyDemo.getApply_start()}','{applyDemo.getApply_end()}'," + $"'{applyDemo.getApply_reason()}',{applyDemo.getCheck_tutor()},{applyDemo.getCheck_instructor()}," + $"'{applyDemo.getApply_editTime()}')"; MySqlCommand cmd = new MySqlCommand(sql, conn); int j = cmd.ExecuteNonQuery(); CP.closeConnection(CP.getConnection()); return(j); }
public int check_refuse(apply applyDemo, teacher teacherDemo, string refuse) { MySqlConnection conn = CP.getConnection(); DateTime DT = DateTime.Now; string sql; if (teacherDemo.getTeacher_pos() == 1) { sql = $"update tb_apply set check_tutor=2,apply_editTime='{DT}',apply_refuse='{refuse}' where apply_ID={applyDemo.getApply_ID()}"; } else { sql = $"update tb_apply set check_instructor=2,apply_editTime='{DT}',apply_refuse='{refuse}' where apply_ID={applyDemo.getApply_ID()}"; } MySqlCommand cmd = new MySqlCommand(sql, conn); int j = cmd.ExecuteNonQuery(); CP.closeConnection(conn); return(j); }
private void button1_Click(object sender, EventArgs e) { if (richTextBox1.Text == "") { pictureBox2.Show(); label6.Show(); flag = false; return; } else { pictureBox2.Hide(); label6.Hide(); flag = true; } if (flag == true)//验证通过 { apply applyDemo = new apply(); applyDemo.setStu_ID(studentDemo.getStu_ID()); applyDemo.setApply_start(dateTimePicker1.Value); applyDemo.setApply_end(dateTimePicker2.Value); applyDemo.setApply_reason(richTextBox1.Text); applyDemo.setCheck_tutor(0); applyDemo.setInstructor_ID(0); applyDemo.setApply_refuse(""); applyDemo.setApply_editTime(DateTime.Now); applyDemo.setApply_time(DateTime.Now); applyDemo.setTutor_ID(tutor_ID); applyDemo.setInstructor_ID(instructor_ID); applyDemo.setApply_editTime(DateTime.Now); sql_apply sa = new sql_apply(CP); sa.insert(applyDemo); MessageBox.Show("添加成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.Hide(); } }
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(); } }