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