/// <summary>
/// Check Existence of Std columns and create them in AD and DB
/// </summary>
/// <param name="table">name of the table</param>
/// <param name="EntityType">Entity Type</param>
public static void CheckStandardColumns(MTable table, String EntityType)
{
if (table == null)
{
return;
}
if (Utility.Util.IsEmpty(EntityType))
{
EntityType = table.GetEntityType();
}
table.GetColumns(true); // get new columns
// Key Column
String colName = table.GetTableName() + "_ID";
if (table.GetColumn(colName) == null)
{
MColumn col = new MColumn(table);
col.SetColumnName(colName);
col.SetAD_Reference_ID(DisplayType.ID);
col.SetIsKey(true);
col.SetIsUpdateable(false);
col.SetIsMandatory(true);
col.SetEntityType(EntityType);
CreateColumn(col, table, true);
}
colName = "AD_Client_ID";
if (table.GetColumn(colName) == null)
{
MColumn col = new MColumn(table);
col.SetColumnName(colName);
col.SetAD_Reference_ID(DisplayType.TableDir);
col.SetIsUpdateable(false);
col.SetIsMandatory(true);
col.SetAD_Val_Rule_ID(116); // Client Login
col.SetDefaultValue("@#AD_Client_ID@");
col.SetConstraintType(X_AD_Column.CONSTRAINTTYPE_Restrict);
col.SetEntityType(EntityType);
CreateColumn(col, table, true);
}
colName = "AD_Org_ID";
if (table.GetColumn(colName) == null)
{
MColumn col = new MColumn(table);
col.SetColumnName(colName);
col.SetAD_Reference_ID(DisplayType.TableDir);
col.SetIsUpdateable(false);
col.SetIsMandatory(true);
col.SetAD_Val_Rule_ID(104); // Org Security
col.SetDefaultValue("@#AD_Org_ID@");
col.SetConstraintType(X_AD_Column.CONSTRAINTTYPE_Restrict);
col.SetEntityType(EntityType);
CreateColumn(col, table, true);
}
colName = "Created";
if (table.GetColumn(colName) == null)
{
MColumn col = new MColumn(table);
col.SetColumnName(colName);
col.SetAD_Reference_ID(DisplayType.DateTime);
col.SetIsUpdateable(false);
col.SetIsMandatory(true);
col.SetEntityType(EntityType);
CreateColumn(col, table, true);
}
colName = "Updated";
if (table.GetColumn(colName) == null)
{
MColumn col = new MColumn(table);
col.SetColumnName(colName);
col.SetAD_Reference_ID(DisplayType.DateTime);
col.SetIsUpdateable(false);
col.SetIsMandatory(true);
col.SetEntityType(EntityType);
CreateColumn(col, table, true);
}
colName = "CreatedBy";
if (table.GetColumn(colName) == null)
{
MColumn col = new MColumn(table);
col.SetColumnName(colName);
col.SetAD_Reference_ID(DisplayType.Table);
col.SetAD_Reference_Value_ID(110);
col.SetConstraintType(X_AD_Column.CONSTRAINTTYPE_DoNOTCreate);
col.SetIsUpdateable(false);
col.SetIsMandatory(true);
col.SetEntityType(EntityType);
CreateColumn(col, table, true);
}
colName = "UpdatedBy";
if (table.GetColumn(colName) == null)
{
MColumn col = new MColumn(table);
col.SetColumnName(colName);
col.SetAD_Reference_ID(DisplayType.Table);
col.SetAD_Reference_Value_ID(110);
col.SetConstraintType(X_AD_Column.CONSTRAINTTYPE_DoNOTCreate);
col.SetIsUpdateable(false);
col.SetIsMandatory(true);
col.SetEntityType(EntityType);
CreateColumn(col, table, true);
}
colName = "IsActive";
if (table.GetColumn(colName) == null)
{
MColumn col = new MColumn(table);
col.SetColumnName(colName);
col.SetAD_Reference_ID(DisplayType.YesNo);
col.SetDefaultValue("Y");
col.SetIsUpdateable(true);
col.SetIsMandatory(true);
col.SetEntityType(EntityType);
CreateColumn(col, table, true);
}
colName = "Export_ID";
if (table.GetColumn(colName) == null)
{
MColumn col = new MColumn(table);
col.SetColumnName(colName);
col.SetAD_Reference_ID(DisplayType.String);
col.SetIsUpdateable(true);
col.SetIsMandatory(false);
col.SetEntityType(EntityType);
col.SetFieldLength(50);
CreateColumn(col, table, true);
}
} // checkStandardColumns