Пример #1
0
        public void AddTagesmitteltemperaturen(object chartData, List<Zeitraum> zeitraums )
        {
            var periods = zeitraums.OrderByDescending(p => p.Start).GetFormatted(true);

            this.CreateHeading("3. Tagesmitteltemperaturen³ des gewählten Abrechnungszeitraumes und des Vorjahres");
            ICanvas legendCanvas = default(ICanvas);
            IText text = default(IText);

            // Add grid 
            IGrid grid = this.currentBand.AddGrid();
            GridCellPattern cellPattern = new GridCellPattern();
            cellPattern.Alignment = new ContentAlignment(Alignment.Left, Alignment.Middle);

            // Grid pattern for borders around block
            GridPattern gridPattern = new GridPattern();
            gridPattern.Borders = new Borders(new Pen(new Color(0, 0, 0)));
            gridPattern.Paddings.All = 10;
            gridPattern.Apply(grid);

            IGridColumn column = grid.AddColumn();
            IGridRow gridRow = grid.AddRow();
            IGridCell gridCell = gridRow.AddCell();


            //Add Legend
            gridCell.Alignment = new ContentAlignment(Alignment.Center, Alignment.Middle);
            IGrid legendGrid = gridCell.AddGrid();
            IGridCell legendCell;

            legendGrid.Width = new FixedWidth(450);
            column = legendGrid.AddColumn();
            column.Width = new FixedWidth(7);
            column = legendGrid.AddColumn();
            column = legendGrid.AddColumn();
            column.Width = new FixedWidth(7);
            column = legendGrid.AddColumn();
            column = legendGrid.AddColumn();
            column.Width = new FixedWidth(7);
            column = legendGrid.AddColumn();
            gridRow = legendGrid.AddRow();

            //1 Period
            legendCell = gridRow.AddCell();
            cellPattern.Apply(legendCell);
            legendCanvas = legendCell.AddCanvas();
            legendCanvas.Width = new FixedWidth(5);
            legendCanvas.Paddings.All = 0;
            legendCanvas.Margins.All = 0;
            legendCanvas.Height = new FixedHeight(5);
            legendCanvas.Pen = new Pen(new Color(65, 69, 120), 2);
            legendCanvas.DrawLine(0, 2.5f, 5, 2.5f);

            legendCell = gridRow.AddCell();
            cellPattern.Apply(legendCell);
            text = legendCell.AddText();
            text.Style.Font = this.pdfFonts[PdfFont.DefaultNormalReg];
            text.AddContent(periods[0]);

            //2 Period 
            legendCell = gridRow.AddCell();
            cellPattern.Apply(legendCell);
            legendCanvas = legendCell.AddCanvas();
            legendCanvas.Width = new FixedWidth(5);
            legendCanvas.Height = new FixedHeight(5);
            legendCanvas.Pen = new Pen(new Color(204, 76, 24), 2);
            legendCanvas.DrawLine(0, 2.5f, 5, 2.5f);

            legendCell = gridRow.AddCell();
            cellPattern.Apply(legendCell);
            text = legendCell.AddText();
            text.Style.Font = this.pdfFonts[PdfFont.DefaultNormalReg];
            text.AddContent(periods[1]);

            //Ausgangbasis 
            legendCell = gridRow.AddCell();
            cellPattern.Apply(legendCell);
            legendCanvas = legendCell.AddCanvas();
            legendCanvas.Width = new FixedWidth(5);
            legendCanvas.Height = new FixedHeight(5);
            legendCanvas.Pen = new Pen(Colors.Green, 2);
            legendCanvas.DrawLine(0, 2.5f, 5, 2.5f);

            legendCell = gridRow.AddCell();
            cellPattern.Apply(legendCell);
            text = legendCell.AddText();
            text.Style.Font = this.pdfFonts[PdfFont.DefaultNormalReg];
            text.AddContent("Heizgrenztemperatur");
            //text.AddContent("Heizgrenztemperatur⁴");

            //Add Chart
            //chartData.Columns("Heizgrenztemperatur").ColumnName = "Heizgrenztemperatur³"
            gridRow = grid.AddRow();
            gridCell = gridRow.AddCell();

            ICanvas canvas = gridCell.AddCanvas();
            //Me.currentBand.AddCanvas()
            canvas.Width = new FixedWidth(530);
            canvas.Height = new FixedHeight(300);
            using (System.Drawing.Graphics g = canvas.CreateGraphics())
            {
                using (UltraChart myChart = new UltraChart())
                {
                    TemperaturChart.GetChart(myChart, chartData, 530, 300);
                    myChart.Legend.Visible = false;
                    myChart.RenderPdfFriendlyGraphics(g);
                }
            }
            //this.currentBand.AddStretcher();
        }
