protected void coursescoresub_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(studentscorecj.Text.Trim()))
{
ScriptManager.RegisterStartupScript(this.coursescore_panel, this.GetType(), "updateScript", "alert('成绩不能为空！')", true);
return;
}
int cj = 0;
int bkcj = 0;
try
{
cj = Convert.ToInt32(studentscorecj.Text.Trim());
if (!string.IsNullOrEmpty(studentscorebkcj.Text.Trim()))
{
bkcj = Convert.ToInt32(studentscorebkcj.Text.Trim());
}
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(this.coursescore_panel, this.GetType(), "updateScript", "alert('请在成绩或补考成绩中输入数字！')", true);
return;
}
string sql = null;
if (cj >= 60)
{
sql = "update tb_study set cj='" + cj + "',pass='******' ,bkcj = null where xh ='" + Convert.ToInt32(studentscorexh.Text.Trim()) + "' and kcdh ='" + Session["courseevaluatekcdh"] + "'";
}
else if (bkcj >= 60)
{
sql = "update tb_study set cj='" + cj + "',pass='******',bkcj='" + bkcj + "' where xh ='" + Convert.ToInt32(studentscorexh.Text.Trim()) + "' and kcdh ='" + Session["courseevaluatekcdh"] + "'";
}
else
{
sql = "update tb_study set cj='" + cj + "',pass='******', bkcj='" + bkcj + "' where xh ='" + Convert.ToInt32(studentscorexh.Text.Trim()) + "' and kcdh ='" + Session["courseevaluatekcdh"] + "'";
}
try
{
DBControl.update(sql);
ScriptManager.RegisterStartupScript(this.coursescore_panel, this.GetType(), "updateScript", "alert('打分成功')", true);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.coursescore_panel, this.GetType(), "updateScript", "alert('打分失败')", true);
}
CourseEvaluateListView.DataSource = null;
CourseEvaluateListView.DataBind();
coursechooseresult_panel.Visible = true;
coursescore_panel.Visible = false;
}
protected void coursechoose_Click(object sender, EventArgs e)
{
Session["courseevaluatekcdh"] = Convert.ToInt32(coursechoosecontent.SelectedValue);
string sql = "select * from vi_course where kcdh ='" + Session["courseevaluatekcdh"] + "'";
SqlConnection conn = DBCon.getConnection();
SqlCommand com = new SqlCommand(sql, conn);
SqlDataReader course = null;
try
{
conn.Open();
course = com.ExecuteReader();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
Session["courseevaluateinfo"] = null;
if (course.Read())
{
string bxk = null;
if (course["bxk"].ToString() == "True")
{
bxk = "是";
}
else
{
bxk = "否";
}
Session["courseevaluateinfo"] += "课程信息：<br /><br /> 课程代号：" + course["kcdh"] + " 课程名：" + course["kcm"] + " 课时数：" + course["kss"] + " 必修课：" + bxk + " 学分：" + course["xf"] + " 授课教师：" + course["xm"] + "<br /><br />";
}
else
{
ScriptManager.RegisterStartupScript(this.courseevaluate_panel, this.GetType(), "updateScript", "alert('没有这个课程！')", true);
return;
}
DBCon.CloseAll(conn, com);
Session["courseevaluateinfo"] += "<br /><br />选修学生：<br />";
CourseEvaluateListView.DataSource = null;
CourseEvaluateListView.DataBind();
coursechooseresult_panel.Visible = true;
coursescore_panel.Visible = false;
}