insert_shiti.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;

public partial class HouAdmin_insert_shiti : System.Web.UI.Page
{
    Datacon dataconn = new Datacon();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            dataconn.ecDropDownList(ddlProfession, "select * from tb_Profession", "Name", "id");
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("insert_shiti.aspx");
    }
    protected void btnSelect_Click(object sender, EventArgs e)
    {
        Session["drop1"] = ddlProfession.Text;
        Session["drop2"] = ddlLesson.Text;
        Session["drop3"] = ddlQueName.Text;
        if (this.ddlLesson.Text == "" )
        {
            Page.Response.Write("<script lanuage=javascript>alert('请选择考试课程');location='javascript:history.go(-1)'</script>");
            return;
        }
        Page.Response.Redirect("InsertShiTi.aspx");   
    }
    protected void ddlProfession_SelectedIndexChanged(object sender, EventArgs e)
    {
        dataconn.ecDropDownList(ddlLesson, "select * from tb_Lesson where ofProfession='" 
            + ddlProfession.SelectedValue.ToString() + "'", "Name", "id");
        dataconn.ecDropDownList(ddlQueName, "select a.*,b.ofProfession from tb_TaoTi as a join tb_Lesson as b on a.LessonID=b.ID where a.LessonID='"
            + ddlLesson.SelectedValue.ToString() + "' and b.ofProfession='"
            + ddlProfession.SelectedValue.ToString() + "'", "Name", "id");
    }
    protected void ddlLesson_SelectedIndexChanged(object sender, EventArgs e)
    {
        dataconn.ecDropDownList(ddlQueName, "select * from tb_TaoTi where LessonID='" + ddlLesson.SelectedValue.ToString() + "'", "Name", "id");
    }

    protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
    {
        if (TreeView1.SelectedNode.Text=="退出系统")
        {
            Response.Write("<script lanuage=javascript>window.close();location='javascript:history.go(-1)'</script>");
        }
    }
}