Пример #2
0
        public void AddJahresbetrachtung( MeteoGtzYear meteoGtzYear)
        {

            this.CreateHeading("1. Jahresbetrachtung der heizwirksamen Temperatur des aktuellen Jahres im Vergleich zu den Vorjahren und Langzeitmittel²");

            // Add grid 
            IGrid grid = this.currentBand.AddGrid();

            IText text;
            Style textStyle = new Style(this.pdfFonts[PdfFont.DefaultNormalReg], Brushes.Black);
            Style headerStyle = new Style(this.pdfFonts[PdfFont.DefaultNormalBold], Brushes.Black);


            // Grid pattern for borders around block
            var gridPattern = new GridPattern
            {
                Borders = new Borders(new Pen(Colors.Black)),
                Paddings =
                {
                    All = 10
                }
            };
            gridPattern.Apply(grid);

            var column = grid.AddColumn();
            var gridRow = grid.AddRow();
            var gridCell = gridRow.AddCell();


            GridCellPattern cellPattern = new GridCellPattern
            {
                Alignment = new ContentAlignment(Alignment.Center, Alignment.Middle),
                Paddings =
                {
                    Left = 10,
                    Bottom = 0
                }
            };

            //cellPattern.Apply(gridCell);
            //text = gridCell.AddText();
            //text.Style.Font = pdfFonts[PdfFont.DefaultNormalReg];
            //text.AddContent("Alle Angaben sind immer konkret bezogen auf die getroffene Auswahl hinsichtlich Abrech-nungszeitraum (Stichtag) " + "und die ausgewählte Region. Basis sind dabei immer die Tages-mitteltemperaturen. Betrachtet werden immer " + "ganzjährige Abrechnungszeiträume.");
            //text.AddLineBreak();
            //text.AddLineBreak();

            //Add Chart
            gridRow = grid.AddRow();
            gridCell = gridRow.AddCell();

            ICanvas canvas = gridCell.AddCanvas();
            canvas.Width = new FixedWidth(440);
            canvas.Height = new FixedHeight(190);
            using (System.Drawing.Graphics g = canvas.CreateGraphics())
            {
                UltraChart myChart = JahresbetrachtungChart.GetChart(meteoGtzYear, 440, 190, true);
                //myChart.ColumnChart.ChartText(0).Visible = True
                myChart.Legend.Visible = false;
                myChart.RenderPdfFriendlyGraphics(g);
            }
                
            gridRow = grid.AddRow();
            gridCell = gridRow.AddCell();
            cellPattern.Apply(gridCell);

            text = gridCell.AddText();
            text.Style.Font = this.pdfFonts[PdfFont.DefaultNormalReg];
            //text.Paddings.Top = 5;

            var relativeData = meteoGtzYear.ToRelativeData();

            double vorjahrBedarf = relativeData.Period2;
            double lgtzBedarf = relativeData.Lgtz;
            var vorjahrBedarfText = string.Format(
                        @"In der gewählten Region war es im gleichen Zeitraum des Vorjahres {0}% {1} als im betrachteten Zeiraum des aktuellen Jahres.
Entsprechend ist im aktuellen Jahr im Vergleich zum Vorjahreszeitraum mit einem Heiz{2}bedarf zu rechnen.",
                Math.Abs(Math.Round(vorjahrBedarf, 2)), (vorjahrBedarf > 0 ? "wärmer" : "kälter"), (vorjahrBedarf > 0 ? "mehr" : "minder"));
            var lgtzBedarfText = string.Format("In der gewählten Region ist das Langzeitmittel {0}% {1} als das aktuelle Jahr.", Math.Abs(Math.Round(lgtzBedarf, 2)), (lgtzBedarf > 0 ? "wärmer" : "kälter"));

            //text.AddLineBreak();
            text.AddContent(vorjahrBedarfText);
            text.AddLineBreak();
            text.AddLineBreak();
            text.AddContent(lgtzBedarfText);
            
        }
