//显示选择科目的填空题 protected void ddlCourse_SelectedIndexChanged(object sender, EventArgs e) { FillBlankProblem fillblankproblem = new FillBlankProblem(); //创建填空题对象 DataSet ds = fillblankproblem.QueryFillBlankProblem(Int32.Parse(ddlCourse.SelectedValue));//根据考试科目查询填空题信息 GridView1.DataSource = ds.Tables[0].DefaultView; //为GridView控件指名数据源 GridView1.DataBind(); //绑定数据 }
//添加或修改事件 protected void imgBtnSave_Click(object sender, ImageClickEventArgs e) { if (Page.IsValid) { FillBlankProblem fillblankproblem = new FillBlankProblem(); //创建填空题对象 fillblankproblem.CourseID = int.Parse(ddlCourse.SelectedValue);//为填空题对象各属性赋值 fillblankproblem.FrontTitle=txtFrontTitle.Text; fillblankproblem.BackTitle = txtBackTitle.Text; fillblankproblem.Answer = txtAnswer.Text; if (Request["ID"] != null) //如果是修改题目信息 { fillblankproblem.ID = int.Parse(Request["ID"].ToString()); //取出试题主键 if (fillblankproblem.UpdateByProc(int.Parse(Request["ID"].ToString()), int.Parse(ddlCourse.SelectedValue)))//调用修改试题方法修改试题 { lblMessage.Text = "成功修改该填空题!"; } else { lblMessage.Text = "修改该填空题失败!"; } } else //如果是添加试题 { if (fillblankproblem.InsertByProc(int.Parse(ddlCourse.SelectedValue))) //调用添加试题方法添加试题 { lblMessage.Text = "成功添加该填空题!"; } else { lblMessage.Text = "添加该填空题失败!"; } } } }
//删除多条记录 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { FillBlankProblem fill = new FillBlankProblem();//创建FillBlankProblem对象 foreach (GridViewRow dr in GridView1.Rows)//对GridView中的每一行进行判断 { if (((CheckBox)dr.FindControl("xuanze")).Checked)//如果选择了进行删除 { int ID = int.Parse(((Label)dr.FindControl("Label1")).Text); fill.ID = ID; fill.DeleteByProc(ID); } } Response.AddHeader("Refresh", "0"); }
//删除试题事件 protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { FillBlankProblem fillblankproblem = new FillBlankProblem(); //创建填空题对象 int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //取出要删除记录的主键值 if (fillblankproblem.DeleteByProc(ID)) { Response.Write("<script language=javascript>alert('成功删除试题!')</script>"); } else { Response.Write("<script language=javascript>alert('该题已被收录入试卷,请勿删除!')</script>"); } GridViewBind();//为GridView重新绑定数据 GridView1.EditIndex = -1; }
protected void GridViewBind() { FillBlankProblem fillblankproblem = new FillBlankProblem(); //创建填空题对象 DataSet ds = fillblankproblem.QueryFillBlankProblem(Int32.Parse(ddlCourse.SelectedValue));//根据考试科目查询填空题信息 GridView1.DataSource = ds.Tables[0].DefaultView; //为GridView控件指名数据源 GridView1.DataBind(); //绑定数据 //胡媛媛修改,为gridview1中的复选框添加事件,2010-5-5 if (GridView1.Rows.Count > 0) { foreach (GridViewRow dr in GridView1.Rows) { ((CheckBox)dr.FindControl("xuanze")).Attributes.Add("onclick", "SigchkChg()"); } } //胡媛媛修改,为gridview1中的复选框添加事件,2010-5-5 }
//初始化数据 protected void InitData() { int fillblankProblemID = int.Parse(Request["ID"].ToString()); //取出传递过来的试题编号 FillBlankProblem fillblankproblem = new FillBlankProblem(); //创建填空题对象 if (fillblankproblem.LoadData(fillblankProblemID)) //如果取出题目信息,分别放在相应控件显示 { ddlCourse.SelectedValue = fillblankproblem.CourseID.ToString(); txtFrontTitle.Text = fillblankproblem.FrontTitle; txtBackTitle.Text = fillblankproblem.BackTitle; txtAnswer.Text = fillblankproblem.Answer; } else //查询出错,给出提示 { lblMessage.Text = "加载数据出错!"; } }