private FbXpertMainForm() { InitializeComponent(); NotificationsForm.Instance().Init(); NotifiesClass.Instance().Notify.OnRaiseInfoHandler += InfoRaised; NotifiesClass.Instance().Notify.OnRaiseErrorHandler += ErrorRaised; LanguageClass.Instance().OnRaiseLanguageChangedHandler += FBXpertMainForm_OnRaiseLanguageChangedHandler; NotificationsForm.Instance().SetMDIForm(this); string appfile = Application.StartupPath + "\\config\\AppSettings.json"; if (File.Exists(appfile)) { AppSettingsClass appset = fastJSON.JSON.ToObject(File.ReadAllText(appfile)) as AppSettingsClass; AppSettingsClass.Instance().Load(appset); } else { AppSettingsClass.Instance(); } NotifiesClass.Instance().InfoThreshold = eInfoLevel.normal; //(eInfoLevel) AppSettingsClass.Instance().BehavierSettings.DebugThreshold; }
private void FBXpertMainForm_Load(object sender, EventArgs e) { // LanguageClass.Instance().InitEmbedded(this,"FBXpert.Languages","Language","de"); LanguageClass.Instance().InitFile(this, $@"{Application.StartupPath}\Languages\", "Language", ".", "de"); LanguageClass.Instance().OnRaiseLanguageExceptionHandler += FbXpertMainForm_OnRaiseLanguageExceptionHandler; LanguageClass.Instance().ChangeLanguage(LanguageClass.German); Text = $@"FBXpert V {Assembly.GetAssembly(GetType()).GetName().Version}"; Application.DoEvents(); var cf = FBXInfo.Instance(); cf.MdiParent = this; cf.Show(); _dbe = DbExplorerForm.Instance(this); if (_dbe.ReadDatabaseDefinition()) { Application.DoEvents(); NotifiesClass.Instance().InfoThreshold = eInfoLevel.normal; _dbe.SetCaption(); _dbe.Show(); _dbe.Enabled = false; _dbe.MakeDatabaseTree(false); _dbe.OpenActiveDatabases(); if (NotificationsForm.Instance().Visible) { NotificationsForm.Instance().Close(); } NotifiesClass.Instance().InfoThreshold = eInfoLevel.few; } DbExplorerForm.Instance().Enabled = true; LanguageClass.Instance().ChangeLanguage(LanguageClass.German); }
public int RefreshFields() { if (string.IsNullOrEmpty(ViewObject.Name)) { return(lvFields.Items.Count); } string cmd = SQLStatementsClass.Instance().GetViewFields(DBReg.Version, ViewObject.Name); ViewFieldClass vf = null; lvFields.Items.Clear(); dgExportGrid.Rows.Clear(); try { var con = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(DBReg)); con.Open(); var fcmd = new FbCommand(cmd, con); var dread = fcmd.ExecuteReader(); if (dread.HasRows) { while (dread.Read()) { object ob = dread.GetValue(0); object ob_field_position = dread.GetValue(1); string fieldstr = ob.ToString(); string posstr = ob_field_position.ToString(); string typename = dread.GetValue(3).ToString(); string typelength = dread.GetValue(4).ToString(); vf = new ViewFieldClass() { Name = fieldstr.Trim() }; string[] obarr = { posstr.Trim(), fieldstr.Trim(), typename.Trim(), typelength.Trim() }; object[] obarr_export = { posstr.Trim(), fieldstr.Trim(), true, true }; var lvi = new ListViewItem(obarr) { Tag = vf, Checked = true }; lvFields.Items.Add(lvi); dgExportGrid.Rows.Add(obarr_export); } } con.Close(); } catch (Exception ex) { NotifiesClass.Instance().AddToERROR(BasicClassLibrary.StaticFunctionsClass.DateTimeNowStr() + " ViewManagerForm->RefreshDependenciesFrom->" + ex.Message); } return(lvFields.Items.Count); }
public static string ConvertDesignType(string name, int length) { if (name == "LONG") { switch (length) { case 4: return("NUMBER"); } } else if (name == "TIMESTAMP") { switch (length) { case 8: return("TIMESTAMP"); } } else if (name == "VARYING") { return("VARCHAR2"); } else if (name == "DOUBLE") { switch (length) { case 8: return("DOUBLE PRECISION"); } } else if (name == "DATE") { return("DATE"); } else if (name == "TIME") { return("TIME"); } else if (name == "SHORT") { return("NUMBER"); } else if (name == "BOOLEAN") { return("BOOLEAN"); } else if (name == "BLOB") { return("BLOB"); } NotifiesClass.Instance().AddToERROR("Datatype:" + name + " not defined !!! (StaticVariables->ConvertDiesignType)"); return("UNDEFINED"); }
public void WaitClosed(ConnectionClass cc1, string str) { int n = 0; while (!cc1.ConnectionIsClosed() && (n < 10)) { Thread.Sleep(200); n++; } if (cc1.ConnectionIsClosed()) { return; } if (NotifiesClass.Instance().AllowErrors) { NotifiesClass.Instance().AddToERROR("Timeout for Connection " + cc1.ConnName + " while " + str); } }
private void hsExport_Click(object sender, EventArgs e) { var ew = new ExportWorkers(NotifiesClass.Instance()) { alltables = new List <TableClass>() }; ew.alltables.Clear(); ew.AktDBReg = DBReg; ew.ShowScripting = cbViewInScript.Checked; ew.WriteToFile = cbExportToFile.Checked; if (ew.WriteToFile) { if ((txtFileName.Text.IndexOf(".", StringComparison.Ordinal)) < 0) { txtFileName.Text += ".sql"; } var di = ActFolder.Tag as DirectoryInfo; ew.SQLFileInfo = new FileInfo(di?.FullName + "\\" + txtFileName.Text); ew.CharSet = cbCharSet.SelectedItem as EncodingClass; } else { ew.SQLFileInfo = null; } for (int i = 0; i < selTables.ItemDatas.Count; i++) { var itm = selTables.ItemDatas[i] as ItemDataClass; var tc = itm.Object as TableClass; tc.State = selTables.GetItemCheckState(i); if (tc.State != CheckState.Checked) { continue; } ew.alltables.Add(tc); } ew.StartworkerGetTableData(ew.alltables, DBReg, ew.SQLFileInfo); }
public int RefreshDependenciesFrom() { dsDependencies.Clear(); dgvDependencies.AutoGenerateColumns = true; string cmd_index = SQLStatementsClass.Instance().GetViewManagerDependenciesFROM(DBReg.Version, ViewObject.Name); try { var con = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(DBReg)); FbDataAdapter ds = new FbDataAdapter(cmd_index, con); ds.Fill(dsDependencies); con.Close(); } catch (Exception ex) { NotifiesClass.Instance().AddToERROR(BasicClassLibrary.StaticFunctionsClass.DateTimeNowStr() + " ViewManagerForm->RefreshDependenciesFrom->" + ex.Message); } bsDependencies.DataMember = "Table"; return(dsDependencies.Tables[0].Rows.Count); }
public void SaveConfig() { _dbReg.State = eRegState.none; var tn = _dbReg.GetNode(); tn.Text = _dbReg.Alias; if (BearbeitenMode == EditStateClass.eBearbeiten.eEdit) { var drc = DatabaseDefinitions.Instance().Databases.Find(x => x.Position == _dbReg.Position); } else { _dbReg.Position = DatabaseDefinitions.Instance().Databases.Count + 1; DatabaseDefinitions.Instance().Databases.Add(_dbReg); DataToEdit(); } DatabaseDefinitions.Instance().SerializeCurrent("User changed"); _dbReg.State = Cloned ? eRegState.create : eRegState.update; BearbeitenMode = EditStateClass.eBearbeiten.eEdit; if (_connectionDataChanged) { NotifiesClass.Instance().Notify.RaiseInfo($@"Configuration saved for {_dbReg.Alias}->Proc:{Name}->SaveConfig", StaticVariablesClass.DatabaseConfigDataSaved, (object)_dbReg); DbExplorerForm.Instance().DbExlorerNotify.Notify.RaiseInfo($@"{_dbReg.Alias}->Proc:{Name}->SaveConfig", StaticVariablesClass.DatabaseConfigDataSaved, (object)_dbReg); _connectionDataChanged = false; } if (_dataChanged) { tn.Text = _dbReg.Alias; _dataChanged = false; } if (Cloned) { Close(); } }
public int RefreshDependenciesTo() { string cmd = SQLStatementsClass.Instance().GetDepentenciesGenerators(_dbReg.Version, GeneratorObject.Name); try { dsDependenciesTo.Clear(); dgvDependenciesTo.AutoGenerateColumns = true; var con = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(_dbReg)); var ds = new FbDataAdapter(cmd, con); ds.Fill(dsDependenciesTo); con.Close(); bsDependenciesTo.DataMember = "Table"; return(dsDependenciesTo.Tables[0].Rows.Count); } catch (Exception ex) { NotifiesClass.Instance().AddToERROR($@"{StaticFunctionsClass.DateTimeNowStr()} GeneratorForm -> RefreshDependenciesTo: {ex.Message}"); } return(0); }
public int RefreshMonitorConnections() { GetConnections(); try { string cmd_index = SQLStatementsClass.Instance().GetMonitorConnections(DBReg.Version, cbAllConnections.Checked); dsMonConnections.Clear(); dgvMonConnections.AutoGenerateColumns = true; var con = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(DBReg)); var ds = new FbDataAdapter(cmd_index, con); ds.Fill(dsMonConnections); con.Close(); bsMonConnections.DataMember = "Table"; return(dsMonConnections.Tables[0].Rows.Count); } catch (Exception ex) { NotifiesClass.Instance().AddToERROR(AppStaticFunctionsClass.GetFormattedError($@"{Name}-> RefreshMonitorConnections()", ex)); } bsMonConnections.DataMember = "Table"; return(dsMonConnections.Tables[0].Rows.Count); }
public SQLViewForm1(DBRegistrationClass ca, List <TableClass> actTables, Form mdiParent = null, eColorDesigns appDesign = eColorDesigns.Gray, eColorDesigns developDesign = eColorDesigns.Gray, bool testMode = false) { MdiParent = mdiParent; _dbReg = ca; _actTables = actTables; _appDesign = appDesign; _developDesign = developDesign; InitializeComponent(); var nf = new NotifiesClass(); nf.gaugeNotify.OnRaiseGaugeHandler += new NotifyGauge.RaiseGaugeHandler(GaugeRaised); _localNotifies.AddNotify(nf, "SQLViewForm"); _localNotifies.AddNotify(NotifiesClass.Instance(), "GLOBAL"); _sqLcommand = new SQLCommandsClass(_dbReg, _localNotifies.Find("SQLViewForm")); tabPageSucceeded.Text = "commands succeded DESC"; Meldungen(); Errors(); History(); ClearDevelopDesign(_developDesign); SetDesign(_appDesign); cbTestlauf.Checked = testMode; cbTestlauf.Visible = testMode; }
private SQLCommandsReturnInfoClass ExecSql(HistoryMode toHistory) { dataSet1.Clear(); dgvResults.AutoGenerateColumns = true; if (txtSQL.Text.Length <= 0) { return(new SQLCommandsReturnInfoClass()); } _sqLcommand.SetEncoding(cbEncoding.Text); var ri = _sqLcommand.ExecuteCommandWithGlobalConnection(txtSQL.Lines); lblUsedMs.Text = ri.costs.ToString(); dataSet1 = ri.dataSet; if (dataSet1?.Tables.Count > 0) { bindingSource1.DataSource = dataSet1; bindingSource1.DataMember = "Table"; } else if (ri.lastCommandType == SQLCommandType.select) { NotifiesClass.Instance().AddToERROR("SQLViewForm->ExecSql->No datas selected"); _localNotifies?.AddToERROR("SQLViewForm->ExecSql->No datas selected"); } if (ri.commandDone) { AddToHistory(toHistory, ri.lastSQL); } else { AddToFailedHistory(toHistory, ri.lastSQL); } return(ri); }
public int RefreshDependencies() { dsDependencies.Clear(); dgvDependenciesTo.AutoGenerateColumns = true; string cmd_index = SQLStatementsClass.Instance().GetFieldDependencies(_dbReg.Version, TableObject.Name, FieldObject.Name); try { var con = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(_dbReg)); FbDataAdapter ds = new FbDataAdapter(cmd_index, con); ds.Fill(dsDependencies); con.Close(); bsDependencies.DataMember = "Table"; bsDependencies.DataSource = dsDependencies; return(dsDependencies.Tables[0].Rows.Count); } catch (Exception ex) { NotifiesClass.Instance().AddToERROR($"{StaticFunctionsClass.DateTimeNowStr()}->FieldForm->RefreshDependencies->{ex.Message}"); } return(0); }
private void hsExportStructure_Click(object sender, EventArgs e) { var ew = new ExportWorkers(NotifiesClass.Instance()) { allviews = new List <ViewClass>() }; ew.allviews.Clear(); ew.alltables = new List <TableClass>(); ew.alltables.Clear(); ew.allPKConstraints = new Dictionary <string, PrimaryKeyClass>(); ew.allPKConstraints.Clear(); ew.allFKConstraints = new Dictionary <string, ForeignKeyClass>(); ew.allFKConstraints.Clear(); ew.allDomains = new Dictionary <string, DomainClass>(); ew.allDomains.Clear(); ew.allGenerator = new Dictionary <string, GeneratorClass>(); ew.allGenerator.Clear(); ew.allTrigger = new Dictionary <string, TriggerClass>(); ew.allTrigger.Clear(); ew.allIndeces = new Dictionary <string, IndexClass>(); ew.allIndeces.Clear(); ew.allProcedures = new Dictionary <string, ProcedureClass>(); ew.allProcedures.Clear(); ew.allFunctions = new Dictionary <string, FunctionClass>(); ew.allFunctions.Clear(); ew.AktDBReg = DBReg; ew.ShowScripting = cbViewObjectScript.Checked; ew.WriteToFile = cbObjectExportToFile.Checked; ew.CommitAfterStatement = cbStructureCommit.Checked; ew.CreateConnectionStatement = cbStructureConnectiionStatement.Checked; ew.CreateDatabaseStatement = cbStructureCreateDatabaseStatement.Checked; ew.CreateMode = (rbCREATEObject.Checked) ? eCreateMode.create : eCreateMode.recreate; if (ew.WriteToFile) { if ((txtFileName.Text.IndexOf(".")) < 0) { txtFileName.Text += ".sql"; } var di = ActFolder.Tag as DirectoryInfo; ew.SQLFileInfo = new FileInfo(di.FullName + "\\" + txtFileName.Text); ew.CharSet = cbCharSet.SelectedItem as EncodingClass; } else { ew.SQLFileInfo = null; } ew.StartworkerGetDatabaseStructure(DBReg, ew.SQLFileInfo); foreach (var itm in selExportStructureList.CheckedItemDatasNotNulls) { //if ((itm.Check != CheckState.Checked)||(itm.Object == null)) continue; if (itm.Object.GetType() == typeof(TableClass)) { ew.alltables.AddRange(ExportTableStructure(ew)); ew.StartworkerGetTableStructure(ew.alltables, DBReg, ew.SQLFileInfo); } else if (itm.Object.GetType() == typeof(ViewClass)) { ew.allviews.AddRange(ExportViewStructure(ew)); ew.StartworkerGetViewStructure(ew.allviews, DBReg, ew.SQLFileInfo); } else if (itm.Object.GetType() == typeof(PrimaryKeyClass)) { ExportPKTableStructure(ew); ew.StartworkerGetPKTableStructure(ew.allPKConstraints, DBReg, ew.SQLFileInfo); } else if (itm.Object.GetType() == typeof(ForeignKeyClass)) { ExportFKTableStructure(ew); ew.StartworkerGetFKTableStructure(ew.allFKConstraints, DBReg, ew.SQLFileInfo); } else if (itm.Object.GetType() == typeof(DomainClass)) { ExportDomainStructure(ew); ew.StartworkerGetDomainStructure(ew.allDomains, DBReg, ew.SQLFileInfo); } else if (itm.Object.GetType() == typeof(GeneratorClass)) { ExportGeneratorStructure(ew); ew.StartworkerGetGeneratorStructure(ew.allGenerator, DBReg, ew.SQLFileInfo); } else if (itm.Object.GetType() == typeof(IndexClass)) { ExportIndecesStructure(ew); ew.StartworkerGetIndecesStructure(ew.allIndeces, DBReg, ew.SQLFileInfo); } else if (itm.Object.GetType() == typeof(TriggerClass)) { ExportTriggerStructure(ew); ew.StartworkerGetTriggerStructure(ew.allTrigger, DBReg, ew.SQLFileInfo); } else if (itm.Object.GetType() == typeof(ProcedureClass)) { ExportProcedureStructure(ew); ew.StartworkerGetProcedureDefinitionStructure(ew.allProcedures, DBReg, ew.SQLFileInfo); ew.StartworkerGetProcedureStructure(ew.allProcedures, DBReg, ew.SQLFileInfo); } else if (itm.Object.GetType() == typeof(FunctionClass)) { ExportFunctionStructure(ew); ew.StartworkerGetFunctionDefinitionStructure(ew.allFunctions, DBReg, ew.SQLFileInfo); ew.StartworkerGetFunctionStructure(ew.allFunctions, DBReg, ew.SQLFileInfo); } } ew.WaitForWorker(); ew.MakeScript(); NotificationsForm.Instance().Close(); }
public static string ConvertINTERNALType_TO_SQLType(string name, int length) { switch (name) { case "LONG": return("INTEGER"); //HE switch (length) { case 4: return("INTEGER"); } break; case "INT64": return("BIGINT"); //HE switch (length) { case 8: return("BIGINT"); } break; case "TIMESTAMP": return("TIMESTAMP"); //HE switch (length) { case 8: return("TIMESTAMP"); } break; case "TIME": return("TIME"); default: if ((name == "VARYING") || (name.StartsWith("ISO")) || (name.StartsWith("UTF")) || (name.StartsWith("ASCII")) || (name.StartsWith("TEXT"))) { return("VARCHAR(" + length + ")"); } else if (name == "DOUBLE") { return("DOUBLE PRECISION"); //HE switch (length) { case 8: return("DOUBLE PRECISION"); } } else if (name == "DATE") { return("DATE"); } else if (name == "SHORT") { return("NUMERIC"); } else if (name == "FLOAT") { return("FLOAT"); } else if (name == "BOOLEAN") { return("BOOLEAN"); } else if (name == "BLOB") { return("BLOB"); } break; } NotifiesClass.Instance().AddToERROR("Datatype:" + name + " not defined !!! (StaticVariables->ConvertType)"); return("UNDEFINED"); }
public static TreeNode GetNewNode(string name) { TreeNode node; ContextMenuStrip cmnull = new ContextMenuStrip(); switch (name.ToUpper()) { case StaticVariablesClass.DatabaseKeyStr: node = new TreeNode() { Name = name.ToUpper(), Text = "Database", Tag = new DBRegistrationClass(), //ContextMenuStrip = ContextMenusClass.Instance().cmsDatabase, ImageIndex = (int)eImageIndex.DATABASE_INACTIVE }; return(node); case StaticVariablesClass.ProceduresKeyGroupStr: node = new TreeNode() { Name = name.ToUpper(), Text = "Procedures", Tag = new ProceduresGroupClass(), //ContextMenuStrip = ContextMenusClass.Instance().cmsProcedureGroup, ImageIndex = (int)eImageIndex.PROCEDURE }; return(node); case StaticVariablesClass.ProceduresKeyStr: node = new TreeNode() { Name = name.ToUpper(), Text = "Procedures", Tag = new ProcedureClass(), //ContextMenuStrip = ContextMenusClass.Instance().cmsProcedure, ImageIndex = (int)eImageIndex.PROCEDURE }; return(node); case StaticVariablesClass.FunctionsKeyGroupStr: node = new TreeNode() { Name = name.ToUpper(), Text = "User defined functions", Tag = new UserDefinedFunctionGroupClass(), //ContextMenuStrip = ContextMenusClass.Instance().cmsFunctionGroup, ImageIndex = (int)eImageIndex.FUNCTION }; return(node); case StaticVariablesClass.UserDefinedFunctionsKeyGroupStr: node = new TreeNode() { Name = name.ToUpper(), Text = "User defined functions", Tag = new UserDefinedFunctionGroupClass(), //ContextMenuStrip = ContextMenusClass.Instance().cmsUserDefinedFunctionGroup, ImageIndex = (int)eImageIndex.FUNCTION }; return(node); case StaticVariablesClass.ForeignKeyGroupStr: node = new TreeNode() { Name = name.ToUpper(), //ContextMenuStrip = ContextMenusClass.Instance().cmsForeignKeyGroup, Text = "Foreign Keys", Tag = new ForeignKeyGroupClass(), ImageIndex = (int)eImageIndex.KEYS }; return(node); case StaticVariablesClass.PrimaryKeyGroupStr: node = new TreeNode() { Name = name.ToUpper(), //ContextMenuStrip = ContextMenusClass.Instance().cmsPrimaryKeyGroup, Text = "Primary Keys", Tag = new PrimaryKeyGroupClass(), ImageIndex = (int)eImageIndex.PRIMARYKEY }; return(node); case StaticVariablesClass.PrimaryKeyStr: node = new TreeNode() { Name = name.ToUpper(), //ContextMenuStrip = ContextMenusClass.Instance().cmsPrimaryKey, Text = "Primary Key", Tag = new PrimaryKeyClass(), ImageIndex = (int)eImageIndex.PRIMARYKEY }; return(node); case StaticVariablesClass.ConstraintsKeyGroupStr: node = new TreeNode() { Name = name.ToUpper(), //ContextMenuStrip = ContextMenusClass.Instance().cmsContraintsGroup, Text = "Constraints", Tag = new ConstraintsGroupClass(), ImageIndex = (int)eImageIndex.KEYS }; return(node); case StaticVariablesClass.ConstraintsKeyStr: node = new TreeNode() { //ContextMenuStrip = ContextMenusClass.Instance().cmsContraints, Text = "Constraint", Name = name.ToUpper(), Tag = new ConstraintsClass(), ImageIndex = (int)eImageIndex.KEYS }; return(node); case StaticVariablesClass.FunctionsKeyStr: node = new TreeNode() { //ContextMenuStrip = ContextMenusClass.Instance().cmsFunction, Text = "Function", Name = name.ToUpper(), Tag = new FunctionClass(), ImageIndex = (int)eImageIndex.FUNCTION }; return(node); case StaticVariablesClass.UserDefinedFunctionsKeyStr: node = new TreeNode() { //ContextMenuStrip = ContextMenusClass.Instance().cmsUserDefinedFunction, Text = "User defined function", Name = name.ToUpper(), Tag = new UserDefinedFunctionClass(), ImageIndex = (int)eImageIndex.FUNCTION }; return(node); case StaticVariablesClass.ForeignKeyStr: node = new TreeNode() { //ContextMenuStrip = ContextMenusClass.Instance().cmsForeignKey, Text = "Foreign Key", Tag = new ForeignKeyClass(), Name = name.ToUpper(), ImageIndex = (int)eImageIndex.FOREIGNKEY }; return(node); case StaticVariablesClass.FieldsKeyStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Field", Tag = new TableFieldClass(), Name = name.ToUpper(), ImageIndex = (int)eImageIndex.FIELDS }; return(node); case StaticVariablesClass.FieldsKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Fields", Name = name.ToUpper(), Tag = new TableFieldGroupClass(), ImageIndex = (int)eImageIndex.FIELDS }; return(node); case StaticVariablesClass.ViewFieldsKeyStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Field", Tag = new ViewFieldClass(), Name = name.ToUpper(), ImageIndex = (int)eImageIndex.FIELDS }; return(node); case StaticVariablesClass.ViewFieldsKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Fields", Name = name.ToUpper(), Tag = new ViewFieldGroupClass(), ImageIndex = (int)eImageIndex.FIELDS }; return(node); case StaticVariablesClass.UniquesKeyGroupStr: node = new TreeNode() { ContextMenuStrip = cmnull, Text = "Uniques", // Name = StaticVariablesClass.UniquesKeyGroupStr, Tag = new UniqueConstraintsGroupClass(), ImageIndex = (int)eImageIndex.UNIQUE }; return(node); case StaticVariablesClass.UniquesKeyStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Unique", Name = name.ToUpper(), Tag = new ConstraintsClass(), ImageIndex = (int)eImageIndex.UNIQUE }; return(node); case StaticVariablesClass.NotNullKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Not Nulls", Name = name.ToUpper(), Tag = new NotNullConstraintsGroupClass(), ImageIndex = (int)eImageIndex.NOTNULL }; return(node); case StaticVariablesClass.NotNullKeyStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Not Null", Name = name.ToUpper(), Tag = new ConstraintsClass(), ImageIndex = (int)eImageIndex.NOTNULL }; return(node); case StaticVariablesClass.ChecksKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Checks", Name = name.ToUpper(), Tag = new ChecksKeyConstraintsGroupClass(), ImageIndex = (int)eImageIndex.CHECK }; return(node); case StaticVariablesClass.ChecksKeyStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Check", Name = name.ToUpper(), Tag = new ConstraintsClass(), ImageIndex = (int)eImageIndex.CHECK }; return(node); case StaticVariablesClass.DependenciesKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Dependencies", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCY }; return(node); case StaticVariablesClass.DependenciesTablesKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Tables", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCY }; return(node); case StaticVariablesClass.DependenciesToTablesKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Dependencies To", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCYTO }; return(node); case StaticVariablesClass.DependenciesFromTablesKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Dependencies From", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCYFROM }; return(node); case StaticVariablesClass.DependenciesTriggersKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Triggers", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCY }; return(node); case StaticVariablesClass.DependenciesToTriggersKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Dependencies To", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCYTO }; return(node); case StaticVariablesClass.DependenciesFromTriggersKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Dependencies From", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCYFROM }; return(node); case StaticVariablesClass.DependenciesToTriggersKeyStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Dependency to", Name = name.ToUpper(), Tag = new DependencyClass(), ImageIndex = (int)eImageIndex.DEPENDENCYTO }; return(node); case StaticVariablesClass.DependenciesFromTriggersKeyStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Dependency from", Name = name.ToUpper(), Tag = new DependencyClass(), ImageIndex = (int)eImageIndex.DEPENDENCYFROM }; return(node); case StaticVariablesClass.DependenciesViewsKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Views", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCY }; return(node); case StaticVariablesClass.DependenciesToViewsKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Depends on Views", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCYTO }; return(node); case StaticVariablesClass.DependenciesToViewsKeyStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Depends to View", Name = name.ToUpper(), Tag = new DependencyClass(), ImageIndex = (int)eImageIndex.DEPENDENCYTO }; return(node); case StaticVariablesClass.DependenciesFromViewsKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Dependencies from Views", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCYFROM }; return(node); case StaticVariablesClass.DependenciesFromViewsKeyStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Depends from View", Name = name.ToUpper(), Tag = new DependencyClass(), ImageIndex = (int)eImageIndex.DEPENDENCYFROM }; return(node); case StaticVariablesClass.DependenciesFromKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Dependencies from ", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCYFROM }; return(node); case StaticVariablesClass.DependenciesFromKeyStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Depends from ", Name = name.ToUpper(), Tag = new DependencyClass(), ImageIndex = (int)eImageIndex.DEPENDENCYFROM }; return(node); case StaticVariablesClass.DependenciesToKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Dependencies to ", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCYTO }; return(node); case StaticVariablesClass.DependenciesToKeyStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Depends to ", Name = name.ToUpper(), Tag = new DependencyClass(), ImageIndex = (int)eImageIndex.DEPENDENCYTO }; return(node); case StaticVariablesClass.DependenciesProceduresKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Procedures", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCY }; return(node); case StaticVariablesClass.DependenciesToProceduresKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Depends on Procedures", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCYTO }; return(node); case StaticVariablesClass.DependenciesToProceduresKeyStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Depends on procedure", Name = name.ToUpper(), Tag = new DependencyClass(), ImageIndex = (int)eImageIndex.DEPENDENCYTO }; return(node); case StaticVariablesClass.DependenciesFromProceduresKeyGroupStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Dependencies From", Name = name.ToUpper(), Tag = new DependencyGroupClass(), ImageIndex = (int)eImageIndex.DEPENDENCYFROM }; return(node); case StaticVariablesClass.DependenciesFromProceduresKeyStr: node = new TreeNode() { // ContextMenuStrip = cmnull, Text = "Depends from procedure", Name = name.ToUpper(), Tag = new DependencyClass(), ImageIndex = (int)eImageIndex.DEPENDENCYFROM }; return(node); case StaticVariablesClass.TriggersKeyGroupStr: node = new TreeNode() { Text = "Triggers", Name = name.ToUpper(), Tag = new TriggerGroupClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsTriggerGroup, ImageIndex = (int)eImageIndex.TRIGGERS }; return(node); case StaticVariablesClass.TriggersKeyStr: node = new TreeNode() { //ContextMenuStrip = ContextMenusClass.Instance().cmsTrigger, Text = "Trigger", Tag = new TriggerClass(), Name = name.ToUpper(), ImageIndex = (int)eImageIndex.TRIGGERS }; return(node); case StaticVariablesClass.IndicesKeyGroupStr: node = new TreeNode() { Text = "Indices", Name = name.ToUpper(), Tag = new IndexGroupClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsIndicesGroup, ImageIndex = (int)eImageIndex.INDEX }; return(node); case StaticVariablesClass.IndicesKeyStr: node = new TreeNode() { // ContextMenuStrip = ContextMenusClass.Instance().cmsIndices, Text = "Index", Tag = new IndexClass(), Name = name.ToUpper(), ImageIndex = (int)eImageIndex.INDEX }; return(node); case StaticVariablesClass.RolesKeyGroupStr: node = new TreeNode() { Name = name.ToUpper(), Text = "Roles", Tag = new RoleGroupClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsRolesGroup, ImageIndex = (int)eImageIndex.ROLES }; return(node); case StaticVariablesClass.RolesKeyStr: node = new TreeNode() { // ContextMenuStrip = ContextMenusClass.Instance().cmsRoles, Text = "Role", Tag = new RoleClass(), Name = name.ToUpper(), ImageIndex = (int)eImageIndex.ROLES }; return(node); case StaticVariablesClass.GeneratorsKeyGroupStr: node = new TreeNode() { Text = "Generators", Name = name.ToUpper(), Tag = new GeneratorGroupClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsGeneratorGroup, ImageIndex = (int)eImageIndex.GENERATORS }; return(node); case StaticVariablesClass.GeneratorsKeyStr: node = new TreeNode() { Text = "Generators", Name = name.ToUpper(), Tag = new GeneratorClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsGenerator, ImageIndex = (int)eImageIndex.GENERATORS }; return(node); case StaticVariablesClass.CommonTablesKeyGroupStr: node = new TreeNode() { Name = name.ToUpper(), Text = "Tables", Tag = new TableGroupClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsTableGroup, ImageIndex = (int)eImageIndex.TABLES }; return(node); case StaticVariablesClass.TablesKeyStr: node = new TreeNode() { Name = name.ToUpper(), Text = "Table", Tag = new TableClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsTable, ImageIndex = (int)eImageIndex.TABLES }; return(node); case StaticVariablesClass.SystemTablesKeyGroupStr: node = new TreeNode() { Name = name.ToUpper(), Text = "System Tables", Tag = new SystemTableGroupClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsSystemTableGroup, ImageIndex = (int)eImageIndex.TABLES }; return(node); case StaticVariablesClass.SystemTablesKeyStr: node = new TreeNode() { Name = name.ToUpper(), Text = "Systemtable", Tag = new SystemTableClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsSystemTable, ImageIndex = (int)eImageIndex.TABLES }; return(node); case StaticVariablesClass.ViewsKeyGroupStr: node = new TreeNode() { Name = name.ToUpper(), Text = "Views", Tag = new ViewGroupClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsViewGroup, ImageIndex = (int)eImageIndex.VIEW }; return(node); case StaticVariablesClass.ViewsKeyStr: node = new TreeNode() { Name = name.ToUpper(), Text = "View", Tag = new ViewClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsView, ImageIndex = (int)eImageIndex.VIEW }; return(node); case StaticVariablesClass.ConstraintsViewsKeyGroupStr: node = new TreeNode() { Name = name.ToUpper(), Text = "Constraints Views", Tag = new ViewGroupClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsViewGroup, ImageIndex = (int)eImageIndex.VIEW }; return(node); case StaticVariablesClass.ConstraintsViewsKeyStr: node = new TreeNode() { Name = name.ToUpper(), Text = "Constraints for View", Tag = new ViewClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsView, ImageIndex = (int)eImageIndex.VIEW }; return(node); case StaticVariablesClass.DomainsKeyGroupStr: node = new TreeNode() { Name = name.ToUpper(), Text = "Domains", Tag = new DomainGroupClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsDomainGroup, ImageIndex = (int)eImageIndex.DOMAIN }; return(node); case StaticVariablesClass.DomainsKeyStr: node = new TreeNode() { Name = name.ToUpper(), Text = "Domain", Tag = new DomainClass(), // ContextMenuStrip = ContextMenusClass.Instance().cmsDomain, ImageIndex = (int)eImageIndex.DOMAIN }; return(node); } NotifiesClass.Instance().AddToERROR("DataCLassFactory->GetNode->" + name + " not created", "GetNode"); return(null); }
public int RefreshDatas(string cmd) { int errorsCnt = 0; int errorsAllowed = BasicClassLibrary.StaticFunctionsClass.ToIntDef(txtMaxAllowedErrors.Text, 0); if (string.IsNullOrEmpty(ViewObject.Name)) { return(dsViewContent.Tables[0].Rows.Count); } try { long.TryParse(txtMaxRows.Text, out var maxRows); dgvResults.AutoGenerateColumns = true; GetDataWorker.ReportProgress(1, "Reading data..."); long skip = 0; if (_dataConnection != null) { if (_dataConnection.State != System.Data.ConnectionState.Closed) { _dataConnection.Close(); } } _dataConnection = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(DBReg)); _dataConnection.Open(); var cnt = DBReg.SkipForSelect; var sk = DBReg.SkipForSelect; if ((maxRows > 0) && (cnt > maxRows)) { cnt = maxRows; sk = cnt; } string cmds = string.Empty; while ((cnt >= sk) && (skip < maxRows || maxRows <= 0)) { try { if (this.GetDataWorker.CancellationPending) { return(0); } cmds = $@"SELECT FIRST {sk} SKIP {skip} {cmd};"; var ds = new FbDataAdapter(cmds, _dataConnection); cnt = ds.Fill(dsViewContent); GetDataWorker.ReportProgress(1, "..." + skip.ToString()); skip += cnt; } catch (Exception ex) { _localNofity.AddToERROR($@"{BasicClassLibrary.StaticFunctionsClass.DateTimeNowStr()}->{this.Name}->RefreshDatas({cmds}), msg:{ex.Message}"); errorsCnt++; if (errorsCnt > errorsAllowed) { GetDataWorker.CancelAsync(); } } } _dataConnection.Close(); } catch (Exception ex) { NotifiesClass.Instance().AddToERROR($@"{BasicClassLibrary.StaticFunctionsClass.DateTimeNowStr()}->{this.Name}->RefreshDatas({cmd}), msg:{ex.Message}"); } return(dsViewContent.Tables[0].Rows.Count); }
private bool CreateDatabase(string sqlCmd) { /* * CREATE DATABASE 'localhost:D:\Data\kj\KJFERT59.FDB' * USER 'SYSDBA' PASSWORD 'masterkey' * PAGE_SIZE 8192 * DEFAULT CHARACTER SET NONE; */ string sql = sqlCmd.ToUpper(); string location = "D:\\Data\\test111.FDB"; string server = "localhost"; string user = "******"; string password = "******"; string packetsize = "8192"; int inx = sql.IndexOf("CREATE DATABASE ", StringComparison.Ordinal); if (inx >= 0) { string cmd3 = sqlCmd.Substring(inx + 16); int inx2 = cmd3.IndexOf(" ", StringComparison.Ordinal); string arg = cmd3.Substring(0, inx2); int inx3 = arg.IndexOf(":\\", StringComparison.Ordinal); int inx4 = arg.IndexOf(":", StringComparison.Ordinal); if (inx4 < inx3) { //server server = arg.Substring(0, inx4).Replace("'", ""); location = arg.Substring(inx4 + 1); location = location.Replace("'", ""); } else { //nur dateipfad server = "localhost"; location = arg.Replace("'", ""); } } inx = sql.IndexOf("USER ", StringComparison.Ordinal); if (inx >= 0) { string cmd3 = sqlCmd.Substring(inx + 5); int inx2 = cmd3.IndexOf(" ", StringComparison.Ordinal); string arg = cmd3.Substring(0, inx2); user = arg.Replace("'", ""); } inx = sql.IndexOf("PASSWORD ", StringComparison.Ordinal); if (inx >= 0) { string cmd3 = sqlCmd.Substring(inx + 9); int inx2 = cmd3.IndexOf(" ", StringComparison.Ordinal); string arg = cmd3.Substring(0, inx2); password = arg.Replace("'", ""); } inx = sql.IndexOf("PAGE_SIZE ", StringComparison.Ordinal); if (inx >= 0) { string cmd3 = sqlCmd.Substring(inx + 10); int inx2 = cmd3.IndexOf(" ", StringComparison.Ordinal); string arg = cmd3.Substring(0, inx2); packetsize = arg; } try { _parentNotifies?.AddToINFO(StaticFunctionsClass.DateTimeNowStr() + " ...Creating new database via script " + server + ":" + location); DBProviderSet.CreateDatabase(location, server, user, password, StaticFunctionsClass.ToIntDef(packetsize, AppSettingsClass.Instance().DatabaseSettings.DefaultPacketSize)); } catch (Exception ex) { NotifiesClass.Instance().AddToERROR(AppStaticFunctionsClass.GetFormattedError($@"{sqlCmd}-> CreateDatabase()", ex)); } return(true); }