?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;
using SMS;

public partial class add_Class : System.Web.UI.Page

{
   
    OPDataBase op = new OPDataBase();
    protected void Page_Load(object sender, EventArgs e)
    {
        string sql = "select Desn, DepartmentID from Department";
        string sqlteacher = "select TeacherID ,Name from Teacher";
   　 
    
        SqlDataReader dr1;
        dr1 = op.getDataReader(sqlteacher);
        SqlDataReader dr;
        dr = op.getDataReader(sql);
        if (!IsPostBack)
        {
            while (dr.Read())
            {
                DropDownList1.Items.Add(new ListItem(dr["Desn"].ToString(), dr["DepartmentID"].ToString()));
               
            }
            while (dr1 .Read ())
            {
            
             DropDownList3.Items.Add(new ListItem(dr1["Name"].ToString(), dr1["TeacherID"].ToString()));
            }
            for (byte a = 1; a <= 31; a++)
            {
                DropDownList7.Items.Add(new ListItem ((a + "日").ToString(),a .ToString ()));

                DropDownList11.Items.Add(new ListItem ((a + "日").ToString(), a.ToString()));
            }
     
            //string str = "select GradeID from Grade where DepartmentID='" + Session["DepartmentID"] + "'and Desn='" + Session["Desn"] + "'";
            //SqlDataReader dr3;
            //dr3 = op.getDataReader(str);
            //while (dr3.Read())
            //{
            //    TextBox1.Text = dr3["GradeID"].ToString();
            //}
     

        }
       
     

   
    }
  
   
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string speciality = DropDownList1.SelectedItem .Text .ToString();
        string sql = "select  "+speciality +" from speciality ";
        #region 控件聯動方法二;
        //SqlDataReader dr;
        //dr = op.getDataReader(sql);
        //try
        //{
        //    while (dr.Read())
        //    {
        //        DropDownList2.Items.Add(new ListItem(dr[speciality].ToString(), dr[speciality].ToString()));


        //    }
  
        //}
        //catch (Exception  ex)
        //{
        //    Label1.Text = ex.Message.ToString();

        //}
        #endregion
        Session["DepartID"] = DropDownList1.SelectedValue.ToString(); 
      
        DataSet ds = new DataSet();
        ds = op.getDataset(sql);
        DropDownList2.DataSource = ds;
        DropDownList2 .DataTextField = speciality;
        DropDownList2.DataValueField = speciality;
        DropDownList2.DataBind();
       
    }
    protected void DropDownList5_SelectedIndexChanged(object sender, EventArgs e)
    {
        Session["Desn"] = DropDownList5.SelectedValue.ToString();
    
        string str = "select GradeID from Grade where DepartmentID='" + Session["DepartID"].ToString() + "'and Desn='" +Session["Desn"].ToString () + "'";
        SqlDataReader dr3;
        dr3 = op.getDataReader(str);
        while (dr3.Read())
        {
            TextBox1.Text = dr3["GradeID"].ToString();
        }



    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string  Desn, TeacherID, GradeID, StartDate, EndDate, StuNum;
        Desn = DropDownList2.SelectedValue .ToString ()+DropDownList4 .SelectedItem.Text .ToString ();
        TeacherID = DropDownList3 .SelectedValue .ToString ();
        GradeID = ""+TextBox1 .Text+"";
      
        StartDate = DropDownList9 .SelectedValue .ToString() + DropDownList8 .SelectedValue .ToString() + DropDownList7 .SelectedValue .ToString ();
        EndDate = DropDownList6.SelectedValue.ToString() + DropDownList10.SelectedValue.ToString()+ DropDownList11.SelectedValue.ToString();
        StuNum = TextBox2.Text;
        string sql = "insert into Class (Desn, TeacherID, GradeID, StartDate, EndDate, StuNum)values('"+Desn +"','"+
         TeacherID + "','" + GradeID + "','" + StartDate + "','" + EndDate + "','" + StuNum + "')";
        if (DropDownList2.Items.Count > 0)
        {
            op.BindCommand(sql, Label1);

        }
        else 
        
        {
            Label1.Text = "*請選擇完數據后再添加!*";
        
        }
    }
}