Ejemplo n.º 1
0
 void views_LoadData(object sender, EventArgs e)
 {
     BaseNode obj = (BaseNode)sender;
     //IList<ViewSchema> list = DBSchemaProvider.GetInstance().GetViews(obj.ConnectionStringBuilder);
     //if (list != null)
     //{
     //    foreach (ViewSchema schema in list)
     //    {
     //        BaseNode view = new BaseNode(schema.Name, obj.ConnectionStringBuilder, DataType.view);
     //        view.ContextMenu = new System.Windows.Forms.ContextMenu(new MenuItem[]{
     //            Refresh(),Open()
     //        });
     //        view.ImageIndex =view.SelectedImageIndex= 3;
     //        obj.Nodes.Add(view);
     //    }
     //}
     if (obj.Tag != null)
     {
         DataBaseEntity database = (DataBaseEntity)obj.Tag;
         IList<ViewEntity> list=database.Views;
         if (list != null)
         {
             foreach (ViewEntity schema in list)
             {
                 BaseNode proc = new BaseNode(schema.Name, schema.DbConnectionStringBuilder, DataType.view);
                 proc.Tag=schema;
                 proc.ContextMenu = new System.Windows.Forms.ContextMenu(new MenuItem[]{
                     Refresh(),Open()
                 });
                 proc.ImageIndex = proc.SelectedImageIndex = 3;
                 obj.Nodes.Add(proc);
             }
         }
     }
 }
Ejemplo n.º 2
0
 void tables_LoadData(object sender, EventArgs e)
 {
     BaseNode obj = (BaseNode)sender;
     if (obj.Tag != null)
     {
         DataBaseEntity database = (DataBaseEntity)obj.Tag;
         IList<TableEntity> list=database.Tables;
         if (list != null)
         {
             foreach (TableEntity schema in list)
             {
                 BaseNode node = new BaseNode(schema.Description, schema.DbConnectionStringBuilder, DataType.table);
                 node.Tag = schema;
                 node.ContextMenu = new System.Windows.Forms.ContextMenu(new MenuItem[]{
                             Refresh(),Open(),BuildCode()
                         });
                 node.Name = schema.Name;
                 node.ImageIndex = node.SelectedImageIndex = 2;
                 node.LoadData += new EventHandler(node_LoadData);
                 obj.Nodes.Add(node);
             }
         }
     }
 }
Ejemplo n.º 3
0
 void root_LoadData(object sender, EventArgs e)
 {
     BaseNode obj = (BaseNode)sender;
     //IList<DataBaseSchema> list =DBSchemaProvider.GetInstance().GetDataBases();
     //if (list != null)
     //{
     //    foreach (DataBaseSchema schema in list)
     //    {
     //        DbConnectionStringBuilder builder = obj.ConnectionStringBuilder.NewInstance(schema.Name);
     //        BaseNode database = new BaseNode(schema.Name, builder, DataType.database);
     //        database.ContextMenu = new System.Windows.Forms.ContextMenu(new MenuItem[]{
     //            Refresh()
     //        });
     //        database.ImageIndex =database.SelectedImageIndex= 1;
     //        database.LoadData += new EventHandler(database_LoadData);
     //        //database.Image = ResourcesHelper.FetchDB_icon(p => p.Schema);
     //        obj.Nodes.Add(database);
     //    }
     //}
     if (obj.Tag != null)
     {
         ServiceSite service = (ServiceSite)obj.Tag;
         IList<DataBaseEntity> list = service.DataBases;
         if (list != null)
         {
             foreach (DataBaseEntity schema in list)
             {
                 BaseNode database = new BaseNode(schema.Name,schema.DbConnectionStringBuilder, DataType.database);
                 database.Tag = schema;
                 database.ContextMenu = new System.Windows.Forms.ContextMenu(new MenuItem[]{
                 Refresh()
             });
                 database.ImageIndex = database.SelectedImageIndex = 1;
                 database.LoadData += new EventHandler(database_LoadData);
                 //database.Image = ResourcesHelper.FetchDB_icon(p => p.Schema);
                 obj.Nodes.Add(database);
             }
         }
     }
 }
