winform datagridview打印

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Drawing.Printing;
using System.Text;
using System.Windows.Forms;
using System.Configuration;
using System.Globalization;

namespace WindowsFormsApplication2
{
    public partial class Statistics : Form
    {
        GridPrinter gridPrinter;
        private DataSet ds = new DataSet();
        private OleDbConnection conn = null;
        private OleDbDataAdapter da = null;
        private string DRIVER = ConfigurationManager.AppSettings["sqlconn"];//获取配置文件里自己设置的连接字符串;
        private DataTable dt = new DataTable();
        private string sql_select = "SELECT [b.id],[a.accname],[b.begindate],[b.enddate],[b.je],[b.rate],[b.Interest],[b.skrname],[b.jxbz],[b.remark],[b.afterjxje] FROM account a INNER JOIN jkmx b ON (a.AccID = b.jkrid)";//自已的SELECT语句

        public Statistics()
        {
            InitializeComponent();
        }

        private void Statistics_Load(object sender, EventArgs e)
        {
            string connection = ConfigurationManager.AppSettings["sqlconn"];//获取配置文件里自己设置的连接字符串
            conn = new OleDbConnection(DRIVER);

conn.Open();

            da = new OleDbDataAdapter(sql_select, conn);
            cmdbuilder = new OleDbCommandBuilder(da);
            da.Fill(dt);
            da.Fill(ds, "table");
            rowssum();

            try
            {
                da.Fill(ds, "dt");
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error: " + ex.ToString(), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            dataGridView.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 9, FontStyle.Bold, GraphicsUnit.Point);
            dataGridView.ColumnHeadersDefaultCellStyle.BackColor = SystemColors.ControlDark;
            dataGridView.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single;
            dataGridView.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            dataGridView.DefaultCellStyle.Font = new Font("Arial", 9, FontStyle.Regular, GraphicsUnit.Point);
            dataGridView.DefaultCellStyle.BackColor = Color.Empty;
            dataGridView.CellBorderStyle = DataGridViewCellBorderStyle.Single;
            dataGridView.GridColor = SystemColors.ControlDark;

this.dataGridView.DataSource = ds.Tables["table"].DefaultView;

            foreach (DataGridViewColumn col in dataGridView.Columns)
            {
                col.SortMode = DataGridViewColumnSortMode.NotSortable;
            }

            dataGridView.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;

            dataGridView.DataSource = dt;
            string strColName = "";
            for (int i = 1; i < dataGridView.Columns.Count; i++)
            {
                strColName = dataGridView.Columns[i].DataPropertyName;

                if (dt.Columns[strColName].DataType.ToString() == "System.Double")
                {
                    dataGridView.Columns[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                }
            }
            // adjust grid
            //dataGridView.Columns[dataGridView.Columns.Count - 1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
            dataGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
            dataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; //自动列宽enter;//列标题居中
            dataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

            conn.Close();
            dataGridView.DataSource = dt;
            tbtitle.Visible = false;
            tbtitle.Text = "";
        }

        private void btnPrint_Click(object sender, EventArgs e)
        {
            if (InitializePrinting())
                printDocument.Print();
        }

        private void printDocument_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
        {
            bool more = gridPrinter.DrawDataGridView(e.Graphics);
            if (more == true)
                e.HasMorePages = true;
        }

        private void btnPrintPreview_Click(object sender, EventArgs e)
        {
            if (InitializePrinting())
            {
                PrintPreviewDialog printPreviewDialog = new PrintPreviewDialog();
                printPreviewDialog.Document = printDocument;
                printPreviewDialog.ShowDialog();
            }
        }

        private bool InitializePrinting()
        {
            PrintDialog printDialog = new PrintDialog();
            if (printDialog.ShowDialog() != DialogResult.OK)
                return false;

            printDocument.DocumentName = "Data";
            printDocument.PrinterSettings = printDialog.PrinterSettings;
            printDocument.DefaultPageSettings = printDialog.PrinterSettings.DefaultPageSettings;
            printDocument.DefaultPageSettings.Margins = new Margins(40, 40, 40, 40);

            if (MessageBox.Show("Center on the page?", "Center Prompt", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                gridPrinter = new GridPrinter(dataGridView, printDocument, true, true, tbtitle.Text, new Font("Arial", 18, FontStyle.Bold, GraphicsUnit.Point), Color.Blue, true);
            else
                gridPrinter = new GridPrinter(dataGridView, printDocument, false, true, tbtitle.Text, new Font("Arial", 18, FontStyle.Bold, GraphicsUnit.Point), Color.Blue, true);

return true;
}

        private void rowssum()
        {
            double iQuantityAll = 0, iSumAll = 0, iAfterJx = 0;
            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (dt.Rows[i]["b.je"].ToString() == "")
                        dt.Rows[i]["b.je"] = 0;
                    if (dt.Rows[i]["b.Interest"].ToString() == "")
                        dt.Rows[i]["b.Interest"] = 0;
                    if (dt.Rows[i]["b.afterjxje"].ToString() == "")
                        dt.Rows[i]["b.afterjxje"] = 0;

                    iQuantityAll += Convert.ToInt32(dt.Rows[i]["b.je"]);
                    iSumAll += Convert.ToDouble(dt.Rows[i]["b.Interest"]);
                    iAfterJx += Convert.ToDouble(dt.Rows[i]["b.afterjxje"]);

                }
                Object[] obj = new Object[11];//一共多少列
                obj[1] = "合计:";
                obj[4] = iQuantityAll;//合计数量iQuantityAll变量
                obj[6] = iSumAll;//合计金额iSumAll变量
                obj[10] = iAfterJx;

                DataRow dr = dt.NewRow();//datatable中添加行
                dr.BeginEdit();
                dr.ItemArray = obj;
                dr.EndEdit();
                dt.Rows.Add(dr);
                dataGridView.AllowUserToAddRows = false;
                dataGridView.DataSource = dt;//绑定数据集
            }

}

        private void bttitle_Click(object sender, EventArgs e)
        {
            if (tbtitle.Visible != true)
            {
                tbtitle.Visible = true;
                bttitle.Text = "表头确认";
                tbtitle.Focus();
            }
            else
            {
                tbtitle.Visible = false;
                bttitle.Text = "表头录入";
            }
        }

}
}

//GridPrinter类

using System;
using System.Text;
using System.Collections;
using System.Collections.Generic;
using System.Drawing;
using System.Drawing.Printing;
using System.Data;
using System.Windows.Forms;

class GridPrinter
{
// the grid to print
private DataGridView dataGridView;

// the PrintDocument
private PrintDocument printDocument;

// center printout?
private bool centerOnPage;

// has a title?
private bool hasTitle;

// title
private string title;

// font
private Font titleFont;

// title color
private Color titleColor;

// use paging?
private bool paging;

// row printing
static int currentRow;

// page printing
static int pageNumber;

