static public MSeriesFilter[] GetFilters(int D_SeriesFilter_ID) { int key = D_SeriesFilter_ID; List <MSeriesFilter> list = new List <MSeriesFilter>(); String sql = "SELECT * FROM D_SeriesFilter pfi " + "WHERE pfi.IsActive='Y' And pfi.D_Series_ID=@D_Series_ID"; try { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@D_Series_ID", key); DataSet ds = SqlExec.ExecuteQuery.ExecuteDataset(sql, param); foreach (DataRow dr in ds.Tables[0].Rows) { MSeriesFilter pfi = new MSeriesFilter(Env.GetCtx(), 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 } MSeriesFilter[] retValue = new MSeriesFilter[list.Count]; retValue = list.ToArray(); return(retValue); }
/// <summary> /// Get Charts /// </summary> /// <param name="D_Chart_ID">Chart ID</param> /// <returns>Charts</returns> static public MSeriesFilter Get(int D_SeriesFilter_ID) { int key = D_SeriesFilter_ID; MSeriesFilter msf = null; if (s_chart.ContainsKey(key)) { msf = s_chart[key]; } if (msf == null) { msf = new MSeriesFilter(Env.GetCtx(), key, null); if (s_chart.ContainsKey(key)) { s_chart[key] = msf; } else { s_chart.Add(key, msf); } } else { s_log.Config("Chart ID = " + key); } return(msf); }