wfrmteacherpage.aspx.cs

Teacher Manager System

    }
    private void display(CTeacher p_teacher)
    {

        txtTeacherId.Text = p_teacher.TeacherID;
        txtIdCardNo.Text = p_teacher.IdCardNo;
        txtName.Text = p_teacher.Name;
        DropDownList1.SelectedValue = p_teacher.Sex;
        txtTitle.Text = p_teacher.Title;
        txtOZip.Text = p_teacher.OZip;
        txtOPhone.Text = p_teacher.OPhone;
        txtOFax.Text = p_teacher.OFax;
        txtOAddr.Text = p_teacher.OAddr;
        txtKeyinTime.Text = p_teacher.KeyinTime;
        txtHZip.Text = p_teacher.HZip;
        txtHphone.Text = p_teacher.HPhone;
        txtHFax.Text = p_teacher.HFax;
        txtHAddr.Text = p_teacher.HAddr;
        txtCreator.Text = p_teacher.Creator;
        txtBirthDate.Text = p_teacher.BirthDate;
        txtComments.Text = p_teacher.Comments;
        txtCompanyName.Text = p_teacher.CompanyName;
        txtDegree.Text = p_teacher.Degree;
        txtDeptName.Text = p_teacher.DeptName;
        txtEmail.Text = p_teacher.Email;
        txtMphone.Text = p_teacher.MPhone;

        Session["CurrentTeacher"] = p_teacher;

    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        getCTManager().moveFirst();
        panelShowOpen();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        getCTManager().movePrevious();
        panelShowOpen();
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        getCTManager().moveNext();
        panelShowOpen();
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        getCTManager().moveLast();
        panelShowOpen();
    }
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        if (getFacade().目前使用者.USERNAME.Equals(getCTManager().get目前教師().Creator) || getFacade().目前使用者.USERNAME.Equals("sa"))
        {
            C專長Factory l_專長Factory = new C專長Factory(Session["DbManager"].ToString());
            C專長[] l_專長s = l_專長Factory.queryByTeacherID(txtTeacherId.Text);

            if (l_專長s.Length != 0)
            {
                foreach (C專長 c in l_專長s)
                {
                    l_專長Factory.delete(c);
                }
            }
            getTeacherFactory().Delete(getCTManager().get目前教師());
            getCTManager().loadData(getTeacherFactory().getAll());
            getCTManager().movePrevious();
            display(getCTManager().get目前教師());
        }
        else
        {
            Response.Write("<script>alert('抱歉你無法刪除');</script>");
        }
    }


    protected void Button2_Click1(object sender, EventArgs e)
    {
        displayclear();
    }




    ///姓名:趙璿涵
    ///修改:查詢功能-(使用C查詢完成)
    ///日期:03-05-1445
    ///
    protected void btnSelect_Click(object sender, EventArgs e)
    {
        search();
    }

    private void search()
    {
        CTeacher l_teacher = new CTeacher();
        l_teacher.TeacherID = txtTeacherIdSelect.Text;
        l_teacher.Name = txtTeacherNameSelect.Text;
        CTeacher[] l_teachers = getCTManager().多功能搜尋(l_teacher);
        if (l_teachers != null)
        {
            Session["教師Manager"] = null;
            getCTManager().loadData(l_teachers);
            display(l_teachers[0]);
            displayImportGridView(l_teachers);
        }
        else
        {
            Response.Write("<script>alert('查無資料');</script>");
        }
    }

    /// <summary>
    /// 姓名:趙璿涵
    /// 日期:02-27-1427
    /// 新增功能:瀏覽測試
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>

    /// <summary>
    /// 姓名:趙璿涵
    /// 日期:02-28-1146
    /// 新增功能:瀏覽測試   SQL   刪除
    ///          修改為切換頁面至   "瀏覽專長跳出視窗"
    /// </summary>


    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //CheckBox x = new CheckBox();
        //e.Row.Cells[0].Controls.Add(x);
    }
    protected void btn觀看清單_Click(object sender, EventArgs e)
    {
        //CTeacher l_teacher = new CTeacher();
        //l_teacher.TeacherID = "";
        //l_teacher.Name = "";
        //l_teacher.Title = "";
        //displayImportGridView(getCTManager().多功能搜尋(l_teacher));
        panelShowOpen();
        
    }
    protected void btn移動GridVIew_Click(object sender, EventArgs e)
    {
        //WebPartManager1.DisplayMode = WebPartManager.DesignDisplayMode;
    }
    protected void btnShowAllTeacherData_Click(object sender, EventArgs e)
    {
        CTeacher l_teacher = new CTeacher();
        l_teacher.TeacherID = "";
        l_teacher.Name = "";
        l_teacher.Title = "";
        displayGridView(getCTManager().多功能搜尋(l_teacher));

        //display(getCTManager().多功能搜尋(l_teacher)[0]);

    }

    /// <summary>
    /// 姓名:趙璿涵
    /// 日期:03-04-2016
    /// 新增功能:設定是否只能讀取
    ///          
    /// </summary>
    private void 設定只能讀取(Boolean isReadOnly)
    {
        txtTeacherId.ReadOnly = isReadOnly;
        txtIdCardNo.ReadOnly = isReadOnly;
        txtName.ReadOnly = isReadOnly;
        txtEmail.ReadOnly = isReadOnly;
        txtMphone.ReadOnly = isReadOnly;
        txtBirthDate.ReadOnly = isReadOnly;
        txtDegree.ReadOnly = isReadOnly;
        txtComments.ReadOnly = isReadOnly;
        txtHphone.ReadOnly = isReadOnly;
        txtHAddr.ReadOnly = isReadOnly;
        txtHZip.ReadOnly = isReadOnly;
        txtCompanyName.ReadOnly = isReadOnly;
        txtDeptName.ReadOnly = isReadOnly;
        txtTitle.ReadOnly = isReadOnly;
        txtOPhone.ReadOnly = isReadOnly;
        txtOFax.ReadOnly = isReadOnly;
        txtOAddr.ReadOnly = isReadOnly;
        txtOZip.ReadOnly = isReadOnly;
        txtKeyinTime.ReadOnly = isReadOnly;
        txtCreator.ReadOnly = isReadOnly;


    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        if (getFacade().目前使用者.USERNAME.Equals(getCTManager().get目前教師().Creator) || getFacade().目前使用者.USERNAME.Equals("sa"))
        {
            
            if ("編輯".Equals(btnUpdate.Text))
            {
                btnUpdate.Text = "取消";
                panelShowOpen();
                this.設定只能讀取(false);
                txtTeacherId.ReadOnly = true;
                this.設定按鍵啟用(false);
                btnAdd.Enabled = false;
                btnOK.Enabled = true;
                
            }
            else
            {
                panelShowClose();
                btnUpdate.Text = "編輯";
                display(getCTManager().get目前教師());
                this.設定只能讀取(true);
                this.設定按鍵啟用(true);
                btnAdd.Enabled = true;
                btnOK.Enabled = false;
                panelShowOpen();
            }
        }
        else
        {
            Response.Write("<script>alert('抱歉你無法修改');</script>");
        }

    }
    /// <summary>
    /// 姓名:趙璿涵
    /// 日期:03-06-0059 
    /// 新增功能:getWfrmUpdate
    ///          
    /// </summary>
    private void getWfrmUpdate()
    {
        getCTManager().loadData(getTeacherFactory().getAll());
    }
    /// <summary>
    /// 姓名:趙璿涵
    /// 日期:03-06-0059 
    /// 新增功能:確認按鈕
    ///          
    /// </summary>
    protected void btnOK_Click(object sender, EventArgs e)
    {
        CTeacher l_teacher = getTeacherFactory().queryById(txtTeacherId.Text);
        //CTeacher[] l_teachers = getCTManager().多功能搜尋(l_teacher);
        if (l_teacher != null)
        {
            l_teacher.IdCardNo = txtIdCardNo.Text;
            l_teacher.Name = txtName.Text;
            l_teacher.Sex = DropDownList1.SelectedValue;
            l_teacher.Title = txtTitle.Text;
            l_teacher.OZip = txtOZip.Text;
            l_teacher.OPhone = txtOPhone.Text;
            l_teacher.OFax = txtOFax.Text;
            l_teacher.OAddr = txtOAddr.Text;
            l_teacher.KeyinTime = txtKeyinTime.Text;
            l_teacher.HZip = txtHZip.Text;
            l_teacher.HPhone = txtHphone.Text;
            l_teacher.HFax = txtHFax.Text;
            l_teacher.HAddr = txtHAddr.Text;
            l_teacher.Creator = txtCreator.Text;
            l_teacher.BirthDate = txtBirthDate.Text;
            l_teacher.Comments = txtComments.Text;
            l_teacher.CompanyName = txtCompanyName.Text;
            l_teacher.Degree = txtDegree.Text;
            l_teacher.DeptName = txtDeptName.Text;
            l_teacher.Email = txtEmail.Text;
            l_teacher.MPhone = txtMphone.Text;
            getTeacherFactory().Update(l_teacher);
            getCTManager().loadData(getTeacherFactory().getAll());
            getCTManager().get目前教師();
            btnUpdate.Text = "編輯";
        }
        else
        {
            
            l_teacher = new CTeacher();
            l_teacher.TeacherID = txtTeacherId.Text;
            l_teacher.IdCardNo = txtIdCardNo.Text;
            l_teacher.Name = txtName.Text;
            l_teacher.Sex = DropDownList1.SelectedValue;
            l_teacher.Title = txtTitle.Text;
            l_teacher.OZip = txtOZip.Text;
            l_teacher.OPhone = txtOPhone.Text;
            l_teacher.OFax = txtOFax.Text;
            l_teacher.OAddr = txtOAddr.Text;
            l_teacher.KeyinTime = txtKeyinTime.Text;
            l_teacher.HZip = txtHZip.Text;
            l_teacher.HPhone = txtHphone.Text;
            l_teacher.HFax = txtHFax.Text;
            l_teacher.HAddr = txtHAddr.Text;
            l_teacher.Creator = txtCreator.Text;
            l_teacher.BirthDate = txtBirthDate.Text;
            l_teacher.Comments = txtComments.Text;
            l_teacher.CompanyName = txtCompanyName.Text;
            l_teacher.Degree = txtDegree.Text;
            l_teacher.DeptName = txtDeptName.Text;
            l_teacher.Email = txtEmail.Text;
            l_teacher.MPhone = txtMphone.Text;
            getTeacherFactory().Update(l_teacher);
            getCTManager().loadData(getTeacherFactory().getAll());
            getCTManager().moveLast();
            btnAdd.Text = "新增";
        }
        //getWfrmUpdate();
        this.設定只能讀取(true);
        this.設定按鍵啟用(true);
        btnUpdate.Enabled = true;
        btnAdd.Enabled = true;
        panelShowClose();
        search();

        //displayImportGridView(l_teacher);
        

    }
    protected void GridViewShowSome_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridViewShowSome.PageIndex = e.NewPageIndex;
        search();
        
        
    }
    private CCFacade getFacade()
    {
        CCFacade l_facade = (CCFacade)Session["USER"];
        if (l_facade == null)
            Response.Redirect("WfrmLogeinPage.aspx");
        return l_facade;
    }
    protected void GridViewShowSome_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[2].Text) || getFacade().目前使用者.USERNAME.Equals("sa"))
                {
                    l_link.NavigateUrl = "WfrmTeacherList.aspx?TeacherID=" + e.Row.Cells[2].Text + "";
                }
                else
                {
                    l_link.NavigateUrl = "WfrmTeacherMiddle.aspx?TeacherMiddle=" + 2 + "&returnTeacherPage=" + 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[6].Text) || getFacade().目前使用者.USERNAME.Equals("sa"))
                {
                    l_link2.NavigateUrl = "WfrmTeacherMiddle.aspx?TeacherID=" + e.Row.Cells[2].Text + "&returnTeacherPage=" + Request.Url.ToString() + "&TeacherMiddle=" + 1 + "";
                }
                else
                {
                    l_link2.NavigateUrl = "WfrmTeacherMiddle.aspx?TeacherMiddle=" + 2 + "&returnTeacherPage=" + Request.Url.ToString();
                }
                e.Row.Cells[1].Controls.Add(l_link2);
            }
            catch
            { 
            
            
            }
        }
    }
}