SANHOPE.mes.wcf/DK.Basics/BaseControls/ExportExcel/MES_Common.cs

using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Drawing;
using System.Drawing.Printing;
using System.IO;
using System.Threading;
using System.Windows.Forms;
using Dongke.IBOSS.Framework.Controls;
/*using iTextSharp.text;
using iTextSharp.text.pdf;*/
using Microsoft.VisualBasic;
using Microsoft.VisualBasic.CompilerServices;
using Microsoft.VisualBasic.FileIO;
using NPOI.XSSF.UserModel;
using NPOI.SS.UserModel;
using Curtain.Log;

namespace Dongke.IBOSS.PRD.Framework.Controls
{
	public class MES_Common
	{
		/*	private class testevent : IPdfPageEvent
			{
				private PdfContentByte cb;

				private PdfTemplate template;

				public void OnChapter(PdfWriter writer, Document document, float paragraphPosition, Paragraph title)
				{
				}

				public void OnChapterEnd(PdfWriter writer, Document document, float paragraphPosition)
				{
				}

				public void OnCloseDocument(PdfWriter writer, Document document)
				{
					((PdfContentByte)template).BeginText();
					((PdfContentByte)template).SetFontAndSize(BaseFont.CreateFont(), 10f);
					((PdfContentByte)template).SetTextMatrix(0f, 0f);
					((PdfContentByte)template).ShowText(Conversions.ToString(checked(writer.PageNumber - 1)));
					((PdfContentByte)template).EndText();
				}

				public void OnEndPage(PdfWriter writer, Document document)
				{
					string text = " - " + writer.PageNumber;
					BaseFont val = BaseFont.CreateFont();
					float widthPoint = val.GetWidthPoint("1", 10f);
					Rectangle pageSize = document.PageSize;
					cb.SetRGBColorFill(100, 100, 100);
					cb.BeginText();
					cb.SetFontAndSize(val, 10f);
					cb.SetTextMatrix(document.LeftMargin + (document.PageSize.Width - document.RightMargin - document.LeftMargin) / 2f, pageSize.GetBottom(document.BottomMargin) - document.BottomMargin / 3f);
					cb.ShowText(text);
					cb.EndText();
					cb.AddTemplate(template, document.LeftMargin - widthPoint + (document.PageSize.Width - document.RightMargin - document.LeftMargin) / 2f, pageSize.GetBottom(document.BottomMargin) - document.BottomMargin / 3f);
				}

				public void OnGenericTag(PdfWriter writer, Document document, Rectangle rect, string text)
				{
				}

				public void OnOpenDocument(PdfWriter writer, Document document)
				{
					cb = writer.DirectContent;
					template = cb.CreateTemplate(50f, 50f);
				}

				public void OnParagraph(PdfWriter writer, Document document, float paragraphPosition)
				{
				}

				public void OnParagraphEnd(PdfWriter writer, Document document, float paragraphPosition)
				{
				}

				public void OnSection(PdfWriter writer, Document document, float paragraphPosition, int depth, Paragraph title)
				{
				}

				public void OnSectionEnd(PdfWriter writer, Document document, float paragraphPosition)
				{
				}

				public void OnStartPage(PdfWriter writer, Document document)
				{
				}
			}
		*/
		private static MES_Common _instance;

		/*private Document mydoc;

		private PdfWriter mywriter;*/

		private float _paperwidth;

		private float _paperheight;

		private bool _paperlandscape;

		private Margins _margin;

		private float myratio;

		private bool _repeatheader;

		private bool disposedValue;

		public static MES_Common Instance
		{
			get
			{
				if (_instance == null)
				{
					_instance = new MES_Common();
				}
				return _instance;
			}
		}

		public bool RepeatHeader
		{
			get
			{
				return _repeatheader;
			}
			set
			{
				_repeatheader = value;
			}
		}

		public Margins PaperMargin
		{
			get
			{
				return _margin;
			}
			set
			{
				_margin = value;
			}
		}

		public float PaperWidth
		{
			get
			{
				return _paperwidth;
			}
			set
			{
				_paperwidth = value;
			}
		}

		public float PaperHeight
		{
			get
			{
				return _paperheight;
			}
			set
			{
				if (value > 0f)
				{
					_paperheight = value;
				}
			}
		}

		public bool PaperLandScape
		{
			get
			{
				return _paperlandscape;
			}
			set
			{
				_paperlandscape = value;
			}
		}

		private MES_Common()
		{
		}

