?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 _Default2 : System.Web.UI.Page
{
    OPDataBase op = new OPDataBase();
    static string drSql = "";
    //static string Sql = "select * ,Name From Course,Teacher Where Course.TeacherID=Teacher.TeacherID";
    static string Sql = "";
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Sql = "select * ,Name From Course,Teacher Where Course.TeacherID=Teacher.TeacherID";
            op.BinData(Sql, GridView1);
            GridView1.DataKeyNames = new string[] { "Desn" };
            GridView1.Attributes.Add("style", "table-layout:fixed");
            string sql = "select Desn from Course";
            SqlDataReader dr;
            dr = op.getDataReader(sql);
            while (dr.Read())
            {
                DropDownList1.Items.Add(new ListItem(dr["Desn"].ToString(), dr["Desn"].ToString()));
                DropDownList1.SelectedIndex = 2;
            }
            if ((int)Session["Power"] != 0)
            {
                GridView1.Columns[8].Visible = false;
                GridView1.Columns[9].Visible = false;

            }

        }
       
     
        
    }

    public void bin()
    {
        
        op.BinData(Sql ,GridView1);
        GridView1.DataKeyNames = new string[] { "Desn"};
       
    
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Sql = "select * ,Name From Course,Teacher Where  Course.Desn='" + DropDownList1.SelectedValue.ToString() + "'and Course.TeacherID=Teacher.TeacherID";

      
        bin();
       
       
       
       
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        try
        {
            GridView1.PageIndex = e.NewPageIndex;
            bin();
         }
     catch { }  
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex ;
        drSql = "select Name ,TeacherID from Teacher ";

       bin();
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        bin();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string  Body, StartDate, EndDate, ExamineDate, TeacherID, CourseHour, TotalMark;
       
        Body = ((TextBox)((GridView1.Rows[e.RowIndex].Cells[1].Controls[0]))).Text.ToString().Trim();
        StartDate = ((TextBox)((GridView1.Rows[e.RowIndex].Cells[2].Controls[0]))).Text.ToString().Trim();
        EndDate= ((TextBox)((GridView1.Rows[e.RowIndex].Cells[3].Controls[0]))).Text.ToString().Trim();
        CourseHour=  ((TextBox)((GridView1.Rows[e.RowIndex].Cells[4].Controls[0]))).Text.ToString().Trim();
        //DropDownList drl = (DropDownList)GridView1.Rows[e.RowIndex].Cells[4].FindControl("DropDownList3");
        //string teacherID = drl.SelectedValue.ToString();
     
            DropDownList  dl= (DropDownList )GridView1.Rows[e.RowIndex].Cells[5].FindControl("DropDownList2");

            TeacherID = dl.SelectedValue.ToString();
      
        ExamineDate=  ((TextBox)((GridView1.Rows[e.RowIndex].Cells[6].Controls[0]))).Text.ToString().Trim() ;
        TotalMark = ((TextBox)((GridView1.Rows[e.RowIndex].Cells[7].Controls[0]))).Text.ToString().Trim() ;
        string sql = "Update Course set Body='"+Body+"' ,StartDate='"+StartDate+"' ,EndDate='"+EndDate
            +"' ,CourseHour='"+CourseHour+"' ,TeacherID='"+TeacherID+"',ExamineDate='"+ExamineDate+"' ,TotalMark='"+TotalMark+"' where Desn='"+
            GridView1.DataKeys[e.RowIndex].Value.ToString() +"'";
        SqlConnection conn = new SqlConnection(op.getConnection ());
        conn.Open();
        SqlCommand cmd = new SqlCommand(sql,conn );
        try
        {
            //op.BindCommand(Sql);
            cmd.ExecuteNonQuery();
            GridView1.EditIndex = -1;
            bin();
        }
        catch (SqlException E)
        {
            Label2.Text = E.Message.ToString();
           // Response.Write("<script>alert('失敗！')</script>");
        }
        
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string sql = "delete From Course where Desn='" + GridView1.DataKeys[e.RowIndex].Value.ToString() +"'";
        op.BindCommand(sql );
        bin();
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            //鼠標經過時，行背景色變 
            e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#E6F5FA'");
            //鼠標移出時，行背景色變 
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFFFFF'");
            //((ImageButton)(e.Row.Cells[9].Controls[0])).Attributes.Add("onclick", "return confirm('你確認要刪除嗎?')");
            //如果是綁定數據行 //清清月兒http://blog.csdn.net/21aspnet 
        }

    }
    public SqlDataReader bindr()
    {
        SqlDataReader dr = op.getDataReader(drSql);

        return dr;
    }

    protected void ImageButton5_Click(object sender, ImageClickEventArgs e)
    {
        Sql = "select * ,Name From Course,Teacher Where Course.TeacherID=Teacher.TeacherID";
        bin();
    }
}