insertshiti.aspx.cs

书本的源代码。可以用的在线考试系统。在vs平台上测试成功

                dataconn.eccom("insert into tb_Questions"
                    +"(que_professionid,que_lessonid,que_taotiid,que_subject,que_type,optionA,optionB,optionC,optionD,que_answer,note)"
                    +"values('" + sstr1 + "','" + sstr2 + "','" + sstr3 + "','" + this.txtExamTitle.Text 
                    + "','" + ddlType.Text + "','" + this.txtExamA.Text + "','" + this.txtExamB.Text 
                    + "','" + this.txtExamC.Text + "','" + this.txtExamD.Text + "','" + str9 
                    + "','" + txtInstruction.Text + "')");
                Response.Redirect("kaoshi_timu.aspx");
            }
            if (cblAnswer.Items[0].Selected == false && cblAnswer.Items[1].Selected == false && cblAnswer.Items[2].Selected == true && cblAnswer.Items[3].Selected == true)
            {
                string str10 = "C,D";
                dataconn.eccom("insert into tb_Questions"
                    +"(que_professionid,que_lessonid,que_taotiid,que_subject,que_type,optionA,optionB,optionC,optionD,que_answer,note)"
                    +"values('" + sstr1 + "','" + sstr2 + "','" + sstr3 + "','" + this.txtExamTitle.Text 
                    + "','" + ddlType.Text + "','" + this.txtExamA.Text + "','" + this.txtExamB.Text 
                    + "','" + this.txtExamC.Text + "','" + this.txtExamD.Text + "','" + str10 
                    + "','" + txtInstruction.Text + "')");
                Response.Redirect("kaoshi_timu.aspx");
            }
            if (cblAnswer.Items[0].Selected == true && cblAnswer.Items[1].Selected == false && cblAnswer.Items[2].Selected == true && cblAnswer.Items[3].Selected == false)
            {
                string str11 = "A,C";
                dataconn.eccom("insert into tb_Questions"
                    +"(que_professionid,que_lessonid,que_taotiid,que_subject,que_type,optionA,optionB,optionC,optionD,que_answer,note)"
                    +"values('" + sstr1 + "','" + sstr2 + "','" + sstr3 + "','" + this.txtExamTitle.Text 
                    + "','" + ddlType.Text + "','" + this.txtExamA.Text + "','" + this.txtExamB.Text 
                    + "','" + this.txtExamC.Text + "','" + this.txtExamD.Text + "','" + str11 
                    + "','" + txtInstruction.Text + "')");
                Response.Redirect("kaoshi_timu.aspx");
            }
            if (cblAnswer.Items[0].Selected == false && cblAnswer.Items[1].Selected == true && cblAnswer.Items[2].Selected == true && cblAnswer.Items[3].Selected == false)
            {
                string str12 = "B,D";
                dataconn.eccom("insert into tb_Questions"
                    +"(que_professionid,que_lessonid,que_taotiid,que_subject,que_type,optionA,optionB,optionC,optionD,que_answer,note)"
                    +"values('" + sstr1 + "','" + sstr2 + "','" + sstr3 + "','" + this.txtExamTitle.Text 
                    + "','" + ddlType.Text + "','" + this.txtExamA.Text + "','" + this.txtExamB.Text 
                    + "','" + this.txtExamC.Text + "','" + this.txtExamD.Text + "','" + str12 
                    + "','" + txtInstruction.Text + "')");
                Response.Redirect("kaoshi_timu.aspx");
            }
            if (cblAnswer.Items[0].Selected == true && cblAnswer.Items[1].Selected == true && cblAnswer.Items[2].Selected == false && cblAnswer.Items[3].Selected == true)
            {
                string str13 = "A,B,D";
                dataconn.eccom("insert into tb_Questions"
                    +"(que_professionid,que_lessonid,que_taotiid,que_subject,que_type,optionA,optionB,optionC,optionD,que_answer,note)"
                    +"values('" + sstr1 + "','" + sstr2 + "','" + sstr3 + "','" + this.txtExamTitle.Text 
                    + "','" + ddlType.Text + "','" + this.txtExamA.Text + "','" + this.txtExamB.Text 
                    + "','" + this.txtExamC.Text + "','" + this.txtExamD.Text + "','" + str13 
                    + "','" + txtInstruction.Text + "')");
                Response.Redirect("kaoshi_timu.aspx");
            }
            if (cblAnswer.Items[0].Selected == true && cblAnswer.Items[1].Selected == false && cblAnswer.Items[2].Selected == true && cblAnswer.Items[3].Selected == true)
            {
                string str14 = "A,C";
                dataconn.eccom("insert into tb_Questions"
                    +"(que_professionid,que_lessonid,que_taotiid,que_subject,que_type,optionA,optionB,optionC,optionD,que_answer,note)"
                    +"values('" + sstr1 + "','" + sstr2 + "','" + sstr3 + "','" + this.txtExamTitle.Text 
                    + "','" + ddlType.Text + "','" + this.txtExamA.Text + "','" + this.txtExamB.Text 
                    + "','" + this.txtExamC.Text + "','" + this.txtExamD.Text + "','" + str14 
                    + "','" + txtInstruction.Text + "')");
                Response.Redirect("kaoshi_timu.aspx");
            }
            if (cblAnswer.Items[0].Selected == false && cblAnswer.Items[1].Selected == false && cblAnswer.Items[2].Selected == true && cblAnswer.Items[3].Selected == false)
            {
                string str15 = "C";
                dataconn.eccom("insert into tb_Questions"
                    +"(que_professionid,que_lessonid,que_taotiid,que_subject,que_type,optionA,optionB,optionC,optionD,que_answer,note)"
                    +"values('" + sstr1 + "','" + sstr2 + "','" + sstr3 + "','" + this.txtExamTitle.Text 
                    + "','" + ddlType.Text + "','" + this.txtExamA.Text + "','" + this.txtExamB.Text 
                    + "','" + this.txtExamC.Text + "','" + this.txtExamD.Text + "','" + str15 
                    + "','" + txtInstruction.Text + "')");
                Response.Redirect("kaoshi_timu.aspx");
            }
            if (cblAnswer.Items[0].Selected == false && cblAnswer.Items[1].Selected == false && cblAnswer.Items[2].Selected == false && cblAnswer.Items[3].Selected == true)
            {
                string str16 = "D";
                dataconn.eccom("insert into tb_Questions"
                    +"(que_professionid,que_lessonid,que_taotiid,que_subject,que_type,optionA,optionB,optionC,optionD,que_answer,note)"
                    +"values('" + sstr1 + "','" + sstr2 + "','" + sstr3 + "','" + this.txtExamTitle.Text 
                    + "','" + ddlType.Text + "','" + this.txtExamA.Text + "','" + this.txtExamB.Text 
                    + "','" + this.txtExamC.Text + "','" + this.txtExamD.Text + "','" + str16 
                    + "','" + txtInstruction.Text + "')");
                Response.Redirect("kaoshi_timu.aspx");
            }
        }
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("admin.aspx");    
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("zhuce_stu.aspx");
    }
    protected void LinkButton3_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("zhuanye_xinxi.aspx");
    }
    protected void LinkButton4_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("kecheng_xinxi.aspx"); 
    }
    protected void LinkButton5_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("taoti_xinxi.aspx");  
    }
    protected void LinkButton6_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("kaosheng_chengji.aspx");
    }
    protected void LinkButton7_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("kaoshi_timu.aspx");
    }
    protected void LinkButton8_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("insert_shiti.aspx"); 
    }
    protected void LinkButton9_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("../index.aspx");  
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("InsertShiTi.aspx");
    }
    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>");
        }
    }
}