Esempi in C# (CSharp) per NMT_ESC_DAL Consultas.SelectKPI_Share_SKU_Flt_ProductSubfamilyDescription

Esempio n. 1

File: ShareSKU.cs Progetto: slytsal/nmtmdz

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