WEB开发网
开发学院WEB开发Jsp 使用.NET自带的类实现DataGrid报表的打印 阅读

使用.NET自带的类实现DataGrid报表的打印

 2008-01-05 10:49:06 来源:WEB开发网   
核心提示:using System;using System.Windows.Forms;using System.Drawing;using System.Drawing.PRinting;using System.Data;using System.Collections;using DataLibrary;namespac

  using System;
  using System.Windows.Forms;
  using System.Drawing;
  using System.Drawing.PRinting;
  using System.Data;
  using System.Collections;
  using DataLibrary;
  
  namespace ControlLibrary
  {
   ///
   /// DataGrid打印
   ///

   public class DataGridPrinter
   {
   private PrintDocument ThePrintDocument;
   private DataTable TheTable;
   private DataGrid TheDataGrid;
   public int RowCount = 0;
   private const int kVerticalCellLeeway = 10;
   public int PageNumber = 1;
   public ArrayList Lines = new ArrayList();
   public int header=0;
   public int footer=0;
   DataCatena DataCatena1;
   public int PageWidth;
   public int PageHeight;
   public int TopMargin;
   public int BottomMargin;
   int GridWidth = 0;
   public int LeftMargin;
   public int RightMargin;
   public string PaperName;
   public int pagecount;
   private int rows_page;
   public bool showfooter;
  
   public int bodylength
   {
    get
    {
    if(this.PageNumber     return (1+this.rows_page) * ((int)(TheDataGrid.Font.SizeInPoints) + kVerticalCellLeeway);
    else
     return (this.TheTable.Rows.Count + 1 -(this.rows_page*(this.PageNumber-1))) * ( (int)
    (TheDataGrid.Font.SizeInPoints) + kVerticalCellLeeway);
    }
   }
  
   public DataGridPrinter(DataGrid aGrid, PrintDocument aPrintDocument,string theform,int Header,int Footer)
   {
    //
    // TODO: Add constrUCtor logic here
    //
    this.header=Header;
    this.footer=Footer;
    this.showfooter=true;
    TheDataGrid = aGrid;
    ThePrintDocument = aPrintDocument;
    if(theform!="")
    {
    DataCatena1=new DataCatena();
    DataView myDV=DataCatena1.GetDataView("select * from yh_bbdy where bm='"+theform +"'");
  
    this.PaperName=myDV[0]["zm"].ToString();
  
    PaperSize pkSize;
  
    if(myDV[0]["fx"].ToString()=="True")
     this.ThePrintDocument.DefaultPageSettings.Landscape=true;
    else
     this.ThePrintDocument.DefaultPageSettings.Landscape=false;
  
    int found=0;
    for (int i = 0; i < this.ThePrintDocument.PrinterSettings.PaperSizes.Count; i++)
    {
     pkSize = this.ThePrintDocument.PrinterSettings.PaperSizes[i];
     if(pkSize.PaperName==this.PaperName)
     {
     this.ThePrintDocument.DefaultPageSettings.PaperSize=pkSize;
     found=1;
     i=this.ThePrintDocument.PrinterSettings.PaperSizes.Count;
     if(this.ThePrintDocument.DefaultPageSettings.Landscape)
     {
      PageHeight = pkSize.Width;
      PageWidth = pkSize.Height;
     }
     else
     {
      PageWidth = pkSize.Width;
      PageHeight = pkSize.Height;
     }
     }
    }
  
    if(found==0)
    {
     if(this.ThePrintDocument.DefaultPageSettings.Landscape)
     {
     PageHeight = Int32.Parse(myDV[0]["zk"].ToString());
     PageWidth = Int32.Parse(myDV[0]["zc"].ToString());
     }
     else
     {
     PageWidth = Int32.Parse(myDV[0]["zk"].ToString());
     PageHeight = Int32.Parse(myDV[0]["zc"].ToString());
     }
    }
  
    TopMargin = Int32.Parse(myDV[0]["sk"].ToString());
    BottomMargin = Int32.Parse(myDV[0]["xk"].ToString());
    RightMargin = Int32.Parse(myDV[0]["rightk"].ToString());
    LeftMargin = Int32.Parse(myDV[0]["leftk"].ToString());
    }
    else
    {
    PageWidth = ThePrintDocument.DefaultPageSettings.PaperSize.Width;
    PageHeight = ThePrintDocument.DefaultPageSettings.PaperSize.Height;
    TopMargin = ThePrintDocument.DefaultPageSettings.Margins.Top;
    BottomMargin = ThePrintDocument.DefaultPageSettings.Margins.Bottom;
    RightMargin = ThePrintDocument.DefaultPageSettings.Margins.Right;
    LeftMargin = ThePrintDocument.DefaultPageSettings.Margins.Left;
    }
  
    PageWidth -= this.LeftMargin ;
    PageWidth -= this.RightMargin;
  
    this.rows_page=(int)((float)(this.PageHeight-this.TopMargin-this.BottomMargin-this.footer-this.header)
    /(TheDataGrid.Font.SizeInPoints + kVerticalCellLeeway));
  
    for (int k = 0; k < TheDataGrid.TableStyles[0].GridColumnStyles.Count; k++)
    {
    GridWidth += TheDataGrid.TableStyles[0].GridColumnStyles[k].Width; // TheTable.Columns[k].ToString();
    }
  
   }
  
   public void DrawHeader(Graphics g)
   {
    SolidBrush ForeBrush = new SolidBrush(TheDataGrid.HeaderForeColor);
    SolidBrush BackBrush = new SolidBrush(Color.White);  //(TheDataGrid.HeaderBackColor);
    Pen TheLinePen = new Pen(TheDataGrid.GridLineColor, 1);
    StringFormat cellformat = new StringFormat();
    cellformat.Trimming = StringTrimming.EllipsisCharacter;
    cellformat.FormatFlags = StringFormatFlags.NoWrap StringFormatFlags.LineLimit;
    cellformat.Alignment= StringAlignment.Center;
  
  
    int columnwidth = 0;
  
    int initialRowCount = RowCount;
  
    // draw the table header
    float startXPosition = this.LeftMargin;           //TheDataGrid.Location.X;
    RectangleF nextcellbounds = new RectangleF(0,0, 0, 0);
  
    /*
     这一段是画表头底色的代码
  
     RectangleF HeaderBounds = new RectangleF(0, 0, 0, 0);
  
     HeaderBounds.X = this.LeftMargin;    //TheDataGrid.Location.X;
     HeaderBounds.Y = + (RowCount - initialRowCount) * (TheDataGrid.Font.SizeInPoints + kVerticalCellLeeway);
     HeaderBounds.Height = TheDataGrid.Font.SizeInPoints + kVerticalCellLeeway;
     HeaderBounds.Width = PageWidth;
    */
    float y1=(float)(header+this.TopMargin);
  
    g.DrawLine(TheLinePen, this.LeftMargin, y1, this.LeftMargin + this.PageWidth, y1);
    y1=y1+ (float)(TheDataGrid.Font.SizeInPoints + kVerticalCellLeeway);
    g.DrawLine(TheLinePen, this.LeftMargin, y1, this.LeftMargin + this.PageWidth, y1);
  
    //  g.FillRectangle(BackBrush, HeaderBounds);
  
    for (int k = 0; k < this.TheDataGrid.TableStyles[0].GridColumnStyles.Count; k++)
    {
    columnwidth = TheDataGrid.TableStyles[0].GridColumnStyles[k].Width * PageWidth / this.GridWidth;
  
    string nextcolumn = TheDataGrid.TableStyles[0].GridColumnStyles[k].HeaderText; 
    // TheTable.Columns[k].ToString(); + (RowCount - initialRowCount) * (TheDataGrid.Font.SizeInPoints 
    + kVerticalCellLeeway)
    RectangleF cellbounds = new RectangleF(startxposition, header + TopMargin+2 ,
     columnwidth,
     TheDataGrid.HeaderFont.SizeInPoints + kVerticalCellLeeway-2);
    nextcellbounds = cellbounds;
  
    if (startxposition + columnwidth <= PageWidth+this.LeftMargin)
    {
     g.DrawString(nextcolumn, TheDataGrid.HeaderFont, ForeBrush, cellbounds, cellformat);
    }
  
    startxposition = startxposition + columnwidth;
  
    }
    y1=y1+ (float)(TheDataGrid.Font.SizeInPoints + kVerticalCellLeeway);
    g.DrawLine(TheLinePen, this.LeftMargin, y1, this.LeftMargin + this.PageWidth, y1);
  
    //if (TheDataGrid.GridLineStyle != DataGridLineStyle.None)
    // g.DrawLine(TheLinePen, TheDataGrid.Locatio

Tags:使用 NET 自带

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接