private void EDTLabeltextBox_TextChanged(object sender, EventArgs e)
{
if (!String.IsNullOrWhiteSpace(EDTLabeltextBox.Text) && (_parms.EdtLabel != EDTLabeltextBox.Text))
{
EDTHelpTextBox.Text = $"Identification of the {AxHelper.PrettyName(EDTLabeltextBox.Text)}";
_parms.EdtHelpText = EDTHelpTextBox.Text;
}
}
private void TableLabelTextBox_Validated(object sender, EventArgs e)
{
if (!String.IsNullOrWhiteSpace(TableLabelTextBox.Text))
{
FormLabelTextBox.Text = TableLabelTextBox.Text;
_parms.FormLabel = FormLabelTextBox.Text;
FormHelpTextBox.Text = $"Set up {AxHelper.PrettyName(TableLabelTextBox.Text)}";
_parms.FormHelp = FormHelpTextBox.Text;
PrivilegeLabelViewTextBox.Text = $"{_parms.FormLabel} view";
_parms.PrivilegeLabelView = PrivilegeLabelViewTextBox.Text;
PrivilegeLabelMaintainTextBox.Text = $"{_parms.FormLabel} maintain";
_parms.PrivilegeLabelMaintain = PrivilegeLabelMaintainTextBox.Text;
}
}
public string GenerateResult()
{
int longestNameLength = (from x in Fields select x.FieldName.Length).Max();
int longestTypeLength = (from x in Fields select x.FieldType.Length).Max();
longestTypeLength = Math.Max("boolean".Length, longestTypeLength);
longestTypeLength++;
longestNameLength++;
CodeGenerateHelper generateHelper = new CodeGenerateHelper {
IndentGlobalValue = 4
};
generateHelper.AddColumnAlignInt("Type", longestTypeLength);
generateHelper.AddColumnAlignInt("FieldName", longestNameLength);
if (VarName == "")
{
VarName = AxHelper.PrettyName(TableName);
}
string mandatoryFields;
if (IsCreateFind)
{
generateHelper.IndentSetValue(0);
generateHelper.Append($"public static {TableName} find(");
generateHelper.IndentSetAsCurrentPos();
// build args and mandatory fields list
mandatoryFields = "";
bool isFirst = true;
foreach (AxTableFieldParm df in Fields.OrderBy(x => x.Position))
{
if (df.IsMandatory || df.FieldName == "RecId")
{
if (mandatoryFields.Length > 0)
{
mandatoryFields += " && ";
}
mandatoryFields += "_" + AxHelper.PrettyName(df.FieldName);
}
if (!isFirst)
{
generateHelper.AppendLine(",");
}
generateHelper.Append(df.FieldType, "Type");
generateHelper.Append($" _{AxHelper.PrettyName(df.FieldName)}");
isFirst = false;
}
generateHelper.AppendLine(",");
generateHelper.Append("boolean", "Type");
generateHelper.AppendLine(" _forUpdate = false)");
//build method header
generateHelper.IndentSetValue(0);
generateHelper.AppendLine("{");
generateHelper.IndentIncrease();
generateHelper.AppendLine(TableName + " " + VarName + ";");
generateHelper.AppendLine(";");
//check for mandatory fields
if (mandatoryFields != "")
{
generateHelper.AppendLine("if (" + mandatoryFields + ")");
generateHelper.AppendLine("{");
generateHelper.IndentIncrease();
}
//selectForUpdate
generateHelper.AppendLine(VarName + ".selectForUpdate(_forUpdate);");
generateHelper.AppendLine("");
//build select query
generateHelper.AppendLine("select firstonly " + VarName);
generateHelper.Append(" where ");
generateHelper.IndentSetAsCurrentPos();
isFirst = true;
foreach (AxTableFieldParm df in Fields.OrderBy(x => x.Position))
{
if (!isFirst)
{
generateHelper.AppendLine(" && ");
}
generateHelper.Append(VarName + ".");
generateHelper.Append(df.FieldName, "FieldName");
generateHelper.Append(" == _" + AxHelper.PrettyName(df.FieldName));
isFirst = false;
}
generateHelper.IndentRestorePrev();
generateHelper.AppendLine(";");
//footer
if (mandatoryFields != "")
{
generateHelper.IndentDecrease();
generateHelper.AppendLine("}");
}
generateHelper.AppendLine("");
generateHelper.AppendLine("return " + VarName + ";");
generateHelper.IndentDecrease();
generateHelper.AppendLine("}");
}
if (IsCreateFindRecId)
{
generateHelper.IndentSetValue(0);
generateHelper.AppendLine("");
generateHelper.AppendLine($"public static {TableName} findRecId(RefRecId _recId, _forUpdate = false)");
//build method header
generateHelper.AppendLine("{");
generateHelper.IndentIncrease();
generateHelper.AppendLine(TableName + " " + VarName + ";");
generateHelper.AppendLine(";");
generateHelper.AppendLine("if (_recId)");
generateHelper.AppendLine("{");
generateHelper.IndentIncrease();
//selectForUpdate
generateHelper.AppendLine(VarName + ".selectForUpdate(_forUpdate);");
generateHelper.AppendLine("");
//build select query
generateHelper.AppendLine("select firstonly " + VarName);
generateHelper.AppendLine(" where " + VarName + ".RecId == _recId;");
generateHelper.IndentDecrease();
generateHelper.AppendLine("}");
generateHelper.AppendLine("");
generateHelper.AppendLine("return " + VarName + ";");
generateHelper.IndentDecrease();
generateHelper.AppendLine("}");
}
if (IsCreateExists)
{
generateHelper.IndentSetValue(0);
generateHelper.AppendLine("");
generateHelper.Append("public static boolean exists(");
generateHelper.IndentSetAsCurrentPos();
// build args and mandatory fields list
mandatoryFields = "";
bool isFirst = true;
foreach (AxTableFieldParm df in Fields.OrderBy(x => x.Position))
{
if (df.IsMandatory || df.FieldName == "RecId")
{
if (mandatoryFields.Length > 0)
{
mandatoryFields += " && ";
}
mandatoryFields += "_" + AxHelper.PrettyName(df.FieldName);
}
if (!isFirst)
{
generateHelper.AppendLine(",");
}
generateHelper.Append(df.FieldType, "Type");
generateHelper.Append($" _{AxHelper.PrettyName(df.FieldName)}");
isFirst = false;
}
generateHelper.AppendLine(")");
//build method header
generateHelper.IndentSetValue(0);
generateHelper.AppendLine("{");
generateHelper.IndentIncrease();
generateHelper.AppendLine("boolean res;");
generateHelper.AppendLine(";");
//check for mandatory fields
if (mandatoryFields != "")
{
generateHelper.AppendLine("if (" + mandatoryFields + ")");
generateHelper.AppendLine("{");
generateHelper.IndentIncrease();
}
//build select query
generateHelper.AppendLine("res = (select firstonly RecId from " + TableName);
generateHelper.Append(" where ");
generateHelper.IndentSetAsCurrentPos();
isFirst = true;
foreach (AxTableFieldParm df in Fields.OrderBy(x => x.Position))
{
if (!isFirst)
{
generateHelper.AppendLine(" && ");
}
generateHelper.Append(TableName + ".");
generateHelper.Append(df.FieldName, "FieldName");
generateHelper.Append(" == _" + AxHelper.PrettyName(df.FieldName));
isFirst = false;
}
generateHelper.IndentRestorePrev();
generateHelper.AppendLine(").RecId != 0;");
//footer
if (mandatoryFields != "")
{
generateHelper.IndentDecrease();
generateHelper.AppendLine("}");
}
generateHelper.AppendLine("");
generateHelper.AppendLine("return res;");
generateHelper.IndentDecrease();
generateHelper.AppendLine("}");
}
var methodText = generateHelper.ResultString.ToString();
return(methodText);
}