private void GetDatabaseObjects2(DBRegistrationClass dbR) { if (dbR == null) { return; } this.Cursor = Cursors.WaitCursor; var db = dbR.Clone(); var ddc = new DatabaseDesignClass { Tables = StaticTreeClass.Instance().GetAllNonSystemTableObjectsComplete(db), Views = StaticTreeClass.Instance().GetViewObjects(db) }; var generators = StaticTreeClass.Instance().GetGeneratorObjects(db); var procedures = StaticTreeClass.Instance().GetProcedureObjects(db); var functions = StaticTreeClass.Instance().GetFunctionObjects(db); slbDbObjects2.ClearItems(); if (ddc.Tables != null) { foreach (var tc in ddc.Tables.Values) { slbDbObjects2.Add($@"TABLE.{tc.Name}", CheckState.Checked, tc); } } if (ddc.Views != null) { foreach (var tc in ddc.Views.Values) { slbDbObjects2.Add($@"VIEW.{tc.Name}", CheckState.Checked, tc); } } if (generators != null) { foreach (var tc in generators.Values) { slbDbObjects2.Add($@"GEN.{tc.Name}", CheckState.Checked, tc); } } if (procedures != null) { foreach (var tc in procedures.Values) { slbDbObjects2.Add($@"PROC.{tc.Name}", CheckState.Checked, tc); } } if (functions != null) { foreach (var tc in functions.Values) { slbDbObjects2.Add($@"FUNC.{tc.Name}", CheckState.Checked, tc); } } this.Cursor = Cursors.Default; }
private void GetDatabaseObjects1(DBRegistrationClass dbR) { if (dbR == null) { return; } this.Cursor = Cursors.WaitCursor; var db = dbR.Clone(); var ddc = new DatabaseDesignClass { Tables = StaticTreeClass.GetAllTableObjectsComplete(db), Views = StaticTreeClass.GetViewObjects(db) }; var generators = StaticTreeClass.GetGeneratorObjects(db); var procedures = StaticTreeClass.GetProcedureObjects(db); slbDbObjects1.ClearItems(); foreach (var tc in ddc.Tables.Values) { slbDbObjects1.Add($@"TABLE.{tc.Name}", CheckState.Checked, tc); } foreach (var tc in ddc.Views.Values) { slbDbObjects1.Add($@"VIEW.{tc.Name}", CheckState.Checked, tc); } foreach (var tc in generators.Values) { slbDbObjects1.Add($@"GEN.{tc.Name}", CheckState.Checked, tc); } foreach (var tc in procedures.Values) { slbDbObjects1.Add($@"PROC.{tc.Name}", CheckState.Checked, tc); } this.Cursor = Cursors.Default; }