From 8cdeacd407027fdffa13b86c089c6ab407f3b773 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期三, 13 十二月 2023 17:57:06 +0800
Subject: [PATCH] 1.设备保养项目、设备保养标准导入接口开发
---
VueWebCoreApi/DLL/DAL/ExcelCheckDAL.cs | 154 ++++++++++++++++++++++++++++----------------------
1 files changed, 86 insertions(+), 68 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/ExcelCheckDAL.cs b/VueWebCoreApi/DLL/DAL/ExcelCheckDAL.cs
index aa9e0d2..c4f9914 100644
--- a/VueWebCoreApi/DLL/DAL/ExcelCheckDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/ExcelCheckDAL.cs
@@ -24,55 +24,61 @@
Message = ImportExcelData.Zerro(savePath, out StuCode);
break;
case "1"://宀椾綅绠＄悊
- Message = ImportExcelData.One(savePath, out StuCode);
+ Message = ImportExcelData.One(dataTable, out StuCode);
break;
case "2"://鐝粍绠＄悊
- Message = ImportExcelData.Two(savePath, out StuCode);
+ Message = ImportExcelData.Two(dataTable, out StuCode);
break;
case "3"://浜哄憳绠＄悊
Message = ImportExcelData.Three(dataTable, out StuCode);
break;
case "4"://瑙掕壊绠＄悊
- Message = ImportExcelData.Four(savePath, out StuCode);
+ Message = ImportExcelData.Four(dataTable, out StuCode);
break;
case "5"://寰�鏉ュ崟浣�
- Message = ImportExcelData.Five(savePath, out StuCode);
+ Message = ImportExcelData.Five(dataTable, out StuCode);
break;
case "6"://浠撳簱璁剧疆
- Message = ImportExcelData.Six(savePath, out StuCode);
+ Message = ImportExcelData.Six(dataTable, out StuCode);
break;
case "7"://搴撲綅璁剧疆
- Message = ImportExcelData.Seven(savePath, out StuCode);
+ Message = ImportExcelData.Seven(dataTable, out StuCode);
break;
case "8"://瀛樿揣妗ｆ
- Message = ImportExcelData.Eight(savePath, out StuCode);
+ Message = ImportExcelData.Eight(dataTable, out StuCode);
break;
case "9"://璁惧娓呭崟
- Message = ImportExcelData.Nine(savePath, out StuCode);
+ Message = ImportExcelData.Nine(dataTable, out StuCode);
break;
case "10"://璁惧鐐规椤圭洰
- Message = ImportExcelData.Ten(savePath, out StuCode);
+ Message = ImportExcelData.Ten(dataTable, out StuCode);
break;
- case "22"://璁惧鐐规鏍囧噯
- Message = ImportExcelData.TwentyTwo(savePath, out StuCode);
+ case "10_1"://璁惧鐐规鏍囧噯
+ Message = ImportExcelData.Ten_one(dataTable, out StuCode);
break;
case "11"://璁惧淇濆吇椤圭洰
- Message = ImportExcelData.Eleven(savePath, out StuCode);
+ Message = ImportExcelData.Eleven(dataTable, out StuCode);
break;
- case "23"://璁惧淇濆吇鏍囧噯
- Message = ImportExcelData.TwentyThree(savePath, out StuCode);
+ case "11_1"://璁惧淇濆吇鏍囧噯
+ Message = ImportExcelData.Eleven_one(dataTable, out StuCode);
break;
- case "12"://宸ヨ娓呭崟
- Message = ImportExcelData.Twelve(savePath, out StuCode);
+ case "12"://妯″叿娓呭崟
+ Message = ImportExcelData.Twelve(dataTable, out StuCode);
break;
- case "13"://宸ヨ鐐规
- Message = ImportExcelData.Thirteen(savePath, out StuCode);
+ case "13"://妯″叿鐐规椤圭洰
+ Message = ImportExcelData.Thirteen(dataTable, out StuCode);
break;
- case "14"://宸ヨ淇濆吇
- Message = ImportExcelData.Fourteen(savePath, out StuCode);
+ case "13_1"://妯″叿鐐规鏍囧噯
+ Message = ImportExcelData.Thirteen_one(dataTable, out StuCode);
+ break;
+ case "14"://妯″叿淇濆吇椤圭洰
+ Message = ImportExcelData.Fourteen(dataTable, out StuCode);
+ break;
+ case "14_1"://妯″叿淇濆吇鏍囧噯
+ Message = ImportExcelData.Fourteen_one(dataTable, out StuCode);
break;
case "15"://宸ュ簭瀹氫箟
- Message = ImportExcelData.Fifteen(savePath, out StuCode);
+ Message = ImportExcelData.Fifteen(dataTable, out StuCode);
break;
case "16"://宸ヨ壓璺嚎
Message = ImportExcelData.Sixteen(savePath, out StuCode);
@@ -84,7 +90,7 @@
Message = ImportExcelData.Seventeen(savePath, out StuCode);
break;
case "18"://缂洪櫡瀹氫箟
- Message = ImportExcelData.Eighteen(savePath, out StuCode);
+ Message = ImportExcelData.Eighteen(dataTable, out StuCode);
break;
case "19"://鐢熶骇璁㈠崟
Message = ImportExcelData.Nineteen(savePath, out StuCode);
@@ -103,7 +109,7 @@
mes.code = StuCode;
- mes.Message = Message;
+ mes.message = Message;
return mes;
}
@@ -122,55 +128,61 @@
list = ImportExcelData.ZerroData(savePath, out stuCode, out message, out count);
break;
case "1": //宀椾綅绠＄悊
- list = ImportExcelData.OneData(savePath, out stuCode, out message, out count);
+ list = ImportExcelData.OneData(dataTable, out stuCode, out message, out count);
break;
case "2"://鐝粍绠＄悊
- list = ImportExcelData.TwoData(savePath, out stuCode, out message, out count);
+ list = ImportExcelData.TwoData(dataTable, out stuCode, out message, out count);
break;
case "3"://浜哄憳绠＄悊
list = ImportExcelData.ThreeData(dataTable, out stuCode, out message, out count);
break;
case "4"://瑙掕壊绠＄悊
- list = ImportExcelData.FourData(savePath, out stuCode, out message, out count);
+ list = ImportExcelData.FourData(dataTable, out stuCode, out message, out count);
break;
case "5"://寰�鏉ュ崟浣�
- list = ImportExcelData.FiveData(savePath, out stuCode, out message, out count);
+ list = ImportExcelData.FiveData(dataTable, out stuCode, out message, out count);
break;
case "6"://浠撳簱璁剧疆
- list = ImportExcelData.SixData(savePath, out stuCode, out message, out count);
+ list = ImportExcelData.SixData(dataTable, out stuCode, out message, out count);
break;
case "7"://搴撲綅璁剧疆
- list = ImportExcelData.SevenData(savePath, out stuCode, out message, out count);
+ list = ImportExcelData.SevenData(dataTable, out stuCode, out message, out count);
break;
case "8"://瀛樿揣妗ｆ
- list = ImportExcelData.EightData(savePath, out stuCode, out message, out count);
+ list = ImportExcelData.EightData(dataTable, out stuCode, out message, out count);
break;
case "9"://璁惧娓呭崟
- list = ImportExcelData.NineData(savePath, out stuCode, out message, out count);
+ list = ImportExcelData.NineData(dataTable, out stuCode, out message, out count);
break;
case "10"://璁惧鐐规椤圭洰
- list = ImportExcelData.TenData(savePath, out stuCode, out message, out count);
+ list = ImportExcelData.TenData(dataTable, out stuCode, out message, out count);
break;
- case "22"://璁惧鐐规鏍囧噯
- list = ImportExcelData.TwentyTwoData(savePath, out stuCode, out message, out count);
+ case "10_1"://璁惧鐐规鏍囧噯
+ list = ImportExcelData.Ten_oneData(dataTable, out stuCode, out message, out count);
break;
case "11"://璁惧淇濆吇椤圭洰
- list = ImportExcelData.ElevenData(savePath, out stuCode, out message, out count);
+ list = ImportExcelData.ElevenData(dataTable, out stuCode, out message, out count);
break;
- case "23"://璁惧淇濆吇鏍囧噯
- list = ImportExcelData.TwentyThreeData(savePath, out stuCode, out message, out count);
+ case "11_1"://璁惧淇濆吇鏍囧噯
+ list = ImportExcelData.Eleven_oneData(dataTable, out stuCode, out message, out count);
break;
- case "12"://宸ヨ娓呭崟
- list = ImportExcelData.TwelveData(savePath, out stuCode, out message, out count);
+ case "12"://妯″叿娓呭崟
+ list = ImportExcelData.TwelveData(dataTable, out stuCode, out message, out count);
break;
- case "13"://宸ヨ鐐规
- list = ImportExcelData.ThirteenData(savePath, out stuCode, out message, out count);
+ case "13"://妯″叿鐐规椤圭洰
+ list = ImportExcelData.ThirteenData(dataTable, out stuCode, out message, out count);
break;
- case "14"://宸ヨ淇濆吇
- list = ImportExcelData.FourteenData(savePath, out stuCode, out message, out count);
+ case "13_1"://妯″叿鐐规鏍囧噯
+ list = ImportExcelData.Thirteen_oneData(dataTable, out stuCode, out message, out count);
+ break;
+ case "14"://妯″叿淇濆吇椤圭洰
+ list = ImportExcelData.FourteenData(dataTable, out stuCode, out message, out count);
+ break;
+ case "14_1"://妯″叿淇濆吇鏍囧噯
+ list = ImportExcelData.FourteenData_one(dataTable, out stuCode, out message, out count);
break;
case "15"://宸ュ簭瀹氫箟
- list = ImportExcelData.FifteenData(savePath, out stuCode, out message, out count);
+ list = ImportExcelData.FifteenData(dataTable, out stuCode, out message, out count);
break;
case "16"://宸ヨ壓璺嚎
list = ImportExcelData.SixteenData(savePath, out stuCode, out message, out count);
@@ -182,7 +194,7 @@
list = ImportExcelData.SeventeenData(savePath, out stuCode, out message, out count);
break;
case "18"://缂洪櫡瀹氫箟
- list = ImportExcelData.EighteenData(savePath, out stuCode, out message, out count);
+ list = ImportExcelData.EighteenData(dataTable, out stuCode, out message, out count);
break;
case "19"://鐢熶骇璁㈠崟
list = ImportExcelData.NineteenData(savePath, out stuCode, out message, out count);
@@ -212,55 +224,61 @@
Message = ImportExcelData.ZerroSubmit(savePath, User, out StuCode);
break;
case "1": //宀椾綅绠＄悊
- Message = ImportExcelData.OneSubmit(savePath, User, out StuCode);
+ Message = ImportExcelData.OneSubmit(dataTable, us, out StuCode);
break;
case "2"://鐝粍绠＄悊
- Message = ImportExcelData.TwoSubmit(savePath, User, out StuCode);
+ Message = ImportExcelData.TwoSubmit(dataTable, us, out StuCode);
break;
case "3"://浜哄憳绠＄悊
Message = ImportExcelData.ThreeSubmit(dataTable, us, out StuCode);
break;
case "4"://瑙掕壊绠＄悊
- Message = ImportExcelData.FourSubmit(savePath, User, out StuCode);
+ Message = ImportExcelData.FourSubmit(dataTable, us, out StuCode);
break;
case "5"://寰�鏉ュ崟浣�
- Message = ImportExcelData.FiveSubmit(savePath, User, out StuCode);
+ Message = ImportExcelData.FiveSubmit(dataTable, us, out StuCode);
break;
case "6"://浠撳簱璁剧疆
- Message = ImportExcelData.SixSubmit(savePath, User, out StuCode);
+ Message = ImportExcelData.SixSubmit(dataTable, us, out StuCode);
break;
case "7"://搴撲綅璁剧疆
- Message = ImportExcelData.SevenSubmit(savePath, User, out StuCode);
+ Message = ImportExcelData.SevenSubmit(dataTable, us, out StuCode);
break;
case "8"://瀛樿揣妗ｆ
- Message = ImportExcelData.EightSubmit(savePath, User, out StuCode);
+ Message = ImportExcelData.EightSubmit(dataTable, us, out StuCode);
break;
case "9"://璁惧娓呭崟
- Message = ImportExcelData.NineSubmit(savePath, User, out StuCode);
+ Message = ImportExcelData.NineSubmit(dataTable, us, out StuCode);
break;
case "10"://璁惧鐐规椤圭洰
- Message = ImportExcelData.TenSubmit(savePath, User, out StuCode);
+ Message = ImportExcelData.TenSubmit(dataTable, us, out StuCode);
break;
- case "22"://璁惧鐐规鏍囧噯
- Message = ImportExcelData.TwentyTwoSubmit(savePath, User, out StuCode);
+ case "10_1"://璁惧鐐规鏍囧噯
+ Message = ImportExcelData.Ten_oneSubmit(dataTable, us, out StuCode);
break;
case "11"://璁惧淇濆吇椤圭洰
- Message = ImportExcelData.ElevenSubmit(savePath, User, out StuCode);
+ Message = ImportExcelData.ElevenSubmit(dataTable, us, out StuCode);
break;
- case "23"://璁惧淇濆吇鏍囧噯
- Message = ImportExcelData.TwentyThreeSubmit(savePath, User, out StuCode);
+ case "11_1"://璁惧淇濆吇鏍囧噯
+ Message = ImportExcelData.Eleven_oneSubmit(dataTable, us, out StuCode);
break;
- case "12"://宸ヨ娓呭崟
- Message = ImportExcelData.TwelveSubmit(savePath, User, out StuCode);
+ case "12"://妯″叿娓呭崟
+ Message = ImportExcelData.TwelveSubmit(dataTable, us, out StuCode);
break;
- case "13"://宸ヨ鐐规
- Message = ImportExcelData.ThirteenSubmit(savePath, User, out StuCode);
+ case "13"://妯″叿鐐规椤圭洰
+ Message = ImportExcelData.ThirteenSubmit(dataTable, us, out StuCode);
break;
- case "14"://宸ヨ淇濆吇
- Message = ImportExcelData.FourteenSubmit(savePath, User, out StuCode);
+ case "13_1"://妯″叿鐐规鏍囧噯
+ Message = ImportExcelData.Thirteen_oneSubmit(dataTable, us, out StuCode);
+ break;
+ case "14"://妯″叿淇濆吇椤圭洰
+ Message = ImportExcelData.FourteenSubmit(dataTable, us, out StuCode);
+ break;
+ case "14_1"://妯″叿淇濆吇鏍囧噯
+ Message = ImportExcelData.Fourteen_oneSubmit(dataTable, us, out StuCode);
break;
case "15"://宸ュ簭瀹氫箟
- Message = ImportExcelData.FifteenSubmit(savePath, User, out StuCode);
+ Message = ImportExcelData.FifteenSubmit(dataTable, us, out StuCode);
break;
case "16"://宸ヨ壓璺嚎
Message = ImportExcelData.SixteenSubmit(savePath, User, out StuCode);
@@ -272,7 +290,7 @@
Message = ImportExcelData.SeventeenSubmit(savePath, User, out StuCode);
break;
case "18"://缂洪櫡瀹氫箟
- Message = ImportExcelData.EighteenSubmit(savePath, User, out StuCode);
+ Message = ImportExcelData.EighteenSubmit(dataTable, us, out StuCode);
break;
case "19"://鐢熶骇璁㈠崟
Message = ImportExcelData.NineteenSubmit(savePath, User, out StuCode);
@@ -288,7 +306,7 @@
}
mes.code = StuCode;
- mes.Message = Message;
+ mes.message = Message;
return mes;
}
#endregion
--
Gitblit v1.9.3