使用.NET內建的類實現DataGrid報表的列印

來源:互聯網
上載者:User
datagrid|列印 using System;
using System.Windows.Forms;
using System.Drawing;
using System.Drawing.Printing;
using System.Data;
using System.Collections;
using DataLibrary;

namespace ControlLibrary
{
/// <summary>
/// DataGrid列印
/// </summary>
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<this.pagecount)
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.Location.X, nextcellbounds.Bottom, PageWidth, nextcellbounds.Bottom);
}

public void SetDataSource(DataTable aTable)
{
TheTable = aTable;
this.pagecount=(int)Math.Ceiling((double)(TheTable.Rows.Count)/(double)(this.rows_page));
// MessageBox.Show("rows_count:"+TheTable.Rows.Count.ToString()+" rows_page:"+rows_page.ToString() + "page_count:" +this.pagecount.ToString());
// this.ThePrintDocument
}

public bool DrawRows(Graphics g)
{
int lastRowBottom = TopMargin;
Lines.Clear();

try
{
SolidBrush ForeBrush = new SolidBrush(TheDataGrid.ForeColor);
SolidBrush BackBrush = new SolidBrush(TheDataGrid.BackColor);
SolidBrush AlternatingBackBrush = new SolidBrush(TheDataGrid.AlternatingBackColor);
Pen TheLinePen = new Pen(TheDataGrid.GridLineColor, 1);
StringFormat cellformat = new StringFormat();
cellformat.Trimming = StringTrimming.EllipsisCharacter;
cellformat.FormatFlags = StringFormatFlags.NoWrap | StringFormatFlags.LineLimit;
int columnwidth = PageWidth/TheDataGrid.TableStyles[0].GridColumnStyles.Count;

int initialRowCount = (this.PageNumber-1)*this.rows_page;
int endrow=initialRowCount+this.rows_page;

RectangleF RowBounds = new RectangleF(0, 0, 0, 0);

// draw vertical lines

// draw the rows of the table
for (int i = initialRowCount; i < TheTable.Rows.Count && i< endrow; i++)
{
DataRow dr = TheTable.Rows[i];
int startxposition = this.LeftMargin+2; //TheDataGrid.Location.X;

RowBounds.X = 0;
RowBounds.Y = header + TopMargin + ((RowCount - initialRowCount)+1) * (TheDataGrid.Font.SizeInPoints + kVerticalCellLeeway);
RowBounds.Height = TheDataGrid.Font.SizeInPoints + kVerticalCellLeeway;
RowBounds.Width = PageWidth;


/* ///這一段是畫表格底色的代碼
if (i%2 == 0)
{
g.FillRectangle(BackBrush, RowBounds);
}
else
{
g.FillRectangle(AlternatingBackBrush, RowBounds);
}
*/

for (int j = 0; j < TheDataGrid.TableStyles[0].GridColumnStyles.Count; j++)
{
columnwidth = TheDataGrid.TableStyles[0].GridColumnStyles[j].Width* PageWidth / this.GridWidth -2;
RectangleF cellbounds = new RectangleF(startxposition,
header + TopMargin + 2 +
((RowCount - initialRowCount) + 1) * (TheDataGrid.Font.SizeInPoints + kVerticalCellLeeway),
columnwidth,
TheDataGrid.Font.SizeInPoints + kVerticalCellLeeway);


if (startxposition + columnwidth <= PageWidth)
{
g.DrawString(dr[(TheDataGrid.TableStyles[0].GridColumnStyles[j].MappingName)].ToString(), TheDataGrid.Font, ForeBrush, cellbounds, cellformat);
}

startxposition = startxposition + columnwidth+2;
}

Lines.Add(RowBounds.Bottom);
lastRowBottom = (int)RowBounds.Bottom;

RowCount++;
}

DrawHorizontalLines(g, Lines);
DrawVerticalGridLines(g, TheLinePen,lastRowBottom);

if(this.showfooter==true)
DrawFooter(g);

if (this.PageNumber<this.pagecount)
{
return true;
}
else
{
return false;
}

}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());

return false;
}

}

void DrawFooter(Graphics g)
{
FontFamily fontFamily = new FontFamily("宋體");

string text="第"+this.PageNumber.ToString()+"頁 共"
+this.pagecount.ToString()+"頁";

Font font = new Font(
fontFamily, 10,
FontStyle.Regular,
GraphicsUnit.Point);

SizeF size= g.MeasureString(text,font);

int startpos = this.PageHeight
-this.BottomMargin;

SolidBrush ForeBrush = new SolidBrush(Color.Black);

StringFormat cellformat = new StringFormat();

g.DrawString(text,font,ForeBrush,
(this.PageWidth-size.Width)/2 + this.LeftMargin,
startpos, cellformat);

text="【Cobainsoft】";

size= g.MeasureString(text,font);

g.DrawString(text,font,ForeBrush,
this.PageWidth + this.LeftMargin - size.Width-3,
startpos, cellformat);

}



void DrawHorizontalLines(Graphics g, ArrayList lines)
{
Pen TheLinePen = new Pen(TheDataGrid.GridLineColor, 1);

if (TheDataGrid.GridLineStyle == DataGridLineStyle.None)
return;

int i;

for (i = 0; i < lines.Count; i++)
{
g.DrawLine(TheLinePen, this.LeftMargin, (float)lines[i], this.LeftMargin + this.PageWidth, (float)lines[i]);
}

}

void DrawVerticalGridLines(Graphics g, Pen TheLinePen, int bottom)
{
if (TheDataGrid.GridLineStyle == DataGridLineStyle.None)
return;

int posx=0;

//畫最左邊的豎線

g.DrawLine(TheLinePen, this.LeftMargin + posx,
header + TopMargin,
this.LeftMargin + posx,
bottom);

//畫最右邊的豎線
g.DrawLine(TheLinePen, this.LeftMargin + this.PageWidth,
header + TopMargin,
this.LeftMargin + this.PageWidth,
bottom);

int total=TheDataGrid.TableStyles[0].GridColumnStyles.Count -1;
for (int k = 0; k < total; k++)
{
posx+=(TheDataGrid.TableStyles[0].GridColumnStyles[k].Width) * this.PageWidth / this.GridWidth;
g.DrawLine(TheLinePen, this.LeftMargin + posx,
header + TopMargin,
this.LeftMargin + posx,
bottom);
}
}


public bool DrawDataGrid(Graphics g)
{

try
{
DrawHeader(g);
bool bContinue = DrawRows(g);
return bContinue;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
return false;
}

}

}

}




相關文章

Beyond APAC's No.1 Cloud

19.6% IaaS Market Share in Asia Pacific - Gartner IT Service report, 2018

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。