public bool IsSameType(TableFieldClass fo, string type, string fieldlength, string fieldprec, string fieldscale)
{
string st1 = GetTypeString(type, fieldlength, fieldprec, fieldscale);
string st2 = GetTypeString(fo.Domain.RawType, fo.Domain.Length.ToString(), fo.Domain.Precision.ToString(), fo.Domain.Scale.ToString());
return(st1 == st2);
}
private void ExecueteSQL()
{
string _connstr = ConnectionStrings.Instance.MakeConnectionString(_dbReg);
var _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(InfoRaised);
_sql.ScriptNotify.Register4Error(ErrorRaised);
var riList = _sql.ExecuteCommands(fctSQL.Lines);
var riFailure = riList.Find(x => x.commandDone == false);
EditToData();
if (riFailure == null)
{
OrgFieldObject = FieldObject.DeepClone();
BearbeitenMode = StateClasses.EditStateClass.eBearbeiten.eEdit;
ObjectToEdit(FieldObject);
MakeSQL();
}
AppStaticFunctionsClass.SendResultNotify(riList, localNotify);
string info = (riFailure == null)
? $@"Fields for {_dbReg.Alias}->{FieldObject.TableName} updated."
: $@"Fields for {_dbReg.Alias}->{FieldObject.TableName} not updated !!!{Environment.NewLine}{riFailure.nErrors} errors";
DbExplorerForm.Instance().DbExlorerNotify.Notify.RaiseInfo(info, StaticVariablesClass.ReloadFields, $@"->Proc:{Name}->ExecueteSQL()");
_localTableNotify.Notify.RaiseInfo(info, StaticVariablesClass.ReloadFields);
}
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);
}
private void hsOrg_Click(object sender, EventArgs e)
{
DataFilled = false;
FieldObject = OrgFieldObject.DeepClone();
ObjectToEdit(FieldObject);
DataFilled = true;
MakeSQL();
}
public TableFieldForm(DBRegistrationClass dbReg, Form parent, TableFieldClass fieldsObject, string tabName)
{
InitializeComponent();
DBReg = dbReg;
FieldObject = fieldsObject;
TabName = tabName;
RefreshDomain();
DataToEdit();
}
public void ObjectToEdit(TableFieldClass FieldObject)
{
txtFieldName.Text = FieldObject.Name;
fctDescription.Text = FieldObject.Description;
cbPrimaryKey.Checked = FieldObject.IsPrimary;
txtDefault.Text = FieldObject.Domain.DefaultValue;
cbNotNull.Checked = FieldObject.Domain.NotNull;
txtLength.Text = FieldObject.Domain.Length.ToString();
txtScale.Text = FieldObject.Domain.Scale.ToString();
txtPrecisionLength.Text = FieldObject.Domain.Precision.ToString();
txtPK.Text = string.IsNullOrEmpty(FieldObject.PK_ConstraintName) ? TableObject.primary_constraint?.Name : FieldObject.PK_ConstraintName;
cbDOMAIN.Text = FieldObject.Domain.Name;
cbFieldTypes.Text = StaticVariablesClass.ConvertRawTypeToRawName(FieldObject.Domain.FieldType);
fctDescription.Text = FieldObject.Description;
cbCharSet.Text = (FieldObject.Domain.CharSet == null) ? "NONE" : FieldObject.Domain.CharSet;
cbCollate.Text = (FieldObject.Domain.Collate == null) ? "NONE" : FieldObject.Domain.Collate;
txtPosition.Text = FieldObject.Position.ToString();
}
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;
}
private void ExecueteSQL()
{
var _sql = new SQLScriptingClass(_dbReg, "SCRIPT", localNotify);
var riList = _sql.ExecuteCommands(fctSQL.Lines);
var riFailure = riList.Find(x => x.commandDone == false);
EditToObject();
if (riFailure == null)
{
OrgFieldObject = FieldObject.DeepClone();
BearbeitenMode = StateClasses.EditStateClass.eBearbeiten.eEdit;
ObjectToEdit(FieldObject);
MakeSQL();
}
string info = (riFailure == null)
? $@"Fields for {_dbReg.Alias}->{FieldObject.TableName} updated."
: $@"Fields for {_dbReg.Alias}->{FieldObject.TableName} not updated !!!{Environment.NewLine}{riFailure.nErrors} errors, last error:{riFailure.lastError}";
DbExplorerForm.Instance().DbExlorerNotify.Notify.RaiseInfo(info, StaticVariablesClass.ReloadFields, $@"->Proc:{Name}->Create");
_localTableNotify.Notify.RaiseInfo(info);
}
public void NewFieldObject()
{
FieldObject = new TableFieldClass()
{
Name = "NEW_FIELD",
};
FieldObject.Domain.Name = "";
FieldObject.Domain.Length = 8;
FieldObject.Domain.FieldType = "VARCHAR";
FieldObject.Domain.CharSet = _dbReg.CharSet;
FieldObject.Domain.Collate = _dbReg.Collation;
FieldObject.Domain.RawType = "VARCHAR(8)";
FieldObject.Domain.Scale = 8;
FieldObject.Domain.Precision = 3;
FieldObject.Domain.NotNull = false;
FieldObject.IsPrimary = false;
FieldObject.PK_ConstraintName = TableObject.primary_constraint.Name;
FieldObject.Position = 0; //keine Position
FieldObject.Description = string.Empty;
FieldObject.DefaultValue = string.Empty;
FieldObject.Domain.Check = string.Empty;
FieldObject.Domain.DefaultValue = string.Empty;
}
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 bool TableFieldsEqual(TableFieldClass tcf1, TableFieldClass tcf2)
{
return((tcf1.Domain.FieldType == tcf2.Domain.FieldType) && (tcf1.Domain.Length == tcf2.Domain.Length) &&
(tcf1.Domain.CharSet == tcf2.Domain.CharSet));
}
