wfrmteacherpage.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;
using System.Data.OleDb;
using tw.org.iii.crm.data;
using System.Data.SqlClient;


///日期:03-04-2101     391行---新增:isReadOnly
///日期:03-05-0127     72行---新增:Session(問題很多)
///日期:03-05-0129     120行---修改:設定參數(問題很多)
///日期:03-05-0131     359行---修改:查詢功能
///日期:03-06-0101     442行---修改:getWfrmUpdate
///日期:03-06-0101     452行---修改:查詢功能
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
            
            Response.Write("<script type='text/javascript'>");
            Response.Write("function wopen1(){");
            Response.Write("var WO1; WO1=window.open(''");
            Response.Write(",");
            Response.Write("'WindowOpen1'");
            Response.Write(",");
            Response.Write("'toolbar=yes");
            Response.Write(",");
            Response.Write("location=yes");
            Response.Write(",");
            Response.Write("directories=yes");
            Response.Write(",");
            Response.Write("status=yes");
            Response.Write("");
            Response.Write(",");
            Response.Write("menubar=yes");
            Response.Write(",");
            Response.Write("scrollbars=yes");
            Response.Write(",");
            Response.Write("resizable=yes');");
            Response.Write("WO1.location.href='瀏覽老師專長視窗.aspx' }");

            Response.Write("function wopen2(){");
            Response.Write("var WO2; WO2=window.open(''");
            Response.Write(",");
            Response.Write("'WindowOpen2'");
            Response.Write(",");
            Response.Write("'toolbar=yes");
            Response.Write(",");
            Response.Write("location=yes");
            Response.Write(",");
            Response.Write("directories=yes");
            Response.Write(",");
            Response.Write("status=yes");
            Response.Write("");
            Response.Write(",");
            Response.Write("menubar=yes");
            Response.Write(",");
            Response.Write("scrollbars=yes");
            Response.Write(",");
            Response.Write("resizable=yes');");
            Response.Write("WO2.location.href='WfrmTeacherList.aspx' }");

            Response.Write("</script>");

            string l_str = "<input type='button' value='專長瀏覽' onClick='wopen1()'/>";
            Literal1.Text = l_str;
        //if(!Page.IsPostBack)
        //{
            string l_strId = Request["TeacherID"];
            this.設定只能讀取(true);
            panelShowClose();
            btnOK.Enabled = false;
            Label1.Text = getFacade().目前使用者.USERNAME + "你好";
            if (!Page.IsPostBack && getMode().Equals("編輯"))
            {
                search();
            }
            if (!Page.IsPostBack && getMode().Equals("刪除"))
            {
                search();
            }
            
            
        //}
    }
    private string getMode()
    {
        if (Session["Teacher"] == null)
        {
            return "0";
        }
        return Session["Teacher"].ToString();
    }

    private void panelShowOpen()
    {
        Panel住家資料.Visible = true;
        Panel建檔資料.Visible = true;
        Panel教師基本資料.Visible = true;
        Panel辦公室資料.Visible = true;
        PanelContrl.Visible = true;
        Panel1.Visible = false;
    }
    private void panelShowClose()
    {
        Panel住家資料.Visible = false;
        Panel建檔資料.Visible = false;
        Panel教師基本資料.Visible = false;
        Panel辦公室資料.Visible = false;
        PanelContrl.Visible = false;
        Panel1.Visible = true;
    }
    private void 設定按鍵啟用(Boolean isButtonEnable)
    {
        foreach (Control c in PanelContrl.Controls)
        {
            if (c is Button)
            {
                Button t = (Button)c;
                if (t.ID.Equals(btnOK.ID))
                    continue;
                if (t.ID.Equals(btnAdd.ID))
                    continue;
                if (t.ID.Equals(btnUpdate.ID))
                    continue;
                t.Enabled = isButtonEnable;
            }

        }
        foreach (Control c in Panel教師查詢.Controls)
        {
            if (c is Button)
            {
                ((Button)c).Enabled = isButtonEnable;
            }
        }
    }
    private void displayclear()
    {
        //txtBirthDate.Text = "";
        //txtComments.Text = "";
        //txtCompanyName.Text = "";
        //txtCreator.Text = "";
        //txtDegree.Text = "";
        //txtDeptName.Text = "";
        //txtEmail.Text = "";
        //txtHAddr.Text = "";
        //txtHFax.Text = "";
        //txtHphone.Text = "";
        //txtHZip.Text = "";
        //txtIdCardNo.Text = "";
        //txtKeyinTime.Text = "";
        //txtMphone.Text = "";
        //txtName.Text = "";
        //txtOAddr.Text = "";
        //txtOFax.Text = "";
        //txtOPhone.Text = "";
        //txtOZip.Text = "";

        //txtTeacherId.Text = "";
        //txtTitle.Text = "";
        txtTeacherIdSelect.Text = "";
        txtTeacherNameSelect.Text = "";
        Panel1.Visible = false;
    }

    /// <summary>
    /// 姓名:趙璿涵
    /// 新增:getTeacherFactory
    /// 日期:03-06-0051
    /// </summary>
    /// 
    private CTeacherFactory iv_teacherFactory;
    public CTeacherFactory getTeacherFactory()
    {
        if (iv_teacherFactory == null)
        {
            iv_teacherFactory = new CTeacherFactory(Session["DbManager"].ToString());
        }
        return iv_teacherFactory;
    }

    /// <summary>
    /// 姓名:趙璿涵
    /// 新增:Session  這部分問題很大
    /// 日期:03-05-0127
    /// </summary>
    public CTeacherManager getCTManager()
    {

        if (Session["教師Manager"] == null)
        {
            Session["教師Manager"] = new CTeacherManager();


        }
        ((CTeacherManager)Session["教師Manager"]).iv_action += this.display;
        return (CTeacherManager)Session["教師Manager"];
    }



    /// <summary>
    /// 姓名:趙璿涵
    /// 修改:設定參數(有問題須再改)
    /// 日期:03-05-0127
    /// </summary>
    private void displayImportGridView(CTeacher[] p_teacher)
    {
        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("職稱"));
        //l_table.Columns.Add(new DataColumn("公司電話"));
        //l_table.Columns.Add(new DataColumn("建檔時間"));
        l_table.Columns.Add(new DataColumn("建立者"));

        for (int i = 0; i < p_teacher.Length; i++)
        {
            DataRow l_row = l_table.NewRow();
            l_row["講師編號"] = p_teacher[i].TeacherID;
            l_row["姓名"] = p_teacher[i].Name;
            l_row["電子信箱"] = p_teacher[i].Email;
            l_row["手機號碼"] = p_teacher[i].MPhone;
            //l_row["學歷"] = p_teacher[i].Degree;
            //l_row["職稱"] = p_teacher[i].Title;
            //l_row["公司電話"] = p_teacher[i].OPhone;
            //l_row["建檔時間"] = p_teacher[i].KeyinTime;
            l_row["建立者"] = p_teacher[i].Creator;


            l_table.Rows.Add(l_row);
        }

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


    }

    /// <summary>
    /// 姓名:Aaron
    /// 增加:Show 所有教師基本資料到GridView
    /// 日期:02-28-1000
    /// </summary>
    private void displayGridView(CTeacher[] p_teacher)
    {
        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("學歷"));
        ////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("職稱"));
        //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_teacher.Length; i++)
        //{
        //    DataRow l_row = l_table.NewRow();
        //    l_row["講師編號"] = p_teacher[i].TeacherID;
        //    //l_row["身分證字號"] = p_teacher[i].IdCardNo;
        //    l_row["姓名"] = p_teacher[i].Name;
        //    l_row["電子信箱"] = p_teacher[i].Email;
        //    l_row["手機號碼"] = p_teacher[i].MPhone;
        //    //l_row["性別"] = p_teacher[i].Sex;
        //    //l_row["生日"] = p_teacher[i].BirthDate;
        //    //l_row["學歷"] = p_teacher[i].Degree;
        //    //l_row["註解"] = p_teacher[i].Comments;
        //    l_row["住家電話"] = p_teacher[i].HPhone;
        //    //l_row["住家傳真"] = p_teacher[i].HFax;
        //    //l_row["地址"] = p_teacher[i].HAddr;
        //    //l_row["郵遞區號"] = p_teacher[i].HZip;
        //    //l_row["公司名稱"] = p_teacher[i].CompanyName;
        //    //l_row["所屬部門"] = p_teacher[i].DeptName;
        //    //l_row["職稱"] = p_teacher[i].Title;
        //    l_row["公司電話"] = p_teacher[i].OPhone;
        //    //l_row["公司傳真"] = p_teacher[i].OFax;
        //    //l_row["公司地址"] = p_teacher[i].OAddr;
        //    //l_row["公司區號"]=p_teacher[i].OZip;
        //    l_row["建檔時間"] = p_teacher[i].KeyinTime;
        //    l_row["建立者"] = p_teacher[i].Creator;

        //    l_table.Rows.Add(l_row);
        //}
        /// <summary>
        /// 姓名:趙璿涵
        /// 日期:03-04-2239
        /// 新增功能:以HTML方式顯示表格
        /// </summary>
        
        Response.Write("<form1>");
        Response.Write("<style>.ctl{table-layout:fixed}.ctl td{text-overflow:ellipsis;overflow:hidden;white-space: nowrap;padding:2px}</style>");
        Response.Write("<table cellSpacing='0' cellpadding='1' width='2100' class='ctl' border='1'>");
        Response.Write("<tr>");
        Response.Write("<td>講師編號</td><td width='100'>身分證字號</td><td width='70'>姓名</td><td width='150'>電子信箱</td><td width='100'>手機號碼</td><td width='40'>性別</td><td width='100'>生日</td><td>學歷</td><td>註解</td><td width='100'>住家電話</td><td width='100'>住家傳真</td><td width='200'>地址</td><td>郵遞區號</td><td>公司名稱</td><td>所屬部門</td><td>職稱</td><td width='100'>公司電話</td><td width='100'>公司傳真</td><td width='200'>公司地址</td><td>公司區號</td><td>建檔時間</td><td>建立者</td></tr>");
        for (int i = 0; i <p_teacher.Length; i++)
        {
            if (l_table != null)
            {
                Response.Write("<td>" + p_teacher[i].TeacherID + "</td><td>" + p_teacher[i].IdCardNo + "</td><td>" + p_teacher[i].Name + "</td><td>" + p_teacher[i].Email + "</td><td>" + p_teacher[i].MPhone + "</td><td>" + p_teacher[i].Sex + "</td><td>" + p_teacher[i].BirthDate + "</td><td>" + p_teacher[i].Degree + "</td><td>" + p_teacher[i].Comments + "</td><td>" + p_teacher[i].HPhone + "</td><td>" + p_teacher[i].HFax + "</td><td>" + p_teacher[i].HAddr + "</td><td>" + p_teacher[i].HZip + "</td><td>" + p_teacher[i].CompanyName + "</td><td>" + p_teacher[i].DeptName + "</td><td>" + p_teacher[i].Title + "</td><td>" + p_teacher[i].OPhone + "</td><td>" + p_teacher[i].OFax + "</td><td>" + p_teacher[i].OAddr + "</td><td>" + p_teacher[i].OZip + "</td><td>" + p_teacher[i].KeyinTime + "</td><td>" + p_teacher[i].Creator + "</td></tr>");
            }
            else
            {
                Response.Write("<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
            }

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

    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        this.設定只能讀取(false);
        this.設定按鍵啟用(false);
        if ("新增".Equals(btnAdd.Text))
        {
            
            txtCreator.ReadOnly = true;
            txtTeacherId.ReadOnly = true;
            txtKeyinTime.ReadOnly = true;
            panelShowOpen();
            btnOK.Enabled = true;
            btnAdd.Text = "取消";            
            display(getTeacherFactory().CreateTeacher());
            txtCreator.Text = getFacade().目前使用者.USERNAME;
            btnUpdate.Enabled = false;
        }
        else
        {
            panelShowClose();
            btnAdd.Text = "新增";
            this.設定只能讀取(true);
            this.設定按鍵啟用(true);
            display(getCTManager().get目前教師());
            btnUpdate.Enabled = true;

        }