?using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace EquipmentMS
{
    public partial class frmMain : Form
    {
        BaseClass.Operation oper = new BaseClass.Operation();
        public frmMain()
        {
            InitializeComponent();
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            staDataTime.Text = DateTime.Now.ToString();
        }

        private void tlbtnExit_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("請確認退出！","系統提示",MessageBoxButtons.YesNo,MessageBoxIcon.Information,MessageBoxDefaultButton.Button1) == DialogResult.Yes)
                Application.Exit();
        }

        private void DataBindGridViewList()
        {
            DataSet P_dsDataGridView = null;
            DataSet P_dsZC = null;

            P_dsDataGridView = oper.GetDataGridViewList();
            P_dsZC = oper.GetDataSetZC();

            dgvEquipmentList.DataSource = P_dsZC.Tables[0].DefaultView;

            for (int j = 0; j < P_dsZC.Tables[0].Columns.Count; j++)
            {
                for (int i = 1; i < P_dsDataGridView.Tables[0].Rows.Count; i++)
                    if (P_dsDataGridView.Tables[0].Rows[i]["filedName"].ToString() == P_dsZC.Tables[0].Columns[j].ColumnName)
                    {
                        dgvEquipmentList.Columns[i].HeaderText = P_dsDataGridView.Tables[0].Rows[i - 1]["title"].ToString();
                        dgvEquipmentList.Columns[i+1].Width = Convert.ToInt16(P_dsDataGridView.Tables[0].Rows[i]["width"].ToString());
                        dgvEquipmentList.Columns[i+1].Visible = Convert.ToBoolean(P_dsDataGridView.Tables[0].Rows[i]["visible"].ToString());
                    }
            }
            dgvEquipmentList.Columns[P_dsZC.Tables[0].Columns.Count - 1].HeaderText = P_dsDataGridView.Tables[0].Rows[P_dsDataGridView.Tables[0].Rows.Count - 1]["title"].ToString();
            dgvEquipmentList.Columns[P_dsZC.Tables[0].Columns.Count - 1].Width = Convert.ToInt16(P_dsDataGridView.Tables[0].Rows[P_dsDataGridView.Tables[0].Rows.Count - 1]["width"].ToString());
            dgvEquipmentList.Columns[P_dsZC.Tables[0].Columns.Count - 1].Visible = Convert.ToBoolean(P_dsDataGridView.Tables[0].Rows[P_dsDataGridView.Tables[0].Rows.Count - 1]["visible"].ToString());
            dgvEquipmentList.Columns[0].Visible = false;
        }
        private void SetUnits()
        {
            DataSet ds = oper.GetDataSetUnits();
            staUnits.Text = ds.Tables[0].Rows[0]["units"].ToString();
            staAddress.Text = ds.Tables[0].Rows[0]["address"].ToString();

        }
        private void frmMain_Load(object sender, EventArgs e)
        {
            this.SetUnits();

            this.DataBindGridViewList();

            this.SetTreeView();
        }
        private void SetTreeView()
        {
            trvFile.Nodes.Clear();
            //設置TreeView控件的菜單項
            DataSet ds = null;
            ds = oper.TreeFill();
            TreeNode RootNode = null;
            TreeNode chileNode = null;
            DataTable dt = ds.Tables[0].Copy();     //將資產列表另存一份為dt
            DataView dv = new DataView(dt);
            dv.RowFilter = "firstID = -1";
            //將數據集中的所有記錄逐個根據他們之間的關系添加到樹形表中去
            if (dv.Count > 0)
            {
                foreach (DataRowView myRow in dv)
                {
                    //設置根節點,然后該函數會遞歸添加所有子節點。
                    trvFile.Nodes.Add(RootNode = new TreeNode(myRow["zclb"].ToString()));
                    childTreeView(myRow["zclb"].ToString(), trvFile.Nodes[0], myRow);
                    trvFile.SelectedNode = trvFile.Nodes[0]; //選中第一個節點 
                }
            }
            //展開節點
            trvFile.ExpandAll();
            //填充－－增加方式
            chileNode = RootNode.Nodes.Add("增加方式", "增加方式", 1);
            for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
            {
                chileNode.Nodes.Add("", ds.Tables[1].Rows[i]["zjfs"].ToString(), 2);
            }
            //填充－－使用部門
            chileNode = RootNode.Nodes.Add("使用部門", "使用部門", 1);
            for (int i = 0; i < ds.Tables[2].Rows.Count; i++)
            {
                chileNode.Nodes.Add("", ds.Tables[2].Rows[i]["sybm"].ToString(), 2);
            }
            //填充－－使用情況
            chileNode = RootNode.Nodes.Add("使用情況", "使用情況", 1);
            for (int i = 0; i < ds.Tables[3].Rows.Count; i++)
            {
                chileNode.Nodes.Add("", ds.Tables[3].Rows[i]["syqk"].ToString(), 2);
            }
            //填充－－存放地點
            chileNode = RootNode.Nodes.Add("存放地點", "存放地點", 1);
            for (int i = 0; i < ds.Tables[4].Rows.Count; i++)
            {
                chileNode.Nodes.Add("", ds.Tables[4].Rows[i]["cfdd"].ToString(), 2);
            }
            //填充－－保管人員
            chileNode = RootNode.Nodes.Add("保管人員", "保管人員", 1);
            for (int i = 0; i < ds.Tables[5].Rows.Count; i++)
            {
                chileNode.Nodes.Add("", ds.Tables[5].Rows[i]["bgry"].ToString(), 2);
            }
        }
        private void childTreeView(string childPart, TreeNode childNode, DataRowView childRow)
        {
            string strdeptName = "";
            DataSet ds = null;
            ds = oper.TreeFill();
            DataTable dt = ds.Tables[0].Copy();
            DataView dv = new DataView(dt);
            //篩選獲得當前傳遞過來的節點的子項，并將其添加到樹形圖中
            //判斷方法是凡parentIndex等于傳遞過來的節點的absIndex的，就是該節點的子項
            dv.RowFilter = "firstID = '" + childRow["secondID"].ToString() + "'";
            //遞歸的添加每一個節點的所有子節點
            foreach (DataRowView myRow in dv)
            {
                strdeptName = myRow["zclb"].ToString();
                TreeNode myNode = new TreeNode(strdeptName);
                childNode.Nodes.Add(myNode);
                //函數遞歸調用，將所有節點按順序添加完畢
                childTreeView(strdeptName, myNode, myRow);
            }
        }

        private void toolStripTextBox1_Click(object sender, EventArgs e)
        {
            new EquipmentMS.BaseInfo.frmBaseSort().Show();
        }

        private void toolStripMenuItem3_Click(object sender, EventArgs e)
        {
            new EquipmentMS.BaseInfo.frmBaseInfo().Show();
        }

        private void toolStripButton4_Click(object sender, EventArgs e)
        {
            toolStripMenuItem3_Click(sender, e);
        }

        private void toolStripButton11_Click(object sender, EventArgs e)
        {
            toolStripTextBox1_Click(sender, e);
        }

        private void toolStripMenuItem4_Click(object sender, EventArgs e)
        {
            new EquipmentMS.BaseInfo.frmBaseNumber().Show();
        }

        private void toolStripMenuItem11_Click(object sender, EventArgs e)
        {
            new EquipmentMS.Equipment.frmEquipmentInsert().Show();
        }

        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            toolStripMenuItem11_Click(sender, e);
        }

        private void toolStripButton2_Click(object sender, EventArgs e)
        {
            toolStripMenuItem12_Click(sender, e);
        }

        private void toolStripMenuItem12_Click(object sender, EventArgs e)
        {
            if (dgvEquipmentList.RowCount > 1)
            {
                EquipmentMS.Equipment.frmEquipmentUpdate frmEUpdate = new EquipmentMS.Equipment.frmEquipmentUpdate();
                frmEUpdate.M_frmMain = this;
                frmEUpdate.M_str_BH = dgvEquipmentList.SelectedCells[1].Value.ToString();
                frmEUpdate.Show();
            }
        }

        private void toolStripButton10_Click(object sender, EventArgs e)
        {
            this.DataBindGridViewList();
        }

        private void toolStripMenuItem13_Click(object sender, EventArgs e)
        {
            if (dgvEquipmentList.RowCount > 1)
            {
                if (MessageBox.Show("是否刪除當前行數據!", "系統提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)