瀏覽老師專長視窗.aspx.cs

Teacher Manager System

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;

public partial class _Default : System.Web.UI.Page
{
    C專長[] iv_專長s;
    protected void Page_Load(object sender, EventArgs e)
    {


        CTeacher l_teacher = (CTeacher)Session["CurrentTeacher"];
        lblTeacherName.Text = l_teacher.Name.ToString() + "老師的專長列表" + "<br/>";
        C專長 l_專長 = new C專長();
        l_專長.TeacherID = l_teacher.TeacherID;
        iv_專長s = new C專長Factory(Session["DbManager"].ToString()).query(l_專長);

        displayGridView();
        Session["TeacherSpeciality"] = iv_專長s;

    }

    private void displayGridView()
    {
        DataTable l_table = new DataTable();
        l_table.Columns.Add(new DataColumn("專長編號"));
        l_table.Columns.Add(new DataColumn("專長名稱"));
        l_table.Columns.Add(new DataColumn("敘述"));

        for (int i = 0; i < iv_專長s.Length; i++)
        {
            DataRow l_row = l_table.NewRow();
            l_row["專長編號"] = iv_專長s[i].SpecID.ToString();
            l_row["專長名稱"] = iv_專長s[i].SpecName.ToString();
            l_row["敘述"] = iv_專長s[i].Description.ToString();

            l_table.Rows.Add(l_row);
        }
        GView瀏覽專長.DataSource = l_table;
        GView瀏覽專長.DataBind();

    }
    //private string getTeacher專長SqlCommandString()
    //{
        //string l_strSql = "SELECT * FROM Specialty WHERE";
        //if (!"".Equals(txt專長編號Select.Text.Trim()))
        //    l_strSql += "(SpecID LIKE'%" + txt專長編號Select.Text + "%') AND ";
        //if (!"".Equals(txt專長名稱Select.Text.Trim()))
        //    l_strSql += "(SpecName LIKE'%" + txt專長名稱Select.Text + "%') AND ";
        //return l_strSql.Substring(0, l_strSql.Length - 5);
    //}
    protected void btn專長Select_Click(object sender, EventArgs e)
    {



    }
    protected void GView瀏覽專長_RowDataBound(object sender, GridViewRowEventArgs e)
    {




    }
    protected void GView瀏覽專長_SelectedIndexChanged(object sender, EventArgs e)
    {

        //Label1.Text = "Hello";
    }

    protected void Button1_Click1(object sender, EventArgs e)
    {
        Response.Redirect("WfrmShow專長.aspx");
    }
    protected void btnOk_Click(object sender, EventArgs e)
    {
        Response.Redirect("WfrmTeacherPage.aspx");
    }
}