protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string id = GridViewScore.DataKeys[e.RowIndex].Value.ToString();
bool success = dao.DeleteBody(id, 5);
if (success)
{
Response.Write("<script>alert('删除成功！')</script>");
//刷新该页面
SqlConnection sqlConnection = SqlTools.Connection();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("select score.id,Score.SubmitTime,Score.Score,Course.Name,student.Name as'studentname' from score left join student on Score.Student=student.ID join Course on Score.Course=Course.ID", sqlConnection);
DataSet dataSet = new DataSet();
GridViewScore.DataKeyNames = new string[] { "id" };
sqlDataAdapter.Fill(dataSet);
GridViewScore.DataSource = dataSet;
GridViewScore.DataBind();
sqlConnection.Close();
}
else
{
Response.Write("<script>alert('删除失败！')</script>");
}
}
protected void DropDownListTerm_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownListTerm.SelectedIndex == DropDownListTerm.Items.Count - 1)
{
GridViewScore.DataSource = null;
GridViewScore.DataBind();
txtAvgSubjectScore.Text = string.Empty;
return;
}
System.Data.DataTable studentScore = new System.Data.DataTable();
eRegisterData.DAL oDAL = new eRegisterData.DAL();
if (DropDownListSubject.SelectedValue.Equals("-1"))
{
studentScore = oDAL.GetStudentScores(studentID, byte.Parse(DropDownListTerm.SelectedValue), 0);
txtAvgSubjectScore.Text = string.Empty;
}
else
{
studentScore = oDAL.GetStudentScores(studentID, byte.Parse(DropDownListTerm.SelectedValue), short.Parse(DropDownListSubject.SelectedValue));
if (!DropDownListTerm.SelectedValue.Equals("-1"))
{
txtAvgSubjectScore.Text = oDAL.GetStudentsAvgScore(studentID, byte.Parse(DropDownListTerm.SelectedValue), short.Parse(DropDownListSubject.SelectedValue));
}
else
{
txtAvgSubjectScore.Text = string.Empty;
}
}
GridViewScore.DataSource = studentScore.DefaultView;
GridViewScore.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection sqlConnection = SqlTools.Connection();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("select score.id,Score.SubmitTime,Score.Score,Course.Name,student.Name as'studentname' from score left join student on Score.Student=student.ID join Course on Score.Course=Course.ID", sqlConnection);
DataSet dataSet = new DataSet();
GridViewScore.DataKeyNames = new string[] { "id" };
sqlDataAdapter.Fill(dataSet);
GridViewScore.DataSource = dataSet;
GridViewScore.DataBind();
sqlConnection.Close();
}
