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

public partial class EndTest : System.Web.UI.Page
{
    protected string m_answers;

    protected void Page_Load(object sender, EventArgs e)
    {
        DataTable table1 = (DataTable)Session["Questions"];
        TableHeaderCell hCell1;
        TableCell cell1;
        int iAnswer;
        MultiAnswer mAnswer;
        StringBuilder sb1 = new StringBuilder();
        for (int i = 0; i < table1.Rows.Count; i++)
        {
            hCell1 = new TableHeaderCell();
            hCell1.Text = (i + 1).ToString();
            TableRow1.Cells.Add(hCell1);
            cell1 = new TableCell();
            if (Session["Answer" + (i + 1)] != null)
            {
                iAnswer = (int)Session["Answer" + (i + 1)];
                if ((int)table1.Rows[i]["QuestionType"] == 0)
                {
                    cell1.Text = ((char)(64 + iAnswer)).ToString();
                    sb1.Append(iAnswer);
                }
                else
                {
                    mAnswer = MultiAnswer.FromByte((byte)iAnswer);
                    cell1.Text = mAnswer.ToAnswerString();
                    sb1.Append(mAnswer.ToString());
                }
                sb1.Append(' ');
            }
            TableRow2.Cells.Add(cell1);
        }
        m_answers = sb1.ToString();
    }

    protected void BtnConfirm_Click(object sender, EventArgs e)
    {      
        SqlConnection conn1 = null;
        try
        {
            conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["TestLibraryConnectionString"].ConnectionString);
            conn1.Open();
            SqlCommand cmd1 = new SqlCommand("SubmitTestPaper", conn1);
            cmd1.CommandType = CommandType.StoredProcedure;
            SqlParameter par1 = new SqlParameter("@TestID", SqlDbType.Int);
            par1.Value = Session["TestID"];
            cmd1.Parameters.Add(par1);
            par1 = new SqlParameter("@TesteeNumber", SqlDbType.NChar, 5);
            par1.Value = Session["TesteeNumber"];
            cmd1.Parameters.Add(par1);
            par1 = new SqlParameter("@Answers", SqlDbType.NVarChar, 2048);
            par1.Value = m_answers;
            cmd1.Parameters.Add(par1);
            cmd1.ExecuteNonQuery();
            Response.Write("提交成功!");
            BtnConfirm.Enabled = false;
        }
        catch (Exception exp)
        {
            Response.Write("错误:无法建立数据连接:" + exp.Message);
        }
        finally
        {
            if (conn1 != null && conn1.State != ConnectionState.Closed)
                conn1.Close();
        }
    }
}