using System;
using System.Data;
using System.Diagnostics;
using System.IO;
using System.Windows.Forms;
using Cyberpipe.DZ_Forms;

namespace Cyberpipe.GKT1_logicfile
{
    class GKT1_Affair
    {
        #region  公共变量
        // public Point CPoint;  //添加命名空间using System.Drawing;
        public static string BaseNode = "";//设录文件夹的根节点名称
        public string TempNode = "";//临时根节点名称
        public static int UserSign = 0;//用户的ID号
        //public static string IfSign = "";//查找当前用户的条件
        public static int Fclass = 0;//窗体的类型:1为复制，2为删
        public static string Redact_T = "";
        public static string Redact_N = "";  //treeview接点的名称
        public static string Redact_M = "";
        public static string Redact_D = "";
        public static ListView ADD_LV = new ListView();
        #endregion

        #region  窗体设置
        /// <summary>
        /// 窗体设置
        /// </summary>
        /// <param Frm="Form">窗体</param>
        public void FrmSetUp(Form Frm)  //Form或MouseEventArgs添加命名空间using System.Windows.Forms;
        {
            //Frm.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;//去掉窗体的边框
            Frm.StartPosition = FormStartPosition.CenterScreen;//使窗体居中

        }
        #endregion

        #region  向资料集中的添加名称
        /// <summary>
        /// 向资料集中的添加名称
        /// </summary>
        /// <param LV="ListView">ListView控件</param>
        /// <param DS="DataSet">返回查找的数据集</param>
        public void Data_List(ListView LV, DataSet DS)  //Form或MouseEventArgs添加命名空间using System.Windows.Forms;
        {
            LV.Items.Clear();//清空所有项的集合
            LV.Columns.Clear();//清空所有列的集合
            LV.GridLines = true;//在各数据之间形成网格线
            LV.View = View.Details;//显示列名称
            LV.FullRowSelect = true;//在单击某项时，对其进行选中
            LV.Columns.Add("项目名称", LV.Parent.Width - 3, HorizontalAlignment.Center);//设置列标头的名称及大小
            //添加指定列的信息
            for (int i = 0; i < DS.Tables[0].Rows.Count; i++)
            {
                ListViewItem lvi = new ListViewItem(DS.Tables[0].Rows[i][0].ToString());//实例化一个项
                lvi.Tag = DS.Tables[0].Rows[i][1];
                LV.Items.Add(lvi);//添加列信息            
            }
        }
        #endregion

        #region  切换文件列表和资料集
        /// <summary>
        /// 切换文件列表和资料集
        /// </summary>
        /// <param LV="ListView">ListView控件</param>
        /// <param TV="TreeView">TreeView控件</param>
        /// <param TF="bool">用于判断显示指定的控件</param>
        public void TreeAndList(ListView LV, TreeView TV, bool TF)
        {
            LV.Dock = DockStyle.Fill;//使ListView控件最大化
            TV.Dock = DockStyle.Fill;//使TreeView控件最大化
            LV.Visible = TF;//是否显示ListView控件
            TV.Visible = !TF;//是否显示TreeView控件
            if (TF)//调用自定义方法Data_List获取资集中的名称，并显示在ListView控件中
            {
                Data_List(LV, OledbHelper.getDataSet("select NODENAME,NODEID,NODETYPE from casic_gkt1 where"
                    + " NODETYPE=2", "casic_gkt1"));
            }
        }
        #endregion

        #region  在文件列表中添加根节点
        /// <summary>
        /// 在文件列表中添加根节点
        /// </summary>
        /// <param TV="TreeView">TreeView控件</param>
        /// <param Nodename="string">要添加的根节点名称</param>
        public void ShowTree(TreeView TV, string Nodename)
        {
            TreeNode TNode = new TreeNode();
            if (BaseNode.Trim() != TempNode.Trim())//判断资料集文件名是否为当前根节点名称
            {
                TV.Nodes.Clear();//清空TreeView控件
                TNode = TV.Nodes.Add(Nodename);//向TreeView控件中添加根节点
                //在数据库中查找当前根节点的信息
                DataSet DSet = OledbHelper.getDataSet("select NODEID,NODEPID,NODENAME,NODETYPE from casic_gkt1"
                    + " where NODENAME='" + Nodename + "'", "casic_gkt1");
                TNode.Tag = DSet.Tables[0].Rows[0][0];//获取当前文件的主ID号
                TNode.ImageIndex = 0;//设置当前节点的图片
                TempNode = BaseNode.Trim();//将当前根节点的名称赋给临时变量
                ADD_NullTreeNode(TV, TNode, 0);//调用自定义方法ADD_NullTreeNode
            }
        }
        #endregion