    // page width
    private int pageWidth;

    // page height
    private int pageHeight;

// left margin
private int leftMargin;

// top margin
private int topMargin;

// right margin
private int rightMargin;

// bottom margin
private int bottomMargin;

// y location placeholder
private float currentY;

    // grid sizes
    private float rowHeaderHeight;
    private List<float> rowsHeight;
    private List<float> columnsWidth;
    private float dataGridViewWidth;

    // column stop points
    private List<int[]> mColumnPoints;
    private List<float> mColumnPointsWidth;
    private int mColumnPoint;

    public GridPrinter(DataGridView objDataGridView, PrintDocument objPrintDocument, bool bCenterOnPage, bool bHasTitle, string sTitle, Font objTitleFont, Color objTitleColor, bool bPaging)
    {
        dataGridView = objDataGridView;
        printDocument = objPrintDocument;
        centerOnPage = bCenterOnPage;
        hasTitle = bHasTitle;
        title = sTitle;
        titleFont = objTitleFont;
        titleColor = objTitleColor;
        paging = bPaging;

pageNumber = 0;

rowsHeight = new List<float>();
columnsWidth = new List<float>();

mColumnPoints = new List<int[]>();
mColumnPointsWidth = new List<float>();

        if (!printDocument.DefaultPageSettings.Landscape)
        {
            pageWidth = printDocument.DefaultPageSettings.PaperSize.Width;
            pageHeight = printDocument.DefaultPageSettings.PaperSize.Height;
        }
        else
        {
            pageHeight = printDocument.DefaultPageSettings.PaperSize.Width;
            pageWidth = printDocument.DefaultPageSettings.PaperSize.Height;
        }

        leftMargin = printDocument.DefaultPageSettings.Margins.Left;
        topMargin = printDocument.DefaultPageSettings.Margins.Top;
        rightMargin = printDocument.DefaultPageSettings.Margins.Right;
        bottomMargin = printDocument.DefaultPageSettings.Margins.Bottom;

currentRow = 0;
}

