?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;
using MyOnLineExam.DataAccessLayer;

public partial class Web_admin_PaperSetup : System.Web.UI.Page
{
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {            
            InitData();  //初始化考試科目          
        }
    }
    //初始化考試科目
    protected void InitData()
    {
        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 imgBtnConfirm_Click(object sender, ImageClickEventArgs e)
    {
        Panel1.Visible = true;
        DataBase db = new DataBase();//創建DataBase類對象
        string GridView1Str = "select top " + int.Parse(txtSingleNum.Text.Trim()) + " * from SingleProblem order by newid()";//根據參數設置查詢單選題Sql語句
        DataSet ds1 = db.GetDataSetSql(GridView1Str);//調用DataBase類方法GetDataSetSql方法查詢數據
        GridView1.DataSource=ds1.Tables[0].DefaultView;//為單選題GridView控件指名數據源
        GridView1.DataBind();//綁定數據
        string GridView2Str = "select top " + int.Parse(txtMultiNum.Text.Trim()) + " * from MultiProblem order by newid()";//根據參數設置查詢多選題Sql語句
        DataSet ds2 = db.GetDataSetSql(GridView2Str);//調用DataBase類方法GetDataSetSql方法查詢數據
        GridView2.DataSource = ds2.Tables[0].DefaultView;//為多選題GridView控件指名數據源
        GridView2.DataBind();//綁定數據
        string GridView3Str = "select top " + int.Parse(txtJudgeNum.Text.Trim()) + " * from JudgeProblem order by newid()";//根據參數設置查詢判斷題Sql語句
        DataSet ds3 = db.GetDataSetSql(GridView3Str);//調用DataBase類方法GetDataSetSql方法查詢數據
        GridView3.DataSource = ds3.Tables[0].DefaultView;//為判斷題GridView控件指名數據源
        GridView3.DataBind();//綁定數據
        string GridView4Str = "select top " + int.Parse(txtFillNum.Text.Trim()) + " * from FillBlankProblem order by newid()";//根據參數設置查詢填空題Sql語句
        DataSet ds4 = db.GetDataSetSql(GridView4Str);//調用DataBase類方法GetDataSetSql方法查詢數據
        GridView4.DataSource = ds4.Tables[0].DefaultView;//為填空題GridView控件指名數據源
        GridView4.DataBind();//綁定數據
    }
    //將生成試卷保存到數據庫
    protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
    {
        DataBase db = new DataBase();
        string insertpaper = "insert into Paper(CourseID,PaperName,PaperState) values(" + int.Parse(ddlCourse.SelectedValue) + ",'" + txtPaperName.Text + "',1)";
        int afterID = db.GetIDInsert(insertpaper);//保存試卷，并返回自動生成的試卷編號
        if (afterID > 0)
        {
            foreach (GridViewRow dr in GridView1.Rows)//保存試卷單選題信息
            {
                string single = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'單選題'," + int.Parse(((Label)dr.FindControl("Label3")).Text) + ","+int.Parse(txtSingleFen.Text)+")";
                db.Insert(single);
            }
            foreach (GridViewRow dr in GridView2.Rows)//保存試卷多選題信息
            {
                string multi = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'多選題'," + int.Parse(((Label)dr.FindControl("Label6")).Text) + "," + int.Parse(txtMultiFen.Text) + ")";
                db.Insert(multi);
            }
            foreach (GridViewRow dr in GridView3.Rows)//保存試卷判斷題信息
            {
                string judge = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'判斷題'," + int.Parse(((Label)dr.FindControl("Label7")).Text) + "," + int.Parse(txtJudgeFen.Text) + ")";
                db.Insert(judge);
            }
            foreach (GridViewRow dr in GridView4.Rows)//保存試卷填空題信息
            {
                string fill = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'填空題'," + int.Parse(((Label)dr.FindControl("Label8")).Text) + "," + int.Parse(txtFillFen.Text) + ")";
                db.Insert(fill);
            }
        }        			
    }
}