testpaper.aspx.cs

本系统实现了网上考试的目的

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 System.Data.SqlClient;
using System.Data.SqlTypes;

public partial class TestPaper : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["UserID"] == null)
        {
            Response.Redirect("Default.aspx");
        }
        else
        {
            string courseId = Convert.ToString(Session["ClassifyID"]);
            string stuId = Convert.ToString(Session["UserID"]);
            string stuName = Convert.ToString(Session["UserName"]);
            string courseName = Convert.ToString(Session["ClassifyName"]);
            lbl_stuId.Text = stuId;
            lbl_stuName.Text = stuName;
            lbl_courseName.Text = courseName;

            int ifCreate = (new UserDB()).ifCourseHasTest(stuId, courseId);//判断指定的用户指定的科目是否已经考试过
            if (ifCreate != 1)
            {
                SqlDataReader readerXZ = (new UserDB()).createXZ(courseId);
                int count = (new UserDB()).insertStuStatusToScore(stuId, courseId, 0, 0, 0, 0, 0);
                if (count == 0)
                {
                    Response.Write("<script>alert(\"更新状态错误！\");</script>");
                }
                Hashtable ht_XZRightAnswer = new Hashtable();
                Hashtable ht_XZStuTest = new Hashtable();
                int XZnum = 1;
                while (readerXZ.Read())
                {
                    Literal lit_XZContent = new Literal();
                    RadioButtonList rbtnList_XZ = new RadioButtonList();
                    rbtnList_XZ.ID = "rbtnList_XZ" + XZnum.ToString();
                    lit_XZContent.Text = "<br>" + XZnum.ToString() + "、" + Server.HtmlEncode(readerXZ["XZName"].ToString()) + "<br>";
                    rbtnList_XZ.Items.Add("A. " + Server.HtmlEncode(readerXZ["A"].ToString()));
                    rbtnList_XZ.Items.Add("B. " + Server.HtmlEncode(readerXZ["B"].ToString()));
                    rbtnList_XZ.Items.Add("C. " + Server.HtmlEncode(readerXZ["C"].ToString()));
                    rbtnList_XZ.Items.Add("D. " + Server.HtmlEncode(readerXZ["D"].ToString()));
                    string XZID = readerXZ["XZID"].ToString();
                    ht_XZStuTest.Add(XZnum.ToString(), XZID.ToString());
                    int XZRightAns = (new UserDB()).getXZRightAnsAsXZId(XZID);
                    ht_XZRightAnswer.Add(XZnum.ToString(), XZRightAns);
                    for (int j = 1; j <= 4; j++)
                    {
                        rbtnList_XZ.Items[j - 1].Value = j.ToString();
                    }
                    if (XZnum <= 35)
                    {
                        Panel1.Controls.Add(lit_XZContent);
                        Panel1.Controls.Add(rbtnList_XZ);
                    }
                    else
                    {
                        Panel2.Controls.Add(lit_XZContent);
                        Panel2.Controls.Add(rbtnList_XZ);
                    }
                    string xz = "xz";
                    int count1213 = (new UserDB()).insertTestPaper(stuId, courseId, XZID, xz, XZnum, 0);
                    XZnum++;
                }
                Session["XZRightAnswer"] = ht_XZRightAnswer;
                Session["XZStuTest"] = ht_XZStuTest;
                SqlDataReader readerWX = (new UserDB()).createWXTK(courseId);
                while (readerWX.Read())
                {
                    string WXID2 = readerWX["WXID"].ToString();
                    string WXTKID = readerWX["WXTKID"].ToString();
                    Session["WXID"] = WXID2;
                    Literal lit_WXContent = new Literal();
                    lit_WXContent.Text = "<br>" + Server.HtmlEncode(readerWX["WXName"].ToString()) + "<br>";
                    Hashtable ht_WXContent = new Hashtable();
                    ht_WXContent.Add(1, WXTKID.ToString());
                    Panel3.Controls.Add(lit_WXContent);
                    Session["WXContent"] = ht_WXContent;
                    string wx = "wxtk";
                    int count1213 = (new UserDB()).insertTestPaper(stuId, courseId, WXTKID, wx, 1, 0);

                }
                string WXID1 = Convert.ToString(Session["WXID"]);
                SqlDataReader readerWXDetail = (new UserDB()).getWXTKDetailAsWXId(WXID1);
                Hashtable ht_WXRightAnswer = new Hashtable();
                Hashtable ht_WXStuTest = new Hashtable();
                int WXnum = 1;
                while (readerWXDetail.Read())
                {

                    Literal lit_WXDeltail = new Literal();
                    RadioButtonList rbtnList_WX = new RadioButtonList();
                    rbtnList_WX.ID = "rbtnList_WX" + WXnum.ToString();
                    rbtnList_WX.RepeatColumns = 4;
                    lit_WXDeltail.Text = "<br>" + WXnum.ToString() + "、" + "<br>";
                    rbtnList_WX.Items.Add("A. " + Server.HtmlEncode(readerWXDetail["A"].ToString()));
                    rbtnList_WX.Items.Add("B. " + Server.HtmlEncode(readerWXDetail["B"].ToString()));
                    rbtnList_WX.Items.Add("C. " + Server.HtmlEncode(readerWXDetail["C"].ToString()));
                    rbtnList_WX.Items.Add("D. " + Server.HtmlEncode(readerWXDetail["D"].ToString()));
                    string WXID = readerWXDetail["WXNumber"].ToString();
                    ht_WXStuTest.Add(WXnum.ToString(), WXID.ToString());
                    int WXRightAns = (new UserDB()).getWXRightAnsAsWXId(WXID);
                    ht_WXRightAnswer.Add(WXnum.ToString(), WXRightAns);
                    for (int j = 1; j <= 4; j++)
                    {
                        rbtnList_WX.Items[j - 1].Value = j.ToString();
                    }
                    Panel3.Controls.Add(lit_WXDeltail);
                    Panel3.Controls.Add(rbtnList_WX);
                    string wxdetail = "wxdetail";
                    string id = "11111111-1111-1111-1111-111111111111";
                    int count121333 = (new UserDB()).insertTestPaper(stuId, courseId, id, wxdetail, WXnum, 0);
                    WXnum++;
                }
                Session["WXRightAnswer"] = ht_WXRightAnswer;
                Session["WXStuTest"] = ht_WXStuTest;
                SqlDataReader readerYD = (new UserDB()).createYD(courseId);
                while (readerYD.Read())
                {
                    string YD2 = readerYD["YDID"].ToString();
                    string YDID = readerYD["YUEDUID"].ToString();
                    Session["YDID"] = YD2;
                    Literal lit_YDContent = new Literal();
                    lit_YDContent.Text = "<br>" + Server.HtmlEncode(readerYD["YDName"].ToString()) + "<br>";
                    Hashtable ht_YDContent = new Hashtable();
                    ht_YDContent.Add(1, YDID.ToString());
                    Panel4.Controls.Add(lit_YDContent);
                    Session["YDContent"] = ht_YDContent;
                    string yd = "yuedu";
                    int count1213 = (new UserDB()).insertTestPaper(stuId, courseId, YDID, yd, 1, 0);
                }

                string YDID1 = Convert.ToString(Session["YDID"]);
                SqlDataReader readerYDDetail = (new UserDB()).getYDDetailAsYDId(YDID1);
                Hashtable ht_YDRightAnswer = new Hashtable();
                Hashtable ht_YDStuTest = new Hashtable();
                int YDDetailnum = 1;
                while (readerYDDetail.Read())
                {

                    Literal lit_YDDeltail = new Literal();
                    RadioButtonList rbtnList_YD = new RadioButtonList();
                    rbtnList_YD.ID = "rbtnList_YD" + YDDetailnum.ToString();

                    lit_YDDeltail.Text = "<br>" + YDDetailnum.ToString() + "、" + Server.HtmlEncode(readerYDDetail["YDName"].ToString()) + "<br>";
                    rbtnList_YD.Items.Add("A. " + Server.HtmlEncode(readerYDDetail["A"].ToString()));
                    rbtnList_YD.Items.Add("B. " + Server.HtmlEncode(readerYDDetail["B"].ToString()));
                    rbtnList_YD.Items.Add("C. " + Server.HtmlEncode(readerYDDetail["C"].ToString()));
                    rbtnList_YD.Items.Add("D. " + Server.HtmlEncode(readerYDDetail["D"].ToString()));
                    string ID = readerYDDetail["YDNumber"].ToString();
                    ht_YDStuTest.Add(YDDetailnum.ToString(), ID.ToString());
                    int YDRightAns = (new UserDB()).getYDRightAnsAsId(ID);
                    ht_YDRightAnswer.Add(YDDetailnum.ToString(), YDRightAns);
                    for (int j = 1; j <= 4; j++)
                    {
                        rbtnList_YD.Items[j - 1].Value = j.ToString();
                    }
                    Panel4.Controls.Add(lit_YDDeltail);
                    Panel4.Controls.Add(rbtnList_YD);
                    string yddetail = "yddetail";
                    string id = "11111111-1111-1111-1111-111111111111";
                    int count121333 = (new UserDB()).insertTestPaper(stuId, courseId, id, yddetail, YDDetailnum, 0);
                    YDDetailnum++;
                }
                Session["YDRightAnswer"] = ht_YDRightAnswer;
                Session["YDStuTest"] = ht_YDStuTest;

            }

            else
            {
                Hashtable ht_XZStuTest = (Hashtable)Session["XZStuTest"];
                string XZID = "";

                DataSet XZds;
                bool find;
                for (int XZnum = 1; XZnum <= 70; XZnum++)
                {
                    find = false;
                    IDictionaryEnumerator XZEnumerator = ht_XZStuTest.GetEnumerator();
                    while (XZEnumerator.MoveNext() && !find)

                        if (XZEnumerator.Key.Equals(XZnum.ToString()))
                        {
                            XZID = XZEnumerator.Value.ToString();
                            find = true;
                            XZds = (new UserDB()).getXZInfoAsXZId(XZID);
                            DataTable dt = XZds.Tables["testInfo"];
                            DataRow dataRow = dt.Rows[0];
                            Literal lit_XZContent = new Literal();
                            RadioButtonList rbtnList_XZ = new RadioButtonList();
                            rbtnList_XZ.ID = "rbtnList_XZ" + XZnum.ToString();
                            lit_XZContent.Text = "<br>" + XZnum.ToString() + "、" + Server.HtmlEncode(dataRow["XZName"].ToString()) + "<br>";
                            rbtnList_XZ.Items.Add("A. " + Server.HtmlEncode(dataRow["A"].ToString()));
                            rbtnList_XZ.Items.Add("B. " + Server.HtmlEncode(dataRow["B"].ToString()));
                            rbtnList_XZ.Items.Add("C. " + Server.HtmlEncode(dataRow["C"].ToString()));
                            rbtnList_XZ.Items.Add("D. " + Server.HtmlEncode(dataRow["D"].ToString()));
                            int XZRightAns = (new UserDB()).getXZRightAnsAsXZId(XZID);
                            for (int j = 1; j <= 4; j++)
                            {
                                rbtnList_XZ.Items[j - 1].Value = j.ToString();
                            }
                            if (XZnum <= 35)
                            {
                                Panel1.Controls.Add(lit_XZContent);
                                Panel1.Controls.Add(rbtnList_XZ);
                            }
                            else
                            {
                                Panel2.Controls.Add(lit_XZContent);
                                Panel2.Controls.Add(rbtnList_XZ);
                            }
                        }
                }
                Hashtable ht_WXContent = (Hashtable)Session["WXContent"];
                Hashtable ht_WXStuTest = (Hashtable)Session["WXStuTest"];
                string WXTKID = "";
                string WXNumber = "";
                DataSet WXds;
                DataSet WXDetailds;
                find = false;
                IDictionaryEnumerator WXEnumerator1 = ht_WXContent.GetEnumerator();