    // calculate printing metrics
    private void Calculate(Graphics g)
    {
        if (pageNumber == 0)
        {
            SizeF tmpSize = new SizeF();
            Font tmpFont;
            float tmpWidth;

            dataGridViewWidth = 0;
            for (int i = 0; i < dataGridView.Columns.Count; i++)
            {
                tmpFont = dataGridView.ColumnHeadersDefaultCellStyle.Font;
                if (tmpFont == null)
                    tmpFont = dataGridView.DefaultCellStyle.Font;

                tmpSize = g.MeasureString(dataGridView.Columns[i].HeaderText, tmpFont);
                tmpWidth = tmpSize.Width;
                rowHeaderHeight = tmpSize.Height;

                for (int j = 0; j < dataGridView.Rows.Count; j++)
                {
                    tmpFont = dataGridView.Rows[j].DefaultCellStyle.Font;
                    if (tmpFont == null)
                        tmpFont = dataGridView.DefaultCellStyle.Font;

tmpSize = g.MeasureString("Anything", tmpFont);
rowsHeight.Add((float)(tmpSize.Height *1.5)) ;

                    tmpSize = g.MeasureString(dataGridView.Rows[j].Cells[i].EditedFormattedValue.ToString(), tmpFont);
                    if (tmpSize.Width > tmpWidth)
                        tmpWidth = tmpSize.Width;
                }
                if (dataGridView.Columns[i].Visible)
                    dataGridViewWidth += tmpWidth;
                columnsWidth.Add(tmpWidth);
            }

int k;

            int mStartPoint = 0;
            for (k = 0; k < dataGridView.Columns.Count; k++)
                if (dataGridView.Columns[k].Visible)
                {
                    mStartPoint = k;
                    break;
                }

            int mEndPoint = dataGridView.Columns.Count;
            for (k = dataGridView.Columns.Count - 1; k >= 0; k--)
                if (dataGridView.Columns[k].Visible)
                {
                    mEndPoint = k + 1;
                    break;
                }

            float mTempWidth = dataGridViewWidth;
            float mTempPrintArea = (float)pageWidth - (float)leftMargin - (float)rightMargin;

            if (dataGridViewWidth > mTempPrintArea)
            {
                mTempWidth = 0.0F;
                for (k = 0; k < dataGridView.Columns.Count; k++)
                {
                    if (dataGridView.Columns[k].Visible)
                    {
                        mTempWidth += columnsWidth[k];
                        if (mTempWidth > mTempPrintArea)
                        {
                            mTempWidth -= columnsWidth[k];
                            mColumnPoints.Add(new int[] { mStartPoint, mEndPoint });
                            mColumnPointsWidth.Add(mTempWidth);
                            mStartPoint = k;
                            mTempWidth = columnsWidth[k];
                        }
                    }
                    mEndPoint = k + 1;
                }
            }

            mColumnPoints.Add(new int[] { mStartPoint, mEndPoint });
            mColumnPointsWidth.Add(mTempWidth);
            mColumnPoint = 0;
        }
    }

