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));
}
