当前文件路径：OnLineExam/Web/admin_FillBlankLists.aspx.cs

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using MyOnLineExam.BusinessLogicLayer;
12
13public partial class Web_admin_FillBlankLists : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17        if (!IsPostBack)
18        ...{
19            ImageButton1.Attributes.Add("OnClick", "javascript:return confirm('确实要删除这些试题吗？')");
20            InitDDLData();  //初始化考试科目          
21        }
22    }
23    //初始化考试科目
24    protected void InitDDLData()
25    ...{
26        Course course = new Course();       //创建考试科目对象
27        DataSet ds = course.QueryCourse();  //查询考试科目信息
28        ddlCourse.DataSource = ds;          //指名考试科目列表框数据源
29        ddlCourse.DataTextField = "Name";   //DataTextField显示Name字段值
30        ddlCourse.DataValueField = "ID";    //DataValueField显示ID字段值
31        ddlCourse.DataBind();               //绑定数据
32    }
33    //显示选择科目的填空题
34    protected void ddlCourse_SelectedIndexChanged(object sender, EventArgs e)
35    ...{
36        FillBlankProblem fillblankproblem = new FillBlankProblem();  //创建填空题对象
37        DataSet ds = fillblankproblem.QueryFillBlankProblem(int.Parse(ddlCourse.SelectedValue));//根据考试科目查询填空题信息
38        GridView1.DataSource = ds.Tables[0].DefaultView;    //为GridView控件指名数据源
39        GridView1.DataBind();                               //绑定数据
40    }
41    //删除试题事件
42    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
43    ...{
44        FillBlankProblem fillblankproblem = new FillBlankProblem();  //创建填空题对象
45        int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //取出要删除记录的主键值
46        if (fillblankproblem.DeleteByProc(ID))
47        ...{
48            Response.Write("<script language=javascript>alert('成功删除试题！')</script>");
49        }
50        else
51        ...{
52            Response.Write("<script language=javascript>alert('删除试题失败！')</script>");
53        }
54        GridViewBind();//为GridView重新绑定数据
55        GridView1.EditIndex = -1;
56    }
57    //显示选择科目的填空题
58    protected void ddlCourse_SelectedIndexChanged1(object sender, EventArgs e)
59    ...{
60        GridViewBind();//为GridView绑定数据
61    }
62    protected void GridViewBind()
63    ...{
64        FillBlankProblem fillblankproblem = new FillBlankProblem();  //创建填空题对象
65        DataSet ds = fillblankproblem.QueryFillBlankProblem(int.Parse(ddlCourse.SelectedValue));//根据考试科目查询填空题信息
66        GridView1.DataSource = ds.Tables[0].DefaultView;    //为GridView控件指名数据源
67        GridView1.DataBind();                               //绑定数据
68    }
69    //删除多条记录
70    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
71    ...{
72        FillBlankProblem fill = new FillBlankProblem();//创建FillBlankProblem对象
73        foreach (GridViewRow dr in GridView1.Rows)//对GridView中的每一行进行判断
74        ...{
75            if (((CheckBox)dr.FindControl("xuanze")).Checked)//如果选择了进行删除
76            ...{
77                int ID = int.Parse(((Label)dr.FindControl("Label1")).Text);
78                fill.ID = ID;
79                fill.DeleteByProc(ID);
80            }
81        }
82    }
83}
84