		public bool ExportExcel(DataGridView mydgv, TreeView columnheadertree, Font titlefont, string title, string FileName, Font tableheaderfont, string Tableheader, Font tablefooterfont, string TableFooter, string sheetname, bool isopenfile, bool isshowprogress, bool isTopNodeFill)
		{
			checked
			{
				bool result;
				if (mydgv == null)
				{
					result = false;
				}
				else
				{
					if (titlefont == null)
					{
						titlefont = new Font("黑体", 18f, FontStyle.Bold);
					}
					if (tableheaderfont == null)
					{
						tableheaderfont = new Font("宋体", 12f);
					}
					if (tablefooterfont == null)
					{
						tablefooterfont = new Font("宋体", 12f);
					}
					progressexcel progressexcel = null;
					Module1.G_CancelExportDGVToExcel = false;
					if (isshowprogress)
					{
						progressexcel = new progressexcel();
						progressexcel.TopMost = true;
						progressexcel.Visible = true;
					}
					Ruler ruler = new Ruler();
					try
					{
						if (isshowprogress)
						{
							progressexcel.Label1.Text = "正在做导出前的准备，请稍侯……";
							progressexcel.ProgressBar1.Value = 0;
							Application.DoEvents();
						}
						int columnCount = mydgv.ColumnCount;
						int[] array = new int[columnCount - 1 + 1];
						int[] array2 = new int[columnCount - 1 + 1];
						int num = 0;
						int num2 = 0;
						int num3 = columnCount - 1;
						for (int i = num2; i <= num3; i++)
						{
							array[i] = i;
							array2[i] = mydgv.Columns[i].DisplayIndex;
							if (mydgv.Columns[i].Visible)
							{
								num++;
							}
						}
						if (num <= 0)
						{
							if (isshowprogress)
							{
								progressexcel.Close();
								progressexcel.Dispose();
							}
							result = true;
						}
						else
						{
							Array.Sort(array2, array);
							int[] array3 = new int[num - 1 + 1];
							int num4 = 0;
							int num5 = 0;
							int num6 = columnCount - 1;
							for (int j = num5; j <= num6; j++)
							{
								if (mydgv.Columns[array[j]].Visible)
								{
									array3[num4] = array[j];
									num4++;
								}
							}
							DGVtoExcel.w_ZDYcolors = 8;
							int endcol = num - 1;
							SaveFileDialog saveFileDialog = new SaveFileDialog();
							saveFileDialog.Title = "请选择要导出Excel文件的路径和文件名";
							saveFileDialog.AddExtension = true;
							saveFileDialog.OverwritePrompt = false;
							//saveFileDialog.DefaultExt = "xls";
							//saveFileDialog.Filter = "97-2003 Excel文件(*.xls)|*.xls|所有文件(*.*)|*.*";
							saveFileDialog.DefaultExt = "xlsx";
							saveFileDialog.Filter = "Excel文件(*.xlsx)|*.xlsx|所有文件(*.*)|*.*";
							saveFileDialog.FileName = FileName;
							if (isshowprogress)
							{
								progressexcel.Visible = false;
							}
							if (saveFileDialog.ShowDialog() == DialogResult.Cancel)
							{
								if (isshowprogress)
								{
									progressexcel.Close();
									progressexcel.Dispose();
								}
								saveFileDialog.Dispose();
								return false;
							}
							FileName = saveFileDialog.FileName;
							saveFileDialog.Dispose();
							if (isshowprogress)
							{
								progressexcel.Visible = true;
							}
							DGVtoExcel.w_font = null;
							DGVtoExcel.w_ifont = null;
							DGVtoExcel.w_Cellstyle = null;
							DGVtoExcel.w_iCellstyle = null;
							DGVtoExcel.w_color = null;
							if (MyProject.Computer.FileSystem.FileExists(FileName))
							{
								if (isshowprogress)
								{
									progressexcel.Visible = false;
								}
								switch (Interaction.MsgBox("选择的文件【" + FileName + "】已经存在，您确定要覆盖原来的文件吗？注意：覆盖原文件后，原文件中的全部数据都将丢失！\r\n单击[是]按钮，将覆盖原文件，单击[否]按钮，导出数据将以追加的形式添加到文件中，单击[取消]按钮将取消导出", MsgBoxStyle.YesNoCancel | MsgBoxStyle.Question, "提示信息"))
								{
									case MsgBoxResult.Cancel:
										if (isshowprogress)
										{
											progressexcel.Close();
											progressexcel.Dispose();
										}
										return false;
									case MsgBoxResult.Yes:
										try
										{
											MyProject.Computer.FileSystem.DeleteFile(FileName, UIOption.OnlyErrorDialogs, RecycleOption.SendToRecycleBin);
										}
										catch (Exception projectError)
										{
											Logger.Error(projectError, "projectError");
											MessageBox.Show(projectError.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
											ProjectData.SetProjectError(projectError);
											Interaction.MsgBox("数据导出失败，原因是文件【" + FileName + "】无法覆盖，可能该文件正在使用中，请关闭该文件后再试", MsgBoxStyle.Exclamation, "提示信息");
											if (isshowprogress)
											{
												progressexcel.Close();
												progressexcel.Dispose();
											}
											result = false;
											ProjectData.ClearProjectError();
											return result;
										}
										break;
								}
								if (isshowprogress)
								{
									progressexcel.Visible = true;
								}
							}
							XSSFWorkbook hSSFWorkbook;
							if (MyProject.Computer.FileSystem.FileExists(FileName))
							{
								FileStream fileStream;
								try
								{
									fileStream = new FileStream(FileName, FileMode.Open, FileAccess.Read);
								}
								catch (Exception ex)
								{
									Logger.Error(ex, "ex");
									MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
									ProjectData.SetProjectError(ex);
									Exception ex2 = ex;
									if (isshowprogress)
									{
										progressexcel.Close();
										progressexcel.Dispose();
									}
									Interaction.MsgBox("数据导出失败，原因是打开Excel文件〖" + FileName + "〗失败，" + ex2.Message, MsgBoxStyle.Exclamation, "提示信息");
									fileStream = null;
									result = false;
									ProjectData.ClearProjectError();
									return result;
								}
								try
								{
									hSSFWorkbook = new XSSFWorkbook(fileStream);
								}
								catch (Exception projectError2)
								{
									Logger.Error(projectError2, "projectError2");
									MessageBox.Show(projectError2.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
									ProjectData.SetProjectError(projectError2);
									if (isshowprogress)
									{
										progressexcel.Close();
										progressexcel.Dispose();
									}
									fileStream.Dispose();
									fileStream = null;
									Interaction.MsgBox("数据导出失败，原因是打开Excel文件〖" + FileName + "〗失败，可能不是有效的Office97-2003 Excel文件格式，因此无法向该文件中追加导出的数据", MsgBoxStyle.Exclamation, "提示信息");
									hSSFWorkbook = null;
									result = false;
									ProjectData.ClearProjectError();
									return result;
								}
							}
							else
							{
								hSSFWorkbook = new XSSFWorkbook();
							}
							string excelNewSheetName = DGVtoExcel.GetExcelNewSheetName(hSSFWorkbook, sheetname);
							XSSFSheet hSSFSheet = (XSSFSheet)hSSFWorkbook.CreateSheet(excelNewSheetName);
							int num7;
							if (Operators.CompareString(title, "", TextCompare: false) == 0)
							{
								num7 = 0;
							}
							else
							{
								DGVtoExcel.SetTitle(hSSFWorkbook, hSSFSheet, 0, 0, 0, endcol, title, titlefont);
								num7 = 1;
							}
							if (Operators.CompareString(Tableheader, "", TextCompare: false) != 0)
							{
								DGVtoExcel.SetTitle(hSSFWorkbook, hSSFSheet, num7, num7, 0, endcol, Tableheader, tableheaderfont);
								num7++;
							}
							DGVtoExcel.w_gridcolor = DGVtoExcel.GetXLColour(hSSFWorkbook, mydgv.GridColor);
							if (mydgv.ColumnHeadersVisible)
							{
								if (columnheadertree == null)
								{
									IRow row = hSSFSheet.CreateRow(num7);
									row.HeightInPoints = Module1.ConvertMmToInch(ruler.ConvertToMM(mydgv.ColumnHeadersHeight, isX: false)) * 72f;
									int num8 = 0;
									int num9 = num - 1;
									for (int k = num8; k <= num9; k++)
									{
										DGVtoExcel.SetCellValue(hSSFSheet, num7, k, mydgv.Columns[array3[k]].HeaderText);
										Font dGVHeaderFont = Module1.GetDGVHeaderFont(mydgv.Columns[array3[k]]);
										Color dGVHeaderBackColor = Module1.GetDGVHeaderBackColor(mydgv.Columns[array3[k]]);
										Color dGVHeaderForeColor = Module1.GetDGVHeaderForeColor(mydgv.Columns[array3[k]]);
										DGVtoExcel.SetCellStyle(hSSFWorkbook, hSSFSheet, num7, k, leftborder: true, rightborder: true, topborder: true, bottomborder: true, StringAlignment.Center, StringAlignment.Center, dGVHeaderFont, dGVHeaderBackColor, dGVHeaderForeColor, needwrap: false);
									}
								}
								else
								{
									mytree mytree = new mytree(columnheadertree, mydgv);
									int leves = mytree.GetLeves();
									int num10 = 1;
									int num11 = leves;
									for (int l = num10; l <= num11; l++)
									{
										IRow row2 = hSSFSheet.CreateRow(num7 + l - 1);
										row2.HeightInPoints = Module1.ConvertMmToInch(ruler.ConvertToMM((float)((double)mydgv.ColumnHeadersHeight / (double)leves), isX: false)) * 72f;
									}
									int num12 = 1;
									int num13 = leves;
									bool flag = true;
									for (int m = num12; m <= num13; m++)
									{
										if (m != 1)
										{
											num7++;
										}
										int num14 = 0;
										int num15 = num - 1;
										for (int n = num14; n <= num15; n++)
										{
											string nodeText = mytree.GetNodeText(array3[n], m);
											int cellHeightLevels = mytree.GetCellHeightLevels(array3[n], m, isTopNodeFill, out flag);
											int cellWidthCols = mytree.GetCellWidthCols(array3[n], m);
											if (unchecked(cellHeightLevels == 0 || cellWidthCols == 0))
											{
												continue;
											}
											Font font = mytree.GetNodeFont(array3[n], m);
											if (font == null)
											{
												font = Module1.GetDGVHeaderFont(mydgv.Columns[array3[n]]);
											}
											Color forcolor = mytree.GetNodeForeColor(array3[n], m);
											if (forcolor.IsEmpty)
											{
												forcolor = Module1.GetDGVHeaderForeColor(mydgv.Columns[array3[n]]);
											}
											Color bkcolor = mytree.GetNodeBackColor(array3[n], m);
											if (bkcolor.IsEmpty)
											{
												bkcolor = Module1.GetDGVHeaderBackColor(mydgv.Columns[array3[n]]);
											}
											if (unchecked(cellWidthCols == 1 && cellHeightLevels == 1))
											{
												int num16 = num7;
												if (!flag)
												{
													num16++;
												}
												DGVtoExcel.SetCellValue(hSSFSheet, num16, n, nodeText);
												DGVtoExcel.SetCellStyle(hSSFWorkbook, hSSFSheet, num16, n, leftborder: true, rightborder: true, topborder: true, bottomborder: true, StringAlignment.Center, StringAlignment.Center, font, bkcolor, forcolor, needwrap: false);
												continue;
											}
											DGVtoExcel.SetCellValue(hSSFSheet, num7, n, nodeText);
											DGVtoExcel.SetCellStyle(hSSFWorkbook, hSSFSheet, num7, n, leftborder: true, rightborder: true, topborder: true, bottomborder: true, StringAlignment.Center, StringAlignment.Center, font, bkcolor, forcolor, needwrap: false);
											int num17 = num7;
											int num18 = num7 + cellHeightLevels - 1;
											for (int num19 = num17; num19 <= num18; num19++)
											{
												int num20 = n;
												int num21 = n + cellWidthCols - 1;
												for (int num22 = num20; num22 <= num21; num22++)
												{
													if (unchecked(num19 != num7 || num22 != n))
													{
														DGVtoExcel.SetCellBorder(hSSFWorkbook, hSSFSheet, num19, num22, leftborder: true, rightborder: true, topborder: true, bottomborder: true);
													}
												}
											}
											DGVtoExcel.SetMergeCell(hSSFSheet, num7, n, num7 + cellHeightLevels - 1, n + cellWidthCols - 1);
										}
									}
									mytree.Dispose();
								}
								num7++;
							}
							int num23 = 1;
							int num24 = 0;
							int num25 = 0;
							int num26 = 0;
							int num27 = 0;
							int num28 = 1;
							int num29 = 0;
							int num30 = mydgv.RowCount - 1;
							for (int num31 = num29; num31 <= num30; num31++)
							{
								IRow row3 = hSSFSheet.CreateRow(num7 + num31);
								row3.HeightInPoints = Module1.ConvertMmToInch(ruler.ConvertToMM(mydgv.Rows[num31].Height, isX: false)) * 72f;
								if (!mydgv.Rows[num31].Visible)
								{
									row3.ZeroHeight = true;
								}
								if (num31 + num7 == 1048575)
								{
									break;
								}
							}
							int num32 = 0;
							int num33 = 0;
							if (isshowprogress)
							{
								progressexcel.ProgressBar1.Maximum = mydgv.RowCount;
							}
							int num34 = 0;
							int num35 = mydgv.RowCount - 1;
							for (int num36 = num34; num36 <= num35; num36++)
							{
								bool flag2 = false;
								if (isshowprogress)
								{
									progressexcel.Label1.Text = "正在导出第〖" + Conversions.ToString(num36 + 1) + "〗条记录，共〖" + Conversions.ToString(mydgv.RowCount) + "〗条记录，已完成〖" + Strings.Format((double)(num36 + 1) / (double)mydgv.RowCount, "###.##%") + "〗";
									progressexcel.ProgressBar1.Value = num36 + 1;
									Application.DoEvents();
								}
								if (Module1.G_CancelExportDGVToExcel)
								{
									break;
								}
								int num37 = 0;
								int num38 = num - 1;
								for (num4 = num37; num4 <= num38; num4++)
								{
									int num39;
									if (mydgv.Columns[array3[num4]].ValueType == null)
									{
										num39 = 0;
									}
									else
									{
										switch (Strings.Left(mydgv.Columns[array3[num4]].ValueType.Name.ToUpper(), 3))
										{
											case "STR":
												num39 = 0;
												break;
											case "INT":
											case "DEC":
												num39 = 1;
												flag2 = false;
												break;
											case "DAT":
												num39 = 2;
												break;
											case "BOO":
												num39 = 3;
												flag2 = false;
												break;
											default:
												num39 = 0;
												break;
										}
									}
									num28 = 1;
									num23 = 1;
									num26 = 0;
									num24 = 0;
									num27 = 0;
									num26 = 0;
									num24 = 0;
									num25 = 0;
									string text = Conversions.ToString(mydgv.Rows[num36].Cells[array3[num4]].Tag);
									switch (text)
									{
										default:
											{
												float mywidth = 0f;
												float num40 = 9f;
												int firstcolumn = 0;
												int firstrow = 0;
												int firstc = 0;
												int firstr = 0;
												switch (text)
												{
													default:
														num28 = 1;
														num23 = 1;
														break;
													case "合并":
													case "左上合并":
													case "左下合并":
													case "右上合并":
													case "右下合并":
													case "上边合并":
													case "下边合并":
													case "左边合并":
													case "右边合并":
														mymerge.GetHVMergeWidthAndHeight(mydgv, array3[num4], num36, ref mywidth, ref num40, ref num27, ref num26, ref num24, ref num25, ref firstcolumn, ref firstrow, ref firstc, ref firstr);
														num28 = num26 + num27 + 1;
														num23 = num24 + num25 + 1;
														break;
													case "水平合并":
													case "#水平合并#":
													case "左合并":
													case "右合并":
														mywidth = (int)Math.Round(mymerge.GetHMergeWidth(mydgv, array3[num4], num36, ref num28, ref num26, ref num27, ref firstcolumn, ref firstc, iscancheckheight: true));
														break;
												}
												break;
											}
										case "垂直合并":
										case "#垂直合并#":
										case "上合并":
										case "下合并":
											{
												int firstrow = 0;
												int firstr = 0;
												float num40 = mymerge.GetVMergeHeight(mydgv, array3[num4], num36, ref num23, ref num25, ref num24, ref firstrow, ref firstr);
												break;
											}
									}
									if (unchecked(num26 > 0 || num24 > 0))
									{
										continue;
									}
									if (Operators.CompareString(Versioned.TypeName(mydgv.Columns[array3[num4]]), "DataGridViewImageColumn", TextCompare: false) == 0)
									{
										if (mydgv.Rows[num36].Cells[array3[num4]].Value != null)
										{
											Image img = (Image)mydgv.Rows[num36].Cells[array3[num4]].FormattedValue;
											byte[] byteByImage = DGVtoExcel.GetByteByImage(img);
											int pictureIndex = hSSFWorkbook.AddPicture(byteByImage, PictureType.JPEG);
											IDrawing drawing = hSSFSheet.CreateDrawingPatriarch();
											XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0, num4, num7 + num36, num4 + 1, num7 + num36 + 1);
											drawing.CreatePicture(anchor, pictureIndex);
										}
									}
									else if (Operators.CompareString(Versioned.TypeName(mydgv.Columns[array3[num4]]), "DataGridViewCheckBoxColumn", TextCompare: false) == 0)
									{
										if (mydgv.Rows[num36].Cells[array3[num4]].Value != null && mydgv.Rows[num36].Cells[array3[num4]].Value != DBNull.Value && Conversions.ToBoolean(mydgv.Rows[num36].Cells[array3[num4]].Value))
										{
											DGVtoExcel.SetCellValue(hSSFSheet, num7 + num36, num4, "√");
										}
										flag2 = false;
									}
									else
									{
										string text2 = Conversions.ToString(mydgv.Rows[num36].Cells[array3[num4]].FormattedValue) ?? "";
										flag2 = Strings.InStr(text2, "\r\n") > 0;
										switch (num39)
										{
											case 1:
												if (Versioned.IsNumeric(text2))
												{
													DGVtoExcel.SetCellValue(hSSFSheet, num7 + num36, num4, Conversions.ToDouble(text2));
												}
												else
												{
													DGVtoExcel.SetCellValue(hSSFSheet, num7 + num36, num4, text2);
												}
												break;
											case 2:
												DGVtoExcel.SetCellValue(hSSFSheet, num7 + num36, num4, text2);
												break;
											default:
												DGVtoExcel.SetCellValue(hSSFSheet, num7 + num36, num4, text2);
												break;
										}
									}
									DataGridViewCellStyle dGVCellStyle = Module1.GetDGVCellStyle(mydgv.Rows[num36].Cells[array3[num4]]);
									DataGridViewContentAlignment alignment = dGVCellStyle.Alignment;
									StringAlignment valign = StringAlignment.Center;
									StringAlignment halign = StringAlignment.Center;
									switch (alignment)
									{
										case DataGridViewContentAlignment.BottomCenter:
											valign = StringAlignment.Far;
											halign = StringAlignment.Center;
											break;
										case DataGridViewContentAlignment.MiddleCenter:
											valign = StringAlignment.Center;
											halign = StringAlignment.Center;
											break;
										case DataGridViewContentAlignment.TopCenter:
											valign = StringAlignment.Near;
											halign = StringAlignment.Center;
											break;
										case DataGridViewContentAlignment.BottomLeft:
											valign = StringAlignment.Far;
											halign = StringAlignment.Near;
											break;
										case DataGridViewContentAlignment.MiddleLeft:
											valign = StringAlignment.Center;
											halign = StringAlignment.Near;
											break;
										case DataGridViewContentAlignment.TopLeft:
											valign = StringAlignment.Near;
											halign = StringAlignment.Near;
											break;
										case DataGridViewContentAlignment.BottomRight:
											valign = StringAlignment.Far;
											halign = StringAlignment.Far;
											break;
										case DataGridViewContentAlignment.MiddleRight:
											valign = StringAlignment.Center;
											halign = StringAlignment.Far;
											break;
										case DataGridViewContentAlignment.TopRight:
											valign = StringAlignment.Near;
											halign = StringAlignment.Far;
											break;
									}
									if (string.Concat(mydgv.Rows[num36].Cells[array3[num4]].Tag).Contains("合并"))
									{
										valign = StringAlignment.Center;
										halign = StringAlignment.Center;
									}
									if (!flag2 && dGVCellStyle.WrapMode == DataGridViewTriState.True)
									{
										flag2 = true;
									}
									Color dGVCellBackColor = Module1.GetDGVCellBackColor(mydgv.Rows[num36].Cells[array3[num4]]);
									Color dGVCellForeColor = Module1.GetDGVCellForeColor(mydgv.Rows[num36].Cells[array3[num4]]);
									DGVtoExcel.SetCellStyle(hSSFWorkbook, hSSFSheet, num7 + num36, num4, leftborder: true, rightborder: true, topborder: true, bottomborder: true, halign, valign, Module1.GetDGVCellFont(mydgv.Rows[num36].Cells[array3[num4]]), dGVCellBackColor, dGVCellForeColor, flag2);
									if (unchecked(num28 == 1 && num23 == 1))
									{
										continue;
									}
									int num41 = num7 + num36;
									int num42 = num7 + num36 + num25;
									for (int num43 = num41; num43 <= num42; num43++)
									{
										int num44 = num4;
										int num45 = num4 + num27;
										for (int num46 = num44; num46 <= num45; num46++)
										{
											unchecked
											{
												if (num43 != checked(num7 + num36) || num46 != num4)
												{
													DGVtoExcel.SetCellBorder(hSSFWorkbook, hSSFSheet, num43, num46, leftborder: true, rightborder: true, topborder: true, bottomborder: true);
												}
											}
										}
									}
									DGVtoExcel.SetMergeCell(hSSFSheet, num7 + num36, num4, num7 + num36 + num25, num4 + num27);
									num4 += num27;
								}
								if (!((num36 + num7 == 1048575) & (num36 != mydgv.RowCount - 1)))
								{
									continue;
								}
								int num47 = 0;
								int num48 = num - 1;
								for (int num49 = num47; num49 <= num48; num49++)
								{
									hSSFSheet.SetColumnWidth(num49, (int)Math.Round(Math.Ceiling((double)mydgv.Columns[array3[num49]].Width / 8.0) * 256.0));
								}
								num32++;
								excelNewSheetName = DGVtoExcel.GetExcelNewSheetName(hSSFWorkbook, sheetname);
								hSSFSheet = (XSSFSheet)hSSFWorkbook.CreateSheet(excelNewSheetName);
								num33 = 1;
								int num50 = num36 + 1;
								int num51 = mydgv.RowCount - 1;
								for (num4 = num50; num4 <= num51; num4++)
								{
									IRow row4 = hSSFSheet.CreateRow(num33 - 1);
									if (!mydgv.Rows[num4].Visible)
									{
										row4.ZeroHeight = true;
									}
									row4.HeightInPoints = Module1.ConvertMmToInch(ruler.ConvertToMM(mydgv.Rows[num4].Height, isX: false)) * 72f;
									if (num33 == 1048576)
									{
										break;
									}
									num33++;
								}
								num7 = -num36 - 1;
							}
							num7 = ((num33 != 0) ? (num33 - 1) : (num7 + mydgv.RowCount));
							if (Operators.CompareString(TableFooter, "", TextCompare: false) != 0)
							{
								DGVtoExcel.SetTitle(hSSFWorkbook, hSSFSheet, num7, num7, 0, endcol, TableFooter, tablefooterfont);
							}
							DGVtoExcel.w_font = null;
							DGVtoExcel.w_ifont = null;
							DGVtoExcel.w_Cellstyle = null;
							DGVtoExcel.w_iCellstyle = null;
							DGVtoExcel.w_color = null;
							int num52 = 0;
							int num53 = num - 1;
							for (int num54 = num52; num54 <= num53; num54++)
							{
								hSSFSheet.SetColumnWidth(num54, (int)Math.Round(Math.Ceiling((double)mydgv.Columns[array3[num54]].Width / 8.0) * 256.0));
							}
							ruler.Dispose();
							ruler = null;
							if (isshowprogress)
							{
								progressexcel.Close();
								progressexcel.Dispose();
							}
							hSSFWorkbook.SetActiveSheet(hSSFWorkbook.GetSheetIndex(excelNewSheetName));
							if (!DGVtoExcel.WriteToFile(hSSFWorkbook, FileName))
							{
								hSSFWorkbook = null;
								result = false;
							}
							else
							{
								hSSFWorkbook = null;
								if (isopenfile && Interaction.MsgBox("导出的Excel文件已保存到【" + FileName + " 】\r\n您是否要立即打开这个文件以查看其内容?", MsgBoxStyle.YesNoCancel, "提示信息") == MsgBoxResult.Yes)
								{
									try
									{
										Process.Start(FileName);
									}
									catch (Exception projectError3)
									{
										Logger.Error(projectError3, "projectError3");
										MessageBox.Show(projectError3.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
										ProjectData.SetProjectError(projectError3);
										try
										{
											Thread.Sleep(100);
											Process.Start(FileName);
										}
										catch (Exception projectError4)
										{
											Logger.Error(projectError4, "projectError4");
											MessageBox.Show(projectError4.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
											ProjectData.SetProjectError(projectError4);
											ProjectData.ClearProjectError();
										}
										ProjectData.ClearProjectError();
									}
								}
								result = true;
							}
						}
					}
					catch (Exception projectError5)
					{
						Logger.Error(projectError5, "projectError5");
						MessageBox.Show(projectError5.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
						ProjectData.SetProjectError(projectError5);
						if (isshowprogress)
						{
							progressexcel.Close();
							progressexcel.Dispose();
						}
						try
						{
							ruler.Dispose();
							ruler = null;
						}
						catch (Exception projectError6)
						{
							Logger.Error(projectError6, "projectError6");
							MessageBox.Show(projectError6.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
							ProjectData.SetProjectError(projectError6);
							ProjectData.ClearProjectError();
						}
						if (Operators.CompareString(FileName, "", TextCompare: false) == 0)
						{
							result = DGVtoExcel.myNewDGVtoExcel(mydgv, FileName, title, Tableheader, TableFooter, isopenfile: true);
							ProjectData.ClearProjectError();
						}
						else
						{
							result = DGVtoExcel.myNewDGVtoExcel(mydgv, FileName, title, Tableheader, TableFooter, isopenfile: false);
							ProjectData.ClearProjectError();
						}
					}
				}
				return result;
			}
		}

		public bool ExportExcel(List<DataGridView> mydgvs, List<TreeView> columnheadertrees, Font titlefont, string title, string FileName, Font tableheaderfont, string Tableheader, Font tablefooterfont, string TableFooter, List<string> sheetnames, bool isopenfile, bool isshowprogress, bool isshowSheetTitle, bool isTopNodeFill)
		{
			bool result = true;
			checked
			{
				if (mydgvs == null || mydgvs.Count == 0 || sheetnames == null || sheetnames.Count == 0 || mydgvs.Count != sheetnames.Count)
				{
					result = false;
				}
				else
				{
					if (columnheadertrees != null && columnheadertrees.Count > 0 && mydgvs.Count != columnheadertrees.Count)
					{
						return false;
					}
					int num = 0;
					int num2 = 0;
					for (int i = 0; i < mydgvs.Count; i++)
					{
						num += mydgvs[i].Rows.Count;
					}
					if (titlefont == null)
					{
						titlefont = new Font("黑体", 18f, FontStyle.Bold);
					}
					if (tableheaderfont == null)
					{
						tableheaderfont = new Font("宋体", 12f);
					}
					if (tablefooterfont == null)
					{
						tablefooterfont = new Font("宋体", 12f);
					}
					progressexcel progressexcel = null;
					Module1.G_CancelExportDGVToExcel = false;
					if (isshowprogress)
					{
						progressexcel = new progressexcel();
						progressexcel.TopMost = true;
						progressexcel.Visible = true;
					}
					Ruler ruler = new Ruler();
					try
					{
						if (isshowprogress)
						{
							progressexcel.Label1.Text = "正在做导出前的准备，请稍侯……";
							progressexcel.ProgressBar1.Value = 0;
							Application.DoEvents();
						}
						bool flag = false;
						DataGridView dataGridView = null;
						TreeView treeView = null;
						XSSFWorkbook hSSFWorkbook = null;
						string empty = string.Empty;
						for (int j = 0; j < mydgvs.Count; j++)
						{
							empty = sheetnames[j];
							dataGridView = mydgvs[j];
							if (columnheadertrees != null && columnheadertrees.Count > 0)
							{
								treeView = columnheadertrees[j];
							}
							int columnCount = dataGridView.ColumnCount;
							int[] array = new int[columnCount - 1 + 1];
							int[] array2 = new int[columnCount - 1 + 1];
							int num3 = 0;
							int num4 = 0;
							int num5 = columnCount - 1;
							for (int k = num4; k <= num5; k++)
							{
								array[k] = k;
								array2[k] = dataGridView.Columns[k].DisplayIndex;
								if (dataGridView.Columns[k].Visible)
								{
									num3++;
								}
							}
							if (num3 <= 0)
							{
								if (isshowprogress)
								{
									progressexcel.Close();
									progressexcel.Dispose();
								}
								result = true;
							}
							else
							{
								Array.Sort(array2, array);
								int[] array3 = new int[num3 - 1 + 1];
								int num6 = 0;
								int num7 = 0;
								int num8 = columnCount - 1;
								for (int l = num7; l <= num8; l++)
								{
									if (dataGridView.Columns[array[l]].Visible)
									{
										array3[num6] = array[l];
										num6++;
									}
								}
								DGVtoExcel.w_ZDYcolors = 8;
								int endcol = num3 - 1;
								if (!flag)
								{
									SaveFileDialog saveFileDialog = new SaveFileDialog();
									saveFileDialog.Title = "请选择要导出Excel文件的路径和文件名";
									saveFileDialog.AddExtension = true;
									saveFileDialog.OverwritePrompt = false;
									saveFileDialog.DefaultExt = "xls";
									saveFileDialog.Filter = "97-2003 Excel文件(*.xls)|*.xls|所有文件(*.*)|*.*";
									saveFileDialog.FileName = FileName;
									if (isshowprogress)
									{
										progressexcel.Visible = false;
									}
									if (saveFileDialog.ShowDialog() == DialogResult.Cancel)
									{
										if (isshowprogress)
										{
											progressexcel.Close();
											progressexcel.Dispose();
										}
										saveFileDialog.Dispose();
										result = false;
										return result;
									}
									FileName = saveFileDialog.FileName;
									saveFileDialog.Dispose();
									if (isshowprogress)
									{
										progressexcel.Visible = true;
									}
									DGVtoExcel.w_font = null;
									DGVtoExcel.w_ifont = null;
									DGVtoExcel.w_Cellstyle = null;
									DGVtoExcel.w_iCellstyle = null;
									DGVtoExcel.w_color = null;
									if (MyProject.Computer.FileSystem.FileExists(FileName))
									{
										if (isshowprogress)
										{
											progressexcel.Visible = false;
										}
										switch (Interaction.MsgBox("选择的文件【" + FileName + "】已经存在，您确定要覆盖原来的文件吗？注意：覆盖原文件后，原文件中的全部数据都将丢失！\r\n单击[是]按钮，将覆盖原文件，单击[否]按钮，导出数据将以追加的形式添加到文件中，单击[取消]按钮将取消导出", MsgBoxStyle.YesNoCancel | MsgBoxStyle.Question, "提示信息"))
										{
											case MsgBoxResult.Cancel:
												if (isshowprogress)
												{
													progressexcel.Close();
													progressexcel.Dispose();
												}
												result = false;
												return result;
											case MsgBoxResult.Yes:
												try
												{
													MyProject.Computer.FileSystem.DeleteFile(FileName, UIOption.OnlyErrorDialogs, RecycleOption.SendToRecycleBin);
												}
												catch (Exception projectError)
												{
													Logger.Error(projectError, "projectError");
													MessageBox.Show(projectError.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
													ProjectData.SetProjectError(projectError);
													Interaction.MsgBox("数据导出失败，原因是文件【" + FileName + "】无法覆盖，可能该文件正在使用中，请关闭该文件后再试", MsgBoxStyle.Exclamation, "提示信息");
													if (isshowprogress)
													{
														progressexcel.Close();
														progressexcel.Dispose();
													}
													result = false;
													ProjectData.ClearProjectError();
													return result;
												}
												break;
										}
										if (isshowprogress)
										{
											progressexcel.Visible = true;
										}
									}
									if (MyProject.Computer.FileSystem.FileExists(FileName))
									{
										FileStream fileStream;
										try
										{
											fileStream = new FileStream(FileName, FileMode.Open, FileAccess.Read);
										}
										catch (Exception ex)
										{
											Logger.Error(ex, "list-ex");
											MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
											ProjectData.SetProjectError(ex);
											Exception ex2 = ex;
											if (isshowprogress)
											{
												progressexcel.Close();
												progressexcel.Dispose();
											}
											Interaction.MsgBox("数据导出失败，原因是打开Excel文件〖" + FileName + "〗失败，" + ex2.Message, MsgBoxStyle.Exclamation, "提示信息");
											fileStream = null;
											result = false;
											ProjectData.ClearProjectError();
											return result;
										}
										try
										{
											hSSFWorkbook = new XSSFWorkbook(fileStream);
										}
										catch (Exception projectError2)
										{
											Logger.Error(projectError2, "list-projectError2");
											MessageBox.Show(projectError2.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
											ProjectData.SetProjectError(projectError2);
											if (isshowprogress)
											{
												progressexcel.Close();
												progressexcel.Dispose();
											}
											fileStream.Dispose();
											fileStream = null;
											Interaction.MsgBox("数据导出失败，原因是打开Excel文件〖" + FileName + "〗失败，可能不是有效的Office97-2003 Excel文件格式，因此无法向该文件中追加导出的数据", MsgBoxStyle.Exclamation, "提示信息");
											hSSFWorkbook = null;
											result = false;
											ProjectData.ClearProjectError();
											return result;
										}
									}
									else
									{
										hSSFWorkbook = new XSSFWorkbook();
									}
									flag = true;
								}
								string excelNewSheetName = DGVtoExcel.GetExcelNewSheetName(hSSFWorkbook, empty);
								XSSFSheet hSSFSheet = (XSSFSheet)hSSFWorkbook.CreateSheet(excelNewSheetName);
								int num9;
								if (Operators.CompareString(title, "", TextCompare: false) == 0)
								{
									num9 = 0;
								}
								else if (isshowSheetTitle)
								{
									DGVtoExcel.SetTitle(hSSFWorkbook, hSSFSheet, 0, 0, 0, endcol, empty, titlefont);
									num9 = 1;
								}
								else
								{
									num9 = 0;
								}
								if (Operators.CompareString(Tableheader, "", TextCompare: false) != 0)
								{
									DGVtoExcel.SetTitle(hSSFWorkbook, hSSFSheet, num9, num9, 0, endcol, Tableheader, tableheaderfont);
									num9++;
								}
								DGVtoExcel.w_gridcolor = DGVtoExcel.GetXLColour(hSSFWorkbook, dataGridView.GridColor);
								if (dataGridView.ColumnHeadersVisible)
								{
									if (treeView == null)
									{
										IRow row = hSSFSheet.CreateRow(num9);
										row.HeightInPoints = Module1.ConvertMmToInch(ruler.ConvertToMM(dataGridView.ColumnHeadersHeight, isX: false)) * 72f;
										int num10 = 0;
										int num11 = num3 - 1;
										for (int m = num10; m <= num11; m++)
										{
											DGVtoExcel.SetCellValue(hSSFSheet, num9, m, dataGridView.Columns[array3[m]].HeaderText);
											Font dGVHeaderFont = Module1.GetDGVHeaderFont(dataGridView.Columns[array3[m]]);
											Color dGVHeaderBackColor = Module1.GetDGVHeaderBackColor(dataGridView.Columns[array3[m]]);
											Color dGVHeaderForeColor = Module1.GetDGVHeaderForeColor(dataGridView.Columns[array3[m]]);
											DGVtoExcel.SetCellStyle(hSSFWorkbook, hSSFSheet, num9, m, leftborder: true, rightborder: true, topborder: true, bottomborder: true, StringAlignment.Center, StringAlignment.Center, dGVHeaderFont, dGVHeaderBackColor, dGVHeaderForeColor, needwrap: false);
										}
									}
									else
									{
										mytree mytree = new mytree(treeView, dataGridView);
										int leves = mytree.GetLeves();
										int num12 = 1;
										int num13 = leves;
										for (int n = num12; n <= num13; n++)
										{
											IRow row2 = hSSFSheet.CreateRow(num9 + n - 1);
											row2.HeightInPoints = Module1.ConvertMmToInch(ruler.ConvertToMM((float)((double)dataGridView.ColumnHeadersHeight / (double)leves), isX: false)) * 72f;
										}
										int num14 = 1;
										int num15 = leves;
										bool flag2 = true;
										for (int num16 = num14; num16 <= num15; num16++)
										{
											if (num16 != 1)
											{
												num9++;
											}
											int num17 = 0;
											int num18 = num3 - 1;
											for (int num19 = num17; num19 <= num18; num19++)
											{
												string nodeText = mytree.GetNodeText(array3[num19], num16);
												int cellHeightLevels = mytree.GetCellHeightLevels(array3[num19], num16, isTopNodeFill, out flag2);
												int cellWidthCols = mytree.GetCellWidthCols(array3[num19], num16);
												if (unchecked(cellHeightLevels == 0 || cellWidthCols == 0))
												{
													continue;
												}
												Font font = mytree.GetNodeFont(array3[num19], num16);
												if (font == null)
												{
													font = Module1.GetDGVHeaderFont(dataGridView.Columns[array3[num19]]);
												}
												Color forcolor = mytree.GetNodeForeColor(array3[num19], num16);
												if (forcolor.IsEmpty)
												{
													forcolor = Module1.GetDGVHeaderForeColor(dataGridView.Columns[array3[num19]]);
												}
												Color bkcolor = mytree.GetNodeBackColor(array3[num19], num16);
												if (bkcolor.IsEmpty)
												{
													bkcolor = Module1.GetDGVHeaderBackColor(dataGridView.Columns[array3[num19]]);
												}
												if (unchecked(cellWidthCols == 1 && cellHeightLevels == 1))
												{
													int num20 = num9;
													if (!flag2)
													{
														num20++;
													}
													DGVtoExcel.SetCellValue(hSSFSheet, num20, num19, nodeText);
													DGVtoExcel.SetCellStyle(hSSFWorkbook, hSSFSheet, num20, num19, leftborder: true, rightborder: true, topborder: true, bottomborder: true, StringAlignment.Center, StringAlignment.Center, font, bkcolor, forcolor, needwrap: false);
													continue;
												}
												DGVtoExcel.SetCellValue(hSSFSheet, num9, num19, nodeText);
												DGVtoExcel.SetCellStyle(hSSFWorkbook, hSSFSheet, num9, num19, leftborder: true, rightborder: true, topborder: true, bottomborder: true, StringAlignment.Center, StringAlignment.Center, font, bkcolor, forcolor, needwrap: false);
												int num21 = num9;
												int num22 = num9 + cellHeightLevels - 1;
												for (int num23 = num21; num23 <= num22; num23++)
												{
													int num24 = num19;
													int num25 = num19 + cellWidthCols - 1;
													for (int num26 = num24; num26 <= num25; num26++)
													{
														if (unchecked(num23 != num9 || num26 != num19))
														{
															DGVtoExcel.SetCellBorder(hSSFWorkbook, hSSFSheet, num23, num26, leftborder: true, rightborder: true, topborder: true, bottomborder: true);
														}
													}
												}
												DGVtoExcel.SetMergeCell(hSSFSheet, num9, num19, num9 + cellHeightLevels - 1, num19 + cellWidthCols - 1);
											}
										}
										mytree.Dispose();
									}
									num9++;
								}
								int num27 = 1;
								int num28 = 0;
								int num29 = 0;
								int num30 = 0;
								int num31 = 0;
								int num32 = 1;
								int num33 = 0;
								int num34 = dataGridView.RowCount - 1;
								for (int num35 = num33; num35 <= num34; num35++)
								{
									IRow row3 = hSSFSheet.CreateRow(num9 + num35);
									row3.HeightInPoints = Module1.ConvertMmToInch(ruler.ConvertToMM(dataGridView.Rows[num35].Height, isX: false)) * 72f;
									if (!dataGridView.Rows[num35].Visible)
									{
										row3.ZeroHeight = true;
									}
									//if (num35 + num9 == 1048575)
									{
										break;
									}
								}
								int num36 = 0;
								int num37 = 0;
								if (isshowprogress)
								{
									progressexcel.ProgressBar1.Maximum = num;
								}
								int num38 = 0;
								int num39 = dataGridView.RowCount - 1;
								for (int num40 = num38; num40 <= num39; num40++)
								{
									bool flag3 = false;
									if (isshowprogress)
									{
										progressexcel.Label1.Text = "正在导出第〖" + Conversions.ToString(num40 + num2 + 1) + "〗条记录，共〖" + Conversions.ToString(num) + "〗条记录，已完成〖" + Strings.Format((double)(num40 + num2 + 1) / (double)num, "###.##%") + "〗";
										progressexcel.ProgressBar1.Value = num40 + 1;
										Application.DoEvents();
									}
									if (Module1.G_CancelExportDGVToExcel)
									{
										break;
									}
									int num41 = 0;
									int num42 = num3 - 1;
									for (num6 = num41; num6 <= num42; num6++)
									{
										int num43;
										if (dataGridView.Columns[array3[num6]].ValueType == null)
										{
											num43 = 0;
										}
										else
										{
											switch (Strings.Left(dataGridView.Columns[array3[num6]].ValueType.Name.ToUpper(), 3))
											{
												case "STR":
													num43 = 0;
													break;
												case "INT":
												case "DEC":
													num43 = 1;
													flag3 = false;
													break;
												case "DAT":
													num43 = 2;
													break;
												case "BOO":
													num43 = 3;
													flag3 = false;
													break;
												default:
													num43 = 0;
													break;
											}
										}
										num32 = 1;
										num27 = 1;
										num30 = 0;
										num28 = 0;
										num31 = 0;
										num30 = 0;
										num28 = 0;
										num29 = 0;
										string text = Conversions.ToString(dataGridView.Rows[num40].Cells[array3[num6]].Tag);
										switch (text)
										{
											default:
												{
													float mywidth = 0f;
													float num44 = 9f;
													int firstcolumn = 0;
													int firstrow = 0;
													int firstc = 0;
													int firstr = 0;
													switch (text)
													{
														default:
															num32 = 1;
															num27 = 1;
															break;
														case "合并":
														case "左上合并":
														case "左下合并":
														case "右上合并":
														case "右下合并":
														case "上边合并":
														case "下边合并":
														case "左边合并":
														case "右边合并":
															mymerge.GetHVMergeWidthAndHeight(dataGridView, array3[num6], num40, ref mywidth, ref num44, ref num31, ref num30, ref num28, ref num29, ref firstcolumn, ref firstrow, ref firstc, ref firstr);
															num32 = num30 + num31 + 1;
															num27 = num28 + num29 + 1;
															break;
														case "水平合并":
														case "#水平合并#":
														case "左合并":
														case "右合并":
															mywidth = (int)Math.Round(mymerge.GetHMergeWidth(dataGridView, array3[num6], num40, ref num32, ref num30, ref num31, ref firstcolumn, ref firstc, iscancheckheight: true));
															break;
													}
													break;
												}
											case "垂直合并":
											case "#垂直合并#":
											case "上合并":
											case "下合并":
												{
													int firstrow = 0;
													int firstr = 0;
													float num44 = mymerge.GetVMergeHeight(dataGridView, array3[num6], num40, ref num27, ref num29, ref num28, ref firstrow, ref firstr);
													break;
												}
										}
										if (unchecked(num30 > 0 || num28 > 0))
										{
											continue;
										}
										if (Operators.CompareString(Versioned.TypeName(dataGridView.Columns[array3[num6]]), "DataGridViewImageColumn", TextCompare: false) == 0)
										{
											if (dataGridView.Rows[num40].Cells[array3[num6]].Value != null)
											{
												Image img = (Image)dataGridView.Rows[num40].Cells[array3[num6]].FormattedValue;
												byte[] byteByImage = DGVtoExcel.GetByteByImage(img);
												int pictureIndex = hSSFWorkbook.AddPicture(byteByImage, PictureType.JPEG);
												IDrawing drawing = hSSFSheet.CreateDrawingPatriarch();
												XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0, num6, num9 + num40, num6 + 1, num9 + num40 + 1);
												drawing.CreatePicture(anchor, pictureIndex);
											}
										}
										else if (Operators.CompareString(Versioned.TypeName(dataGridView.Columns[array3[num6]]), "DataGridViewCheckBoxColumn", TextCompare: false) == 0)
										{
											if (dataGridView.Rows[num40].Cells[array3[num6]].Value != null && dataGridView.Rows[num40].Cells[array3[num6]].Value != DBNull.Value  && Conversions.ToBoolean(dataGridView.Rows[num40].Cells[array3[num6]].FormattedValue))
											{
												DGVtoExcel.SetCellValue(hSSFSheet, num9 + num40, num6, "√");
											}
											flag3 = false;
										}
										else
										{
											string text2 = Conversions.ToString(dataGridView.Rows[num40].Cells[array3[num6]].FormattedValue) ?? "";
											flag3 = Strings.InStr(text2, "\r\n") > 0;
											switch (num43)
											{
												case 1:
													if (Versioned.IsNumeric(text2))
													{
														DGVtoExcel.SetCellValue(hSSFSheet, num9 + num40, num6, Conversions.ToDouble(text2));
													}
													else
													{
														DGVtoExcel.SetCellValue(hSSFSheet, num9 + num40, num6, text2);
													}
													break;
												case 2:
													DGVtoExcel.SetCellValue(hSSFSheet, num9 + num40, num6, text2);
													break;
												default:
													DGVtoExcel.SetCellValue(hSSFSheet, num9 + num40, num6, text2);
													break;
											}
										}
										DataGridViewCellStyle dGVCellStyle = Module1.GetDGVCellStyle(dataGridView.Rows[num40].Cells[array3[num6]]);
										DataGridViewContentAlignment alignment = dGVCellStyle.Alignment;
										StringAlignment valign = StringAlignment.Center;
										StringAlignment halign = StringAlignment.Center;
										switch (alignment)
										{
											case DataGridViewContentAlignment.BottomCenter:
												valign = StringAlignment.Far;
												halign = StringAlignment.Center;
												break;
											case DataGridViewContentAlignment.MiddleCenter:
												valign = StringAlignment.Center;
												halign = StringAlignment.Center;
												break;
											case DataGridViewContentAlignment.TopCenter:
												valign = StringAlignment.Near;
												halign = StringAlignment.Center;
												break;
											case DataGridViewContentAlignment.BottomLeft:
												valign = StringAlignment.Far;
												halign = StringAlignment.Near;
												break;
											case DataGridViewContentAlignment.MiddleLeft:
												valign = StringAlignment.Center;
												halign = StringAlignment.Near;
												break;
											case DataGridViewContentAlignment.TopLeft:
												valign = StringAlignment.Near;
												halign = StringAlignment.Near;
												break;
											case DataGridViewContentAlignment.BottomRight:
												valign = StringAlignment.Far;
												halign = StringAlignment.Far;
												break;
											case DataGridViewContentAlignment.MiddleRight:
												valign = StringAlignment.Center;
												halign = StringAlignment.Far;
												break;
											case DataGridViewContentAlignment.TopRight:
												valign = StringAlignment.Near;
												halign = StringAlignment.Far;
												break;
										}
										if (string.Concat(dataGridView.Rows[num40].Cells[array3[num6]].Tag).Contains("合并"))
										{
											valign = StringAlignment.Center;
											halign = StringAlignment.Center;
										}
										if (!flag3 && dGVCellStyle.WrapMode == DataGridViewTriState.True)
										{
											flag3 = true;
										}
										Color dGVCellBackColor = Module1.GetDGVCellBackColor(dataGridView.Rows[num40].Cells[array3[num6]]);
										Color dGVCellForeColor = Module1.GetDGVCellForeColor(dataGridView.Rows[num40].Cells[array3[num6]]);
										DGVtoExcel.SetCellStyle(hSSFWorkbook, hSSFSheet, num9 + num40, num6, leftborder: true, rightborder: true, topborder: true, bottomborder: true, halign, valign, Module1.GetDGVCellFont(dataGridView.Rows[num40].Cells[array3[num6]]), dGVCellBackColor, dGVCellForeColor, flag3);
										if (unchecked(num32 == 1 && num27 == 1))
										{
											continue;
										}
										int num45 = num9 + num40;
										int num46 = num9 + num40 + num29;
										for (int num47 = num45; num47 <= num46; num47++)
										{
											int num48 = num6;
											int num49 = num6 + num31;
											for (int num50 = num48; num50 <= num49; num50++)
											{
												unchecked
												{
													if (num47 != checked(num9 + num40) || num50 != num6)
													{
														DGVtoExcel.SetCellBorder(hSSFWorkbook, hSSFSheet, num47, num50, leftborder: true, rightborder: true, topborder: true, bottomborder: true);
													}
												}
											}
										}
										DGVtoExcel.SetMergeCell(hSSFSheet, num9 + num40, num6, num9 + num40 + num29, num6 + num31);
										num6 += num31;
									}
									if (!((num40 + num9 == 1048575) & (num40 != dataGridView.RowCount - 1)))
									{
										continue;
									}
									int num51 = 0;
									int num52 = num3 - 1;
									for (int num53 = num51; num53 <= num52; num53++)
									{
										hSSFSheet.SetColumnWidth(num53, (int)Math.Round(Math.Ceiling((double)dataGridView.Columns[array3[num53]].Width / 8.0) * 256.0));
									}
									num36++;
									excelNewSheetName = DGVtoExcel.GetExcelNewSheetName(hSSFWorkbook, empty);
									hSSFSheet = (XSSFSheet)hSSFWorkbook.CreateSheet(excelNewSheetName);
									num37 = 1;
									int num54 = num40 + 1;
									int num55 = dataGridView.RowCount - 1;
									for (num6 = num54; num6 <= num55; num6++)
									{
										IRow row4 = hSSFSheet.CreateRow(num37 - 1);
										if (!dataGridView.Rows[num6].Visible)
										{
											row4.ZeroHeight = true;
										}
										row4.HeightInPoints = Module1.ConvertMmToInch(ruler.ConvertToMM(dataGridView.Rows[num6].Height, isX: false)) * 72f;
										if (num37 == 1048576)
										{
											break;
										}
										num37++;
									}
									num9 = -num40 - 1;
								}
								num9 = ((num37 != 0) ? (num37 - 1) : (num9 + dataGridView.RowCount));
								if (Operators.CompareString(TableFooter, "", TextCompare: false) != 0)
								{
									DGVtoExcel.SetTitle(hSSFWorkbook, hSSFSheet, num9, num9, 0, endcol, TableFooter, tablefooterfont);
								}
								DGVtoExcel.w_font = null;
								DGVtoExcel.w_ifont = null;
								DGVtoExcel.w_Cellstyle = null;
								DGVtoExcel.w_iCellstyle = null;
								DGVtoExcel.w_color = null;
								int num56 = 0;
								int num57 = num3 - 1;
								for (int num58 = num56; num58 <= num57; num58++)
								{
									hSSFSheet.SetColumnWidth(num58, (int)Math.Round(Math.Ceiling((double)dataGridView.Columns[array3[num58]].Width / 8.0) * 256.0));
								}
								hSSFWorkbook.SetActiveSheet(hSSFWorkbook.GetSheetIndex(excelNewSheetName));
							}
							num2 += mydgvs[j].Rows.Count;
						}
						ruler.Dispose();
						ruler = null;
						if (isshowprogress)
						{
							progressexcel.Close();
							progressexcel.Dispose();
						}
						if (!DGVtoExcel.WriteToFile(hSSFWorkbook, FileName))
						{
							hSSFWorkbook = null;
							result = false;
						}
						else
						{
							hSSFWorkbook = null;
							if (isopenfile && Interaction.MsgBox("导出的Excel文件已保存到【" + FileName + " 】\r\n您是否要立即打开这个文件以查看其内容?", MsgBoxStyle.YesNoCancel, "提示信息") == MsgBoxResult.Yes)
							{
								try
								{
									Process.Start(FileName);
								}
								catch (Exception projectError3)
								{
									Logger.Error(projectError3, "list-projectError3");
									MessageBox.Show(projectError3.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
									ProjectData.SetProjectError(projectError3);
									try
									{
										Thread.Sleep(100);
										Process.Start(FileName);
									}
									catch (Exception projectError4)
									{
										Logger.Error(projectError4, "list-projectError4");
										MessageBox.Show(projectError4.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
										ProjectData.SetProjectError(projectError4);
										ProjectData.ClearProjectError();
									}
									ProjectData.ClearProjectError();
								}
							}
							result = true;
						}
					}
					catch (Exception projectError5)
					{
						Logger.Error(projectError5, "list-projectError5");
						MessageBox.Show(projectError5.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
						ProjectData.SetProjectError(projectError5);
						if (isshowprogress)
						{
							progressexcel.Close();
							progressexcel.Dispose();
						}
						try
						{
							ruler.Dispose();
							ruler = null;
						}
						catch (Exception projectError6)
						{
							Logger.Error(projectError6, "list-projectError6");
							MessageBox.Show(projectError6.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
							ProjectData.SetProjectError(projectError6);
							ProjectData.ClearProjectError();
						}
					}
				}
				return result;
			}
		}

/*
		public bool ExportExcelOneSheet(List<DataGridView> mydgvs, List<TreeView> columnheadertrees, Font titlefont, string title, string FileName, Font tableheaderfont, string Tableheader, Font tablefooterfont, string TableFooter, List<string> sheetnames, bool isopenfile, bool isshowprogress, bool isTopNodeFill)
		{
			bool result = true;
			int num = 0;
			checked
			{
				if (mydgvs == null || mydgvs.Count == 0 || sheetnames == null || sheetnames.Count == 0 || mydgvs.Count != sheetnames.Count)
				{
					result = false;
				}
				else
				{
					if (columnheadertrees != null && columnheadertrees.Count > 0 && mydgvs.Count != columnheadertrees.Count)
					{
						return false;
					}
					int num2 = 0;
					if (titlefont == null)
					{
						titlefont = new Font("黑体", 18f, FontStyle.Bold);
					}
					if (tableheaderfont == null)
					{
						tableheaderfont = new Font("宋体", 12f);
					}
					if (tablefooterfont == null)
					{
						tablefooterfont = new Font("宋体", 12f);
					}
					progressexcel progressexcel = null;
					Module1.G_CancelExportDGVToExcel = false;
					if (isshowprogress)
					{
						progressexcel = new progressexcel();
						progressexcel.TopMost = true;
						progressexcel.Visible = true;
					}
					Ruler ruler = new Ruler();
					try
					{
						if (isshowprogress)
						{
							progressexcel.Label1.Text = "正在做导出前的准备，请稍侯……";
							progressexcel.ProgressBar1.Value = 0;
							Application.DoEvents();
						}
						bool flag = false;
						DataGridView dataGridView = null;
						TreeView treeView = null;
						XSSFWorkbook hSSFWorkbook = null;
						XSSFSheet hSSFSheet = null;
						string empty = string.Empty;
						string text = string.Empty;
						for (int i = 0; i < mydgvs.Count; i++)
						{
							empty = sheetnames[i];
							dataGridView = mydgvs[i];
							if (columnheadertrees != null && columnheadertrees.Count > 0)
							{
								treeView = columnheadertrees[i];
							}
							int columnCount = dataGridView.ColumnCount;
							int[] array = new int[columnCount - 1 + 1];
							int[] array2 = new int[columnCount - 1 + 1];
							int num3 = 0;
							int num4 = 0;
							int num5 = columnCount - 1;
							for (int j = num4; j <= num5; j++)
							{
								array[j] = j;
								array2[j] = dataGridView.Columns[j].DisplayIndex;
								if (dataGridView.Columns[j].Visible)
								{
									num3++;
								}
							}
							if (num3 <= 0)
							{
								if (isshowprogress)
								{
									progressexcel.Close();
									progressexcel.Dispose();
								}
								result = true;
							}
							else
							{
								Array.Sort(array2, array);
								int[] array3 = new int[num3 - 1 + 1];
								int num6 = 0;
								int num7 = 0;
								int num8 = columnCount - 1;
								for (int k = num7; k <= num8; k++)
								{
									if (dataGridView.Columns[array[k]].Visible)
									{
										array3[num6] = array[k];
										num6++;
									}
								}
								DGVtoExcel.w_ZDYcolors = 8;
								int endcol = num3 - 1;
								if (!flag)
								{
									SaveFileDialog saveFileDialog = new SaveFileDialog();
									saveFileDialog.Title = "请选择要导出Excel文件的路径和文件名";
									saveFileDialog.AddExtension = true;
									saveFileDialog.OverwritePrompt = false;
									saveFileDialog.DefaultExt = "xls";
									saveFileDialog.Filter = "97-2003 Excel文件(*.xls)|*.xls|所有文件(*.*)|*.*";
									saveFileDialog.FileName = FileName;
									if (isshowprogress)
									{
										progressexcel.Visible = false;
									}
									if (saveFileDialog.ShowDialog() == DialogResult.Cancel)
									{
										if (isshowprogress)
										{
											progressexcel.Close();
											progressexcel.Dispose();
										}
										saveFileDialog.Dispose();
										result = false;
										return result;
									}
									FileName = saveFileDialog.FileName;
									saveFileDialog.Dispose();
									if (isshowprogress)
									{
										progressexcel.Visible = true;
									}
									DGVtoExcel.w_font = null;
									DGVtoExcel.w_ifont = null;
									DGVtoExcel.w_Cellstyle = null;
									DGVtoExcel.w_iCellstyle = null;
									DGVtoExcel.w_color = null;
									if (MyProject.Computer.FileSystem.FileExists(FileName))
									{
										if (isshowprogress)
										{
											progressexcel.Visible = false;
										}
										switch (Interaction.MsgBox("选择的文件【" + FileName + "】已经存在，您确定要覆盖原来的文件吗？注意：覆盖原文件后，原文件中的全部数据都将丢失！\r\n单击[是]按钮，将覆盖原文件，单击[否]按钮，导出数据将以追加的形式添加到文件中，单击[取消]按钮将取消导出", MsgBoxStyle.YesNoCancel | MsgBoxStyle.Question, "提示信息"))
										{
											case MsgBoxResult.Cancel:
												if (isshowprogress)
												{
													progressexcel.Close();
													progressexcel.Dispose();
												}
												result = false;
												return result;
											case MsgBoxResult.Yes:
												try
												{
													MyProject.Computer.FileSystem.DeleteFile(FileName, UIOption.OnlyErrorDialogs, RecycleOption.SendToRecycleBin);
												}
												catch (Exception projectError)
												{
													ProjectData.SetProjectError(projectError);
													Interaction.MsgBox("数据导出失败，原因是文件【" + FileName + "】无法覆盖，可能该文件正在使用中，请关闭该文件后再试", MsgBoxStyle.Exclamation, "提示信息");
													if (isshowprogress)
													{
														progressexcel.Close();
														progressexcel.Dispose();
													}
													result = false;
													ProjectData.ClearProjectError();
													return result;
												}
												break;
										}
										if (isshowprogress)
										{
											progressexcel.Visible = true;
										}
									}
									if (MyProject.Computer.FileSystem.FileExists(FileName))
									{
										FileStream fileStream;
										try
										{
											fileStream = new FileStream(FileName, FileMode.Open, FileAccess.Read);
										}
										catch (Exception ex)
										{
											ProjectData.SetProjectError(ex);
											Exception ex2 = ex;
											if (isshowprogress)
											{
												progressexcel.Close();
												progressexcel.Dispose();
											}
											Interaction.MsgBox("数据导出失败，原因是打开Excel文件〖" + FileName + "〗失败，" + ex2.Message, MsgBoxStyle.Exclamation, "提示信息");
											fileStream = null;
											result = false;
											ProjectData.ClearProjectError();
											return result;
										}
										try
										{
											hSSFWorkbook = new XSSFWorkbook(fileStream);
										}
										catch (Exception projectError2)
										{
											ProjectData.SetProjectError(projectError2);
											if (isshowprogress)
											{
												progressexcel.Close();
												progressexcel.Dispose();
											}
											fileStream.Dispose();
											fileStream = null;
											Interaction.MsgBox("数据导出失败，原因是打开Excel文件〖" + FileName + "〗失败，可能不是有效的Office97-2003 Excel文件格式，因此无法向该文件中追加导出的数据", MsgBoxStyle.Exclamation, "提示信息");
											hSSFWorkbook = null;
											result = false;
											ProjectData.ClearProjectError();
											return result;
										}
									}
									else
									{
										hSSFWorkbook = new XSSFWorkbook();
									}
									flag = true;
								}
								if (hSSFSheet == null)
								{
									text = DGVtoExcel.GetExcelNewSheetName(hSSFWorkbook, title);
									hSSFSheet = (XSSFSheet)hSSFWorkbook.CreateSheet(text);
								}
								int num9;
								if (Operators.CompareString(title, "", TextCompare: false) == 0)
								{
									num9 = 0;
								}
								else
								{
									DGVtoExcel.SetTitle(hSSFWorkbook, hSSFSheet, num2, num2, 0, endcol, empty, titlefont);
									num9 = 1;
								}
								if (Operators.CompareString(Tableheader, "", TextCompare: false) != 0)
								{
									DGVtoExcel.SetTitle(hSSFWorkbook, hSSFSheet, num9 + num2, num9 + num2, 0, endcol, Tableheader, tableheaderfont);
									num9++;
								}
								num9 += num2;
								DGVtoExcel.w_gridcolor = DGVtoExcel.GetXLColour(hSSFWorkbook, dataGridView.GridColor);
								if (dataGridView.ColumnHeadersVisible)
								{
									if (treeView == null)
									{
										IRow row = hSSFSheet.CreateRow(num9);
										row.HeightInPoints = Module1.ConvertMmToInch(ruler.ConvertToMM(dataGridView.ColumnHeadersHeight, isX: false)) * 72f;
										int num10 = 0;
										int num11 = num3 - 1;
										for (int l = num10; l <= num11; l++)
										{
											DGVtoExcel.SetCellValue(hSSFSheet, num9, l, dataGridView.Columns[array3[l]].HeaderText);
											Font dGVHeaderFont = Module1.GetDGVHeaderFont(dataGridView.Columns[array3[l]]);
											Color dGVHeaderBackColor = Module1.GetDGVHeaderBackColor(dataGridView.Columns[array3[l]]);
											Color dGVHeaderForeColor = Module1.GetDGVHeaderForeColor(dataGridView.Columns[array3[l]]);
											DGVtoExcel.SetCellStyle(hSSFWorkbook, hSSFSheet, num9, l, leftborder: true, rightborder: true, topborder: true, bottomborder: true, StringAlignment.Center, StringAlignment.Center, dGVHeaderFont, dGVHeaderBackColor, dGVHeaderForeColor, needwrap: false);
										}
									}
									else
									{
										mytree mytree = new mytree(treeView, dataGridView);
										num = mytree.GetLeves();
										int num12 = 1;
										int num13 = num;
										for (int m = num12; m <= num13; m++)
										{
											IRow row2 = hSSFSheet.CreateRow(num9 + m - 1);
											row2.HeightInPoints = Module1.ConvertMmToInch(ruler.ConvertToMM((float)((double)dataGridView.ColumnHeadersHeight / (double)num), isX: false)) * 72f;
										}
										int num14 = 1;
										int num15 = num;
										for (int n = num14; n <= num15; n++)
										{
											if (n != 1)
											{
												num9++;
											}
											int num16 = 0;
											int num17 = num3 - 1;
											bool flag2 = true;
											for (int num18 = num16; num18 <= num17; num18++)
											{
												string nodeText = mytree.GetNodeText(array3[num18], n);
												int cellHeightLevels = mytree.GetCellHeightLevels(array3[num18], n, isTopNodeFill, out flag2);
												int cellWidthCols = mytree.GetCellWidthCols(array3[num18], n);
												if (unchecked(cellHeightLevels == 0 || cellWidthCols == 0))
												{
													continue;
												}
												Font font = mytree.GetNodeFont(array3[num18], n);
												if (font == null)
												{
													font = Module1.GetDGVHeaderFont(dataGridView.Columns[array3[num18]]);
												}
												Color forcolor = mytree.GetNodeForeColor(array3[num18], n);
												if (forcolor.IsEmpty)
												{
													forcolor = Module1.GetDGVHeaderForeColor(dataGridView.Columns[array3[num18]]);
												}
												Color bkcolor = mytree.GetNodeBackColor(array3[num18], n);
												if (bkcolor.IsEmpty)
												{
													bkcolor = Module1.GetDGVHeaderBackColor(dataGridView.Columns[array3[num18]]);
												}
												if (unchecked(cellWidthCols == 1 && cellHeightLevels == 1))
												{
													int num19 = num9;
													if (!flag2)
													{
														num19++;
													}
													DGVtoExcel.SetCellValue(hSSFSheet, num19, num18, nodeText);
													DGVtoExcel.SetCellStyle(hSSFWorkbook, hSSFSheet, num19, num18, leftborder: true, rightborder: true, topborder: true, bottomborder: true, StringAlignment.Center, StringAlignment.Center, font, bkcolor, forcolor, needwrap: false);
													continue;
												}
												DGVtoExcel.SetCellValue(hSSFSheet, num9, num18, nodeText);
												DGVtoExcel.SetCellStyle(hSSFWorkbook, hSSFSheet, num9, num18, leftborder: true, rightborder: true, topborder: true, bottomborder: true, StringAlignment.Center, StringAlignment.Center, font, bkcolor, forcolor, needwrap: false);
												int num20 = num9;
												int num21 = num9 + cellHeightLevels - 1;
												for (int num22 = num20; num22 <= num21; num22++)
												{
													int num23 = num18;
													int num24 = num18 + cellWidthCols - 1;
													for (int num25 = num23; num25 <= num24; num25++)
													{
														if (unchecked(num22 != num9 || num25 != num18))
														{
															DGVtoExcel.SetCellBorder(hSSFWorkbook, hSSFSheet, num22, num25, leftborder: true, rightborder: true, topborder: true, bottomborder: true);
														}
													}
												}
												DGVtoExcel.SetMergeCell(hSSFSheet, num9, num18, num9 + cellHeightLevels - 1, num18 + cellWidthCols - 1);
											}
										}
										mytree.Dispose();
									}
									num9++;
								}
								int num26 = 1;
								int num27 = 0;
								int num28 = 0;
								int num29 = 0;
								int num30 = 0;
								int num31 = 1;
								int num32 = 0;
								int num33 = dataGridView.RowCount - 1;
								for (int num34 = num32; num34 <= num33; num34++)
								{
									IRow row3 = hSSFSheet.CreateRow(num9 + num34);
									row3.HeightInPoints = Module1.ConvertMmToInch(ruler.ConvertToMM(dataGridView.Rows[num34].Height, isX: false)) * 72f;
									if (!dataGridView.Rows[num34].Visible)
									{
										row3.ZeroHeight = true;
									}
									if (num34 + num9 == 1048575)
									{
										break;
									}
								}
								int num35 = 0;
								int num36 = 0;
								if (isshowprogress)
								{
									progressexcel.ProgressBar1.Maximum = dataGridView.RowCount;
								}
								int num37 = 0;
								int num38 = dataGridView.RowCount - 1;
								for (int num39 = num37; num39 <= num38; num39++)
								{
									bool flag3 = false;
									if (isshowprogress)
									{
										progressexcel.Label1.Text = "正在导出第〖" + Conversions.ToString(num39 + 1) + "〗条记录，共〖" + Conversions.ToString(dataGridView.RowCount) + "〗条记录，已完成〖" + Strings.Format((double)(num39 + 1) / (double)dataGridView.RowCount, "###.##%") + "〗";
										progressexcel.ProgressBar1.Value = num39 + 1;
										Application.DoEvents();
									}
									if (Module1.G_CancelExportDGVToExcel)
									{
										break;
									}
									int num40 = 0;
									int num41 = num3 - 1;
									for (num6 = num40; num6 <= num41; num6++)
									{
										int num42;
										if (dataGridView.Columns[array3[num6]].ValueType == null)
										{
											num42 = 0;
										}
										else
										{
											switch (Strings.Left(dataGridView.Columns[array3[num6]].ValueType.Name.ToUpper(), 3))
											{
												case "STR":
													num42 = 0;
													break;
												case "INT":
												case "DEC":
													num42 = 1;
													flag3 = false;
													break;
												case "DAT":
													num42 = 2;
													break;
												case "BOO":
													num42 = 3;
													flag3 = false;
													break;
												default:
													num42 = 0;
													break;
											}
										}
										num31 = 1;
										num26 = 1;
										num29 = 0;
										num27 = 0;
										num30 = 0;
										num29 = 0;
										num27 = 0;
										num28 = 0;
										string text2 = Conversions.ToString(dataGridView.Rows[num39].Cells[array3[num6]].Tag);
										switch (text2)
										{
											default:
												{
													float mywidth = 0f;
													float num43 = 9f;
													int firstcolumn = 0;
													int firstrow = 0;
													int firstc = 0;
													int firstr = 0;
													switch (text2)
													{
														default:
															num31 = 1;
															num26 = 1;
															break;
														case "合并":
														case "左上合并":
														case "左下合并":
														case "右上合并":
														case "右下合并":
														case "上边合并":
														case "下边合并":
														case "左边合并":
														case "右边合并":
															mymerge.GetHVMergeWidthAndHeight(dataGridView, array3[num6], num39, ref mywidth, ref num43, ref num30, ref num29, ref num27, ref num28, ref firstcolumn, ref firstrow, ref firstc, ref firstr);
															num31 = num29 + num30 + 1;
															num26 = num27 + num28 + 1;
															break;
														case "水平合并":
														case "#水平合并#":
														case "左合并":
														case "右合并":
															mywidth = (int)Math.Round(mymerge.GetHMergeWidth(dataGridView, array3[num6], num39, ref num31, ref num29, ref num30, ref firstcolumn, ref firstc, iscancheckheight: true));
															break;
													}
													break;
												}
											case "垂直合并":
											case "#垂直合并#":
											case "上合并":
											case "下合并":
												{
													int firstrow = 0;
													int firstr = 0;
													float num43 = mymerge.GetVMergeHeight(dataGridView, array3[num6], num39, ref num26, ref num28, ref num27, ref firstrow, ref firstr);
													break;
												}
										}
										if (unchecked(num29 > 0 || num27 > 0))
										{
											continue;
										}
										if (Operators.CompareString(Versioned.TypeName(dataGridView.Columns[array3[num6]]), "DataGridViewImageColumn", TextCompare: false) == 0)
										{
											if (dataGridView.Rows[num39].Cells[array3[num6]].Value != null)
											{
												Image img = (Image)dataGridView.Rows[num39].Cells[array3[num6]].FormattedValue;
												byte[] byteByImage = DGVtoExcel.GetByteByImage(img);
												int pictureIndex = hSSFWorkbook.AddPicture(byteByImage, PictureType.JPEG);
												IDrawing drawing = hSSFSheet.CreateDrawingPatriarch();
												XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0, num6, num9 + num39, num6 + 1, num9 + num39 + 1);
												drawing.CreatePicture(anchor, pictureIndex);
											}
										}
										else if (Operators.CompareString(Versioned.TypeName(dataGridView.Columns[array3[num6]]), "DataGridViewCheckBoxColumn", TextCompare: false) == 0)
										{
											if (dataGridView.Rows[num39].Cells[array3[num6]].Value != null && Conversions.ToBoolean(dataGridView.Rows[num39].Cells[array3[num6]].FormattedValue))
											{
												DGVtoExcel.SetCellValue(hSSFSheet, num9 + num39, num6, "√");
											}
											flag3 = false;
										}
										else
										{
											string text3 = Conversions.ToString(dataGridView.Rows[num39].Cells[array3[num6]].FormattedValue) ?? "";
											flag3 = Strings.InStr(text3, "\r\n") > 0;
											switch (num42)
											{
												case 1:
													if (Versioned.IsNumeric(text3))
													{
														DGVtoExcel.SetCellValue(hSSFSheet, num9 + num39, num6, Conversions.ToDouble(text3));
													}
													else
													{
														DGVtoExcel.SetCellValue(hSSFSheet, num9 + num39, num6, text3);
													}
													break;
												case 2:
													DGVtoExcel.SetCellValue(hSSFSheet, num9 + num39, num6, text3);
													break;
												default:
													DGVtoExcel.SetCellValue(hSSFSheet, num9 + num39, num6, text3);
													break;
											}
										}
										DataGridViewCellStyle dGVCellStyle = Module1.GetDGVCellStyle(dataGridView.Rows[num39].Cells[array3[num6]]);
										DataGridViewContentAlignment alignment = dGVCellStyle.Alignment;
										StringAlignment valign = StringAlignment.Center;
										StringAlignment halign = StringAlignment.Center;
										switch (alignment)
										{
											case DataGridViewContentAlignment.BottomCenter:
												valign = StringAlignment.Far;
												halign = StringAlignment.Center;
												break;
											case DataGridViewContentAlignment.MiddleCenter:
												valign = StringAlignment.Center;
												halign = StringAlignment.Center;
												break;
											case DataGridViewContentAlignment.TopCenter:
												valign = StringAlignment.Near;
												halign = StringAlignment.Center;
												break;
											case DataGridViewContentAlignment.BottomLeft:
												valign = StringAlignment.Far;
												halign = StringAlignment.Near;
												break;
											case DataGridViewContentAlignment.MiddleLeft:
												valign = StringAlignment.Center;
												halign = StringAlignment.Near;
												break;
											case DataGridViewContentAlignment.TopLeft:
												valign = StringAlignment.Near;
												halign = StringAlignment.Near;
												break;
											case DataGridViewContentAlignment.BottomRight:
												valign = StringAlignment.Far;
												halign = StringAlignment.Far;
												break;
											case DataGridViewContentAlignment.MiddleRight:
												valign = StringAlignment.Center;
												halign = StringAlignment.Far;
												break;
											case DataGridViewContentAlignment.TopRight:
												valign = StringAlignment.Near;
												halign = StringAlignment.Far;
												break;
										}
										if (string.Concat(dataGridView.Rows[num39].Cells[array3[num6]].Tag).Contains("合并"))
										{
											valign = StringAlignment.Center;
											halign = StringAlignment.Center;
										}
										if (!flag3 && dGVCellStyle.WrapMode == DataGridViewTriState.True)
										{
											flag3 = true;
										}
										Color dGVCellBackColor = Module1.GetDGVCellBackColor(dataGridView.Rows[num39].Cells[array3[num6]]);
										Color dGVCellForeColor = Module1.GetDGVCellForeColor(dataGridView.Rows[num39].Cells[array3[num6]]);
										DGVtoExcel.SetCellStyle(hSSFWorkbook, hSSFSheet, num9 + num39, num6, leftborder: true, rightborder: true, topborder: true, bottomborder: true, halign, valign, Module1.GetDGVCellFont(dataGridView.Rows[num39].Cells[array3[num6]]), dGVCellBackColor, dGVCellForeColor, flag3);
										if (unchecked(num31 == 1 && num26 == 1))
										{
											continue;
										}
										int num44 = num9 + num39;
										int num45 = num9 + num39 + num28;
										for (int num46 = num44; num46 <= num45; num46++)
										{
											int num47 = num6;
											int num48 = num6 + num30;
											for (int num49 = num47; num49 <= num48; num49++)
											{
												unchecked
												{
													if (num46 != checked(num9 + num39) || num49 != num6)
													{
														DGVtoExcel.SetCellBorder(hSSFWorkbook, hSSFSheet, num46, num49, leftborder: true, rightborder: true, topborder: true, bottomborder: true);
													}
												}
											}
										}
										DGVtoExcel.SetMergeCell(hSSFSheet, num9 + num39, num6, num9 + num39 + num28, num6 + num30);
										num6 += num30;
									}
									if (!((num39 + num9 == 1048575) & (num39 != dataGridView.RowCount - 1)))
									{
										continue;
									}
									int num50 = 0;
									int num51 = num3 - 1;
									for (int num52 = num50; num52 <= num51; num52++)
									{
										hSSFSheet.SetColumnWidth(num52, (int)Math.Round(Math.Ceiling((double)dataGridView.Columns[array3[num52]].Width / 8.0) * 256.0));
									}
									num35++;
									text = DGVtoExcel.GetExcelNewSheetName(hSSFWorkbook, empty);
									hSSFSheet = (XSSFSheet)hSSFWorkbook.CreateSheet(text);
									num36 = 1;
									int num53 = num39 + 1;
									int num54 = dataGridView.RowCount - 1;
									for (num6 = num53; num6 <= num54; num6++)
									{
										IRow row4 = hSSFSheet.CreateRow(num36 - 1);
										if (!dataGridView.Rows[num6].Visible)
										{
											row4.ZeroHeight = true;
										}
										row4.HeightInPoints = Module1.ConvertMmToInch(ruler.ConvertToMM(dataGridView.Rows[num6].Height, isX: false)) * 72f;
										if (num36 == 1048576)
										{
											break;
										}
										num36++;
									}
									num9 = -num39 - 1;
								}
								num9 = ((num36 != 0) ? (num36 - 1) : (num9 + dataGridView.RowCount));
								if (Operators.CompareString(TableFooter, "", TextCompare: false) != 0)
								{
									DGVtoExcel.SetTitle(hSSFWorkbook, hSSFSheet, num9, num9, 0, endcol, TableFooter, tablefooterfont);
								}
								DGVtoExcel.w_font = null;
								DGVtoExcel.w_ifont = null;
								DGVtoExcel.w_Cellstyle = null;
								DGVtoExcel.w_iCellstyle = null;
								DGVtoExcel.w_color = null;
								int num55 = 0;
								int num56 = num3 - 1;
								for (int num57 = num55; num57 <= num56; num57++)
								{
									hSSFSheet.SetColumnWidth(num57, (int)Math.Round(Math.Ceiling((double)dataGridView.Columns[array3[num57]].Width / 8.0) * 256.0));
								}
								hSSFWorkbook.SetActiveSheet(hSSFWorkbook.GetSheetIndex(text));
							}
							num2 += mydgvs[i].Rows.Count + ((num == 0) ? 1 : num) + 4;
						}
						ruler.Dispose();
						ruler = null;
						if (isshowprogress)
						{
							progressexcel.Close();
							progressexcel.Dispose();
						}
						if (!DGVtoExcel.WriteToFile(hSSFWorkbook, FileName))
						{
							hSSFWorkbook = null;
							result = false;
						}
						else
						{
							hSSFWorkbook = null;
							if (isopenfile && Interaction.MsgBox("导出的Excel文件已保存到【" + FileName + " 】\r\n您是否要立即打开这个文件以查看其内容?", MsgBoxStyle.YesNoCancel, "提示信息") == MsgBoxResult.Yes)
							{
								try
								{
									Process.Start(FileName);
								}
								catch (Exception projectError3)
								{
									ProjectData.SetProjectError(projectError3);
									try
									{
										Thread.Sleep(100);
										Process.Start(FileName);
									}
									catch (Exception projectError4)
									{
										ProjectData.SetProjectError(projectError4);
										ProjectData.ClearProjectError();
									}
									ProjectData.ClearProjectError();
								}
							}
							result = true;
						}
					}
					catch (Exception projectError5)
					{
						ProjectData.SetProjectError(projectError5);
						if (isshowprogress)
						{
							progressexcel.Close();
							progressexcel.Dispose();
						}
						try
						{
							ruler.Dispose();
							ruler = null;
						}
						catch (Exception projectError6)
						{
							ProjectData.SetProjectError(projectError6);
							ProjectData.ClearProjectError();
						}
					}
				}
				return result;
			}
		}

		public void ExportDGVToPDF(DataGridView dgv, TreeView tv, string title, Font titlefont, Font tableheaderfont, string tableheader, Font tablefooterfont, string tablefooter, string filename, bool isshowprogress)
		{
			//IL_012f: Unknown result type (might be due to invalid IL or missing references)
			//IL_0139: Expected O, but got Unknown
			//IL_021a: Unknown result type (might be due to invalid IL or missing references)
			//IL_0221: Expected O, but got Unknown
			//IL_03c9: Unknown result type (might be due to invalid IL or missing references)
			//IL_03d0: Expected O, but got Unknown
			//IL_0300: Unknown result type (might be due to invalid IL or missing references)
			//IL_0307: Expected O, but got Unknown
			//IL_04ed: Unknown result type (might be due to invalid IL or missing references)
			//IL_04f4: Expected O, but got Unknown
			//IL_05a8: Unknown result type (might be due to invalid IL or missing references)
			//IL_05af: Expected O, but got Unknown
			//IL_0550: Unknown result type (might be due to invalid IL or missing references)
			//IL_0557: Expected O, but got Unknown
			//IL_0702: Unknown result type (might be due to invalid IL or missing references)
			//IL_0709: Expected O, but got Unknown
			_paperwidth = 210f;
			_paperheight = 297f;
			_paperlandscape = false;
			_margin = new Margins(10, 10, 10, 10);
			_repeatheader = true;
			if (dgv == null || dgv.ColumnCount <= 0)
			{
				return;
			}
			progressexcel progressexcel = null;
			SaveFileDialog saveFileDialog = new SaveFileDialog();
			saveFileDialog.Title = "请选择要导出PDF文件的路径和文件名";
			saveFileDialog.AddExtension = true;
			saveFileDialog.OverwritePrompt = false;
			saveFileDialog.DefaultExt = "PDF";
			saveFileDialog.Filter = "PDF文件(*.pdf)|*.pdf";
			saveFileDialog.FileName = filename;
			if (isshowprogress)
			{
				progressexcel = new progressexcel();
				progressexcel.Text = "导出PDF文件";
				progressexcel.TopMost = true;
				progressexcel.Visible = true;
				Module1.G_CancelExportDGVToExcel = false;
				progressexcel.Label1.Text = "正在做导出前的准备，请稍侯……";
				Application.DoEvents();
			}
			if (saveFileDialog.ShowDialog() == DialogResult.Cancel)
			{
				if (isshowprogress)
				{
					progressexcel.Close();
					progressexcel.Dispose();
				}
				saveFileDialog.Dispose();
				return;
			}
			filename = saveFileDialog.FileName;
			saveFileDialog.Dispose();
			if (mydoc != null)
			{
				mydoc.Dispose();
				mydoc = null;
			}
			if (mywriter != null)
			{
				((DocWriter)mywriter).Dispose();
				mywriter = null;
			}
			FontFactory.RegisterDirectories();
			mydoc = new Document();
			float totalwidth = 0f;
			int[] dGVColWidth = GetDGVColWidth(dgv, ref totalwidth);
			checked
			{
				float[] array = new float[dGVColWidth.Length - 1 + 1];
				int num = 0;
				int num2 = dGVColWidth.Length - 1;
				for (int i = num; i <= num2; i++)
				{
					array[i] = Module1.G_ruler.ConvertToPoint(dGVColWidth[i], isx: true);
				}
				mywriter = PdfWriter.GetInstance(mydoc, (Stream)new FileStream(filename, FileMode.Create));
				mywriter.PageEvent = (IPdfPageEvent)(object)new testevent();
				mydoc.Open();
				if (PaperWidth == 0f)
				{
					totalwidth = Module1.G_ruler.ConvertToMM(totalwidth, isX: true) + (float)PaperMargin.Left + (float)PaperMargin.Right;
					totalwidth = Module1.G_ruler.ConvertToPointFromMM(totalwidth);
					Rectangle pageSize = new Rectangle(0f, 0f, totalwidth, Module1.G_ruler.ConvertToPointFromMM(PaperHeight));
					mydoc.SetPageSize(pageSize);
					mydoc.SetMargins(Module1.G_ruler.ConvertToPointFromMM(_margin.Left), Module1.G_ruler.ConvertToPointFromMM(_margin.Right), Module1.G_ruler.ConvertToPointFromMM(_margin.Top), Module1.G_ruler.ConvertToPointFromMM(_margin.Bottom));
					myratio = 1f;
				}
				else
				{
					totalwidth = Module1.G_ruler.ConvertToMM(totalwidth, isX: true);
					totalwidth = Module1.G_ruler.ConvertToPointFromMM(totalwidth);
					float num3 = Module1.G_ruler.ConvertToPointFromMM(PaperWidth);
					float num4 = Module1.G_ruler.ConvertToPointFromMM(PaperHeight);
					if (unchecked(PaperLandScape || num3 > num4))
					{
						Rectangle val = new Rectangle(0f, 0f, num3, num4);
						mydoc.SetMargins(Module1.G_ruler.ConvertToPointFromMM(_margin.Left), Module1.G_ruler.ConvertToPointFromMM(_margin.Right), Module1.G_ruler.ConvertToPointFromMM(_margin.Top), Module1.G_ruler.ConvertToPointFromMM(_margin.Bottom));
						mydoc.SetPageSize(val.Rotate());
						myratio = (num4 - Module1.G_ruler.ConvertToPointFromMM(_margin.Left) - Module1.G_ruler.ConvertToPointFromMM(_margin.Right)) / totalwidth;
					}
					else
					{
						Rectangle pageSize2 = new Rectangle(0f, 0f, num3, num4);
						mydoc.SetMargins(Module1.G_ruler.ConvertToPointFromMM(_margin.Left), Module1.G_ruler.ConvertToPointFromMM(_margin.Right), Module1.G_ruler.ConvertToPointFromMM(_margin.Top), Module1.G_ruler.ConvertToPointFromMM(_margin.Bottom));
						mydoc.SetPageSize(pageSize2);
						myratio = (num3 - Module1.G_ruler.ConvertToPointFromMM(_margin.Left) - Module1.G_ruler.ConvertToPointFromMM(_margin.Right)) / totalwidth;
					}
				}
				int num5 = 0;
				int num6 = dGVColWidth.Length - 1;
				for (int j = num5; j <= num6; j++)
				{
					array[j] *= myratio;
				}
				mydoc.NewPage();
				if (titlefont == null)
				{
					titlefont = new Font("黑体", 18f, FontStyle.Bold);
				}
				if (title != null && Operators.CompareString(title, "", TextCompare: false) != 0)
				{
					Paragraph val2 = new Paragraph(title, GetPDFFont(titlefont));
					val2.Alignment = 1;
					val2.SpacingAfter = 5f;
					val2.SpacingBefore = 0f;
					mydoc.Add((IElement)(object)val2);
				}
				if (Operators.CompareString(tableheader, "", TextCompare: false) != 0)
				{
					if (tableheaderfont == null)
					{
						tableheaderfont = new Font("宋体", 12f);
					}
					Paragraph val3 = new Paragraph(tableheader, GetPDFFont(tableheaderfont));
					val3.SpacingAfter = 5f;
					mydoc.Add((IElement)(object)val3);
				}
				Module1.G_CancelExportDGVToExcel = false;
				if (isshowprogress)
				{
					progressexcel.ProgressBar1.Maximum = dgv.RowCount;
					progressexcel.Label1.Text = "正导出表头，请稍侯……";
					Application.DoEvents();
				}
				PdfPTable val4 = new PdfPTable(GetDGVVisibleCols(dgv));
				val4.SetWidths(array);
				if (dgv.ColumnHeadersVisible)
				{
					AddHead(dgv, tv, val4);
				}
				int num7 = 0;
				int num8 = dgv.RowCount - 1;
				for (int k = num7; k <= num8; k++)
				{
					if (isshowprogress)
					{
						progressexcel.Label1.Text = "正在导出第〖" + Conversions.ToString(k + 1) + "〗条记录，共〖" + Conversions.ToString(dgv.RowCount) + "〗条记录，已完成〖" + Strings.Format((double)(k + 1) / (double)dgv.RowCount, "###.##%") + "〗";
						progressexcel.ProgressBar1.Value = k + 1;
						Application.DoEvents();
						if (Module1.G_CancelExportDGVToExcel)
						{
							break;
						}
					}
					if (dgv.Rows[k].Visible)
					{
						AddRow(dgv, k, val4);
					}
				}
				if (isshowprogress)
				{
					progressexcel.Close();
					progressexcel.Dispose();
				}
				val4.WidthPercentage = 100f;
				mydoc.Add((IElement)(object)val4);
				if (Operators.CompareString(tablefooter, "", TextCompare: false) != 0)
				{
					if (tablefooterfont == null)
					{
						tablefooterfont = new Font("宋体", 12f);
					}
					Paragraph val5 = new Paragraph(tablefooter, GetPDFFont(tablefooterfont));
					val5.SpacingAfter = 5f;
					mydoc.Add((IElement)(object)val5);
				}
				mydoc.Close();
				((DocWriter)mywriter).Dispose();
				mywriter = null;
				mydoc.Dispose();
				mydoc = null;
			}
		}

		private int[] GetDGVColWidth(DataGridView dgv, ref float totalwidth)
		{
			totalwidth = 0f;
			if (dgv == null)
			{
				return null;
			}
			int columnCount = dgv.ColumnCount;
			checked
			{
				int[] array = new int[columnCount - 1 + 1];
				int[] array2 = new int[columnCount - 1 + 1];
				int num = 0;
				int num2 = columnCount - 1;
				for (int i = num; i <= num2; i++)
				{
					array[i] = i;
					array2[i] = dgv.Columns[i].DisplayIndex;
				}
				Array.Sort(array2, array);
				int dGVVisibleCols = GetDGVVisibleCols(dgv);
				if (dGVVisibleCols == 0)
				{
					return null;
				}
				int num3 = 0;
				int[] array3 = new int[dGVVisibleCols - 1 + 1];
				int num4 = 0;
				int num5 = columnCount - 1;
				for (int j = num4; j <= num5; j++)
				{
					if (dgv.Columns[array[j]].Visible)
					{
						array3[num3] = dgv.Columns[array[j]].Width;
						totalwidth += array3[num3];
						num3++;
					}
				}
				return array3;
			}
		}

		private int GetDGVVisibleCols(DataGridView dgv)
		{
			if (dgv == null)
			{
				return 0;
			}
			int num = 0;
			int num2 = 0;
			checked
			{
				int num3 = dgv.ColumnCount - 1;
				for (int i = num2; i <= num3; i++)
				{
					if (dgv.Columns[i].Visible)
					{
						num++;
					}
				}
				return num;
			}
		}

		private Font GetPDFFont(Font f)
		{
			if (f == null)
			{
				return null;
			}
			float size = f.Size;
			int num = 0;
			if (f.Bold)
			{
				num |= 1;
			}
			if (f.Italic)
			{
				num |= 2;
			}
			if (f.Underline)
			{
				num |= 4;
			}
			if (f.Strikeout)
			{
				num |= 8;
			}
			return GetPDFFont(f.Name, size, num);
		}

		private Font GetPDFFont(Font f, Color cc)
		{
			if (f == null)
			{
				return null;
			}
			float size = f.Size;
			int num = 0;
			if (f.Bold)
			{
				num |= 1;
			}
			if (f.Italic)
			{
				num |= 2;
			}
			if (f.Underline)
			{
				num |= 4;
			}
			if (f.Strikeout)
			{
				num |= 8;
			}
			return GetPDFFont(f.Name, size, num, GetPDFColor(cc));
		}

		private Font GetPDFFont(string fontname, float size, int style)
		{
			return FontFactory.GetFont(fontname, "Identity-H", false, size, style);
		}

		private Font GetPDFFont(string fontname, float size, int style, BaseColor cc)
		{
			return FontFactory.GetFont(fontname, "Identity-H", false, size, style, cc);
		}

		private void AddHead(DataGridView dgv, PdfPTable tb)
		{
			//IL_010e: Unknown result type (might be due to invalid IL or missing references)
			//IL_0115: Expected O, but got Unknown
			//IL_0117: Unknown result type (might be due to invalid IL or missing references)
			//IL_011e: Expected O, but got Unknown
			if (dgv == null || dgv.ColumnCount <= 0)
			{
				return;
			}
			int columnCount = dgv.ColumnCount;
			checked
			{
				int[] array = new int[columnCount - 1 + 1];
				int[] array2 = new int[columnCount - 1 + 1];
				int num = 0;
				int num2 = columnCount - 1;
				for (int i = num; i <= num2; i++)
				{
					array[i] = i;
					array2[i] = dgv.Columns[i].DisplayIndex;
				}
				Array.Sort(array2, array);
				int num3 = 0;
				int num4 = dgv.ColumnCount - 1;
				for (int j = num3; j <= num4; j++)
				{
					if (dgv.Columns[array[j]].Visible)
					{
						_ = dgv.Columns[array[j]].Width;
						Font dGVHeaderFont = Module1.GetDGVHeaderFont(dgv.Columns[array[j]]);
						Color dGVHeaderForeColor = Module1.GetDGVHeaderForeColor(dgv.Columns[array[j]]);
						Color dGVHeaderBackColor = Module1.GetDGVHeaderBackColor(dgv.Columns[array[j]]);
						Phrase val = new Phrase(dgv.Columns[array[j]].HeaderText, GetPDFFont(dGVHeaderFont, dGVHeaderForeColor));
						PdfPCell val2 = new PdfPCell(val);
						val2.Padding = 1f;
						((Rectangle)val2).BorderColor = GetPDFColor(dgv.GridColor);
						val2.HorizontalAlignment = 1;
						val2.VerticalAlignment = 5;
						((Rectangle)val2).BackgroundColor = GetPDFColor(dGVHeaderBackColor);
						if (myratio >= 1f)
						{
							val2.FixedHeight = Module1.G_ruler.ConvertToPoint(dgv.ColumnHeadersHeight, isx: false);
						}
						else
						{
							val2.MinimumHeight = Module1.G_ruler.ConvertToPoint(dgv.ColumnHeadersHeight, isx: false);
						}
						tb.AddCell(val2);
					}
				}
			}
		}

		private void AddHead(DataGridView dgv, TreeView tv, PdfPTable tb)
		{
			if (dgv == null)
			{
				return;
			}
			if (tv == null)
			{
				if (RepeatHeader)
				{
					tb.HeaderRows = 1;
				}
				AddHead(dgv, tb);
				return;
			}
			checked
			{
				float[] array = new float[dgv.ColumnCount - 1 + 1];
				int num = 0;
				int num2 = dgv.ColumnCount - 1;
				for (int i = num; i <= num2; i++)
				{
					array[i] = dgv.Columns[i].Width;
				}
				mytree mytree = new mytree(tv, dgv, array);
				int leves = mytree.GetLeves();
				if (mytree.GetColumns() != dgv.ColumnCount)
				{
					if (RepeatHeader)
					{
						tb.HeaderRows = 1;
					}
					AddHead(dgv, tb);
				}
				else
				{
					if (RepeatHeader)
					{
						tb.HeaderRows = leves;
					}
					int num3 = 1;
					int num4 = leves;
					for (int j = num3; j <= num4; j++)
					{
						AddHead(dgv, mytree, j, tb);
					}
				}
				mytree.Dispose();
			}
		}

		private void AddHead(DataGridView dgv, mytree myheader, int curlevel, PdfPTable tb)
		{
			//IL_01b8: Unknown result type (might be due to invalid IL or missing references)
			//IL_01bf: Expected O, but got Unknown
			//IL_01c1: Unknown result type (might be due to invalid IL or missing references)
			//IL_01c8: Expected O, but got Unknown
			if (dgv == null || dgv.ColumnCount <= 0)
			{
				return;
			}
			int columnCount = dgv.ColumnCount;
			checked
			{
				int[] array = new int[columnCount - 1 + 1];
				int[] array2 = new int[columnCount - 1 + 1];
				int num = 0;
				int num2 = columnCount - 1;
				for (int i = num; i <= num2; i++)
				{
					array[i] = i;
					array2[i] = dgv.Columns[i].DisplayIndex;
				}
				Array.Sort(array2, array);
				int num3 = (int)Math.Round((double)dgv.ColumnHeadersHeight / (double)myheader.GetLeves());
				int num4 = 0;
				int num5 = dgv.ColumnCount - 1;
				bool flag = true;
				for (int j = num4; j <= num5; j++)
				{
					if (!dgv.Columns[array[j]].Visible)
					{
						continue;
					}
					int num6 = myheader.GetCellHeightLevels(array[j], curlevel, isTopNodeFill: false, out flag);
					int cellWidthCols = myheader.GetCellWidthCols(array[j], curlevel);
					if (unchecked(num6 == 0 || cellWidthCols == 0))
					{
						if (num6 != 0)
						{
						}
						continue;
					}
					string nodeText = myheader.GetNodeText(array[j], curlevel);
					Font font = myheader.GetNodeFont(array[j], curlevel);
					if (font == null)
					{
						font = Module1.GetDGVHeaderFont(dgv.Columns[array[j]]);
					}
					Color cc = myheader.GetNodeForeColor(array[j], curlevel);
					if (cc.IsEmpty)
					{
						cc = Module1.GetDGVHeaderForeColor(dgv.Columns[array[j]]);
					}
					Color cc2 = myheader.GetNodeBackColor(array[j], curlevel);
					if (cc2.IsEmpty)
					{
						cc2 = Module1.GetDGVHeaderBackColor(dgv.Columns[array[j]]);
					}
					if (unchecked(cellWidthCols == 1 && num6 == 1))
					{
						_ = dgv.Columns[array[j]].Width;
					}
					else
					{
						_ = (int)Math.Round(myheader.GetCellWidth2(array[j], curlevel));
					}
					Phrase val = new Phrase(nodeText, GetPDFFont(font, cc));
					PdfPCell val2 = new PdfPCell(val);
					if (cellWidthCols != 0)
					{
						val2.Colspan = cellWidthCols;
					}
					if (num6 != 0)
					{
						val2.Rowspan = num6;
					}
					val2.Padding = 1f;
					((Rectangle)val2).BorderColor = GetPDFColor(dgv.GridColor);
					val2.HorizontalAlignment = 1;
					val2.VerticalAlignment = 5;
					((Rectangle)val2).BackgroundColor = GetPDFColor(cc2);
					if (num6 <= 0)
					{
						num6 = 1;
					}
					if (myratio >= 1f)
					{
						val2.FixedHeight = Module1.G_ruler.ConvertToPoint(num3 * num6, isx: false);
					}
					else
					{
						val2.MinimumHeight = Module1.G_ruler.ConvertToPoint(num3 * num6, isx: false);
					}
					tb.AddCell(val2);
				}
			}
		}

		private void AddRow(DataGridView dgv, int rowindex, PdfPTable tb)
		{
			//IL_0750: Unknown result type (might be due to invalid IL or missing references)
			//IL_0757: Expected O, but got Unknown
			//IL_0759: Unknown result type (might be due to invalid IL or missing references)
			//IL_0760: Expected O, but got Unknown
			//IL_065a: Unknown result type (might be due to invalid IL or missing references)
			//IL_0661: Expected O, but got Unknown
			//IL_0602: Unknown result type (might be due to invalid IL or missing references)
			//IL_0609: Expected O, but got Unknown
			//IL_05f6: Unknown result type (might be due to invalid IL or missing references)
			//IL_05fd: Expected O, but got Unknown
			//IL_0536: Unknown result type (might be due to invalid IL or missing references)
			//IL_053d: Expected O, but got Unknown
			if (dgv == null || dgv.RowCount <= 0 || rowindex >= dgv.RowCount || dgv.ColumnCount <= 0 || !dgv.Rows[rowindex].Visible)
			{
				return;
			}
			int columnCount = dgv.ColumnCount;
			checked
			{
				int[] array = new int[columnCount - 1 + 1];
				int[] array2 = new int[columnCount - 1 + 1];
				int num = 0;
				int num2 = columnCount - 1;
				for (int i = num; i <= num2; i++)
				{
					array[i] = i;
					array2[i] = dgv.Columns[i].DisplayIndex;
				}
				Array.Sort(array2, array);
				int height = dgv.Rows[rowindex].Height;
				int num3 = 1;
				int num4 = 0;
				int num5 = 0;
				int num6 = 0;
				int num7 = 0;
				int num8 = 1;
				int num9 = 0;
				int num10 = dgv.ColumnCount - 1;
				for (int j = num9; j <= num10; j++)
				{
					if (!dgv.Columns[array[j]].Visible)
					{
						continue;
					}
					num8 = 1;
					num3 = 1;
					num6 = 0;
					num4 = 0;
					num7 = 0;
					num6 = 0;
					num4 = 0;
					num5 = 0;
					float myheight = height;
					string text = Conversions.ToString(dgv.Rows[rowindex].Cells[array[j]].Tag);
					int num11 = 0;
					int firstrow = 0;
					int firstr = 0;
					switch (text)
					{
						default:
							{
								int firstcolumn = 0;
								int firstc = 0;
								switch (text)
								{
									default:
										num8 = 1;
										num3 = 1;
										num11 = dgv.Columns[array[j]].Width;
										break;
									case "合并":
									case "左上合并":
									case "左下合并":
									case "右上合并":
									case "右下合并":
									case "上边合并":
									case "下边合并":
									case "左边合并":
									case "右边合并":
										{
											float mywidth = 0f;
											mymerge.GetHVMergeWidthAndHeight(dgv, array[j], rowindex, ref mywidth, ref myheight, ref num7, ref num6, ref num4, ref num5, ref firstcolumn, ref firstrow, ref firstc, ref firstr);
											num8 = num6 + num7 + 1;
											num3 = num4 + num5 + 1;
											num11 = (int)Math.Round(mywidth);
											unchecked
											{
												if (num3 > 1 && num8 > 1)
												{
													if (!(num4 == 0 && num6 == 0))
													{
														if (num6 != 0)
														{
														}
														continue;
													}
												}
												else if (num3 > 1)
												{
													if (num4 != 0)
													{
														continue;
													}
												}
												else if (num8 > 1 && num6 != 0)
												{
													continue;
												}
												break;
											}
										}
									case "水平合并":
									case "#水平合并#":
									case "左合并":
									case "右合并":
										num11 = (int)Math.Round(mymerge.GetHMergeWidth(dgv, array[j], rowindex, ref num8, ref num6, ref num7, ref firstcolumn, ref firstc, iscancheckheight: true));
										if (num8 > 1 && num6 != 0)
										{
											continue;
										}
										break;
								}
								break;
							}
						case "垂直合并":
						case "#垂直合并#":
						case "上合并":
						case "下合并":
							myheight = mymerge.GetVMergeHeight(dgv, array[j], rowindex, ref num3, ref num5, ref num4, ref firstrow, ref firstr);
							num11 = dgv.Columns[array[j]].Width;
							if (num3 > 1 && num4 != 0)
							{
								continue;
							}
							break;
					}
					Font dGVCellFont = Module1.GetDGVCellFont(dgv.Rows[rowindex].Cells[array[j]]);
					Color dGVCellBackColor = Module1.GetDGVCellBackColor(dgv.Rows[rowindex].Cells[array[j]]);
					Color dGVCellForeColor = Module1.GetDGVCellForeColor(dgv.Rows[rowindex].Cells[array[j]]);
					Margins dGVCellPadding = Module1.GetDGVCellPadding(dgv.Rows[rowindex].Cells[j]);
					PdfPCell val;
					if (dgv.Columns[array[j]] is DataGridViewImageColumn)
					{
						if (dgv.Rows[rowindex].Cells[array[j]].Value != null)
						{
							if (dgv.Rows[rowindex].Cells[array[j]].FormattedValue != null)
							{
								Image instance = Image.GetInstance((Image)dgv.Rows[rowindex].Cells[array[j]].FormattedValue, BaseColor.WHITE);
								DataGridViewImageCell dataGridViewImageCell = (DataGridViewImageCell)dgv.Rows[rowindex].Cells[array[j]];
								DataGridViewImageCellLayout imageLayout = dataGridViewImageCell.ImageLayout;
								if (imageLayout == DataGridViewImageCellLayout.Stretch)
								{
									if (myratio >= 1f)
									{
										instance.ScaleAbsolute(Module1.G_ruler.ConvertToPoint(num11 - 1, isx: true) * myratio, Module1.G_ruler.ConvertToPoint(myheight - 1f, isx: false));
									}
									else
									{
										instance.ScaleAbsoluteWidth(Module1.G_ruler.ConvertToPoint(num11, isx: true) * myratio);
									}
								}
								else
								{
									instance.ScaleToFit(Module1.G_ruler.ConvertToPoint(num11, isx: true) * myratio, Module1.G_ruler.ConvertToPoint(myheight, isx: false));
								}
								val = new PdfPCell(instance);
								val.PaddingLeft = Module1.G_ruler.ConvertToPoint(dGVCellPadding.Left, isx: true);
								val.PaddingRight = Module1.G_ruler.ConvertToPoint(dGVCellPadding.Right, isx: true);
								val.PaddingBottom = Module1.G_ruler.ConvertToPoint(dGVCellPadding.Bottom, isx: false);
								val.PaddingTop = Module1.G_ruler.ConvertToPoint(dGVCellPadding.Top, isx: false);
								if ((val.PaddingRight == 0f) & (val.PaddingLeft == 0f) & (val.PaddingBottom == 0f) & (val.PaddingTop == 0f))
								{
									val.Padding = 0.5f;
								}
							}
							else
							{
								val = new PdfPCell();
							}
						}
						else
						{
							val = new PdfPCell();
						}
					}
					else if (dgv.Columns[array[j]] is DataGridViewCheckBoxColumn)
					{
						Bitmap dGVCheckBoxCellImage = Module1.getDGVCheckBoxCellImage(dgv.Rows[rowindex].Cells[array[j]], dGVCellBackColor);
						Image instance2 = Image.GetInstance((Image)dGVCheckBoxCellImage, BaseColor.WHITE);
						val = new PdfPCell(instance2);
						val.PaddingLeft = Module1.G_ruler.ConvertToPoint(dGVCellPadding.Left, isx: true);
						val.PaddingRight = Module1.G_ruler.ConvertToPoint(dGVCellPadding.Right, isx: true);
						val.PaddingBottom = Module1.G_ruler.ConvertToPoint(dGVCellPadding.Bottom, isx: false);
						val.PaddingTop = Module1.G_ruler.ConvertToPoint(dGVCellPadding.Top, isx: false);
						if ((val.PaddingRight == 0f) & (val.PaddingLeft == 0f) & (val.PaddingBottom == 0f) & (val.PaddingTop == 0f))
						{
							val.Padding = 0.5f;
						}
						dGVCheckBoxCellImage.Dispose();
					}
					else
					{
						string text2 = Conversions.ToString(dgv.Rows[rowindex].Cells[array[j]].FormattedValue);
						Phrase val2 = new Phrase(text2, GetPDFFont(dGVCellFont, dGVCellForeColor));
						val = new PdfPCell(val2);
						val.PaddingLeft = Module1.G_ruler.ConvertToPoint(dGVCellPadding.Left, isx: true);
						val.PaddingRight = Module1.G_ruler.ConvertToPoint(dGVCellPadding.Right, isx: true);
						val.PaddingBottom = Module1.G_ruler.ConvertToPoint(dGVCellPadding.Bottom, isx: false);
						val.PaddingTop = Module1.G_ruler.ConvertToPoint(dGVCellPadding.Top, isx: false);
					}
					((Rectangle)val).BorderColor = GetPDFColor(dgv.GridColor);
					if (myratio >= 1f)
					{
						val.FixedHeight = Module1.G_ruler.ConvertToPoint(myheight, isx: false);
					}
					else
					{
						val.MinimumHeight = Module1.G_ruler.ConvertToPoint(myheight, isx: false);
					}
					((Rectangle)val).BackgroundColor = GetPDFColor(dGVCellBackColor);
					val.Rowspan = num3;
					val.Colspan = num8;
					DataGridViewContentAlignment alignment = Module1.GetDGVCellStyle(dgv.Rows[rowindex].Cells[array[j]]).Alignment;
					if (alignment != DataGridViewContentAlignment.BottomCenter && alignment != DataGridViewContentAlignment.BottomLeft && alignment != DataGridViewContentAlignment.BottomRight)
					{
						if (alignment != DataGridViewContentAlignment.MiddleCenter && alignment != DataGridViewContentAlignment.MiddleLeft && alignment != DataGridViewContentAlignment.MiddleRight && alignment != 0)
						{
							val.VerticalAlignment = 4;
						}
						else
						{
							val.VerticalAlignment = 5;
						}
					}
					else
					{
						val.VerticalAlignment = 6;
					}
					DataGridViewContentAlignment alignment2 = Module1.GetDGVCellStyle(dgv.Rows[rowindex].Cells[array[j]]).Alignment;
					if (alignment2 != DataGridViewContentAlignment.BottomLeft && alignment2 != DataGridViewContentAlignment.MiddleLeft && alignment2 != DataGridViewContentAlignment.TopLeft && alignment2 != 0)
					{
						if (alignment2 != DataGridViewContentAlignment.BottomCenter && alignment2 != DataGridViewContentAlignment.MiddleCenter && alignment2 != DataGridViewContentAlignment.TopCenter)
						{
							val.HorizontalAlignment = 2;
						}
						else
						{
							val.HorizontalAlignment = 1;
						}
					}
					else
					{
						val.HorizontalAlignment = 0;
					}
					tb.AddCell(val);
				}
			}
		}

		private static BaseColor GetPDFColor(Color cc)
		{
			//IL_0001: Unknown result type (might be due to invalid IL or missing references)
			//IL_0007: Expected O, but got Unknown
			return new BaseColor(cc);
		}
	*/
	}
}