//更新成绩 private void button6_Click(object sender, EventArgs e) { ScoreInfo.id = textBox6.Text; ScoreInfo.course_id = textBox7.Text; ScoreInfo.score = numericUpDown1.Value.ToString(); string Str3 = "select count(*) from score_info where Id = '" + ScoreInfo.id + "'and Course_Id = '" + ScoreInfo.course_id + "'"; string str5 = "update score_info set score = '" + ScoreInfo.score + "'where Course_Id = '" + ScoreInfo.course_id + "'and Id = '" + ScoreInfo.id + "'"; DBlink db = new DBlink(); //创建数据库连接对象 DBlink db4 = new DBlink(); //创建数据库连接对象 if (db4.DBconn()) { //连接数据库 string Str1 = "select Course_name from course_information where Course_Id = " + ScoreInfo.course_id; string Str2 = "select name from user_information where Id = " + ScoreInfo.id; ScoreInfo.course_name = db4.Getstringsearch(Str1); ScoreInfo.name = db4.Getstringsearch(Str2); //MessageBox.Show(ScoreInfo.course_id + ScoreInfo.course_name); int count = db4.GetIntsearch(Str3); if (count == 0) { string str4 = "insert into score_info(name,Id,Course_name,Course_Id,score) " + "values('" + ScoreInfo.name + "','" + ScoreInfo.id + "','" + ScoreInfo.course_name + "','" + ScoreInfo.course_id + "','" + ScoreInfo.score + "');"; bool bool6 = db4.UpdataDeletAdd(str4);// 执行查询 if (bool6) { MessageBox.Show("更新记录成功!"); } else { MessageBox.Show("更新记录失败!"); } } else { bool bool7 = db4.UpdataDeletAdd(str5);// 执行查询 if (bool7) { MessageBox.Show("更新记录成功!"); } else { MessageBox.Show("更新记录失败!"); } } } db4.DBclose();//关闭数据连接 string sql = "SELECT score_info.Id as 学号, score_info.name as 姓名,score_info.course_name as 课程,score_info.score as 成绩 FROM score_info"; BindsocreData(sql); }
//--------------------------------------------------------------用户功能--------------------------------------------- //一、成绩管理 private void 成绩管理ToolStripMenuItem_Click(object sender, EventArgs e) { panel3.Visible = false; panel4.Visible = true; //隐藏成绩与课程信息 DBlink db = new DBlink(); //创建数据库连接对象 if (db.DBconn()) { //创建数据库连接 string Str1 = "select Id from login_info WHERE username = '******'"; Globel.Id = db.Getstringsearch(Str1); } db.DBclose(); //关闭数据库连接 string sql = "SELECT score_info.Id as 学号, score_info.name as 姓名,score_info.course_name as 课程,score_info.score as 成绩 FROM score_info"; if (LoginInfo.id_tag.Equals("s")) { BindsocreData("select score_info.Id as 学号, score_info.name as 姓名,score_info.course_name as 课程,score_info.score as 成绩 from score_info where Id = '" + Globel.Id + "'"); } else if (LoginInfo.id_tag.Equals("t")) { BindsocreData(sql); panel5.Visible = true; //教师可以管理成绩 panel6.Visible = true; //教师可以查询成绩 } else if (LoginInfo.id_tag.Equals("ts")) { BindsocreData(sql); panel6.Visible = true;//教学秘书可以查询成绩 } }