?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_InsertShiTi : System.Web.UI.Page
{
    Datacon dataconn = new Datacon();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (ddlType.SelectedIndex == 0)
        {
            Panel1.Visible = true;
            Panel2.Visible = false;
            Panel3.Visible = false;
            Panel4.Visible = false;
            Panel5.Visible = false;
        }       
        if (ddlType.SelectedIndex == 1)
        {
            Panel1.Visible = false;
            Panel2.Visible = true;
            Panel3.Visible = false;
            Panel4.Visible = false;
            Panel5.Visible = false;
        }
        if (ddlType.SelectedIndex == 2)
        {
            Panel1.Visible = false;
            Panel2.Visible = false;
            Panel3.Visible = true;
            Panel4.Visible = false;
            Panel5.Visible = false;
            txtExamA.Visible = false;
            txtExamB.Visible = false;
            txtExamC.Visible = false;
            txtExamD.Visible = false;
            Label4.Visible = false;
            Label5.Visible = false;
            Label6.Visible = false;
            Label7.Visible = false;
            Label12.Visible = false;
            Label13.Visible = false;
            Label14.Visible = false;
            Label15.Visible = false;
        }
        if (ddlType.SelectedIndex == 3)
        {
            Panel1.Visible = false;
            Panel2.Visible = false;
            Panel3.Visible = false;
            Panel4.Visible = true;
            Panel5.Visible = false;
            txtExamA.Visible = false;
            txtExamB.Visible = false;
            txtExamC.Visible = false;
            txtExamD.Visible = false;
            Label4.Visible = false;
            Label5.Visible = false;
            Label6.Visible = false;
            Label7.Visible = false;
            Label12.Visible = false;
            Label13.Visible = false;
            Label14.Visible = false;
            Label15.Visible = false;
        }
        if (ddlType.SelectedIndex == 4)
        {
            Panel1.Visible = false;
            Panel2.Visible = false;
            Panel3.Visible = false;
            Panel4.Visible = false;
            Panel5.Visible = true;
            txtExamA.Visible = false;
            txtExamB.Visible = false;
            txtExamC.Visible = false;
            txtExamD.Visible = false;
            Label4.Visible = false;
            Label5.Visible = false;
            Label6.Visible = false;
            Label7.Visible = false;
            Label12.Visible = false;
            Label13.Visible = false;
            Label14.Visible = false;
            Label15.Visible = false;
        }

    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        string sstr1 = Session["drop1"].ToString();
        string sstr2 = Session["drop2"].ToString();
        string sstr3 = Session["drop3"].ToString();
        if (ddlType.SelectedIndex == 2)
        {
            dataconn.eccom("insert into tb_Panduan"
                + "(que_professionid,que_lessonid,que_taotiid,que_subject,que_type,que_answer,note)"
                + "values('" + sstr1 + "','" + sstr2 + "','" + sstr3 + "','" + this.txtExamTitle.Text
                + "','" + ddlType.Text + "','"
                + panduanAnswer.Text + "','" + txtInstruction.Text + "')");
            Response.Redirect("kaoshi_timu.aspx");
        }
        if (ddlType.SelectedIndex == 3)
        {
            dataconn.eccom("insert into tb_Tiankong"
                + "(que_professionid,que_lessonid,que_taotiid,que_subject,que_type,que_answer,note)"
                + "values('" + sstr1 + "','" + sstr2 + "','" + sstr3 + "','" + this.txtExamTitle.Text
                + "','" + ddlType.Text + "','"
                + tiankongAnswer.Text + "','" + txtInstruction.Text + "')");
            Response.Redirect("kaoshi_timu.aspx");
        }
        if (ddlType.SelectedIndex == 4)
        {
            dataconn.eccom("insert into tb_Jianda"
                + "(que_professionid,que_lessonid,que_taotiid,que_subject,que_type,que_answer,note)"
                + "values('" + sstr1 + "','" + sstr2 + "','" + sstr3 + "','" + this.txtExamTitle.Text
                + "','" + ddlType.Text + "','"
                + jiandaAnswer.Text + "','" + txtInstruction.Text + "')");
            Response.Redirect("kaoshi_timu.aspx");
        }
        if (ddlType.SelectedIndex == 0)
        {
            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 + "','" 
                + ddlAnswer.Text + "','" + txtInstruction.Text + "')");
            Response.Redirect("kaoshi_timu.aspx");
        }
        else
        {
            if (cblAnswer.Items[0].Selected == true && cblAnswer.Items[1].Selected == true && cblAnswer.Items[2].Selected == true && cblAnswer.Items[3].Selected == true)
            {
                string str1 = "A,B,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 + "','" + str1 
                    + "','" + txtInstruction.Text + "')");
                Response.Redirect("kaoshi_timu.aspx");
            }
            if (cblAnswer.Items[0].Selected == true && cblAnswer.Items[1].Selected == true && cblAnswer.Items[2].Selected == true && cblAnswer.Items[3].Selected == false)
            {
                string str2 = "A,B,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 + "','" + str2 
                    + "','" + 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 == false)
            {
                string str3 = "A,B";
                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 + "','" + str3 
                    + "','" + txtInstruction.Text + "')");
                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("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 + "','" + str4 
                    + "','" + txtInstruction.Text + "')");
                Response.Redirect("kaoshi_timu.aspx");
            }