报表源代码 winform c# -基于DexExpressXtraReport的打印报表,后台生成报表,winform版本,采用C#语言封装,比金质通更强大,现在开放源代码

基于DexExpressXtraReport的通用打印,先放源代码先!

源码里面有范例,方便新手学习

 

代码
//
// ================================================= 
//   基于DevExpress通用表格打印
//    
//    设计: 陈炎和 2011.02
//==================================================
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using DevExpress.XtraReports.UI;
using System.Data;


namespace com.CYH.TableXtraReport
{
    
    
/// <summary>
    
/// 报表每个单元打印前事件
    
/// </summary>
    
/// <param name="sender">发生事件的对象</param>
    
/// <param name="source">来源:1:页头 2:表头 3:表格 4:表脚 5:页脚 6:条码</param>
    
/// <param name="PageIndex">当前页号</param>
    
/// <param name="RowIndex">当前行号</param>
    
/// <param name="Caption">标题</param>
    
/// <param name="Field">绑定字段</param>
    
/// <param name="Value">打印前值</param>
    
/// <param name="e"></param>
    public delegate void XReportUnitAfterPrint(object sender,int source,int PageIndex,int RowIndex,string Caption,string Field,ref string Value,EventArgs e);
    
    
    
/// <summary>
    
/// 通用报表
    
/// </summary>
    public class TableXReport : DevExpress.XtraReports.UI.XtraReport
    {

        
/// <summary>
        
/// 报表主体设置
        
/// </summary>
        private  struct ReportMain
        {
            
/// <summary>
            
/// 打印机名
            
/// </summary>
            public string printerName;
            
/// <summary>
            
/// 纸张大小
            
/// </summary>
            public Size pageSize;
            
/// <summary>
            
/// 页边距
            
/// </summary>
            public System.Drawing.Printing.Margins Margins;
            
/// <summary>
            
/// 获取或设置纸张类型
            
/// </summary>
            public System.Drawing.Printing.PaperKind PaperKind;
            
/// <summary>
            
/// 获取或设置每行高度(以0.1毫米为单位)
            
/// </summary>
            public int DetailHeight;
            
/// <summary>
            
/// 获取或设置每页行数
            
/// </summary>
            public int DetailRows;
            
/// <summary>
            
/// 获取或设置打印开始页
            
/// </summary>
            public int BeginPage;
            
/// <summary>
            
/// 获取或设置打印结束页
            
/// </summary>
            public int EndPage;
            
/// <summary>
            
/// 获取或设置打印方向
            
/// </summary>
            public bool Landscape;
            
/// <summary>
            
/// 获取或设置表格线的类型
            
///   1:三栏表,2:有边框的三栏,4:完全网格
            
/// </summary>
            public int GridLine;
            
/// <summary>
            
/// 表格对齐方式
            
/// </summary>
            public System.Drawing.ContentAlignment Align;
        }
        
/// <summary>
        
/// 报表标题
        
/// </summary>
        private struct ReportTitle
        {
            
/// <summary>
            
/// 标题内空
            
/// </summary>
            public string Caption;
            
/// <summary>
            
/// 页头或页脚
            
/// </summary>
            public bool Header;
            
/// <summary>
            
/// 字体(宋体加粗四号)
            
/// </summary>
            public Font Font;
            
/// <summary>
            
/// 对齐方式
            
/// </summary>
            public DevExpress.XtraPrinting.TextAlignment TextAlignment;
            
/// <summary>
            
///  标题的高度和宽度,若不定义便检测Caption,否则自换行
            
/// </summary>
            public System.Drawing.Size size;
        }
        
/// <summary>
        
/// 报表各字段格式
        
/// </summary>
        private  struct ReportField
        {
            
/// <summary>
            
/// 名称
            
/// </summary>
            public string Name;
            
/// <summary>
            
/// 表格头标题
            
/// </summary>
            public string Caption;
            
/// <summary>
            
/// 标题字体(宋体、小四)
            
/// </summary>
            public Font HeaderFont;
            
/// <summary>
            
/// 绑定字段
            
/// </summary>
            public string Field;
            
/// <summary>
            
/// 对齐方式
            
/// </summary>
            public DevExpress.XtraPrinting.TextAlignment TextAlignment;
            
/// <summary>
            
/// 表格字体(宋体、小四)
            
/// </summary>
            public Font DetailFont;
            
/// <summary>
            
/// 自动换行
            
/// </summary>
            public bool WordWrap;
            
/// <summary>
            
/// 表格脚内容
            
/// </summary>
            public string Bottom;
            
/// <summary>
            
/// 是否合计
            
/// </summary>
            public bool Sum;
            
/// <summary>
            
/// 格式化字符串
            
/// </summary>
            public string FormatString;
            
/// <summary>
            
/// 标题的高度和宽度,若不定义便检测Caption,否则自换行并居中
            
/// </summary>
            public Size HeaderSize;
        }

        
private struct ReportBarcode
        {   
            
/// <summary>
            
/// 条码内容(A-Z,0-9)
            
/// </summary>
            public string Text;
            
/// <summary>
            
/// 起点
            
/// </summary>
            public Point pint;
            
/// <summary>
            
/// 大小
            
/// </summary>
            public Size size;
            
/// <summary>
            
/// 编码格式
            
/// </summary>
            public DevExpress.XtraPrinting.BarCode.BarCodeGeneratorBase Symbology;
            
/// <summary>
            
/// 是否显示文字
            
/// </summary>
            public bool showText;
        }


        
private ReportMain m_rpm = new ReportMain();
        
private ArrayList m_rpt = new ArrayList();
        
private ArrayList m_rpf = new ArrayList();
        
private ReportBarcode m_rpb = new ReportBarcode();
        
private int m_rowindex;
        
/// <summary>
        
/// 定义报表主体同时创建报表(必须先定义SetReportTitle和SetReportFiled)
        
/// </summary>
        
/// <param name="DetailHeight">明细每行高度</param>
        
/// <param name="DetailRows">每页行数</param>
        
/// <param name="GridLine">表格线的类型 1:三栏表,2:有边框的三栏,4:完全网格</param>
        
/// <param name="Align">表格对齐方向</param>
        
/// <param name="Landscape">横向还是纵向打印</param>
        
/// <param name="Margins">页的边距尺寸</param>
        
/// <param name="PaperKind">标准的纸张大小</param>
        
/// <param name="pageSize">纸张大小</param>
        
/// <param name="FromPage">起始页</param>
        
/// <param name="ToPage">结束页</param>
        
/// <param name="printerName">打印机名</param>        
        public void SetReportMain(int DetailHeight, int DetailRows, int GridLine, System.Drawing.ContentAlignment Align, bool Landscape, System.Drawing.Printing.Margins Margins,
            System.Drawing.Printing.PaperKind PaperKind, Size pageSize, 
int FromPage, int ToPage, string printerName)
        {
            m_rpm.DetailHeight 
= DetailHeight;
            m_rpm.DetailRows 
= DetailRows;
            m_rpm.Align 
= Align;
            m_rpm.Landscape 
= Landscape;
            m_rpm.Margins 
= Margins;
            m_rpm.PaperKind 
= PaperKind;
            m_rpm.pageSize 
= pageSize;
            m_rpm.BeginPage 
= FromPage;
            m_rpm.EndPage 
= ToPage;
            m_rpm.printerName 
= printerName;
            m_rpm.GridLine 
= GridLine;
            
base.Bands.Clear();
            
this.SetReport(m_rpm, (ReportTitle[])m_rpt.ToArray(typeof(ReportTitle)), (ReportField[])m_rpf.ToArray(typeof(ReportField)),m_rpb);
        }
        
/// <summary>
        
/// 定义报表标题
        
/// </summary>
        
/// <param name="Caption">标题内容</param>
        
/// <param name="Header">页头或页脚</param>
        
/// <param name="Font">字体(宋体加粗四号)</param>
        
/// <param name="TextAlignment">对齐方式</param>
        
/// <param name="size"> 标题的高度和宽度,若不定义便检测Caption,否则自换行</param>
        public void SetReportTitle(string Caption, bool Header, Font Font, DevExpress.XtraPrinting.TextAlignment TextAlignment, System.Drawing.Size size)
        {
            ReportTitle rpt 
= new ReportTitle();
            rpt.Caption 
= Caption;
            rpt.Header 
= Header;
            rpt.TextAlignment 
= TextAlignment == 0 ? DevExpress.XtraPrinting.TextAlignment.TopCenter : TextAlignment;
            rpt.Font 
= Font == null ? new System.Drawing.Font("宋体"14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))) : Font;
            rpt.size 
= size;
            m_rpt.Add(rpt);
        }
        
