?using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MyOnLineExam.BusinessLogicLayer;

public partial class Web_admin_SingleSelectLists : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ImageButton1.Attributes.Add("OnClick", "javascript:return confirm('確實要刪除這些試題嗎？')");
            InitDDLData();  //初始化考試科目          
        }
    }

    //初始化考試科目
    protected void InitDDLData()
    {        
        Course course = new Course();       //創建考試科目對象
        DataSet ds = course.QueryCourse();  //查詢考試科目信息
        ddlCourse.DataSource = ds;          //指名考試科目列表框數據源
        ddlCourse.DataTextField = "Name";   //DataTextField顯示Name字段值
        ddlCourse.DataValueField = "ID";    //DataValueField顯示ID字段值
        ddlCourse.DataBind();               //綁定數據
    }
    //顯示選擇科目的單選題
    protected void ddlCourse_SelectedIndexChanged(object sender, EventArgs e)
    {
        GridViewBind();//為GridView綁定數據
    }
    //GridView控件綁定數據事件
    protected void GridViewBind()
    {
        SingleProblem singleproblem = new SingleProblem();  //創建單選題對象
        DataSet ds = singleproblem.QuerySingleProblem(int.Parse(ddlCourse.SelectedValue));//根據考試科目查詢單選題信息
        GridView1.DataSource = ds.Tables[0].DefaultView;    //為GridView控件指名數據源
        GridView1.DataBind();                               //綁定數據
    }
    //刪除試題事件
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        SingleProblem singleproblem = new SingleProblem();  //創建單選題對象
        int ID=int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //取出要刪除記錄的主鍵值
        if (singleproblem.DeleteByProc(ID))
        {
            Response.Write("<script language=javascript>alert('成功刪除試題！')</script>");
        }
        else
        {
            Response.Write("<script language=javascript>alert('刪除試題失敗！')</script>");
        }
        GridView1.EditIndex = -1;
        GridViewBind();//重新綁定數據
    }
    //刪除多條記錄
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        SingleProblem single = new SingleProblem();//創建SingleProblem對象        
        foreach (GridViewRow dr in GridView1.Rows)//對GridView中的每一行進行判斷
        {
            if (((CheckBox)dr.FindControl("xuanze")).Checked)//如果選擇了進行刪除
            {
                int ID = int.Parse(((Label)dr.FindControl("Label1")).Text);
                single.ID = ID;
                single.DeleteByProc(ID);                
            }
        }
    }
}