testpaper2.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 TestPaper2 : 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["courseID"]);
            string stuId = Convert.ToString(Session["stuID"]);
            string stuName = Convert.ToString(Session["stuName"]);
            string courseName = Convert.ToString(Session["courseName"]);
            int XZnum = 1;
            SqlDataReader readerXZ = (new UserDB()).selectXZastestpaper(stuId, courseId);
            Hashtable ht_XZRightAnswer = new Hashtable();
            Hashtable ht_XZStuTest = new Hashtable();
            while (readerXZ.Read())
            {
                string testId = readerXZ["testID"].ToString();


                SqlDataReader readerXZ1 = (new UserDB()).getXZInfoAsXZId1(testId);

                while (readerXZ1.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(readerXZ1["XZName"].ToString()) + "<br>";
                    rbtnList_XZ.Items.Add("A. " + Server.HtmlEncode(readerXZ1["A"].ToString()));
                    rbtnList_XZ.Items.Add("B. " + Server.HtmlEncode(readerXZ1["B"].ToString()));
                    rbtnList_XZ.Items.Add("C. " + Server.HtmlEncode(readerXZ1["C"].ToString()));
                    rbtnList_XZ.Items.Add("D. " + Server.HtmlEncode(readerXZ1["D"].ToString()));
                    // string XZID = readerXZ["XZID"].ToString();
                    ht_XZStuTest.Add(XZnum.ToString(), testId.ToString());
                    int XZRightAns = (new UserDB()).getXZRightAnsAsXZId(testId);
                    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 stuanswer = (new UserDB()).getstuanswer(stuId, courseId, xz, XZnum);
                RadioButtonList XZlist;
                if (XZnum <= 35)
                {
                    XZlist = (RadioButtonList)Panel1.FindControl("rbtnList_XZ" + XZnum.ToString());
                }
                else
                {
                    XZlist = (RadioButtonList)Panel2.FindControl("rbtnList_XZ" + XZnum.ToString());
                }
                switch (stuanswer)
                {
                    case 1:
                        XZlist.Items[0].Selected = true;
                        break;
                    case 2:
                        XZlist.Items[1].Selected = true;
                        break;
                    case 3:
                        XZlist.Items[2].Selected = true;
                        break;
                    case 4:
                        XZlist.Items[3].Selected = true;
                        break;
                    default:
                        break;
                }
                XZnum++;
            }
            Session["XZRightAnswer"] = ht_XZRightAnswer;
            Session["XZStuTest"] = ht_XZStuTest;
            SqlDataReader readerWX3 = (new UserDB()).selectWXastestpaper(stuId, courseId);
            Hashtable ht_WXRightAnswer = new Hashtable();
            Hashtable ht_WXStuTest = new Hashtable();
            while (readerWX3.Read())
            {
                string testId = readerWX3["testID"].ToString();
                SqlDataReader readerWX1 = (new UserDB()).getWXInfoAsWXId1(testId);
                while (readerWX1.Read())
                {
                    string WXID2 = readerWX1["WXID"].ToString();
                    string WXTKID = readerWX1["WXTKID"].ToString();
                    Session["WXID"] = WXID2;
                    Literal lit_WXContent = new Literal();
                    lit_WXContent.Text = "<br>" + Server.HtmlEncode(readerWX1["WXName"].ToString()) + "<br>";
                    Hashtable ht_WXContent = new Hashtable();
                    ht_WXContent.Add(1, WXTKID.ToString());
                    Panel3.Controls.Add(lit_WXContent);
                    Session["WXContent"] = ht_WXContent;
                }
                string WXID1 = Convert.ToString(Session["WXID"]);
                SqlDataReader readerWXDetail = (new UserDB()).getWXTKDetailAsWXId(WXID1);
                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";
                    int stuanswer = (new UserDB()).getstuanswer(stuId, courseId, wxdetail, WXnum);
                    RadioButtonList WXlist;
                    WXlist = (RadioButtonList)Panel3.FindControl("rbtnList_WX" + WXnum.ToString());
                    switch (stuanswer)
                    {
                        case 1:
                            WXlist.Items[0].Selected = true;
                            break;
                        case 2:
                            WXlist.Items[1].Selected = true;
                            break;
                        case 3:
                            WXlist.Items[2].Selected = true;
                            break;
                        case 4:
                            WXlist.Items[3].Selected = true;
                            break;
                        default:
                            break;
                    }
                    WXnum++;
                }

            }
            Session["WXRightAnswer"] = ht_WXRightAnswer;
            Session["WXStuTest"] = ht_WXStuTest;
            SqlDataReader readerYD3 = (new UserDB()).selectYDastestpaper(stuId, courseId);
            Hashtable ht_YDRightAnswer = new Hashtable();
            Hashtable ht_YDStuTest = new Hashtable();
            while (readerYD3.Read())
            {
                string testId = readerYD3["testID"].ToString();
                SqlDataReader readerYD1 = (new UserDB()).getYDInfoAsYDId1(testId);
                while (readerYD1.Read())
                {
                    string YD2 = readerYD1["YDID"].ToString();
                    string YDID = readerYD1["YUEDUID"].ToString();
                    Session["YDID"] = YD2;
                    Literal lit_YDContent = new Literal();
                    lit_YDContent.Text = "<br>" + Server.HtmlEncode(readerYD1["YDName"].ToString()) + "<br>";
                    Hashtable ht_YDContent = new Hashtable();
                    ht_YDContent.Add(1, YDID.ToString());
                    Panel4.Controls.Add(lit_YDContent);
                    Session["YDContent"] = ht_YDContent;
                }
                string YDID1 = Convert.ToString(Session["YDID"]);
                SqlDataReader readerYDDetail = (new UserDB()).getYDDetailAsYDId(YDID1);
                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";
                    int stuanswer = (new UserDB()).getstuanswer(stuId, courseId, yddetail, YDDetailnum);
                    RadioButtonList YDlist;
                    YDlist = (RadioButtonList)Panel4.FindControl("rbtnList_YD" + YDDetailnum.ToString());
                    switch (stuanswer)
                    {
                        case 1:
                            YDlist.Items[0].Selected = true;
                            break;
                        case 2:
                            YDlist.Items[1].Selected = true;
                            break;
                        case 3:
                            YDlist.Items[2].Selected = true;
                            break;
                        case 4:
                            YDlist.Items[3].Selected = true;
                            break;
                        default:
                            break;
                    }
                    YDDetailnum++;
                }

            }
            Session["YDRightAnswer"] = ht_YDRightAnswer;
            Session["YDStuTest"] = ht_YDStuTest;
            //这写代码
            Hashtable ht_XZStuAnswer = new Hashtable();
            Hashtable ht_WXStuAnswer = new Hashtable();
            Hashtable ht_YDStuAnswer = new Hashtable();
            string XZans = "";
            string WXans = "";
            string YDans = "";
            for (int i = 1; i <= 70; i++)
            {
                RadioButtonList XZlist;
                if (i <= 35)
                {
                    XZlist = (RadioButtonList)Panel1.FindControl("rbtnList_XZ" + i.ToString());
                }
                else
                {
                    XZlist = (RadioButtonList)Panel2.FindControl("rbtnList_XZ" + i.ToString());
                }
                if (XZlist != null)
                {
                    XZans = XZlist.SelectedValue.ToString();
                    if (!ht_XZStuAnswer.Contains(i.ToString()))
                        ht_XZStuAnswer.Add(i.ToString(), XZans);
                }
                else XZans += i.ToString() + "null";
            }
            Session["XZStuAnswer"] = ht_XZStuAnswer;
            Session["XZans"] = XZans;
            for (int j = 1; j <= 20; j++)
            {
                RadioButtonList WXlist;

                WXlist = (RadioButtonList)Panel3.FindControl("rbtnList_WX" + j.ToString());

                if (WXlist != null)
                {
                    WXans = WXlist.SelectedValue.ToString();
                    if (!ht_WXStuAnswer.Contains(j.ToString()))
                        ht_WXStuAnswer.Add(j.ToString(), WXans);
                }
                else WXans += j.ToString() + "null";
            }
            Session["WXStuAnswer"] = ht_WXStuAnswer;
            Session["WXans"] = WXans;
            for (int m = 1; m <= 5; m++)
            {
                RadioButtonList YDlist;

                YDlist = (RadioButtonList)Panel4.FindControl("rbtnList_YD" + m.ToString());

                if (YDlist != null)
                {
                    YDans = YDlist.SelectedValue.ToString();
                    if (!ht_YDStuAnswer.Contains(m.ToString()))
                        ht_YDStuAnswer.Add(m.ToString(), YDans);
                }
                else YDans += m.ToString() + "null";
            }
            Session["YDStuAnswer"] = ht_YDStuAnswer;
            Session["YDans"] = YDans;
        }
    }
}