?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 _Default : System.Web.UI.Page
{
    OPDataBase op = new OPDataBase();
    static  string Sql = "";
    static string drSql = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Sql = "  select Class.Desn a ,ClassID,Name,Grade.Desn b,StuNum ,StartDate ,EndDate ,Department.Desn c from Class ,Teacher ,Grade ,Department  where Class.GradeID=Grade.GradeID and Grade.DepartmentID=Department.DepartmentID and Class.TeacherID=Teacher.TeacherID ";
            //聲明數(shù)組,用來設(shè)置需要轉(zhuǎn)變時間格式的GridView控件的行;
            //分別是7行和8行,注意,GridView行號是從0開始的!所以是是7和8;
     
            //綁定!
            int[] a ={ 6, 7 };
            op.BinData(Sql, GridView1, "StartDate", a);
            GridView1.DataKeyNames = new string[] { "ClassID" };
            GridView1.Attributes.Add("style", "table-layout:fixed");
         
          
        }
        //string dr_sql;
        //SqlDataReader dr;
        //dr_sql = "select * from Department";

        //dr = op.getDataReader(dr_sql);
        //while (dr.Read())
        //{
        //    DropDownList2.Items.Add(new ListItem(dr["Desn"].ToString(), dr["DepartmentID"].ToString()));

        //}
        if ((int)Session["Power"] != 0)
        {
            GridView1.Columns[8].Visible = false;
            GridView1.Columns[9].Visible = false;
        }

        TextBox2.Focus();
    }
    protected void ImageButton5_Click(object sender, ImageClickEventArgs e)
    {
        
            
        if (TextBox2.Text != "")
        {
            string txt = TextBox2.Text.ToString().Trim ();
            Sql = "select Class.Desn a ,ClassID,Name,Grade.Desn b,"+
                "StuNum ,StartDate ,EndDate ,Department.Desn c from Class ,Teacher ,Grade ,Department "+
                " where Class.GradeID=Grade.GradeID and Grade.DepartmentID=Department.DepartmentID and "+
                "Class.TeacherID=Teacher.TeacherID and ( Grade.Desn Like'%" +
                TextBox2.Text.ToString().Trim() +
                "%'or Department.Desn Like'%" +
                TextBox2.Text.ToString().Trim() + 
              
                "%'or Teacher.Name Like'%" + 
                TextBox2.Text.ToString().Trim() + "%')";
            int[] a ={ 6, 7 };

            op.BinData(Sql, GridView1, "StartDate", a);
            if (GridView1.Rows.Count < 1)
            {
                Label2.Text = "對不起,沒有符合的數(shù)據(jù)!";
            }
            else { Label2.Text = "執(zhí)行成功!"; }
            
        }
        else
        {
            Sql = "select Class.Desn a ,ClassID,Name,Grade.Desn b,StuNum ,StartDate ,EndDate ,"+
                "Department.Desn c from Class ,Teacher ,Grade ,Department  where"+
                " Class.GradeID=Grade.GradeID and Grade.DepartmentID=Department.DepartmentID and Class.TeacherID=Teacher.TeacherID and "
                + DropDownList1.SelectedValue.ToString() + "='" + DropDownList2.SelectedValue.ToString() + "'";
      
            int[] a ={ 6, 7 };
            op.BinData(Sql, GridView1, "StartDate", a);
            if (GridView1.Rows.Count < 1)
            {
                Label2.Text = "對不起,沒有符合的數(shù)據(jù)!";
            }
            else { Label2.Text = "執(zhí)行成功!"; }
           
        }
        TextBox2.Text = "";
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {

        try
        {
            GridView1.PageIndex = e.NewPageIndex;
            bin();
        }
        catch
        { }

       
   
  
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        bin();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {  
       string sql = "delete from Class where ClassID='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

        op.BindCommand(sql,Label2);
        bin();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex ;
       
       int  y = (int)(e.NewEditIndex);
       string  desn= GridView1.Rows[y].Cells[3].Text.ToString();
        

      
         drSql = "select Name ,TeacherID from Teacher where DepartmentID = (select DepartmentID from Department where Desn ='"
         +desn+ "')";
        bin(); 
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        DropDownList drl = (DropDownList)GridView1.Rows[e.RowIndex].Cells[4].FindControl("DropDownList3");
        string  teacherID=drl .SelectedValue .ToString ();
        //TextBox1.Text = teacherID;
        string sql = "update Class set  StuNum='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString() + "',TeacherID='" + teacherID + "' where ClassID='"+GridView1 .DataKeys [e.RowIndex].Value .ToString ()+"'";
        op.BindCommand(sql ,Label2);
        GridView1.EditIndex = -1;
        bin();
       
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            //鼠標(biāo)經(jīng)過時，行背景色變 
            e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#E6F5FA'");
            //鼠標(biāo)移出時，行背景色變 
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFFFFF'");
            //((ImageButton)(e.Row.Cells[9].Controls[0])).Attributes.Add("onclick", "return confirm('你確認(rèn)要刪除嗎?')");
            //如果是綁定數(shù)據(jù)行 //清清月兒http://blog.csdn.net/21aspnet 
        }
      
    }
    protected void ImageButton6_Click(object sender, ImageClickEventArgs e)
    {
       Sql = "  select Class.Desn a ,ClassID,Name,Grade.Desn b,StuNum ,StartDate ,EndDate ,Department.Desn c from Class ,Teacher ,Grade ,Department  where Class.GradeID=Grade.GradeID and Grade.DepartmentID=Department.DepartmentID and Class.TeacherID=Teacher.TeacherID ";
        //聲明數(shù)組,用來設(shè)置需要轉(zhuǎn)變時間格式的GridView控件的行;
        //分別是7行和8行,注意,GridView行號是從0開始的!所以是是7和8;
       int[] a ={ 6, 7 };
       op.BinData(Sql , GridView1, "StartDate", a);
        GridView1.DataKeyNames = new string[] { "ClassID" };
        Label2.Text = "";
    }
    //頁面綁定;
    public void bin()
    {

       

       //Sql = "  select Class.Desn a ,ClassID,Name,Grade.Desn b,StuNum ,StartDate ,EndDate ,Department.Desn c from Class ,Teacher ,Grade ,Department  where Class.GradeID=Grade.GradeID and Grade.DepartmentID=Department.DepartmentID and Class.TeacherID=Teacher.TeacherID ";
       //聲明數(shù)組,用來設(shè)置需要轉(zhuǎn)變時間格式的GridView控件的行;
       //分別是7行和8行,注意,GridView行號是從0開始的!所以是是7和8;
        int[] a ={ 6, 7 };
        op.BinData(Sql, GridView1, "StartDate", a);
        GridView1.DataKeyNames = new string[] { "ClassID"};
       
      
    
    }
    public SqlDataReader bindr()
    {
        SqlDataReader dr = op.getDataReader(drSql);

        return dr;
    }


    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    { string  Drvalue= DropDownList1 .SelectedValue.ToString ();
    string dr_sql;
    #region Switch語句;
 
    switch (Drvalue)
      {
          case "Department.Desn":
              dr_sql = "select Department.Desn h from Department";

              DataSet ds = new DataSet();
              ds = op.getDataset(dr_sql);
              DropDownList2.DataSource = ds;
              DropDownList2.DataTextField = "h";
              DropDownList2.DataValueField = "h";
              DropDownList2.DataBind();
              break;
          case "Grade.Desn":
              dr_sql = "select distinct Grade.Desn v from  Grade   order by Grade.Desn asc";

        
              ds = op.getDataset(dr_sql);
              DropDownList2.DataSource = ds;
              DropDownList2.DataTextField = "v";
              DropDownList2.DataValueField = "v";
              DropDownList2.DataBind();
            
                            
              break ;
          case "Teacher.Name":
              dr_sql = "select Teacher.Name x from Teacher";

           
              ds = op.getDataset(dr_sql );
              DropDownList2.DataSource = ds;
              DropDownList2.DataTextField ="x";
              DropDownList2.DataValueField = "x";
              DropDownList2.DataBind();
              break ;

      }
    #endregion


      


  }
}