wfrmshow專長.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
{
    protected void Page_Load(object sender, EventArgs e)
    {

        C專長 l_專長 = new C專長();

        C專長[] l_專長s = new C專長Factory(Session["DbManager"].ToString()).show所有專長(l_專長);

        displatGridView(l_專長s);

    }

    private void displatGridView(C專長[] l_專長s)
    {
        DataTable l_table = new DataTable();
        l_table.Columns.Add(new DataColumn("選取"));
        l_table.Columns.Add(new DataColumn("專長代號"));
        l_table.Columns.Add(new DataColumn("專長名稱"));
        l_table.Columns.Add(new DataColumn("敘述"));

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

            l_table.Rows.Add(l_row);
        }
        GridView1.DataSource = l_table;
        GridView1.DataBind();
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        C專長[] l_專長s = (C專長[])Session["TeacherSpeciality"];

        if (!"選取".Equals(e.Row.Cells[0].Text))
        {
            CheckBox l_check = new CheckBox();
            e.Row.Cells[0].Controls.Add(l_check);
            foreach (C專長 c in l_專長s)
                if (c.SpecName.Equals(e.Row.Cells[2].Text))
                {
                    l_check.Checked = true;
                }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        C專長[] l_專長s = (C專長[])Session["TeacherSpeciality"];
        CTeacher l_teacher = (CTeacher)Session["CurrentTeacher"];
        C專長Factory l_專長Factory = new C專長Factory(Session["DbManager"].ToString());

        foreach (GridViewRow r in GridView1.Rows)
        {

            CheckBox l_chk = (CheckBox)r.Cells[0].Controls[0];
            if (l_專長s.Length == 0)
            {
                if (l_chk.Checked)
                {
                    C專長 l_專長 = new C專長();
                    l_專長.TeacherID = l_teacher.TeacherID;
                    l_專長.SpecID = r.Cells[1].Text;
                    l_專長.SpecName = r.Cells[2].Text;
                    l_專長Factory.update(l_專長);
                }
            }
            else
            {
                if (l_chk.Checked)
                {

                    l_專長s[0].SpecID = r.Cells[1].Text;
                    l_專長s[0].SpecName = r.Cells[2].Text;
                    l_專長Factory.update(l_專長s[0]);
                }
                else
                {
                    l_專長s[0].SpecID = r.Cells[1].Text;
                    l_專長s[0].SpecName = r.Cells[2].Text;
                    l_專長Factory.delete(l_專長s[0]);
                }
            }

        }
        Response.Redirect("瀏覽老師專長視窗.aspx");
    }
}