dbview.cs

通过数据库结构自动 生成三层结构代码,相当不错的一款软件

                                        node17.Tag = "column";
                                        node16.Nodes.Add(node17);
                                    }
                                }
                            }
                        }
                    }
                    continue;
                }
                catch (Exception exception5)
                {
                    LogInfo.WriteLog(exception5);
                    MessageBox.Show(this, "获取数据库" + dbName + "的视图信息失败：" + exception5.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
                    continue;
                }
            }
            foreach (TreeNode node18 in this.treeView1.Nodes)
            {
                if (node18.Text == ServerIp)
                {
                    this.treeView1.SelectedNode = node18;
                }
            }
            this.mainfrm.StatusLabel1.Text = "就绪";
        }

        private void DbView_Layout(object sender, LayoutEventArgs e)
        {
            if (!this.m_bLayoutCalled)
            {
                this.m_bLayoutCalled = true;
                SplashScreen.CloseForm();
                base.Activate();
            }
        }

        private void DbView_Load(object sender, EventArgs e)
        {
            this.LoadServer();
            this.setting = ModuleConfig.GetSettings();
            this.mainfrm = (MainForm) Application.OpenForms["MainForm"];
        }

        private void DELETEItem_Click(object sender, EventArgs e)
        {
            if (this.TreeClickNode != null)
            {
                string text = this.TreeClickNode.Parent.Parent.Parent.Text;
                string dbname = this.TreeClickNode.Parent.Parent.Text;
                string tablename = this.TreeClickNode.Text;
                string sQLDelete = ObjHelper.CreatDsb(text).GetSQLDelete(dbname, tablename);
                string pageTitle = tablename + "查询.sql";
                this.AddTabPage(pageTitle, new DbQuery(this.mainfrm, sQLDelete));
            }
        }

        protected override void Dispose(bool disposing)
        {
            if (disposing && (this.components != null))
            {
                this.components.Dispose();
            }
            base.Dispose(disposing);
        }

        private string GetConstr(string ServerIp, string txtConstr)
        {
            string str = "";
            if (ServerIp != "")
            {
                str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ServerIp + ";Persist Security Info=False";
                if (ServerIp.ToLower().IndexOf(".mdb") > 0)
                {
                    isMdb = true;
                    return str;
                }
                isMdb = false;
                return str;
            }
            str = txtConstr;
            if (str.ToLower().IndexOf(".mdb") > 0)
            {
                isMdb = true;
                return str;
            }
            isMdb = false;
            return str;
        }

        public string GetLongServername()
        {
            TreeNode selectedNode = this.treeView1.SelectedNode;
            if (selectedNode == null)
            {
                return "";
            }
            switch (selectedNode.Tag.ToString())
            {
                case "serverlist":
                    return "";

                case "server":
                    return selectedNode.Text;

                case "db":
                    return selectedNode.Parent.Text;

                case "tableroot":
                case "viewroot":
                    return selectedNode.Parent.Parent.Text;

                case "table":
                case "view":
                    return selectedNode.Parent.Parent.Parent.Text;

                case "column":
                    return selectedNode.Parent.Parent.Parent.Parent.Text;
            }
            return "";
        }

        private string GetserverNodeText(string servername, string dbtype, string dbname)
        {
            string str = servername + "(" + dbtype + ")";
            if ((dbname.Trim() != "") && (dbname.Trim() != "master"))
            {
                str = str + "(" + dbname + ")";
            }
            return str;
        }

        private void InitializeComponent()
        {
            this.components = new Container();
            ComponentResourceManager manager = new ComponentResourceManager(typeof(DbView));
            TreeNode node = new TreeNode("ID", 7, 7);
            TreeNode node2 = new TreeNode("table1", 5, 5, new TreeNode[] { node });
            TreeNode node3 = new TreeNode("表", 3, 4, new TreeNode[] { node2 });
            TreeNode node4 = new TreeNode("节点4", 7, 7);
            TreeNode node5 = new TreeNode("view1", 6, 6, new TreeNode[] { node4 });
            TreeNode node6 = new TreeNode("视图", 3, 4, new TreeNode[] { node5 });
            TreeNode node7 = new TreeNode("master", 2, 2, new TreeNode[] { node3, node6 });
            TreeNode node8 = new TreeNode("127.0.0.1", 1, 1, new TreeNode[] { node7 });
            TreeNode node9 = new TreeNode("服务器", 0, 0, new TreeNode[] { node8 });
            this.treeImgs = new ImageList(this.components);
            this.treeView1 = new TreeView();
            this.DbTreeContextMenu = new ContextMenuStrip(this.components);
            this.添加服务器ToolStripMenuItem = new ToolStripMenuItem();
            this.adfsToolStripMenuItem = new ToolStripMenuItem();
            this.toolStripMenuItem1 = new ToolStripSeparator();
            this.toolStrip1 = new ToolStrip();
            this.toolbtn_AddServer = new ToolStripButton();
            this.toolStripSeparator2 = new ToolStripSeparator();
            this.toolbtn_Connect = new ToolStripButton();
            this.toolbtn_unConnect = new ToolStripButton();
            this.toolStripSeparator1 = new ToolStripSeparator();
            this.toolbtn_Refrush = new ToolStripButton();
            this.DbTreeContextMenu.SuspendLayout();
            this.toolStrip1.SuspendLayout();
            base.SuspendLayout();
            this.treeImgs.ImageStream = (ImageListStreamer) manager.GetObject("treeImgs.ImageStream");
            this.treeImgs.TransparentColor = Color.Transparent;
            this.treeImgs.Images.SetKeyName(0, "serverlist.gif");
            this.treeImgs.Images.SetKeyName(1, "server.ico");
            this.treeImgs.Images.SetKeyName(2, "db.gif");
            this.treeImgs.Images.SetKeyName(3, "Folderclose.gif");
            this.treeImgs.Images.SetKeyName(4, "Folderopen.gif");
            this.treeImgs.Images.SetKeyName(5, "tab2.gif");
            this.treeImgs.Images.SetKeyName(6, "view.gif");
            this.treeImgs.Images.SetKeyName(7, "fild2.gif");
            this.treeImgs.Images.SetKeyName(8, "sp.gif");
            this.treeImgs.Images.SetKeyName(9, "sp_p.gif");
            this.treeView1.BorderStyle = BorderStyle.FixedSingle;
            this.treeView1.ContextMenuStrip = this.DbTreeContextMenu;
            this.treeView1.Dock = DockStyle.Fill;
            this.treeView1.ImageIndex = 0;
            this.treeView1.ImageList = this.treeImgs;
            this.treeView1.Location = new Point(0, 0x1a);
            this.treeView1.Name = "treeView1";
            node.ImageIndex = 7;
            node.Name = "ID";
            node.SelectedImageIndex = 7;
            node.Text = "ID";
            node2.ImageIndex = 5;
            node2.Name = "table1";
            node2.SelectedImageIndex = 5;
            node2.Text = "table1";
            node3.ImageIndex = 3;
            node3.Name = "表";
            node3.SelectedImageIndex = 4;
            node3.Text = "表";
            node4.ImageIndex = 7;
            node4.Name = "节点4";
            node4.SelectedImageIndex = 7;
            node4.Text = "节点4";
            node5.ImageIndex = 6;
            node5.Name = "view1";
            node5.SelectedImageIndex = 6;
            node5.Text = "view1";
            node6.ImageIndex = 3;
            node6.Name = "视图";
            node6.SelectedImageIndex = 4;
            node6.Text = "视图";
            node7.ImageIndex = 2;
            node7.Name = "master";
            node7.SelectedImageIndex = 2;
            node7.Text = "master";
            node8.ImageIndex = 1;
            node8.Name = "";
            node8.SelectedImageIndex = 1;
            node8.Text = "127.0.0.1";
            node9.ImageIndex = 0;
            node9.Name = "";
            node9.SelectedImageIndex = 0;
            node9.Text = "服务器";
            this.treeView1.Nodes.AddRange(new TreeNode[] { node9 });
            this.treeView1.SelectedImageIndex = 0;
            this.treeView1.ShowRootLines = false;
            this.treeView1.Size = new Size(0xab, 0x156);
            this.treeView1.TabIndex = 2;
            this.treeView1.AfterSelect += new TreeViewEventHandler(this.treeView1_AfterSelect);
            this.treeView1.MouseUp += new MouseEventHandler(this.treeView1_MouseUp);
            this.treeView1.ItemDrag += new ItemDragEventHandler(this.treeView1_ItemDrag);
            this.DbTreeContextMenu.Items.AddRange(new ToolStripItem[] { this.添加服务器ToolStripMenuItem, this.toolStripMenuItem1 });
            this.DbTreeContextMenu.Name = "DbTreeContextMenu";
            this.DbTreeContextMenu.Size = new Size(0x83, 0x20);
            this.添加服务器ToolStripMenuItem.DropDownItems.AddRange(new ToolStripItem[] { this.adfsToolStripMenuItem });
            this.添加服务器ToolStripMenuItem.Name = "添加服务器ToolStripMenuItem";
            this.添加服务器ToolStripMenuItem.Size = new Size(130, 0x16);
            this.添加服务器ToolStripMenuItem.Text = "添加服务器";
            this.adfsToolStripMenuItem.Name = "adfsToolStripMenuItem";
            this.adfsToolStripMenuItem.Size = new Size(0x5e, 0x16);
            this.adfsToolStripMenuItem.Text = "adfs";
            this.toolStripMenuItem1.Name = "toolStripMenuItem1";
            this.toolStripMenuItem1.Size = new Size(0x7f, 6);
            this.toolStrip1.BackColor = SystemColors.Control;
            this.toolStrip1.BackgroundImage = (Image) manager.GetObject("toolStrip1.BackgroundImage");
            this.toolStrip1.Items.AddRange(new ToolStripItem[] { this.toolbtn_AddServer, this.toolStripSeparator2, this.toolbtn_Connect, this.toolbtn_unConnect, this.toolStripSeparator1, this.toolbtn_Refrush });
            this.toolStrip1.Location = new Point(0, 0);
            this.toolStrip1.Name = "toolStrip1";
            this.toolStrip1.Size = new Size(0xab, 0x1a);
            this.toolStrip1.TabIndex = 3;
            this.toolStrip1.Text = "toolStrip1";
            this.toolbtn_AddServer.DisplayStyle = ToolStripItemDisplayStyle.Image;
            this.toolbtn_AddServer.Image = (Image) manager.GetObject("toolbtn_AddServer.Image");
            this.toolbtn_AddServer.ImageScaling = ToolStripItemImageScaling.None;
            this.toolbtn_AddServer.ImageTransparentColor = Color.Magenta;
            this.toolbtn_AddServer.Name = "toolbtn_AddServer";
            this.toolbtn_AddServer.Size = new Size(0x17, 0x17);
            this.toolbtn_AddServer.Text = "新增服务器注册";
            this.toolbtn_AddServer.ToolTipText = "新增服务器注册";
            this.toolbtn_AddServer.Click += new EventHandler(this.toolbtn_AddServer_Click);
            this.toolStripSeparator2.Name = "toolStripSeparator2";
            this.toolStripSeparator2.Size = new Size(6, 0x1a);
            this.toolbtn_Connect.DisplayStyle = ToolStripItemDispl