kaoshiupdate.aspx.cs

SQL+Asp.net(c#)网上考试系统

                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str3 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                Response.Redirect("kaoshi_timu.aspx");
            }
            if (cblAnswer.Items[0].Selected == true && cblAnswer.Items[1].Selected == false && cblAnswer.Items[2].Selected == false && cblAnswer.Items[3].Selected == false)
            {
                string str4 = "A";
                dataconn.eccom("update tb_Questions set que_subject='"
                    + this.txtLessName.Text + "',que_type='" + ddlProfession.Text + "',optionA='"
                    + this.txtSelA.Text + "',optionB='" + this.txtSelB.Text + "',optionC='"
                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str4 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                Response.Redirect("kaoshi_timu.aspx");
            }
            if (cblAnswer.Items[0].Selected == false && cblAnswer.Items[1].Selected == true && cblAnswer.Items[2].Selected == false && cblAnswer.Items[3].Selected == false)
            {
                string str5 = "B";
                dataconn.eccom("update tb_Questions set que_subject='"
                    + this.txtLessName.Text + "',que_type='" + ddlProfession.Text + "',optionA='"
                    + this.txtSelA.Text + "',optionB='" + this.txtSelB.Text + "',optionC='"
                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str5 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                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 str6 = "B,C";
                dataconn.eccom("update tb_Questions set que_subject='"
                    + this.txtLessName.Text + "',que_type='" + ddlProfession.Text + "',optionA='"
                    + this.txtSelA.Text + "',optionB='" + this.txtSelB.Text + "',optionC='"
                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str6 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                Response.Redirect("kaoshi_timu.aspx");
            }
            if (cblAnswer.Items[0].Selected == false && cblAnswer.Items[1].Selected == true && cblAnswer.Items[2].Selected == false && cblAnswer.Items[3].Selected == true)
            {
                string str7 = "B,D";
                dataconn.eccom("update tb_Questions set que_subject='"
                    + this.txtLessName.Text + "',que_type='" + ddlProfession.Text + "',optionA='"
                    + this.txtSelA.Text + "',optionB='" + this.txtSelB.Text + "',optionC='"
                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str7 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                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 == true)
            {
                string str8 = "B,C,D";
                dataconn.eccom("update tb_Questions set que_subject='"
                    + this.txtLessName.Text + "',que_type='" + ddlProfession.Text + "',optionA='"
                    + this.txtSelA.Text + "',optionB='" + this.txtSelB.Text + "',optionC='"
                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str8 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                Response.Redirect("kaoshi_timu.aspx");
            }
            if (cblAnswer.Items[0].Selected == true && cblAnswer.Items[1].Selected == false && cblAnswer.Items[2].Selected == false && cblAnswer.Items[3].Selected == true)
            {
                string str9 = "A,D";
                dataconn.eccom("update tb_Questions set que_subject='"
                    + this.txtLessName.Text + "',que_type='" + ddlProfession.Text + "',optionA='"
                    + this.txtSelA.Text + "',optionB='" + this.txtSelB.Text + "',optionC='"
                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str9 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                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("update tb_Questions set que_subject='"
                    + this.txtLessName.Text + "',que_type='" + ddlProfession.Text + "',optionA='"
                    + this.txtSelA.Text + "',optionB='" + this.txtSelB.Text + "',optionC='"
                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str10 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                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("update tb_Questions set que_subject='"
                    + this.txtLessName.Text + "',que_type='" + ddlProfession.Text + "',optionA='"
                    + this.txtSelA.Text + "',optionB='" + this.txtSelB.Text + "',optionC='"
                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str11 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                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("update tb_Questions set que_subject='"
                    + this.txtLessName.Text + "',que_type='" + ddlProfession.Text + "',optionA='"
                    + this.txtSelA.Text + "',optionB='" + this.txtSelB.Text + "',optionC='"
                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str12 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                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("update tb_Questions set que_subject='"
                    + this.txtLessName.Text + "',que_type='" + ddlProfession.Text + "',optionA='"
                    + this.txtSelA.Text + "',optionB='" + this.txtSelB.Text + "',optionC='"
                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str13 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                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("update tb_Questions set que_subject='"
                    + this.txtLessName.Text + "',que_type='" + ddlProfession.Text + "',optionA='"
                    + this.txtSelA.Text + "',optionB='" + this.txtSelB.Text + "',optionC='"
                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str14 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                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("update tb_Questions set que_subject='"
                    + this.txtLessName.Text + "',que_type='" + ddlProfession.Text + "',optionA='"
                    + this.txtSelA.Text + "',optionB='" + this.txtSelB.Text + "',optionC='"
                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str15 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                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("update tb_Questions set que_subject='"
                    + this.txtLessName.Text + "',que_type='" + ddlProfession.Text + "',optionA='"
                    + this.txtSelA.Text + "',optionB='" + this.txtSelB.Text + "',optionC='"
                    + this.txtSelC.Text + "',optionD='" + this.txtSelD.Text + "',que_answer='"
                    + str16 + "',note='" + txtInstruction.Text + "' where id=" + Request["id"]);
                Response.Redirect("kaoshi_timu.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>");
        }
    }
}