    // header printing
    private void DrawHeader(Graphics g)
    {
        currentY = (float)topMargin;

        if (paging)
        {
            pageNumber++;
            string PageString = "Page " + pageNumber.ToString();

            StringFormat PageStringFormat = new StringFormat();
            PageStringFormat.Trimming = StringTrimming.Word;
            PageStringFormat.FormatFlags = StringFormatFlags.NoWrap | StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
            PageStringFormat.Alignment = StringAlignment.Far;

Font PageStringFont = new Font("Arial", 8, FontStyle.Regular, GraphicsUnit.Point);

RectangleF PageStringRectangle = new RectangleF((float)leftMargin, currentY, (float)pageWidth - (float)rightMargin - (float)leftMargin, g.MeasureString(PageString, PageStringFont).Height);

g.DrawString(PageString, PageStringFont, new SolidBrush(Color.Black), PageStringRectangle, PageStringFormat);

currentY += g.MeasureString(PageString, PageStringFont).Height;
}

        if (hasTitle)
        {
            StringFormat TitleFormat = new StringFormat();
            TitleFormat.Trimming = StringTrimming.Word;
            TitleFormat.FormatFlags = StringFormatFlags.NoWrap | StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
            if (centerOnPage)
                TitleFormat.Alignment = StringAlignment.Center;
            else
                TitleFormat.Alignment = StringAlignment.Near;

RectangleF TitleRectangle = new RectangleF((float)leftMargin, currentY, (float)pageWidth - (float)rightMargin - (float)leftMargin, g.MeasureString(title, titleFont).Height);

g.DrawString(title, titleFont, new SolidBrush(titleColor), TitleRectangle, TitleFormat);

currentY += g.MeasureString(title, titleFont).Height;
}

        float CurrentX = (float)leftMargin;
        if (centerOnPage)
            CurrentX += (((float)pageWidth - (float)rightMargin - (float)leftMargin) - mColumnPointsWidth[mColumnPoint]) / 2.0F;

        Color HeaderForeColor = dataGridView.ColumnHeadersDefaultCellStyle.ForeColor;
        if (HeaderForeColor.IsEmpty)
            HeaderForeColor = dataGridView.DefaultCellStyle.ForeColor;
        SolidBrush HeaderForeBrush = new SolidBrush(HeaderForeColor);

        Color HeaderBackColor = dataGridView.ColumnHeadersDefaultCellStyle.BackColor;
        if (HeaderBackColor.IsEmpty)
            HeaderBackColor = dataGridView.DefaultCellStyle.BackColor;
        SolidBrush HeaderBackBrush = new SolidBrush(HeaderBackColor);

Pen TheLinePen = new Pen(dataGridView.GridColor, 1);

        Font HeaderFont = dataGridView.ColumnHeadersDefaultCellStyle.Font;
        if (HeaderFont == null)
            HeaderFont = dataGridView.DefaultCellStyle.Font;

RectangleF HeaderBounds = new RectangleF(CurrentX, currentY, mColumnPointsWidth[mColumnPoint], rowHeaderHeight);
g.FillRectangle(HeaderBackBrush, HeaderBounds);

        StringFormat CellFormat = new StringFormat();
        CellFormat.Trimming = StringTrimming.Word;
        CellFormat.FormatFlags = StringFormatFlags.NoWrap | StringFormatFlags.LineLimit | StringFormatFlags.NoClip;

        RectangleF CellBounds;
        float ColumnWidth;
        for (int i = (int)mColumnPoints[mColumnPoint].GetValue(0); i < (int)mColumnPoints[mColumnPoint].GetValue(1); i++)
        {
            if (!dataGridView.Columns[i].Visible) continue;

ColumnWidth = columnsWidth[i];

            if (dataGridView.ColumnHeadersDefaultCellStyle.Alignment.ToString().Contains("Right"))
                CellFormat.Alignment = StringAlignment.Far;
            else if (dataGridView.ColumnHeadersDefaultCellStyle.Alignment.ToString().Contains("Center"))
                CellFormat.Alignment = StringAlignment.Center;
            else
                CellFormat.Alignment = StringAlignment.Near;

CellBounds = new RectangleF(CurrentX, currentY, ColumnWidth, rowHeaderHeight);

g.DrawString(dataGridView.Columns[i].HeaderText, HeaderFont, HeaderForeBrush, CellBounds, CellFormat);

if (dataGridView.RowHeadersBorderStyle != DataGridViewHeaderBorderStyle.None)
g.DrawRectangle(TheLinePen, CurrentX, currentY, ColumnWidth, rowHeaderHeight);

CurrentX += ColumnWidth;
}

currentY += rowHeaderHeight;
}

