wfrmcoursepage.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 void 設定只能讀取(Boolean isReadOnly)
    {
    }
    private String getMode()
    {
        if (Session["Course"] == null)
            return "0";
        return Session["Course"].ToString();
    }
    private void 設定按鍵啟用(Boolean isButtonEnable)
    {
        
    }

    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();

        if (Page.IsPostBack)
        {
            dosearch();
        }
        
        this.設定只能讀取(true);
       

        Label1.Text = getFacade().目前使用者.USERNAME + "你好";
    }

    private void displayTableWithHtml(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("建立者"));

        for (int i = 0; i < p_course.Length; i++)
        {
            DataRow l_row = l_table.NewRow();
            l_row["課程碼"] = p_course[i].CID;
            l_row["課程代號"] = p_course[i].CourseID;
            l_row["課程名稱"] = p_course[i].CourseName;
            l_row["註記"] = p_course[i].Note;
            l_row["建立者"] = p_course[i].Creator;

            l_table.Rows.Add(l_row);
        }

        /// <summary>
        /// 姓名:趙璿涵
        /// 日期:03-04-2239
        /// 新增功能:以HTML方式顯示表格
        /// </summary>
        //Response.Write("<form1>");
        //Response.Write("<table border='3' AllowPaging='true'>");
        //Response.Write("<tr>");
        //Response.Write("<td>課程碼</td><td>課程代號</td><td>課程名稱</td><td>註解</td></tr>");
        //for (int i = 0; i < p_course.Length; i++)
        //{
        //    Response.Write("<td>" + p_course[i].CID + "</td><td>" + p_course[i].CourseID + "</td><td>" + p_course[i].CourseName + "</td><td>" + p_course[i].fNote + "</td></tr>");
        //}

        //Response.Write("</table>");
        //Response.Write("</form1>");



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

    private void display(CCourse p_course)
    {
       
        ListItem l = new ListItem();
        l.Text = p_course.fStyle;


    }
    public C課程Manager get課程Manager()
    {

        if (Session["課程Manager"] == null)
        {
            Session["課程Manager"] = new C課程Manager();
        }
        ((C課程Manager)Session["課程Manager"]).iv_action += this.display;

        return (C課程Manager)Session["課程Manager"];
    }
    private CCourseFactory iv_courseFactory;

    public CCourseFactory getCourseFactory()
    {
        if (iv_courseFactory == null)
        {
            string l_conn = (string)Session["DbManager"];
            iv_courseFactory = new CCourseFactory(l_conn);
        }
        return iv_courseFactory;
    }

    private void txtClear()
    {
        txtSearchCourseName.Text = "";
        txtSearchCID.Text = "";
    }

    
   
    /// <summary>
    /// 姓名:趙璿涵
    /// 日期:03-04-2124
    /// 新增功能:顯示清單
    /// </summary>

    protected void btnShowAll_Click(object sender, EventArgs e)
    {
        CCourse l_course = new CCourse();
        l_course.CID = "";
        l_course.CourseName = "";
        displayTableWithHtml(get課程Manager().多功能課程搜尋(l_course));
    }
    protected void btnSearch_Click1(object sender, EventArgs e)
    {
        dosearch();
    }
    protected void btnClear_Click1(object sender, EventArgs e)
    {
        this.txtClear();
    }
    protected void btnCT_Click(object sender, EventArgs e)
    {
        Response.Redirect("WfrmCourseTeacher.aspx");
    }
   
    
    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Redirect("WfrmCourseMaterial.aspx");
    }
    
    
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        dosearch();


    }
    private CCFacade getFacade()
    {
        CCFacade l_facade = (CCFacade)Session["USER"];
        if (l_facade == null)
            Response.Redirect("WfrmLogeinPage.aspx");
        return l_facade;
    }
    private void dosearch()
    {
        
        CCourse l_course = new CCourse();
        l_course.CID = txtSearchCID.Text;
        l_course.CourseName = txtSearchCourseName.Text;
        CCourse[] l_courses = get課程Manager().多功能課程搜尋(l_course);

        if (l_courses != null)
        {
            Session["課程Manager"] = null;            
            get課程Manager().loadData(l_courses);           
             display(l_courses[0]);
            
            displayTableWithHtml(l_courses);
           
            
            
        }
        else
        {
            Response.Write("<script>alert('查無資料');</script>");
        }
    }
    protected void GridView1_RowDataBound(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[6].Text) || getFacade().目前使用者.USERNAME.Equals("sa"))
                {
                    l_link.NavigateUrl = "WfrmCourseEdit.aspx?CID=" + e.Row.Cells[2].Text + "";
                }
                else
                {
                    l_link.NavigateUrl = "WfrmMiddle.aspx?Middle=" + 3 + "&returnurl=" + Request.Url.ToString();

                }
                e.Row.Cells[0].Controls.Add(l_link);

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


            }

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