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; }
public IMPORTDataForm(Form parent, DBRegistrationClass drc) { InitializeComponent(); this.MdiParent = parent; localNotify = new NotifiesClass() { ErrorGranularity = eMessageGranularity.never }; localNotify.Register4Info(InfoRaised); localNotify.Register4Error(ErrorRaised); DBReg = drc; var tableObjects = StaticTreeClass.Instance().GetAllNonSystemTableObjectsComplete(DBReg); if (tableObjects.Count <= 0) { return; } foreach (var tc in tableObjects.Values) { selTables.Add(tc.ToString(), CheckState.Unchecked, tc); } selTables.CheckChecks(); SelectAllTableFields(); }
void ErrorRaised(object sender, MessageEventArgs k) { _cmdError++; tabERRORS.Text = $@"Errors ({_cmdError})"; if ((txtErrIntervall.Inhalt.Length > 0) && (cbErrAutoclear.Checked)) { if (rtfERRORS.Lines.Length > Int32.Parse(txtErrIntervall.Inhalt)) { rtfERRORS.Clear(); } } if (rbErrAppend.Checked) { rtfERRORS.AppendText(k.Meldung); if (cbAutoSrcollErr.Checked) { rtfERRORS.SelectionStart = rtfERRORS.TextLength; rtfERRORS.Select(rtfERRORS.TextLength, 0); rtfERRORS.ScrollToCaret(); rtfERRORS.Refresh(); } } else { rtfERRORS.Text.Insert(0, k.Meldung); } NotifiesClass nf = _localNotifies.Find("GLOBAL"); if (nf != null) { nf.Notify.OnRaiseError(k); } }
public FieldForm(DBRegistrationClass dbReg, Form parent, TreeNode tableNode, TableFieldClass fieldObject, NotifiesClass lnotify, StateClasses.EditStateClass.eBearbeiten bearbeitenMode) { InitializeComponent(); DataFilled = false; this.MdiParent = parent; _dbReg = dbReg; TableNode = tableNode; var tc = (TableClass)tableNode.Tag; TableObject = tc.Clone() as TableClass; BearbeitenMode = bearbeitenMode; FillCombos(); if (BearbeitenMode == StateClasses.EditStateClass.eBearbeiten.eInsert) { NewFieldObject(); } else { FieldObject = fieldObject; FieldObject.IsPrimary = TableObject.IsPrimary(FieldObject.Name); FieldObject.Domain.NotNull = TableObject.IsNotNull(FieldObject.Name); FieldObject.TableName = TableObject.Name; } OrgFieldObject = FieldObject.DeepClone(); ObjectToEdit(FieldObject); _localTableNotify = (lnotify == null) ? new NotifiesClass() : lnotify; DataFilled = false; _localTableNotify.Register4Info(TableInfoRaised); localNotify.Register4Info(InfoRaised); localNotify.Register4Error(ErrorRaised); }
public ReportDesignForm(Form parent, DBRegistrationClass dbReg, NotifiesClass notifies) { InitializeComponent(); _notifies = notifies; _dbReg = dbReg; SetMdiParent(parent); }
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 SQLScriptingClassOLD(DBRegistrationClass drc, string connectionName = "SCRIPT", NotifiesClass pNotifies = null, NotifiesClass eventNotifies = null) { _parentNotifies = pNotifies; _eventNotifies = eventNotifies; _connectionName = connectionName; _drc = drc; _connstr = ConnectionStrings.Instance().MakeConnectionString(_drc); _aktCommand = new SCRIPTCommandClass(); }
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); }
private void EXPORTDataForm_FormClosing(object sender, FormClosingEventArgs e) { this.WindowState = FormWindowState.Normal; if (localNotify == null) { return; } localNotify.Notify.OnRaiseInfoHandler -= new NotifyInfos.RaiseNotifyHandler(InfoRaised); localNotify.Notify.OnRaiseErrorHandler -= new NotifyInfos.RaiseNotifyHandler(ErrorRaised); localNotify = null; }
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 SelectDefaultForm(Form parent, NotifiesClass locNotify) { InitializeComponent(); this.MdiParent = parent; localNotify = locNotify; cbDefaults.Items.Clear(); cbDefaults.Items.Add("CURRENT_USER"); cbDefaults.Items.Add("CURRENT_DATE"); cbDefaults.Items.Add("CURRENT_TIMESTAMP"); cbDefaults.Items.Add("CURRENT_TIME"); cbDefaults.Items.Add("CURRENT_ROLE"); cbDefaults.Items.Add("CURRENT_PATH"); cbDefaults.SelectedIndex = 0; }
public SelectDefaultForm(Form parent, NotifiesClass locNotify, string key, string[] items) { InitializeComponent(); this.MdiParent = parent; localNotify = locNotify; _key = key; cbDefaults.Items.Clear(); foreach (string s in items) { cbDefaults.Items.Add(s); } cbDefaults.SelectedIndex = 0; }
public MeasurementClass(MeasurementConfigClass measConfig, bool worker) { mcc = measConfig; nf = new NotifiesClass(); nf.Register4Info(InfoRaised); nf.Register4Error(ErrorRaised); if (worker) { measWorker = new System.ComponentModel.BackgroundWorker(); this.measWorker.WorkerReportsProgress = true; this.measWorker.WorkerSupportsCancellation = true; this.measWorker.DoWork += new System.ComponentModel.DoWorkEventHandler(this.measWorker_DoWork); this.measWorker.ProgressChanged += new System.ComponentModel.ProgressChangedEventHandler(this.measWorker_ProgressChanged); this.measWorker.RunWorkerCompleted += new System.ComponentModel.RunWorkerCompletedEventHandler(this.measWorker_RunWorkerCompleted); } }
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; }
public CreateNewTableForm(DBRegistrationClass dbReg, Form parent, NotifiesClass lnotify) { InitializeComponent(); MdiParent = parent; _dbReg = dbReg; _tableObject = new TableClass(); _tableObject.Name = "NEW_TABLE"; _fieldObject = new TableFieldClass(); _fieldObject.Name = "ID"; //_fieldObject.RawType = "INTEGER"; _fieldObject.Domain.Name = "ID"; _fieldObject.Domain.RawType = "INTEGER"; _localTableNotify = lnotify; _dataFilled = false; DataToEdit(); cbPrimaryKey.Enabled = true; _localTableNotify.Notify.OnRaiseInfoHandler += new NotifyInfos.RaiseNotifyHandler(TableInfoRaised); _localNotify.Notify.OnRaiseInfoHandler += new NotifyInfos.RaiseNotifyHandler(InfoRaised); _localNotify.Notify.OnRaiseErrorHandler += new NotifyInfos.RaiseNotifyHandler(ErrorRaised); }
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); }
public EXPORTDataForm(Form parent, DBRegistrationClass drc) { InitializeComponent(); this.MdiParent = parent; localNotify = new NotifiesClass() { NotifyType = eNotifyType.ErrorWithoutMessage, AllowErrors = false }; localNotify.Notify.OnRaiseInfoHandler += new NotifyInfos.RaiseNotifyHandler(InfoRaised); localNotify.Notify.OnRaiseErrorHandler += new NotifyInfos.RaiseNotifyHandler(ErrorRaised); DBReg = drc; var viewobjects = StaticTreeClass.GetViewObjects(DBReg); var tableObjects = StaticTreeClass.GetAllTableObjectsComplete(DBReg); var domainObjects = StaticTreeClass.GetDomainObjects(DBReg); var generatorObjects = StaticTreeClass.GetGeneratorObjects(DBReg); var indecesObjects = StaticTreeClass.GetIndecesObjects(DBReg); var triggerObjects = StaticTreeClass.GetTriggerObjects(DBReg); //var procedureObjects = StaticTreeClass.GetAllProcedureObjects(DBReg); var procedureObjects = StaticTreeClass.GetProcedureObjects(DBReg); var functionObjects = StaticTreeClass.GetInternalFunctionObjects(DBReg); if (tableObjects.Count <= 0) { return; } foreach (var tc in tableObjects.Values) { selTables.Add(tc.ToString(), CheckState.Unchecked, tc); } selTables.CheckChecks(); foreach (var tc in tableObjects.Values) { selStructureTables.Add(tc.ToString(), CheckState.Unchecked, tc); } selStructureTables.CheckChecks(); SelectAllTableFields(); foreach (var tc in viewobjects.Values) { selStructureViews.Add(tc.ToString(), CheckState.Unchecked, tc); } selStructureViews.CheckChecks(); foreach (var tc in domainObjects.Values) { if ((tc.ToString().StartsWith("RDB$")) || (tc.ToString().StartsWith("SEC$")) || (tc.ToString().StartsWith("MON$"))) { continue; } selDomains.Add(tc.ToString(), CheckState.Unchecked, tc); } selDomains.CheckChecks(); foreach (var tc in generatorObjects.Values) { if ((tc.ToString().StartsWith("RDB$")) || (tc.ToString().StartsWith("SEC$")) || (tc.ToString().StartsWith("MON$"))) { continue; } selGenerators.Add(tc.ToString(), CheckState.Unchecked, tc); } selGenerators.CheckChecks(); foreach (var tc in triggerObjects.Values) { selTriggerStructure.Add(tc.ToString(), CheckState.Unchecked, tc); } selTriggerStructure.CheckChecks(); foreach (var tc in indecesObjects.Values) { selIndeces.Add(tc.ToString(), CheckState.Unchecked, tc); } selIndeces.CheckChecks(); foreach (var tc in procedureObjects.Values) { selProceduresStructure.Add(tc.ToString(), CheckState.Unchecked, tc); } selProceduresStructure.CheckChecks(); foreach (var tc in functionObjects.Values) { selFunctionsStructure.Add(tc.ToString(), CheckState.Unchecked, tc); } selFunctionsStructure.CheckChecks(); var itm = selTables.ItemDatas[0] as ItemDataClass; TableObject = itm.Object as TableClass; selExportStructureList.AllowMultipleChecks = true; selExportStructureList.Add("Domains", CheckState.Checked, new DomainClass()); selExportStructureList.Add("UDFs", CheckState.Checked, new UserDefinedFunctionClass()); selExportStructureList.Add("Generators", CheckState.Checked, new GeneratorClass()); selExportStructureList.Add("Procedures", CheckState.Checked, new ProcedureClass()); selExportStructureList.Add("Functions", CheckState.Checked, new FunctionClass()); selExportStructureList.Add("Tables", CheckState.Checked, new TableClass()); selExportStructureList.Add("Views", CheckState.Checked, new ViewClass()); selExportStructureList.Add("Check constraints", CheckState.Checked, new ChecksClass()); selExportStructureList.Add("Unique constraints", CheckState.Checked, new UniquesClass()); selExportStructureList.Add("Primary keys", CheckState.Checked, new PrimaryKeyClass()); selExportStructureList.Add("Foreign keys", CheckState.Checked, new ForeignKeyClass()); selExportStructureList.Add("Indices", CheckState.Checked, new IndexClass()); selExportStructureList.Add("Triggers", CheckState.Checked, new TriggerClass()); selExportStructureList.Add("UDF descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Generator descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Procedure descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Table descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Table field descriptions", CheckState.Checked, new object()); selExportStructureList.Add("View descriptions", CheckState.Checked, new object()); selExportStructureList.Add("View field descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Index descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Trigger descriptions", CheckState.Checked, new object()); selExportStructureList.Add("Procedure parameter descriptions", CheckState.Checked, new object()); }
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 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 void DoCreateAlter(IList <string> cmd, DBRegistrationClass DBReg, NotifiesClass _localNofity, string Name) { var SQLcommand = new SQLCommandsClass(DBReg, _localNofity); var ri = SQLcommand.ExecuteCommand(cmd, true); }
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); }
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); }
static public long SendResultNotify(List <SQLCommandsReturnInfoClass> riList, NotifiesClass notify) { long costs = 0; foreach (var ri in riList) { costs += ri.costs; if (ri.commandDone) { notify.Notify.RaiseInfo($@"Done: {ri.lastSQL}{Environment.NewLine}", StaticVariablesClass.ReloadFields); } else { notify.Notify.RaiseError($@"ERROR: {ri.lastSQL}->{ri.lastError}{Environment.NewLine}", StaticVariablesClass.ReloadFields); } } return(costs); }