public void MakeReport3() { List <Product> Products = GetProductData().ToList(); DataProcessor dp = new DataProcessor(); dp.BeforeGroup = (x, d) => { if (1 == d) { var groupColor = x as IGrouping <string, Product>; TemplateRow tmp = new TemplateRow(); tmp.RowStyle = "styleFullBlueCover"; tmp.RowContent.AddRange(new List <TemplateCell>() { "Color:", groupColor.Key, groupColor.AsEnumerable().Count() }); dp.Result.Add(tmp); } }; dp.Process(Products.GroupBy(a => a.Color)); ReportMakerHelper reportMakerHelper = new ReportMakerHelper(); var styleSheet = reportMakerHelper.GetSheet("Template2.xlsx", "Styles"); ReportMaker reportMaker = new ReportMaker(new StylesManager(styleSheet)); Dictionary <string, List <TemplateRow> > dict = new Dictionary <string, List <TemplateRow> >() { { "Products", dp.Result } }; var image = reportMaker.FillDataInTemplate("Template2.xlsx", dict); File.WriteAllBytes("Test3.xlsx", image.ToArray()); }
public void MakeReport2() { List <Product> Products = GetProductData().ToList(); DataProcessor dp = new DataProcessor(); dp.BeforeGroup = (x, d) => { if (1 == d) { var groupColor = x as IGrouping <string, Product>; TemplateRow tmp = new TemplateRow(); TemplateCell colorTemplateCell = new TemplateCell() { content = "Color:", cellStyle = "B2" }; tmp.RowContent.AddRange(new List <TemplateCell>() { colorTemplateCell, groupColor.Key, groupColor.AsEnumerable().Count() }); dp.Result.Add(tmp); } }; dp.Process(Products.GroupBy(a => a.Color)); ReportMaker reportMaker = new ReportMaker(); Dictionary <string, List <TemplateRow> > dict = new Dictionary <string, List <TemplateRow> >() { { "Products", dp.Result } }; var image = reportMaker.FillDataInTemplate("Template1.xlsx", dict); File.WriteAllBytes("Test2.xlsx", image.ToArray()); }
private void ListaDeElementos_SelectionChanged(object sender, SelectionChangedEventArgs e) { this.mapa.Markers.Clear(); if (this.listaDeElementos.SelectedItem != null) { var vendedor = this.listaDeElementos.SelectedItem as Vendedor; try { SeleccionarMarcador(vendedor); var reporte = ReportMaker.CrearReporte(vendedor); this.posicionesUC.FechaDelReporte = this.dtpFecha.SelectedDate.Value.ToString("dddd, dd MMMM yyyy"); this.posicionesUC.Posiciones = new ObservableCollection <ItemReporte>(reporte); this.posicionesUC.NombreVendedor = vendedor.Nombre; this.posicionesUC.CodigoVendedor = vendedor.Codigo; this.VisibilidadColumnaClientes = GridLength.Auto; } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { this.VisibilidadColumnaClientes = new GridLength(0); } }
private void cargaPosicionesFleteroWorker_Complete(object sender, RunWorkerCompletedEventArgs e) { if (e.Result != null) { var fletero = (Fletero)e.Result; var cargaClientesWorker = new CargarClientesFleteroWorker(this.mapa, fletero, diaSeleccionado.Value); cargaClientesWorker.RunWorkerCompleted += CargaClientesWorker_RunWorkerCompleted; cargaClientesWorker.RunWorkerAsync(); ControladorMapa.ImprimirCamino(this.mapa, fletero.Posiciones); var reporte = ReportMaker.CrearReporte(fletero); this.posicionesUC.FechaDelReporte = this.dtpFecha.SelectedDate.Value.ToString("dddd, dd MMMM yyyy"); this.posicionesUC.Posiciones = new ObservableCollection <ItemReporte>(reporte); this.posicionesUC.NombreVendedor = fletero.Nombre; this.posicionesUC.CodigoVendedor = fletero.Codigo; this.VisibilidadColumnaClientes = GridLength.Auto; } }
public void Setup() { WeSayWordsProject.InitializeForTests(); _addin = new ReportMaker(); _addin.LaunchAfterTransform = false; }