admin/ShowExam.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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;

public partial class admin_ShowExam : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["admin"] == null && Session["teacher"] == null)
        {
            Response.Redirect("../Login.aspx");
        }
        if (!IsPostBack)
        {
            InitExam();
        }
    }
    private void InitExam()
    {
        string conn = ConfigurationManager.ConnectionStrings["db_ExamOnlineConnectionString1"].ConnectionString;
        string id = "";
        if (Request["sid"] != null)
        {
            id = Request["sid"].ToString();
        }
        SqlParameter[] sp = new SqlParameter[1];

        string sql = "select * from tb_ExamPaper where id=@id";
        sp[0] = new SqlParameter("@id", id);
        SqlDataReader sdr = PetShop.DBUtility.SqlHelper.ExecuteReader(conn, CommandType.Text, sql, sp);
        while (sdr.Read())
        {
            E_Name.Text = sdr["PaperName"].ToString();
            E_time.Text = "考试时间： " + sdr["KaoShiTime"].ToString() + " 分钟";
            E_FenShu.Text = "总分: " + sdr["ExamZongFen"].ToString() + " 分";
            KaiTime.Text = "开考时间： " + sdr["KaiKaoTime"].ToString();
            Dan_Xuan.Text = "一、单选题（" + Convert.ToInt32(sdr["DanCount"]) * Convert.ToDouble(sdr["DanFen"]) + " 分，每小题 " + sdr["DanFen"].ToString() + " 分）";
            BindDanXuan(sdr["id"].ToString());
            if (Convert.ToInt32(sdr["DuoCount"]) != 0)
            {
                Duo_Xuan.Text = "二、多选题（" + Convert.ToInt32(sdr["DuoCount"]) * Convert.ToDouble(sdr["DuoFen"]) + " 分，每小题 " + sdr["DuoFen"].ToString() + " 分） ";
                BindDuoXuan(sdr["id"].ToString());
            }
            if (Convert.ToInt32(sdr["PanduanCount"]) != 0)
            {
                Pan_Duan.Text = "三、判断题（" + Convert.ToInt32(sdr["PanduanCount"]) * Convert.ToDouble(sdr["PanduanFen"]) + " 分，每小题 " + sdr["PanduanFen"].ToString() + " 分 )";
                BindPanDuan(sdr["id"].ToString());
            }
        }
        sdr.Close();
        sdr.Dispose();
    }