/// <summary>
/// Initialize Setting Service
/// </summary>
/// <returns></returns>
private bool Init()
{
if (_setupOk)
{
return(true);
}
try
{
UserDefinedHelper.CreateTable(UdtSettings, "Settings")
.CreateUDF(UdfSettingValue, "Value", size: ValueMaxLength);
UserDefinedHelper.IncreaseUserFieldSize($"@{UdtSettings}", UdfSettingValue, ValueMaxLength);
_setupOk = true;
SboApp.Logger.Info("SettingService Init [OK]");
}
catch (Exception e)
{
SboApp.Logger.Error($"SettingService Init [NOT OK] {e.Message}", e);
_setupOk = false;
throw;
}
return(_setupOk);
}
/// <summary>
/// Create Table
/// </summary>
public void Create()
{
UserDefinedHelper.CreateTable(TableName, TableDescription, TableType);
UserDefiniedFields.ToList().ForEach(udf =>
{
udf.Create();
});
}
public void Run()
{
// Fluid API Style
UserDefinedHelper.CreateTable("ITCO_MyTbl", "My Table")
.CreateUDF("ITCO_MyField1", "My Field 1", BoFieldTypes.db_Alpha, 30)
.CreateUDF("ITCO_MyField2", "My Field 2", BoFieldTypes.db_Numeric, 10)
.CreateUDF("ITCO_MyField2", "My Field 2", BoFieldTypes.db_Numeric, 10);
UserDefinedHelper.CreateField(
SboTable.BusinessPartner, "ITCO_YesNo", "Yes or no?",
BoFieldTypes.db_Alpha, 1, validValues: UserDefinedHelper.YesNoValiesValues);
// Init Setting
SettingService.Instance.InitSetting("itco.savepath", "Save path", @"c:\temp\");
}
/// <summary>
/// Run Setup
/// </summary>
public void Run()
{
UserDefinedHelper.CreateTable(UdtChangeTracker, "Change Tracker")
.CreateUDF(UdfKey, "Key")
.CreateUDF(UdfObj, "Object Type");
}
/// <summary> /// Create field /// </summary> public void Create() => UserDefinedHelper.CreateField(TableName, FieldName, FieldDescription, Type, Size, SubType, ValidValues, DefaultValue, LinkedTable, EditSize);
