test.aspx.cs

二、目的和意义 本项目成果提供一个数值分析在线考试的网站

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

public partial class _Default : System.Web.UI.Page 
{

    private RadioButton[] testBtn1 = new RadioButton[10];
    private RadioButton[] testBtn2 = new RadioButton[10];
    private RadioButton[] testBtn3 = new RadioButton[10];
    private RadioButton[] testBtn4 = new RadioButton[10];
    private static int[] rightAns = new int[10];
    private int score = 0;
   
    public void Page_Load(object sender, EventArgs e)
    {   
        SqlConnection con = new SqlConnection("server=.;database=TestOnline;uid=sa;pwd=123;");
        con.Open();
        SqlCommand cmd = new SqlCommand("select max(id) from XZ_test", con);
        int maxTestID = (int)cmd.ExecuteScalar();
        int[] testIDs = new int[10];
        Random rand = new Random();
        String testContent = "";
        String ans1 = "";
        String ans2 = "";
        String ans3 = "";
        String ans4 = "";
        String testID = "";
        for (int i = 0; i < 10; i++)
        {
            int j = rand.Next(1, maxTestID);
            int k = 0;
            cmd = new SqlCommand("select id from XZ_test where id=" + j, con);
            while (cmd.ExecuteScalar() == null)
            {
                j = rand.Next(1, maxTestID);
                cmd = new SqlCommand("select id from XZ_test where id=" + j, con);
            }
            while (k <= i)
            {
                cmd = new SqlCommand("select id from XZ_test where id=" + j, con);
                if (j == testIDs[k] || cmd.ExecuteScalar()==null)
                {
                    j = rand.Next(1,maxTestID);
                    k = 0;
                }
                else
                {
                    k++;
                }
            }
            Literal l = new Literal();
            Literal l1 = new Literal();
            cmd = new SqlCommand("select testContent from XZ_test where id=" + j, con);
            testContent = (String)cmd.ExecuteScalar();
            cmd = new SqlCommand("select testAns1 from XZ_test where id=" + j, con);
            ans1 = (String)cmd.ExecuteScalar();
            cmd = new SqlCommand("select testAns2 from XZ_test where id=" + j, con);
            ans2 = (String)cmd.ExecuteScalar();
            cmd = new SqlCommand("select testAns3 from XZ_test where id=" + j, con);
            ans3 = (String)cmd.ExecuteScalar();
            cmd = new SqlCommand("select testAns4 from XZ_test where id=" + j, con);
            ans4 = (String)cmd.ExecuteScalar();
            
            
            l.Text = i + 1 + "." + testContent + "<br>";
            testBtn1[i] = new RadioButton();
            testBtn2[i] = new RadioButton();
            testBtn3[i] = new RadioButton();
            testBtn4[i] = new RadioButton();
            testBtn1[i].GroupName = "g" + i;
            testBtn1[i].Text = "A、" + ans1 + "　　";
            testBtn1[i].ID = "testBtn1" + i;
            testBtn2[i] = new RadioButton();
            testBtn2[i].GroupName = "g" + i;
            testBtn2[i].Text = "B、" + ans2 + "　　";
            testBtn2[i].ID = "testBtn2" + i;
            testBtn3[i] = new RadioButton();
            testBtn3[i].GroupName = "g" + i;
            testBtn3[i].Text = "C、" + ans3 + "　　";
            testBtn3[i].ID = "testBtn3" + i;
            testBtn4[i] = new RadioButton();
            testBtn4[i].GroupName = "g" + i;
            testBtn4[i].Text = "D、" + ans4 + "　　";
            testBtn4[i].ID = "testBtn4" + i;
            Panel1.Controls.Add(l);
            Panel1.Controls.Add(testBtn1[i]);
            Panel1.Controls.Add(testBtn2[i]);
            Panel1.Controls.Add(testBtn3[i]);
            Panel1.Controls.Add(testBtn4[i]);
            l1.Text = "<br><br>";
            Panel1.Controls.Add(l1);
            testIDs[i] = j; 
        }
        if (!IsPostBack)
        {
            for (int i = 0; i < 10; i++)
            {
                cmd = new SqlCommand("select rightAns from XZ_test where id=" + testIDs[i], con);
                rightAns[i] = (int)cmd.ExecuteScalar();
            }
        }
        Button b = new Button();
        b.Text = "提交";
        b.Click += new System.EventHandler(this.b_click);
        Literal lc = new Literal();
        Literal lc1 = new Literal();
        lc.Text = "<center>";
        lc1.Text = "</center>";
        Panel1.Controls.Add(lc);
        Panel1.Controls.Add(b);
        Panel1.Controls.Add(lc1);
        con.Close();       
    }

    public void b_click(object sender, EventArgs e)
    {
        for (int i = 0; i < 10; i++)
        {
            if (testBtn1[i].Checked)
            {
                if (rightAns[i] == 1)
                {
                    score += 10;
                }
            }
            else if (testBtn2[i].Checked)
            {
                if (rightAns[i] == 2)
                {
                    score += 10;
                }
            }
            else if (testBtn3[i].Checked)
            {
                if (rightAns[i] == 3)
                {
                    score += 10;
                }
            }
            else if(testBtn4[i].Checked)
            {
                if (rightAns[i] == 4)
                {
                    score += 10;
                }
            }
        }
        Response.Redirect("result.aspx?score=" + score);
    }
}