/// <summary> /// Get active Items /// </summary> /// <returns>items</returns> public static MChart[] GetCharts(Ctx ctx) { List <MChart> list = new List <MChart>(); String sql = "SELECT pfi.AD_CLIENT_ID, " + "pfi.AD_ORG_ID, " + "pfi.CHARTTYPE, " + "pfi.D_CHART_ID, " + "pfi.ENABLE3D , " + "pfi.ISACTIVE, " + "pfi.NAME, " + "pfi.AD_CHART_BG_COLOR_ID, " + "pfi.ISSHOWLEGEND, " + "pfi.ISSHOWZEROSERIES, " + "pfi.SEQNO, " + "pfi.IsTiltLabel " + "FROM D_Chart pfi INNER JOIN D_CHARTACCESS DCA " + "ON pfi.D_CHART_ID=DCA.D_CHART_ID " + "INNER JOIN (SELECT DISTINCT D_CHART_ID FROM D_Series WHERE ISACTIVE ='Y') ds " + "ON DS.D_CHART_ID = DCA.D_CHART_ID " + "WHERE pfi.IsActive='Y' " + "AND DCA.AD_ROLE_ID='" + ctx.GetAD_Role_ID() + "' AND DCA.ISACTIVE='Y' AND DCA.ISREADWRITE = 'Y' ORDER BY SeqNo asc"; MRole role = MRole.GetDefault(ctx, false); if (role.IsTableAccess(Table_ID, false)) { try { //SqlParameter[] param = new SqlParameter[1]; //param[0] = new SqlParameter("@D_ChartID", Get_ID()); DataSet ds = DB.ExecuteDataset(sql, null); foreach (DataRow dr in ds.Tables[0].Rows) { MChart pfi = new MChart(ctx, dr, null); //if (role.IsColumnAccess(GetAD_Table_ID(), pfi.GetAD_Column_ID(), true)) list.Add(pfi); } } catch (Exception e) { s_log.Severe(e.ToString()); //log entry, if any } } // MChart[] retValue = new MChart[list.Count]; retValue = list.ToArray(); return(retValue); } // getItems
} // create /// <summary> /// Load Tab Details from dr into vo /// </summary> /// <param name="vo">GridTabVO object</param> /// <param name="dr">Datarow</param> /// <returns>true if successful</returns> private static bool LoadTabDetails(GridTabVO vo, IDataReader dr) { MRole role = MRole.GetDefault(vo.ctx, false); bool showTrl = "Y".Equals(vo.ctx.GetContext("#ShowTrl")) || DataBase.GlobalVariable.IsVisualEditor; bool showAcct = "Y".Equals(vo.ctx.GetContext("#ShowAcct")) || DataBase.GlobalVariable.IsVisualEditor; bool showAdvanced = "Y".Equals(vo.ctx.GetContext("#ShowAdvanced")) || DataBase.GlobalVariable.IsVisualEditor; // VLogger.get().warning("ShowTrl=" + showTrl + ", showAcct=" + showAcct); try { vo.AD_Tab_ID = Utility.Util.GetValueOfInt(dr["AD_Tab_ID"]); vo.Referenced_Tab_ID = Utility.Util.GetValueOfInt(dr["Referenced_Tab_ID"]); vo.ctx.SetContext(vo.windowNo, vo.tabNo, "AD_Tab_ID", vo.AD_Tab_ID.ToString()); vo.Name = Utility.Util.GetValueOfString(dr["Name"]); vo.ctx.SetContext(vo.windowNo, vo.tabNo, "Name", vo.Name); // Translation Tab ** if (Utility.Util.GetValueOfString(dr["IsTranslationTab"]).Equals("Y")) { // Document Translation vo.TableName = Utility.Util.GetValueOfString(dr["TableName"]); if (!Env.IsBaseTranslation(vo.TableName) && // C_UOM, ... !Env.IsMultiLingualDocument(vo.ctx)) { showTrl = false; } if (!showTrl) { VLogger.Get().Config("TrlTab Not displayed - AD_Tab_ID=" + vo.AD_Tab_ID + "=" + vo.Name + ", Table=" + vo.TableName + ", BaseTrl=" + Env.IsBaseTranslation(vo.TableName) + ", MultiLingual=" + Env.IsMultiLingualDocument(vo.ctx)); return(false); } } // Advanced Tab ** if (!showAdvanced && Utility.Util.GetValueOfString(dr["IsAdvancedTab"]).Equals("Y")) { VLogger.Get().Config("AdvancedTab Not displayed - AD_Tab_ID=" + vo.AD_Tab_ID + " " + vo.Name); return(false); } // Accounting Info Tab ** if (!showAcct && Utility.Util.GetValueOfString(dr["IsInfoTab"]).Equals("Y")) { VLogger.Get().Fine("AcctTab Not displayed - AD_Tab_ID=" + vo.AD_Tab_ID + " " + vo.Name); return(false); } // DisplayLogic vo.DisplayLogic = Utility.Util.GetValueOfString(dr["DisplayLogic"]); // Access Level vo.AccessLevel = Utility.Util.GetValueOfString(dr["AccessLevel"]); if (!role.CanView(vo.ctx, vo.AccessLevel) && !DataBase.GlobalVariable.IsVisualEditor) // No Access { VLogger.Get().Fine("No Role Access - AD_Tab_ID=" + vo.AD_Tab_ID + " " + vo.Name); return(false); } // Used by MField.getDefault vo.ctx.SetContext(vo.windowNo, vo.tabNo, "AccessLevel", vo.AccessLevel); // Table Access vo.AD_Table_ID = Utility.Util.GetValueOfInt(dr["AD_Table_ID"]); vo.ctx.SetContext(vo.windowNo, vo.tabNo, "AD_Table_ID", vo.AD_Table_ID.ToString()); if (!role.IsTableAccess(vo.AD_Table_ID, true) && !DataBase.GlobalVariable.IsVisualEditor) { VLogger.Get().Config("No Table Access - AD_Tab_ID=" + vo.AD_Tab_ID + " " + vo.Name); return(false); } if (role.IsTableReadOnly(vo.AD_Table_ID) && !DataBase.GlobalVariable.IsVisualEditor) { vo.IsReadOnly = true; } if (Utility.Util.GetValueOfString(dr["IsReadOnly"]).Equals("Y")) { vo.IsReadOnly = true; } vo.ReadOnlyLogic = Utility.Util.GetValueOfString(dr["ReadOnlyLogic"]); if (Utility.Util.GetValueOfString(dr["IsInsertRecord"]).Equals("N")) { vo.IsInsertRecord = false; } // vo.Description = Utility.Util.GetValueOfString(dr["Description"]); if (vo.Description == null) { vo.Description = ""; } vo.Help = Utility.Util.GetValueOfString(dr["Help"]); if (vo.Help == null) { vo.Help = ""; } if (Utility.Util.GetValueOfString(dr["IsSingleRow"]).Equals("Y")) { vo.IsSingleRow = true; } if (Utility.Util.GetValueOfString(dr["HasTree"]).Equals("Y")) { vo.HasTree = true; } if (Utility.Util.GetValueOfString(dr["ShowSummaryLevelNodes"]).Equals("Y")) { vo.ShowSummaryLevel = true; } vo.AD_Table_ID = Utility.Util.GetValueOfInt(dr["AD_Table_ID"]); vo.TableName = Utility.Util.GetValueOfString(dr["TableName"]); if (Utility.Util.GetValueOfString(dr["IsView"]).Equals("Y")) { vo.IsView = true; } vo.AD_Column_ID = Utility.Util.GetValueOfInt(dr["AD_Column_ID"]); // Primary Parent Column if (Utility.Util.GetValueOfString(dr["IsSecurityEnabled"]).Equals("Y")) { vo.IsSecurityEnabled = true; } if (Utility.Util.GetValueOfString(dr["IsDeleteable"]).Equals("Y")) { vo.IsDeleteable = true; } if (Utility.Util.GetValueOfString(dr["IsHighVolume"]).Equals("Y")) { vo.IsHighVolume = true; } vo.CommitWarning = Utility.Util.GetValueOfString(dr["CommitWarning"]); if (vo.CommitWarning == null) { vo.CommitWarning = ""; } vo.WhereClause = Utility.Util.GetValueOfString(dr["WhereClause"]); if (vo.WhereClause == null) { vo.WhereClause = ""; } vo.OrderByClause = Utility.Util.GetValueOfString(dr["OrderByClause"]); if (vo.OrderByClause == null) { vo.OrderByClause = ""; } vo.AD_Process_ID = Utility.Util.GetValueOfInt(dr["AD_Process_ID"]); //if (dr.wasNull()) // vo.AD_Process_ID = 0; vo.AD_Image_ID = Utility.Util.GetValueOfInt(dr["AD_Image_ID"]); //if (dr.wasNull()) // vo.AD_Image_ID = 0; vo.Included_Tab_ID = Utility.Util.GetValueOfInt(dr["Included_Tab_ID"]); //if (dr.wasNull()) // vo.Included_Tab_ID = 0; // vo.TabLevel = Utility.Util.GetValueOfInt(dr["TabLevel"]); //if (dr.wasNull()) // vo.TabLevel = 0; // vo.IsSortTab = Utility.Util.GetValueOfString(dr["IsSortTab"]).Equals("Y"); if (vo.IsSortTab) { vo.AD_ColumnSortOrder_ID = Utility.Util.GetValueOfInt(dr["AD_ColumnSortOrder_ID"]); vo.AD_ColumnSortYesNo_ID = Utility.Util.GetValueOfInt(dr["AD_ColumnSortYesNo_ID"]); } // // Replication Type - set R/O if Reference try { //int index = dr.fin .findColumn("ReplicationType"); vo.ReplicationType = Utility.Util.GetValueOfString(dr["ReplicationType"]); if ("R".Equals(vo.ReplicationType)) { vo.IsReadOnly = true; } } catch { } } catch (System.Exception ex) { VLogger.Get().Log(Level.SEVERE, "", ex); return(false); } return(true); }