Ejemplo n.º 4
0
 void node_LoadData(object sender, EventArgs e)
 {
     BaseNode obj = (BaseNode)sender;
     //IList<ColumnSchema> list = DBSchemaProvider.GetInstance().GetColumns(obj.ConnectionStringBuilder, obj.Name);
     //if (list != null)
     //{
     //    foreach (ColumnSchema schema in list)
     //    {
     //        BaseNode col = new BaseNode(schema.Name, obj.ConnectionStringBuilder, DataType.column);
     //        col.ImageIndex=col.SelectedImageIndex =6;
     //        col.Nodes.Clear();
     //        obj.Nodes.Add(col);
     //    }
     //}
     if (obj.Tag != null)
     {
         TableEntity table = (TableEntity)obj.Tag;
         IList<ColumnEntity> list=table.Columns;
         if (list != null)
         {
             foreach (ColumnEntity schema in list)
             {
                 BaseNode col = new BaseNode(schema.Description, schema.DbConnectionStringBuilder, DataType.column);
                 col.Tag=schema;
                 col.ImageIndex=col.SelectedImageIndex =6;
                 col.Nodes.Clear();
                 obj.Nodes.Add(col);
             }
         }
     }
 }
Ejemplo n.º 5
0
        void database_LoadData(object sender, EventArgs e)
        {
            BaseNode database = (BaseNode)sender;
            BaseNode tables = new BaseNode("Tables", database.ConnectionStringBuilder, DataType.package);
            tables.Tag = database.Tag;
            tables.ImageIndex = tables.SelectedImageIndex = 7;
            tables.ContextMenu = new System.Windows.Forms.ContextMenu(new MenuItem[]{
                        Refresh()
                    });
            tables.LoadData += new EventHandler(tables_LoadData);
            database.Nodes.Add(tables);

            BaseNode views = new BaseNode("Views", database.ConnectionStringBuilder, DataType.package);
            views.Tag = database.Tag;
            views.ImageIndex = views.SelectedImageIndex = 7;
            views.ContextMenu = new System.Windows.Forms.ContextMenu(new MenuItem[]{
                        Refresh()
                    });
            views.LoadData += new EventHandler(views_LoadData);
            database.Nodes.Add(views);

            BaseNode proc = new BaseNode("Proc", database.ConnectionStringBuilder, DataType.package);
            proc.Tag = database.Tag;
            proc.ImageIndex = proc.SelectedImageIndex = 7;
            proc.ContextMenu = new System.Windows.Forms.ContextMenu(new MenuItem[]{
                        Refresh()
                    });
            proc.LoadData += new EventHandler(proc_LoadData);
            database.Nodes.Add(proc);

            BaseNode triggers = new BaseNode("Triggers", database.ConnectionStringBuilder, DataType.package);
            triggers.Tag = database.Tag;
            triggers.ImageIndex = triggers.SelectedImageIndex = 7;
            triggers.ContextMenu = new System.Windows.Forms.ContextMenu(new MenuItem[]{
                        Refresh()
                    });
            triggers.LoadData += new EventHandler(triggers_LoadData);
            database.Nodes.Add(triggers);
        }
Ejemplo n.º 6
0
 private void DataBasesTree_Load(object sender, EventArgs e)
 {
     this.treeView1.Nodes.Clear();
     /*test*/
     SqlConnectionStringBuilder str = new SqlConnectionStringBuilder();
     str.DataSource = @"L-PC\MYSQL";
     str.UserID = "sa";
     str.Password = "******";
     //MySql.Data.MySqlClient.MySqlConnectionStringBuilder str = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder();
     //str.Server = "127.0.0.1";
     //str.UserID = "root";
     //str.Password = "******";
     //DBSchemaProvider.NewInstance("LCW.Framework.Common.DataAccess.Schema.Mysql.MySqlProvider");
     //DBSchemaProvider.GetInstance().ConnectionStringBuilder = str;
     //DbConnectionStringBuilder builder = DBSchemaProvider.GetInstance().ConnectionStringBuilder;
     //BaseNode root = new BaseNode(builder.ServiceName(), builder, DataType.service);
     //root.ImageIndex =root.SelectedImageIndex= 0;
     //root.LoadData += new EventHandler(root_LoadData);
     //this.treeView1.Nodes.Add(root);
     ServiceSite service=DataBaseSchemaBuilder.NewInstance(str, "Sql");
     BaseNode root = new BaseNode(service.Name,service.DbConnectionStringBuilder, DataType.service);
     root.ImageIndex = root.SelectedImageIndex = 0;
     root.Tag = service;
     root.LoadData += new EventHandler(root_LoadData);
     this.treeView1.Nodes.Add(root);
 }