From f2b71fe1d3c2b7651d525a5b5bbe66fad602ea06 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 09 九月 2025 18:46:28 +0800
Subject: [PATCH] 代码清理
---
WebApi/Gs.Toolbox/ExcelHelper.cs | 572 +++++++++++++++++++++++++++++---------------------------
1 files changed, 299 insertions(+), 273 deletions(-)
diff --git a/WebApi/Gs.Toolbox/ExcelHelper.cs b/WebApi/Gs.Toolbox/ExcelHelper.cs
index b654eb7..7378881 100644
--- a/WebApi/Gs.Toolbox/ExcelHelper.cs
+++ b/WebApi/Gs.Toolbox/ExcelHelper.cs
@@ -1,15 +1,11 @@
锘縰sing System.Collections;
using System.Data;
using System.Text;
-using System.Timers;
-using Masuit.Tools;
using NPOI.HSSF.UserModel;
using NPOI.HSSF.Util;
-using NPOI.SS.Formula.Functions;
using NPOI.SS.UserModel;
using NPOI.SS.Util;
using NPOI.XSSF.UserModel;
-
namespace Gs.Toolbox;
@@ -37,12 +33,12 @@
arrColWidth[item.Ordinal] = Encoding.GetEncoding(936)
.GetBytes(item.ColumnName).Length;
for (var i = 0; i < dtSource.Rows.Count; i++)
- for (var j = 0; j < dtSource.Columns.Count; j++)
- {
- var intTemp = Encoding.GetEncoding(936)
- .GetBytes(dtSource.Rows[i][j].ToString()).Length;
- if (intTemp > arrColWidth[j]) arrColWidth[j] = intTemp;
- }
+ for (var j = 0; j < dtSource.Columns.Count; j++)
+ {
+ var intTemp = Encoding.GetEncoding(936)
+ .GetBytes(dtSource.Rows[i][j].ToString()).Length;
+ if (intTemp > arrColWidth[j]) arrColWidth[j] = intTemp;
+ }
var rowIndex = 0;
foreach (DataRow row in dtSource.Rows)
@@ -186,12 +182,12 @@
.GetBytes(item.ColumnName).Length;
if (fixW <= 0)
for (var i = 0; i < dtSource.Rows.Count; i++)
- for (var j = 0; j < dtSource.Columns.Count; j++)
- {
- var intTemp = Encoding.GetEncoding(936)
- .GetBytes(dtSource.Rows[i][j].ToString()).Length;
- if (intTemp > arrColWidth[j]) arrColWidth[j] = intTemp;
- }
+ for (var j = 0; j < dtSource.Columns.Count; j++)
+ {
+ var intTemp = Encoding.GetEncoding(936)
+ .GetBytes(dtSource.Rows[i][j].ToString()).Length;
+ if (intTemp > arrColWidth[j]) arrColWidth[j] = intTemp;
+ }
var cusRow = sheet.CreateRow(0);
var _rr = 0;
@@ -299,7 +295,6 @@
}
/// <summary>
- ///
/// </summary>
/// <param name="workbook"></param>
/// <param name="fontSize">瀛椾綋澶у皬</param>
@@ -307,64 +302,68 @@
/// <param name="isCenter">鏄惁涓棿</param>
/// <param name="border">鏄惁杈规</param>
/// <returns></returns>
- private static ICellStyle getStyle(HSSFWorkbook workbook, double fontSize = 11, bool isBold = false, bool isCenter = false, bool border = true)
+ private static ICellStyle getStyle(HSSFWorkbook workbook,
+ double fontSize = 11, bool isBold = false, bool isCenter = false,
+ bool border = true)
{
- IFont font = workbook.CreateFont();
+ var font = workbook.CreateFont();
font.FontName = "瀹嬩綋";
font.FontHeightInPoints = fontSize;
- if (isBold == true)
+ if (isBold)
font.Boldweight = (short)FontBoldWeight.Bold;
// 鍒涘缓鍗曞厓鏍兼牱寮� - 甯﹁竟妗嗗拰鎸囧畾瀛椾綋
- ICellStyle style = workbook.CreateCellStyle();
+ var style = workbook.CreateCellStyle();
style.SetFont(font);
- if (border == true)
+ if (border)
{
style.BorderTop = BorderStyle.Thin;
style.BorderBottom = BorderStyle.Thin;
style.BorderLeft = BorderStyle.Thin;
style.BorderRight = BorderStyle.Thin;
}
- if (isCenter == true)
+
+ if (isCenter)
style.Alignment = HorizontalAlignment.Center;
style.VerticalAlignment = VerticalAlignment.Center;
return style;
}
/// <summary>
- /// 璁剧疆鍗曞厓鏍肩殑鍊�
+ /// 璁剧疆鍗曞厓鏍肩殑鍊�
/// </summary>
/// <param name="sheet"></param>
/// <param name="rowIdx"></param>
/// <param name="colIdx"></param>
/// <param name="val"></param>
- private static void setCellVal(ISheet sheet, int rowIdx, int colIdx, string val)
+ private static void setCellVal(ISheet sheet, int rowIdx, int colIdx,
+ string val)
{
- IRow row = sheet.GetRow(rowIdx) ?? sheet.CreateRow(rowIdx);
- ICell cell = row.GetCell(colIdx) ?? row.CreateCell(colIdx);
+ var row = sheet.GetRow(rowIdx) ?? sheet.CreateRow(rowIdx);
+ var cell = row.GetCell(colIdx) ?? row.CreateCell(colIdx);
cell.SetCellValue(val); // 鍙互璁剧疆瀛楃涓层�佹暟瀛楃瓑绫诲瀷鐨勬暟鎹�
-
}
+
/// <summary>
- /// 鐢熸垚棣栨
+ /// 鐢熸垚棣栨
/// </summary>
/// <param name="dtSource"></param>
public static void ExportShouJian(DataSet dtSource, string strFileName)
{
//琛岄珮
- int rowHeight = 25;
+ var rowHeight = 25;
//鎬�7鍒�
- int maxCols = 7;
+ var maxCols = 7;
// 鍒涘缓宸ヤ綔绨�
- HSSFWorkbook workbook = new HSSFWorkbook();
- ISheet sheet = workbook.CreateSheet("Sheet1");
+ var workbook = new HSSFWorkbook();
+ var sheet = workbook.CreateSheet("Sheet1");
// 鍒涘缓鍗曞厓鏍兼牱寮� - 甯﹁竟妗嗗拰鎸囧畾瀛椾綋
- ICellStyle style = getStyle(workbook);
- ICellStyle styleHeader = getStyle(workbook, 20, true, true);
- ICellStyle style12 = getStyle(workbook, 11, false, true);
+ var style = getStyle(workbook);
+ var styleHeader = getStyle(workbook, 20, true, true);
+ var style12 = getStyle(workbook, 11, false, true);
// 璁剧疆鍒楀锛�6鍒楋級
- sheet.SetColumnWidth(0, 4000); // 绗竴鍒楃◢瀹�
+ sheet.SetColumnWidth(0, 4000); // 绗竴鍒楃◢瀹�
sheet.SetColumnWidth(1, 3000);
sheet.SetColumnWidth(2, 3000);
sheet.SetColumnWidth(3, 3000);
@@ -372,24 +371,25 @@
sheet.SetColumnWidth(5, 3000);
sheet.SetColumnWidth(6, 3000);
// 鍒涘缓20琛�
- for (int rowIndex = 0; rowIndex <= 6; rowIndex++)
+ for (var rowIndex = 0; rowIndex <= 6; rowIndex++)
{
- IRow row = sheet.CreateRow(rowIndex);
+ var row = sheet.CreateRow(rowIndex);
// 璁剧疆琛岄珮锛堟墍鏈夎鐩稿悓楂樺害锛�
row.HeightInPoints = rowHeight;
// 鍒涘缓6涓崟鍏冩牸
- for (int colIndex = 0; colIndex < maxCols; colIndex++)
+ for (var colIndex = 0; colIndex < maxCols; colIndex++)
{
- ICell cell = row.CreateCell(colIndex);
+ var cell = row.CreateCell(colIndex);
if (rowIndex == 0)
cell.CellStyle = styleHeader;
else
cell.CellStyle = style;
}
}
+
//杩欐槸琛ㄥご
- DataTable tb0 = dtSource.Tables[0];
- DataRow row0 = tb0.Rows[0];
+ var tb0 = dtSource.Tables[0];
+ var row0 = tb0.Rows[0];
// 1. 绗竴琛屽垪鍚堝苟
sheet.AddMergedRegion(new CellRangeAddress(0, 0, 0, 6));
// 2. 绗簩琛屽垪鍚堝苟
@@ -424,25 +424,22 @@
setCellVal(sheet, 5, 5, "鐢熶骇鏃ユ湡");
setCellVal(sheet, 5, 6, row0["scrq"].ToString());
string[] ary = { "椤圭洰", "鎶�鏈�/鍝佽川瑕佹眰", "娴嬭瘯鏁版嵁", "妫�楠岀粨鏋�", "A", "B", "C" };
- for (int i = 0; i < ary.Length; i++)
- {
- setCellVal(sheet, 6, i, ary[i]);
- }
+ for (var i = 0; i < ary.Length; i++) setCellVal(sheet, 6, i, ary[i]);
//浠庣7琛屽紑濮嬶紝灏辨槸寰幆鏁版嵁搴�
- int _idx = 7;
- DataTable tb1 = dtSource.Tables[1];
- string dd = "";
- bool _blPscs = false;
- bool _blGjyzx = false;
+ var _idx = 7;
+ var tb1 = dtSource.Tables[1];
+ var dd = "";
+ var _blPscs = false;
+ var _blGjyzx = false;
foreach (DataRow rrr in tb1.Rows)
{
//澧炲姞鍝佹按娴嬭瘯鏍囬
- if (_blPscs == false && rrr["椤圭洰"].ToString() == "鍝佹按娴嬭瘯")
+ if (!_blPscs && rrr["椤圭洰"].ToString() == "鍝佹按娴嬭瘯")
{
- IRow row700 = sheet.CreateRow(_idx);
- for (int i = 0; i < ary.Length; i++)
+ var row700 = sheet.CreateRow(_idx);
+ for (var i = 0; i < ary.Length; i++)
{
- ICell cell700 = row700.CreateCell(i);
+ var cell700 = row700.CreateCell(i);
cell700.CellStyle = style;
if (i == 0)
cell700.SetCellValue(rrr["椤圭洰"].ToString());
@@ -455,18 +452,20 @@
if (i == 6)
cell700.SetCellValue("妫�楠岀粨鏋�");
}
+
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 2));
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 3, 4));
_idx++;
_blPscs = true;
}
+
//澧炲姞鏍囬
- if (_blGjyzx == false && rrr["椤圭洰"].ToString() == "鍏抽敭閮ㄤ欢涓�鑷存��")
+ if (!_blGjyzx && rrr["椤圭洰"].ToString() == "鍏抽敭閮ㄤ欢涓�鑷存��")
{
- IRow row700 = sheet.CreateRow(_idx);
- for (int i = 0; i < ary.Length; i++)
+ var row700 = sheet.CreateRow(_idx);
+ for (var i = 0; i < ary.Length; i++)
{
- ICell cell700 = row700.CreateCell(i);
+ var cell700 = row700.CreateCell(i);
cell700.CellStyle = style;
if (i == 0)
cell700.SetCellValue(rrr["椤圭洰"].ToString());
@@ -483,32 +482,36 @@
if (i == 6)
cell700.SetCellValue("鎿嶄綔");
}
+
_idx++;
_blGjyzx = true;
}
- IRow row7 = sheet.CreateRow(_idx);
+ var row7 = sheet.CreateRow(_idx);
row7.HeightInPoints = rowHeight;
- string _tmphb = rrr["椤圭洰鍚堝苟琛屾暟"].ToString();
- string _tmp = "";
+ var _tmphb = rrr["椤圭洰鍚堝苟琛屾暟"].ToString();
+ var _tmp = "";
if (dd == rrr["椤圭洰"].ToString())
_tmp = "";
else
_tmp = rrr["椤圭洰"].ToString();
dd = rrr["椤圭洰"].ToString();
- for (int i = 0; i < ary.Length; i++)
+ for (var i = 0; i < ary.Length; i++)
{
- ICell cell7 = row7.CreateCell(i);
+ var cell7 = row7.CreateCell(i);
cell7.CellStyle = style;
if (i == 0)
{
cell7.SetCellValue(_tmp);
if (!string.IsNullOrEmpty(_tmp) && int.Parse(_tmphb) > 1)
{
- if (rrr["椤圭洰"].ToString() == "鍝佹按娴嬭瘯" || rrr["椤圭洰"].ToString() == "鍏抽敭閮ㄤ欢涓�鑷存��" )
- sheet.AddMergedRegion(new CellRangeAddress(_idx-1, _idx + int.Parse(_tmphb)-1, 0, 0));
+ if (rrr["椤圭洰"].ToString() == "鍝佹按娴嬭瘯" ||
+ rrr["椤圭洰"].ToString() == "鍏抽敭閮ㄤ欢涓�鑷存��")
+ sheet.AddMergedRegion(new CellRangeAddress(_idx - 1,
+ _idx + int.Parse(_tmphb) - 1, 0, 0));
else
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx + int.Parse(_tmphb) - 1, 0, 0));
+ sheet.AddMergedRegion(new CellRangeAddress(_idx,
+ _idx + int.Parse(_tmphb) - 1, 0, 0));
}
}
else
@@ -519,7 +522,8 @@
cell7.SetCellValue(rrr["鍒剁儹鎬ц兘table"].ToString());
row7.HeightInPoints = rowHeight * 5;
if (i == ary.Length - 1)
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 6));
+ sheet.AddMergedRegion(
+ new CellRangeAddress(_idx, _idx, 1, 6));
break;
case "鍝佹按娴嬭瘯":
//搴︽暟
@@ -533,9 +537,12 @@
cell7.SetCellValue(rrr["妫�楠岀粨鏋�"].ToString());
if (i == ary.Length - 1)
{
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 2));
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 3, 4));
+ sheet.AddMergedRegion(
+ new CellRangeAddress(_idx, _idx, 1, 2));
+ sheet.AddMergedRegion(
+ new CellRangeAddress(_idx, _idx, 3, 4));
}
+
break;
case "鍏抽敭閮ㄤ欢涓�鑷存��":
if (i == 1)
@@ -547,7 +554,8 @@
if (i == 4)
cell7.SetCellValue(rrr["璁よ瘉淇℃伅"].ToString());
if (i == 5)
- cell7.SetCellValue(rrr["鏄惁绗﹀悎CCC涓�鑷存��"].ToString());
+ cell7.SetCellValue(rrr["鏄惁绗﹀悎CCC涓�鑷存��"]
+ .ToString());
//if (i == 6)
// cell7.SetCellValue(rrr["妫�楠岀粨鏋�"].ToString());
break;
@@ -557,26 +565,30 @@
}
}
}
+
_idx++;
}
- IRow row8 = sheet.CreateRow(_idx);
+
+ var row8 = sheet.CreateRow(_idx);
row8.HeightInPoints = rowHeight;
- for (int colIndex = 0; colIndex < maxCols; colIndex++)
+ for (var colIndex = 0; colIndex < maxCols; colIndex++)
{
- ICell cell = row8.CreateCell(colIndex);
+ var cell = row8.CreateCell(colIndex);
cell.CellStyle = style12;
}
+
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 5));
setCellVal(sheet, _idx, 0, "缁煎悎鍒ゅ畾");
setCellVal(sheet, _idx, 1, "鍚堟牸");
_idx++;
- IRow row9 = sheet.CreateRow(_idx);
+ var row9 = sheet.CreateRow(_idx);
row9.HeightInPoints = rowHeight;
- for (int colIndex = 0; colIndex < maxCols; colIndex++)
+ for (var colIndex = 0; colIndex < maxCols; colIndex++)
{
- ICell cell = row9.CreateCell(colIndex);
+ var cell = row9.CreateCell(colIndex);
cell.CellStyle = style;
}
+
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 3));
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 4, 6));
setCellVal(sheet, _idx, 1, "宸ヨ壓 宸茬‘璁わ細鍚堟牸");
@@ -584,25 +596,27 @@
sheet.AddMergedRegion(new CellRangeAddress(_idx - 1, _idx, 0, 0));
_idx++;
- IRow row10 = sheet.CreateRow(_idx);
+ var row10 = sheet.CreateRow(_idx);
row10.HeightInPoints = rowHeight;
- for (int colIndex = 0; colIndex < maxCols; colIndex++)
+ for (var colIndex = 0; colIndex < maxCols; colIndex++)
{
- ICell cell = row10.CreateCell(colIndex);
+ var cell = row10.CreateCell(colIndex);
cell.CellStyle = style12;
}
+
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 5));
setCellVal(sheet, _idx, 0, "瀹℃牳鎰忚");
setCellVal(sheet, _idx, 1, "鍚堟牸");
_idx++;
- IRow row11 = sheet.CreateRow(_idx);
+ var row11 = sheet.CreateRow(_idx);
row11.HeightInPoints = rowHeight;
- for (int colIndex = 0; colIndex < maxCols; colIndex++)
+ for (var colIndex = 0; colIndex < maxCols; colIndex++)
{
- ICell cell = row11.CreateCell(colIndex);
+ var cell = row11.CreateCell(colIndex);
cell.CellStyle = style12;
}
+
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 0, 6));
setCellVal(sheet, _idx, 0, "棣栦欢濉啓,鏉ユ枡妫�楠�");
//****鍚堝苟濂藉悗寮�濮嬭祴鍊糴nd**************
@@ -623,26 +637,26 @@
}
/// <summary>
- /// 鐢熸垚iqc
+ /// 鐢熸垚iqc
/// </summary>
/// <param name="dtSource"></param>
public static void ExportIqc(DataSet dtSource, string strFileName)
{
//琛岄珮
- int rowHeight = 25;
+ var rowHeight = 25;
//鎬诲垪
- int maxCols = 8;
+ var maxCols = 8;
// 鍒涘缓宸ヤ綔绨�
- HSSFWorkbook workbook = new HSSFWorkbook();
- ISheet sheet = workbook.CreateSheet("Sheet1");
+ var workbook = new HSSFWorkbook();
+ var sheet = workbook.CreateSheet("Sheet1");
// 鍒涘缓鍗曞厓鏍兼牱寮� - 甯﹁竟妗嗗拰鎸囧畾瀛椾綋
- ICellStyle style = getStyle(workbook);
- ICellStyle styleHeader = getStyle(workbook, 20, true, true);
- ICellStyle style12 = getStyle(workbook, 11, false, true);
+ var style = getStyle(workbook);
+ var styleHeader = getStyle(workbook, 20, true, true);
+ var style12 = getStyle(workbook, 11, false, true);
// 璁剧疆鍒楀锛�6鍒楋級
- sheet.SetColumnWidth(0, 3000); // 绗竴鍒楃◢瀹�
+ sheet.SetColumnWidth(0, 3000); // 绗竴鍒楃◢瀹�
sheet.SetColumnWidth(1, 3000);
sheet.SetColumnWidth(2, 3000);
sheet.SetColumnWidth(3, 3000);
@@ -651,15 +665,15 @@
sheet.SetColumnWidth(6, 3000);
sheet.SetColumnWidth(7, 3000);
// 鍒涘缓9琛�
- for (int rowIndex = 0; rowIndex <= 8; rowIndex++)
+ for (var rowIndex = 0; rowIndex <= 8; rowIndex++)
{
- IRow row = sheet.CreateRow(rowIndex);
+ var row = sheet.CreateRow(rowIndex);
// 璁剧疆琛岄珮锛堟墍鏈夎鐩稿悓楂樺害锛�
row.HeightInPoints = rowHeight;
// 鍒涘缓涓崟鍏冩牸
- for (int colIndex = 0; colIndex < maxCols; colIndex++)
+ for (var colIndex = 0; colIndex < maxCols; colIndex++)
{
- ICell cell = row.CreateCell(colIndex);
+ var cell = row.CreateCell(colIndex);
if (rowIndex == 1)
cell.CellStyle = styleHeader;
else
@@ -668,9 +682,10 @@
cell.SetCellValue($"琛寋rowIndex + 1}鍒梴colIndex + 1}");
}
}
+
//杩欐槸琛ㄥご
- DataTable tb0 = dtSource.Tables[0];
- DataRow row0 = tb0.Rows[0];
+ var tb0 = dtSource.Tables[0];
+ var row0 = tb0.Rows[0];
//绗竴琛屽垪鍚堝苟
sheet.AddMergedRegion(new CellRangeAddress(0, 0, 0, 3));
sheet.AddMergedRegion(new CellRangeAddress(0, 0, 4, 7));
@@ -730,18 +745,19 @@
setCellVal(sheet, 8, 6, "妫�楠岃褰�");
setCellVal(sheet, 8, 7, "妫�楠岀粨鏋�");
////浠庣9琛屽紑濮嬶紝灏辨槸寰幆鏁版嵁搴�
- int _idx = 9;
- DataTable tb1 = dtSource.Tables[1];
+ var _idx = 9;
+ var tb1 = dtSource.Tables[1];
foreach (DataRow rrr in tb1.Rows)
{
- IRow row7 = sheet.CreateRow(_idx);
+ var row7 = sheet.CreateRow(_idx);
row7.HeightInPoints = rowHeight;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell7 = row7.CreateCell(i);
+ var cell7 = row7.CreateCell(i);
cell7.CellStyle = style;
// cell7.SetCellValue(rrr[ary[i]].ToString());
}
+
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 5));
setCellVal(sheet, _idx, 0, rrr["椤圭洰"].ToString());
setCellVal(sheet, _idx, 1, rrr["璐ㄩ噺瑕佹眰"].ToString());
@@ -749,29 +765,33 @@
setCellVal(sheet, _idx, 7, rrr["妫�楠岀粨鏋�"].ToString());
_idx++;
}
+
//澶囨敞
- IRow row8 = sheet.CreateRow(_idx);
+ var row8 = sheet.CreateRow(_idx);
row8.HeightInPoints = rowHeight;
- for (int colIndex = 0; colIndex < maxCols; colIndex++)
+ for (var colIndex = 0; colIndex < maxCols; colIndex++)
{
- ICell cell = row8.CreateCell(colIndex);
+ var cell = row8.CreateCell(colIndex);
cell.CellStyle = style12;
}
+
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 7));
setCellVal(sheet, _idx, 0, "澶囨敞锛�");
_idx++;
//缁煎悎鍒ゅ畾
- for (int i = 0; i < 2; i++)
+ for (var i = 0; i < 2; i++)
{
- IRow row9 = sheet.CreateRow(_idx);
+ var row9 = sheet.CreateRow(_idx);
row9.HeightInPoints = rowHeight;
- for (int colIndex = 0; colIndex < maxCols; colIndex++)
+ for (var colIndex = 0; colIndex < maxCols; colIndex++)
{
- ICell cell = row9.CreateCell(colIndex);
+ var cell = row9.CreateCell(colIndex);
cell.CellStyle = style;
}
+
_idx++;
}
+
sheet.AddMergedRegion(new CellRangeAddress(_idx - 2, _idx - 1, 0, 0));
sheet.AddMergedRegion(new CellRangeAddress(_idx - 2, _idx - 2, 1, 7));
sheet.AddMergedRegion(new CellRangeAddress(_idx - 1, _idx - 1, 1, 7));
@@ -779,17 +799,19 @@
setCellVal(sheet, _idx - 2, 1, row0["zhpd"].ToString());
setCellVal(sheet, _idx - 1, 1, row0["zhpdqz"].ToString());
//瀹℃牳鎰忚锛�
- for (int i = 0; i < 2; i++)
+ for (var i = 0; i < 2; i++)
{
- IRow row9 = sheet.CreateRow(_idx);
+ var row9 = sheet.CreateRow(_idx);
row9.HeightInPoints = rowHeight;
- for (int colIndex = 0; colIndex < maxCols; colIndex++)
+ for (var colIndex = 0; colIndex < maxCols; colIndex++)
{
- ICell cell = row9.CreateCell(colIndex);
+ var cell = row9.CreateCell(colIndex);
cell.CellStyle = style;
}
+
_idx++;
}
+
sheet.AddMergedRegion(new CellRangeAddress(_idx - 2, _idx - 1, 0, 0));
sheet.AddMergedRegion(new CellRangeAddress(_idx - 2, _idx - 2, 1, 7));
sheet.AddMergedRegion(new CellRangeAddress(_idx - 1, _idx - 1, 1, 7));
@@ -797,26 +819,31 @@
setCellVal(sheet, _idx - 2, 1, row0["shyj"].ToString());
setCellVal(sheet, _idx - 1, 1, row0["shyjqz"].ToString());
string[] ary = { "閲囪喘閮ㄦ剰瑙�", "閿�鍞儴鎰忚", "鎶�鏈儴鎰忚", "鐢熶骇閮ㄦ剰瑙�", "鍝佽川閮ㄦ剰瑙�" };
- for (int i = 0; i < ary.Length; i++)
+ for (var i = 0; i < ary.Length; i++)
{
- IRow row9 = sheet.CreateRow(_idx);
+ var row9 = sheet.CreateRow(_idx);
row9.HeightInPoints = rowHeight;
- for (int colIndex = 0; colIndex < maxCols; colIndex++)
+ for (var colIndex = 0; colIndex < maxCols; colIndex++)
{
- ICell cell = row9.CreateCell(colIndex);
+ var cell = row9.CreateCell(colIndex);
cell.CellStyle = style;
}
+
// sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 0, 1));
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 2, 7));
_idx++;
}
+
setCellVal(sheet, _idx - ary.Length, 0, "涓嶅悎鏍艰瘎瀹★細");
- sheet.AddMergedRegion(new CellRangeAddress(_idx - ary.Length, _idx - 1, 0, 0));
- for (int i = 0; i < ary.Length; i++)
+ sheet.AddMergedRegion(new CellRangeAddress(_idx - ary.Length, _idx - 1,
+ 0, 0));
+ for (var i = 0; i < ary.Length; i++)
{
setCellVal(sheet, _idx - i - 1, 1, ary[i]);
- setCellVal(sheet, _idx - i - 1, 2, "鈻� 鍚屾剰 鈻� 涓嶅悓鎰� 绛惧悕/鏃ユ湡锛�");
+ setCellVal(sheet, _idx - i - 1, 2,
+ "鈻� 鍚屾剰 鈻� 涓嶅悓鎰� 绛惧悕/鏃ユ湡锛�");
}
+
//****鍚堝苟濂藉悗寮�濮嬭祴鍊糴nd**************
//淇濆瓨
using (var ms = new MemoryStream())
@@ -836,26 +863,26 @@
/// <summary>
- /// 鐢熸垚宸℃
+ /// 鐢熸垚宸℃
/// </summary>
/// <param name="dtSource"></param>
public static void ExportXunJian(DataSet dtSource, string strFileName)
{
- DataTable tb0 = dtSource.Tables[0];
- DataRow row0 = tb0.Rows[0];
- DataTable tb1 = dtSource.Tables[1];
+ var tb0 = dtSource.Tables[0];
+ var row0 = tb0.Rows[0];
+ var tb1 = dtSource.Tables[1];
//琛岄珮
- int rowHeight = 25;
+ var rowHeight = 25;
//鎬诲垪
- int maxCols = 10;
- HSSFWorkbook workbook = new HSSFWorkbook();
- ISheet sheet = workbook.CreateSheet("Sheet1");
+ var maxCols = 10;
+ var workbook = new HSSFWorkbook();
+ var sheet = workbook.CreateSheet("Sheet1");
// 鍒涘缓鍗曞厓鏍兼牱寮� - 甯﹁竟妗嗗拰鎸囧畾瀛椾綋
- ICellStyle style = getStyle(workbook);
- ICellStyle styleHeader = getStyle(workbook, 20, true, true);
- ICellStyle style12 = getStyle(workbook, 11, false, true);
+ var style = getStyle(workbook);
+ var styleHeader = getStyle(workbook, 20, true, true);
+ var style12 = getStyle(workbook, 11, false, true);
// 璁剧疆鍒楀锛�10鍒楋級
- sheet.SetColumnWidth(0, 3000); // 绗竴鍒楃◢瀹�
+ sheet.SetColumnWidth(0, 3000); // 绗竴鍒楃◢瀹�
sheet.SetColumnWidth(1, 3000);
sheet.SetColumnWidth(2, 3000);
sheet.SetColumnWidth(3, 3000);
@@ -866,21 +893,22 @@
sheet.SetColumnWidth(8, 3000);
sheet.SetColumnWidth(9, 3000);
// 鍒涘缓澶磋
- for (int rowIndex = 0; rowIndex <= 2; rowIndex++)
+ for (var rowIndex = 0; rowIndex <= 2; rowIndex++)
{
- IRow row = sheet.CreateRow(rowIndex);
+ var row = sheet.CreateRow(rowIndex);
// 璁剧疆琛岄珮锛堟墍鏈夎鐩稿悓楂樺害锛�
row.HeightInPoints = rowHeight;
// 鍒涘缓涓崟鍏冩牸
- for (int colIndex = 0; colIndex < maxCols; colIndex++)
+ for (var colIndex = 0; colIndex < maxCols; colIndex++)
{
- ICell cell = row.CreateCell(colIndex);
+ var cell = row.CreateCell(colIndex);
if (rowIndex == 0)
cell.CellStyle = styleHeader;
else
cell.CellStyle = style;
}
}
+
//绗竴琛屽垪鍚堝苟
sheet.AddMergedRegion(new CellRangeAddress(0, 0, 0, 9));
setCellVal(sheet, 0, 0, row0["title"].ToString());
@@ -894,8 +922,8 @@
setCellVal(sheet, 1, 5, "瑙勬牸鍨嬪彿");
setCellVal(sheet, 1, 6, row0["itemModel"].ToString());
//绗笁琛屽垪鍚堝苟
- sheet.AddMergedRegion(new CellRangeAddress(2, 2,2, 4));
- setCellVal(sheet,2, 0, "搴忓彿");
+ sheet.AddMergedRegion(new CellRangeAddress(2, 2, 2, 4));
+ setCellVal(sheet, 2, 0, "搴忓彿");
setCellVal(sheet, 2, 1, "妫�楠岄」鐩�");
setCellVal(sheet, 2, 2, "妫�楠屾爣鍑�");
setCellVal(sheet, 2, 5, row0["tm1"].ToString());
@@ -904,14 +932,14 @@
setCellVal(sheet, 2, 8, row0["tm4"].ToString());
setCellVal(sheet, 2, 9, row0["tm5"].ToString());
//寰幆鏁版嵁搴�
- int _idx = 3;
+ var _idx = 3;
foreach (DataRow rrr in tb1.Rows)
{
- IRow row7 = sheet.CreateRow(_idx);
+ var row7 = sheet.CreateRow(_idx);
row7.HeightInPoints = rowHeight;
- for (int colIndex = 0; colIndex < maxCols; colIndex++)
+ for (var colIndex = 0; colIndex < maxCols; colIndex++)
{
- ICell cell7 = row7.CreateCell(colIndex);
+ var cell7 = row7.CreateCell(colIndex);
cell7.CellStyle = style;
// cell7.SetCellValue("1");
switch (colIndex)
@@ -920,7 +948,8 @@
cell7.SetCellValue(rrr["搴忓彿"].ToString());
break;
case 1:
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 2, 4));
+ sheet.AddMergedRegion(
+ new CellRangeAddress(_idx, _idx, 2, 4));
cell7.SetCellValue(rrr["妫�楠岄」鐩�"].ToString());
break;
case 2:
@@ -943,16 +972,19 @@
break;
}
}
+
_idx++;
}
+
////澶囨敞
- IRow row8 = sheet.CreateRow(_idx);
+ var row8 = sheet.CreateRow(_idx);
row8.HeightInPoints = rowHeight;
- for (int colIndex = 0; colIndex < maxCols; colIndex++)
+ for (var colIndex = 0; colIndex < maxCols; colIndex++)
{
- ICell cell = row8.CreateCell(colIndex);
+ var cell = row8.CreateCell(colIndex);
cell.CellStyle = style12;
}
+
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 0, 4));
setCellVal(sheet, _idx, 0, "宸℃浜猴細");
setCellVal(sheet, _idx, 5, row0["xjr1"].ToString());
@@ -977,74 +1009,77 @@
}
/// <summary>
- /// 鐢熸垚鎴愬搧妫�楠屾姤鍛婏紙鎸夊疄闄呮ā鏉跨粨鏋勶級
+ /// 鐢熸垚鎴愬搧妫�楠屾姤鍛婏紙鎸夊疄闄呮ā鏉跨粨鏋勶級
/// </summary>
/// <param name="dtSource"></param>
/// <param name="strFileName"></param>
public static void ExportChengPin(DataSet dtSource, string strFileName)
{
//琛岄珮
- int rowHeight = 25;
+ var rowHeight = 25;
//鎬诲垪鏁� - 鏍规嵁妯℃澘鍒嗘瀽锛岃嚦灏戦渶瑕�18鍒�
- int maxCols = 18;
+ var maxCols = 18;
// 鍒涘缓宸ヤ綔绨�
- HSSFWorkbook workbook = new HSSFWorkbook();
- ISheet sheet = workbook.CreateSheet("Sheet1");
+ var workbook = new HSSFWorkbook();
+ var sheet = workbook.CreateSheet("Sheet1");
// 鍒涘缓鍗曞厓鏍兼牱寮�
- ICellStyle style = getStyle(workbook);
- ICellStyle styleHeader = getStyle(workbook, 16, true, true);
- ICellStyle styleTitle = getStyle(workbook, 14, true, true);
- ICellStyle styleSmall = getStyle(workbook, 10, false, false);
+ var style = getStyle(workbook);
+ var styleHeader = getStyle(workbook, 16, true, true);
+ var styleTitle = getStyle(workbook, 14, true, true);
+ var styleSmall = getStyle(workbook, 10);
// 璁剧疆鍒楀
- sheet.SetColumnWidth(0, 3500); // A鍒楋細椤圭洰鍚嶇О
- sheet.SetColumnWidth(1, 5000); // B鍒楋細鏍囧噯/瑙勮寖
- for (int i = 2; i < 18; i++) // C鍒癛鍒楋細16涓娴嬪�煎垪
- {
+ sheet.SetColumnWidth(0, 3500); // A鍒楋細椤圭洰鍚嶇О
+ sheet.SetColumnWidth(1, 5000); // B鍒楋細鏍囧噯/瑙勮寖
+ for (var i = 2; i < 18; i++) // C鍒癛鍒楋細16涓娴嬪�煎垪
sheet.SetColumnWidth(i, 2500);
- }
//鑾峰彇琛ㄥご鏁版嵁
- DataTable tb0 = dtSource.Tables[0];
- DataRow row0 = tb0.Rows[0];
- int _idx = 0;
+ var tb0 = dtSource.Tables[0];
+ var row0 = tb0.Rows[0];
+ var _idx = 0;
// 绗�1琛岋細鎶ュ憡鏍囬
- IRow titleRow = sheet.CreateRow(_idx);
+ var titleRow = sheet.CreateRow(_idx);
titleRow.HeightInPoints = 30;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell = titleRow.CreateCell(i);
+ var cell = titleRow.CreateCell(i);
cell.CellStyle = styleHeader;
}
+
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 0, maxCols - 1));
setCellVal(sheet, _idx, 0, "鎴愬搧妫�楠屾姤鍛�");
_idx++;
// 绗�2琛岋細鍩烘湰淇℃伅绗竴琛�
- IRow info1Row = sheet.CreateRow(_idx);
+ var info1Row = sheet.CreateRow(_idx);
info1Row.HeightInPoints = rowHeight;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell = info1Row.CreateCell(i);
+ var cell = info1Row.CreateCell(i);
cell.CellStyle = style;
}
- setCellVal(sheet, _idx, 0, "鐢熶骇杞﹂棿锛�" + (row0["workShop"]?.ToString() ?? ""));
+
+ setCellVal(sheet, _idx, 0,
+ "鐢熶骇杞﹂棿锛�" + (row0["workShop"]?.ToString() ?? ""));
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 0, 5));
- setCellVal(sheet, _idx, 12, "瀹ゆ俯锛�" + (row0["temperature"]?.ToString() ?? ""));
+ setCellVal(sheet, _idx, 12,
+ "瀹ゆ俯锛�" + (row0["temperature"]?.ToString() ?? ""));
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 12, 17));
_idx++;
// 绗�3琛岋細浜у搧淇℃伅
- IRow info2Row = sheet.CreateRow(_idx);
+ var info2Row = sheet.CreateRow(_idx);
info2Row.HeightInPoints = rowHeight;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell = info2Row.CreateCell(i);
+ var cell = info2Row.CreateCell(i);
cell.CellStyle = style;
}
+
setCellVal(sheet, _idx, 0, "浜у搧鍚嶇О");
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 4));
setCellVal(sheet, _idx, 1, row0["itemName"]?.ToString() ?? "");
@@ -1061,13 +1096,14 @@
_idx++;
// 绗�4琛岋細鍟嗘爣绛変俊鎭�
- IRow info3Row = sheet.CreateRow(_idx);
+ var info3Row = sheet.CreateRow(_idx);
info3Row.HeightInPoints = rowHeight;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell = info3Row.CreateCell(i);
+ var cell = info3Row.CreateCell(i);
cell.CellStyle = style;
}
+
setCellVal(sheet, _idx, 0, "鍟嗘爣");
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 4));
setCellVal(sheet, _idx, 1, row0["brand"]?.ToString() ?? "");
@@ -1084,13 +1120,14 @@
_idx++;
// 绗�5琛岋細AC/Re鏍囧噯
- IRow acreRow = sheet.CreateRow(_idx);
+ var acreRow = sheet.CreateRow(_idx);
acreRow.HeightInPoints = rowHeight;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell = acreRow.CreateCell(i);
+ var cell = acreRow.CreateCell(i);
cell.CellStyle = style;
}
+
setCellVal(sheet, _idx, 0, "Ac/Re(A绫伙級");
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 5));
setCellVal(sheet, _idx, 1, row0["acRe_A"]?.ToString() ?? "");
@@ -1105,18 +1142,21 @@
_idx++;
// 绗�6琛岋細鎶芥牱淇℃伅
- IRow sampleRow = sheet.CreateRow(_idx);
+ var sampleRow = sheet.CreateRow(_idx);
sampleRow.HeightInPoints = rowHeight;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell = sampleRow.CreateCell(i);
+ var cell = sampleRow.CreateCell(i);
cell.CellStyle = style;
}
+
setCellVal(sheet, _idx, 0, "鎶芥牱");
setCellVal(sheet, _idx, 1, "鍖�閫�");
- setCellVal(sheet, _idx, 2, row0["SampleMethod"]?.ToString() == "鍖�閫�" ? "鈭�" : "");
+ setCellVal(sheet, _idx, 2,
+ row0["SampleMethod"]?.ToString() == "鍖�閫�" ? "鈭�" : "");
setCellVal(sheet, _idx, 3, "闅忔満");
- setCellVal(sheet, _idx, 4, row0["SampleMethod"]?.ToString() == "闅忔満" ? "鈭�" : "");
+ setCellVal(sheet, _idx, 4,
+ row0["SampleMethod"]?.ToString() == "闅忔満" ? "鈭�" : "");
setCellVal(sheet, _idx, 5, "鏍锋湰鏁�");
setCellVal(sheet, _idx, 6, "鍖�閫熸娊鏍锋暟");
@@ -1128,36 +1168,35 @@
_idx++;
// 绗�7琛岋細妫�楠岄」鐩〃澶�
- IRow headerRow = sheet.CreateRow(_idx);
+ var headerRow = sheet.CreateRow(_idx);
headerRow.HeightInPoints = rowHeight;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell = headerRow.CreateCell(i);
+ var cell = headerRow.CreateCell(i);
cell.CellStyle = styleTitle;
}
+
setCellVal(sheet, _idx, 0, "椤圭洰");
setCellVal(sheet, _idx, 1, "鏍囧噯");
setCellVal(sheet, _idx, 2, "1");
setCellVal(sheet, _idx, 3, "2");
// 鏍规嵁闇�瑕佺户缁坊鍔犳洿澶氬垪鏍囬锛岃繖閲岀畝鍖栦负涓昏鍒�
- for (int i = 4; i < 18; i++)
- {
- setCellVal(sheet, _idx, i, (i-1).ToString());
- }
+ for (var i = 4; i < 18; i++)
+ setCellVal(sheet, _idx, i, (i - 1).ToString());
_idx++;
// 妫�楠岄」鐩暟鎹�
if (dtSource.Tables.Count > 1)
{
- DataTable tb1 = dtSource.Tables[1];
+ var tb1 = dtSource.Tables[1];
foreach (DataRow rrr in tb1.Rows)
{
- IRow dataRow = sheet.CreateRow(_idx);
+ var dataRow = sheet.CreateRow(_idx);
dataRow.HeightInPoints = rowHeight;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell = dataRow.CreateCell(i);
+ var cell = dataRow.CreateCell(i);
cell.CellStyle = style;
}
@@ -1165,17 +1204,15 @@
setCellVal(sheet, _idx, 1, rrr["RPB004"]?.ToString() ?? "");
// 濉厖16涓祴璇曞��
- for (int i = 0; i < 16; i++)
+ for (var i = 0; i < 16; i++)
{
- string colName = $"RPB{i + 5:D3}"; // RPB005, RPB006, ..., RPB020
+ var colName =
+ $"RPB{i + 5:D3}"; // RPB005, RPB006, ..., RPB020
if (rrr.Table.Columns.Contains(colName))
- {
- setCellVal(sheet, _idx, i + 2, rrr[colName]?.ToString() ?? "");
- }
+ setCellVal(sheet, _idx, i + 2,
+ rrr[colName]?.ToString() ?? "");
else
- {
setCellVal(sheet, _idx, i + 2, "");
- }
}
_idx++;
@@ -1183,59 +1220,66 @@
}
// 涓嶅悎鏍煎唴瀹硅褰�
- IRow defectHeaderRow = sheet.CreateRow(_idx);
+ var defectHeaderRow = sheet.CreateRow(_idx);
defectHeaderRow.HeightInPoints = rowHeight;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell = defectHeaderRow.CreateCell(i);
+ var cell = defectHeaderRow.CreateCell(i);
cell.CellStyle = styleTitle;
}
+
setCellVal(sheet, _idx, 0, "搴忓彿");
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 10)); // 涓嶅悎鏍煎唴瀹瑰崰澶氬垪
+ sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1,
+ 10)); // 涓嶅悎鏍煎唴瀹瑰崰澶氬垪
setCellVal(sheet, _idx, 1, "涓嶅悎鏍煎唴瀹�");
setCellVal(sheet, _idx, 11, "A绫�");
setCellVal(sheet, _idx, 12, "B绫�");
setCellVal(sheet, _idx, 13, "C绫�");
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 14, 17)); // 娉ㄦ剰鐐瑰崰鍓╀綑鍒�
+ sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 14,
+ 17)); // 娉ㄦ剰鐐瑰崰鍓╀綑鍒�
setCellVal(sheet, _idx, 14, "娉ㄦ剰鐐�");
_idx++;
if (dtSource.Tables.Count > 2)
{
- DataTable tb2 = dtSource.Tables[2];
+ var tb2 = dtSource.Tables[2];
foreach (DataRow rrr in tb2.Rows)
{
if (rrr["Description"]?.ToString() == "涓嶈壇鏁伴噺")
break;
- IRow dataRow = sheet.CreateRow(_idx);
+ var dataRow = sheet.CreateRow(_idx);
dataRow.HeightInPoints = rowHeight;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell = dataRow.CreateCell(i);
+ var cell = dataRow.CreateCell(i);
cell.CellStyle = style;
}
setCellVal(sheet, _idx, 0, rrr["Seq"]?.ToString() ?? "");
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 10)); // 涓嶅悎鏍煎唴瀹瑰崰澶氬垪
- setCellVal(sheet, _idx, 1, rrr["Description"]?.ToString() ?? "");
+ sheet.AddMergedRegion(
+ new CellRangeAddress(_idx, _idx, 1, 10)); // 涓嶅悎鏍煎唴瀹瑰崰澶氬垪
+ setCellVal(sheet, _idx, 1,
+ rrr["Description"]?.ToString() ?? "");
setCellVal(sheet, _idx, 11, rrr["AClass"]?.ToString() ?? "");
setCellVal(sheet, _idx, 12, rrr["BClass"]?.ToString() ?? "");
setCellVal(sheet, _idx, 13, rrr["CClass"]?.ToString() ?? "");
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 14, 17)); // 娉ㄦ剰鐐瑰崰鍓╀綑鍒�
+ sheet.AddMergedRegion(
+ new CellRangeAddress(_idx, _idx, 14, 17)); // 娉ㄦ剰鐐瑰崰鍓╀綑鍒�
setCellVal(sheet, _idx, 14, rrr["Point"]?.ToString() ?? "");
_idx++;
}
- DataRow dr = tb2.Rows[tb2.Rows.Count - 1];
+ var dr = tb2.Rows[tb2.Rows.Count - 1];
// 澶囨敞琛�
- IRow remarkRow = sheet.CreateRow(_idx);
+ var remarkRow = sheet.CreateRow(_idx);
remarkRow.HeightInPoints = rowHeight;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell = remarkRow.CreateCell(i);
+ var cell = remarkRow.CreateCell(i);
cell.CellStyle = style;
}
+
setCellVal(sheet, _idx, 0, "澶囨敞锛�");
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 8));
setCellVal(sheet, _idx, 9, "涓嶈壇鏁伴噺锛�");
@@ -1243,31 +1287,33 @@
setCellVal(sheet, _idx, 11, dr["AClass"]?.ToString() ?? "");
setCellVal(sheet, _idx, 12, dr["BClass"]?.ToString() ?? "");
setCellVal(sheet, _idx, 13, dr["CClass"]?.ToString() ?? "");
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 14, 17)); // 娉ㄦ剰鐐瑰崰鍓╀綑鍒�
+ sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 14,
+ 17)); // 娉ㄦ剰鐐瑰崰鍓╀綑鍒�
setCellVal(sheet, _idx, 14, dr["Point"]?.ToString() ?? "");
_idx++;
// 澶х殑澶囨敞鍐呭鍖哄煙
- IRow remarkContentRow = sheet.CreateRow(_idx);
+ var remarkContentRow = sheet.CreateRow(_idx);
remarkContentRow.HeightInPoints = 60;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell = remarkContentRow.CreateCell(i);
+ var cell = remarkContentRow.CreateCell(i);
cell.CellStyle = style;
}
+
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 0, 17));
setCellVal(sheet, _idx, 0, dr["Remark"]?.ToString() ?? "");
_idx++;
}
// 妫�楠屽垽瀹氬尯鍩燂紙3琛屽竷灞�锛�
- for (int judgeRowIndex = 0; judgeRowIndex < 3; judgeRowIndex++)
+ for (var judgeRowIndex = 0; judgeRowIndex < 3; judgeRowIndex++)
{
- IRow judgmentRow = sheet.CreateRow(_idx);
+ var judgmentRow = sheet.CreateRow(_idx);
judgmentRow.HeightInPoints = rowHeight;
- for (int i = 0; i < maxCols; i++)
+ for (var i = 0; i < maxCols; i++)
{
- ICell cell = judgmentRow.CreateCell(i);
+ var cell = judgmentRow.CreateCell(i);
cell.CellStyle = styleTitle;
}
@@ -1275,110 +1321,90 @@
{
// 绗竴琛岋細妫�楠屽垽瀹�
setCellVal(sheet, _idx, 0, "妫�楠屽垽瀹�");
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx + 2, 0, 0)); // 妫�楠屽垽瀹氳法3琛�
+ sheet.AddMergedRegion(
+ new CellRangeAddress(_idx, _idx + 2, 0, 0)); // 妫�楠屽垽瀹氳法3琛�
if (row0["CheckResult"]?.ToString() == "鍚堟牸")
- {
setCellVal(sheet, _idx, 1, "鈭� 鍚堟牸 鈻� 涓嶅悎鏍�");
- }
- else if(row0["CheckResult"]?.ToString() == "涓嶅悎鏍�")
- {
+ else if (row0["CheckResult"]?.ToString() == "涓嶅悎鏍�")
setCellVal(sheet, _idx, 1, "鈻� 鍚堟牸 鈭� 涓嶅悎鏍�");
- }
else
- {
setCellVal(sheet, _idx, 1, "鈻� 鍚堟牸 鈻� 涓嶅悎鏍�");
- }
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx + 1, 1, 5)); // 鍚堟牸/涓嶅悎鏍艰法2琛�
+ sheet.AddMergedRegion(
+ new CellRangeAddress(_idx, _idx + 1, 1, 5)); // 鍚堟牸/涓嶅悎鏍艰法2琛�
setCellVal(sheet, _idx, 6, "瀹℃牳");
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx + 2, 6, 6)); // 瀹℃牳璺�3琛�
+ sheet.AddMergedRegion(
+ new CellRangeAddress(_idx, _idx + 2, 6, 6)); // 瀹℃牳璺�3琛�
if (row0["ProcessResults"]?.ToString() == "鏃�")
- {
setCellVal(sheet, _idx, 7, "鈭� 鏃� 鈻� 杩斿伐");
- }
else if (row0["ProcessResults"]?.ToString() == "杩斿伐")
- {
setCellVal(sheet, _idx, 7, "鈻� 鏃� 鈭� 杩斿伐");
- }
else
- {
setCellVal(sheet, _idx, 7, "鈻� 鏃� 鈻� 杩斿伐");
- }
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 7, 11));
setCellVal(sheet, _idx, 12, "瀹℃壒");
- sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx + 2, 12, 12)); // 瀹℃壒璺�3琛�
+ sheet.AddMergedRegion(
+ new CellRangeAddress(_idx, _idx + 2, 12, 12)); // 瀹℃壒璺�3琛�
if (row0["ProcessResults"]?.ToString() == "鏃�")
- {
setCellVal(sheet, _idx, 13, "鈭� 鏃� 鈻� 杩斿伐");
- }
else if (row0["ProcessResults"]?.ToString() == "杩斿伐")
- {
setCellVal(sheet, _idx, 13, "鈻� 鏃� 鈭� 杩斿伐");
- }
else
- {
setCellVal(sheet, _idx, 13, "鈻� 鏃� 鈻� 杩斿伐");
- }
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 13, 17));
}
else if (judgeRowIndex == 1)
{
if (row0["ProcessResults"]?.ToString() == "璁╂鎺ユ敹")
- {
setCellVal(sheet, _idx, 7, "鈭� 璁╂鎺ユ敹 鈻� 鐗归噰");
- }
else if (row0["ProcessResults"]?.ToString() == "鐗归噰")
- {
setCellVal(sheet, _idx, 7, "鈻� 璁╂鎺ユ敹 鈭� 鐗归噰");
- }
else
- {
setCellVal(sheet, _idx, 7, "鈻� 璁╂鎺ユ敹 鈻� 鐗归噰");
- }
// 绗簩琛岋細璁╂鎺ユ敹閫夐」
-
+
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 7, 11));
if (row0["ProcessResults"]?.ToString() == "璁╂鎺ユ敹")
- {
setCellVal(sheet, _idx, 13, "鈭� 璁╂鎺ユ敹 鈻� 鐗归噰");
- }
else if (row0["ProcessResults"]?.ToString() == "鐗归噰")
- {
setCellVal(sheet, _idx, 13, "鈻� 璁╂鎺ユ敹 鈭� 鐗归噰");
- }
else
- {
setCellVal(sheet, _idx, 13, "鈻� 璁╂鎺ユ敹 鈻� 鐗归噰");
- }
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 13, 17));
}
else
{
// 绛惧悕琛�
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 1, 2));
- setCellVal(sheet, _idx, 1, $"绛惧悕/鏃ユ湡锛�");
+ setCellVal(sheet, _idx, 1, "绛惧悕/鏃ユ湡锛�");
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 3, 5));
- setCellVal(sheet, _idx, 3, $"{row0["JY_USER"]?.ToString() ?? ""}/{row0["JY_DATE"]?.ToString() ?? ""}");
+ setCellVal(sheet, _idx, 3,
+ $"{row0["JY_USER"]?.ToString() ?? ""}/{row0["JY_DATE"]?.ToString() ?? ""}");
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 7, 8));
- setCellVal(sheet, _idx, 7, $"绛惧悕/鏃ユ湡锛�");
+ setCellVal(sheet, _idx, 7, "绛惧悕/鏃ユ湡锛�");
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 9, 11));
- setCellVal(sheet, _idx, 9, $"{row0["CHECK_USER"]?.ToString() ?? ""}/{row0["CHECK_DATE"]?.ToString() ?? ""}");
+ setCellVal(sheet, _idx, 9,
+ $"{row0["CHECK_USER"]?.ToString() ?? ""}/{row0["CHECK_DATE"]?.ToString() ?? ""}");
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 13, 14));
- setCellVal(sheet, _idx, 13, $"绛惧悕/鏃ユ湡锛�");
+ setCellVal(sheet, _idx, 13, "绛惧悕/鏃ユ湡锛�");
sheet.AddMergedRegion(new CellRangeAddress(_idx, _idx, 15, 17));
- setCellVal(sheet, _idx, 15, $"{row0["SP_USER"]?.ToString() ?? ""}/{row0["SP_DATE"]?.ToString() ?? ""}");
+ setCellVal(sheet, _idx, 15,
+ $"{row0["SP_USER"]?.ToString() ?? ""}/{row0["SP_DATE"]?.ToString() ?? ""}");
}
+
_idx++;
}
+
//淇濆瓨
using (var ms = new MemoryStream())
{
- using (var fs = new FileStream(strFileName, FileMode.Create, FileAccess.Write))
+ using (var fs = new FileStream(strFileName, FileMode.Create,
+ FileAccess.Write))
{
workbook.Write(ms);
ms.Flush();
@@ -1478,4 +1504,4 @@
return "=" + cell.CellFormula;
}
}
-}
+}
\ No newline at end of file
--
Gitblit v1.9.3