DevExpress如何实现通用表格打印

new System.Drawing.Font("楷体_GB2312", 14.25F, System.Drawing.FontStyle.Bold,System.Drawing.GraphicsUnit.Point, ((byte)(134))) : Font; rpt.size = size; m_rpt.Add(rpt); } public void AddReportTitle(string Caption, bool Header, Font Font, StringAlignment TextAlignment,System.Drawing.Size size) { DevExpress.XtraPrinting.TextAlignment alig = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; if (TextAlignment == StringAlignment.Center) alig = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; if (TextAlignment == StringAlignment.Far) alig = DevExpress.XtraPrinting.TextAlignment.MiddleRight; SetReportTitle(Caption, Header, Font, alig, size); } /// /// 定义报表标题 /// /// 标题内容 /// 页头或页脚 public void AddReportTitle(string Caption, bool Header) { AddReportTitle(Caption, Header, null, StringAlignment.Near, Size.Empty); } /// /// 定义报表字段 /// /// 表格头标题 /// 标题字体(楷体_GB2312、小四) /// 绑定字段 /// 对齐方式 /// 表格字体(楷体_GB2312、小四) /// 自动换行 /// 表格脚内容 /// 是否合计 /// 格式化字符串 /// 标题的高度和宽度，若不定义便检测Caption,否则自换行并居中 public void SetReportField(string Caption, Font HeaderFont, string Field, DevExpress.XtraPrinting.TextAlignment TextAlignment, Font DetailFont , bool WordWrap, string Bottom, bool Sum, string FormatString, Size HeaderSize) { ReportField rpf = new ReportField(); rpf.Caption = Caption; rpf.HeaderFont = HeaderFont; rpf.Field = Field; rpf.xTextAlignment = TextAlignment; rpf.DetailFont = DetailFont; rpf.WordWrap = WordWrap; rpf.Bottom = Bottom; rpf.Sum = Sum; rpf.FormatString = FormatString; rpf.HeaderSize = HeaderSize; m_rpf.Add(rpf); } public void AddReportField(string Caption, Font HeaderFont, string Field, StringAlignment TextAlignment, Font DetailFont , bool WordWrap, string Bottom, bool Sum, string FormatString, Size HeaderSize) { DevExpress.XtraPrinting.TextAlignment alig = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; if (TextAlignment == StringAlignment.Center) alig = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; if (TextAlignment == StringAlignment.Far) alig = DevExpress.XtraPrinting.TextAlignment.MiddleRight; SetReportField(Caption, HeaderFont, Field, alig, DetailFont, WordWrap, Bottom, Sum, FormatString, HeaderSize); } /// /// 定义报表字段 /// /// 表格头标题 /// 绑定字段 public void AddReportField(string Caption, string Filed) { AddReportField(Caption, null, Filed, StringAlignment.Near, null, false, "", false, string.Empty, Size.Empty); } /// /// 定义条码 /// /// 条码内容(A-Z,0-9) /// 起点 /// 大小 /// 是否显示文字 /// 字段名 public void SetReportBarCode(string Text, Point pint, Size size, bool showText, string Field) { m_rpb.Text = Text; m_rpb.pint = pint; m_rpb.size = size; m_rpb.showText = showText; m_rpb.Field = Field; } private const int c_LineWidth =3;//预留边线的宽度 /// /// 报表每个单元打印前事件 /// public event ReportUnitAfterPrint UnitAfterPrint; //报表头、报表尾整个报表中只会加载一次，页头、页尾每一页都会加载一次 //本通用报表只有页头，页尾和表体三部份 private ReportMain rpMain; /// /// 初始化通用表格打印 /// public ctlTableXReport() { this.ReportUnit = ReportUnit.TenthsOfAMillimeter; //使用0.1毫米计量单位 this.Dpi = 254F; base.BeforePrint += new System.Drawing.Printing.PrintEventHandler(XReport_BeforePrint); base.AfterPrint+=new EventHandler(XReport_AfterPrint); } /// /// 显示打印 /// /// public void ShowDialog() { base.ShowPreview(); } /// /// 显示打印 /// /// /// public void ShowDialog(IWin32Window owner) { base.ShowPreviewDialog(); } /// /// 自动页长时计算每页打印的行数 /// /// 总行数 /// 充许每页打印最大行数 /// public int GetAutoRow(int rows, int maxrow) { if (rows % maxrow == 0) return maxrow; else { //找余数为0或最接近最大行数 List m = new List(); for (int i = maxrow; i >= maxrow * 3 / 4; i--) { m.Add(rows % i); if (rows % i == 0) return i; } int k = m.AsEnumerable().Max(); for (int i = 0; i < m.Count(); i++) { if (m[i] == k) return maxrow - i;//只能最接近了 } return maxrow; } } /// /// 设置标准格式报表 /// private void SetReport( ReportMain rpm,ReportTitle[] rpt,ReportField[] rpf ,ReportBarcode rpb) { rpMain = rpm; //初始化变量 if (rpMain.Align == 0) rpMain.Align = StringAlignment.Center; for (int i = 0; i < rpt.Length; i++) { if (rpt[i].xTextAlignment ==0) rpt[i].xTextAlignment=DevExpress.XtraPrinting.TextAlignment.TopCenter; if (rpt[i].Font == null) rpt[i].Font = new System.Drawing.Font("楷体_GB2312", 14.25F,System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); } for (int i = 0;i < rpf.Length ;i++) { if (rpf[i].xTextAlignment ==0) rpf[i].xTextAlignment=DevExpress.XtraPrinting.TextAlignment.TopLeft; if (rpf[i].HeaderFont==null) rpf[i].HeaderFont = new System.Drawing.Font("楷体_GB2312", 12F,System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); if (rpf[i].DetailFont==null) rpf[i].DetailFont = new System.Drawing.Font("楷体_GB2312", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); if (rpf[i].HeaderSize.IsEmpty) { SizeF size = MeasureString(rpf[i].Caption,rpf[i].HeaderFont); rpf[i].HeaderSize = new Size((int)size.Width + (i==0?h:-c_LineWidth); xrline.Width = w + 2* c_LineWidth; //水平线加一个宽度 xrline.Left = x - c_LineWidth; } return xrline; } #region 创建表格的各个功能单元 // 创建表格头 private XRTable CreateTableHeader(ReportField[] rpf,bool border) { System.Drawing.Size tablesize = new Size(); XRTableRow headerRow = new XRTableRow(); headerRow.Dpi = 254F; foreach (ReportField obj in rpf) { XRTableCell headerCell = new XRTableCell(); headerCell.Dpi = 254F; headerCell.Font = obj.HeaderFont; headerCell.Width = obj.HeaderSize.Width; if (border) //上下边和侧边 if (obj.Equals(rpf[0])) headerCell.Borders =(DevExpress.XtraPrinting.BorderSide) (DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Left|DevExpress.XtraPrinting.BorderSide.Bottom); else headerCell.Borders = (DevExpress.XtraPrinting.BorderSide)(DevExpress.XtraPrinting.BorderSide.Bottom| DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Right); headerCell.BorderWidth = c_LineWidth; if (tablesize.Height < obj.HeaderSize.Height) tablesize.Height = obj.HeaderSize.Height; headerCell.WordWrap = true; //自动换行 headerCell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; headerCell.CanGrow = false; headerCell.Text = obj.Caption; headerCell.Tag = obj.Field; //headerCell.BackColor = Color.Red; headerCell.PrintOnPage += new PrintOnPageEventHandler(headerCell_PrintOnPage); if (obj.Name !=null && obj.Name != string.Empty) headerCell.Name ="header_"+ obj.Name; headerRow.Cells.Add(headerCell); tablesize.Width = tablesize.Width + headerCell.Width; } headerRow.Size = tablesize; XRTable tableHeader = new XRTable(); tableHeader.Dpi = 254F; tableHeader.Size = tablesize; tableHeader.Rows.Add(headerRow); return tableHeader; } // 创建表格 private XRTable CreateTableDetail(ReportField[] rpf, int rowHeight,bool border) { System.Drawing.Size tablesize = new Size(); tablesize.Height = rowHeight; XRTableRow detailRow = new XRTableRow(); detailRow.Dpi = 254F; foreach (ReportField obj in rpf) { XRTableCell detailCell = new XRTableCell(); detailCell.Dpi = 254F; detailCell.Font = obj.DetailFont; detailCell.Width = obj.HeaderSize.Width; if (obj.FormatString==null || obj.FormatString == string.Empty) detailCell.DataBindings.Add("Text", null, obj.Field); else detailCell.DataBindings.Add("Text", null,obj.Field,obj.FormatString); detailCell.Tag = obj.Caption; detailCell.TextAlignment = obj.xTextAlignment; detailCell.WordWrap = obj.WordWrap; //detailCell.BackColor = Color.Blue; detailCell.CanGrow = false; if (border) //侧边和下边 if (obj.Equals(rpf[0])) detailCell.Borders = (DevExpress.XtraPrinting.BorderSide) (DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Left| DevExpress.XtraPrinting.BorderSide.Bottom); else detailCell.Borders = (DevExpress.XtraPrinting.BorderSide)(DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom); detailCell.BorderWidth = c_LineWidth; detailCell.PrintOnPage += new PrintOnPageEventHandler(detailCell_PrintOnPage); if (obj.Name != null && obj.Name != string.Empty) detailCell.Name = "detail_" + obj.Name; detailRow.Cells.Add(detailCell); tablesize.Width = tablesize.Width + detailCell.Width;// +LineCell.Width; } detailRow.Size = tablesize; XRTable tableDetail = new XRTable(); tableDetail.Dpi = 254F; tableDetail.Size = tablesize; tableDetail.Rows.Add(detailRow); tableDetail.PrintOnPage += new PrintOnPageEventHandler(tableDetail_PrintOnPage); return tableDetail; } // 创建表格脚(若Rows[0].Cells.Count 表示无表格脚) private XRTable CreateTableFooter(ReportField[] rpf, int rowHeight, bool border) { System.Drawing.Size tablesize = new Size(); tablesize.Height = rowHeight; XRTableRow FooterRow = new XRTableRow(); FooterRow.Dpi = 254F; bool isfooter = false; foreach (ReportField obj in rpf) { if (obj.Sum || (obj.Bottom != null && obj.Bottom != string.Empty)) { isfooter = true; break; } } if (isfooter) foreach (ReportField obj in rpf) { XRTableCell FooterCell = new XRTableCell(); FooterCell.Dpi = 254F; FooterCell.Font = obj.HeaderFont; FooterCell.Width = obj.HeaderSize.Width; FooterCell.Tag = obj.Caption; FooterCell.CanGrow = false; if (obj.Sum) //合计 { if (obj.FormatString == null || obj.FormatString == string.Empty) FooterCell.DataBindings.Add("Text", null, obj.Field); else FooterCell.DataBindings.Add("Text", null, obj.Field, obj.FormatString); DevExpress.XtraReports.UI.XRSummary xrSummary = new DevExpress.XtraReports.UI.XRSummary(); xrSummary.Running = DevExpress.XtraReports.UI.SummaryRunning.Page; FooterCell.Summary = xrSummary; } else FooterCell.Text = obj.Bottom; if (border) //侧边和下边 if (obj.Equals(rpf[0])) FooterCell.Borders = (DevExpress.XtraPrinting.BorderSide) (DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Bottom); else FooterCell.Borders = (DevExpress.XtraPrinting.BorderSide) (DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom); FooterCell.BorderWidth = c_LineWidth; FooterCell.TextAlignment = obj.xTextAlignment; FooterCell.WordWrap = obj.WordWrap; //FooterCell.BackColor = Color.Yellow; FooterCell.PrintOnPage += new PrintOnPageEventHandler(FooterCell_PrintOnPage); if (obj.Name != null && obj.Name != string.Empty) FooterCell.Name = "footer_" + obj.Name; FooterRow.Cells.Add(FooterCell); tablesize.Width = tablesize.Width + FooterCell.Width;// +LineCell.Width; } XRTable tableFooter = new XRTable(); tableFooter.Dpi = 254F; FooterRow.Size = tablesize; tableFooter.Size = tablesize; tableFooter.Rows.Add(FooterRow); return tableFooter; } // 创建页头或页脚标题 (Rows.Count =0表示无标题) private XRPanel CreateTitleHeader(ReportTitle[] rpt, bool Header) { XRPanel xrpHeader = new XRPanel(); xrpHeader.Dpi = 254F; System.Drawing.Size size = new Size(); foreach (ReportTitle obj in rpt) { if (obj.Header == Header) { XRLabel xrt = new XRLabel(); xrt.Dpi = 254F; xrt.Text = obj.Caption; xrt.Tag = Header; xrt.TextAlignment = obj.xTextAlignment; xrt.WordWrap = true; xrt.CanGrow = false; xrt.Font = obj.Font; if (obj.size.IsEmpty) { xrt.Width = (this.PageWidth - (this.Margins.Left + this.Margins.Right)); xrt.Height = (int)MeasureString(obj.Caption, obj.Font, xrt.Width).Height + 1; } else { xrt.Width = obj.size.Width; xrt.Height = obj.size.Height; } xrt.PrintOnPage += new PrintOnPageEventHandler(title_PrintOnPage); xrt.Top = size.Height; size.Width = xrt.Width; size.Height = size.Height + xrt.Height; ; xrpHeader.Controls.Add(xrt); } } xrpHeader.Size = size; return xrpHeader; } // 创建条码 private XRBarCode createBarCode(ReportBarcode rpb) { XRBarCode xrbar = new XRBarCode(); xrbar.AutoModule = true; xrbar.Dpi = 254F; xrbar.Location = rpb.pint.IsEmpty ?