/// <summary>
        
/// 定义报表字段
        
/// </summary>
        
/// <param name="Caption">表格头标题</param>
        
/// <param name="HeaderFont">标题字体(宋体、小四)</param>
        
/// <param name="Field">绑定字段</param>
        
/// <param name="TextAlignment">对齐方式</param>
        
/// <param name="DetailFont"> 表格字体(宋体、小四)</param>
        
/// <param name="WordWrap">自动换行</param>
        
/// <param name="Bottom">表格脚内容</param>
        
/// <param name="Sum">是否合计</param>
        
/// <param name="FormatString">格式化字符串</param>
        
/// <param name="HeaderSize">标题的高度和宽度,若不定义便检测Caption,否则自换行并居中</param>
        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.TextAlignment 
= TextAlignment;
            rpf.DetailFont 
= DetailFont;
            rpf.WordWrap 
= WordWrap;
            rpf.Bottom 
= Bottom;
            rpf.Sum 
= Sum;
            rpf.FormatString 
= FormatString;
            rpf.HeaderSize 
= HeaderSize;
            m_rpf.Add(rpf);
        }
        
/// <summary>
        
/// 定义条码
        
/// </summary>
        
/// <param name="Text">条码内容(A-Z,0-9)</param>
        
/// <param name="pint">起点</param>
        
