using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

namespace PWMS.ModuleClass
{
    class MyModule
    {
        #region  公共變量
        DataClass.MyMeans MyDataClass = new PWMS.DataClass.MyMeans();   //聲明MyMeans類的一個對象，以調(diào)用其方法
        public static string ADDs = "";  //用來存儲添加或修改的SQL語句
        public static string FindValue = "";  //存儲查詢條件
        public static string Address_ID = "";  //存儲通訊錄添加修改時的ID編號
        public static string User_ID = "";  //存儲用戶的ID編號
        public static string User_Name = "";    //存儲用戶名
        #endregion

        #region  窗體的調(diào)用
        /// <summary>
        /// 窗體的調(diào)用.
        /// </summary>
        /// <param name="FrmName">調(diào)用窗體的Text屬性值</param>
        /// <param name="n">標(biāo)識</param>
        public void Show_Form(string FrmName, int n)
        {
            if (n == 1)
            {
                if (FrmName == "人事檔案瀏覽")  //判斷當(dāng)前要打開的窗體
                {
                    PerForm.F_ManFile FrmManFile = new PWMS.PerForm.F_ManFile();
                    FrmManFile.Text = "人事檔案瀏覽";   //設(shè)置窗體名稱
                    FrmManFile.ShowDialog();    //顯示窗體
                    FrmManFile.Dispose();
                }
                if (FrmName == "人事資料查詢")
                {
                    PerForm.F_Find FrmFind = new PWMS.PerForm.F_Find();
                    FrmFind.Text = "人事資料查詢";
                    FrmFind.ShowDialog();
                    FrmFind.Dispose();
                }
                if (FrmName == "人事資料統(tǒng)計")
                {
                    PerForm.F_Stat FrmStat = new PWMS.PerForm.F_Stat();
                    FrmStat.Text = "人事資料統(tǒng)計";
                    FrmStat.ShowDialog();
                    FrmStat.Dispose();
                }
                if (FrmName == "員工生日提示")
                {
                    InfoAddForm.F_ClewSet FrmClewSet = new PWMS.InfoAddForm.F_ClewSet();
                    FrmClewSet.Text = "員工生日提示";   //設(shè)置窗體名稱
                    FrmClewSet.Tag = 1; //設(shè)置窗體的Tag屬性，用于在打開窗體時判斷窗體的顯示類形
                    FrmClewSet.ShowDialog();    //顯示窗體
                    FrmClewSet.Dispose();
                }
                if (FrmName == "員工合同提示")
                {
                    InfoAddForm.F_ClewSet FrmClewSet = new PWMS.InfoAddForm.F_ClewSet();
                    FrmClewSet.Text = "員工合同提示";
                    FrmClewSet.Tag = 2;
                    FrmClewSet.ShowDialog();
                    FrmClewSet.Dispose();
                }
                if (FrmName == "日常記事")
                {
                    PerForm.F_WordPad FrmWordPad = new PWMS.PerForm.F_WordPad();
                    FrmWordPad.Text = "日常記事";
                    FrmWordPad.ShowDialog();
                    FrmWordPad.Dispose();
                }
                if (FrmName == "通訊錄")
                {
                    PerForm.F_AddressList FrmAddressList = new PWMS.PerForm.F_AddressList();
                    FrmAddressList.Text = "通訊錄";
                    FrmAddressList.ShowDialog();
                    FrmAddressList.Dispose();
                }
                if (FrmName == "備份/還原數(shù)據(jù)庫")
                {
                    PerForm.F_HaveBack FrmHaveBack = new PWMS.PerForm.F_HaveBack();
                    FrmHaveBack.Text = "備份/還原數(shù)據(jù)庫";
                    FrmHaveBack.ShowDialog();
                    FrmHaveBack.Dispose();
                }
                if (FrmName == "清空數(shù)據(jù)庫")
                {
                    PerForm.F_ClearData FrmClearData = new PWMS.PerForm.F_ClearData();
                    FrmClearData.Text = "清空數(shù)據(jù)庫";
                    FrmClearData.ShowDialog();
                    FrmClearData.Dispose();
                }

                if (FrmName == "重新登錄")
                {
                    F_Login FrmLogin = new F_Login();
                    FrmLogin.Tag = 2;
                    FrmLogin.ShowDialog();
                    FrmLogin.Dispose();
                }
                if (FrmName == "用戶設(shè)置")
                {
                    PerForm.F_User FrmUser = new PWMS.PerForm.F_User();
                    FrmUser.Text = "用戶設(shè)置";
                    FrmUser.ShowDialog();
                    FrmUser.Dispose();
                }
                if (FrmName == "計算器")
                {
                    System.Diagnostics.Process.Start("calc.exe");
                }
                if (FrmName == "記事本")
                {
                    System.Diagnostics.Process.Start("notepad.exe");
                }
            }
            if (n == 2)
            {
                String FrmStr = ""; //記錄窗體名稱
                if (FrmName == "民族類別設(shè)置")  //判斷要打開的窗體
                {
                    DataClass.MyMeans.Mean_SQL = "select * from tb_Folk";   //SQL語句
                    DataClass.MyMeans.Mean_Table = "tb_Folk";   //表名
                    DataClass.MyMeans.Mean_Field = "FolkName";  //添加、修改數(shù)據(jù)的字段名
                    FrmStr = FrmName;
                }
                if (FrmName == "職工類別設(shè)置")
                {
                    DataClass.MyMeans.Mean_SQL = "select * from tb_EmployeeGenre";
                    DataClass.MyMeans.Mean_Table = "tb_EmployeeGenre";
                    DataClass.MyMeans.Mean_Field = "EmployeeName";
                    FrmStr = FrmName;
                }
                if (FrmName == "文化程度設(shè)置")
                {
                    DataClass.MyMeans.Mean_SQL = "select * from tb_Kultur";
                    DataClass.MyMeans.Mean_Table = "tb_Kultur";
                    DataClass.MyMeans.Mean_Field = "KulturName";
                    FrmStr = FrmName;
                }
                if (FrmName == "政治面貌設(shè)置")
                {
                    DataClass.MyMeans.Mean_SQL = "select * from tb_Visage";
                    DataClass.MyMeans.Mean_Table = "tb_Visage";
                    DataClass.MyMeans.Mean_Field = "VisageName";
                    FrmStr = FrmName;
                }
                if (FrmName == "部門類別設(shè)置")
                {
                    DataClass.MyMeans.Mean_SQL = "select * from tb_Branch";
                    DataClass.MyMeans.Mean_Table = "tb_Branch";
                    DataClass.MyMeans.Mean_Field = "BranchName";
                    FrmStr = FrmName;
                }
                if (FrmName == "工資類別設(shè)置")
                {
                    DataClass.MyMeans.Mean_SQL = "select * from tb_Laborage";
                    DataClass.MyMeans.Mean_Table = "tb_Laborage";
                    DataClass.MyMeans.Mean_Field = "LaborageName";
                    FrmStr = FrmName;
                }
                if (FrmName == "職務(wù)類別設(shè)置")
                {
                    DataClass.MyMeans.Mean_SQL = "select * from tb_Business";
                    DataClass.MyMeans.Mean_Table = "tb_Business";
                    DataClass.MyMeans.Mean_Field = "BusinessName";
                    FrmStr = FrmName;
                }
                if (FrmName == "職稱類別設(shè)置")
                {
                    DataClass.MyMeans.Mean_SQL = "select * from tb_Duthcall";
                    DataClass.MyMeans.Mean_Table = "tb_Duthcall";
                    DataClass.MyMeans.Mean_Field = "DuthcallName";
                    FrmStr = FrmName;
                }
                if (FrmName == "獎懲類別設(shè)置")
                {
                    DataClass.MyMeans.Mean_SQL = "select * from tb_RPKind";
                    DataClass.MyMeans.Mean_Table = "tb_RPKind";
                    DataClass.MyMeans.Mean_Field = "RPKind";
                    FrmStr = FrmName;
                }
                if (FrmName == "記事本類別設(shè)置")
                {
                    DataClass.MyMeans.Mean_SQL = "select * from tb_WordPad";
                    DataClass.MyMeans.Mean_Table = "tb_WordPad";
                    DataClass.MyMeans.Mean_Field = "WordPad";
                    FrmStr = FrmName;
                }
                InfoAddForm.F_Basic FrmBasic = new PWMS.InfoAddForm.F_Basic();
                FrmBasic.Text = FrmStr; //設(shè)置窗體名稱
                FrmBasic.ShowDialog();  //顯示調(diào)用的窗體
                FrmBasic.Dispose();
            }
        }
        #endregion

