/// <summary> /// /// </summary> public List<Filtro> ObtenerFiltros() { filtros = new List<Filtro>(); Consultas consulta = new Consultas(); DataTable filtro1 = consulta.SelectKPI_Share_SKU_Flt_ProductSubfamilyCode().Tables[0]; Filtro filterProductSubfamilyCode = Herramientas.Instance.obtenerFiltro(filtro1, "Product Subfamily Code", "ProductSubfamilyCode", "ProductSubfamilyCode", true); DataTable filtro2 = consulta.SelectKPI_Share_SKU_Flt_ProductSubfamilyDescription().Tables[0]; Filtro filterProductSubfamilyDescription = Herramientas.Instance.obtenerFiltro(filtro2, "Marca", "ProductSubfamilyDescription", "ProductSubfamilyDescription", true);//Subfamilia DataTable filtro3 = consulta.SelectKPI_Share_SKU_Flt_SegmentPrice().Tables[0]; Filtro filterSegmentPrice = Herramientas.Instance.obtenerFiltro(filtro3, "Segmento de Precio", "SegmentPrice", "SegmentPrice", false); filtros.Add(filterProductSubfamilyCode); filtros.Add(filterProductSubfamilyDescription); filtros.Add(filterSegmentPrice); return filtros; }