PrintDataGridView.cs
using System;
using System.Collections.Generic;
using
System.Text;
using System.Drawing;
using System.Data;
using
System.Data.SqlClient;
using System.Drawing.Printing;
using
System.Windows.Forms;
namespace ManagerBLL
{
public class PrintDataGridView
{
private static List<DataGridViewCellPrint> CellPrintList =
new List<DataGridViewCellPrint>();
private static
PageSetupDialog pageSetup =null;
private static int printRowCount =
0;
private static bool IsPrint = true;
private static bool
IsRole = true;
private static int PoXTmp = 0;
private
static int PoYTmp = 0;
private static int WidthTmp = 0;
private static int HeightTmp = 0;
private static int RowIndex =
0;
/// <summary>
/// 打印DataGridView控件
///
</summary>
/// <param
name="dataGridView">DataGridView控件</param>
/// <param
name="includeColumnText">是否包括列标题</param>
/// <param
name="e">为 System.Drawing.Printing.PrintDocument.PrintPage
事件提供数据。</param>
/// <param
name="PoX">起始X坐标</param>
/// <param
name="PoY">起始Y坐标</param>
public static void
Print(DataGridView dataGridView, bool includeColumnText, PrintPageEventArgs
eValue, ref int PoX, ref int PoY)
{
pageSetup = new
PageSetupDialog();
pageSetup.PageSettings =
eValue.PageSettings;
//pageSetup.Document;
pageSetup.ShowDialog();
try
{
if (PrintDataGridView.IsPrint)
{
PrintDataGridView.printRowCount = 0;
PrintDataGridView.IsPrint = false;
PrintDataGridView.DataGridViewCellVsList(dataGridView,
includeColumnText);
if
(PrintDataGridView.CellPrintList.Count==0)
return;
if (PoX >
eValue.MarginBounds.Left)
PrintDataGridView.IsRole =
true;
else
PrintDataGridView.IsRole = false;
PrintDataGridView.PoXTmp = PoX;
PrintDataGridView.PoYTmp
= PoY;
PrintDataGridView.RowIndex =
0;
WidthTmp = 0;
HeightTmp =
0;
}
if
(PrintDataGridView.printRowCount!=0)
{
if (IsRole)
{
PoX = PoXTmp =
eValue.MarginBounds.Left;
PoY = PoYTmp =
eValue.MarginBounds.Top;
}
else
{
PoX =
PoXTmp;
PoY = PoYTmp;
}
}
while (PrintDataGridView.printRowCount
< PrintDataGridView.CellPrintList.Count)
{
DataGridViewCellPrint CellPrint =
CellPrintList[PrintDataGridView.printRowCount];
if
(RowIndex == CellPrint.RowIndex)
PoX = PoX +
WidthTmp;
else
{
PoX = PoXTmp;
PoY = PoY
+ HeightTmp;
if (PoY + HeightTmp >
eValue.MarginBounds.Bottom)
{
HeightTmp = 0;
eValue.HasMorePages = true;
return;
}
}
using (SolidBrush solidBrush = new
SolidBrush(CellPrint.BackColor))
{
RectangleF rectF1 = new RectangleF(PoX, PoY,
CellPrint.Width, CellPrint.Height);
eValue.Graphics.FillRectangle(solidBrush, rectF1);
using (Pen pen = new Pen(Color.Black, 1))
eValue.Graphics.DrawRectangle(pen,
Rectangle.Round(rectF1));
solidBrush.Color =
CellPrint.ForeColor;
eValue.Graphics.DrawString(CellPrint.FormattedValue, CellPrint.Font, solidBrush,
new Point(PoX + 2, PoY + 3));
}
WidthTmp = CellPrint.Width;
HeightTmp =
CellPrint.Height;
RowIndex =
CellPrint.RowIndex;
PrintDataGridView.printRowCount++;
}
PoY =
PoY + HeightTmp;
eValue.HasMorePages =
false;
PrintDataGridView.IsPrint = true;
}
catch(Exception ex)
{
eValue.HasMorePages = false;
PrintDataGridView.IsPrint =
true;
throw ex;
}
}
/// <summary>
/// 将DataGridView控件内容转变到
CellPrintList
/// </summary>
/// <param
name="dataGridView">DataGridView控件</param>
/// <param
name="includeColumnText">是否包括列标题</param>
private static void
DataGridViewCellVsList(DataGridView dataGridView, bool
includeColumnText)
{
CellPrintList.Clear();
try
{
int rowsCount = dataGridView.Rows.Count;
int colsCount =
dataGridView.Columns.Count;
//最后一行是供输入的行时，不用读数据。
if
(dataGridView.Rows[rowsCount - 1].IsNewRow)
rowsCount--;
//包括列标题
if
(includeColumnText)
{
for (int
columnsIndex = 0; columnsIndex < colsCount;
columnsIndex++)
{
if
(dataGridView.Columns[columnsIndex].Visible)
{
DataGridViewCellPrint CellPrint = new
DataGridViewCellPrint();
CellPrint.FormattedValue
= dataGridView.Columns[columnsIndex].HeaderText;
CellPrint.RowIndex = 0;
CellPrint.ColumnIndex =
columnsIndex;
CellPrint.Font =
dataGridView.Columns[columnsIndex].HeaderCell.Style.Font;
CellPrint.BackColor = Color.Orange;//
dataGridView.ColumnHeadersDefaultCellStyle.BackColor;
CellPrint.ForeColor =
dataGridView.ColumnHeadersDefaultCellStyle.ForeColor;
CellPrint.Width =
dataGridView.Columns[columnsIndex].Width;
CellPrint.Height =
dataGridView.ColumnHeadersHeight;
CellPrintList.Add(CellPrint);
}
}
}
//读取单元格数据
for (int rowIndex = 0; rowIndex < rowsCount;
rowIndex++)
{
for (int columnsIndex =
0; columnsIndex < colsCount; columnsIndex++)
{
if
(dataGridView.Columns[columnsIndex].Visible)
{
DataGridViewCellPrint CellPrint = new
DataGridViewCellPrint();
CellPrint.FormattedValue
=
dataGridView.Rows[rowIndex].Cells[columnsIndex].FormattedValue.ToString();
if (includeColumnText)
CellPrint.RowIndex =
rowIndex + 1;//假如包括列标题则从行号1开始
else
CellPrint.RowIndex =
rowIndex;
CellPrint.ColumnIndex =
columnsIndex;
CellPrint.Font =
dataGridView.Rows[rowIndex].Cells[columnsIndex].Style.Font;
System.Drawing.Color TmpColor =
System.Drawing.Color.Empty;
if
(System.Drawing.Color.Empty !=
dataGridView.Rows[rowIndex].Cells[columnsIndex].Style.BackColor)
TmpColor =
dataGridView.Rows[rowIndex].Cells[columnsIndex].Style.BackColor;
else if (System.Drawing.Color.Empty !=
dataGridView.Rows[rowIndex].DefaultCellStyle.BackColor)
TmpColor =
dataGridView.Rows[rowIndex].DefaultCellStyle.BackColor;
else
TmpColor =
dataGridView.DefaultCellStyle.BackColor;
CellPrint.BackColor = TmpColor;
TmpColor =
System.Drawing.Color.Empty;
if
(System.Drawing.Color.Empty !=
dataGridView.Rows[rowIndex].Cells[columnsIndex].Style.ForeColor)
TmpColor =
dataGridView.Rows[rowIndex].Cells[columnsIndex].Style.ForeColor;
else if (System.Drawing.Color.Empty !=
dataGridView.Rows[rowIndex].DefaultCellStyle.ForeColor)
TmpColor =
dataGridView.Rows[rowIndex].DefaultCellStyle.ForeColor;
else
TmpColor =
dataGridView.DefaultCellStyle.ForeColor;
CellPrint.ForeColor = TmpColor;
CellPrint.Width =
dataGridView.Columns[columnsIndex].Width;
CellPrint.Height =
dataGridView.Rows[rowIndex].Height;
CellPrintList.Add(CellPrint);
}
}
}
}
catch { throw; }
}
private class DataGridViewCellPrint
{
private
string _FormattedValue = "";
private int _RowIndex =
-1;
private int _ColumnIndex = -1;
private
System.Drawing.Color _ForeColor = System.Drawing.Color.Black;
private System.Drawing.Color _BackColor =
System.Drawing.Color.White;
private int _Width =
100;
private int _Height = 23;
private
System.Drawing.Font _Font = new System.Drawing.Font("宋体", 9F,
System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point,
((byte)(134)));
/// <summary>
///
获取或设置单元格的字体。
/// </summary>
public
System.Drawing.Font Font
{
set { if (null !=
value) _Font = value; }
get { return _Font; }
}
/// <summary>
///
获取为显示进行格式化的单元格的值。
/// </summary>
public
string FormattedValue
{
set { _FormattedValue
= value; }
get { return _FormattedValue; }
}
/// <summary>
/// 获取或设置列的当前宽度
（以像素为单位）。默认值为 100。
/// </summary>
public int
Width
{
set { _Width = value;
}
get { return _Width; }
}
///
<summary>
/// 获取或设置列标题行的高度（以像素为单位）。默认值为 23。
/// </summary>
public int Height
{
set { _Height = value; }
get { return
_Height; }
}
/// <summary>
/// 获取或设置行号。
/// </summary>
public int
RowIndex
{
set { _RowIndex = value;
}
get { return _RowIndex; }
}
/// <summary>
/// 获取或设置列号。
///
</summary>
public int ColumnIndex
{
set { _ColumnIndex = value; }
get {
return _ColumnIndex; }
}
///
<summary>
/// 获取或设置前景色。
///
</summary>
public System.Drawing.Color
ForeColor
{
set { _ForeColor = value;
}
get { return _ForeColor; }
}
/// <summary>
/// 获取或设置背景色。
///
</summary>
public System.Drawing.Color
BackColor
{
set { _BackColor = value;
}
get { return _BackColor; }
}
}
}
}
接下来，在表示层添加DataGridView并且将数据库中的数据显示到DataGridView之中。在窗体中添加PrintDocument和PriintPreviewDialog控件，同时将PriintPreviewDialog属性中的Document属性设为PrintDocument的名称，否则不能实现打印。 再在窗体中添加一个按钮，实现打印预览功能。
代码实现，PrintDocument的默认事件是PrintPage事件，双击PrintDocument其中的代码如下：
private void PrintDocument_PrintPage(object sender,
System.Drawing.Printing.PrintPageEventArgs e)
{
Font
font = new Font("宋体", 12);
e.Graphics.DrawString("菜单信息", font,
Brushes.Red, 400, 20);
e.Graphics.DrawString("时间" +
DateTime.Now.ToLongDateString(), font, Brushes.Black, 20, 40);
int x = 10;
int y = 70;
PrintDataGridView.Print(dgvInfo2, true, e, ref x, ref
y); //注意：PrintDataGridView该类位于上面所写的业务逻辑层之中
}
打印预览按钮的单击事件中的代码如下：
private void btnPrint_Click(object sender, EventArgs e)
{
this.pPreview.ShowDialog();
}
至此，如果DataGridView中有数据的话，运行—点击"打印预览",应该可以实现打印预览功能！