/// <param name="size">大小</param>
        
/// <param name="Symbology">编码格式</param>
        
/// <param name="showText">是否显示文字</param>
        public void SetReportBarCode(string Text, Point pint, Size size, DevExpress.XtraPrinting.BarCode.BarCodeGeneratorBase Symbology, bool showText)
        {
            m_rpb.Text 
= Text;
            m_rpb.pint 
= pint;
            m_rpb.size 
= size;
            m_rpb.Symbology 
=  Symbology==null?new DevExpress.XtraPrinting.BarCode.Code128Generator():Symbology;
            m_rpb.showText 
= showText;
        }
       

        
private const int c_LineWidth =3;//预留边线的宽度
        /// <summary>
        
/// 报表每个单元打印前事件
        
/// </summary>
        public event XReportUnitAfterPrint UnitAfterPrint;
        
//报表头、报表尾整个报表中只会加载一次,页头、页尾每一页都会加载一次
        
//本通用报表只有页头,页尾和表体三部份
        
        
private ReportMain rpMain;
        
/// <summary>
        
/// 初始化通用表格打印
        
/// </summary>
        public TableXReport()
        {
            
this.ReportUnit = ReportUnit.TenthsOfAMillimeter; //使用0.1毫米计量单位
            this.Dpi = 254F;
            
base.BeforePrint += new System.Drawing.Printing.PrintEventHandler(XReport_BeforePrint);
            
base.AfterPrint+=new EventHandler(XReport_AfterPrint);
             
        }       
        