Пример #3
0
        public void AddMonatsbetrachtung(DataTable chartData, List<Zeitraum> zeitraums)
        {
            if ((chartData == null))
            {
                return;
            }

            //Dummy Column für Legende Langzeitmittel
            var columnDummy = new DataColumn
            {
                DataType = typeof(double)
            };
            chartData.Columns.Add(columnDummy);

            var periods = zeitraums.OrderByDescending(p => p.Start).GetFormatted(true);

            this.CreateHeading("2. Monatsbetrachtung der Temperatur des aktuellen Jahres im Vergleich zum Vorjahr und Langzeitmittel²");

            //Dim flow As Infragistics.Documents.Report.Flow.IFlow = currentBand.AddFlow()
            //flow.Borders.All = New Border(New Pen(Colors.Black))
            IText text ;
            ICanvas legendCanvas;

            // Add grid 
            IGrid grid = this.currentBand.AddGrid();

            // Grid pattern for borders around block
            GridPattern gridPattern = new GridPattern
            {
                Borders = new Borders(new Pen(Colors.Black)),
                Paddings =
                {
                    All = 10
                }
            };
            gridPattern.Apply(grid);

            IGridColumn column = grid.AddColumn();
            IGridRow gridRow = grid.AddRow();
            IGridCell gridCell = gridRow.AddCell();

            GridCellPattern cellPattern = new GridCellPattern
            {
                Alignment = new ContentAlignment(Alignment.Left, Alignment.Middle)
            };
            //cellPattern.Borders = New Borders(New Pen(New Color(0, 0, 0)))
            //cellPattern.Paddings.All = 0

            //Add Legend
            gridCell.Alignment = new ContentAlignment(Alignment.Center, Alignment.Middle);
            IGrid legendGrid = gridCell.AddGrid();
            IGridCell legendCell;

            legendGrid.Width = new FixedWidth(450);
            column = legendGrid.AddColumn();
            column.Width = new FixedWidth(7);
            column = legendGrid.AddColumn();
            column = legendGrid.AddColumn();
            column.Width = new FixedWidth(7);
            column = legendGrid.AddColumn();
            column = legendGrid.AddColumn();
            column.Width = new FixedWidth(7);
            column = legendGrid.AddColumn();
            gridRow = legendGrid.AddRow();

            //Vorjahr
            legendCell = gridRow.AddCell();
            cellPattern.Apply(legendCell);
            legendCanvas = legendCell.AddCanvas();
            legendCanvas.Width = new FixedWidth(5);
            legendCanvas.Paddings.All = 0;
            legendCanvas.Margins.All = 0;
            legendCanvas.Height = new FixedHeight(5);
            legendCanvas.Brush = new SolidColorBrush(new Color(0, 76, 148));
            legendCanvas.DrawRectangle(0, 0, 5, 5, PaintMode.FillStroke);

            legendCell = gridRow.AddCell();
            cellPattern.Apply(legendCell);
            text = legendCell.AddText();
            text.Style.Font = this.pdfFonts[PdfFont.DefaultNormalReg];
            text.AddContent(periods[0]);

            //Langzeitmittel 
            legendCell = gridRow.AddCell();
            cellPattern.Apply(legendCell);
            legendCanvas = legendCell.AddCanvas();
            legendCanvas.Width = new FixedWidth(5);
            legendCanvas.Height = new FixedHeight(5);
            legendCanvas.Brush = new SolidColorBrush(new Color(236, 98, 42));
            legendCanvas.DrawRectangle(0, 0, 5, 5, PaintMode.FillStroke);

            legendCell = gridRow.AddCell();
            cellPattern.Apply(legendCell);
            text = legendCell.AddText();
            text.Style.Font = this.pdfFonts[PdfFont.DefaultNormalReg];
            text.AddContent(periods[1]);

            //Ausgangbasis 
            legendCell = gridRow.AddCell();
            cellPattern.Apply(legendCell);
            legendCanvas = legendCell.AddCanvas();
            legendCanvas.Width = new FixedWidth(5);
            legendCanvas.Height = new FixedHeight(5);
            legendCanvas.Pen = new Pen(Colors.Green, 2);
            legendCanvas.DrawLine(0, 2.5f, 5, 2.5f);

            legendCell = gridRow.AddCell();
            cellPattern.Apply(legendCell);
            text = legendCell.AddText();
            text.Style.Font = this.pdfFonts[PdfFont.DefaultNormalReg];
            text.AddContent("Langzeitmittel (Nulllinie)");


            //Add Chart
            gridRow = grid.AddRow();
            gridCell = gridRow.AddCell();

            ICanvas canvas = gridCell.AddCanvas();
            //Me.currentBand.AddCanvas()
            canvas.Width = new FixedWidth(500);
            canvas.Height = new FixedHeight(250);
            using (System.Drawing.Graphics g = canvas.CreateGraphics())
            {
                UltraChart myChart = MonatsRelativeVerteilungJahrChart.GetChart(chartData, 500, 250, periods.ToArray());
                //myChart.ColumnChart.ChartText(0).Visible = True
                myChart.Legend.Visible = false;
               myChart.RenderPdfFriendlyGraphics(g);
            }

            //gridCell.AddStretcher()

            //Add Info
            GridCellPattern cellPattern2 = new GridCellPattern
            {
                Paddings =
                {
                    Left = 10,
                    Bottom = 0
                }
            };

            gridRow = grid.AddRow();
            gridCell = gridRow.AddCell();
            cellPattern2.Apply(gridCell);


            DataRow row = chartData.Rows[chartData.Rows.Count - 1];
            try
            {
                string monat = Utils.GetMonthName(row["Monat"].ConvertTo<int>(), "MMMM");
                double VorjahrBedarf = row.Field<double>("Vorjahr");
                double aktuellJqahr = row.Field<double>("Aktuelljahr");

                text = gridCell.AddText();
                text.Style.Font = this.pdfFonts[PdfFont.DefaultNormalReg];
                //text.Paddings.Top = 10
                text.AddLineBreak();
                text.AddContent("Das Langzeitmittel stellt die Nulllinie dar.");
                text.AddLineBreak();
                text.AddLineBreak();
                text.AddContent("Negativer Prozentwert (Balken zeigt nach unten): in dem jeweiligen Monat des Vorjahres / aktuellen Jahres war es kälter als im gleichen Monat des Langzeitmittels.");
                text.AddLineBreak();
                text.AddLineBreak();
                text.AddContent("Positiver Prozentwert (Balken zeigt nach oben): in dem jeweiligen Monat des Vorjahres / aktuellen Jahres war es wärmer als im gleichen Monat des Langzeitmittels.");
                text.AddLineBreak();
                text.AddLineBreak();
                text.AddContent(string.Format("Für die gewählte Region war es - bezogen auf das Langzeitmittel im Monat {0}", monat));

                IQuickList list = gridCell.AddQuickList();
                list.Margins.Bottom = 0;
                list.Font = this.pdfFonts[PdfFont.DefaultNormalReg];
                list.Interval = 1;
                list.AddItem(string.Format("des Vorjahres ca. {0}% {1}", Math.Abs(Math.Round(VorjahrBedarf, 2)), (VorjahrBedarf > 0 ? "wärmer" : "kälter")));
                list.AddItem(string.Format("des aktuellen Jahres ca. {0}% {1}",   Math.Abs(Math.Round(aktuellJqahr, 2)), (aktuellJqahr > 0 ? "wärmer" : "kälter")));
                //gridCell.AddStretcher();

            }
            catch (Exception ex)
            {
            }
            this.currentBand.AddStretcher();
        }
