} // createParameter
/// <summary>
/// Make a standard field (Created/Updated/By)
/// </summary>
/// <param name="ctx">context</param>
/// <param name="windowNo">window number</param>
/// <param name="tabNo">tab number</param>
/// <param name="AD_Window_ID">Window_ID</param>
/// <param name="AD_Tab_ID">Tab Id</param>
/// <param name="tabReadOnly">tab readonly</param>
/// <param name="isCreated">is prefic created column</param>
/// <param name="isTimestamp">is prefix "update" column</param>
/// <returns></returns>
public static GridFieldVO CreateStdField(Ctx ctx, int windowNo, int tabNo,
int AD_Window_ID, int AD_Tab_ID, bool tabReadOnly,
bool isCreated, bool isTimestamp)
{
GridFieldVO vo = new GridFieldVO(ctx, windowNo, tabNo,
AD_Window_ID, AD_Tab_ID, tabReadOnly);
vo.ColumnName = isCreated ? "Created" : "Updated";
if (!isTimestamp)
{
vo.ColumnName += "By";
}
vo.displayType = isTimestamp ? DisplayType.DateTime : DisplayType.Table;
if (!isTimestamp)
{
vo.AD_Reference_Value_ID = 110; // AD_User Table Reference
}
vo.IsDisplayedf = false;
vo.IsMandatoryUI = false;
vo.IsReadOnly = false;
vo.IsUpdateable = true;
vo.InitFinish();
return(vo);
} // initStdField
/// <summary>
///Clone Field object
/// </summary>
/// <param name="Ctx">context</param>
/// <param name="windowNo">window number</param>
/// <param name="tabNo">tab number</param>
/// <param name="ad_Window_ID">window_id</param>
/// <param name="ad_Tab_ID">tab_ id</param>
/// <param name="TabReadOnly">is tabreadonly</param>
/// <returns>this object</returns>
public GridFieldVO Clone(Ctx ctx, int windowNo, int tabNo,
int ad_Window_ID, int ad_Tab_ID,
bool TabReadOnly)
{
GridFieldVO clone = new GridFieldVO(ctx, windowNo, tabNo,
ad_Window_ID, ad_Tab_ID, TabReadOnly);
clone.isProcess = false;
// Database Fields
clone.ColumnName = ColumnName;
clone.ColumnSQL = ColumnSQL;
clone.Header = Header;
clone.displayType = displayType;
clone.AD_Table_ID = AD_Table_ID;
clone.AD_Column_ID = AD_Column_ID;
clone.DisplayLength = DisplayLength;
clone.IsSameLine = IsSameLine;
clone.IsDisplayedf = IsDisplayedf;
clone.IsDisplayedMR = IsDisplayedMR;
clone.DisplayLogic = DisplayLogic;
clone.DefaultValue = DefaultValue;
clone.IsMandatoryUI = IsMandatoryUI;
clone.IsReadOnly = IsReadOnly;
clone.IsUpdateable = IsUpdateable;
clone.IsAlwaysUpdateable = IsAlwaysUpdateable;
clone.IsHeading = IsHeading;
clone.IsFieldOnly = IsFieldOnly;
clone.IsEncryptedField = IsEncryptedField;
clone.IsEncryptedColumn = IsEncryptedColumn;
clone.IsSelectionColumn = IsSelectionColumn;
//clone.IsIncludedColumn = IsIncludedColumn;
clone.SelectionSeqNo = SelectionSeqNo;
clone.SortNo = SortNo;
clone.FieldLength = FieldLength;
clone.VFormat = VFormat;
clone.ValueMin = ValueMin;
clone.ValueMax = ValueMax;
clone.FieldGroup = FieldGroup;
clone.IsKey = IsKey;
clone.IsParent = IsParent;
clone.Callout = Callout;
clone.AD_Process_ID = AD_Process_ID;
clone.Description = Description;
clone.Help = Help;
clone.ReadOnlyLogic = ReadOnlyLogic;
clone.ObscureType = ObscureType;
clone.IsDefaultFocus = IsDefaultFocus;
// Lookup
clone.ValidationCode = ValidationCode;
clone.AD_Reference_Value_ID = AD_Reference_Value_ID;
clone.lookupInfo = lookupInfo;
// Process Parameter
clone.isRange = isRange;
clone.DefaultValue2 = DefaultValue2;
//Lakhwinder
clone.AD_Field_ID = AD_Field_ID;
clone.AD_InfoWindow_ID = AD_InfoWindow_ID;
//Harwinder
clone.MobileListingFormat = MobileListingFormat;
clone.mrSeqNo = mrSeqNo;
clone.ZoomWindow_ID = ZoomWindow_ID;
clone.isLink = isLink;
clone.isRightPaneLink = isRightPaneLink;
clone.IsCopy = IsCopy;
clone.ColumnWidth = ColumnWidth;
clone.AD_Form_ID = AD_Form_ID;
clone.IsBackgroundProcess = IsBackgroundProcess;
clone.AskUserBGProcess = AskUserBGProcess;
clone.IsHeaderPanelitem = IsHeaderPanelitem;
clone.HeaderOverrideReference = HeaderOverrideReference;
clone.HeaderStyle = HeaderStyle;
clone.HeaderHeadingOnly = HeaderHeadingOnly;
clone.HeaderSeqno = HeaderSeqno;
clone.HeaderIconOnly = HeaderIconOnly;
clone.HtmlStyle = HtmlStyle;
clone.ShowIcon = ShowIcon;
clone.AD_Image_ID = AD_Image_ID;
clone.FontClass = FontClass;
clone.ImageName = ImageName;
clone.IsMaintainVersions = IsMaintainVersions;
clone.CellSpace = CellSpace;
clone.FieldBreadth = FieldBreadth;
clone.LineBreak = LineBreak;
clone.FieldGroupDefault = FieldGroupDefault;
clone.ShowFilterOption = ShowFilterOption;
return(clone);
}
/// <summary>
/// Create Field Value Object
/// </summary>
/// <param name="ctx">context</param>
/// <param name="WindowNo">window number</param>
/// <param name="TabNo">tab number</param>
/// <param name="AD_Window_ID">window Id</param>
/// <param name="AD_Tab_ID">Tab Id</param>
/// <param name="readOnly">is readonly</param>
/// <param name="dr">datarow</param>
/// <returns>object of this Class</returns>
public static GridFieldVO Create(Ctx ctx, int windowNo, int tabNo,
int AD_Window_ID, int AD_Tab_ID, bool readOnly, IDataReader dr)
{
GridFieldVO vo = new GridFieldVO(ctx, windowNo, tabNo,
AD_Window_ID, AD_Tab_ID, readOnly);
String columnName = "ColumnName";
try
{
vo.ColumnName = dr["ColumnName"].ToString();
if (vo.ColumnName == null || columnName.Trim().Length == 0)
{
return(null);
}
// VLogger.Get().Fine(vo.ColumnName);
//ResultSetMetaData rsmd = dr.getMetaData();
for (int i = 0; i < dr.FieldCount; i++)
{
columnName = dr.GetName(i).ToUpper();// rsmd.getColumnName(i);
if (columnName.Equals("NAME"))
{
vo.Header = dr[i].ToString();
}
else if (columnName.Equals("AD_REFERENCE_ID"))
{
vo.displayType = Utility.Util.GetValueOfInt(dr[i]);// Utility.Util.GetValueOfInt(dr[i])
}
else if (columnName.Equals("AD_COLUMN_ID"))
{
vo.AD_Column_ID = Utility.Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("AD_INFOWINDOW_ID"))
{
vo.AD_InfoWindow_ID = Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("AD_TABLE_ID"))
{
vo.AD_Table_ID = Utility.Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("DISPLAYLENGTH"))
{
vo.DisplayLength = Utility.Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("ISSAMELINE"))
{
vo.IsSameLine = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("ISDISPLAYED"))
{
vo.IsDisplayedf = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("MRISDISPLAYED"))
{
vo.IsDisplayedMR = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("DISPLAYLOGIC"))
{
vo.DisplayLogic = dr[i].ToString();
}
else if (columnName.Equals("DEFAULTVALUE"))
{
vo.DefaultValue = dr[i].ToString();
}
else if (columnName.Equals("ISMANDATORYUI"))
{
vo.IsMandatoryUI = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("ISREADONLY"))
{
vo.IsReadOnly = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("ISUPDATEABLE"))
{
vo.IsUpdateable = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("ISALWAYSUPDATEABLE"))
{
vo.IsAlwaysUpdateable = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("ISHEADING"))
{
vo.IsHeading = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("ISFIELDONLY"))
{
vo.IsFieldOnly = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("ISENCRYPTEDFIELD"))
{
vo.IsEncryptedField = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("ISENCRYPTEDCOLUMN"))
{
vo.IsEncryptedColumn = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("ISSELECTIONCOLUMN"))
{
vo.IsSelectionColumn = "Y".Equals(dr[i].ToString());
}
//else if (columnName.Equals("ISINCLUDEDCOLUMN"))
// vo.IsIncludedColumn = "Y".Equals(dr[i].ToString());
else if (columnName.Equals("SELECTIONSEQNO"))
{
vo.SelectionSeqNo = Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("SORTNO"))
{
vo.SortNo = Utility.Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("FIELDLENGTH"))
{
vo.FieldLength = Utility.Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("VFORMAT"))
{
vo.VFormat = dr[i].ToString();
}
else if (columnName.Equals("VALUEMIN"))
{
vo.ValueMin = dr[i].ToString();
}
else if (columnName.Equals("VALUEMAX"))
{
vo.ValueMax = dr[i].ToString();
}
else if (columnName.Equals("FIELDGROUP"))
{
vo.FieldGroup = Env.TrimModulePrefix(dr[i].ToString());
}
else if (columnName.Equals("ISKEY"))
{
vo.IsKey = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("ISPARENT"))
{
vo.IsParent = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("DESCRIPTION"))
{
vo.Description = dr[i].ToString();
}
else if (columnName.Equals("HELP"))
{
vo.Help = dr[i].ToString();
}
else if (columnName.Equals("CALLOUT"))
{
vo.Callout = dr[i].ToString();
if (!string.IsNullOrEmpty(vo.Callout))
{
Tuple <string, string, string> tpl = null;
StringTokenizer st = new StringTokenizer(vo.Callout, ";,", false);
StringBuilder callouts = new StringBuilder();
bool hasModulePrefix = Env.HasModulePrefix(vo.ColumnName, out tpl);
while (st.HasMoreTokens()) // for each callout
{
string prefix = "";
String cmd = st.NextToken().Trim();
if (hasModulePrefix)
{
prefix = vo.ColumnName.Substring(0, vo.ColumnName.IndexOf('_'));
}
else
{
String className = cmd.Substring(0, cmd.LastIndexOf("."));
className = className.Remove(0, className.LastIndexOf(".") + 1);
if (Env.HasModulePrefix(className, out tpl))
{
prefix = className.Substring(0, className.IndexOf('_'));
}
}
if (callouts.Length > 0)
{
if (prefix.Length > 0)
{
callouts.Append(";").Append(cmd.Replace("ViennaAdvantage", prefix));
}
else
{
callouts.Append(";").Append(cmd);
}
}
else
{
if (prefix.Length > 0)
{
callouts.Append(cmd.Replace("ViennaAdvantage", prefix));
}
else
{
callouts.Append(";").Append(cmd);
}
}
}
vo.Callout = callouts.ToString();
}
}
else if (columnName.Equals("AD_PROCESS_ID"))
{
vo.AD_Process_ID = Utility.Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("AD_FORM_ID"))
{
vo.AD_Form_ID = Utility.Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("READONLYLOGIC"))
{
vo.ReadOnlyLogic = dr[i].ToString();
}
else if (columnName.Equals("MANDATORYLOGIC"))
{
vo.mandatoryLogic = dr[i].ToString();
}
else if (columnName.Equals("OBSCURETYPE"))
{
vo.ObscureType = dr[i].ToString();
}
else if (columnName.Equals("ISDEFAULTFOCUS"))
{
vo.IsDefaultFocus = "Y".Equals(dr[i].ToString());
}
//
else if (columnName.Equals("AD_REFERENCE_VALUE_ID"))
{
vo.AD_Reference_Value_ID = Utility.Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("VALIDATIONCODE"))
{
vo.ValidationCode = dr[i].ToString();
}
else if (columnName.Equals("COLUMNSQL"))
{
vo.ColumnSQL = dr[i].ToString();
}
else if (columnName.Equals("AD_FIELD_ID"))
{
vo.AD_Field_ID = Utility.Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("MOBILELISTINGFORMAT"))
{
vo.MobileListingFormat = Utility.Util.GetValueOfString(dr[i]);
}
else if (columnName.Equals("MRSEQNO"))
{
if (dr[i] != null && dr[i] != DBNull.Value)
{
int mrseq = Util.GetValueOfInt(dr[i]);
if (mrseq >= 0)
{
vo.mrSeqNo = mrseq;
}
}
}
else if (columnName.Equals("ZOOMWINDOW_ID"))
{
vo.ZoomWindow_ID = Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("ISLINK"))
{
vo.isLink = "Y".Equals(Util.GetValueOfString(dr[i]));
}
else if (columnName.Equals("ISRIGHTPANELINK"))
{
vo.isRightPaneLink = "Y".Equals(Util.GetValueOfString(dr[i]));
}
else if (columnName.Equals("ISCOPY"))
{
vo.IsCopy = "Y".Equals(Util.GetValueOfString(dr[i]));
}
else if (columnName.Equals("COLUMNWIDTH"))
{
vo.ColumnWidth = Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("ISBACKGROUNDPROCESS"))
{
vo.IsBackgroundProcess = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("ASKUSERBGPROCESS"))
{
vo.AskUserBGProcess = "Y".Equals(dr[i].ToString());
}
/******************************/
else if (columnName.Equals("Isheaderpanelitem", StringComparison.OrdinalIgnoreCase))
{
vo.IsHeaderPanelitem = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("Headeroverridereference", StringComparison.OrdinalIgnoreCase))
{
vo.HeaderOverrideReference = Utility.Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("HeaderStyle", StringComparison.OrdinalIgnoreCase))
{
vo.HeaderStyle = dr[i].ToString();
}
else if (columnName.Equals("HeaderHeadingOnly", StringComparison.OrdinalIgnoreCase))
{
vo.HeaderHeadingOnly = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("HeaderSeqno", StringComparison.OrdinalIgnoreCase))
{
vo.HeaderSeqno = Utility.Util.GetValueOfDecimal(dr[i]);
}
else if (columnName.Equals("HeaderIconOnly", StringComparison.OrdinalIgnoreCase))
{
vo.HeaderIconOnly = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("HtmlStyle", StringComparison.OrdinalIgnoreCase))
{
vo.HtmlStyle = dr[i].ToString();
}
else if (columnName.Equals("ShowIcon", StringComparison.OrdinalIgnoreCase))
{
vo.ShowIcon = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("AD_Image_ID", StringComparison.OrdinalIgnoreCase))
{
vo.AD_Image_ID = Utility.Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("PlaceHolder", StringComparison.OrdinalIgnoreCase))
{
vo.PlaceHolder = Utility.Util.GetValueOfString(dr[i]);
}
else if (columnName.Equals("FontName", StringComparison.OrdinalIgnoreCase))
{
vo.FontClass = Utility.Util.GetValueOfString(dr[i]);
}
else if (columnName.Equals("ImageUrl", StringComparison.OrdinalIgnoreCase))
{
vo.ImageName = Utility.Util.GetValueOfString(dr[i]);
if (vo.ImageName != "" && vo.ImageName.Contains("/"))
{
vo.ImageName = vo.ImageName.Substring(vo.ImageName.LastIndexOf("/") + 1);
}
}
// new column added for maintain versions
else if (columnName.Equals("ISMAINTAINVERSIONS", StringComparison.OrdinalIgnoreCase))
{
vo.IsMaintainVersions = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("CellSpace", StringComparison.OrdinalIgnoreCase))
{
vo.CellSpace = Utility.Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("FieldBreadth", StringComparison.OrdinalIgnoreCase))
{
vo.FieldBreadth = Utility.Util.GetValueOfInt(dr[i]);
}
else if (columnName.Equals("IsLineBreak", StringComparison.OrdinalIgnoreCase))
{
vo.LineBreak = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("FieldGroupDefault", StringComparison.OrdinalIgnoreCase))
{
vo.FieldGroupDefault = "Y".Equals(dr[i].ToString());
}
else if (columnName.Equals("ShowFilterOption", StringComparison.OrdinalIgnoreCase))
{
vo.ShowFilterOption = "Y".Equals(dr[i].ToString());
}
}
if (vo.Header == null)
{
vo.Header = vo.ColumnName;
}
}
catch (Exception e)
{
VLogger.Get().Log(Level.SEVERE, "ColumnName=" + columnName, e);
return(null);
}
vo.InitFinish();
return(vo);
}
/// <summary>
/// Clone object
/// </summary>
/// <param name="myCtx">Context</param>
/// <param name="windowNo">window number</param>
/// <returns></returns>
public GridTabVO Clone(Ctx myCtx, int windowNo)
{
GridTabVO clone = new GridTabVO(myCtx, windowNo);
clone.AD_Window_ID = AD_Window_ID;
clone.tabNo = tabNo;
//
clone.AD_Tab_ID = AD_Tab_ID;
myCtx.SetContext(windowNo, clone.tabNo, "AD_Tab_ID", clone.AD_Tab_ID.ToString());
clone.Referenced_Tab_ID = Referenced_Tab_ID;
clone.Name = Name;
myCtx.SetContext(windowNo, clone.tabNo, "Name", clone.Name);
clone.Description = Description;
clone.Help = Help;
clone.IsSingleRow = IsSingleRow;
clone.IsReadOnly = IsReadOnly;
clone.IsInsertRecord = IsInsertRecord;
clone.HasTree = HasTree;
clone.ShowSummaryLevel = ShowSummaryLevel;
clone.AD_Table_ID = AD_Table_ID;
clone.AD_Column_ID = AD_Column_ID;
clone.TableName = TableName;
clone.IsView = IsView;
clone.AccessLevel = AccessLevel;
clone.IsSecurityEnabled = IsSecurityEnabled;
clone.IsDeleteable = IsDeleteable;
clone.IsHighVolume = IsHighVolume;
clone.AD_Process_ID = AD_Process_ID;
clone.CommitWarning = CommitWarning;
clone.WhereClause = WhereClause;
clone.OrderByClause = OrderByClause;
clone.ReadOnlyLogic = ReadOnlyLogic;
clone.DisplayLogic = DisplayLogic;
clone.TabLevel = TabLevel;
clone.AD_Image_ID = AD_Image_ID;
clone.Included_Tab_ID = Included_Tab_ID;
clone.ReplicationType = ReplicationType;
myCtx.SetContext(windowNo, clone.tabNo, "AccessLevel", clone.AccessLevel);
myCtx.SetContext(windowNo, clone.tabNo, "AD_Table_ID", clone.AD_Table_ID.ToString());
//
clone.IsSortTab = IsSortTab;
clone.AD_ColumnSortOrder_ID = AD_ColumnSortOrder_ID;
clone.AD_ColumnSortYesNo_ID = AD_ColumnSortYesNo_ID;
// Derived
clone.onlyCurrentDays = 0;
//Tab Panles
clone.panels = new List <GridTabPanelVO>();
for (int i = 0; i < panels.Count; i++)
{
GridTabPanelVO tpo = panels[i];
GridTabPanelVO clonetp = tpo.Clone(myCtx, windowNo);
if (clonetp == null)
{
return(null);
}
clone.panels.Add(clonetp);
}
if (clone.panels != null && clone.panels.Count > 0)
{
clone.HasPanels = true;
}
clone.locationCols = locationCols;
clone.fields = new List <GridFieldVO>();
for (int i = 0; i < fields.Count; i++)
{
GridFieldVO field = fields[i];
GridFieldVO cloneField = field.Clone(myCtx, windowNo, tabNo,
AD_Window_ID, AD_Tab_ID, IsReadOnly);
if (cloneField == null)
{
return(null);
}
clone.fields.Add(cloneField);
}
return(clone);
}
/// <summary>
/// Create Tab Fields
/// </summary>
/// <param name="mTabVO"></param>
/// <param name="AD_UserDef_Win_ID"></param>
/// <returns></returns>
private static bool CreateEditorFields(GridTabVO mTabVO, int AD_UserDef_Win_ID)
{
mTabVO.fields = new List <GridFieldVO>();
bool isBase = true;
if (!Env.IsBaseLanguage(mTabVO.ctx, "AD_Tab"))
{
isBase = false;
}
StringBuilder sql = new StringBuilder(" SELECT ")
.Append(" t.AD_Window_ID AS AD_Window_ID , ")
.Append(" f.AD_Tab_ID AS AD_Tab_ID , ")
.Append(" f.AD_Field_ID AS AD_Field_ID , ")
.Append(" tbl.AD_Table_ID AS AD_Table_ID , ")
.Append(" f.AD_Column_ID AS AD_Column_ID , ")
.Append(" uw.AD_Role_ID AS UserDef_Role_ID , ")
.Append(" uw.AD_User_ID AS AD_User_ID , ")
.Append(" uw.AD_UserDef_Win_ID AS AD_UserDef_Win_ID , ")
.Append(" uw.CustomizationName AS CustomizationName , ")
.Append(" u.AD_UserDef_Tab_ID AS AD_UserDef_Tab_ID , ")
.Append(" u.AD_UserDef_Field_ID AS AD_UserDef_Field_ID , ");
if (!isBase)
{
sql.Append(" COALESCE(u.Name,trl.Name) AS Name , ")
.Append(" COALESCE(u.Description,trl.Description) AS Description , ")
.Append(" COALESCE(u.Help,trl.Help) AS Help , ");
}
else
{
sql.Append(" COALESCE(u.Name,f.Name) AS Name , ")
.Append(" COALESCE(u.Description,f.Description) AS Description , ")
.Append(" COALESCE(u.Help,f.Help) AS Help , ");
}
sql.Append(" COALESCE(u.IsDisplayed,f.IsDisplayed) AS IsDisplayed , ")
.Append(" COALESCE(u.DisplayLogic,f.DisplayLogic) AS DisplayLogic , ")
.Append(" COALESCE(u.DisplayLength,f.DisplayLength) AS DisplayLength , ")
.Append(" COALESCE(u.SeqNo,f.SeqNo) AS SeqNo , ")
.Append(" COALESCE(u.SortNo,f.SortNo) AS SortNo , ")
.Append(" COALESCE(u.IsSameLine,f.IsSameLine) AS IsSameLine , ")
.Append(" f.IsHeading AS IsHeading , ")
.Append(" f.IsFieldOnly AS IsFieldOnly , ")
.Append(" f.IsReadOnly AS IsReadOnly , ")
.Append(" f.IsEncrypted AS IsEncryptedField , ")
.Append(" f.ObscureType AS ObscureType , ")
.Append(" f.IsDefaultFocus AS IsDefaultFocus , ")
.Append(" COALESCE(u.MRSeqNo,f.MRSeqNo) AS MRSeqNo , ")
.Append(" c.ColumnName AS ColumnName , ")
.Append(" c.ColumnSQL AS ColumnSQL , ")
.Append(" c.FieldLength AS FieldLength , ")
.Append(" c.VFormat AS VFormat , ")
.Append(" COALESCE(u.DefaultValue,COALESCE(f.DefaultValue,c.DefaultValue)) AS DefaultValue , ")
.Append(" c.IsKey AS IsKey , ")
.Append(" c.IsParent AS IsParent , ")
.Append(" c.IsMandatory AS IsMandatory , ")
.Append(" c.MandatoryLogic AS MandatoryLogic , ")
.Append(" COALESCE(COALESCE(u.IsMandatoryUI,f.IsMandatoryUI),c.IsMandatoryUI) AS IsMandatoryUI , ")
.Append(" c.IsIdentifier AS IsIdentifier , ")
.Append(" c.IsTranslated AS IsTranslated , ")
.Append(" c.AD_Reference_Value_ID AS AD_Reference_Value_ID, ")
.Append(" c.Callout AS Callout , ")
.Append(" c.IsCallout AS IsCallout , ")
.Append(" COALESCE(f.AD_Reference_ID,c.AD_Reference_ID) AS AD_Reference_ID , ")
.Append(" c.AD_Val_Rule_ID AS AD_Val_Rule_ID , ")
.Append(" c.AD_Process_ID AS AD_Process_ID , ")
.Append(" c.IsAlwaysUpdateable AS IsAlwaysUpdateable , ")
.Append(" c.ReadOnlyLogic AS ReadOnlyLogic , ")
.Append(" c.IsUpdateable AS IsUpdateable , ")
.Append(" c.IsEncrypted AS IsEncryptedColumn , ")
.Append(" COALESCE(u.IsSelectionColumn,c.IsSelectionColumn) AS IsSelectionColumn , ")
.Append(" COALESCE(u.SelectionSeqNo,c.SelectionSeqNo) AS SelectionSeqNo , ")
.Append(" COALESCE(u.IsSummaryColumn,c.IsSummaryColumn) AS IsSummaryColumn , ")
.Append(" COALESCE(u.SummarySeqNo,c.SummarySeqNo) AS SummarySeqNo , ")
.Append(" tbl.TableName AS TableName , ")
.Append(" COALESCE(u.ValueMin,c.ValueMin) AS ValueMin , ")
.Append(" COALESCE(u.ValueMax,c.ValueMax) AS ValueMax , ")
.Append(" fgt.Name AS FieldGroup , ")
.Append(" vr.Code AS ValidationCode ");
if (isBase)
{
sql.Append(" FROM AD_Field f ");
}
else
{
sql.Append(" FROM AD_Field f ")
.Append(" INNER JOIN AD_Field_Trl trl ON f.AD_Field_ID = trl.AD_Field_ID ");
}
sql.Append(" INNER JOIN AD_Tab t ON (f.AD_Tab_ID = t.AD_Tab_ID) LEFT OUTER JOIN ");
if (isBase)
{
sql.Append(" AD_FieldGroup fgt ON (f.AD_FieldGroup_ID = fgt.AD_FieldGroup_ID) ");
}
else
{
sql.Append(" AD_FieldGroup_Trl fgt ON (f.AD_FieldGroup_ID = fgt.AD_FieldGroup_ID AND trl.AD_Language =fgt.AD_Language) ");
}
sql.Append(" LEFT OUTER JOIN AD_Column c ON (f.AD_Column_ID = c.AD_Column_ID) INNER JOIN AD_Table tbl ON (c.AD_Table_ID = tbl.AD_Table_ID) ")
.Append(" INNER JOIN AD_Reference r ON (c.AD_Reference_ID = r.AD_Reference_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) ")
.Append(" LEFT OUTER JOIN AD_UserDef_Field u ON (f.AD_Field_ID=u.AD_Field_ID) LEFT OUTER JOIN AD_UserDef_Tab ut ON (ut.AD_UserDef_Tab_ID=u.AD_UserDef_Tab_ID) ")
.Append(" LEFT OUTER JOIN AD_UserDef_Win uw ON (uw.AD_UserDef_Win_ID=ut.AD_UserDef_Win_ID) ")
.Append(" WHERE f.AD_Tab_ID=@tabID");
if (!isBase)
{
sql.Append(" AND trl.AD_Language='" + Env.GetAD_Language(mTabVO.ctx) + "'");
}
if (AD_UserDef_Win_ID != 0)
{
sql.Append(" AND u.AD_UserDef_Win_ID=" + AD_UserDef_Win_ID);
}
sql.Append(" ORDER BY IsDisplayed DESC, SeqNo");
int AD_Tab_ID = mTabVO.Referenced_Tab_ID;
if (AD_Tab_ID == 0)
{
AD_Tab_ID = mTabVO.AD_Tab_ID;
}
IDataReader dr = null;
try
{
//PreparedStatement pstmt = DataBase.prepareStatement(sql, null);
System.Data.SqlClient.SqlParameter[] param = new System.Data.SqlClient.SqlParameter[1];
param[0] = new System.Data.SqlClient.SqlParameter("@tabID", AD_Tab_ID);
//pstmt.setInt(1, AD_Tab_ID);
dr = DataBase.DB.ExecuteReader(sql.ToString(), param, null);
while (dr.Read())
{
GridFieldVO voF = GridFieldVO.Create(mTabVO.ctx,
mTabVO.windowNo, mTabVO.tabNo,
mTabVO.AD_Window_ID, AD_Tab_ID,
mTabVO.IsReadOnly, dr);
if (voF != null)
{
mTabVO.fields.Add(voF);
}
}
dr.Close();
param = null;
}
catch (Exception e)
{
if (dr != null)
{
dr.Close();
}
VLogger.Get().Log(Level.SEVERE, sql.ToString(), e);
return(false);
}
return(mTabVO.fields.Count != 0);
}
/// <summary>
///Clone Field object
/// </summary>
/// <param name="Ctx">context</param>
/// <param name="windowNo">window number</param>
/// <param name="tabNo">tab number</param>
/// <param name="ad_Window_ID">window_id</param>
/// <param name="ad_Tab_ID">tab_ id</param>
/// <param name="TabReadOnly">is tabreadonly</param>
/// <returns>this object</returns>
public GridFieldVO Clone(Ctx ctx, int windowNo, int tabNo,
int ad_Window_ID, int ad_Tab_ID,
bool TabReadOnly)
{
GridFieldVO clone = new GridFieldVO(ctx, windowNo, tabNo,
ad_Window_ID, ad_Tab_ID, TabReadOnly);
clone.isProcess = false;
// Database Fields
clone.ColumnName = ColumnName;
clone.ColumnSQL = ColumnSQL;
clone.Header = Header;
clone.displayType = displayType;
clone.AD_Table_ID = AD_Table_ID;
clone.AD_Column_ID = AD_Column_ID;
clone.DisplayLength = DisplayLength;
clone.IsSameLine = IsSameLine;
clone.IsDisplayedf = IsDisplayedf;
clone.DisplayLogic = DisplayLogic;
clone.DefaultValue = DefaultValue;
clone.IsMandatoryUI = IsMandatoryUI;
clone.IsReadOnly = IsReadOnly;
clone.IsUpdateable = IsUpdateable;
clone.IsAlwaysUpdateable = IsAlwaysUpdateable;
clone.IsHeading = IsHeading;
clone.IsFieldOnly = IsFieldOnly;
clone.IsEncryptedField = IsEncryptedField;
clone.IsEncryptedColumn = IsEncryptedColumn;
clone.IsSelectionColumn = IsSelectionColumn;
clone.SelectionSeqNo = SelectionSeqNo;
clone.SortNo = SortNo;
clone.FieldLength = FieldLength;
clone.VFormat = VFormat;
clone.ValueMin = ValueMin;
clone.ValueMax = ValueMax;
clone.FieldGroup = FieldGroup;
clone.IsKey = IsKey;
clone.IsParent = IsParent;
clone.Callout = Callout;
clone.AD_Process_ID = AD_Process_ID;
clone.Description = Description;
clone.Help = Help;
clone.ReadOnlyLogic = ReadOnlyLogic;
clone.ObscureType = ObscureType;
clone.IsDefaultFocus = IsDefaultFocus;
// Lookup
clone.ValidationCode = ValidationCode;
clone.AD_Reference_Value_ID = AD_Reference_Value_ID;
clone.lookupInfo = lookupInfo;
// Process Parameter
clone.isRange = isRange;
clone.DefaultValue2 = DefaultValue2;
//Lakhwinder
clone.AD_Field_ID = AD_Field_ID;
clone.AD_InfoWindow_ID = AD_InfoWindow_ID;
//Harwinder
clone.MobileListingFormat = MobileListingFormat;
clone.mrSeqNo = mrSeqNo;
clone.ZoomWindow_ID = ZoomWindow_ID;
clone.isLink = isLink;
clone.isRightPaneLink = isRightPaneLink;
return(clone);
}