// 设置标准格式报表
        private  void SetReport( ReportMain  rpm,ReportTitle[] rpt,ReportField[] rpf ,ReportBarcode rpb)
        {             
           rpMain 
= rpm;           
           
//初始化变量
           if (rpMain.Align == 0) rpMain.Align = ContentAlignment.TopCenter;
           
for (int i = 0; i < rpt.Length; i++)
           {
               
if (rpt[i].TextAlignment ==0) rpt[i].TextAlignment=DevExpress.XtraPrinting.TextAlignment.TopCenter;
               
if (rpt[i].Font == null) rpt[i].Font = new System.Drawing.Font("宋体"14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
           }
           
for (int i = 0;i < rpf.Length ;i++)
           {
               
if (rpf[i].TextAlignment ==0) rpf[i].TextAlignment=DevExpress.XtraPrinting.TextAlignment.TopLeft;
               
if (rpf[i].HeaderFont==null) rpf[i].HeaderFont = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
               
if (rpf[i].DetailFont==null) rpf[i].DetailFont = new System.Drawing.Font("宋体", 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? 3:2* c_LineWidth, (int)size.Height + 30); //宽度增加2个线位,防止自动换行                  
               }
           }

           
if (rpm.Margins != nullthis.Margins = rpm.Margins;
           
if (!rpm.pageSize.IsEmpty)
           {
               
this.PaperKind = System.Drawing.Printing.PaperKind.Custom;              
               
this.PageSize = rpm.pageSize;
           }
           
else
               
this.PaperKind = rpm.PaperKind;
           
this.Landscape = rpm.Landscape;
           
if (rpm.printerName != string.Empty) this.PrinterName = rpm.printerName;


           DetailBand detail 
= new DetailBand();
           PageHeaderBand pageHeader 
= new PageHeaderBand();
           PageFooterBand pageFooter 
= new PageFooterBand();
           pageHeader.Dpi 
= 254F;  //用于0.1毫米的计量
           detail.Dpi = 254F;
           pageFooter.Dpi 
= 254F;
           XRPanel TitleHeader 
= CreateTitleHeader(rpt, true);
           XRPanel TitleFooter 
= CreateTitleHeader(rpt, false);
           XRTable TableHeader 
= CreateTableHeader(rpf,rpMain.GridLine==4);
           XRTable TableFooter 
= CreateTableFooter(rpf, rpm.DetailHeight, rpMain.GridLine == 4);
           XRTable TableDetail 
= CreateTableDetail(rpf, rpm.DetailHeight, rpMain.GridLine == 4);
           XRBarCode BarCode 
= createBarCode(rpb);
           
//校正表格的对齐方式
           switch (rpMain.Align)
           {
               
case ContentAlignment.TopLeft:
                   TableHeader.Left 
= c_LineWidth;
                   
break;
               
case ContentAlignment.TopRight:
                   TableHeader.Left 
= (this.PageWidth - (this.Margins.Left + this.Margins.Right)) - TableHeader.Width - c_LineWidth;
                   
break;
               
default:  //中间
                   TableHeader.Left = (this.PageWidth - (this.Margins.Left + this.Margins.Right) - TableHeader.Width) /2 ;
                   
break;
           }
           TableDetail.Left 
= TableHeader.Left;
           TableFooter.Left 
= TableHeader.Left;           
           
//页头 
           TableHeader.Top = c_LineWidth + TitleHeader.Top + TitleHeader.Height ;
           
if (rpb.Text !=null && rpb.Text != string.Empty)  //加入条码
           {
               pageHeader.Controls.Add(BarCode);
               
if (TableHeader.Top + TableHeader.Height < BarCode.Height) TableHeader.Top = BarCode.Height - TableHeader.Height;
           }                            
           pageHeader.Controls.Add(TitleHeader);
           pageHeader.Controls.Add(TableHeader);
           pageHeader.Height 
=  TableHeader.Top + TableHeader.Height;         
           
//表格头二条线
           if (rpm.GridLine == 1 || rpm.GridLine == 2)
           {
               pageHeader.Controls.Add(CreateLine(TableHeader.Left ,TableHeader.Top,TableHeader.Width,TableHeader.Height, DevExpress.XtraPrinting.BorderSide.Top));
               pageHeader.Controls.Add(CreateLine(TableHeader.Left ,TableHeader.Top,TableHeader.Width,TableHeader.Height, DevExpress.XtraPrinting.BorderSide.Bottom));
               
//两侧线
               if (rpm.GridLine == 2)
               {
                   pageHeader.Controls.Add(CreateLine(TableHeader.Left, TableHeader.Top, TableHeader.Width, TableHeader.Height, DevExpress.XtraPrinting.BorderSide.Left));
                   pageHeader.Controls.Add(CreateLine(TableHeader.Left, TableHeader.Top, TableHeader.Width, TableHeader.Height, DevExpress.XtraPrinting.BorderSide.Right));
               }
           }           
           
//带区
           detail.Height = rpm.DetailHeight;
           detail.Controls.Add(TableDetail);
           
//两侧线
           if (rpm.GridLine == 2)
           {
               detail.Controls.Add(CreateLine(TableDetail.Left, TableDetail.Top, TableDetail.Width, TableDetail.Height, DevExpress.XtraPrinting.BorderSide.Left));
               detail.Controls.Add(CreateLine(TableDetail.Left, TableDetail.Top, TableDetail.Width, TableDetail.Height, DevExpress.XtraPrinting.BorderSide.Right));
           }
           
//页脚
           if (rpm.GridLine == 1 || rpm.GridLine == 2//一条线
           {
               pageFooter.Controls.Add(CreateLine(TableDetail.Left, 
0, TableDetail.Width, 0, DevExpress.XtraPrinting.BorderSide.Top));
               TableFooter.Top 
= c_LineWidth;
               TitleFooter.Top 
= c_LineWidth;
           }
           
else
           {
               TableFooter.Top 
= 0;
               TitleFooter.Top 
= 0;
           }
           
if (TableFooter.Rows[0].Cells.Count > 0)
           {               
               TitleFooter.Top 
= TableFooter.Height+TableFooter.Top;   
               pageFooter.Controls.Add(TableFooter);              
           }          
            pageFooter.Controls.Add(TitleFooter);          
           
if (rpm.DetailRows > 0)
           {  
              
//计算余下的空白
               if (pageHeader.Height + detail.Height * rpm.DetailRows + this.Margins.Top + this.Margins.Bottom > this.PageHeight)
                   
throw new Exception("PageHeight不够大,请重新定义纸张大小,或减少DetailRows");
               pageFooter.Height 
= this.PageHeight - pageHeader.Height - detail.Height * rpm.DetailRows - this.Margins.Top - this.Margins.Bottom - 1//必须减1         
           }
           
else 
              pageFooter.Height 
= TitleFooter.Top + TitleFooter.Height;            
           Bands.AddRange(
new DevExpress.XtraReports.UI.Band[] { detail, pageHeader,pageFooter});
           
//this.Bands[BandKind.PageHeader].Controls.Add(tableHeader); 另一种加入方法
                    
        }     

        
// 创建表线(从指定距形中创建边线,线在边框外)
        
//由于线条有一个宽度,起点坐标要向左移一个宽度,水平线还要增长2个宽度,上水平线向上移一个宽度
        private XRLine CreateLine(int x ,int y,int w,int h ,DevExpress.XtraPrinting.BorderSide BorderSide)
        {
            XRLine xrline 
= new XRLine();
            xrline.Dpi 
= 254F;
            xrline.LineDirection 
= (BorderSide == DevExpress.XtraPrinting.BorderSide.Left || BorderSide == DevExpress.XtraPrinting.BorderSide.Right) ? LineDirection.Vertical : LineDirection.Horizontal;            
            xrline.LineWidth 
= c_LineWidth; //线宽
            if (xrline.LineDirection == LineDirection.Vertical) //垂直
            {
                xrline.Width 
= c_LineWidth;
                
//当LineWidth少于5时,Width或Height会自动校正为5,必须手工校正坐标
                xrline.Left = x -(xrline.Width - c_LineWidth)/2+ (BorderSide == DevExpress.XtraPrinting.BorderSide.Right ? w : -c_LineWidth);  
                xrline.Height 
= h;
                xrline.Top 
= y;              
            }
            
else //水平
            {
                xrline.Height 
= c_LineWidth;
                
//当LineWidth少于5时,Width或Height会自动校正为5,必须手工校正坐标
                xrline.Top = y -(xrline.Height - c_LineWidth)/2+(BorderSide == DevExpress.XtraPrinting.BorderSide.Bottom?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.TextAlignment;
                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.TextAlignment;
                    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.TextAlignment;
                    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 ? new Point(00) : rpb.pint;
            xrbar.Module 
= 5.08F;
            xrbar.Size 
= rpb.size.IsEmpty ? new Size(this.PageWidth - this.Margins.Left - this.Margins.Right, 150) : rpb.size;
            xrbar.Text 
= rpb.Text;
            xrbar.ShowText 
= rpb.showText;
            xrbar.Symbology 
= rpb.Symbology;
            xrbar.PrintOnPage 
+= new PrintOnPageEventHandler(xrbar_PrintOnPage);
            
return xrbar;
        }

           
        
#endregion

        
#region   //处理表格各个事件

        
//每页单元格事件
        void tableDetail_PrintOnPage(object sender, PrintOnPageEventArgs e)
        {
            m_rowindex
++;
        }

        
void headerCell_PrintOnPage(object sender, PrintOnPageEventArgs e)
        {
            
if (UnitAfterPrint == nullreturn;
            XRTableCell cell 
= (XRTableCell)sender;
            
string value = cell.Text;
            UnitAfterPrint(sender, 
2, e.PageIndex, m_rowindex, cell.Text, cell.Tag.ToString(), ref value, new EventArgs());
            cell.Text 
= value;
        }

             
//处理表格单元事件
        void detailCell_PrintOnPage(object sender, PrintOnPageEventArgs e)
        {
            
if (UnitAfterPrint == nullreturn;
            XRTableCell cell 
= (XRTableCell)sender;
            
string field = "";
            
string value = cell.Text;
            
if (cell.DataBindings.Count > 0) field = cell.DataBindings[0].DataMember;                     
            UnitAfterPrint(sender, 
3, e.PageIndex, m_rowindex, cell.Tag.ToString(), field, ref value , new EventArgs());
            cell.Text 
= value;
        }

        
//处理标题单元事件
        void title_PrintOnPage(object sender, PrintOnPageEventArgs e)
        {
            
if (UnitAfterPrint == nullreturn;
            XRLabel xrl 
= (XRLabel)sender;
            
string value = xrl.Text;
            UnitAfterPrint(sender, Convert.ToBoolean(xrl.Tag) 
? 1 : 5, e.PageIndex, m_rowindex, xrl.Text, ""ref value , new EventArgs());
            xrl.Text 
= value;
        }          
        
//表格脚事件
        void FooterCell_PrintOnPage(object sender, PrintOnPageEventArgs e)
        {
            
if (UnitAfterPrint == nullreturn;
            XRTableCell cell 
= (XRTableCell)sender;
            
string field = "";
            
string value = cell.Text;
            
if (cell.DataBindings.Count > 0) field = cell.DataBindings[0].PropertyName;
            UnitAfterPrint(sender, 
4, e.PageIndex, m_rowindex, cell.Tag.ToString(), field, ref value, new EventArgs());
            cell.Text 
= value;
        }
        
//条码事件
        void xrbar_PrintOnPage(object sender, PrintOnPageEventArgs e)
        {
            
if (UnitAfterPrint == nullreturn;
            XRBarCode barcode 
= (XRBarCode)sender;
            
string value = barcode.Text;
            UnitAfterPrint(sender, 
6, e.PageIndex, m_rowindex,barcode.Text,""ref value, new EventArgs());
            barcode.Text 
= value;
        } 
        
#endregion

        
void XReport_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            m_rowindex 
= 0;
        }
        
void XReport_AfterPrint(object sender, EventArgs e)
        {
            
for (int i = this.PrintingSystem.Pages.Count; i > 0; i--)
            {
                
if ((i < m_rpm.BeginPage && m_rpm.BeginPage > 0|| (i > m_rpm.EndPage && m_rpm.EndPage > 0))
                    
this.PrintingSystem.Pages.Remove(this.PrintingSystem.Pages[1]); //移去指定的页码;
            }
        }
        
//测量字符的打印范围(单行)
        private SizeF MeasureString(string text, Font font)
        {
            
return MeasureString(text, font, 10000);
        }
        
//测量字符的打印范围(多行)
        private SizeF MeasureString(string text, Font font,int width)
        {
            
//Graphics fg = CreateGraphics();
            
//fg.PageUnit = GraphicsUnit.Pixel;
            
//fg.MeasureString();
           SizeF size=DevExpress.XtraPrinting.BrickGraphics.MeasureString(text, font, width, null, GraphicsUnit.Millimeter);
           size.Width 
= size.Width * 10;
           size.Height 
= size.Height * 10;
           
return size;
        }
       

    }
}

  

源码示例下载 

posted @ 2011-02-23 16:26  yayaLee  阅读(2388)  评论(3编辑  收藏  举报