        #region  添加子节点
        /// <summary>
        /// 添加子节点
        /// </summary>
        /// <param TV="TreeView">TreeView控件</param>
        /// <param ANode="TreeNode">当前节点</param>
        public void ADD_TreeNode(TreeView TV, TreeNode ANode)
        {
            //在数据库中查找当前节点下的所有子节点
            DataSet DSet = OledbHelper.getDataSet("select NODEID,NODEPID,NODENAME,NODETYPE from casic_gkt1 "
                + "where NODEPID=" + ANode.Tag, "casic_gkt1");
            if (DSet.Tables[0].Rows.Count > 0)//当查找的行数大于0时
            {
                ANode.Nodes.Clear();//清空当前节点下的所有子节点
                int TypeIn = 0;//定义一个局部变量，用于存放指定数据的辅ID号
                for (int i = 0; i < DSet.Tables[0].Rows.Count; i++)//遍历数据表中的所有数据
                {
                    TreeNode SonNode = new TreeNode(DSet.Tables[0].Rows[i][2].ToString());//实例化一个具有当前节点名称的节点
                    SonNode.Tag = DSet.Tables[0].Rows[i][0];//在该节点的Tag属性中存放当前信息的主ID号
                    TypeIn = int.Parse(DSet.Tables[0].Rows[i][3].ToString());//存放当前信息的类型
                    if (TypeIn == 0)//设置当前节点的图片
                        SonNode.ImageIndex = 2;
                    else
                        SonNode.ImageIndex = 0;
                    ANode.Nodes.Add(SonNode);//添加该节点
                    ADD_NullTreeNode(TV, SonNode, 1);//调用自定义方法ADD_NullTreeNode
                }
            }
            else
            {
                ANode.Nodes.Clear();//清空子节点
            }
        }
        #endregion

        #region  显示当前文件夹下的所有文件
        /// <summary>
        /// 显示当前文件夹下的所有文件
        /// </summary>
        /// <param MainID="int">当前项的主ID号</param>
        /// <param MainName="string">当前项的名称</param>
        /// <param LV="ListView">ListView控件</param>
        /// <param p="int">操作类型</param>
        public void Show_AllFile(int MainID, string MainName, ListView LV, int p)
        {
            DataSet DSet = new DataSet();//实例化一个DataSet对象
            string wdir = "";
            int ty = -1;
            DSet = OledbHelper.getDataSet("select NODEID,NODEPID,NODEPATH,NODETYPE from casic_gkt1 where "
                + " NODEID=" + MainID, "casic_gkt1");
            ty = int.Parse(DSet.Tables[0].Rows[0][3].ToString());
            wdir = DSet.Tables[0].Rows[0][2].ToString();

            if (ty == 0 && p == 2)
            {
                try
                {
                    Process.Start(wdir);
                }
                catch (Exception ex)
                {
                    MessageBox.Show("文件无法打开。");
                }
            }
            else
            {
                //在数据库中获取当前文件夹的信息
                DSet = OledbHelper.getDataSet("select NODEID,NODEPID,NODENAME,NODETYPE from casic_gkt1 "
                    + "where NODEPID=" + MainID, "casic_gkt1");
                if (DSet.Tables[0].Rows.Count > 0)//当数据表的行数大于0时
                {
                    LV.Items.Clear();//清空ListView控件
                    //当前文件夹下的子文件夹和文件添加到ListView控件中
                    for (int i = 0; i < DSet.Tables[0].Rows.Count; i++)
                    {
                        ListViewItem lvi = new ListViewItem(DSet.Tables[0].Rows[i][2].ToString());//实例化一个项
                        lvi.Tag = int.Parse(DSet.Tables[0].Rows[i][0].ToString());
                        if (int.Parse(DSet.Tables[0].Rows[i][3].ToString()) == 0)//设置各项的图片
                            lvi.ImageIndex = 2;
                        else
                            lvi.ImageIndex = 0;
                        LV.Items.Add(lvi);//添加列信息
                    }
                }
            }
        }
        #endregion

