//更新成绩
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;//教学秘书可以查询成绩
}
}
