/// <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);