Пример #4
0
        public void AddHeader(DateTime startDate, string requestText, string logoPath)
        {
            // Add a repeating band header to the main band
            IBandHeader bandHeader = this.currentBand.Header;

            // Header settings
            bandHeader.Repeat = true;
            bandHeader.Height = new FixedHeight(80);
            bandHeader.Alignment = new ContentAlignment(Alignment.Left, Alignment.Middle);
            var logo = new Image(logoPath);
            logo.Preferences.Compressor = ImageCompressors.Flate;

            //' Add a grid to header
            IGrid grid = bandHeader.AddGrid();

            // Arrays for columns and cells
            IGridColumn[] headerColumn = new IGridColumn[5];
            IGridCell[] headerGridCell = new IGridCell[4];

            // Add two columns to the grid
            headerColumn[0] = grid.AddColumn();
            //headerColumn[0].Width = new FixedWidth(270);
            headerColumn[1] = grid.AddColumn();
            headerColumn[1].Width = new FixedWidth(20);
            headerColumn[2] = grid.AddColumn();
            headerColumn[2].Width = new FixedWidth(270);

            // Add one row to the grid
            IGridRow gridRow = grid.AddRow();

            
            headerGridCell[1] = gridRow.AddCell();
            IGrid dataGrid = headerGridCell[1].AddGrid();
            var dataGridheaderColumn = dataGrid.AddColumn();
            dataGridheaderColumn.Width = new FixedWidth(150);
            dataGrid.AddColumn();

            GridCellPattern dataCellPattern = new GridCellPattern();
            dataCellPattern.Alignment = new ContentAlignment(Alignment.Center, Alignment.Middle);
            dataCellPattern.Paddings.Left = 5;
            dataCellPattern.Paddings.Bottom = 10;

            var dataGridRow = dataGrid.AddRow();

            IText text ;
            headerGridCell[0] = dataGridRow.AddCell();
            dataCellPattern.Apply(headerGridCell[0]);
            text = headerGridCell[0].AddText();
            text.Style.Font = this.pdfFonts[PdfFont.DefaultNormalReg];
            text.AddContent("Ende Abrechnungszeitraum (Stichtag)");

            headerGridCell[1] = dataGridRow.AddCell();
            dataCellPattern.Apply(headerGridCell[1]);
            text = headerGridCell[1].AddText();
            text.Style.Font = this.pdfFonts[PdfFont.DefaultNormalReg];
            text.AddContent(startDate.ToShortDateString());

            dataGridRow = dataGrid.AddRow();

            headerGridCell[0] = dataGridRow.AddCell();
            dataCellPattern.Apply(headerGridCell[0]);
            text = headerGridCell[0].AddText();
            text.Style.Font = this.pdfFonts[PdfFont.DefaultNormalReg];
            text.AddContent("Region");

            headerGridCell[1] = dataGridRow.AddCell();
            dataCellPattern.Apply(headerGridCell[1]);
            text = headerGridCell[1].AddText();
            text.Style.Font = this.pdfFonts[PdfFont.DefaultNormalReg];
            text.AddContent(requestText);

            // Add grid cell for logo
            gridRow.AddCell();

            headerGridCell[0] = gridRow.AddCell();
            //cellPattern.Apply(headerGridCell(0))
            headerGridCell[0].Alignment = ContentAlignment.Right;
            headerGridCell[0].AddImage(logo);
            //gridRow.AddCell();


            //'cellPattern.Apply(headerGridCell(1))
            //'headerGridCell(1).ColSpan = 1
            //Dim headingText As IText = headerGridCell(1).AddText()
            //headingText.Style.Font = pdfFonts(PdfFont.DefaultSmallReg)
            //headingText.AddContent(requestText)

        }