当前文件路径：OnLineExam/Web/admin_PaperSetup.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;
12using MyOnLineExam.DataAccessLayer;
13
14public partial class Web_admin_PaperSetup : System.Web.UI.Page
15...{
16    
17    protected void Page_Load(object sender, EventArgs e)
18    ...{
19        if (!IsPostBack)
20        ...{            
21            InitData();  //初始化考试科目          
22        }
23    }
24    //初始化考试科目
25    protected void InitData()
26    ...{
27        Course course = new Course();       //创建考试科目对象
28        DataSet ds = course.QueryCourse();  //查询考试科目信息
29        ddlCourse.DataSource = ds;          //指名考试科目列表框数据源
30        ddlCourse.DataTextField = "Name";   //DataTextField显示Name字段值
31        ddlCourse.DataValueField = "ID";    //DataValueField显示ID字段值
32        ddlCourse.DataBind();               //绑定数据
33    }
34    //根据设置自动生成试卷
35    protected void imgBtnConfirm_Click(object sender, ImageClickEventArgs e)
36    ...{
37        Panel1.Visible = true;
38        DataBase db = new DataBase();//创建DataBase类对象
39        string GridView1Str = "select top " + int.Parse(txtSingleNum.Text.Trim()) + " * from SingleProblem order by newid()";//根据参数设置查询单选题Sql语句
40        DataSet ds1 = db.GetDataSetSql(GridView1Str);//调用DataBase类方法GetDataSetSql方法查询数据
41        GridView1.DataSource=ds1.Tables[0].DefaultView;//为单选题GridView控件指名数据源
42        GridView1.DataBind();//绑定数据
43        string GridView2Str = "select top " + int.Parse(txtMultiNum.Text.Trim()) + " * from MultiProblem order by newid()";//根据参数设置查询多选题Sql语句
44        DataSet ds2 = db.GetDataSetSql(GridView2Str);//调用DataBase类方法GetDataSetSql方法查询数据
45        GridView2.DataSource = ds2.Tables[0].DefaultView;//为多选题GridView控件指名数据源
46        GridView2.DataBind();//绑定数据
47        string GridView3Str = "select top " + int.Parse(txtJudgeNum.Text.Trim()) + " * from JudgeProblem order by newid()";//根据参数设置查询判断题Sql语句
48        DataSet ds3 = db.GetDataSetSql(GridView3Str);//调用DataBase类方法GetDataSetSql方法查询数据
49        GridView3.DataSource = ds3.Tables[0].DefaultView;//为判断题GridView控件指名数据源
50        GridView3.DataBind();//绑定数据
51        string GridView4Str = "select top " + int.Parse(txtFillNum.Text.Trim()) + " * from FillBlankProblem order by newid()";//根据参数设置查询填空题Sql语句
52        DataSet ds4 = db.GetDataSetSql(GridView4Str);//调用DataBase类方法GetDataSetSql方法查询数据
53        GridView4.DataSource = ds4.Tables[0].DefaultView;//为填空题GridView控件指名数据源
54        GridView4.DataBind();//绑定数据
55    }
56    //将生成试卷保存到数据库
57    protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
58    ...{
59        DataBase db = new DataBase();
60        string insertpaper = "insert into Paper(CourseID,PaperName,PaperState) values(" + int.Parse(ddlCourse.SelectedValue) + ",'" + txtPaperName.Text + "',1)";
61        int afterID = db.GetIDInsert(insertpaper);//保存试卷，并返回自动生成的试卷编号
62        if (afterID > 0)
63        ...{
64            foreach (GridViewRow dr in GridView1.Rows)//保存试卷单选题信息
65            ...{
66                string single = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'单选题'," + int.Parse(((Label)dr.FindControl("Label3")).Text) + ","+int.Parse(txtSingleFen.Text)+")";
67                db.Insert(single);
68            }
69            foreach (GridViewRow dr in GridView2.Rows)//保存试卷多选题信息
70            ...{
71                string multi = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'多选题'," + int.Parse(((Label)dr.FindControl("Label6")).Text) + "," + int.Parse(txtMultiFen.Text) + ")";
72                db.Insert(multi);
73            }
74            foreach (GridViewRow dr in GridView3.Rows)//保存试卷判断题信息
75            ...{
76                string judge = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'判断题'," + int.Parse(((Label)dr.FindControl("Label7")).Text) + "," + int.Parse(txtJudgeFen.Text) + ")";
77                db.Insert(judge);
78            }
79            foreach (GridViewRow dr in GridView4.Rows)//保存试卷填空题信息
80            ...{
81                string fill = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'填空题'," + int.Parse(((Label)dr.FindControl("Label8")).Text) + "," + int.Parse(txtFillFen.Text) + ")";
82                db.Insert(fill);
83            }
84        }                    
85    }
86}
87