private void 学生主菜单_Load(object sender, EventArgs e) { this.Text = User.getuName() + "同学,欢迎您 - 福建工程学院教务管理系统"; //公告栏初始化 string strCmd = "SELECT TEXT from Notice WHERE datetime=(SELECT MAX(datetime) FROM Notice)"; skinTextBox1.Text = op.FiledValue(strCmd); skinTextBox1.ReadOnly = true; //成绩查询初始化 //查询当前登录学生所学的科目的成绩 DataTable dt = op.GetDataTable("SELECT c.cname, g.cno,t.tname,g.grade FROM grade g,course c,teacher t where g.cno=c.cno AND g.tno=t.tno AND sno='" + User.getuNo() + "'", "grade"); skinDataGridView1.DataSource = dt; //课表查询初始化 DataTable dt2 = op.GetDataTable("SELECT c.cname,t.tname,te.lesson_time,te.exam_time FROM Teacher_teaching te, teacher t, student s, grade g, course c where s.sno = g.sno AND g.cno = c.cno AND g.cno = te.cno AND te.tno = t.tno AND s.sno='" + User.getuNo() + "'", "stuCourse"); skinDataGridView2.DataSource = dt2; //选课模块初始化 List <string> selectCnoAndCname = op.getCnoAndCnameStu(); comboBox1.Items.Clear(); for (int i = 0; i < selectCnoAndCname.Count; i++) { comboBox1.Items.Add(selectCnoAndCname[i]); } hidePanel(); panel_message.Show(); }
private void skinButton1_Click(object sender, EventArgs e) { if (comboBox1.SelectedItem.ToString() == "") { MessageBox.Show("请选择课程!"); return; } else { string sno = User.getuNo(); string cno = (comboBox1.Text.ToString().Split('-'))[0]; //获取该课程的授课老师编号 string sql = "select tno from Teacher_teaching where cno ='" + cno + "'"; string tno = op.FiledValue(sql); if (tno != "") { sql = "insert into grade(sno,cno,tno)values ('" + sno + "','" + cno + "','" + tno + "');"; if (op.OPSQL(sql)) { MessageBox.Show("选课成功"); } } else { MessageBox.Show("该课程还未安排老师"); } } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { string id = (comboBox1.Text.ToString()).Split('-')[0]; label3.Text = "单价:" + op.FiledValue(od.getCmdPrice(id)); }