void FieldDataToEdit()
{
txtFieldName.Text = _fieldObject.Name;
fctDescription.Text = _fieldObject.Description;
cbPrimaryKey.Checked = _tableObject.IsPrimary(_fieldObject.Name);
cbNotNull.Checked = _tableObject.IsNotNull(_fieldObject.Name);
}
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 void FillDestFields(string DestTableName)
{
cbDestinationTableFields.Items.Clear();
if (DestTableName.Length > 0)
{
TableClass DestTab = Tables.Find(x => x.Name == DestTableName);// StaticTreeClass.GetTableObjectFromName(DRC, DestTableName);
Dictionary <string, TableFieldClass> DestFds = DestTab.Fields;
foreach (TableFieldClass dstr in DestFds.Values)
{
if (DestTab.IsPrimary(dstr.Name))
{
cbDestinationTableFields.Items.Add(dstr.Name);
}
}
}
}
public static string CreateTabelDLL(TableClass tableObject, eCreateMode cmode)
{
//
// CREATE TABLE TACT_TANT(
// ID TABLE_ID NOT NULL /* TABLE_ID = VARCHAR(64) NOT NULL */,
// BEZ VAR10 /* VAR10 = VARCHAR(10) */,
// TANTWORT_ID REF_ID /* REF_ID = VARCHAR(64) */,
// TACTION_ID REF_ID /* REF_ID = VARCHAR(64) */,
// GUELTIG "SMALLINT" DEFAULT 1 NOT NULL /* "SMALLINT" = SMALLINT */,
// STATUS "SMALLINT" DEFAULT 0 NOT NULL /* "SMALLINT" = SMALLINT */,
// TUSERID REF_ID /* REF_ID = VARCHAR(64) */,
// STAMP "TIMESTAMP" DEFAULT CURRENT_TIMESTAMP /* "TIMESTAMP" = TIMESTAMP */
// );
var sb = new StringBuilder();
if (cmode == eCreateMode.recreate)
{
sb.AppendLine($@"RECREATE TABLE {tableObject.Name}");
}
else
{
sb.AppendLine($@"CREATE TABLE {tableObject.Name}");
}
sb.AppendLine("(");
int fc = 0;
foreach (TableFieldClass tfc in tableObject.Fields.Values)
{
fc++;
bool systemdomain = false;
if (tfc.Domain.Name.IndexOf("$") >= 0)
{
systemdomain = true;
}
if (systemdomain)
{
string FType = (tfc.Domain.Length > 0) ? $@"{StaticVariablesClass.ConvertRawTypeToRawName(tfc.Domain.FieldType)}({tfc.Domain.Length})" : $@"{StaticVariablesClass.ConvertRawTypeToRawName(tfc.Domain.FieldType)}";
sb.Append($@" {tfc.Name} {FType} ");
}
else
{
sb.Append($@" {tfc.Name} {tfc.Domain.Name} ");
}
if ((systemdomain) || ((tfc.Domain.FieldType != "VARYING") && ((!tableObject.IsPrimary(tfc.Name)) /*tfc.IS_PRIMARY*/)))
{
if (tfc.Domain.FieldType == "VARYING")
{
if ((tfc.Domain.CharSet != "NONE") && (tfc.Domain.Collate.Length > 0))
{
sb.Append($@" CHARACTER SET {tfc.Domain.CharSet}");
}
//Not NULL
if (tfc.Domain.NotNull)
{
sb.Append(" NOT NULL");
}
if ((tfc.Domain.Collate != "NONE") && (tfc.Domain.Collate.Length > 0))
{
sb.Append($@" COLLATE {tfc.Domain.CharSet}");
}
}
if (tableObject.IsPrimary(tfc.Name))
{
sb.Append(" PRIMARY KEY");
}
}
if (fc < tableObject.Fields.Count)
{
sb.Append(",");
}
//
if (systemdomain)
{
sb.Append($@" /* intern:[{tfc.Domain.FieldType}] domain:{tfc.Domain.Name} */");
}
else
{
sb.Append($@" /* raw:{tfc.Domain.RawType} intern:[{tfc.Domain.FieldType}] */");
}
if ((!systemdomain) && ((tfc.Domain.FieldType == "VARYING") || ((tableObject.IsPrimary(tfc.Name)))))
{
sb.Append(" /*");
if (tfc.Domain.FieldType == "VARYING")
{
if ((tfc.Domain.CharSet != "NONE") && (tfc.Domain.Collate.Length > 0))
{
sb.Append($@" CHARACTER SET {tfc.Domain.CharSet}");
}
if (tfc.Domain.NotNull)
{
sb.Append(" NOT NULL");
}
if ((tfc.Domain.Collate != "NONE") && (tfc.Domain.Collate.Length > 0))
{
sb.Append($@" COLLATE {tfc.Domain.CharSet}");
}
}
sb.Append(" */");
}
sb.Append(Environment.NewLine);
}
sb.AppendLine("");
sb.AppendLine(");");
return(sb.ToString());
}