        #region  在显示节点时，查找是否有子节点
        /// <summary>
        /// 查找是否有子节点
        /// </summary>
        /// <param TV="TreeView">TreeView控件</param>
        /// <param ANode="TreeNode">当前节点</param>
        /// <param n="int">当前节点</param>
        public void ADD_NullTreeNode(TreeView TV, TreeNode ANode, int n)
        {
            DataSet DSet = new DataSet();//实例化一个DataSet对象
            if (n == 0)//当n==0时为根节点
                DSet = OledbHelper.getDataSet("select NODEID,NODEPID,NODENAME,NODETYPE from casic_gkt1 "
                    + "where NODENAME='" + ANode.Text + "'", "casic_gkt1");
            if (n == 1)//当n==1时为子节点
                DSet = OledbHelper.getDataSet("select NODEID,NODEPID,NODENAME,NODETYPE from casic_gkt1 "
                    + "where NODEPID='" + ANode.Tag + "'", "casic_gkt1");
            if (DSet.Tables[0].Rows.Count > 0)//当查找到的行数大于时
            {
                TreeNode SonNode = new TreeNode("");//实例化一个空的节点
                ANode.Nodes.Add(SonNode);//添加该节点
            }
            else
            {
                ANode.Nodes.Clear();//清空当前节点下的所有子节点
            }
        }
        #endregion

        #region  调用文件夹编辑窗体
        /// <summary>
        /// 调用文件夹编辑窗体
        /// </summary>
        /// <param nob="string">判断操作的是资料集还是文件</param>
        /// <param sender="object">项名称</param>
        /// <param mark="int">标识</param>
        public void Proj_edit(string nob, object sender, int mark)
        {
            Redact_T = nob;
            Redact_N = "";
            Redact_M = "";
            Redact_D = "";
            ListViewItem HLVI = new ListViewItem();
            TreeNode HTreeNode = new TreeNode();
            DataSet DS = new DataSet();
            if (sender.GetType().Name == "ListView")
            {
                if (((ListView)sender).SelectedItems.Count > 0)
                {
                    HLVI = ((ListView)sender).SelectedItems[0];
                    Redact_N = ((ListView)sender).SelectedItems[0].Text;
                    Redact_M = ((ListView)sender).SelectedItems[0].Tag.ToString();
                    DS = OledbHelper.getDataSet("select NODEID,NODEPATH from casic_gkt1 where NODEID="
                        + Redact_M, "casic_gkt1");
                    Redact_D = DS.Tables[0].Rows[0][1].ToString();
                }
            }
            if (sender.GetType().Name == "TreeView")
            {
                if (((TreeView)sender).SelectedNode != null)
                {
                    HTreeNode = ((TreeView)sender).SelectedNode;
                    Redact_N = ((TreeView)sender).SelectedNode.Text;
                    Redact_M = ((TreeView)sender).SelectedNode.Tag.ToString();
                    DS = OledbHelper.getDataSet("select NODEID,NODEPATH from casic_gkt1 where NODEID="
                        + Redact_M, "casic_gkt1");
                    if (DS.Tables[0].Rows.Count == 0)
                        return;
                    Redact_D = DS.Tables[0].Rows[0][1].ToString();
                }
            }
            F_GKT1添加项目 FrmTjxm = new F_GKT1添加项目();//实例化Frm_Folder窗体
            FrmSetUp(FrmTjxm);//调用自定义方法FrmSetUp，对Frm_Radical窗体进行设置
            FrmTjxm.Tag = mark;
            switch (mark)
            {
                case 0: FrmTjxm.Text = "添加项目"; break;
                case 1: FrmTjxm.Text = "修改项目"; break;
                case 2: FrmTjxm.Text = "删除项目"; break;
            }

            if (FrmTjxm.ShowDialog() == DialogResult.OK)//显示窗体
            {
                switch (mark)
                {
                    case 0:
                        {
                            if (sender.GetType().Name == "ListView")
                            {
                                ListViewItem lvi = new ListViewItem(Redact_N);//实例化一个项
                                lvi.Tag = int.Parse(Redact_M);
                                ((ListView)sender).Items.Add(lvi);//添加列信息
                            }
                            if (sender.GetType().Name == "TreeView")
                            {
                                TreeNode SonNode = new TreeNode(Redact_N);//实例化一个具有当前节点名称的节点
                                SonNode.Tag = int.Parse(Redact_M);//在该节点的Tag属性中存放当前信息的主ID号
                                SonNode.ImageIndex = 0;
                                HTreeNode.Nodes.Add(SonNode);//添加该节点
                            }
                            break;
                        }
                    case 1:
                        {
                            FrmTjxm.Text = "修改项目";
                            if (sender.GetType().Name == "ListView")
                            {
                                HLVI.Text = Redact_N;
                            }
                            if (sender.GetType().Name == "TreeView")
                            {
                                HTreeNode.Text = Redact_N;
                            }
                            break;
                        }
                    case 2:
                        {
                            if (sender.GetType().Name == "ListView")
                            {
                                HLVI.Remove();
                            }
                            if (sender.GetType().Name == "TreeView")
                            {
                                HTreeNode.Remove();
                            }
                            break;
                        }
                }
            }
            FrmTjxm.Dispose();

        }
        #endregion

