private void Restart() { fctSQL.AppendText($@"{StaticFunctionsClass.DateTimeNowStr()} Event tracking stopped...{Environment.NewLine}"); hsTracking.Marked = false; List <string> events = new List <string>(); foreach (ListViewItem lvi in lvEvents.Items) { if (string.IsNullOrEmpty(lvi.Text)) { continue; } events.Add(lvi.Text); } if (events.Count > 0) { revent.CancelEvents(); revent.QueueEvents(events.ToArray()); //revent.QueueEvents(new string[] { "new_user","update_user" }); fctSQL.AppendText($@"{StaticFunctionsClass.DateTimeNowStr()} Event tracking restarted...{Environment.NewLine}"); hsTracking.Marked = true; } else { fctSQL.AppendText($@"{StaticFunctionsClass.DateTimeNowStr()} No events will be tracked !!!{Environment.NewLine}"); } }
public string GetTypeString(DBDataTypes type, string fieldlength, string fieldprec, string fieldscale) { if (type.GetType() == typeof(DBVarchar)) { int length = StaticFunctionsClass.ToIntDef(fieldlength, 0); if (length <= 0) { length = StaticFunctionsClass.ToIntDef(fieldlength, 0); } return($@"VARCHAR({length})"); } else if (type.GetType() == typeof(DBNumeric)) { // NUMERIC(8, 3) int prec = StaticFunctionsClass.ToIntDef(fieldprec, 0); int digits = StaticFunctionsClass.ToIntDef(fieldscale, 0); if (digits >= prec) { txtPrecisionLength.Text = "1"; txtScale.Text = "0"; prec = 1; digits = 0; } return($@"NUMERIC({prec},{digits})"); } return(type.ToString()); }
private void SpaltenNotify_SpaltenOnRaiseInfoHandler(object sender, MessageEventArgs k) { if (dgvResults.Columns.Count <= 0) { return; } if (k.Key.ToString() == SESpaltenEditor.Consts.ChangeCheckKey) { int n = StaticFunctionsClass.ToIntDef(k.Meldung, -1); if ((n >= 0) && (dgvResults.Columns.Count > n)) { dgvResults.Columns[n].Visible = (bool)k.Data; } } else if (k.Key.ToString() == SESpaltenEditor.Consts.SwapItemKey) { //Columns swapped Point pt = (Point)k.Data; int d1 = dgvResults.Columns[pt.X].DisplayIndex; int d2 = dgvResults.Columns[pt.Y].DisplayIndex; dgvResults.Columns[pt.X].DisplayIndex = d2; dgvResults.Columns[pt.Y].DisplayIndex = d1; } else if (k.Key.ToString() == SESpaltenEditor.Consts.CloseForm) { gridStore.StoreGridDesign(); } }
public int RefreshDependenciesTo() { string cmd_index0 = "SELECT RDB$DEPENDENCIES.RDB$FIELD_NAME as Field ,RDB$DEPENDENCIES.RDB$DEPENDENT_NAME as DepentTo,CASE RDB$DEPENDENCIES.RDB$DEPENDENT_TYPE"; string case0 = EnumClass.Instance.GetDependenciesTypeSQLCase() + " AS DependentType FROM RDB$DEPENDENCIES"; string cmd_index_where = "WHERE UPPER(RDB$DEPENDENCIES.RDB$DEPENDED_ON_NAME) = '" + TriggerObject.Name + "' AND RDB$DEPENDENCIES.RDB$FIELD_NAME IS NOT NULL"; string cmd_index_order = "ORDER BY RDB$DEPENDENCIES.RDB$DEPENDENT_NAME,RDB$DEPENDENCIES.RDB$FIELD_NAME"; string cmd_index = $@"{cmd_index0} {case0} {cmd_index_where} {cmd_index_order};"; dsDependenciesTo.Clear(); dgvDependenciesTo.AutoGenerateColumns = true; try { var con = new FbConnection(ConnectionStrings.Instance.MakeConnectionString(_dbReg)); FbDataAdapter ds = new FbDataAdapter(cmd_index, con); ds.Fill(dsDependenciesTo); con.Close(); dgvDependenciesTo.DataMember = "Table"; return(dsDependenciesTo.Tables[0].Rows.Count); } catch (Exception ex) { _localNotify?.AddToERROR($@"{StaticFunctionsClass.DateTimeNowStr()}->{this.Name}->RefreshDependenciesTo->{ex.Message}"); } return(0); }
public string RemoveComments(string txt) { //Remove Singleline Comments _parentNotifies?.AddToINFO(StaticFunctionsClass.DateTimeNowStr() + " Remove comments"); Application.DoEvents(); int remstart = txt.IndexOf(_drc.SingleLineComment); int remend = -1; if (remstart >= 0) { remend = txt.Substring(remstart).IndexOf(_drc.NewLine) + remstart; while ((remstart >= 0) && (remend > remstart)) { txt = txt.Remove(remstart, remend - remstart + _drc.NewLine.Length); remstart = txt.IndexOf(_drc.SingleLineComment); remend = txt.IndexOf(_drc.NewLine); } } //Remore Comments remstart = txt.IndexOf(_drc.CommentStart); if (remstart >= 0) { remend = txt.IndexOf(_drc.CommentEnd); while ((remstart >= 0) && (remend > remstart)) { txt = txt.Remove(remstart, remend - remstart + _drc.CommentEnd.Length); remstart = txt.IndexOf(_drc.CommentStart); remend = txt.IndexOf(_drc.CommentEnd); } } return(txt); }
public void MakeSQLNew() { SQLScript.Clear(); string GenName = txtGenName.Text.Trim(); if (!string.IsNullOrEmpty(GenName)) { int?NewValue = StaticFunctionsClass.ToIntDef(txtGenNewValue.Text.Trim(), null); int?IncrementValue = StaticFunctionsClass.ToIntDef(txtIncrementValue.Text.Trim(), null); var sb = new StringBuilder(); sb.Append($@"CREATE SEQUENCE {GenName};{Environment.NewLine}"); if (NewValue != null) { string cmd = ((IncrementValue != null) && (IncrementValue.Value > 0)) ?$@"ALTER SEQUENCE {txtGenName.Text.Trim()} RESTART WITH {NewValue.Value} INCREMENT BY {IncrementValue.Value};{Environment.NewLine}" :$@"ALTER SEQUENCE {txtGenName.Text.Trim()} RESTART WITH {NewValue.Value};{Environment.NewLine}"; sb.Append(cmd); } sb.Append($@"{SQLPatterns.Commit}{Environment.NewLine}{Environment.NewLine}"); sb.Append($@"COMMENT ON GENERATOR {GenName} IS '{fctGenDescription.Text}';{Environment.NewLine}"); sb.Append($@"{SQLPatterns.Commit}{Environment.NewLine}{Environment.NewLine}"); SQLScript.Add(sb.ToString()); } else { SQLScript.Add("/* Generator name is not defined */"); } SQLToUI(); }
public TestOptionsClass EditToData() { TestOptionsClass to = new TestOptionsClass(); to.manualTreshold = ckFixTreshold.Checked; double mt = StaticFunctionsClass.ToDoubleDef(txtManualTreshold.Text, -1); if (mt <= 0) { ckFixTreshold.Checked = false; txtManualTreshold.Text = "1.0"; to.treshold = 1.0; } else { txtManualTreshold.Text = mt.ToString(); to.treshold = mt; } to.minBoardNr = (int)nmMinBoard.Value; to.maxBoardNr = (int)nmMaxBoard.Value; to.signalA = ckSignalA.Checked; to.signalB = ckSignalB.Checked; return(to); }
public void EditToData() { AppSettingsClass.Instance.Stamp = DateTime.Now; AppSettingsClass.Instance.DatabaseSettings.DefaultPacketSize = (int)numDefaultPacketSize.Value; AppSettingsClass.Instance.DatabaseSettings.DefaultPort = (int)numDefaultPort.Value; AppSettingsClass.Instance.DatabaseSettings.DefaultPassword = txtDefaultPassword.Text; AppSettingsClass.Instance.DatabaseSettings.DefaultUser = txtDefaulUser.Text; AppSettingsClass.Instance.DatabaseSettings.OpenDatabaseCount = (int)numOpenDatabaseCount.Value; AppSettingsClass.Instance.PathSettings.DatabasesConfigPath = txtDatabasesConfigPath.Text; AppSettingsClass.Instance.PathSettings.TempPath = txtTemporaryPath.Text; AppSettingsClass.Instance.PathSettings.ScriptingPath = txtScriptingPath.Text; AppSettingsClass.Instance.PathSettings.DatabaseConfigFile = txtDatabasesConfigFile.Text; AppSettingsClass.Instance.PathSettings.InfoPath = txtInfoPath.Text; AppSettingsClass.Instance.PathSettings.ExportPath = txtExportPath.Text; AppSettingsClass.Instance.PathSettings.SQLExportPath = txtSQLExportPath.Text; AppSettingsClass.Instance.PathSettings.SQLHistoryPath = txtSQLHistoryPath.Text; AppSettingsClass.Instance.SQLVariables.SetNewLine(txtSQLNewLine.Text); AppSettingsClass.Instance.SQLVariables.CommentStart = txtSQLCommentStart.Text; AppSettingsClass.Instance.SQLVariables.CommentEnd = txtSQLCommentEnd.Text; AppSettingsClass.Instance.SQLVariables.SkipForSelect = StaticFunctionsClass.ToIntDef(txtSkipForSelect.Text, StaticVariablesClass.SQLSkipForSelect); AppSettingsClass.Instance.SQLVariables.MaxRowsForSelect = StaticFunctionsClass.ToIntDef(txtSQLMaxRowForSelect.Text, StaticVariablesClass.SQLMaxRowForSelect); AppSettingsClass.Instance.SQLVariables.SingleLineComment = txtSQLSingleLineCommand.Text; AppSettingsClass.Instance.SQLVariables.AlternativeTerminator = txtSQLAlternativeTerminator.Text; AppSettingsClass.Instance.SQLVariables.InitialTerminator = txtSQLInitialTerminator.Text; }
private void PlaySingleNote(string HarpCode) { int kz = StaticFunctionsClass.ToIntDef(HarpCode, 0); //FormInstances.Instance().hc.SetTranspose(FormInstances.Instance().Transpose); if (kz >= 0) { if (kz < 100) { FormInstances.Instance().hc.Play(kz, eBreathDirection.blow, 1000); } else { FormInstances.Instance().hc.Play(kz - 100, eBreathDirection.blowPushed, 1000); } } else { if (kz > -100) { FormInstances.Instance().hc.Play(Math.Abs(kz), eBreathDirection.draw, 1000); } else { FormInstances.Instance().hc.Play(Math.Abs(kz + 100), eBreathDirection.drawPushed, 1000); } } }
private void txtSkipForSelect_TextChanged(object sender, EventArgs e) { if (!DoEvent) { return; } _dbReg.SkipForSelect = StaticFunctionsClass.ToIntDef(txtSkipForSelect.Text.Trim(), 1000); }
private void txtPacketsize_TextChanged(object sender, EventArgs e) { if (!DoEvent) { return; } _dbReg.PacketSize = StaticFunctionsClass.ToIntDef(txtPacketsize.Text, 0); connectionDataChanged(); }
private void dgvResults_CellPainting(object sender, DataGridViewCellPaintingEventArgs e) { int rh = StaticFunctionsClass.ToIntDef(txtRowHeight.Text, dgvResults.RowTemplate.Height); foreach (DataGridViewRow x in dgvResults.Rows) { x.MinimumHeight = rh; } }
private void txtMaxPoolSize_TextChanged(object sender, EventArgs e) { if (!DoEvent) { return; } _dbReg.MaxPoolSize = StaticFunctionsClass.ToIntDef(txtMaxPoolSize.Text.Trim(), 15); connectionDataChanged(); }
private void txtConnectionLifetime_TextChanged(object sender, EventArgs e) { if (!DoEvent) { return; } _dbReg.Lifetime = StaticFunctionsClass.ToIntDef(txtLifetime.Text.Trim(), 0); connectionDataChanged(); }
private void txtPort_TextChanged(object sender, EventArgs e) { if (!DoEvent) { return; } _dbReg.Port = StaticFunctionsClass.ToIntDef(txtPort.Text.Trim(), 3050); connectionDataChanged(); }
private void ExecuteCommandsFromFile(string filename) { var fi = new FileInfo(filename); if (!fi.Exists) { return; } var content = new StringBuilder(); _notifies?.AddToINFO($@"{StaticFunctionsClass.DateTimeNowStr()} Prepare executing script in file {filename}"); Application.DoEvents(); string _connstr = ConnectionStrings.Instance.MakeConnectionString(_actScriptingDbReg); _sql = new DBBasicClassLibrary.SQLScriptingClass(_connstr, AppSettingsClass.Instance.SQLVariables.GetNewLine(), AppSettingsClass.Instance.SQLVariables.CommentStart, AppSettingsClass.Instance.SQLVariables.CommentEnd, AppSettingsClass.Instance.SQLVariables.SingleLineComment, "SCRIPT"); _sql.ScriptNotify.Register4Info(EventMeldungRaised); _sql.Commands.Clear(); int lineCount = 0; int clearAfter = StaticFunctionsClass.ToIntDef(txtClear.Text, 1000); fcbCommands.Clear(); fcbCommands.BeginUpdate(); content.Clear(); long mx = fi.Length / 20; pbProgress.Maximum = (int)mx; pbProgress.Minimum = 0; pbProgress.Value = 0; using (var sr = new StreamReader(fi.FullName, Encoding.Default)) { if (pbProgress.Maximum >= pbProgress.Minimum) { pbProgress.Value = 0; } var startDt = DateTime.Now; while (!sr.EndOfStream) { string str = sr.ReadLine(); bool cmdeady = _sql.AddCommandLine($@"{str}{Environment.NewLine}"); if (!cmdeady) { continue; } lineCount++; var returnList = _sql.RunPreparedCommands(); _sql.Commands.Clear(); } fcbCommands.EndUpdate(); Cursor = Cursors.Default; _notifies?.AddToINFO($@"{StaticFunctionsClass.DateTimeNowStr()} Preparing done {lineCount.ToString()} commands"); Application.DoEvents(); } }
private void hsAddRestoreFile_Click(object sender, EventArgs e) { FirebirdSql.Data.Services.FbBackupFile bf = new FirebirdSql.Data.Services.FbBackupFile(txtRestoreLocation.Text); bf.BackupLength = StaticFunctionsClass.ToIntDef(txtRestoreFileSize.Text.Trim(), 0); string[] obarr = { bf.BackupFile, bf.BackupLength.ToString() }; ListViewItem lvi = new ListViewItem(obarr); lvi.Tag = bf; lvRestore.Items.Add(lvi); }
public string RemoveDoubleSpaces(string txt) { //Remove double spaces _parentNotifies?.AddToINFO(StaticFunctionsClass.DateTimeNowStr() + " Remove double spaces"); Application.DoEvents(); while (txt.IndexOf(" ") >= 0) { txt = txt.Replace(" ", " "); } return(txt); }
public void EditToData() { AppSettingsClass.Instance().Stamp = DateTime.Now; AppSettingsClass.Instance().DatabaseSettings.DefaultPacketSize = StaticFunctionsClass.ToIntDef(txtDefaultPacketsize.Text, 8192); AppSettingsClass.Instance().DatabaseSettings.DefaultPassword = txtDefaultPassword.Text; AppSettingsClass.Instance().DatabaseSettings.DefaultUser = txtDefaulUser.Text; AppSettingsClass.Instance().PathSettings.DatabasesConfigPath = txtDatabasesConfigPath.Text; AppSettingsClass.Instance().PathSettings.TempPath = txtTemporaryPath.Text; AppSettingsClass.Instance().PathSettings.ScriptingPath = txtScriptingPath.Text; AppSettingsClass.Instance().PathSettings.DatabaseConfigFile = txtDatabasesConfigFile.Text; }
public void ScriptInfoRaised(object sender, MessageEventArgs e) { if (e.Data.GetType() == typeof(SCRIPTCommandClass)) { var sc = (SCRIPTCommandClass)e.Data; fcbNotify.AppendText($@"{StaticFunctionsClass.DateTimeNowStr()} {e.Meldung}->{e.Key}->{sc.CommandType}->done in {sc.Costs} ms{Environment.NewLine}"); } else { fcbNotify.AppendText($@"{StaticFunctionsClass.DateTimeNowStr()} {e.Meldung}->{e.Key}{Environment.NewLine}"); } }
private void hsAddBackupFile_Click(object sender, EventArgs e) { int fLength = StaticFunctionsClass.ToIntDef(txtFileSize.Text.Trim(), 0); string[] obarr = { txtSQLLocation.Text, fLength.ToString() }; var lvi = new ListViewItem(obarr) { Tag = _fi }; lvFiles.Items.Add(lvi); }
private void PrepareCommandsFromSQL() { if (cbClearBeforePreparing.Checked) { _sql = new SQLScriptingClass(_actScriptingDbReg, "SCRIPT", _notifies, _eventnotifies); lvCommands.Items.Clear(); } pbProgress.Maximum = fcbSQL.Lines.Count;; pbProgress.Minimum = 0; pbProgress.Value = 0; _sql.PrepareCommands(fcbSQL.Lines, cbClearBeforePreparing.Checked); int clearAfter = StaticFunctionsClass.ToIntDef(txtClear.Text, 1000); }
private void txtTranspose_TextChanged(object sender, EventArgs e) { byte transpose = 0; if (doEvents) { transpose = (byte)StaticFunctionsClass.ToIntDef(txtTranspose.Text, 0); FormInstances.Instance().hc.SetTranspose(transpose); } doEvents = false; //txtTranspose.Text = transpose.ToString(); doEvents = true; }
public string TestForValidation(string txt) { string cmd = txt.Replace(" ,", ","); int indv = cmd.IndexOf("VALUES("); if (indv >= 0) { int changed = 0; string cmd2 = cmd.Substring(indv + 7); if (cmd2.Trim().EndsWith(");")) { cmd2 = cmd2.Trim().Substring(0, cmd2.Trim().Length - 2); } string[] arr = cmd2.Split(','); for (int i = 0; i < arr.Length; i++) { string arrcmd = arr[i].Trim(); int n = arrcmd.IndexOf("'", 1); if ((n > -1) && (n < arrcmd.Length - 1)) { arrcmd = arrcmd.Insert(n, "'"); _parentNotifies?.AddToINFO($@"{StaticFunctionsClass.DateTimeNowStr()} ...Executing script, Apostroph quotet:{arr[i]}->{arrcmd}"); arr[i] = arrcmd; changed++; } } if (changed > 0) { var sb = new StringBuilder(); sb.Append(cmd.Substring(0, indv + 7)); bool first = true; foreach (string str in arr) { if (!first) { sb.Append(","); } sb.Append(str); first = false; } sb.Append($@");{Environment.NewLine}"); return(sb.ToString()); } } return(cmd); }
private void PrepareCommandsFromSQL() { string _connstr = ConnectionStrings.Instance.MakeConnectionString(_actScriptingDbReg); _sql = new DBBasicClassLibrary.SQLScriptingClass(_connstr, AppSettingsClass.Instance.SQLVariables.GetNewLine(), AppSettingsClass.Instance.SQLVariables.CommentStart, AppSettingsClass.Instance.SQLVariables.CommentEnd, AppSettingsClass.Instance.SQLVariables.SingleLineComment, "SCRIPT"); _sql.ScriptNotify.Register4Info(EventMeldungRaised); if (cbClearBeforePreparing.Checked) { lvCommands.Items.Clear(); } pbProgress.Maximum = fcbSQL.Lines.Count;; pbProgress.Minimum = 0; pbProgress.Value = 0; _sql.PrepareCommands(fcbSQL.Lines, cbClearBeforePreparing.Checked); int clearAfter = StaticFunctionsClass.ToIntDef(txtClear.Text, 1000); }
public string RefreshIndicesAndGetTablename() { string cmd_index = SQLStatements.Instance().GetIndiciesByName(_dbReg.Version, IndexName.Trim()); DataFilled = false; txtIndexName.Text = IndexName.Trim(); string TableName = string.Empty; try { lvFields.Items.Clear(); var con = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(_dbReg)); con.Open(); string PkColumn = string.Empty; string IndexName = string.Empty; string IndexColumnName = string.Empty; int Unique = 0; FbCommand fcmd = new FbCommand(cmd_index, con); var dread = fcmd.ExecuteReader(); if (dread.HasRows) { while (dread.Read()) { TableName = dread.GetValue(0).ToString().Trim(); IndexColumnName = dread.GetValue(2).ToString().Trim(); Unique = StaticFunctionsClass.ToIntDef(dread.GetValue(3).ToString().Trim(), 0); cbUnique.Checked = Unique > 0; string[] lv = new string[1]; lv[0] = IndexColumnName; ListViewItem lvi = new ListViewItem(lv); lvFields.Items.Add(lvi); } DataFilled = true; } con.Close(); } catch (Exception ex) { _localNotify?.AddToERROR(StaticFunctionsClass.DateTimeNowStr() + "->ConstraintForm->RefreshIndices()->" + ex.Message); } return(TableName); }
public void MakeSQLNew() { SQLScript.Clear(); cbCollate.Enabled = true; var sb = new StringBuilder(); sb.Append($@"CREATE DOMAIN {txtName.Text} AS "); sb.Append($@"{StaticVariablesClass.CompleteRawType(cbTypes.Text.Trim(), StaticFunctionsClass.ToIntDef(txtLength.Text.Trim(), 0))}"); if (cbCharSet.Enabled) { if (cbCharSet.Text != "NONE") { sb.Append($@" CHARACTER SET {cbCharSet.Text}"); } } if (cbCollate.Enabled) { if (cbCollate.Text != "NONE") { sb.Append($@" COLLATE {cbCollate.Text}"); } } if (!string.IsNullOrEmpty(txtDefault.Text)) { sb.Append($@" DEFAULT '{txtDefault.Text}'"); } sb.AppendLine($@";"); sb.Append($@"{SQLPatterns.Commit}{Environment.NewLine}"); if (cbNotNull.Checked) { sb.AppendLine($@"ALTER DOMAIN {txtName.Text} ADD CONSTRAINT CHECK (VALUE IS NOT NULL); /* adds not null flag to domain */"); sb.AppendLine($@"{SQLPatterns.Commit}{Environment.NewLine}"); } if (!string.IsNullOrEmpty(fctDescription.Text)) { sb.AppendLine($@"COMMENT ON DOMAIN {txtName.Text} IS '{fctDescription.Text}';"); sb.Append($@"{SQLPatterns.Commit}{Environment.NewLine}"); } SQLScript.Add(sb.ToString()); SQLToUI(); }
public void RefreshDomain() { string cmd0 = "SELECT RDB$FIELDS.RDB$FIELD_NAME,RDB$FIELDS.RDB$CHARACTER_LENGTH,RDB$FIELDS.RDB$FIELD_SCALE,RDB$FIELD_PRECISION,RDB$FIELDS.RDB$FIELD_TYPE,RDB$FIELDS.RDB$DESCRIPTION,RDB$TYPES.RDB$TYPE_NAME FROM RDB$FIELDS"; string cmd1 = "LEFT JOIN RDB$TYPES ON RDB$TYPES.RDB$TYPE = RDB$FIELDS.RDB$FIELD_TYPE"; string where = "WHERE RDB$FIELDS.RDB$FIELD_NAME = '" + FieldObject.Domain + "' AND RDB$TYPES.RDB$FIELD_NAME = 'RDB$FIELD_TYPE'"; string cmd = cmd0 + " " + cmd1 + " " + where + ";"; ConnectionClass cc = ConnectionPoolClass.Instance().GetConnection("C1"); cc.ShowExceptionMode = MessageLibrary.ShowError.no; DbDataReader dr = cc.ExecuteQuery(cmd, false); if (dr != null) { if (cc.HasRows()) { int n = 0; while (cc.Read()) { DomainObject = DataClassFactory.GetDataClass(StaticVariablesClass.DomainsKeyStr) as DomainClass; DomainObject.Name = cc.GetValue(0).ToString().Trim(); DomainObject.Length = StaticFunctionsClass.ToIntDef(cc.GetValue(1).ToString().Trim(), 0); DomainObject.Scale = StaticFunctionsClass.ToIntDef(cc.GetValue(2).ToString().Trim(), 0); DomainObject.Precision = StaticFunctionsClass.ToIntDef(cc.GetValue(3).ToString().Trim(), 0); DomainObject.TypeNumber = StaticFunctionsClass.ToIntDef(cc.GetValue(4).ToString().Trim(), 0); DomainObject.FieldType = cc.GetValue(6).ToString().Trim(); DomainObject.RawType = StaticVariablesClass.ConvertINTERNALType_TO_SQLType(DomainObject.FieldType, DomainObject.Length); object ob = cc.GetValue(5); DomainObject.Description = cc.GetValue(5).ToString().Trim(); /* * if (!string.IsNullOrEmpty(ob.ToString())) * { * byte[] bytetext = (byte[])cc.DBProvider.DataReader[3]; * DomainObject.Description = System.Text.Encoding.UTF8.GetString(bytetext); * } */ n++; } } cc.CloseConnection(); } }
private void Notify_OnRaiseErrorHandler(object sender, MessageEventArgs k) { var sb = new StringBuilder(); _errorCount++; if (_messagesCount > 0) { sb.Append($@"{StaticFunctionsClass.DateTimeNowStr()} Messages ({_messagesCount}) "); } if (_errorCount > 0) { sb.Append($@"{StaticFunctionsClass.DateTimeNowStr()} Errors ({_errorCount})"); } fctMessages.AppendText($@"ERROR {k.Meldung}"); tabPageMessages.Text = sb.ToString(); fctMessages.ScrollLeft(); }
private void Restore_ServiceOutput(object sender, FirebirdSql.Data.Services.ServiceOutputEventArgs e) { n++; StaticFunctionsClass.SetDoubleBuffered(lvBackupMessage); lvBackupMessage.BeginUpdate(); string[] m = { n.ToString(), e.Message, StaticFunctionsClass.DateTimeNowStr() }; ListViewItem lvi = new ListViewItem(m); lvRestoreMessage.Items.Add(lvi); lvRestoreMessage.Items[lvRestoreMessage.Items.Count - 1].EnsureVisible(); lvRestoreMessage.EndUpdate(); if (n % 20 == 0) { Application.DoEvents(); } }