From 6b8782c6810660751b40d284d40ea7a13656c5b7 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 05 九月 2022 20:04:13 +0800
Subject: [PATCH] 设备点检记录功能、大岛车间综合看板接口变更、工单批量关闭查询，提交
---
VueWebApi/Tools/ImportExcelData.cs | 1580 +++++++++++++++++++++++++++++++++++++++++-----------------
1 files changed, 1,111 insertions(+), 469 deletions(-)
diff --git a/VueWebApi/Tools/ImportExcelData.cs b/VueWebApi/Tools/ImportExcelData.cs
index 4dc51d4..4d64a78 100644
--- a/VueWebApi/Tools/ImportExcelData.cs
+++ b/VueWebApi/Tools/ImportExcelData.cs
@@ -1,4 +1,5 @@
-锘縰sing System;
+锘縰sing Dapper;
+using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
@@ -12,37 +13,115 @@
public static ToMessage mes = new ToMessage(); //瀹氫箟鍏ㄥ眬杩斿洖淇℃伅瀵硅薄
#region銆怑xcel妯℃澘涓婁紶楠岃瘉銆�
- #region銆怑xcel妯℃澘涓婁紶楠岃瘉,瑙掕壊鏉冮檺妯℃澘銆�
- public static string One(string FileCode, out string code)
+ #region銆怑xcel妯℃澘涓婁紶楠岃瘉,鐢ㄦ埛娓呭崟妯℃澘銆�
+ public static string Two(string FileCode, out string code)
{
string Message = "";
code = "";
- DataTable excelTable = new DataTable();
- excelTable = ImportExcel.ExcelToTable(FileCode);
- if (excelTable.Columns.Count != 4)
+ List<DataTable> excelTable = new List<DataTable>();
+ excelTable = ImportExcel.ExcelToTableList(FileCode);
+ if (excelTable.Count != 4)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "瀵煎叆妯℃澘涓嶇鍚堣鑼�,璇锋鏌heet鏁�";
+ return Message;
+
}
- else if (excelTable.Columns[0].ColumnName != "搴忓彿")
+ else if (excelTable[0].Columns.Count != 4)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "鐢ㄦ埛鐝粍妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
+ return Message;
}
- else if (excelTable.Columns[1].ColumnName != "瑙掕壊缂栧彿(鍞竴)")
+ else if (excelTable[1].Columns.Count != 10)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "鐢ㄦ埛娓呭崟妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
+ return Message;
}
- else if (excelTable.Columns[2].ColumnName != "瑙掕壊鍚嶇О(鍞竴)")
+ else if (excelTable[0].Columns[0].ColumnName != "搴忓彿")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "鐢ㄦ埛鐝粍妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�1鍒楀簲涓簕搴忓彿}";
+ return Message;
}
- else if (excelTable.Columns[3].ColumnName != "瑙掕壊绫诲瀷")
+ else if (excelTable[0].Columns[1].ColumnName != "鐝粍缂栧彿(鍞竴)")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "鐢ㄦ埛鐝粍妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�2鍒楀簲涓簕鐝粍缂栧彿(鍞竴)}";
+ return Message;
+ }
+ else if (excelTable[0].Columns[2].ColumnName != "鐝粍鍚嶇О")
+ {
+ code = "300";
+ Message = "鐢ㄦ埛鐝粍妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�3鍒楀簲涓簕鐝粍鍚嶇О}";
+ return Message;
+ }
+ else if (excelTable[0].Columns[3].ColumnName != "鐝粍鎻忚堪")
+ {
+ code = "300";
+ Message = "鐢ㄦ埛鐝粍妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�4鍒楀簲涓簕鐝粍鎻忚堪}";
+ return Message;
+ }
+ else if (excelTable[1].Columns[0].ColumnName != "搴忓彿")
+ {
+ code = "300";
+ Message = "鐢ㄦ埛娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�1鍒楀簲涓簕搴忓彿}";
+ return Message;
+ }
+ else if (excelTable[1].Columns[1].ColumnName != "鐢ㄦ埛缂栧彿(鍞竴)")
+ {
+ code = "300";
+ Message = "鐢ㄦ埛娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�2鍒楀簲涓簕鐢ㄦ埛缂栧彿(鍞竴)}";
+ return Message;
+ }
+ else if (excelTable[1].Columns[2].ColumnName != "鐢ㄦ埛濮撳悕")
+ {
+ code = "300";
+ Message = "鐢ㄦ埛娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�3鍒楀簲涓簕鐢ㄦ埛濮撳悕}";
+ return Message;
+ }
+ else if (excelTable[1].Columns[3].ColumnName != "鍦ㄨ亴鐘舵��")
+ {
+ code = "300";
+ Message = "鐢ㄦ埛娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�4鍒楀簲涓簕鍦ㄨ亴鐘舵�亇";
+ return Message;
+ }
+ else if (excelTable[1].Columns[4].ColumnName != "瀵嗙爜")
+ {
+ code = "300";
+ Message = "鐢ㄦ埛娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�5鍒楀簲涓簕瀵嗙爜}";
+ return Message;
+ }
+ else if (excelTable[1].Columns[5].ColumnName != "鎵嬫満鍙�")
+ {
+ code = "300";
+ Message = "鐢ㄦ埛娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�6鍒楀簲涓簕鎵嬫満鍙穧";
+ return Message;
+ }
+ else if (excelTable[1].Columns[6].ColumnName != "閭")
+ {
+ code = "300";
+ Message = "鐢ㄦ埛娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�7鍒楀簲涓簕閭}";
+ return Message;
+ }
+ else if (excelTable[1].Columns[7].ColumnName != "缁勭粐缂栫爜")
+ {
+ code = "300";
+ Message = "鐢ㄦ埛娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�8鍒楀簲涓簕缁勭粐缂栫爜}";
+ return Message;
+ }
+ else if (excelTable[1].Columns[8].ColumnName != "宸ヨ祫绫诲瀷")
+ {
+ code = "300";
+ Message = "鐢ㄦ埛娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�9鍒楀簲涓簕宸ヨ祫绫诲瀷}";
+ return Message;
+ }
+ else if (excelTable[1].Columns[9].ColumnName != "鐢ㄦ埛缁勭紪鐮�")
+ {
+ code = "300";
+ Message = "鐢ㄦ埛娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�10鍒楀簲涓簕鐢ㄦ埛缁勭紪鐮亇";
+ return Message;
}
else
{
@@ -53,47 +132,79 @@
}
#endregion
- #region銆怑xcel妯℃澘涓婁紶楠岃瘉,鐢ㄦ埛瑙掕壊妯℃澘銆�
- public static string Two(string FileCode, out string code)
+ #region銆怑xcel妯℃澘涓婁紶楠岃瘉,瑙掕壊鏉冮檺妯℃澘銆�
+ public static string One(string FileCode, out string code)
{
string Message = "";
code = "";
- DataTable excelTable = new DataTable();
- excelTable = ImportExcel.ExcelToTable(FileCode);
- if (excelTable.Columns.Count != 6)
+ List<DataTable> excelTable = new List<DataTable>();
+ excelTable = ImportExcel.ExcelToTableList(FileCode);
+ if (excelTable.Count != 4)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "瀵煎叆妯℃澘涓嶇鍚堣鑼�,璇锋鏌heet鏁�";
+ return Message;
+
}
- else if (excelTable.Columns[0].ColumnName != "搴忓彿")
+ else if (excelTable[0].Columns.Count != 3)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "瑙掕壊绫诲瀷妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
+ return Message;
}
- else if (excelTable.Columns[1].ColumnName != "鐢ㄦ埛缂栧彿(鍞竴)")
+ else if (excelTable[1].Columns.Count != 5)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "妯℃澘瑙掕壊娓呭崟涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
+ return Message;
}
- else if (excelTable.Columns[2].ColumnName != "鐢ㄦ埛濮撳悕")
+ else if (excelTable[0].Columns[0].ColumnName != "搴忓彿")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "瑙掕壊绫诲瀷妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�1鍒楀簲涓簕搴忓彿}";
+ return Message;
}
- else if (excelTable.Columns[3].ColumnName != "鎵�灞炵粍缁�")
+ else if (excelTable[0].Columns[1].ColumnName != "瑙掕壊绫诲瀷缂栧彿(鍞竴)")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "瑙掕壊绫诲瀷妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�2鍒楀簲涓簕瑙掕壊绫诲瀷缂栧彿(鍞竴)}";
+ return Message;
}
- else if (excelTable.Columns[4].ColumnName != "鍦ㄨ亴鐘舵��")
+ else if (excelTable[0].Columns[2].ColumnName != "瑙掕壊绫诲瀷鍚嶇О")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "瑙掕壊绫诲瀷妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�3鍒楀簲涓簕瑙掕壊绫诲瀷鍚嶇О}";
+ return Message;
}
- else if (excelTable.Columns[5].ColumnName != "宸ヨ祫绫诲瀷")
+ else if (excelTable[1].Columns[0].ColumnName != "搴忓彿")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "瑙掕壊娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�1鍒楀簲涓簕搴忓彿}";
+ return Message;
+ }
+ else if (excelTable[1].Columns[1].ColumnName != "瑙掕壊缂栧彿(鍞竴)")
+ {
+ code = "300";
+ Message = "瑙掕壊娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�2鍒楀簲涓簕瑙掕壊缂栧彿(鍞竴)}";
+ return Message;
+ }
+ else if (excelTable[1].Columns[2].ColumnName != "瑙掕壊濮撳悕")
+ {
+ code = "300";
+ Message = "瑙掕壊娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�3鍒楀簲涓簕瑙掕壊濮撳悕}";
+ return Message;
+ }
+ else if (excelTable[1].Columns[3].ColumnName != "瑙掕壊绫诲瀷缂栫爜")
+ {
+ code = "300";
+ Message = "瑙掕壊娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�4鍒楀簲涓簕瑙掕壊绫诲瀷缂栫爜}";
+ return Message;
+ }
+ else if (excelTable[1].Columns[4].ColumnName != "瑙掕壊鎻忚堪")
+ {
+ code = "300";
+ Message = "瑙掕壊娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�5鍒楀簲涓簕瑙掕壊鎻忚堪}";
+ return Message;
}
else
{
@@ -170,42 +281,67 @@
}
#endregion
- #region銆怑xcel妯℃澘涓婁紶楠岃瘉,渚涙柟娓呭崟妯℃澘銆�
+ #region銆怑xcel妯℃澘涓婁紶楠岃瘉,寰�鏉ュ崟浣嶆竻鍗曟ā鏉裤��
public static string Four(string FileCode, out string code)
{
string Message = "";
code = "";
- DataTable excelTable = new DataTable();
- excelTable = ImportExcel.ExcelToTable(FileCode);
- if (excelTable.Columns.Count != 5)
+ List<DataTable> excelTable = new List<DataTable>();
+ excelTable = ImportExcel.ExcelToTableList(FileCode);
+ if (excelTable.Count != 2)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "瀵煎叆妯℃澘涓嶇鍚堣鑼�,璇锋鏌heet鏁�";
+ return Message;
+
}
- else if (excelTable.Columns[0].ColumnName != "搴忓彿")
+ else if (excelTable[0].Columns.Count != 7)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "寰�鏉ュ崟浣嶆ā鏉夸笉绗﹀悎瑙勮寖,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
+ return Message;
}
- else if (excelTable.Columns[1].ColumnName != "渚涙柟缂栧彿(鍞竴)")
+ else if (excelTable[0].Columns[0].ColumnName != "搴忓彿")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "寰�鏉ュ崟浣嶆ā鏉夸笉绗﹀悎瑙勮寖锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�1鍒楀簲涓簕搴忓彿}";
+ return Message;
}
- else if (excelTable.Columns[2].ColumnName != "渚涙柟鍚嶇О锛堝敮涓�锛�")
+ else if (excelTable[0].Columns[1].ColumnName != "寰�鏉ュ崟浣嶇紪鍙�(鍞竴)")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "寰�鏉ュ崟浣嶆ā鏉夸笉绗﹀悎瑙勮寖锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�2鍒楀簲涓簕寰�鏉ュ崟浣嶇紪鍙�(鍞竴)}";
+ return Message;
}
- else if (excelTable.Columns[3].ColumnName != "琛ュ厖鎻忚堪")
+ else if (excelTable[0].Columns[2].ColumnName != "寰�鏉ュ崟浣嶅悕绉�")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "寰�鏉ュ崟浣嶆ā鏉夸笉绗﹀悎瑙勮寖锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�3鍒楀簲涓簕寰�鏉ュ崟浣嶅悕绉皚";
+ return Message;
}
- else if (excelTable.Columns[4].ColumnName.Trim() != "渚涙柟绫诲瀷锛堝鍗忎緵鏂�,澶栬喘渚涙柟锛�")
+ else if (excelTable[0].Columns[3].ColumnName != "寰�鏉ュ崟浣嶅睘鎬�")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "寰�鏉ュ崟浣嶆ā鏉夸笉绗﹀悎瑙勮寖锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�4鍒楀簲涓簕寰�鏉ュ崟浣嶅睘鎬";
+ return Message;
+ }
+ else if (excelTable[0].Columns[4].ColumnName != "鑱旂郴浜�")
+ {
+ code = "300";
+ Message = "寰�鏉ュ崟浣嶆ā鏉夸笉绗﹀悎瑙勮寖锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�5鍒楀簲涓簕鑱旂郴浜簘";
+ return Message;
+ }
+ else if (excelTable[0].Columns[5].ColumnName != "鑱旂郴鏂瑰紡")
+ {
+ code = "300";
+ Message = "寰�鏉ュ崟浣嶆ā鏉夸笉绗﹀悎瑙勮寖锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�6鍒楀簲涓簕鑱旂郴鏂瑰紡}";
+ return Message;
+ }
+ else if (excelTable[0].Columns[6].ColumnName != "鍦板潃")
+ {
+ code = "300";
+ Message = "寰�鏉ュ崟浣嶆ā鏉夸笉绗﹀悎瑙勮寖锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�7鍒楀簲涓簕鍦板潃}";
+ return Message;
}
else
{
@@ -216,180 +352,85 @@
}
#endregion
- #region銆怑xcel妯℃澘涓婁紶楠岃瘉,瀹㈡埛娓呭崟妯℃澘銆�
- public static string Five(string FileCode, out string code)
- {
- string Message = "";
- code = "";
- DataTable excelTable = new DataTable();
- excelTable = ImportExcel.ExcelToTable(FileCode);
- if (excelTable.Columns.Count != 4)
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable.Columns[0].ColumnName != "搴忓彿")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable.Columns[1].ColumnName != "瀹㈡埛缂栧彿(鍞竴)")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable.Columns[2].ColumnName != "瀹㈡埛鍚嶇О锛堝敮涓�锛�")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable.Columns[3].ColumnName != "琛ュ厖鎻忚堪")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else
- {
- code = "200";
- Message = "妯℃澘妫�楠岄�氳繃";
- }
- return Message;
- }
- #endregion
-
- #region銆怑xcel妯℃澘涓婁紶楠岃瘉,浠撳簱瀹氫箟妯℃澘銆�
+ #region銆怑xcel妯℃澘涓婁紶楠岃瘉,浠撳簱銆佸簱浣嶅畾涔夋ā鏉裤��
public static string SixOne(string FileCode, out string code)
{
string Message = "";
code = "";
- DataTable excelTable = new DataTable();
- excelTable = ImportExcel.ExcelToTable(FileCode);
- if (excelTable.Columns.Count != 4)
+ List<DataTable> excelTable = new List<DataTable>();
+ excelTable = ImportExcel.ExcelToTableList(FileCode);
+ if (excelTable.Count != 4)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable.Columns[0].ColumnName != "搴忓彿")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable.Columns[1].ColumnName != "浠撳簱缂栫爜(鍞竴)")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable.Columns[2].ColumnName != "浠撳簱鍚嶇О锛堝敮涓�锛�")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable.Columns[3].ColumnName != "鍔熻兘鎻忚堪")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else
- {
- code = "200";
- Message = "妯℃澘妫�楠岄�氳繃";
- }
- return Message;
- }
- #endregion
+ Message = "瀵煎叆妯℃澘涓嶇鍚堣鑼�,璇锋鏌heet鏁�";
+ return Message;
- #region銆怑xcel妯℃澘涓婁紶楠岃瘉,搴撳尯瀹氫箟妯℃澘銆�
- public static string SixTwo(string FileCode, out string code)
- {
- string Message = "";
- code = "";
- DataTable excelTable = new DataTable();
- excelTable = ImportExcel.ExcelToTable(FileCode);
- if (excelTable.Columns.Count != 6)
+ }
+ else if (excelTable[0].Columns.Count != 4)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "浠撳簱娓呭崟妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
+ return Message;
}
- else if (excelTable.Columns[0].ColumnName != "搴忓彿")
+ else if (excelTable[1].Columns.Count != 5)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "搴撲綅娓呭崟妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
+ return Message;
}
- else if (excelTable.Columns[1].ColumnName != "搴撳尯缂栫爜(鍞竴)")
+ else if (excelTable[0].Columns[0].ColumnName != "搴忓彿")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "鐢ㄦ埛鐝粍妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�1鍒楀簲涓簕搴忓彿}";
+ return Message;
}
- else if (excelTable.Columns[2].ColumnName != "搴撳尯鍚嶇О锛堝敮涓�锛�")
+ else if (excelTable[0].Columns[1].ColumnName != "浠撳簱缂栧彿(鍞竴)")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "浠撳簱娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�2鍒楀簲涓簕浠撳簱缂栧彿(鍞竴)}";
+ return Message;
}
- else if (excelTable.Columns[3].ColumnName != "鍔熻兘鎻忚堪")
+ else if (excelTable[0].Columns[2].ColumnName != "浠撳簱鍚嶇О")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "浠撳簱娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�3鍒楀簲涓簕浠撳簱鍚嶇О}";
+ return Message;
}
- else if (excelTable.Columns[4].ColumnName != "浠撳簱缂栫爜")
+ else if (excelTable[0].Columns[3].ColumnName != "浠撳簱鎻忚堪")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "浠撳簱娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�4鍒楀簲涓簕浠撳簱鎻忚堪}";
+ return Message;
}
- else if (excelTable.Columns[5].ColumnName != "浠撳簱鍚嶇О")
+ else if (excelTable[1].Columns[0].ColumnName != "搴忓彿")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "搴撲綅娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�1鍒楀簲涓簕搴忓彿}";
+ return Message;
}
- else
- {
- code = "200";
- Message = "妯℃澘妫�楠岄�氳繃";
- }
- return Message;
- }
- #endregion
-
- #region銆怑xcel妯℃澘涓婁紶楠岃瘉,搴撲綅瀹氫箟妯℃澘銆�
- public static string SixThree(string FileCode, out string code)
- {
- string Message = "";
- code = "";
- DataTable excelTable = new DataTable();
- excelTable = ImportExcel.ExcelToTable(FileCode);
- if (excelTable.Columns.Count != 6)
+ else if (excelTable[1].Columns[1].ColumnName != "搴撲綅缂栧彿(鍞竴)")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "搴撲綅娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�2鍒楀簲涓簕搴撲綅缂栧彿(鍞竴)}";
+ return Message;
}
- else if (excelTable.Columns[0].ColumnName != "搴忓彿")
+ else if (excelTable[1].Columns[2].ColumnName != "搴撲綅濮撳悕")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "搴撲綅娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�3鍒楀簲涓簕搴撲綅濮撳悕}";
+ return Message;
}
- else if (excelTable.Columns[1].ColumnName != "搴撲綅缂栫爜(鍞竴)")
+ else if (excelTable[1].Columns[3].ColumnName != "鎵�灞炰粨搴撶紪鐮�")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "搴撲綅娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�4鍒楀簲涓簕鎵�灞炰粨搴撶紪鐮亇";
+ return Message;
}
- else if (excelTable.Columns[2].ColumnName != "搴撲綅鍚嶇О锛堝敮涓�锛�")
+ else if (excelTable[1].Columns[4].ColumnName != "搴撲綅鎻忚堪")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable.Columns[3].ColumnName != "鍔熻兘鎻忚堪")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable.Columns[4].ColumnName != "搴撳尯缂栫爜")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable.Columns[5].ColumnName != "搴撳尯鍚嶇О")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "搴撲綅娓呭崟妯℃澘锛氳〃澶翠俊鎭笉绗﹀悎瑙勮寖,绗�5鍒楀簲涓簕搴撲綅鎻忚堪}";
+ return Message;
}
else
{
@@ -593,7 +634,7 @@
}
#endregion
- #region銆怑xcel妯℃澘涓婁紶楠岃瘉,璁惧鐐规妯℃澘銆�
+ #region銆怑xcel妯℃澘涓婁紶楠岃瘉,璁惧鐐规椤圭洰妯℃澘銆�
public static string Ten(string FileCode, out string code)
{
string Message = "";
@@ -603,82 +644,51 @@
if (excelTable.Count != 2)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,缂哄け鐨凷heet";
+ Message = "瀵煎叆妯℃澘涓嶇鍚堣鑼�,璇锋鏌heet鏁�";
+ return Message;
+
}
- else if (excelTable[0].Columns.Count != 4)
+ else if (excelTable[0].Columns.Count != 6)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
- }
- else if (excelTable[1].Columns.Count != 9)
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
+ Message = "璁惧鐐规椤圭洰妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
+ return Message;
}
else if (excelTable[0].Columns[0].ColumnName != "搴忓彿")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "璁惧鐐规椤圭洰妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�1鍒楀簲涓簕搴忓彿}";
+ return Message;
}
- else if (excelTable[0].Columns[1].ColumnName != "鐐规鏍囧噯(鍞竴)")
+ else if (excelTable[0].Columns[1].ColumnName != "鐐规椤圭洰缂栧彿(鍞竴)")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "璁惧鐐规椤圭洰妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�2鍒楀簲涓簕鐐规椤圭洰缂栧彿(鍞竴)}";
+ return Message;
}
- else if (excelTable[0].Columns[2].ColumnName != "鏍囧噯鍚嶇О锛堝敮涓�锛�")
+ else if (excelTable[0].Columns[2].ColumnName != "鐐规椤圭洰鍚嶇О")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "璁惧鐐规椤圭洰妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�3鍒楀簲涓簕鐐规椤圭洰鍚嶇О}";
+ return Message;
}
- else if (excelTable[0].Columns[3].ColumnName != "鐐规绠℃帶")
+ else if (excelTable[0].Columns[3].ColumnName != "鐐规鍛ㄦ湡")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "璁惧鐐规椤圭洰妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�4鍒楀簲涓簕鐐规鍛ㄦ湡}";
+ return Message;
}
- else if (excelTable[1].Columns[0].ColumnName != "搴忓彿")
+ else if (excelTable[0].Columns[4].ColumnName != "鏄惁鎵爜")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "璁惧鐐规椤圭洰妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�4鍒楀簲涓簕鏄惁鎵爜}";
+ return Message;
}
- else if (excelTable[1].Columns[1].ColumnName != "鐐规鏍囧噯")
+ else if (excelTable[0].Columns[5].ColumnName != "鐐规椤圭洰瑕佹眰")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[2].ColumnName != "鏍囧噯鍚嶇О")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[3].ColumnName != "SEQ(閮ㄤ綅椤哄簭)")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[4].ColumnName != "閮ㄤ綅鏉＄爜锛堝敮涓�锛�")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[5].ColumnName != "閮ㄤ綅鍚嶇О")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[6].ColumnName != "鐐规瑕佹眰")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[7].ColumnName != "鏄惁鎵爜")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[8].ColumnName != "鐐规鍛ㄦ湡")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "璁惧鐐规椤圭洰妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�4鍒楀簲涓簕鐐规椤圭洰瑕佹眰}";
+ return Message;
}
else
{
@@ -689,7 +699,7 @@
}
#endregion
- #region銆怑xcel妯℃澘涓婁紶楠岃瘉,璁惧淇濆吇妯℃澘銆�
+ #region銆怑xcel妯℃澘涓婁紶楠岃瘉,璁惧淇濆吇椤圭洰妯℃澘銆�
public static string Eleven(string FileCode, out string code)
{
string Message = "";
@@ -699,77 +709,45 @@
if (excelTable.Count != 2)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,缂哄け鐨凷heet";
+ Message = "瀵煎叆妯℃澘涓嶇鍚堣鑼�,璇锋鏌heet鏁�";
+ return Message;
+
}
- else if (excelTable[0].Columns.Count != 3)
+ else if (excelTable[0].Columns.Count != 6)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
- }
- else if (excelTable[1].Columns.Count != 9)
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
+ Message = "璁惧淇濆吇椤圭洰妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
+ return Message;
}
else if (excelTable[0].Columns[0].ColumnName != "搴忓彿")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "璁惧淇濆吇椤圭洰妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�1鍒楀簲涓簕搴忓彿}";
+ return Message;
}
- else if (excelTable[0].Columns[1].ColumnName != "淇濆吇鏍囧噯(鍞竴)")
+ else if (excelTable[0].Columns[1].ColumnName != "淇濆吇椤圭洰缂栧彿(鍞竴)")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "璁惧淇濆吇椤圭洰妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�2鍒楀簲涓簕淇濆吇椤圭洰缂栧彿(鍞竴)}";
+ return Message;
}
- else if (excelTable[0].Columns[2].ColumnName != "鏍囧噯鍚嶇О锛堝敮涓�锛�")
+ else if (excelTable[0].Columns[2].ColumnName != "淇濆吇椤圭洰鍚嶇О")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "璁惧淇濆吇椤圭洰妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�3鍒楀簲涓簕淇濆吇椤圭洰鍚嶇О}";
+ return Message;
}
- else if (excelTable[1].Columns[0].ColumnName != "搴忓彿")
+ else if (excelTable[0].Columns[3].ColumnName != "鏄惁鎵爜")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "璁惧淇濆吇椤圭洰妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�4鍒楀簲涓簕鏄惁鎵爜}";
+ return Message;
}
- else if (excelTable[1].Columns[1].ColumnName != "淇濆吇鏍囧噯")
+ else if (excelTable[0].Columns[4].ColumnName != "淇濆吇椤圭洰瑕佹眰")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[2].ColumnName != "鏍囧噯鍚嶇О")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[3].ColumnName != "SEQ(閮ㄤ綅椤哄簭)")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[4].ColumnName != "閮ㄤ綅鏉＄爜锛堝敮涓�锛�")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[5].ColumnName != "閮ㄤ綅鍚嶇О")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[6].ColumnName != "淇濆吇瑕佹眰")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[7].ColumnName != "鏄惁鎵爜")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[8].ColumnName != "淇濆吇鍛ㄦ湡")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "璁惧淇濆吇椤圭洰妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�4鍒楀簲涓簕淇濆吇椤圭洰瑕佹眰}";
+ return Message;
}
else
{
@@ -1281,73 +1259,39 @@
if (excelTable.Count != 2)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,缂哄け鐨凷heet";
+ Message = "瀵煎叆妯℃澘涓嶇鍚堣鑼�,璇锋鏌heet鏁�";
+ return Message;
+
}
else if (excelTable[0].Columns.Count != 4)
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
- }
- else if (excelTable[1].Columns.Count != 7)
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
+ Message = "缂洪櫡瀹氫箟妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚嶅瓧娈垫暟";
+ return Message;
}
else if (excelTable[0].Columns[0].ColumnName != "搴忓彿")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "缂洪櫡瀹氫箟妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�1鍒楀簲涓簕搴忓彿}";
+ return Message;
}
- else if (excelTable[0].Columns[1].ColumnName != "鐗╂枡缂栫爜(鍞竴)")
+ else if (excelTable[0].Columns[1].ColumnName != "缂洪櫡缂栧彿(鍞竴)")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "缂洪櫡瀹氫箟妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�2鍒楀簲涓簕缂洪櫡缂栧彿(鍞竴)}";
+ return Message;
}
- else if (excelTable[0].Columns[2].ColumnName != "鐗╂枡鍚嶇О")
+ else if (excelTable[0].Columns[2].ColumnName != "缂洪櫡鍚嶇О")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "缂洪櫡瀹氫箟妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�3鍒楀簲涓簕缂洪櫡鍚嶇О}";
+ return Message;
}
- else if (excelTable[0].Columns[3].ColumnName != "鍚敤鐘舵��")
+ else if (excelTable[0].Columns[3].ColumnName != "缂洪櫡鎻忚堪")
{
code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
-
- else if (excelTable[1].Columns[0].ColumnName != "搴忓彿")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[1].ColumnName != "鐗╂枡淇℃伅搴忓彿")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[2].ColumnName != "缂洪櫡浠ｇ爜锛堝敮涓�锛�")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[3].ColumnName != "缂洪櫡鍚嶇О")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[4].ColumnName != "涓诲伐鑹鸿矾绾�")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[5].ColumnName != "璐ｄ换宸ュ簭缂栫爜")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
- }
- else if (excelTable[1].Columns[6].ColumnName != "璐ｄ换宸ュ簭鍚嶇О")
- {
- code = "300";
- Message = "妯℃澘涓嶇鍚堣鑼�,璇锋鏌ュ垪鍚�";
+ Message = "缂洪櫡鎻忚堪妯℃澘涓嶇鍚堣鑼冿細琛ㄥご淇℃伅涓嶇鍚堣鑼�,绗�4鍒楀簲涓簕缂洪櫡鎻忚堪}";
+ return Message;
}
else
{
@@ -1589,20 +1533,6 @@
#endregion
#region銆怑xcel涓婁紶鏁版嵁楠岃瘉銆�
- #region銆怑xcel涓婁紶鏁版嵁楠岃瘉,瑙掕壊鏉冮檺銆�
- public static List<ExcelErro> OneData(string FileCode, out string StuCode, out string message, out int count)
- {
- message = "";
- StuCode = "";
- count = 0;
- string sql = "";
- DataTable dt;
- List<ExcelErro> list = new List<ExcelErro>();
-
- return list;
- }
- #endregion
-
#region銆怑xcel涓婁紶鏁版嵁楠岃瘉,鐢ㄦ埛瑙掕壊銆�
public static List<ExcelErro> TwoData(string FileCode, out string StuCode, out string message, out int count)
{
@@ -1610,9 +1540,181 @@
StuCode = "";
count = 0;
string sql = "";
+ var dynamicParams = new DynamicParameters();
DataTable dt;
List<ExcelErro> list = new List<ExcelErro>();
+ List<DataTable> excelTable = new List<DataTable>();
+ list = ImportExcel.ExcelToTableListErro(FileCode); //楠岃瘉Excel鏁版嵁蹇呭～瀛楁鏄惁涓虹┖銆佸敮涓�瀛楁鏄惁閲嶅
+ excelTable = ImportExcel.ExcelToTableList(FileCode); //鑾峰彇Excel鏁版嵁
+ //涓昏〃
+ for (int j = 0; j < excelTable[0].Rows.Count; j++)
+ {
+ if (excelTable[0].Rows[j][1].ToString().Trim() != null && excelTable[0].Rows[j][1].ToString().Trim() != "")
+ {
+ sql = @"select * from TGroup where group_code=@group_code";
+ dynamicParams.Add("@group_code", excelTable[0].Rows[j][1].ToString().Trim());
+ dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{鐝粍缂栫爜(鍞竴)}";
+ erro.ErrorCont = "鐝粍琛�:{鐝粍缂栫爜(鍞竴)}瀛楁" + excelTable[0].Rows[j][1].ToString().Trim() + "宸插瓨鍦�";
+ list.Add(erro);
+ }
+ }
+ }
+ //瀛愯〃
+ for (int k = 0; k < excelTable[1].Rows.Count; k++)
+ {
+ if (excelTable[1].Rows[k][1].ToString().Trim() != null && excelTable[1].Rows[k][1].ToString().Trim() != "")
+ {
+ sql = @"select * from TUser where usercode=@usercode";
+ dynamicParams.Add("@usercode", excelTable[1].Rows[k][1].ToString().Trim());
+ dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{鐢ㄦ埛缂栫爜(鍞竴)}";
+ erro.ErrorCont = "鐢ㄦ埛琛�:{鐢ㄦ埛缂栫爜(鍞竴)}瀛楁" + excelTable[1].Rows[k][2].ToString().Trim() + "宸插瓨鍦�";
+ list.Add(erro);
+ }
+ }
+ if (excelTable[1].Rows[k][7].ToString().Trim() != null && excelTable[1].Rows[k][7].ToString().Trim() != "")
+ {
+ sql = @"select * from TOrganization where org_code=@org_code";
+ dynamicParams.Add("@org_code", excelTable[1].Rows[k][7].ToString().Trim());
+ dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt == null || dt.Rows.Count <= 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{缁勭粐缂栫爜}";
+ erro.ErrorCont = "鐢ㄦ埛琛�:{缁勭粐缂栫爜}瀛楁" + excelTable[1].Rows[k][2].ToString().Trim() + "涓嶅瓨鍦�";
+ list.Add(erro);
+ }
+ }
+ }
+ //鍒ゆ柇瀛愯〃澶栭敭涓嶅瓨鍦ㄤ簬涓昏〃涓婚敭涓殑鏁版嵁
+ var dt3 = from r in excelTable[1].AsEnumerable()
+ where !(
+ from rr in excelTable[0].AsEnumerable()
+ select rr.Field<string>("鐝粍缂栧彿(鍞竴)")
+ ).Contains(r.Field<string>("鐢ㄦ埛缁勭紪鐮�"))
+ select r;
+ List<DataRow> listRow = dt3.ToList();
+ if (listRow.Count > 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{鐢ㄦ埛缁勭紪鐮亇";
+ erro.ErrorCont = "鐢ㄦ埛琛�:{鐢ㄦ埛缁勭紪鐮亇瀛楁涓湁鍊煎湪鐝粍琛�:{鐝粍缂栧彿(鍞竴)}涓笉瀛樺湪";
+ list.Add(erro);
+ }
+ if (list.Count > 0)
+ {
+ int index = 0;
+ foreach (ExcelErro item in list)
+ {
+ index++;
+ item.Seq = index.ToString();
+ }
+ StuCode = "301";
+ message = "鏁版嵁楠岃瘉澶辫触";
+ }
+ else
+ {
+ StuCode = "200";
+ message = "鏁版嵁楠岃瘉鎴愬姛";
+ count = excelTable[0].Rows.Count + excelTable[1].Rows.Count;
+ }
+ return list;
+ }
+ #endregion
+ #region銆怑xcel涓婁紶鏁版嵁楠岃瘉,瑙掕壊鏉冮檺銆�
+ public static List<ExcelErro> OneData(string FileCode, out string StuCode, out string message, out int count)
+ {
+ message = "";
+ StuCode = "";
+ count = 0;
+ string sql = "";
+ var dynamicParams = new DynamicParameters();
+ DataTable dt;
+ List<ExcelErro> list = new List<ExcelErro>();
+ List<DataTable> excelTable = new List<DataTable>();
+ list = ImportExcel.ExcelToTableListErro(FileCode); //楠岃瘉Excel鏁版嵁蹇呭～瀛楁鏄惁涓虹┖銆佸敮涓�瀛楁鏄惁閲嶅
+ excelTable = ImportExcel.ExcelToTableList(FileCode); //鑾峰彇Excel鏁版嵁
+ //涓昏〃
+ for (int j = 0; j < excelTable[0].Rows.Count; j++)
+ {
+ if (excelTable[0].Rows[j][1].ToString().Trim() != null && excelTable[0].Rows[j][1].ToString().Trim() != "")
+ {
+ sql = @"select * from TRoleType where roletype_code=@roletype_code";
+ dynamicParams.Add("@roletype_code", excelTable[0].Rows[j][1].ToString().Trim());
+ dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{瑙掕壊绫诲瀷缂栫爜(鍞竴)}";
+ erro.ErrorCont = "鐝粍琛�:{瑙掕壊绫诲瀷缂栫爜(鍞竴)}瀛楁" + excelTable[0].Rows[j][1].ToString().Trim() + "宸插瓨鍦�";
+ list.Add(erro);
+ }
+ }
+ }
+ //瀛愯〃
+ for (int k = 0; k < excelTable[1].Rows.Count; k++)
+ {
+ if (excelTable[1].Rows[k][1].ToString().Trim() != null && excelTable[1].Rows[k][1].ToString().Trim() != "")
+ {
+ sql = @"select * from TRole where role_code=@role_code";
+ dynamicParams.Add("@role_code", excelTable[1].Rows[k][1].ToString().Trim());
+ dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{瑙掕壊缂栧彿(鍞竴)}";
+ erro.ErrorCont = "瑙掕壊琛�:{瑙掕壊缂栧彿(鍞竴)}瀛楁" + excelTable[1].Rows[k][2].ToString().Trim() + "宸插瓨鍦�";
+ list.Add(erro);
+ }
+ }
+ }
+ //鍒ゆ柇瀛愯〃澶栭敭涓嶅瓨鍦ㄤ簬涓昏〃涓婚敭涓殑鏁版嵁
+ var dt3 = from r in excelTable[1].AsEnumerable()
+ where !(
+ from rr in excelTable[0].AsEnumerable()
+ select rr.Field<string>("瑙掕壊绫诲瀷缂栧彿(鍞竴)")
+ ).Contains(r.Field<string>("瑙掕壊绫诲瀷缂栫爜"))
+ select r;
+ List<DataRow> listRow = dt3.ToList();
+ if (listRow.Count > 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{瑙掕壊绫诲瀷缂栫爜}";
+ erro.ErrorCont = "瑙掕壊琛�:{瑙掕壊绫诲瀷缂栫爜}瀛楁涓湁鍊煎湪瑙掕壊绫诲瀷琛�:{瑙掕壊绫诲瀷缂栧彿(鍞竴)}涓笉瀛樺湪";
+ list.Add(erro);
+ }
+ if (list.Count > 0)
+ {
+ int index = 0;
+ foreach (ExcelErro item in list)
+ {
+ index++;
+ item.Seq = index.ToString();
+ }
+ StuCode = "301";
+ message = "鏁版嵁楠岃瘉澶辫触";
+ }
+ else
+ {
+ StuCode = "200";
+ message = "鏁版嵁楠岃瘉鎴愬姛";
+ count = excelTable[0].Rows.Count + excelTable[1].Rows.Count;
+ }
return list;
}
#endregion
@@ -1631,7 +1733,7 @@
}
#endregion
- #region銆怑xcel涓婁紶鏁版嵁楠岃瘉,渚涙柟娓呭崟銆�
+ #region銆怑xcel涓婁紶鏁版嵁楠岃瘉,寰�鏉ュ崟浣嶆竻鍗曘��
public static List<ExcelErro> FourData(string FileCode, out string StuCode, out string message, out int count)
{
message = "";
@@ -1639,64 +1741,132 @@
count = 0;
string sql = "";
DataTable dt;
+ var dynamicParams = new DynamicParameters();
List<ExcelErro> list = new List<ExcelErro>();
+ DataTable excelTable = new DataTable();
+ list = ImportExcel.ExcelToTableErro(FileCode); //楠岃瘉Excel鏁版嵁蹇呭～瀛楁鏄惁涓虹┖銆佸敮涓�瀛楁鏄惁閲嶅
+ excelTable = ImportExcel.ExcelToTable(FileCode); //鑾峰彇Excel鏁版嵁
+ for (int i = 0; i < excelTable.Rows.Count; i++)
+ {
+ if (excelTable.Rows[i][1].ToString().Trim() != null && excelTable.Rows[i][1].ToString().Trim() != "")
+ {
+ sql = @"select code from TCustomer where code=@code";
+ dynamicParams.Add("@code", excelTable.Rows[i][1].ToString().Trim());
+ dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{寰�鏉ュ崟浣嶇紪鐮�(鍞竴)}";
+ erro.ErrorCont = "寰�鏉ュ崟浣嶈〃:{寰�鏉ュ崟浣嶇紪鐮�(鍞竴)}瀛楁" + excelTable.Rows[i][1].ToString().Trim() + "宸插瓨鍦�";
+ list.Add(erro);
+ }
+ }
+ }
+ if (list.Count > 0)
+ {
+ int index = 0;
+ foreach (ExcelErro item in list)
+ {
+ index++;
+ item.Seq = index.ToString();
+ }
+ StuCode = "301";
+ message = "鏁版嵁楠岃瘉澶辫触";
+ }
+ else
+ {
+ StuCode = "200";
+ message = "鏁版嵁楠岃瘉鎴愬姛";
+ count = excelTable.Rows.Count;
+ }
return list;
}
#endregion
- #region銆怑xcel涓婁紶鏁版嵁楠岃瘉,瀹㈡埛娓呭崟銆�
- public static List<ExcelErro> FiveData(string FileCode, out string StuCode, out string message, out int count)
- {
- message = "";
- StuCode = "";
- count = 0;
- string sql = "";
- DataTable dt;
- List<ExcelErro> list = new List<ExcelErro>();
-
- return list;
- }
- #endregion
-
- #region銆怑xcel涓婁紶鏁版嵁楠岃瘉,浠撳簱瀹氫箟銆�
+ #region銆怑xcel涓婁紶鏁版嵁楠岃瘉,浠撳簱銆佸簱浣嶅畾涔夈��
public static List<ExcelErro> SixOneData(string FileCode, out string StuCode, out string message, out int count)
{
message = "";
StuCode = "";
count = 0;
string sql = "";
+ var dynamicParams = new DynamicParameters();
DataTable dt;
List<ExcelErro> list = new List<ExcelErro>();
-
- return list;
- }
- #endregion
-
- #region銆怑xcel涓婁紶鏁版嵁楠岃瘉,搴撳尯瀹氫箟銆�
- public static List<ExcelErro> SixTwoData(string FileCode, out string StuCode, out string message, out int count)
- {
- message = "";
- StuCode = "";
- count = 0;
- string sql = "";
- DataTable dt;
- List<ExcelErro> list = new List<ExcelErro>();
-
- return list;
- }
- #endregion
-
- #region銆怑xcel涓婁紶鏁版嵁楠岃瘉,搴撲綅瀹氫箟銆�
- public static List<ExcelErro> SixThreeData(string FileCode, out string StuCode, out string message, out int count)
- {
- message = "";
- StuCode = "";
- count = 0;
- string sql = "";
- DataTable dt;
- List<ExcelErro> list = new List<ExcelErro>();
-
+ List<DataTable> excelTable = new List<DataTable>();
+ list = ImportExcel.ExcelToTableListErro(FileCode); //楠岃瘉Excel鏁版嵁蹇呭～瀛楁鏄惁涓虹┖銆佸敮涓�瀛楁鏄惁閲嶅
+ excelTable = ImportExcel.ExcelToTableList(FileCode); //鑾峰彇Excel鏁版嵁
+ //浠撳簱琛�
+ for (int j = 0; j < excelTable[0].Rows.Count; j++)
+ {
+ if (excelTable[0].Rows[j][1].ToString().Trim() != null && excelTable[0].Rows[j][1].ToString().Trim() != "")
+ {
+ sql = @"select * from T_Sec_Stck where code=@code";
+ dynamicParams.Add("@code", excelTable[0].Rows[j][1].ToString().Trim());
+ dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{浠撳簱缂栧彿(鍞竴)}";
+ erro.ErrorCont = "浠撳簱琛�:{浠撳簱缂栧彿(鍞竴)}瀛楁" + excelTable[0].Rows[j][1].ToString().Trim() + "宸插瓨鍦�";
+ list.Add(erro);
+ }
+ }
+ }
+ //搴撲綅琛�
+ for (int k = 0; k < excelTable[1].Rows.Count; k++)
+ {
+ if (excelTable[1].Rows[k][1].ToString().Trim() != null && excelTable[1].Rows[k][1].ToString().Trim() != "")
+ {
+ sql = @"select * from T_Sec_Loca where code=@code";
+ dynamicParams.Add("@code", excelTable[1].Rows[k][1].ToString().Trim());
+ dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{搴撲綅缂栧彿(鍞竴)}";
+ erro.ErrorCont = "搴撲綅琛�:{搴撲綅缂栧彿(鍞竴)}瀛楁" + excelTable[1].Rows[k][2].ToString().Trim() + "宸插瓨鍦�";
+ list.Add(erro);
+ }
+ }
+ }
+ //鍒ゆ柇瀛愯〃澶栭敭涓嶅瓨鍦ㄤ簬涓昏〃涓婚敭涓殑鏁版嵁
+ var dt3 = from r in excelTable[1].AsEnumerable()
+ where !(
+ from rr in excelTable[0].AsEnumerable()
+ select rr.Field<string>("浠撳簱缂栧彿(鍞竴)")
+ ).Contains(r.Field<string>("鎵�灞炰粨搴撶紪鐮�"))
+ select r;
+ List<DataRow> listRow = dt3.ToList();
+ if (listRow.Count > 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{鎵�灞炰粨搴撶紪鐮亇";
+ erro.ErrorCont = "搴撲綅琛�:{鎵�灞炰粨搴撶紪鐮亇瀛楁涓湁鍊煎湪浠撳簱琛�:{浠撳簱缂栧彿(鍞竴)}涓笉瀛樺湪";
+ list.Add(erro);
+ }
+ if (list.Count > 0)
+ {
+ int index = 0;
+ foreach (ExcelErro item in list)
+ {
+ index++;
+ item.Seq = index.ToString();
+ }
+ StuCode = "301";
+ message = "鏁版嵁楠岃瘉澶辫触";
+ }
+ else
+ {
+ StuCode = "200";
+ message = "鏁版嵁楠岃瘉鎴愬姛";
+ count = excelTable[0].Rows.Count + excelTable[1].Rows.Count;
+ }
return list;
}
#endregion
@@ -1743,7 +1913,7 @@
}
#endregion
- #region銆怑xcel涓婁紶鏁版嵁楠岃瘉,璁惧鐐规銆�
+ #region銆怑xcel涓婁紶鏁版嵁楠岃瘉,璁惧鐐规椤圭洰銆�
public static List<ExcelErro> TenData(string FileCode, out string StuCode, out string message, out int count)
{
@@ -1752,13 +1922,51 @@
count = 0;
string sql = "";
DataTable dt;
+ var dynamicParams = new DynamicParameters();
List<ExcelErro> list = new List<ExcelErro>();
+ DataTable excelTable = new DataTable();
+ list = ImportExcel.ExcelToTableErro(FileCode); //楠岃瘉Excel鏁版嵁蹇呭～瀛楁鏄惁涓虹┖銆佸敮涓�瀛楁鏄惁閲嶅
+ excelTable = ImportExcel.ExcelToTable(FileCode); //鑾峰彇Excel鏁版嵁
+ for (int i = 0; i < excelTable.Rows.Count; i++)
+ {
+ if (excelTable.Rows[i][1].ToString().Trim() != null && excelTable.Rows[i][1].ToString().Trim() != "")
+ {
+ sql = @"select code from TEqpchk_Item where code=@code";
+ dynamicParams.Add("@code", excelTable.Rows[i][1].ToString().Trim());
+ dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{鐐规椤圭洰缂栧彿(鍞竴)}";
+ erro.ErrorCont = "璁惧鐐规椤圭洰琛�:{鐐规椤圭洰缂栧彿(鍞竴)}瀛楁" + excelTable.Rows[i][1].ToString().Trim() + "宸插瓨鍦�";
+ list.Add(erro);
+ }
+ }
+ }
+ if (list.Count > 0)
+ {
+ int index = 0;
+ foreach (ExcelErro item in list)
+ {
+ index++;
+ item.Seq = index.ToString();
+ }
+ StuCode = "301";
+ message = "鏁版嵁楠岃瘉澶辫触";
+ }
+ else
+ {
+ StuCode = "200";
+ message = "鏁版嵁楠岃瘉鎴愬姛";
+ count = excelTable.Rows.Count;
+ }
return list;
}
#endregion
- #region銆怑xcel涓婁紶鏁版嵁楠岃瘉,璁惧淇濆吇銆�
+ #region銆怑xcel涓婁紶鏁版嵁楠岃瘉,璁惧淇濆吇椤圭洰銆�
public static List<ExcelErro> ElevenData(string FileCode, out string StuCode, out string message, out int count)
{
message = "";
@@ -1766,8 +1974,46 @@
count = 0;
string sql = "";
DataTable dt;
+ var dynamicParams = new DynamicParameters();
List<ExcelErro> list = new List<ExcelErro>();
+ DataTable excelTable = new DataTable();
+ list = ImportExcel.ExcelToTableErro(FileCode); //楠岃瘉Excel鏁版嵁蹇呭～瀛楁鏄惁涓虹┖銆佸敮涓�瀛楁鏄惁閲嶅
+ excelTable = ImportExcel.ExcelToTable(FileCode); //鑾峰彇Excel鏁版嵁
+ for (int i = 0; i < excelTable.Rows.Count; i++)
+ {
+ if (excelTable.Rows[i][1].ToString().Trim() != null && excelTable.Rows[i][1].ToString().Trim() != "")
+ {
+ sql = @"select code from TEqpmai_Item where code=@code";
+ dynamicParams.Add("@code", excelTable.Rows[i][1].ToString().Trim());
+ dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{淇濆吇椤圭洰缂栧彿(鍞竴)}";
+ erro.ErrorCont = "璁惧淇濆吇椤圭洰琛�:{鐐规淇濆吇缂栧彿(鍞竴)}瀛楁" + excelTable.Rows[i][1].ToString().Trim() + "宸插瓨鍦�";
+ list.Add(erro);
+ }
+ }
+ }
+ if (list.Count > 0)
+ {
+ int index = 0;
+ foreach (ExcelErro item in list)
+ {
+ index++;
+ item.Seq = index.ToString();
+ }
+ StuCode = "301";
+ message = "鏁版嵁楠岃瘉澶辫触";
+ }
+ else
+ {
+ StuCode = "200";
+ message = "鏁版嵁楠岃瘉鎴愬姛";
+ count = excelTable.Rows.Count;
+ }
return list;
}
#endregion
@@ -1864,8 +2110,46 @@
count = 0;
string sql = "";
DataTable dt;
+ var dynamicParams = new DynamicParameters();
List<ExcelErro> list = new List<ExcelErro>();
+ DataTable excelTable = new DataTable();
+ list = ImportExcel.ExcelToTableErro(FileCode); //楠岃瘉Excel鏁版嵁蹇呭～瀛楁鏄惁涓虹┖銆佸敮涓�瀛楁鏄惁閲嶅
+ excelTable = ImportExcel.ExcelToTable(FileCode); //鑾峰彇Excel鏁版嵁
+ for (int i = 0; i < excelTable.Rows.Count; i++)
+ {
+ if (excelTable.Rows[i][1].ToString().Trim() != null && excelTable.Rows[i][1].ToString().Trim() != "")
+ {
+ sql = @"select code from TDefect where code=@code";
+ dynamicParams.Add("@code", excelTable.Rows[i][1].ToString().Trim());
+ dt = DapperHelper.selectdata(sql, dynamicParams);
+ if (dt.Rows.Count > 0)
+ {
+ ExcelErro erro = new ExcelErro();
+ erro.RoeNumber = "/";
+ erro.ErrorField = "{缂洪櫡瀹氫箟缂栧彿(鍞竴)}";
+ erro.ErrorCont = "缂洪櫡瀹氫箟琛�:{缂洪櫡瀹氫箟缂栧彿(鍞竴)}瀛楁" + excelTable.Rows[i][1].ToString().Trim() + "宸插瓨鍦�";
+ list.Add(erro);
+ }
+ }
+ }
+ if (list.Count > 0)
+ {
+ int index = 0;
+ foreach (ExcelErro item in list)
+ {
+ index++;
+ item.Seq = index.ToString();
+ }
+ StuCode = "301";
+ message = "鏁版嵁楠岃瘉澶辫触";
+ }
+ else
+ {
+ StuCode = "200";
+ message = "鏁版嵁楠岃瘉鎴愬姛";
+ count = excelTable.Rows.Count;
+ }
return list;
}
#endregion
@@ -1949,14 +2233,94 @@
#endregion
#region[Excel涓婁紶鏁版嵁鎻愪氦]
- #region[Excel鏁版嵁涓婁紶,瑙掕壊鏉冮檺]
- public static string OneSubmit(string FileCode, string User, out string StuCode)
+ #region銆怑xcel鏁版嵁涓婁紶,鐢ㄦ埛瑙掕壊銆�
+ public static string TwoSubmit(string FileCode, string User, out string StuCode)
{
string message = "";
StuCode = "";
+ string sql = "";
+ string ZZName = "", Enable = "", WageType = "";
+ DataTable dt;
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
try
{
+ list.Clear();
+ List<DataTable> excelTable = new List<DataTable>();
+ excelTable = ImportExcel.ExcelToTableList(FileCode);
+ //瀵煎叆鐝粍
+ for (int k = 0; k < excelTable[0].Rows.Count; k++)
+ {
+ sql = @"insert into TGroup(group_code,group_name,description,lm_user,lm_date)
+ values(@group_code,@group_name,@description,@Operator,@CreateDate)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ group_code = excelTable[0].Rows[k][1].ToString().Trim(),
+ group_name = excelTable[0].Rows[k][2].ToString().Trim(),
+ description = excelTable[0].Rows[k][3].ToString().Trim(),
+ CreateDate = DateTime.Now.ToString(),
+ Operator = User
+ }
+ });
+ }
+ //瀵煎叆鐢ㄦ埛
+ for (int i = 0; i < excelTable[1].Rows.Count; i++)
+ {
+ if (excelTable[1].Rows[i][3].ToString().Trim() == "鍦ㄨ亴")
+ {
+ Enable = "Y";
+ }
+ else
+ {
+ Enable = "N";
+ }
+ //宸ヨ祫绫诲瀷
+ switch (excelTable[1].Rows[i][8].ToString().Trim())
+ {
+ case "璁′欢鍒�":
+ WageType = "2";
+ break;
+ case "璁℃椂鍒�":
+ WageType = "1";
+ break;
+ default:
+ break;
+ }
+ sql = @"insert into TUser(usercode,username,password,enable,mobile,lm_date,email,lm_user,stu_torgcode,wagetype)
+ values(@UserCode,@UserName,@password,@Enable,@Mobile,@CreateDate,@Email,@Operator,@StuOrg,@wagetype)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ UserCode = excelTable[1].Rows[i][1].ToString().Trim(),
+ UserName = excelTable[1].Rows[i][2].ToString().Trim(),
+ password = excelTable[1].Rows[i][4].ToString().Trim(),
+ Enable = Enable,
+ Mobile = excelTable[1].Rows[i][5].ToString().Trim(),
+ CreateDate = DateTime.Now.ToString(),
+ Email = excelTable[1].Rows[i][6].ToString().Trim(),
+ Operator = User,
+ StuOrg = excelTable[1].Rows[i][7].ToString().Trim(),
+ wagetype = WageType
+ }
+ });
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ StuCode = "200";
+ message = "瀵煎叆鎴愬姛锛�";
+ }
+ else
+ {
+ StuCode = "300";
+ message = "瀵煎叆澶辫触锛�";
+ }
}
catch (Exception e)
{
@@ -1967,14 +2331,66 @@
}
#endregion
- #region銆怑xcel鏁版嵁涓婁紶,鐢ㄦ埛瑙掕壊銆�
- public static string TwoSubmit(string FileCode, string User, out string StuCode)
+ #region[Excel鏁版嵁涓婁紶,瑙掕壊鏉冮檺]
+ public static string OneSubmit(string FileCode, string User, out string StuCode)
{
string message = "";
StuCode = "";
+ string sql = "";
+ string ZZName = "", Enable = "", WageType = "";
+ DataTable dt;
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
try
{
-
+ list.Clear();
+ List<DataTable> excelTable = new List<DataTable>();
+ excelTable = ImportExcel.ExcelToTableList(FileCode);
+ //瀵煎叆瑙掕壊绫诲瀷
+ for (int k = 0; k < excelTable[0].Rows.Count; k++)
+ {
+ sql = @"insert into TRoleType(roletype_code,roletype_name)
+ values(@roletype_code,@roletype_name)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ roletype_code = excelTable[0].Rows[k][1].ToString().Trim(),
+ roletype_name = excelTable[0].Rows[k][2].ToString().Trim()
+ }
+ });
+ }
+ //瀵煎叆瑙掕壊
+ for (int i = 0; i < excelTable[1].Rows.Count; i++)
+ {
+ sql = @"insert into TRole(role_code,role_name,roletype_code,description,lm_user,lm_date)
+ values(@role_code,@role_name,@roletype_code,@description,@Operator,@CreateDate)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ role_code = excelTable[1].Rows[i][1].ToString().Trim(),
+ role_name = excelTable[1].Rows[i][2].ToString().Trim(),
+ roletype_code = excelTable[1].Rows[i][3].ToString().Trim(),
+ description = excelTable[1].Rows[i][4].ToString().Trim(),
+ Operator = User,
+ CreateDate = DateTime.Now.ToString()
+ }
+ });
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ StuCode = "200";
+ message = "瀵煎叆鎴愬姛锛�";
+ }
+ else
+ {
+ StuCode = "300";
+ message = "瀵煎叆澶辫触锛�";
+ }
}
catch (Exception e)
{
@@ -2003,14 +2419,70 @@
}
#endregion
- #region銆怑xcel鏁版嵁涓婁紶,渚涙柟娓呭崟銆�
+ #region銆怑xcel鏁版嵁涓婁紶,寰�鏉ュ崟浣嶆竻鍗曘��
public static string FourSubmit(string FileCode, string User, out string StuCode)
{
string message = "";
StuCode = "";
+ string sql = "";
+ DataTable dt;
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
try
{
+ list.Clear();
+ DataTable excelTable = new DataTable();
+ excelTable = ImportExcel.ExcelToTable(FileCode);
+ //瀵煎叆寰�鏉ュ崟浣嶈〃
+ for (int i = 0; i < excelTable.Rows.Count; i++)
+ {
+ string WGType = "", WXType = "", KHType = "";
+ switch (excelTable.Rows[i][3].ToString().Trim())
+ {
+ case "澶栬喘渚涙柟":
+ WGType = "WG";
+ break;
+ case "澶栧崗渚涙柟":
+ WXType = "WX";
+ break;
+ case "瀹㈡埛":
+ KHType = "KH";
+ break;
+ default:
+ break;
+ }
+ sql = @"insert into TCustomer(code,name,mtype,conttacts,conttphone,addr,lm_user,lm_date,btype,htype)
+ values(@code,@name,@mtype,@conttacts,@conttphone,@addr,@Operator,@CreateDate,@btype,@htype)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ code = excelTable.Rows[i][1].ToString().Trim(),
+ name = excelTable.Rows[i][2].ToString().Trim(),
+ mtype = WGType,
+ conttacts = excelTable.Rows[i][4].ToString().Trim(),
+ conttphone = excelTable.Rows[i][5].ToString().Trim(),
+ addr = excelTable.Rows[i][6].ToString().Trim(),
+ Operator = User,
+ CreateDate = DateTime.Now.ToString(),
+ btype = WXType,
+ htype = KHType
+ }
+ });
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ StuCode = "200";
+ message = "瀵煎叆鎴愬姛锛�";
+ }
+ else
+ {
+ StuCode = "300";
+ message = "瀵煎叆澶辫触锛�";
+ }
}
catch (Exception e)
{
@@ -2021,68 +2493,67 @@
}
#endregion
- #region銆怑xcel鏁版嵁涓婁紶,瀹㈡埛娓呭崟銆�
- public static string FiveSubmit(string FileCode, string User, out string StuCode)
- {
- string message = "";
- StuCode = "";
- try
- {
-
- }
- catch (Exception e)
- {
- StuCode = "300";
- message = e.Message;
- }
- return message;
- }
- #endregion
-
- #region銆怑xcel鏁版嵁涓婁紶,浠撳簱瀹氫箟銆�
+ #region銆怑xcel鏁版嵁涓婁紶,浠撳簱銆佸簱浣嶅畾涔夈��
public static string SixOneSubmit(string FileCode, string User, out string StuCode)
{
string message = "";
StuCode = "";
+ string sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
try
{
-
- }
- catch (Exception e)
- {
- StuCode = "300";
- message = e.Message;
- }
- return message;
- }
- #endregion
-
- #region銆怑xcel鏁版嵁涓婁紶,搴撳尯瀹氫箟銆�
- public static string SixTwoSubmit(string FileCode, string User, out string StuCode)
- {
- string message = "";
- StuCode = "";
- try
- {
-
- }
- catch (Exception e)
- {
- StuCode = "300";
- message = e.Message;
- }
- return message;
- }
- #endregion
-
- #region銆怑xcel鏁版嵁涓婁紶,搴撲綅瀹氫箟銆�
- public static string SixThreeSubmit(string FileCode, string User, out string StuCode)
- {
- string message = "";
- StuCode = "";
- try
- {
-
+ list.Clear();
+ List<DataTable> excelTable = new List<DataTable>();
+ excelTable = ImportExcel.ExcelToTableList(FileCode);
+ //瀵煎叆浠撳簱
+ for (int k = 0; k < excelTable[0].Rows.Count; k++)
+ {
+ sql = @"insert into T_Sec_Stck(code,name,description,lm_user,lm_date)
+ values(@code,@name,@description,@Operator,@CreateDate)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ code = excelTable[0].Rows[k][1].ToString().Trim(),
+ name = excelTable[0].Rows[k][2].ToString().Trim(),
+ description = excelTable[0].Rows[k][3].ToString().Trim(),
+ CreateDate = DateTime.Now.ToString(),
+ Operator = User
+ }
+ });
+ }
+ //瀵煎叆搴撲綅
+ for (int i = 0; i < excelTable[1].Rows.Count; i++)
+ {
+ sql = @"insert into T_Sec_Loca(code,name,description,stock_code,lm_user,lm_date)
+ values(@code,@name,@description,@stock_code,@Operator,@CreateDate)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ code = excelTable[1].Rows[i][1].ToString().Trim(),
+ name = excelTable[1].Rows[i][2].ToString().Trim(),
+ stock_code = excelTable[1].Rows[i][3].ToString().Trim(),
+ description = excelTable[1].Rows[i][4].ToString().Trim(),
+ Operator = User,
+ CreateDate = DateTime.Now.ToString()
+ }
+ });
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ StuCode = "200";
+ message = "瀵煎叆鎴愬姛锛�";
+ }
+ else
+ {
+ StuCode = "300";
+ message = "瀵煎叆澶辫触锛�";
+ }
}
catch (Exception e)
{
@@ -2147,14 +2618,82 @@
}
#endregion
- #region銆怑xcel鏁版嵁涓婁紶,璁惧鐐规銆�
+ #region銆怑xcel鏁版嵁涓婁紶,璁惧鐐规椤圭洰銆�
public static string TenSubmit(string FileCode, string User, out string StuCode)
{
string message = "";
StuCode = "";
+ string sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
try
{
-
+ list.Clear();
+ DataTable excelTable = new DataTable();
+ excelTable = ImportExcel.ExcelToTable(FileCode);
+ //瀵煎叆璁惧鐐规椤圭洰琛�
+ for (int i = 0; i < excelTable.Rows.Count; i++)
+ {
+ string Type = "",IsScan="";
+ switch (excelTable.Rows[i][3].ToString().Trim())
+ {
+ case "骞�":
+ Type = "Y";
+ break;
+ case "瀛�":
+ Type = "S";
+ break;
+ case "鏈�":
+ Type = "M";
+ break;
+ case "鍛�":
+ Type = "W";
+ break;
+ case "鏃�":
+ Type = "D";
+ break;
+ default:
+ break;
+ }
+ switch (excelTable.Rows[i][4].ToString().Trim())
+ {
+ case "鏄�":
+ IsScan = "Y";
+ break;
+ case "鍚�":
+ IsScan = "N";
+ break;
+ default:
+ break;
+ }
+ sql = @"insert into TEqpchk_Item(code,name,description,isscan,cycle,lm_user,lm_date)
+ values(@code,@name,@descr,@Operator,@CreateDate)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ code = excelTable.Rows[i][1].ToString().Trim(),
+ name = excelTable.Rows[i][2].ToString().Trim(),
+ descr = excelTable.Rows[i][5].ToString().Trim(),
+ isscan = IsScan,
+ cycle = Type,
+ Operator = User,
+ CreateDate = DateTime.Now.ToString()
+ }
+ });
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ StuCode = "200";
+ message = "瀵煎叆鎴愬姛锛�";
+ }
+ else
+ {
+ StuCode = "300";
+ message = "瀵煎叆澶辫触锛�";
+ }
}
catch (Exception e)
{
@@ -2165,14 +2704,82 @@
}
#endregion
- #region銆怑xcel鏁版嵁涓婁紶,璁惧淇濆吇銆�
+ #region銆怑xcel鏁版嵁涓婁紶,璁惧淇濆吇椤圭洰銆�
public static string ElevenSubmit(string FileCode, string User, out string StuCode)
{
string message = "";
StuCode = "";
+ string sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
try
{
-
+ list.Clear();
+ DataTable excelTable = new DataTable();
+ excelTable = ImportExcel.ExcelToTable(FileCode);
+ //瀵煎叆璁惧鐐规椤圭洰琛�
+ for (int i = 0; i < excelTable.Rows.Count; i++)
+ {
+ string Type = "", IsScan = "";
+ //switch (excelTable.Rows[i][3].ToString().Trim())
+ //{
+ // case "骞�":
+ // Type = "Y";
+ // break;
+ // case "瀛�":
+ // Type = "S";
+ // break;
+ // case "鏈�":
+ // Type = "M";
+ // break;
+ // case "鍛�":
+ // Type = "W";
+ // break;
+ // case "鏃�":
+ // Type = "D";
+ // break;
+ // default:
+ // break;
+ //}
+ switch (excelTable.Rows[i][4].ToString().Trim())
+ {
+ case "鏄�":
+ IsScan = "Y";
+ break;
+ case "鍚�":
+ IsScan = "N";
+ break;
+ default:
+ break;
+ }
+ sql = @"insert into TEqpmai_Item(code,name,description,isscan,cycle,lm_user,lm_date)
+ values(@code,@name,@descr,@Operator,@CreateDate)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ code = excelTable.Rows[i][1].ToString().Trim(),
+ name = excelTable.Rows[i][2].ToString().Trim(),
+ descr = excelTable.Rows[i][5].ToString().Trim(),
+ isscan = IsScan,
+ cycle = "",
+ Operator = User,
+ CreateDate = DateTime.Now.ToString()
+ }
+ });
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ StuCode = "200";
+ message = "瀵煎叆鎴愬姛锛�";
+ }
+ else
+ {
+ StuCode = "300";
+ message = "瀵煎叆澶辫触锛�";
+ }
}
catch (Exception e)
{
@@ -2296,9 +2903,44 @@
{
string message = "";
StuCode = "";
+ string sql = "";
+ DataTable dt;
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
try
{
-
+ list.Clear();
+ DataTable excelTable = new DataTable();
+ excelTable = ImportExcel.ExcelToTable(FileCode);
+ //瀵煎叆寰�鏉ュ崟浣嶈〃
+ for (int i = 0; i < excelTable.Rows.Count; i++)
+ {
+ sql = @"insert into TDefect(code,name,descr,lm_user,lm_date)
+ values(@code,@name,@descr,@Operator,@CreateDate)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ code = excelTable.Rows[i][1].ToString().Trim(),
+ name = excelTable.Rows[i][2].ToString().Trim(),
+ descr = excelTable.Rows[i][3].ToString().Trim(),
+ Operator = User,
+ CreateDate = DateTime.Now.ToString()
+ }
+ });
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ StuCode = "200";
+ message = "瀵煎叆鎴愬姛锛�";
+ }
+ else
+ {
+ StuCode = "300";
+ message = "瀵煎叆澶辫触锛�";
+ }
}
catch (Exception e)
{
--
Gitblit v1.9.3