private void apply_Click(object sender, EventArgs e) { CellSizeMode cellSizeMode = CellSizeMode.EqualToMaxNode; // get all parameters int nMaxColumnCount = int.Parse(txtMaxColumnCount.Text); int nMaxRowsCount = int.Parse(txtMaxRowsCount.Text); Orientation orientation = (comboExpandMode.SelectedIndex == 0) ? Orientation.Horizontal : Orientation.Vertical; if (comboCellSize.SelectedIndex == 0) { cellSizeMode = CellSizeMode.EqualToMaxNode; } else if (comboCellSize.SelectedIndex == 1) { cellSizeMode = CellSizeMode.Minimal; } else if (comboCellSize.SelectedIndex == 2) { cellSizeMode = CellSizeMode.MinimalTable; } TableLayoutManager m_layoutManager = diagram1.LayoutManager as TableLayoutManager; m_layoutManager.MaxColummnCount = nMaxColumnCount; m_layoutManager.MaxRowsCount = nMaxRowsCount; m_layoutManager.CellSizeMode = cellSizeMode; m_layoutManager.HorizontalSpacing = float.Parse(txtHSpacing.Text); m_layoutManager.VerticalSpacing = float.Parse(txtVSpacing.Text); m_layoutManager.LeftMargin = float.Parse(txtLMarigin.Text); m_layoutManager.TopMargin = float.Parse(txtTMarigin.Text); m_layoutManager.MaxSize = new SizeF(float.Parse(txtMaxWidth.Text), float.Parse(txtMaxHeight.Text)); m_layoutManager.Orientation = orientation; m_layoutManager.AutoLayout = chkAutoLayout.Checked; Layouting(); }
public Form1() { InitializeComponent(); diagram1.BeginUpdate(); DiagramAppearance(); PopulateNodes(); this.diagram1.View.SelectionList.Clear(); TableLayoutManager tlLayout = new TableLayoutManager(this.diagram1.Model, 5, 5); tlLayout.LeftMargin = 50; tlLayout.TopMargin = 120; tlLayout.VerticalSpacing = 0; tlLayout.HorizontalSpacing = 0; tlLayout.CellSizeMode = CellSizeMode.EqualToMaxNode; tlLayout.Orientation = Orientation.Horizontal; tlLayout.MaxSize = new SizeF(1300, 600); this.diagram1.LayoutManager = tlLayout; this.diagram1.LayoutManager.UpdateLayout(null); txtHSpacing.Text = tlLayout.HorizontalSpacing.ToString(); txtVSpacing.Text = tlLayout.VerticalSpacing.ToString(); txtLMarigin.Text = tlLayout.LeftMargin.ToString(); txtTMarigin.Text = tlLayout.TopMargin.ToString(); chkAutoLayout.Checked = tlLayout.AutoLayout; comboCellSize.SelectedIndex = 0; comboExpandMode.SelectedIndex = 0; diagram1.EndUpdate(); }
private void InitDiagram() { TableLayoutManager tlLayout = new TableLayoutManager(this.diagram1.Model, 7, 7); tlLayout.VerticalSpacing = 20; tlLayout.HorizontalSpacing = 20; tlLayout.CellSizeMode = CellSizeMode.EqualToMaxNode; tlLayout.Orientation = Orientation.Horizontal; tlLayout.MaxSize = new SizeF(500, 600); this.diagram1.LayoutManager = tlLayout; //this.diagram1.LayoutManager.UpdateLayout(null);.AttachModel(model1); }
private void CreateTable(out TableManager tableManager, out TableLayoutManager tableLayoutManager) { var table = new Table(); tableManager = new TableManager() { Table = new Table() }; tableLayoutManager = new TableLayoutManager() { Table = new Table() }; }
private double CreateInfoTable(double verticalMillimeters) { if (InfoDataTable.Rows.Count == 0) { verticalMillimeters += InsertItalicText(verticalMillimeters, $" No Breaker Information available."); return(verticalMillimeters); } FontProp headerProp = new FontProp(FontDefinition, 0); headerProp.rSizePoint = 10.0D; using (TableLayoutManager tlm = new TableLayoutManager(headerProp)) { FontProp textProp = new FontProp(FontDefinition, 0); textProp.rSizePoint = 8.0D; tlm.tlmCellDef_Header.rAlignV = RepObj.rAlignCenter; // set vertical alignment of all header cells tlm.tlmCellDef_Default.penProp_LineBottom = new PenProp(this, 0.05, Color.LightGray); // set bottom line for all cells tlm.tlmHeightMode = TlmHeightMode.AdjustLast; tlm.eNewContainer += (oSender, ea) => { verticalMillimeters += tlm.rCurY_MM; verticalMillimeters = NextTablePage(verticalMillimeters, ea); }; new TlmColumnMM(tlm, "Breaker Info", (PageWidthMillimeters - 2 * PageMarginMillimeters) * .5); new TlmColumnMM(tlm, "Value", (PageWidthMillimeters - 2 * PageMarginMillimeters) * .5); DataRow dataRow = InfoDataTable.Select().First(); foreach (DataColumn column in InfoDataTable.Columns) { tlm.NewRow(); tlm.Add(0, new RepString(textProp, column.ColumnName)); tlm.Add(1, new RepString(textProp, dataRow[column.ColumnName].ToString())); } tlm.Commit(); verticalMillimeters += tlm.rCurY_MM + 10; } return(verticalMillimeters); }
public void StampaAllClienti() { _sTitolo = "Stampa complessiva di tutti i clienti"; FontProp fp = new FontPropMM(fd, 1.9); FontProp fp_Header = new FontPropMM(fd, 1.9); fp_Header.bBold = true; fp_Header.color = HeaderForeColor; // create table using (TableLayoutManager tlm = new TableLayoutManager(fp_Header)) { tlm.rContainerHeightMM = rPosBottom - rPosTop; // set height of table tlm.headerCellDef.rAlignV = RepObj.rAlignCenter; // set vertical alignment of all header cells tlm.headerCellDef.bp_Back.color = HeaderBackColor; tlm.cellDef.pp_LineBottom = new PenProp(rpt, 0.05, Color.LightGray); tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer); // define columns TableLayoutManager.Column col; col = new TableLayoutManager.ColumnMM(tlm, "ID", 8); col = new TableLayoutManager.ColumnMM(tlm, "Ragione sociale", 40); col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine; col = new TableLayoutManager.ColumnMM(tlm, "Indirizzo", 36); col = new TableLayoutManager.ColumnMM(tlm, "Località", 30); col = new TableLayoutManager.ColumnMM(tlm, "Cap", 12); col = new TableLayoutManager.ColumnMM(tlm, "Prov", 8); col = new TableLayoutManager.ColumnMM(tlm, "Telefono", 25); col = new TableLayoutManager.ColumnMM(tlm, "Fax", 25); // Ritorna il dataset string strWhere = "SELECT * FROM Clienti;"; SqlCommand cmd = new SqlCommand(strWhere, sqlCn); SqlDataAdapter adap = new SqlDataAdapter(cmd); DataTable DT = new DataTable(); adap.Fill(DT); // read rows for (int r = 0; r < DT.Rows.Count; r++) { tlm.NewRow(); tlm.Add(0, new RepString(fp, DT.Rows[r]["IDCliente"].ToString())); tlm.Add(1, new RepString(fp, DT.Rows[r]["RagioneSoc"].ToString())); tlm.Add(2, new RepString(fp, DT.Rows[r]["Indirizzo"].ToString())); tlm.Add(3, new RepString(fp, DT.Rows[r]["Localita"].ToString())); tlm.Add(4, new RepString(fp, DT.Rows[r]["Cap"].ToString())); tlm.Add(5, new RepString(fp, DT.Rows[r]["Provincia"].ToString())); tlm.Add(6, new RepString(fp, DT.Rows[r]["Telefono"].ToString())); tlm.Add(7, new RepString(fp, DT.Rows[r]["Fax"].ToString())); } } // print page number and current date/time foreach (Root.Reports.Page page in rpt.enum_Page) { Double rY = rPosBottom + 1.5; page.AddLT_MM(rPosLeft, rY, new RepString(fp, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString())); page.AddRT_MM(rPosRight, rY, new RepString(fp, page.iPageNo.ToString() + " / " + rpt.iPageCount.ToString())); } }
public Report StampaScadenzeClientePerPianificazione(int IDCliente) { _sTitolo = ""; rPosLeft = 10; rPosRight = 190; rPosTop = 150; rPosBottom = 288; mMarginLeft = 20; mMarginRight = 190; mMarginTop = 150; mMarginBottom = 278; rPosTop = rPosTop + 30; FontProp fp = new FontPropMM(fd, 1.6); FontProp fp_Header = new FontPropMM(fd, 1.6); //imposto le informazioni per HEADER della tabella fp_Header.bBold = true; fp_Header.color = HeaderForeColor; // create table using (TableLayoutManager tlm = new TableLayoutManager(fp_Header)) { tlm.rContainerHeightMM = rPosBottom - rPosTop; // set height of table //Imposto le informazioni di allineamento e di sfondo del HEADER tlm.headerCellDef.rAlignV = RepObj.rAlignLeft; // set vertical alignment of all header cells tlm.headerCellDef.bp_Back.color = HeaderBackColor; tlm.cellDef.pp_LineBottom = new PenProp(rpt, 0.05, Color.LightGray); //Creo l'eento per ogni nuova pagina tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer); // Definizione delle colonne TableLayoutManager.Column col; col = new TableLayoutManager.ColumnMM(tlm, "Tipologia", 20); col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine; col = new TableLayoutManager.ColumnMM(tlm, "Tipo", 23); col = new TableLayoutManager.ColumnMM(tlm, "Marca", 23); col = new TableLayoutManager.ColumnMM(tlm, "Modello", 25); col = new TableLayoutManager.ColumnMM(tlm, "Matricola", 18); col = new TableLayoutManager.ColumnMM(tlm, "Omologazione", 35); col = new TableLayoutManager.ColumnMM(tlm, "Pef", 8); col = new TableLayoutManager.ColumnMM(tlm, "Data scadenza", 17); col = new TableLayoutManager.ColumnMM(tlm, "Nuova data", 21); //Ritorna il dataset string strWhere = @"SELECT tblScadenze.DataScadenza, Clienti.RagioneSoc, Clienti.bElimina, Marche.Marca, Tipo.Tipo, tblScadenze.Tipologia, Clienti.IDCliente, tblScadenze.NumeroDiSerie, Strumenti.Nome, tblScadenze.Omologazione1, tblScadenze.PEF, Clienti.Localita, Clienti.Provincia, Clienti.Telefono, Clienti.Cap, Clienti.Indirizzo, Clienti.Fax, Clienti.Cellulare, Clienti.Mail, Clienti.kmDistanza, Clienti.Note FROM Tipo INNER JOIN Marche INNER JOIN Strumenti INNER JOIN Clienti INNER JOIN tblScadenze ON Clienti.IDCliente = tblScadenze.IDCliente ON Strumenti.idStrumenti = tblScadenze.IdStrumento ON Marche.IDMarca = Strumenti.IDMarca ON Tipo.IDTipo = Strumenti.IDTipo GROUP BY tblScadenze.DataScadenza, Clienti.RagioneSoc, Clienti.bElimina, Marche.Marca, Tipo.Tipo, tblScadenze.Tipologia, Clienti.bElimina, Clienti.IDCliente, tblScadenze.NumeroDiSerie, Strumenti.Nome, tblScadenze.Omologazione1, tblScadenze.PEF, Clienti.Localita, Clienti.Provincia, Clienti.Telefono, Clienti.Cap, Clienti.Indirizzo, Clienti.Fax, Clienti.Cellulare, Clienti.Mail, Clienti.kmDistanza, Clienti.Note HAVING (Clienti.IDCliente = @IDCliente) ORDER BY tblScadenze.Tipologia"; SqlCommand cmd = new SqlCommand(strWhere, _sqlCn); SqlParameter parIDCliente = new SqlParameter("@IDCliente", SqlDbType.Int); parIDCliente.Value = IDCliente; cmd.Parameters.Add(parIDCliente); SqlDataAdapter adap = new SqlDataAdapter(cmd); DataTable DT = new DataTable(); adap.Fill(DT); //Imposto intestazione cReport objReport = new cReport(rpt, rptPage); string ripTipologia = ""; string s = ""; for (int r = 0; r < DT.Rows.Count; r++) { tlm.NewRow(); if (ripTipologia == DT.Rows[r]["Tipologia"].ToString()) s = ""; else s = ripTipologia = DT.Rows[r]["Tipologia"].ToString(); tlm.Add(0, new RepString(fp, s)); tlm.Add(1, new RepString(fp, DT.Rows[r]["Tipo"].ToString())); tlm.Add(2, new RepString(fp, DT.Rows[r]["Marca"].ToString())); tlm.Add(3, new RepString(fp, DT.Rows[r]["Nome"].ToString())); tlm.Add(4, new RepString(fp, DT.Rows[r]["NumeroDiSerie"].ToString())); tlm.Add(5, new RepString(fp, DT.Rows[r]["Omologazione1"].ToString())); tlm.Add(6, new RepString(fp, DT.Rows[r]["Pef"].ToString())); string sDate = ((DateTime)DT.Rows[r]["DataScadenza"]).ToShortDateString(); tlm.Add(7, new RepString(fp, sDate)); } } // print page number and current date/time foreach (Root.Reports.Page page in rpt.enum_Page) { Double rY = rPosBottom + 1.5; page.AddLT_MM(rPosLeft, rY, new RepString(fp, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString())); page.AddRT_MM(rPosRight, rY, new RepString(fp, page.iPageNo.ToString() + " / " + rpt.iPageCount.ToString())); } return rpt; }
private void dialog_BeginLayout(TableLayoutManager layout) { this.diagram1.LayoutManager = layout; Layouting(); }
//------------------------------------------------------------------------------------------30.10.2004 /// <summary>Creates this report.</summary> /// <remarks> /// This method overrides the method <see cref="Root.Reports.Report.Create"/> of the base class <see cref="Root.Reports.Report"/>. /// </remarks> protected override void Create() { fontDef_Helvetica = new FontDef(this, FontDef.StandardFont.TimesRoman); FontProp fontProp_Text = new FontPropMM(fontDef_Helvetica, 1.9); // standard font FontProp fontProp_Header = new FontPropMM(fontDef_Helvetica, 1.9); // font of the table header fontProp_Header.bBold = true; // create table TableLayoutManager tlm; using (tlm = new TableLayoutManager(fontProp_Header)) { tlm.rContainerHeightMM = rPosBottom - rPosTop; // set height of table tlm.tlmCellDef_Header.rAlignV = RepObj.rAlignCenter; // set vertical alignment of all header cells tlm.tlmCellDef_Default.penProp_LineBottom = new PenProp(this, 0.05, Color.LightGray); // set bottom line for all cells tlm.tlmHeightMode = TlmHeightMode.AdjustLast; tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer); // define columns TlmColumn col; col = new TlmColumnMM(tlm, "Natureza Lançamento", 80); col.tlmCellDef_Default.tlmTextMode = TlmTextMode.MultiLine; col = new TlmColumnMM(tlm, "Tipo", 40); col = new TlmColumnMM(tlm, "Data", 30); col = new TlmColumnMM(tlm, "Valor", 30); List<Financas> listaFinancas = (List<Financas>)RelatorioDTO.DadosRelatorio; Decimal valorTotal = 0; foreach (Financas financas in listaFinancas) { tlm.NewRow(); tlm.Add(0, new RepString(fontProp_Text, financas.NaturezaLancamento.NomeNatureza)); tlm.Add(1, new RepString(fontProp_Text, financas.TipoLancamento)); tlm.Add(2, new RepString(fontProp_Text, financas.DataLancamento.Value.ToString("dd/MM/yyyy"))); tlm.Add(3, new RepString(fontProp_Text, String.Format("{0:C2}", financas.Valor.Value))); valorTotal += financas.Valor.Value; } if (listaFinancas.Count > 0) { tlm.NewRow(); tlm.Add(0, new RepString(fontProp_Text, "")); tlm.Add(1, new RepString(fontProp_Text, "")); tlm.Add(2, new RepString(fontProp_Text, "Total:")); tlm.Add(3, new RepString(fontProp_Text, String.Format("{0:C2}", valorTotal))); } } //page_Cur.AddCT_MM(rPosLeft + tlm.rWidthMM / 2, rPosTop + tlm.rCurY_MM + 2, new RepString(fontProp_Text, "- end of table -")); // print page number and current date/time Double rY = rPosBottom + 1.5; foreach (Page page in enum_Page) { page.AddLT_MM(rPosLeft, rY, new RepString(fontProp_Text, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString())); page.AddRT_MM(rPosRight, rY, new RepString(fontProp_Text, page.iPageNo + " / " + iPageCount)); } }
private Double rPosBottom = 278; // millimeters //------------------------------------------------------------------------------------------30.10.2004 /// <summary>Creates this report.</summary> /// <remarks> /// This method overrides the method <see cref="Root.Reports.Report.Create"/> of the base class <see cref="Root.Reports.Report"/>. /// </remarks> protected override void Create() { fontDef_Helvetica = new FontDef(this, FontDef.StandardFont.TimesRoman); FontProp fontProp_Text = new FontPropMM(fontDef_Helvetica, 1.9); // standard font FontProp fontProp_Header = new FontPropMM(fontDef_Helvetica, 1.9); // font of the table header fontProp_Header.bBold = true; Stream stream_Phone = GetType().Assembly.GetManifestResourceStream("SGS.Componentes.Phone.jpg"); Random random = new Random(6); // create table TableLayoutManager tlm; using (tlm = new TableLayoutManager(fontProp_Header)) { tlm.rContainerHeightMM = rPosBottom - rPosTop; // set height of table tlm.tlmCellDef_Header.rAlignV = RepObj.rAlignCenter; // set vertical alignment of all header cells tlm.tlmCellDef_Default.penProp_LineBottom = new PenProp(this, 0.05, Color.LightGray); // set bottom line for all cells tlm.tlmHeightMode = TlmHeightMode.AdjustLast; tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer); // define columns TlmColumn col; col = new TlmColumnMM(tlm, "ID", 13); col = new TlmColumnMM(tlm, "Company Name", 40); col.tlmCellDef_Default.tlmTextMode = TlmTextMode.MultiLine; col = new TlmColumnMM(tlm, "Address", 30); col = new TlmColumnMM(tlm, "City", 22); col = new TlmColumnMM(tlm, "Postal Code", 16); col = new TlmColumnMM(tlm, "Country", 18); //col = new TlmColumnMM(tlm, "Pais", 24); TlmColumn col_Phone = new TlmColumnMM(tlm, "Phone", rPosRight - rPosLeft - tlm.rWidthMM); col_Phone.fontProp_Header = new FontPropMM(fontDef_Helvetica, 1.9, Color.Brown); col_Phone.tlmCellDef_Header.rAlignH = RepObj.rAlignRight; col_Phone.tlmCellDef_Default.rAlignH = RepObj.rAlignRight; BrushProp brushProp_Phone = new BrushProp(this, Color.FromArgb(255, 255, 200)); col_Phone.tlmCellDef_Default.brushProp_Back = brushProp_Phone; BrushProp brushProp_USA = new BrushProp(this, Color.FromArgb(255, 180, 180)); // open data set DataSet dataSet = new DataSet(); using (Stream stream_Customers = GetType().Assembly.GetManifestResourceStream("SGS.Componentes.Customers.xml")) { dataSet.ReadXml(stream_Customers); } DataTable dataTable_Customers = dataSet.Tables[0]; foreach (DataRow dr in dataTable_Customers.Rows) { String sCountry = (String)dr["Country"]; tlm.tlmCellDef_Default.brushProp_Back = (sCountry == "USA" ? brushProp_USA : null); col_Phone.tlmCellDef_Default.brushProp_Back = (sCountry == "USA" ? new BrushProp(this, Color.FromArgb(255, 227, 50)) : brushProp_Phone); tlm.NewRow(); tlm.Add(0, new RepString(fontProp_Text, (String)dr["CustomerID"])); tlm.Add(1, new RepString(fontProp_Text, (String)dr["CompanyName"])); tlm.Add(2, new RepString(fontProp_Text, (String)dr["Address"])); tlm.Add(3, new RepString(fontProp_Text, (String)dr["City"])); tlm.Add(4, new RepString(fontProp_Text, (String)dr["PostalCode"])); tlm.Add(5, new RepString(fontProp_Text, sCountry)); tlm.Add(6, new RepString(fontProp_Text, (String)dr["Phone"])); if (random.NextDouble() < 0.2) { // mark randomly selected row with a phone icon tlm.tlmRow_Cur.aTlmCell[col_Phone].AddMM(1, 0.25, new RepImageMM(stream_Phone, 2.1, 2.3)); } } } page_Cur.AddCT_MM(rPosLeft + tlm.rWidthMM / 2, rPosTop + tlm.rCurY_MM + 2, new RepString(fontProp_Text, "- end of table -")); // print page number and current date/time Double rY = rPosBottom + 1.5; foreach (Page page in enum_Page) { page.AddLT_MM(rPosLeft, rY, new RepString(fontProp_Text, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString())); page.AddRT_MM(rPosRight, rY, new RepString(fontProp_Text, page.iPageNo + " / " + iPageCount)); } }
//------------------------------------------------------------------------------------------30.10.2004 /// <summary>Creates this report.</summary> /// <remarks> /// This method overrides the method <see cref="Root.Reports.Report.Create"/> of the base class <see cref="Root.Reports.Report"/>. /// </remarks> protected override void Create() { fontDef_Helvetica = new FontDef(this, FontDef.StandardFont.TimesRoman); FontProp fontProp_Text = new FontPropMM(fontDef_Helvetica, 1.9); // standard font FontProp fontProp_Header = new FontPropMM(fontDef_Helvetica, 1.9); // font of the table header fontProp_Header.bBold = true; // create table TableLayoutManager tlm; using (tlm = new TableLayoutManager(fontProp_Header)) { tlm.rContainerHeightMM = rPosBottom - rPosTop; // set height of table tlm.tlmCellDef_Header.rAlignV = RepObj.rAlignCenter; // set vertical alignment of all header cells tlm.tlmCellDef_Default.penProp_LineBottom = new PenProp(this, 0.05, Color.LightGray); // set bottom line for all cells tlm.tlmHeightMode = TlmHeightMode.AdjustLast; tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer); // define columns TlmColumn col; col = new TlmColumnMM(tlm, "Nome Plano", 35); col.tlmCellDef_Default.tlmTextMode = TlmTextMode.MultiLine; col = new TlmColumnMM(tlm, "Data Início", 25); col = new TlmColumnMM(tlm, "Data Fim", 25); col = new TlmColumnMM(tlm, "Valor Orçamento", 30); col = new TlmColumnMM(tlm, "Valor Gasto", 30); col = new TlmColumnMM(tlm, "Saldo Orçamento", 30); List<Orcamento> listaOrcamento = (List<Orcamento>)RelatorioDTO.DadosRelatorio; foreach (Orcamento orcamento in listaOrcamento) { tlm.NewRow(); tlm.Add(0, new RepString(fontProp_Text, orcamento.NomePlano)); tlm.Add(1, new RepString(fontProp_Text, orcamento.InicioVigencia.Value.ToString("dd/MM/yyyy") )); tlm.Add(2, new RepString(fontProp_Text, orcamento.FimVigencia.Value.ToString("dd/MM/yyyy"))); tlm.Add(3, new RepString(fontProp_Text, String.Format("{0:C2}", orcamento.ValorOrcamento.Value))); tlm.Add(4, new RepString(fontProp_Text, String.Format("{0:C2}", orcamento.ValorFinanceiroReal))); tlm.Add(5, new RepString(fontProp_Text, String.Format("{0:C2}", orcamento.SaldoDisponivelOrcamento))); } } //page_Cur.AddCT_MM(rPosLeft + tlm.rWidthMM / 2, rPosTop + tlm.rCurY_MM + 2, new RepString(fontProp_Text, "- end of table -")); // print page number and current date/time Double rY = rPosBottom + 1.5; foreach (Page page in enum_Page) { page.AddLT_MM(rPosLeft, rY, new RepString(fontProp_Text, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString())); page.AddRT_MM(rPosRight, rY, new RepString(fontProp_Text, page.iPageNo + " / " + iPageCount)); } }
public void StampaSca15gg(int iIDGruppo) { _sTitolo = "Scadenze 31gg e già scadute"; FontProp fp = new FontPropMM(fd, 1.9); FontProp fp_Header = new FontPropMM(fd, 1.9); //imposto le informazioni per HEADER della tabella fp_Header.bBold = true; fp_Header.color = HeaderForeColor; // create table using (TableLayoutManager tlm = new TableLayoutManager(fp_Header)) { tlm.rContainerHeightMM = rPosBottom - rPosTop; // set height of table //Imposto le informazioni di allineamento e di sfondo del HEADER tlm.headerCellDef.rAlignV = RepObj.rAlignCenter; // set vertical alignment of all header cells tlm.headerCellDef.bp_Back.color = HeaderBackColor; tlm.cellDef.pp_LineBottom = new PenProp(rpt, 0.05, Color.LightGray); //Creo l'eento per ogni nuova pagina tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer); // Definizione dell colonne TableLayoutManager.Column col; col = new TableLayoutManager.ColumnMM(tlm, "Ragione sociale", 55); col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine; col = new TableLayoutManager.ColumnMM(tlm, "Tipologia", 40); col = new TableLayoutManager.ColumnMM(tlm, "Scadenza", 17); col = new TableLayoutManager.ColumnMM(tlm, "Marca", 25); col = new TableLayoutManager.ColumnMM(tlm, "Tipo", 30); col = new TableLayoutManager.ColumnMM(tlm, "Matricola", 30); //Ritorna il dataset string strWhere = @"SELECT tblScadenze.DataScadenza, Clienti.RagioneSoc, Clienti.bElimina, Marche.Marca, Tipo.Tipo, tblScadenze.Tipologia, tblScadenze.NumeroDiSerie, tblScadenze.IDGruppoScadenza FROM Tipo INNER JOIN Marche INNER JOIN Strumenti INNER JOIN Clienti INNER JOIN tblScadenze ON Clienti.IDCliente = tblScadenze.IDCliente ON Strumenti.idStrumenti = tblScadenze.IdStrumento ON Marche.IDMarca = Strumenti.IDMarca ON Tipo.IDTipo = Strumenti.IDTipo WHERE (tblScadenze.bScadenzaAnnullata = @bScaAnnullata) GROUP BY tblScadenze.DataScadenza, Clienti.RagioneSoc, Clienti.bElimina, Marche.Marca, Tipo.Tipo, tblScadenze.Tipologia, Clienti.bElimina, tblScadenze.NumeroDiSerie, tblScadenze.IDGruppoScadenza HAVING (tblScadenze.DataScadenza < @DataLimite) AND (Clienti.bElimina = @bElimina) AND (tblScadenze.IDGruppoScadenza = @IDGruppo) ORDER BY tblScadenze.DataScadenza"; SqlCommand cmd = new SqlCommand(strWhere, _sqlCn); SqlParameter parDate = new SqlParameter("@DataLimite", SqlDbType.DateTime); parDate.Value = DateTime.Now.AddDays(31); ; cmd.Parameters.Add(parDate); SqlParameter parElimati = new SqlParameter("@bElimina", SqlDbType.Bit); parElimati.Value = 0; cmd.Parameters.Add(parElimati); SqlParameter parScaAnnullata = new SqlParameter("@bScaAnnullata", SqlDbType.Bit); parScaAnnullata.Value = 0; cmd.Parameters.Add(parScaAnnullata); SqlParameter parGruppo = new SqlParameter("@IDGruppo", SqlDbType.Int); parGruppo.Value = iIDGruppo; cmd.Parameters.Add(parGruppo); SqlDataAdapter adap = new SqlDataAdapter(cmd); DataTable DT = new DataTable(); adap.Fill(DT); // read rows string ripRag = ""; string ripTipologia = ""; string s = ""; for (int r = 0; r < DT.Rows.Count; r++) { tlm.NewRow(); if (ripRag == DT.Rows[r]["RagioneSoc"].ToString()) s = ""; else { s = ripRag = DT.Rows[r]["RagioneSoc"].ToString(); ripTipologia = ""; } tlm.Add(0, new RepString(fp, s)); if (ripTipologia == DT.Rows[r]["Tipologia"].ToString()) s = ""; else s = ripTipologia = DT.Rows[r]["Tipologia"].ToString(); tlm.Add(1, new RepString(fp, s)); tlm.Add(2, new RepString(fp, ((DateTime)DT.Rows[r]["DataScadenza"]).ToShortDateString())); tlm.Add(3, new RepString(fp, DT.Rows[r]["Marca"].ToString())); tlm.Add(4, new RepString(fp, DT.Rows[r]["Tipo"].ToString())); tlm.Add(5, new RepString(fp, DT.Rows[r]["NumeroDiSerie"].ToString())); } } // print page number and current date/time foreach (Root.Reports.Page page in rpt.enum_Page) { Double rY = rPosBottom + 1.5; page.AddLT_MM(rPosLeft, rY, new RepString(fp, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString())); page.AddRT_MM(rPosRight, rY, new RepString(fp, page.iPageNo.ToString() + " / " + rpt.iPageCount.ToString())); } }
//------------------------------------------------------------------------------------------30.10.2004 /// <summary>Creates a new page.</summary> /// <param name="oSender">Sender</param> /// <param name="ea">Event argument</param> /// <remarks> /// The first page has a caption. The following pages have no caption and therefore the table can be made higher. /// </remarks> public void Tlm_NewContainer(Object oSender, TableLayoutManager.NewContainerEventArgs ea) { // only "public" for NDoc, should be "private" new Page(this); // first page with caption if (page_Cur.iPageNo == 1) { FontProp fontProp_Title = new FontPropMM(fontDef_Helvetica, 4); fontProp_Title.bBold = true; page_Cur.AddCT_MM(rPosLeft + (rPosRight - rPosLeft) / 2, rPosTop, new RepString(fontProp_Title, "SGS - Relatório Assistido")); ea.container.rHeightMM -= fontProp_Title.rLineFeedMM; // reduce height of table container for the first page } // the new container must be added to the current page page_Cur.AddMM(rPosLeft, rPosBottom - ea.container.rHeightMM, ea.container); }
public void StampaStrForClientiInGrid(string sIDcli) { _sTitolo = "Stampa strumenti per cliente"; FontProp fp = new FontPropMM(fd, 1.9); FontProp fp_Header = new FontPropMM(fd, 1.9); fp_Header.bBold = true; fp_Header.color = HeaderForeColor; //Carico la matrice delle tipologie di strumenti disponibili string[] sTipologia = null;//gestData.tipologiaStringGet(); foreach (string sActualTipologia in sTipologia) { // create table using (TableLayoutManager tlm = new TableLayoutManager(fp_Header)) { tlm.rContainerHeightMM = rPosBottom - rPosTop; // set height of table tlm.headerCellDef.rAlignV = RepObj.rAlignCenter; // set vertical alignment of all header cells tlm.headerCellDef.bp_Back.color = HeaderBackColor; tlm.cellDef.pp_LineBottom = new PenProp(rpt, 0.05, Color.LightGray); tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer); // define columns TableLayoutManager.Column col; col = new TableLayoutManager.ColumnMM(tlm, "Tipo", 20); col = new TableLayoutManager.ColumnMM(tlm, "Marca", 25); col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine; col = new TableLayoutManager.ColumnMM(tlm, "Modello", 30); col = new TableLayoutManager.ColumnMM(tlm, "Matricola", 20); col = new TableLayoutManager.ColumnMM(tlm, "Omologazione 1", 30); col = new TableLayoutManager.ColumnMM(tlm, "Omologazione 2", 30); col = new TableLayoutManager.ColumnMM(tlm, "Num. serie rulli", 20); col = new TableLayoutManager.ColumnMM(tlm, "Num. serie pesa", 20); col = new TableLayoutManager.ColumnMM(tlm, "P.E.F.", 10); col = new TableLayoutManager.ColumnMM(tlm, "Data scadenza", 20); // Ritorna il dataset string strWhere = "SELECT tblScadenze.Tipologia, tblScadenze.DataScadenza, tblScadenze.IDSca," + " Clienti.RagioneSoc, tblScadenze.IDCliente, qryStrumenti.Marca, qryStrumenti.Tipo," + " tblScadenze.DataAttivazione,tblScadenze.Omologazione1,tblScadenze.Omologazione2," + " qryStrumenti.Nome , tblScadenze.NumeroDiSerie, tblScadenze.PEF, tblScadenze.NumSerieRulli," + " tblScadenze.NumSeriePesa , tblScadenze.TipoCalibratore, tblScadenze.NumSerCalibratore" + " FROM (Clienti INNER JOIN tblScadenze ON Clienti.IDCliente = tblScadenze.IDCliente) INNER JOIN qryStrumenti ON tblScadenze.IdStrumento = qryStrumenti.idStrumenti " + " WHERE (((tblScadenze.Tipologia)='" + sActualTipologia + "') AND ((tblScadenze.IDCliente)=" + sIDcli + ")) " + " ORDER BY tblScadenze.Tipologia DESC , tblScadenze.DataScadenza DESC , Clienti.RagioneSoc DESC"; DataSet objDS = null;// gestData.CreateDataSet(strWhere); DataTable DT = objDS.Tables[0]; // read rows for (int r = 0; r < DT.Rows.Count; r++) { tlm.NewRow(); tlm.Add(0, new RepString(fp, DT.Rows[r]["Tipo"].ToString())); tlm.Add(1, new RepString(fp, DT.Rows[r]["Marca"].ToString())); tlm.Add(2, new RepString(fp, DT.Rows[r]["Nome"].ToString())); tlm.Add(3, new RepString(fp, DT.Rows[r]["NumeroDiSerie"].ToString())); tlm.Add(4, new RepString(fp, DT.Rows[r]["Omologazione1"].ToString())); tlm.Add(5, new RepString(fp, DT.Rows[r]["Omologazione2"].ToString())); tlm.Add(6, new RepString(fp, DT.Rows[r]["NumSerieRulli"].ToString())); tlm.Add(7, new RepString(fp, DT.Rows[r]["NumSeriePesa"].ToString())); tlm.Add(8, new RepString(fp, DT.Rows[r]["PEF"].ToString())); tlm.Add(9, new RepString(fp, DT.Rows[r]["DataScadenza"].ToString())); } } } // print page number and current date/time foreach (Root.Reports.Page page in rpt.enum_Page) { Double rY = rPosBottom + 1.5; page.AddLT_MM(rPosLeft, rY, new RepString(fp, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString())); page.AddRT_MM(rPosRight, rY, new RepString(fp, page.iPageNo.ToString() + " / " + rpt.iPageCount.ToString())); } }
/// <summary>Creates a new page</summary> /// <param name="oSender">Sender</param> /// <param name="ea">Event argument</param> private void Tlm_NewContainer(Object oSender, TableLayoutManager.NewContainerEventArgs ea) { if (bfirstPas) new Root.Reports.Page(rpt); bfirstPas = true; // first page with heading if (rpt.page_Cur.iPageNo == 1) { FontProp fp_Title = new FontPropMM(fd, 6); fp_Title.bBold = true; rpt.page_Cur.AddCT_MM(rPosLeft + (rPosRight - rPosLeft) / 2, rPosTop, new RepString(fp_Title, _sTitolo)); ea.container.rHeightMM -= fp_Title.rLineFeedMM; // reduce height of table container for the first page } // the new container must be added to the current page rpt.page_Cur.AddMM(rPosLeft, rPosBottom - ea.container.rHeightMM, ea.container); }
public void StampaScaDA_A(DateTime dataDA, DateTime dataA) { _sTitolo = "Scadenze Dal:" + dataDA.ToShortDateString() + " A:" + dataA.ToShortDateString(); FontProp fp = new FontPropMM(fd, 1.9); FontProp fp_Header = new FontPropMM(fd, 1.9); //imposto le informazioni per HEADER della tabella fp_Header.bBold = true; fp_Header.color = HeaderForeColor; // create table using (TableLayoutManager tlm = new TableLayoutManager(fp_Header)) { tlm.rContainerHeightMM = rPosBottom - rPosTop; // set height of table //Imposto le informazioni di allineamento e di sfondo del HEADER tlm.headerCellDef.rAlignV = RepObj.rAlignCenter; // set vertical alignment of all header cells tlm.headerCellDef.bp_Back.color = HeaderBackColor; tlm.cellDef.pp_LineBottom = new PenProp(rpt, 0.05, Color.LightGray); //Creo l'eento per ogni nuova pagina tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer); // Definizione dell colonne TableLayoutManager.Column col; col = new TableLayoutManager.ColumnMM(tlm, "Ragione sociale", 70); col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine; col = new TableLayoutManager.ColumnMM(tlm, "Localita", 25); col = new TableLayoutManager.ColumnMM(tlm, "Prov", 10); col = new TableLayoutManager.ColumnMM(tlm, "Telefono", 20); col = new TableLayoutManager.ColumnMM(tlm, "Tipologia", 30); col = new TableLayoutManager.ColumnMM(tlm, "Scadenza", 20); string sDA = dataDA.Month + "/" + dataDA.Day + "/" + dataDA.Year; string sA = dataA.Month + "/" + dataA.Day + "/" + dataA.Year; //Ritorna il dataset string strWhere = @"SELECT tblScadenze.DataScadenza, Clienti.RagioneSoc, Clienti.Localita, Clienti.Provincia, Clienti.Telefono, Clienti.bElimina, tblScadenze.Tipologia FROM Tipo INNER JOIN ((Marche INNER JOIN Strumenti ON Marche.IDMarca = Strumenti.IDMarca) INNER JOIN (Clienti INNER JOIN tblScadenze ON Clienti.IDCliente = tblScadenze.IDCliente) ON Strumenti.idStrumenti = tblScadenze.IdStrumento) ON Tipo.IDTipo = Strumenti.IDTipo GROUP BY tblScadenze.DataScadenza, Clienti.RagioneSoc, Clienti.Localita, Clienti.Provincia, Clienti.Telefono, Clienti.bElimina, tblScadenze.Tipologia, Clienti.bElimina HAVING (tblScadenze.DataScadenza Between #" + sDA + "# And #" + sA + "#) AND (Clienti.bElimina=False)" + " ORDER BY tblScadenze.DataScadenza"; SqlCommand cmd = new SqlCommand(strWhere, sqlCn); SqlDataAdapter adap = new SqlDataAdapter(cmd); DataTable DT = new DataTable(); adap.Fill(DT); // read rows string ripRag = ""; string ripTipologia = ""; string s = ""; for (int r = 0; r < DT.Rows.Count; r++) { tlm.NewRow(); if (ripRag == DT.Rows[r]["RagioneSoc"].ToString()) s = ""; else { s = ripRag = DT.Rows[r]["RagioneSoc"].ToString(); ripTipologia = ""; } tlm.Add(0, new RepString(fp, s)); if (ripTipologia == DT.Rows[r]["Tipologia"].ToString()) s = ""; else s = ripTipologia = DT.Rows[r]["Tipologia"].ToString(); tlm.Add(1, new RepString(fp, DT.Rows[r]["Localita"].ToString())); tlm.Add(2, new RepString(fp, DT.Rows[r]["Provincia"].ToString())); tlm.Add(3, new RepString(fp, DT.Rows[r]["Telefono"].ToString())); tlm.Add(4, new RepString(fp, s)); DateTime dtData = (DateTime)DT.Rows[r]["DataScadenza"]; tlm.Add(5, new RepString(fp, dtData.ToShortDateString())); } } // print page number and current date/time foreach (Root.Reports.Page page in rpt.enum_Page) { Double rY = rPosBottom + 1.5; page.AddLT_MM(rPosLeft, rY, new RepString(fp, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString())); page.AddRT_MM(rPosRight, rY, new RepString(fp, page.iPageNo.ToString() + " / " + rpt.iPageCount.ToString())); } }
private double CreateTable(double verticalMillimeters) { if (DataTable.Rows.Count == 0) { verticalMillimeters += InsertItalicText(verticalMillimeters, $" No Breaker Operations during {StartTime.ToString("MM/dd/yyyy")} - {EndTime.ToString("MM/dd/yyyy")}"); return(verticalMillimeters); } FontProp headerProp = new FontProp(FontDefinition, 0); headerProp.rSizePoint = 7.0D; using (TableLayoutManager tlm = new TableLayoutManager(headerProp)) { tlm.tlmCellDef_Header.rAlignV = RepObj.rAlignCenter; // set vertical alignment of all header cells tlm.tlmCellDef_Default.penProp_LineBottom = new PenProp(this, 0.05, Color.LightGray); // set bottom line for all cells tlm.tlmHeightMode = TlmHeightMode.AdjustLast; tlm.eNewContainer += (oSender, ea) => { verticalMillimeters += tlm.rCurY_MM; verticalMillimeters = NextTablePage(verticalMillimeters, ea); }; List <dynamic> columns = new List <dynamic>() { new { Name = "Last Op", Column = "LastOperationDate", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .05 }, new { Name = "Breaker", Column = "BreakerNumber", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .04 }, new { Name = "# of Ops", Column = "Total", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .04 }, new { Name = "Asset", Column = "AssetNum", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .05 }, new { Name = "Line", Column = "LineName", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .10 }, new { Name = "Phase", Column = "LastPhase", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .04 }, new { Name = "Timing (wf)", Column = "LastWaveformTiming", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .05 }, new { Name = "Timing (sb)", Column = "LastStatusTiming", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .05 }, new { Name = "MFR Speed", Column = "MfrSpeed", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .04 }, new { Name = "Operation Timing", Column = "OperationTiming", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .06 }, new { Name = "Method", Column = "LastMethod", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .05 }, new { Name = "# Late", Column = "TotalLateOperation", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .03 }, new { Name = "Last Late", Column = "LastLateOperation", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .05 }, new { Name = "MFR", Column = "Manufacturer", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .07 }, new { Name = "Serial #", Column = "SerialNum", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .08 }, new { Name = "MFR Year", Column = "MfrYear", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .04 }, new { Name = "Model #", Column = "ModelNum", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .07 }, new { Name = "ICR (A)", Column = "InterruptCurrentRating", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .05 }, new { Name = "CAR (A)", Column = "ContinuousAmpRating", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .05 } }; foreach (var column in columns) { new TlmColumnMM(tlm, column.Name, column.Width); } List <string> centeredCols = new List <string>() { "Total", "BreakerNumber", "AssetNum", "LastPhase" }; foreach (DataRow row in DataTable.Rows) { tlm.NewRow(); int index = 0; foreach (var column in columns) { if (column.Column == "LastOperationDate" || (column.Column == "LastLateOperation" && row[column.Column].ToString() != string.Empty)) { FontProp textProp = new FontProp(FontDefinition, 0); textProp.rSizePoint = 6.0D; string date = DateTime.Parse(row[column.Column].ToString()).ToString("MM/dd/yyyy"); string time = DateTime.Parse(row[column.Column].ToString()).ToString("HH:mm:ss"); tlm.Add(index, new RepString(textProp, date)); tlm.NewLine(index); tlm.Add(index++, new RepString(textProp, time)); } else { FontProp textProp = new FontProp(FontDefinition, 0); textProp.rSizePoint = 6.0D; string value = ""; value = row[column.Column].ToString(); RepString repObj = new RepString(textProp, value); if (centeredCols.Contains(column.Column)) { repObj.rAlignH = RepObj.rAlignCenter; } AddDataColumn(tlm, index, value, textProp, column.Width); index++; } } } tlm.Commit(); verticalMillimeters += tlm.rCurY_MM + 10; } return(verticalMillimeters); }
/// <summary>Creates this report.</summary> /// <remarks> /// This method overrides the method <see cref="Root.Reports.Report.Create"/> of the base class <see cref="Root.Reports.Report"/>. /// </remarks> protected override void Create() { fontDef_Helvetica = new FontDef(this, FontDef.StandardFont.Helvetica); FontProp fontProp_Text = new FontPropMM(fontDef_Helvetica, 1.9); // standard font FontProp fontProp_Header = new FontPropMM(fontDef_Helvetica, 1.9); // font of the table header fontProp_Header.bBold = true; // create table TableLayoutManager tlm; using (tlm = new TableLayoutManager(fontProp_Header)) { tlm.rContainerHeightMM = rPosBottom - rPosTop; // set height of table tlm.tlmCellDef_Header.rAlignV = RepObj.rAlignCenter; // set vertical alignment of all header cells tlm.tlmCellDef_Default.penProp_LineBottom = new PenProp(this, 0.05, Color.LightGray); // set bottom line for all cells tlm.tlmHeightMode = TlmHeightMode.AdjustLast; tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer); // define columns TlmColumn col; col = new TlmColumnMM(tlm, "Level", 30); col = new TlmColumnMM(tlm, "Name", 40); col.tlmCellDef_Default.tlmTextMode = TlmTextMode.MultiLine; TlmColumn col_Phone = new TlmColumnMM(tlm, "Email", rPosRight - rPosLeft - tlm.rWidthMM); col_Phone.fontProp_Header = new FontPropMM(fontDef_Helvetica, 1.9, Color.Brown); col_Phone.tlmCellDef_Header.rAlignH = RepObj.rAlignRight; col_Phone.tlmCellDef_Default.rAlignH = RepObj.rAlignRight; BrushProp brushProp_Phone = new BrushProp(this, Color.FromArgb(255, 255, 200)); col_Phone.tlmCellDef_Default.brushProp_Back = brushProp_Phone; // open data set foreach (var user in users) { tlm.NewRow(); switch (user.Level) { case 1: { tlm.Add(0, new RepString(fontProp_Text, Levels.Novice.ToString())); break; } case 2: { tlm.Add(0, new RepString(fontProp_Text, Levels.Intermediate.ToString())); break; } case 3: { tlm.Add(0, new RepString(fontProp_Text, Levels.Advanced.ToString())); break; } } tlm.Add(1, new RepString(fontProp_Text, user.Login)); tlm.Add(2, new RepString(fontProp_Text, user.Email)); } } Double rY = rPosBottom + 1.5; foreach (Page page in enum_Page) { page.AddLT_MM(rPosLeft, rY, new RepString(fontProp_Text, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + " generated by Knowledge Management System")); page.AddRT_MM(rPosRight, rY, new RepString(fontProp_Text, page.iPageNo + " / " + iPageCount)); } }
public Report StampaRigheRapportino(int IDRapportino) { _sTitolo = ""; rPosLeft = 3; rPosRight = 215; rPosTop = 142; rPosBottom = 230; mMarginLeft = 10; mMarginRight = 190; mMarginTop = 140; mMarginBottom = 200; rPosTop = rPosTop + 30; FontProp fp = new FontPropMM(fd, 2); FontProp fp_Header = new FontPropMM(fd, 2); //imposto le informazioni per HEADER della tabella fp_Header.bBold = true; fp_Header.color = HeaderForeColor; // create table using (TableLayoutManager tlm = new TableLayoutManager(fp_Header)) { tlm.rContainerHeightMM = rPosBottom - rPosTop; // set height of table //Imposto le informazioni di allineamento e di sfondo del HEADER tlm.headerCellDef.rAlignV = RepObj.rAlignLeft; // set vertical alignment of all header cells tlm.headerCellDef.bp_Back.color = HeaderBackColor; tlm.cellDef.pp_LineBottom = new PenProp(rpt, 0.05, Color.LightGray); //Creo l'eento per ogni nuova pagina tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer); // Definizione delle colonne TableLayoutManager.Column col; col = new TableLayoutManager.ColumnMM(tlm, "Q.ta", 15); col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine; col = new TableLayoutManager.ColumnMM(tlm, "Modello", 25); col = new TableLayoutManager.ColumnMM(tlm, "Descrizione", 103); col = new TableLayoutManager.ColumnMM(tlm, "Prezzo Unitario", 30); col = new TableLayoutManager.ColumnMM(tlm, "Importo", 30); //Ritorna il dataset string strWhere = @"SELECT IDRapportinoRighe, IDRapportino,IDArticolo, Descrizione, PrezzoUnitario, Quantita, Totale FROM dbo.RapportinoRighe WHERE (IDRapportino = @Rapportino)"; SqlCommand cmd = new SqlCommand(strWhere, _sqlCn); SqlParameter parIDRapportino = new SqlParameter("@Rapportino", SqlDbType.Int); parIDRapportino.Value = IDRapportino; cmd.Parameters.Add(parIDRapportino); SqlDataAdapter adap = new SqlDataAdapter(cmd); DataTable DT = new DataTable(); adap.Fill(DT); //Imposto intestazione cReport objReport = new cReport(rpt, rptPage); // read rows for (int r = 0; r < DT.Rows.Count; r++) { tlm.NewRow(); float f = 0; float.TryParse(DT.Rows[r]["Quantita"].ToString(), out f); tlm.Add(0, new RepString(fp, f.ToString("0.##"))); tlm.Add(1, new RepString(fp, DT.Rows[r]["IDArticolo"].ToString())); tlm.Add(2, new RepString(fp, DT.Rows[r]["Descrizione"].ToString())); float.TryParse(DT.Rows[r]["PrezzoUnitario"].ToString(), out f); tlm.Add(3, new RepString(fp, f.ToString("0.00"))); float.TryParse(DT.Rows[r]["Totale"].ToString(), out f); tlm.Add(4, new RepString(fp, f.ToString("0.00"))); } if (DT.Rows.Count == 0) { tlm.NewRow(); tlm.Add(0, new RepString(fp, "")); tlm.Add(1, new RepString(fp, "")); tlm.Add(2, new RepString(fp, "")); tlm.Add(3, new RepString(fp, "")); tlm.Add(4, new RepString(fp, "")); } } // print page number and current date/time foreach (Root.Reports.Page page in rpt.enum_Page) { Double rY = rPosBottom + 1.5; //page.AddLT_MM(rPosLeft, rY, new RepString(fp, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString())); page.AddRT_MM(rPosRight, rY, new RepString(fp, page.iPageNo.ToString() + " / " + rpt.iPageCount.ToString())); } return rpt; }
private double CreateTimingTable(double verticalMillimeters) { List <dynamic> columns = new List <dynamic>() { new { Name = "Time", Column = "Time", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .1 }, new { Name = "Line", Column = "LineName", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .2 }, new { Name = "Phase", Column = "Phase", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .1 }, new { Name = "Timing (br)", Column = "BreakerTiming", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .1 }, new { Name = "Timing (wf)", Column = "WaveformTiming", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .1 }, new { Name = "Timing (sp)", Column = "StatusTiming", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .1 }, new { Name = "Classification", Column = "OperationTiming", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .1 }, new { Name = "Prefault Current", Column = "PrefaultCurrent", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .1 }, new { Name = "Max Current", Column = "MaxCurrent", Width = (PageWidthMillimeters - 2 * PageMarginMillimeters) * .1 }, }; if (TimingDataTable.Rows.Count == 0) { verticalMillimeters += InsertItalicText(verticalMillimeters, $" No Breaker Operations during {StartTime.ToString("MM/dd/yyyy")} - {EndTime.ToString("MM/dd/yyyy")}"); return(verticalMillimeters); } FontProp headerProp = new FontProp(FontDefinition, 0); headerProp.rSizePoint = 10.0D; using (TableLayoutManager tlm = new TableLayoutManager(headerProp)) { FontProp textProp = new FontProp(FontDefinition, 0); textProp.rSizePoint = 8.0D; tlm.tlmCellDef_Header.rAlignV = RepObj.rAlignCenter; // set vertical alignment of all header cells tlm.tlmCellDef_Default.penProp_LineBottom = new PenProp(this, 0.05, Color.LightGray); // set bottom line for all cells tlm.tlmHeightMode = TlmHeightMode.AdjustLast; tlm.eNewContainer += (oSender, ea) => { verticalMillimeters += tlm.rCurY_MM; verticalMillimeters = NextTablePage(verticalMillimeters, ea); }; // define columns foreach (var column in columns) { new TlmColumnMM(tlm, column.Name, column.Width); } foreach (DataRow row in TimingDataTable.Rows) { tlm.NewRow(); int index = 0; foreach (var column in columns) { if (column.Column == "Time") { string date = DateTime.Parse(row[column.Column].ToString()).ToString("MM/dd/yyyy"); string time = DateTime.Parse(row[column.Column].ToString()).ToString("HH:mm:ss"); tlm.Add(index, new RepString(textProp, date)); tlm.NewLine(index); tlm.Add(index++, new RepString(textProp, time)); } else if (column.Column == "LineName") { AddDataColumn(tlm, index++, row[column.Column].ToString(), textProp, column.Width); } else { tlm.Add(index++, new RepString(textProp, row[column.Column].ToString())); } } } tlm.Commit(); verticalMillimeters += tlm.rCurY_MM + 10; } return(verticalMillimeters); }
private Double rPosBottom = 278; // millimeters //------------------------------------------------------------------------------------------30.10.2004 /// <summary>Creates this report.</summary> /// <remarks> /// This method overrides the method <see cref="Root.Reports.Report.Create"/> of the base class <see cref="Root.Reports.Report"/>. /// </remarks> protected override void Create() { fontDef_Helvetica = new FontDef(this, FontDef.StandardFont.Helvetica); FontProp fontProp_Text = new FontPropMM(fontDef_Helvetica, 1.9); // standard font FontProp fontProp_Header = new FontPropMM(fontDef_Helvetica, 1.9); // font of the table header fontProp_Header.bBold = true; Stream stream_Phone = GetType().Assembly.GetManifestResourceStream("ReportSamples.Phone.jpg"); Random random = new Random(6); // create table TableLayoutManager tlm; using (tlm = new TableLayoutManager(fontProp_Header)) { tlm.rContainerHeightMM = rPosBottom - rPosTop; // set height of table tlm.tlmCellDef_Header.rAlignV = RepObj.rAlignCenter; // set vertical alignment of all header cells tlm.tlmCellDef_Default.penProp_LineBottom = new PenProp(this, 0.05, Color.LightGray); // set bottom line for all cells tlm.tlmHeightMode = TlmHeightMode.AdjustLast; tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer); // define columns TlmColumn col; col = new TlmColumnMM(tlm, "ID", 13); col = new TlmColumnMM(tlm, "Company Name", 40); col.tlmCellDef_Default.tlmTextMode = TlmTextMode.MultiLine; col = new TlmColumnMM(tlm, "Address", 36); col = new TlmColumnMM(tlm, "City", 22); col = new TlmColumnMM(tlm, "Postal Code", 16); col = new TlmColumnMM(tlm, "Country", 18); TlmColumn col_Phone = new TlmColumnMM(tlm, "Phone", rPosRight - rPosLeft - tlm.rWidthMM); col_Phone.fontProp_Header = new FontPropMM(fontDef_Helvetica, 1.9, Color.Brown); col_Phone.tlmCellDef_Header.rAlignH = RepObj.rAlignRight; col_Phone.tlmCellDef_Default.rAlignH = RepObj.rAlignRight; BrushProp brushProp_Phone = new BrushProp(this, Color.FromArgb(255, 255, 200)); col_Phone.tlmCellDef_Default.brushProp_Back = brushProp_Phone; BrushProp brushProp_USA = new BrushProp(this, Color.FromArgb(255, 180, 180)); // open data set DataSet dataSet = new DataSet(); using (Stream stream_Customers = GetType().Assembly.GetManifestResourceStream("ReportSamples.Customers.xml")) { dataSet.ReadXml(stream_Customers); } DataTable dataTable_Customers = dataSet.Tables[0]; foreach (DataRow dr in dataTable_Customers.Rows) { String sCountry = (String)dr["Country"]; tlm.tlmCellDef_Default.brushProp_Back = (sCountry == "USA" ? brushProp_USA : null); col_Phone.tlmCellDef_Default.brushProp_Back = (sCountry == "USA" ? new BrushProp(this, Color.FromArgb(255, 227, 50)) : brushProp_Phone); tlm.NewRow(); tlm.Add(0, new RepString(fontProp_Text, (String)dr["CustomerID"])); tlm.Add(1, new RepString(fontProp_Text, (String)dr["CompanyName"])); tlm.Add(2, new RepString(fontProp_Text, (String)dr["Address"])); tlm.Add(3, new RepString(fontProp_Text, (String)dr["City"])); tlm.Add(4, new RepString(fontProp_Text, (String)dr["PostalCode"])); tlm.Add(5, new RepString(fontProp_Text, sCountry)); tlm.Add(6, new RepString(fontProp_Text, (String)dr["Phone"])); if (random.NextDouble() < 0.2) // mark randomly selected row with a phone icon { tlm.tlmRow_Cur.aTlmCell[col_Phone].AddMM(1, 0.25, new RepImageMM(stream_Phone, 2.1, 2.3)); } } } page_Cur.AddCT_MM(rPosLeft + tlm.rWidthMM / 2, rPosTop + tlm.rCurY_MM + 2, new RepString(fontProp_Text, "- end of table -")); // print page number and current date/time Double rY = rPosBottom + 1.5; foreach (Page page in enum_Page) { page.AddLT_MM(rPosLeft, rY, new RepString(fontProp_Text, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString())); page.AddRT_MM(rPosRight, rY, new RepString(fontProp_Text, page.iPageNo + " / " + iPageCount)); } }
//------------------------------------------------------------------------------------------30.10.2004 /// <summary>Creates this report.</summary> /// <remarks> /// This method overrides the method <see cref="Root.Reports.Report.Create"/> of the base class <see cref="Root.Reports.Report"/>. /// </remarks> protected override void Create() { fontDef_Helvetica = new FontDef(this, FontDef.StandardFont.TimesRoman); FontProp fontProp_Text = new FontPropMM(fontDef_Helvetica, 1.9); // standard font FontProp fontProp_Header = new FontPropMM(fontDef_Helvetica, 1.9); // font of the table header fontProp_Header.bBold = true; // create table TableLayoutManager tlm; using (tlm = new TableLayoutManager(fontProp_Header)) { tlm.rContainerHeightMM = rPosBottom - rPosTop; // set height of table tlm.tlmCellDef_Header.rAlignV = RepObj.rAlignCenter; // set vertical alignment of all header cells tlm.tlmCellDef_Default.penProp_LineBottom = new PenProp(this, 0.05, Color.LightGray); // set bottom line for all cells tlm.tlmHeightMode = TlmHeightMode.AdjustLast; tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer); // define columns TlmColumn col; col = new TlmColumnMM(tlm, "Assistido", 50); col.tlmCellDef_Default.tlmTextMode = TlmTextMode.MultiLine; col = new TlmColumnMM(tlm, "Dt. Nascimento", 24); col = new TlmColumnMM(tlm, "Dt. Entrada", 20); col = new TlmColumnMM(tlm, "Dt. Saída", 20); col = new TlmColumnMM(tlm, "Estado Saúde", 22); col = new TlmColumnMM(tlm, "Status", 26); col = new TlmColumnMM(tlm, "Ativo", 15); System.Collections.Generic.List<Assistido> listaAssistido = (System.Collections.Generic.List<Assistido>)RelatorioDTO.DadosRelatorio; foreach (Assistido assistido in listaAssistido) { tlm.NewRow(); tlm.Add(0, new RepString(fontProp_Text, assistido.Nome)); if (assistido.DataNascimento.HasValue) tlm.Add(1, new RepString(fontProp_Text, assistido.DataNascimento.Value.ToString("dd/MM/yyyy"))); else tlm.Add(1, new RepString(fontProp_Text, "")); tlm.Add(2, new RepString(fontProp_Text, assistido.DataEntrada.Value.ToString("dd/MM/yyyy"))); if (assistido.DataSaida.HasValue) tlm.Add(3, new RepString(fontProp_Text, assistido.DataSaida.Value.ToString("dd/MM/yyyy"))); else tlm.Add(3, new RepString(fontProp_Text, "")); tlm.Add(4, new RepString(fontProp_Text, assistido.EstadoSaude)); tlm.Add(5, new RepString(fontProp_Text, assistido.StatusAssistido)); tlm.Add(6, new RepString(fontProp_Text, assistido.AssistidoAtivo)); } } //page_Cur.AddCT_MM(rPosLeft + tlm.rWidthMM / 2, rPosTop + tlm.rCurY_MM + 2, new RepString(fontProp_Text, "- end of table -")); // print page number and current date/time Double rY = rPosBottom + 1.5; foreach (Page page in enum_Page) { page.AddLT_MM(rPosLeft, rY, new RepString(fontProp_Text, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString())); page.AddRT_MM(rPosRight, rY, new RepString(fontProp_Text, page.iPageNo + " / " + iPageCount)); } }
protected override void Create() { fd = new FontDef(this, "Arial"); FontProp fp = new FontPropMM(fd, 1.9); FontProp fp_Encabezado = new FontPropMM(fd, 1.9); fp_Encabezado.bBold = true; TableLayoutManager tlm = new TableLayoutManager(fp_Encabezado); tlm.rContainerHeightMM = rPosInferior - rPosSuperior; tlm.headerCellDef.rAlignV = RepObj.rAlignCenter; tlm.cellDef.pp_LineBottom = new PenProp(this, 0.05, Color.LightGray); tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer); TableLayoutManager.Column col; col = new TableLayoutManager.ColumnMM(tlm, "Nro.", 15); col = new TableLayoutManager.ColumnMM(tlm, "Fecha", 18); col.cellDef.rAlignH = RepObj.rAlignRight; col = new TableLayoutManager.ColumnMM(tlm, "Proveedor", 54); col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine; col = new TableLayoutManager.ColumnMM(tlm, "Partida", 22); col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine; col = new TableLayoutManager.ColumnMM(tlm, "Unidad Solicitante", 69); col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine; col = new TableLayoutManager.ColumnMM(tlm, "Observaciones", 69); col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine; col = new TableLayoutManager.ColumnMM(tlm, "Monto", 23); col.cellDef.rAlignH = RepObj.rAlignRight; BrushProp bp_Anulada = new BrushProp(this, Color.FromArgb(255, 255, 200)); rDatos = ComprasSuministrosBD.ObtenerOrdenesCompras(rSector, rDesde, rHasta); while (rDatos.Read()) { tlm.cellDef.bp_Back = ((rDatos["Indi_Anulacion"].ToString() == "1") ? bp_Anulada : null); tlm.NewRow(); tlm.Add(0, new RepString(fp, rDatos["Nro_Comp"].ToString())); tlm.Add(1, new RepString(fp, rDatos["Fecha_Orden"].ToString().Substring(0, 10))); tlm.Add(2, new RepString(fp, rDatos["Nombre"].ToString())); tlm.Add(3, new RepString(fp, rDatos["Codigo"].ToString())); tlm.Add(4, new RepString(fp, rDatos["Direccion"].ToString())); tlm.Add(5, new RepString(fp, rDatos["Observacion"].ToString())); tlm.Add(6, new RepString(fp, rDatos["Monto"].ToString())); } rDatos.Close(); //tlm. foreach (Page page in enum_Page) { Double rY = rPosInferior + 1.5; page.SetLandscape(); page.AddLT_MM(rPosIzquierda, rY, new RepString(fp, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString())); page.AddRT_MM(rPosDerecha, rY, new RepString(fp, page.iPageNo + " / " + iPageCount)); } }