?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_Teacher : System.Web.UI.Page
{
    Datacon dataconn = new Datacon();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {


            dataconn.ecadabindinfostring(gvTeacherInfo, "select * from tb_Teacher ORDER BY ID DESC", "ID");
        }
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvTeacherInfo.PageIndex = e.NewPageIndex;
        dataconn.ecadabind(gvTeacherInfo, "Select * From tb_Teacher Where "
                + ddlTeacherName.SelectedValue + "  Like  '%" + txtSelect.Text + "%'");
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (txtSelect.Text == "")
        {
            dataconn.ecadabindinfostring(gvTeacherInfo, "select * from tb_Teacher ORDER BY ID DESC", "ID");
        }
        else
        {
            dataconn.ecadabind(gvTeacherInfo, "Select * From tb_Teacher Where "
                + ddlTeacherName.SelectedValue + "  Like  '%" + txtSelect.Text + "%'");
        }
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        dataconn.eccom("delete from tb_Teacher where ID='" + gvTeacherInfo.DataKeys[e.RowIndex].Value + "'");
        Page.Response.Redirect("Teacher.aspx");
    }
    protected void LinkButton10_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("TeacherInsert.aspx");
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Cells[2].Text = Convert.ToString(Convert.ToDateTime(e.Row.Cells[2].Text).ToShortDateString());
        }
    }
    protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
    {
        if (TreeView1.SelectedNode.Text == "退出系統(tǒng)")
        {
            Response.Write("<script lanuage=javascript>window.close();location='javascript:history.go(-1)'</script>");
        }
    }
}