        #region  將StatusStrip控件中的信息添加到treeView控件中
        /// <summary>
        /// 讀取菜單中的信息.
        /// </summary>
        /// <param name="treeV">TreeView控件</param>
        /// <param name="MenuS">MenuStrip控件</param>
        public void GetMenu(TreeView treeV, MenuStrip MenuS)
        {
            for (int i = 0; i < MenuS.Items.Count; i++) //遍歷MenuStrip組件中的一級菜單項(xiàng)
            {
                //將一級菜單項(xiàng)的名稱添加到TreeView組件的根節(jié)點(diǎn)中，并設(shè)置當(dāng)前節(jié)點(diǎn)的子節(jié)點(diǎn)newNode1
                TreeNode newNode1 = treeV.Nodes.Add(MenuS.Items[i].Text);
                //將當(dāng)前菜單項(xiàng)的所有相關(guān)信息存入到ToolStripDropDownItem對象中
                ToolStripDropDownItem newmenu = (ToolStripDropDownItem)MenuS.Items[i];
                //判斷當(dāng)前菜單項(xiàng)中是否有二級菜單項(xiàng)
                if (newmenu.HasDropDownItems && newmenu.DropDownItems.Count > 0)
                    for (int j = 0; j < newmenu.DropDownItems.Count; j++)    //遍歷二級菜單項(xiàng)
                    {
                        //將二級菜單名稱添加到TreeView組件的子節(jié)點(diǎn)newNode1中，并設(shè)置當(dāng)前節(jié)點(diǎn)的子節(jié)點(diǎn)newNode2
                        TreeNode newNode2 = newNode1.Nodes.Add(newmenu.DropDownItems[j].Text);
                        //將當(dāng)前菜單項(xiàng)的所有相關(guān)信息存入到ToolStripDropDownItem對象中
                        ToolStripDropDownItem newmenu2 = (ToolStripDropDownItem)newmenu.DropDownItems[j];
                        //判斷二級菜單項(xiàng)中是否有三級菜單項(xiàng)
                        if (newmenu2.HasDropDownItems && newmenu2.DropDownItems.Count > 0)
                            for (int p = 0; p < newmenu2.DropDownItems.Count; p++)    //遍歷三級菜單項(xiàng)
                                //將三級菜單名稱添加到TreeView組件的子節(jié)點(diǎn)newNode2中
                                newNode2.Nodes.Add(newmenu2.DropDownItems[p].Text);
                    }
            }
        }
        #endregion

        #region  自動編號
        /// <summary>
        /// 在添加信息時自動計算編號.
        /// </summary>
        /// <param name="TableName">表名</param>
        /// <param name="ID">字段名</param>
        /// <returns>返回String對象</returns>
        public String GetAutocoding(string TableName, string ID)
        {
            //查找指定表中ID號為最大的記錄
            SqlDataReader MyDR = MyDataClass.getcom("select max(" + ID + ") NID from " + TableName);
            int Num = 0;
            if (MyDR.HasRows)   //當(dāng)查找到記錄時
            {
                MyDR.Read();    //讀取當(dāng)前記錄
                if (MyDR[0].ToString() == "")
                    return "0001";
                Num = Convert.ToInt32(MyDR[0].ToString());  //將當(dāng)前找到的最大編號轉(zhuǎn)換成整數(shù)
                ++Num;  //最大編號加1
                string s = string.Format("{0:0000}", Num);  //將整數(shù)值轉(zhuǎn)換成指定格式的字符串
                return s;   //返回自動生成的編號
            }
            else
            {
                return "0001";  //當(dāng)數(shù)據(jù)表沒有記錄時，返回0001
            }