    // common row printing function
    private bool DrawRows(Graphics g)
    {
        Pen TheLinePen = new Pen(dataGridView.GridColor, 1);

        Font RowFont;
        Color RowForeColor;
        Color RowBackColor;
        SolidBrush RowForeBrush;
        SolidBrush RowBackBrush;
        SolidBrush RowAlternatingBackBrush;

        StringFormat CellFormat = new StringFormat();
        CellFormat.Trimming = StringTrimming.Word;
        CellFormat.FormatFlags = StringFormatFlags.NoWrap | StringFormatFlags.LineLimit;

        RectangleF RowBounds;
        float CurrentX;
        float ColumnWidth;
        while (currentRow < dataGridView.Rows.Count)
        {
            if (dataGridView.Rows[currentRow].Visible)
            {

                RowFont = dataGridView.Rows[currentRow].DefaultCellStyle.Font;
                if (RowFont == null)
                    RowFont = dataGridView.DefaultCellStyle.Font;

                RowForeColor = dataGridView.Rows[currentRow].DefaultCellStyle.ForeColor;
                if (RowForeColor.IsEmpty)
                    RowForeColor = dataGridView.DefaultCellStyle.ForeColor;
                RowForeBrush = new SolidBrush(RowForeColor);

                RowBackColor = dataGridView.Rows[currentRow].DefaultCellStyle.BackColor;
                if (RowBackColor.IsEmpty)
                {
                    RowBackBrush = new SolidBrush(dataGridView.DefaultCellStyle.BackColor);
                    RowAlternatingBackBrush = new SolidBrush(dataGridView.AlternatingRowsDefaultCellStyle.BackColor);
                }
                else
                {
                    RowBackBrush = new SolidBrush(RowBackColor);
                    RowAlternatingBackBrush = new SolidBrush(RowBackColor);
                }

                CurrentX = (float)leftMargin;
                if (centerOnPage)
                    CurrentX += (((float)pageWidth - (float)rightMargin - (float)leftMargin) - mColumnPointsWidth[mColumnPoint]) / 2.0F;

RowBounds = new RectangleF(CurrentX, currentY, mColumnPointsWidth[mColumnPoint], rowsHeight[currentRow]);

                if (currentRow % 2 == 0)
                    g.FillRectangle(RowBackBrush, RowBounds);
                else
                    g.FillRectangle(RowAlternatingBackBrush, RowBounds);

                for (int CurrentCell = (int)mColumnPoints[mColumnPoint].GetValue(0); CurrentCell < (int)mColumnPoints[mColumnPoint].GetValue(1); CurrentCell++)
                {
                    if (!dataGridView.Columns[CurrentCell].Visible) continue;

                    if (dataGridView.Columns[CurrentCell].DefaultCellStyle.Alignment.ToString().Contains("Right"))
                        CellFormat.Alignment = StringAlignment.Far;
                    else if (dataGridView.Columns[CurrentCell].DefaultCellStyle.Alignment.ToString().Contains("Center"))
                        CellFormat.Alignment = StringAlignment.Center;
                    else
                        CellFormat.Alignment = StringAlignment.Near;

                    ColumnWidth = columnsWidth[CurrentCell];
                    float currentY1 = currentY + (float)((rowsHeight[currentRow] - rowsHeight[currentRow]/1.5)/2);//将rowHeight扩大1.5倍后,表格中的内容Y坐标下调一半;
                    RectangleF CellBounds = new RectangleF(CurrentX, currentY1, ColumnWidth, rowsHeight[currentRow]);

                    g.DrawString(dataGridView.Rows[currentRow].Cells[CurrentCell].EditedFormattedValue.ToString(), RowFont, RowForeBrush, CellBounds, CellFormat);

                    if (dataGridView.CellBorderStyle != DataGridViewCellBorderStyle.None)
                        g.DrawRectangle(TheLinePen, CurrentX, currentY, ColumnWidth, rowsHeight[currentRow]);

                    CurrentX += ColumnWidth;
                }
                currentY += rowsHeight[currentRow];

                if ((int)currentY > (pageHeight - topMargin - bottomMargin))
                {
                    currentRow++;
                    return true;
                }
            }
            currentRow++;
        }

currentRow = 0;
mColumnPoint++;

        if (mColumnPoint == mColumnPoints.Count)
        {
            mColumnPoint = 0;
            return false;
        }
        else
            return true;
    }

    // the main grid printing method
    public bool DrawDataGridView(Graphics g)
    {
        try
        {
            Calculate(g);
            DrawHeader(g);
            bool bContinue = DrawRows(g);
            return bContinue;
        }
        catch (Exception ex)
        {
            MessageBox.Show("ERROR: " + ex.Message.ToString(), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
            return false;
        }
    }
}