        #region  返回上一级目录
        /// <summary>
        /// 返回上一级目录
        /// </summary>
        /// <param dir="string">目录</param>
        /// <returns>返回String对象</returns>
        public string UpAndDown_Dir(string dir)
        {
            string Change_dir = "";
            Change_dir = Directory.GetParent(dir).FullName;
            return Change_dir;
        }
        #endregion

        #region  文件夹的操作
        /// <summary>
        /// 文件夹的操作
        /// </summary>
        /// <param dir="string">目录</param>
        /// <param NewName="string">修改的文件夹名称</param>
        /// <param n="int">标识</param>
        /// <returns>返回int对象</returns>
        public int Folder_Handle(string dir, string Sdir, string NewName, int n)
        {
            //MessageBox.Show(dir + "==" + Sdir + "==" + NewName + "==" + n.ToString());
            string F_Name = "";
            int t = 0;
            if (Redact_T == "T" || Redact_T == "F")
                F_Name = "文件夹";
            if (Redact_T == "W")
                F_Name = "文件";
            FileInfo FInfo = new FileInfo(dir);
            switch (n)
            {
                case 0:
                    {
                        if (Redact_T == "T" || Redact_T == "F")
                        {
                            if (Directory.Exists(dir))
                            {
                                t = 1;
                                MessageBox.Show("该" + F_Name + "已存在，无法创建。");
                                break;
                            }
                            Directory.CreateDirectory(dir);
                            if (Directory.Exists(dir) == false)
                                t = 1;
                        }
                        if (Redact_T == "W" || Redact_T == "G")
                        {
                            FileInfo SFInfo = new FileInfo(Sdir);
                            bool tbool = true;
                            if (SFInfo.Exists == false)
                            {
                                t = 1;
                                MessageBox.Show("没有找到要复制的" + F_Name);
                                break;
                            }

                            if (FInfo.Exists)
                            {
                                if (MessageBox.Show("文件夹下有同名文件，是否替换?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
                                    tbool = true;
                                else
                                    tbool = false;
                            }
                            try
                            {
                                SFInfo.CopyTo(dir, tbool);
                            }
                            catch (Exception ex)
                            {
                                t = 1;
                                MessageBox.Show(F_Name + "复制失败。");
                            }
                        }
                        break;
                    }
                case 1:
                    {
                        //MessageBox.Show("Redact_T==" + Redact_T);
                        string NewDir = "";
                        if (Redact_T == "T" || Redact_T == "F")
                        {
                            NewDir = UpAndDown_Dir(dir) + "\\" + NewName;
                            if (Directory.Exists(NewDir))
                            {
                                t = 1;
                                MessageBox.Show("该" + F_Name + "已存在，无法修改。");
                                break;
                            }
                            if (Directory.Exists(dir))
                            {
                                Directory.Move(dir, NewDir);
                            }
                            else
                            {
                                MessageBox.Show(F_Name + "不存在，无法修改。");
                                t = 1;
                                break;
                            }
                        }
                        if (Redact_T == "W")
                        {
                            if (FInfo.Exists)
                            {
                                try
                                {
                                    FInfo = new FileInfo(dir);
                                    FInfo.MoveTo(UpAndDown_Dir(dir) + "\\" + NewName);
                                }
                                catch (Exception ex)
                                {
                                    MessageBox.Show(F_Name + "文件名修改失败。");
                                    t = 1;
                                }
                            }
                            else
                            {
                                MessageBox.Show(F_Name + "不存在，无法修改。");
                                t = 1;
                            }
                        }
                        break;
                    }
                case 2:
                    {
                        if (Redact_T == "T" || Redact_T == "F")
                        {
                            if (Directory.Exists(dir) == false)
                            {
                                t = 1;
                                MessageBox.Show(F_Name + "不存在。");
                                break;
                            }
                            Directory.Delete(dir, true);
                            if (Directory.Exists(dir))
                            {
                                t = 1;
                                MessageBox.Show(F_Name + "删除失败。");
                                break;
                            }
                        }
                        if (Redact_T == "W")
                        {
                            if (FInfo.Exists == false)
                            {
                                t = 1;
                                MessageBox.Show(F_Name + "不存在。");
                                break;
                            }
                            try
                            {
                                FInfo.Delete();
                            }
                            catch (Exception ex)
                            {
                                t = 1;
                                MessageBox.Show(F_Name + "删除失败。");
                            }
                        }
                        break;
                    }
                case 3:
                    {
                        if (Directory.Exists(Sdir) == false)
                        {
                            t = 1;
                            MessageBox.Show("没有找到要复制的文件夹。");
                            break;
                        }
                        try
                        {
                            Files_Copy(dir, Sdir);
                            if (NewName == "data")
                            {
                                DirectoryInfo di = new DirectoryInfo(dir);//打开path目录,如果存在则执行方法
                                if (di.Exists)
                                {
                                    DataSet DS = OledbHelper.getDataSet("select max(NODEID) from casic_gkt1", "casic_gkt1");
                                    string SName = DS.Tables[0].Rows[0][0].ToString();
                                    Files_List(di, int.Parse(Redact_M));
                                    Redact_M = SName;
                                    Redact_N = Files_Name(dir, 1);
                                }
                            }
                        }
                        catch (Exception ex)
                        {
                            t = 1;
                            MessageBox.Show("文件夹制复失败。");
                        }
                        break;
                    }
            }
            return t;
        }
        #endregion

        #region  批量将文件夹的路径存入数据库中
        /// <summary>
        /// 批量将文件夹的路径存入数据库中
        /// </summary>
        /// <param dir="FileSystemInfo">目录</param>
        /// <param n="int">标识</param>
        /// <returns>返回string对象</returns>
        private void Files_List(FileSystemInfo dir, int NodeID)
        {
            int PID = NodeID;
            string SubDir = dir.ToString();
            if (!dir.Exists)//先判断所指的文件或文件夹是否存在
            {
                return;
            }
            DirectoryInfo dirD = dir as DirectoryInfo;//如果给定的参数不是文件夹则退出

            if (dirD == null)
            {
                OledbHelper.getsqlcom("insert into casic_gkt1 (NODEPID,NODENAME,NODEPATH,NODETYPE,NODESIGN) "
                    + "values(" + PID + ",'" + dirD.Name.Trim() + "','" + SubDir + "',1," + UserSign + ")");
                return;
            }
            OledbHelper.getsqlcom("insert into casic_gkt1 (NODEPID,NODENAME,NODEPATH,NODETYPE,NODESIGN) "
                                  + "values(" + PID + ",'" + dirD.Name.Trim() + "','" + SubDir + "',1," + UserSign + ")");
            DataSet DS = OledbHelper.getDataSet("select max(NODEID) from casic_gkt1", "casic_gkt1");
            PID = int.Parse(DS.Tables[0].Rows[0][0].ToString());
            SubDir = SubDir + "\\";
            FileSystemInfo[] files = dirD.GetFileSystemInfos();//获取文件夹中所有文件和文件夹
            //对单个FileSystemInfo进行判断,如果是文件夹则进行递归操作
            foreach (FileSystemInfo FSys in files)
            {
                FileInfo file = FSys as FileInfo;
                if (file != null)
                {
                    OledbHelper.getsqlcom("insert into casic_gkt1 (NODEPID,NODENAME,NODEPATH,NODETYPE,NODESIGN)"
                        + " values(" + PID + ",'" + file.Name.Trim() + "','" + SubDir + file.Name + "',0,"
                        + UserSign + ")");
                }
                else
                {
                    DirectoryInfo DD = new DirectoryInfo(SubDir + FSys);
                    Files_List(DD, PID);//进行Files_List方法的递归调用
                }
            }
        }
        #endregion

        #region  文件夹的复制
        /// <summary>
        /// 文件夹的复制
        /// </summary>
        /// <param Ddir="string">要复制的目的路径</param>
        /// <param Sdir="string">要复制的原路径</param>
        /// <returns>返回int对象</returns>
        private void Files_Copy(string Ddir, string Sdir)
        {
            DirectoryInfo dir = new DirectoryInfo(Sdir);
            string SbuDir = Ddir;
            try
            {
                if (!dir.Exists)//判断所指的文件或文件夹是否存在
                {
                    return;
                }
                DirectoryInfo dirD = dir;//如果给定参数不是文件夹则退出
                string UpDir = UpAndDown_Dir(Ddir);
                if (dirD == null)//判断文件夹是否为空
                {
                    Directory.CreateDirectory(UpDir + "\\" + dirD.Name);//如果为空，创建文件夹并退出
                    return;
                }
                Directory.CreateDirectory(UpDir + "\\" + dirD.Name);
                SbuDir = UpDir + "\\" + dirD.Name + "\\";
                FileSystemInfo[] files = dirD.GetFileSystemInfos();//获取文件夹中所有文件和文件夹
                //对单个FileSystemInfo进行判断,如果是文件夹则进行递归操作
                foreach (FileSystemInfo FSys in files)
                {
                    FileInfo file = FSys as FileInfo;
                    if (file != null)//如果是文件的话，进行文件的复制操作
                    {
                        FileInfo SFInfo = new FileInfo(file.DirectoryName + "\\" + file.Name);//获取文件所在的原始路径
                        SFInfo.CopyTo(SbuDir + "\\" + file.Name, true);//将文件复制到指定的路径中
                    }
                    else
                    {
                        string pp = FSys.Name;//获取当前搜索到的文件夹名称
                        Files_Copy(SbuDir + FSys, Sdir + "\\" + FSys);//如果是文件，则进行递归调用
                    }
                }
            }
            catch (Exception ex)
            {
            }
        }
        #endregion

        #region  获取文件或文件夹的名称
        /// <summary>
        /// 获取文件或文件夹的名称
        /// </summary>
        /// <param dir="string">目录</param>
        /// <param n="int">标识</param>
        /// <returns>返回string对象</returns>
        public string Files_Name(string dir, int n)
        {
            string DF_Name = "";
            if (n == 0)
            {
                string F_N = dir.Substring(dir.LastIndexOf("\\") + 1, dir.LastIndexOf(".") - dir.LastIndexOf("\\") - 1);
                string F_E = dir.Substring(dir.LastIndexOf(".") + 1, dir.Length - dir.LastIndexOf(".") - 1);
                DF_Name = F_N + "." + F_E;
            }
            if (n > 0)
            {
                DF_Name = dir.Substring(dir.LastIndexOf("\\") + 1, dir.Length - dir.LastIndexOf("\\") - 1);
            }
            return DF_Name;
        }
        #endregion

        #region  修改或删除文件夹后在数据库中整理子文件夹和子文件的目录
        /// <summary>
        /// 修改或删除文件夹后在数据库中整理子文件夹和子文件的目录
        /// </summary>
        /// <param Olddir="string">原目录</param>
        /// <param NewName="string">修改后的目录</param>
        /// <param n="int">标识</param>
        public void DFiles_CleanUp(string Olddir, string Newdir, int n)
        {
            string DFsql = "";
            //DataSet DS = dataclass.getDataSet("select NodeID,NodeName,NodePath from Ped where NodePath like '" + Olddir + "%'", "Ped");
            string DF_Name = Files_Name(Newdir, n);
            switch (n)
            {
                case 1:
                    {
                        string olddir = Files_Name(Olddir, n);
                        OledbHelper.getsqlcom("update casic_gkt1 set NODEPATH='" + DF_Name + "' where NODEPATH = '" + olddir + "'");

                        //OledbHelper.getsqlcom("update Ped set NodeName='" + DF_Name + "' where NodePath like '" + Olddir + "'");
                        //DFsql = "update Ped set NodePath=(select REPLACE(NodePath,'" + Olddir + "','" + Newdir + "')) where len(NodePath)=len('" + Olddir + "') or substring(NodePath,len('" + Olddir + "')+1,1)='\\'";
                        break;
                    }
                case 2:
                    {
                        DF_Name = Files_Name(Olddir, n);
                        //DFsql = "delete Ped where (len(NodePath)=len('" + Olddir + "') or substring(NodePath,len('" + Olddir + "')+1,1)='\\') and (substring(NodePath,0,len('" + Olddir + "')+1)='" + Olddir + "')";
                        //DFsql = "delete casic_ped where (len(NODEPATH)=len('" + DF_Name + "') or substring(NODEPATH,len('" + DF_Name + "')+1,1)='\\') and (substring(NodePath,0,len('" + DF_Name + "')+1)='" + DF_Name + "')";
                        DFsql = "delete casic_gkt1 where NODEPATH = '" + DF_Name + "'";

                        OledbHelper.getsqlcom(DFsql);
                        break;
                    }
            }
            //if (n > 0)
            //    OledbHelper.getsqlcom(DFsql);
        }
        #endregion

        #region  文件夹禁止使用的字符
        /// <summary>
        /// 文件夹禁止使用的字符
        /// </summary>
        /// <param e="KeyPressEventArgs">键值</param>
        /// <returns>返回string对象</returns>
        public int Files_NameChar(KeyPressEventArgs e)
        {
            int n = 1;
            char[] F_ncs = Path.GetInvalidFileNameChars();
            foreach (char F_nc in F_ncs)
            {
                if (F_nc == e.KeyChar)
                {
                    n = 0;
                    break;
                }
            }
            if (e.KeyChar == '\b')
                n = 1;
            return n;
        }
        #endregion

        #region  调用文件编辑窗体
        /// <summary>
        /// 调用文件夹编辑窗体
        /// </summary>
        /// <param nob="string">判断操作的资料集或文件</param>
        /// <param sender="object">项名称</param>
        /// <param mark="int">标识</param>
        public void FileEdit_form(string nob, object sender, int mark)
        {
            //MessageBox.Show(nob + "==" + mark.ToString());
            Redact_T = nob;
            Redact_N = "";
            Redact_M = "";
            Redact_D = "";
            TreeNode HTreeNode = new TreeNode();
            DataSet DS = new DataSet();
            if (((TreeView)sender).SelectedNode != null)
            {
                HTreeNode = ((TreeView)sender).SelectedNode;
                Redact_N = ((TreeView)sender).SelectedNode.Text;
                Redact_M = ((TreeView)sender).SelectedNode.Tag.ToString();
                DS = OledbHelper.getDataSet("select NODEID,NODEPATH,NODETYPE from casic_gkt1 where NODEID=" + Redact_M, "casic_gkt1");
                if (DS.Tables[0].Rows.Count == 0)
                    return;
                Redact_D = DS.Tables[0].Rows[0][1].ToString();
                int nt = int.Parse(DS.Tables[0].Rows[0][2].ToString());
                //MessageBox.Show(Redact_D + "=!=!=" + nt.ToString());
                if (nt != 0 && mark > 0)
                    return;
            }
            F_GKT1添加文件 FrmFile = new F_GKT1添加文件();//实例化Frm_Folder窗体
            FrmSetUp(FrmFile);//调用自定义方法FrmSetUp，对Frm_Radical窗体进行设置
            FrmFile.Tag = mark;
            switch (mark)
            {
                case 0: FrmFile.Text = "添加文件"; break;
                case 1: FrmFile.Text = "修改文件"; break;
                case 2: FrmFile.Text = "删除文件"; break;
            }
            if (FrmFile.ShowDialog() == DialogResult.OK)//显示窗体
            {
                switch (mark)
                {
                    case 0:
                        {
                            TreeNode SonNode = new TreeNode("");//实例化一个具有当前节点名称的节点
                            for (int i = 0; i < ADD_LV.Items.Count; i++)
                            {
                                SonNode = new TreeNode(ADD_LV.Items[i].Text);//实例化一个具有当前节点名称的节点
                                SonNode.Tag = int.Parse(ADD_LV.Items[i].Tag.ToString());//在该节点的Tag属性中存放当前信息的主ID号
                                SonNode.ImageIndex = 2;
                                HTreeNode.Nodes.Add(SonNode);//添加该节点
                            }
                            break;
                        }
                    case 1:
                        {
                            HTreeNode.Text = Redact_N;
                            break;
                        }
                    case 2:
                        {
                            HTreeNode.Remove();
                            break;
                        }
                }
            }
            FrmFile.Dispose();

        }
        #endregion

        #region  调用导入导出编辑窗体
        /// <summary>
        /// 调用导入导出编辑窗体
        /// </summary>
        /// <param nob="string">判断是导入或导出窗体</param>
        /// <param sender="object">项名称</param>
        /// <param mark="int">标识</param>
        public void GuideEdit_form(string nob, object sender, int mark)
        {
            Redact_T = nob;
            Redact_N = "";
            Redact_M = "";
            Redact_D = "";
            TreeNode HTreeNode = new TreeNode();
            DataSet DS = new DataSet();
            if (((TreeView)sender).SelectedNode != null)
            {
                HTreeNode = ((TreeView)sender).SelectedNode;
                Redact_N = ((TreeView)sender).SelectedNode.Text;
                Redact_M = ((TreeView)sender).SelectedNode.Tag.ToString();
                DS = OledbHelper.getDataSet("select NODEID,NODEPATH,NODETYPE from casic_gkt1 where NODEID="
                    + Redact_M, "casic_gkt1");

                if (DS.Tables[0].Rows.Count == 0)
                    return;
                Redact_D = DS.Tables[0].Rows[0][1].ToString();
                int nt = int.Parse(DS.Tables[0].Rows[0][2].ToString());

                if (nt == 0 && mark != 2)
                    return;
                if (nt > 0 && mark == 2)
                    return;
            }
            F_GKT1数据输入输出 FrmInOut = new F_GKT1数据输入输出();//实例化Frm_Folder窗体
            FrmSetUp(FrmInOut);//调用自定义方法FrmSetUp，对Frm_Radical窗体进行设置
            FrmInOut.Tag = mark;
            if (FrmInOut.ShowDialog() == DialogResult.OK)//显示窗体
            {
                if (mark == 0)
                {
                    TreeNode SonNode = new TreeNode(Redact_N);//实例化一个具有当前节点名称的节点
                    SonNode.Tag = int.Parse(Redact_M);//在该节点的Tag属性中存放当前信息的主ID号
                    SonNode.ImageIndex = 0;
                    HTreeNode.Nodes.Add(SonNode);//添加该节点
                    SonNode.Nodes.Add(new TreeNode(""));
                }

            }
            FrmInOut.Dispose();
        }
        #endregion

        #region  调用导入导出编辑窗体
        /// <summary>
        /// 调用导入导出编辑窗体
        /// </summary>
        /// <param STV="TreeView">查询的节点</param>
        /// <param DLV="ListView">显示查找的文件</param>
        /// <param FName="string">查找的文件名</param>
        public void Find_File(TreeView STV, ListView DLV, string FName)
        {
            STV.Dock = DockStyle.Fill;//使TreeView控件最大化
            STV.Visible = true;//是否显示TreeView控件
            //DLV.Visible = false; 
            DataSet DS = new DataSet();
            if (FName == "")
            {
                MessageBox.Show("查找文件名不能为空。");
                return;
            }
            DS = OledbHelper.getDataSet("select * from casic_gkt1 where NODENAME like '%" + FName
                + "%' and NODETYPE=0", "casic_gkt1");
            if (DS.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("没有查到相关文件。");
                return;
            }
            ShowResultTree(STV, DS.Tables[0]);

        }
        #endregion

        #region  在文件列表中添加根节点
        /// <summary>
        /// 在文件列表中添加根节点
        /// </summary>
        /// <param TV="TreeView">TreeView控件</param>
        /// <param Nodename="string">要添加的根节点名称</param>
        public void ShowResultTree(TreeView TV, DataTable table)
        {
            int temp = 0;

            TempNode = "";
            TV.Nodes.Clear();//清空TreeView控件

            string[] projects = new string[table.Rows.Count];
            string[] filenames = new string[table.Rows.Count];

            TreeNode RNode = null;
            TreeNode YNode = null;
            for (int i = 0; i < table.Rows.Count; i++)
            {
                projects[i] = table.Rows[i][3].ToString();
                filenames[i] = table.Rows[i][2].ToString();
                BaseNode = projects[i].Trim();

                if (BaseNode.Trim() != TempNode.Trim())
                {
                    RNode = new TreeNode(BaseNode);//向TreeView控件中添加根节点    

                    YNode = new TreeNode(filenames[i]);//加个叶子
                    YNode.Tag = table.Rows[i][0].ToString();
                    RNode.Nodes.Add(YNode);
                    TempNode = BaseNode.Trim();
                    temp = 0;
                }
                else
                {
                    YNode = new TreeNode(filenames[i]);//加个叶子 
                    YNode.Tag = table.Rows[i][0].ToString();
                    RNode.Nodes.Add(YNode);
                    temp++;
                }
                if ((temp == 0) || (table.Rows.Count == 1))
                {
                    TV.Nodes.Add(RNode);
                }
            }
        }
        #endregion

    }
}