PrintDGV

public class PrintDGV { public static StringFormat StrFormat; public static int TotalWidth; public static int RowPos; public static int PageNo; public static ArrayList ColumnLefts = new ArrayList(); public static ArrayList ColumnWidths = new ArrayList(); public static int CellHeight; public static System.Drawing.Printing.PrintDocument printDoc = new System.Drawing.Printing.PrintDocument(); public static string PrintTitle = ""; // Header of pages public static DataGridView dgv; public static IList<DataGridView> DGVlist; public static List<string> AvailableColumns = new List<string>(); public static List<string> TableTitle = new List<string>(); public static List<string> OldValue = new List<string>();//要合并列前一行列值集合。 public static List<List<string>> CoalitionColumn = new List<List<string>>(); public static int HeaderHeight = 0;//表头高度 public static int tmpTop = 0;//y坐标 public static int tmpLeft =0;//x坐标 public static int GRDFlag = -1;//记录前一个表 public static int GRDnumber = 0;//记录当前表 public static bool headState = true;//表头打印标志 public static string columnOldValue = ""; public delegate void delegatePring(PrintPageEventArgs e); public static delegatePring printTableTitle; //我们就调用这个方法分别按规则传参； public static void Print_DataGridView(IList<DataGridView> dgv1, List<string> tableTitle, delegatePring vt, List<List<string>> coalitionColumn) { PrintPreviewDialog ppvw; try { DGVlist = dgv1; TableTitle = tableTitle; printTableTitle = vt; CoalitionColumn = coalitionColumn; ppvw = new PrintPreviewDialog(); ppvw.Width = Screen.PrimaryScreen.Bounds.Width; ppvw.Height = Screen.PrimaryScreen.Bounds.Height; ppvw.Document = printDoc; // Showing the Print Preview Page printDoc.BeginPrint += new System.Drawing.Printing.PrintEventHandler(PrintDoc_BeginPrint); printDoc.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(PrintDoc_PrintPage); if (ppvw.ShowDialog() != DialogResult.OK) { printDoc.BeginPrint -= new System.Drawing.Printing.PrintEventHandler(PrintDoc_BeginPrint); printDoc.PrintPage -= new System.Drawing.Printing.PrintPageEventHandler(PrintDoc_PrintPage); return; } // Printing the Documnet headState = true; printDoc.Print(); printDoc.BeginPrint -= new System.Drawing.Printing.PrintEventHandler(PrintDoc_BeginPrint); printDoc.PrintPage -= new System.Drawing.Printing.PrintPageEventHandler(PrintDoc_PrintPage); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { } } private static void PrintDoc_BeginPrint(object sender, System.Drawing.Printing.PrintEventArgs e) { StrFormat = new StringFormat(); StrFormat.Alignment = StringAlignment.Center; StrFormat.LineAlignment = StringAlignment.Center; StrFormat.Trimming = StringTrimming.EllipsisCharacter; GRDFlag = -1; GRDnumber = 0; dgv = DGVlist[0]; CellHeight = dgv.ColumnHeadersHeight; PageNo = 1; RowPos = 0; } private static void PrintDoc_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e) { tmpTop = e.MarginBounds.Top;//当前Y轴坐标 tmpLeft = e.MarginBounds.Left-100;//当前X轴坐标 if (headState == true) { if (printTableTitle != null) { printTableTitle(e); } headState = false; } try { printBody(e); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } #region printBody private static void printBody(System.Drawing.Printing.PrintPageEventArgs e) { AvAndToInit(); newTableInit(e); if (RowPos == 0 && tmpTop == e.MarginBounds.Top) { tmpTop += 50; PrintTitle = TableTitle[GRDnumber]; printTitle(e); tmpTop -= 20; } printTableHead(e); if (GRDFlag != GRDnumber) { PrintTitle = TableTitle[GRDnumber]; printTitle(e); GRDFlag = GRDnumber; int n = CoalitionColumn[GRDnumber].Count; if (n > 0) { OldValue.Clear(); foreach (string str in CoalitionColumn[GRDnumber]) { OldValue.Add(""); } } } bool br = drawRow(e); if (br == false) { return; } if (tmpTop + CellHeight * 5 >= e.MarginBounds.Height + e.MarginBounds.Top) { DrawFooter(e); PageNo++; e.HasMorePages = true; return; } GRDnumber++; if (GRDnumber == DGVlist.Count) { headState = true; e.HasMorePages = false; DrawFooter(e); return; } dgv = DGVlist[GRDnumber]; tmpTop += CellHeight * 3; tmpLeft = e.MarginBounds.Left; printBody(e); } #endregion #region private static bool drawRow(PrintPageEventArgs e) { bool br = true; while (RowPos <= dgv.Rows.Count - 1) { DataGridViewRow GridRow = dgv.Rows[RowPos]; CellHeight = GridRow.Height; if (tmpTop + CellHeight >= e.MarginBounds.Height + e.MarginBounds.Top) { DrawFooter(e); PageNo++; e.HasMorePages = true; br = false; return br; } else { int i = 0; //int p = 0; foreach (DataGridViewCell Cel in GridRow.Cells) { if (!Cel.OwningColumn.Visible) continue; //if (p == 0) bool coalitionState = false; foreach (string temp in CoalitionColumn[GRDnumber]) { if (temp == Cel.OwningColumn.DataPropertyName) { coalitionState = true; break; } } if (coalitionState == true) { if (RowPos + 1 > dgv.Rows.Count - 1)//最后一行 { e.Graphics.DrawLine(Pens.Black, (int)ColumnLefts[i], (float)tmpTop + CellHeight, (int)ColumnLefts[i] + (int)ColumnWidths[i], (float)tmpTop + CellHeight); } if (tmpTop + CellHeight * 2 >= e.MarginBounds.Height + e.MarginBounds.Top)//一页结束 { e.Graphics.DrawLine(Pens.Black, (int)ColumnLefts[i], (float)tmpTop + CellHeight, (int)ColumnLefts[i] + (int)ColumnWidths[i], (float)tmpTop + CellHeight); } if (Cel.Value.ToString().Trim() == OldValue[i])//columnOldValue) { e.Graphics.DrawLine(Pens.Black, (int)ColumnLefts[i], (float)tmpTop, (int)ColumnLefts[i], (float)tmpTop + CellHeight); e.Graphics.DrawLine(Pens.Black, (int)ColumnLefts[i] + (int)ColumnWidths[i], (float)tmpTop, (int)ColumnLefts[i] + (int)ColumnWidths[i], (float)tmpTop + CellHeight); i++; continue; } else { e.Graphics.DrawString(Cel.Value.ToString(), Cel.InheritedStyle.Font, new SolidBrush(Cel.InheritedStyle.ForeColor), new RectangleF((int)ColumnLefts[i], (float)tmpTop, (int)ColumnWidths[i], (float)CellHeight), StrFormat); e.Graphics.DrawLine(Pens.Black, (int)ColumnLefts[i], (float)tmpTop, (int)ColumnLefts[i] + (int)ColumnWidths[i], (float)tmpTop); e.Graphics.DrawLine(Pens.Black, (int)ColumnLefts[i], (float)tmpTop, (int)ColumnLefts[i], (float)tmpTop + CellHeight); e.Graphics.DrawLine(Pens.Black, (int)ColumnLefts[i] + (int)ColumnWidths[i], (float)tmpTop, (int)ColumnLefts[i] + (int)ColumnWidths[i], (float)tmpTop + CellHeight); OldValue[i] = Cel.Value.ToString().Trim();//columnOldValue = Cel.Value.ToString().Trim(); i++; continue; } } e.Graphics.DrawString(Cel.Value.ToString(), Cel.InheritedStyle.Font, new SolidBrush(Cel.InheritedStyle.ForeColor), new RectangleF((int)ColumnLefts[i], (float)tmpTop, (int)ColumnWidths[i], (float)CellHeight), StrFormat); e.Graphics.DrawRectangle(Pens.Black, new Rectangle((int)ColumnLefts[i], tmpTop, (int)ColumnWidths[i], CellHeight)); i++; } tmpTop += CellHeight; } if (RowPos + 1 > dgv.Rows.Count - 1) { RowPos = 0; break; } else { RowPos++; } } return br; } #endregion #region private static void AvAndToInit() { AvailableColumns.Clear(); foreach (DataGridViewColumn c in dgv.Columns) { if (!c.Visible) continue; AvailableColumns.Add(c.HeaderText); } TotalWidth = 0; foreach (DataGridViewColumn GridCol in dgv.Columns) { if (!GridCol.Visible) continue; TotalWidth += GridCol.Width; } } #endregion #region private static void printTitle(PrintPageEventArgs e) { e.Graphics.DrawString(PrintTitle, new Font("宋体", 16, FontStyle.Bold), Brushes.Black, e.MarginBounds.Left + (e.MarginBounds.Width - e.Graphics.MeasureString(PrintTitle, new Font("宋体", 16), e.MarginBounds.Width).Width) / 2, tmpTop - e.Graphics.MeasureString(PrintTitle, new Font(dgv.Font, FontStyle.Bold), e.MarginBounds.Width).Height - 50); } #endregion #region private static void newTableInit(System.Drawing.Printing.PrintPageEventArgs e) { ColumnLefts.Clear(); ColumnWidths.Clear(); foreach (DataGridViewColumn GridCol in dgv.Columns) { int tmpWidth; if (!GridCol.Visible) continue; tmpWidth = (int)(Math.Floor((double)((double)GridCol.Width * ((double)e.MarginBounds.Width / (double)TotalWidth))))+15; HeaderHeight = (int)(e.Graphics.MeasureString(GridCol.HeaderText, GridCol.InheritedStyle.Font, tmpWidth).Height) + 11; // Save width & height of headres and ColumnType ColumnLefts.Add(tmpLeft); ColumnWidths.Add(tmpWidth); tmpLeft += tmpWidth; } } #endregion #region private static void printTableHead(System.Drawing.Printing.PrintPageEventArgs e) { String s = DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToShortTimeString(); e.Graphics.DrawString(s, dgv.Font, Brushes.Black, e.MarginBounds.Left + (e.MarginBounds.Width - e.Graphics.MeasureString(s, dgv.Font, e.MarginBounds.Width).Width), e.MarginBounds.Top + e.MarginBounds.Height + e.Graphics.MeasureString(s, dgv.Font, e.MarginBounds.Width).Height + 10); int i = 0; foreach (DataGridViewColumn GridCol in dgv.Columns) { if (!GridCol.Visible) continue; e.Graphics.FillRectangle(new SolidBrush(Color.LightGray), new Rectangle((int)ColumnLefts[i], tmpTop, (int)ColumnWidths[i], HeaderHeight)); e.Graphics.DrawRectangle(Pens.Black, new Rectangle((int)ColumnLefts[i], tmpTop, (int)ColumnWidths[i], HeaderHeight)); e.Graphics.DrawString(GridCol.HeaderText, GridCol.InheritedStyle.Font, new SolidBrush(GridCol.InheritedStyle.ForeColor), new RectangleF((int)ColumnLefts[i], tmpTop, (int)ColumnWidths[i], HeaderHeight), StrFormat); i++; } tmpTop += HeaderHeight; } #endregion #region private static void DrawFooter(System.Drawing.Printing.PrintPageEventArgs e) { string PageNum = " 第 " + PageNo.ToString() + " 页"; e.Graphics.DrawString(PageNum, dgv.Font, Brushes.Black, e.MarginBounds.Left + (e.MarginBounds.Width - e.Graphics.MeasureString(PageNum, dgv.Font, e.MarginBounds.Width).Width) / 2, e.MarginBounds.Top + e.MarginBounds.Height + 31); } #endregion }

测试:

void PrintButton_Click(object sender, EventArgs e) { IList<DataGridView> dgvList = new List<DataGridView>(); dgvList.Add(base.ShowListDataGridView);//表1 //dgvList.Add(dataGridView2);//表2 //dgvList.Add(dataGridView3);//表3 //dgvList.Add(dataGridView4);//表4 //dgvList.Add(dataGridView5);//表5 List<string> TableTitle = new List<string>(); TableTitle.Add("株洲市815油库");//表1 //TableTitle.Add(); //TableTitle.Add("装置低频轮次设置");//表2 //TableTitle.Add("装置低压轮次设置");//表3 //TableTitle.Add("装置低频减载报告");//表4 //TableTitle.Add("装置低压减载报告");//表5 ODMS.Common.PrintDGV.delegatePring vt = new ODMS.Common.PrintDGV.delegatePring(printTitle); List<List<string>> columnList = new List<List<string>>(); columnList.Add(new List<string>());//表1 //columnList.Add(new List<string>());//表2 //columnList.Add(new List<string>());//表3 //List<string> list4 = new List<string>(); //list4.Add("equipdpname");//要合并的列名 //list4.Add("enetdpname"); //list4.Add("frequency"); //list4.Add("time"); //columnList.Add(list4);//表4 //List<string> list5 = new List<string>(); //list5.Add("equipDYname"); //list5.Add("enetDYname"); //list5.Add("Vn"); //list5.Add("Time"); //columnList.Add(list5);//表5 //这里能： ODMS.Common.PrintDGV.Print_DataGridView(dgvList, TableTitle, vt, columnList); } // 这个是表头显示方法（） public static void printTitle(PrintPageEventArgs e) { string str = "湖 南 石 油 分 公 司 油 罐 动 态 保 管 帐"; Font font = new Font("宋体", 20, FontStyle.Bold); e.Graphics.DrawString(str, font, Brushes.Black, e.MarginBounds.Left + (e.MarginBounds.Width - e.Graphics.MeasureString(str, font, e.MarginBounds.Width).Width) / 2 - 30, ODMS.Common.PrintDGV.tmpTop - e.Graphics.MeasureString(str, font, e.MarginBounds.Width).Height); ODMS.Common.PrintDGV.tmpTop += 80; }