使用.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
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
更多精彩
赞助商链接