wfrmcourseteacher.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
{
    private String getMode()
    {
        if (Session["CT"] == null)
            return "0";
        return Session["CT"].ToString();
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack && getMode().Equals("刪除"))
            doSearch();     
        if (!Page.IsPostBack && getMode().Equals("編輯"))
            doSearch();
        if (!Page.IsPostBack && getMode().Equals("新增"))
            doSearch();
        lblUser.Text = "目前使用者" + getFacade().目前使用者.USERNAME;
        //if (Page.IsPostBack)
        //{
        //    doSearch();
        //}

    }


    private CCourse教師Factory iv_CCourseTeacherFactory;
    private CCourse教師Factory get課程講師Factory()
    {
        if (iv_CCourseTeacherFactory == null)
        {
            iv_CCourseTeacherFactory = new CCourse教師Factory(Session["DbManager"].ToString());

        }
        return iv_CCourseTeacherFactory;
    }
    private C課程Manager iv_CCourseManager;
    private C課程Manager get課程Manager()
    {
        if (iv_CCourseManager == null)
        {
            iv_CCourseManager = new C課程Manager();
        }
        return iv_CCourseManager;

    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        Response.Redirect("WfrmCourseTeacherAdd.aspx");
    }

    protected void btnSearch_Click(object sender, EventArgs e)
    {

        doSearch();
    }

    private void doSearch()
    {
        CCourse教師 l_ct = new CCourse教師();
        l_ct.Teacher = txtSearchCMT.Text;
        l_ct.CourseID = txtSearchCourseID.Text;
        CCourse l_course = new CCourse();
        l_course.CourseID = txtSearchCourseID.Text;
        CCourse[] l_courses = get課程Manager().課程代碼搜尋(l_course);
        CCourse教師[] l_cts = get課程講師Factory().課程講師搜尋(l_ct);
        if (l_cts != null)
        {
            GridView1.Visible = true;
            displayGridView(l_cts, l_courses);
        }
        else
        {
            GridView1.Visible = false;
            Response.Write("<script>alert('查無資料');</script>");
        }
    }
    private void displayGridView(CCourse教師[] p_cmt, CCourse[] p_course)
    {

        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("課程代碼"));
        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 < p_cmt.Length; i++)
        {
            DataRow l_row = l_table.NewRow();
            for (int j = 0; j < p_course.Length; j++)
            {
                if (p_course[j].CourseID.Equals(p_cmt[i].CourseID))
                {
                    l_row["課程名稱"] = p_course[j].CourseName;
                }
            }
            l_row["課程代碼"] = p_cmt[i].CourseID;
            l_row["課程講師"] = p_cmt[i].Teacher;
            l_row["專家"] = p_cmt[i].Expert;
            l_row["備註"] = p_cmt[i].TNote;
            l_row["建立者"] = p_cmt[i].Creator;
            l_table.Rows.Add(l_row);

        }

        GridView1.DataSource = l_table;
        GridView1.DataBind();

    }

    protected void btnBack_Click(object sender, EventArgs e)
    {
        Response.Redirect("WfrmCoursePage.aspx");
    }

    protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e)
    {
        if (!"編輯".Equals(e.Row.Cells[0].Text))
        {
            try
            {
                HyperLink l_link = new HyperLink();
                l_link.Text = "編輯";
                if (getFacade().目前使用者.USERNAME.Equals(e.Row.Cells[7].Text) || getFacade().目前使用者.USERNAME.Equals("sa"))
                {
                    l_link.NavigateUrl = "WfrmCourseTeacherEdit.aspx?CourseID=" + e.Row.Cells[3].Text + "&Teacher=" + Server.UrlEncode(e.Row.Cells[4].Text) + "";
                }
                else
                {
                    l_link.NavigateUrl = "WfrmMiddle.aspx?Middle=" + 3 + "&returnurl=" + Request.Url.ToString();
                }
                e.Row.Cells[1].Controls.Add(l_link);

                HyperLink l_link2 = new HyperLink();
                l_link2.Text = "刪除";
                if (getFacade().目前使用者.USERNAME.Equals(e.Row.Cells[7].Text) || getFacade().目前使用者.USERNAME.Equals("sa"))
                {
                    l_link2.NavigateUrl = "WfrmMiddle.aspx?CourseID=" + e.Row.Cells[3].Text + "&Teacher=" + Server.UrlEncode(e.Row.Cells[4].Text) + "&Middle=" + 2 + "&returnurl=" + Request.Url.ToString();
                }
                else
                {
                    l_link2.NavigateUrl = "WfrmMiddle.aspx?Middle=" + 3 + "&returnurl=" + Request.Url.ToString();
                }
                e.Row.Cells[0].Controls.Add(l_link2);
            }
            catch 
            { 
              
            }

        }
    }
    private CCFacade getFacade()
    {
        CCFacade l_facade = (CCFacade)Session["USER"];
        if (l_facade == null)
            Response.Redirect("WfrmLogeinPage.aspx");
        return l_facade;
    }



    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        doSearch();
    }
    protected void btnClear_Click(object sender, EventArgs e)
    {
        txtSearchCMT.Text = "";
        txtSearchCourseID.Text = "";
        GridView1.Visible = false;
    }
}