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();
}
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 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;
}
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 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 txtMaxPoolSize_TextChanged(object sender, EventArgs e)
{
if (!DoEvent)
{
return;
}
_dbReg.MaxPoolSize = StaticFunctionsClass.ToIntDef(txtMaxPoolSize.Text.Trim(), 15);
connectionDataChanged();
}
private void txtPort_TextChanged(object sender, EventArgs e)
{
if (!DoEvent)
{
return;
}
_dbReg.Port = StaticFunctionsClass.ToIntDef(txtPort.Text.Trim(), 3050);
connectionDataChanged();
}
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 txtConnectionLifetime_TextChanged(object sender, EventArgs e)
{
if (!DoEvent)
{
return;
}
_dbReg.Lifetime = StaticFunctionsClass.ToIntDef(txtLifetime.Text.Trim(), 0);
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);
}
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);
}
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;
}
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;
}
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();
}
}
public void EditToObject()
{
FieldObject = new TableFieldClass();
FieldObject.Name = txtFieldName.Text.Trim();
FieldObject.Position = StaticFunctionsClass.ToIntDef(txtPosition.Text, OrgFieldObject.Position);
//FieldObject.CharSet = cbCharSet.Text;
//FieldObject.Collate = cbCollate.Text;
FieldObject.Domain.Precision = StaticFunctionsClass.ToIntDef(txtPrecisionLength.Text, OrgFieldObject.Domain.Precision);
FieldObject.Domain.Scale = StaticFunctionsClass.ToIntDef(txtScale.Text, OrgFieldObject.Domain.Scale);
FieldObject.Description = fctDescription.Text;
FieldObject.IsPrimary = cbPrimaryKey.Checked;
FieldObject.PK_ConstraintName = txtPK.Text;
FieldObject.Domain.FieldType = StaticVariablesClass.ConvertRawNameToRawType(cbFieldTypes.Text);
FieldObject.Domain.CharSet = cbCharSet.Text.Trim();
FieldObject.Domain.NotNull = cbNotNull.Checked;
FieldObject.Domain.Length = StaticFunctionsClass.ToIntDef(txtLength.Text, OrgFieldObject.Domain.Length);
FieldObject.Domain.DefaultValue = txtDefault.Text;
FieldObject.Domain.Collate = cbCollate.Text;
}
public void EditToData()
{
TriggerObject.Name = txtTriggerName.Text.Trim();
TriggerObject.Active = cbIsActive.Checked;
eTriggerType typ = eTriggerType.none;
string temp = rbBEFORE.Checked ? "BEFORE" : "AFTER";
if (cbINSERT.Checked)
{
typ = (rbBEFORE.Checked) ? eTriggerType.beforeInsert : eTriggerType.afterInsert;
}
if (cbUPDATE.Checked)
{
if (typ == eTriggerType.none)
{
typ = (rbBEFORE.Checked) ? eTriggerType.beforeUpdate : eTriggerType.afterUpdate;
}
else
{
typ = (rbBEFORE.Checked) ? eTriggerType.beforeInsertOrUpdate : eTriggerType.afterInsertOrUpdate;
}
}
if (cbDELETE.Checked)
{
if (typ == eTriggerType.none)
{
typ = (rbBEFORE.Checked) ? eTriggerType.beforeDelete : eTriggerType.afterDelete;
}
else if ((typ == eTriggerType.beforeInsert) || (typ == eTriggerType.afterInsert))
{
typ = (rbBEFORE.Checked) ? eTriggerType.beforeInsertOrDelete : eTriggerType.afterInsertOrDelete;
}
else if ((typ == eTriggerType.beforeInsertOrUpdate) || (typ == eTriggerType.afterInsertOrUpdate))
{
typ = (rbBEFORE.Checked) ? eTriggerType.beforeInsertOrUpdateOrDelete : eTriggerType.afterInsertOrUpdateOrDelete;
}
}
TriggerObject.Type = typ;
TriggerObject.Sequence = StaticFunctionsClass.ToIntDef(txtGenValue.Text, 0);
}
private void cbTick_CheckedChanged(object sender, EventArgs e)
{
if (cbTick.Checked)
{
int tk = StaticFunctionsClass.ToIntDef(txtTick.Text, 0);
if (tk > 0)
{
timer1.Interval = tk * 1000;
timer1.Start();
}
else
{
timer1.Stop();
}
}
else
{
timer1.Stop();
}
}
public string MakeNewIndexName()
{
string inxStr = _indexObject.Name.Trim();
int lastn = 1;
int i = 0;
for (i = inxStr.Length - 1; i >= 0; i--)
{
string s = inxStr.Substring(i);
int n = StaticFunctionsClass.ToIntDef(s, -1);
if (n < 0)
{
break;
}
lastn = n + 1;
}
string newStr = inxStr.Substring(0, i + 1) + lastn.ToString();
return(newStr);
}
public void SetDelay(string noteDelay, double delayDefinition)
{
DelayStr = noteDelay.StartsWith("/") ? $@"1{noteDelay}" : noteDelay;
RefDelay = 120.0 * (120.0 / delayDefinition);
if (DelayStr.Contains("/"))
{
string[] zt = DelayStr.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries);
int z = StaticFunctionsClass.ToIntDef(zt[0], 0);
int t = StaticFunctionsClass.ToIntDef(zt[1], 1);
Delay = RefDelay * (((double)z) / ((double)t));
}
else if (!string.IsNullOrEmpty(DelayStr))
{
int z = StaticFunctionsClass.ToIntDef(DelayStr, 1);
Delay = RefDelay * z;
}
else
{
Delay = RefDelay;
}
}
public string GetTypeString(string type, string fieldlength, string fieldprec, string fieldscale)
{
var sb = new StringBuilder();
if (type == "VARCHAR")
{
int length = StaticFunctionsClass.ToIntDef(fieldlength, 0);
//int digits = StaticFunctionsClass.ToIntDef(txtScale.Text, 0);
if (length > 0)
{
sb.Append($@"VARCHAR({length})");
}
else
{
length = StaticFunctionsClass.ToIntDef(fieldlength, 0);
sb.Append($@"VARCHAR({length})");
}
}
else if (type == "NUMERIC")
{
// NUMERIC(8, 3)
int prec = StaticFunctionsClass.ToIntDef(fieldprec, 0);
int digits = StaticFunctionsClass.ToIntDef(fieldscale, 0);
if (digits < prec)
{
sb.Append($@"NUMERIC({prec},{digits})");
}
else
{
txtPrecisionLength.Text = "1";
txtScale.Text = "0";
sb.Append($@"NUMERIC(1,0)");
}
}
else
{
sb.Append(type);
}
return(sb.ToString());
}
public void SetDelay(string delay)
{
DelayStr = delay.StartsWith("/") ? $@"1{delay}" : delay;
if (DelayStr.Contains("/"))
{
string[] zt = DelayStr.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries);
int z = StaticFunctionsClass.ToIntDef(zt[0], 0);
int t = StaticFunctionsClass.ToIntDef(zt[1], 1);
Delay = RefDelay * (((double)z) / ((double)t));
}
else if (!string.IsNullOrEmpty(DelayStr))
{
double dl = StaticFunctionsClass.ToDoubleDef(DelayStr, 1);
Delay = RefDelay * dl;
}
else
{
Delay = 1;
}
Delay *= Statics.NoteDelayFactor;
}
public void RefreshIndices()
{
string cmd_index = IndexSQLStatementsClass.Instance().GetIndiciesByName(_dbReg.Version, IndexName.Trim());
DataFilled = false;
txtConstraintName.Text = IndexName.Trim();
try
{
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);
string[] lv = new string[1];
lv[0] = IndexColumnName;
}
DataFilled = true;
}
con.Close();
}
catch (Exception ex)
{
_localNotify?.AddToERROR(StaticFunctionsClass.DateTimeNowStr() + "->NotNullForm->RefreshIndices()->" + ex.Message);
}
}
public static double GetNoteLength(string noteatt, double unitlength)
{
int inxsplit = noteatt.IndexOf(Divider);
double notelength = 0;
if (inxsplit < 0)
{
notelength = StaticFunctionsClass.ToDoubleDef(noteatt, 0);
}
else if (inxsplit == 0)
{
notelength = 1.0 / StaticFunctionsClass.ToIntDef(noteatt.Substring(1), 1);
}
else
{
string ddstr = noteatt.Substring(0, inxsplit);
string ddstr2 = noteatt.Substring(inxsplit + 1);
double d1 = StaticFunctionsClass.ToDoubleDef(ddstr, 1);
double d2 = StaticFunctionsClass.ToDoubleDef(ddstr2, 1);
notelength = d1 / d2;
}
return(notelength * unitlength);
}
