From 4084e06d179675c094a17abb9695aa9a33617b92 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 14 九月 2023 17:33:09 +0800
Subject: [PATCH] 存货档案导入、设备清单导入
---
VueWebCoreApi/DLL/DAL/ExcelCheckDAL.cs | 113 +++++++++++++++++++++++++++++++++-----------------------
1 files changed, 67 insertions(+), 46 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/ExcelCheckDAL.cs b/VueWebCoreApi/DLL/DAL/ExcelCheckDAL.cs
index e6fbee6..604cc76 100644
--- a/VueWebCoreApi/DLL/DAL/ExcelCheckDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/ExcelCheckDAL.cs
@@ -1,5 +1,6 @@
锘縰sing System;
using System.Collections.Generic;
+using System.Data;
using System.Linq;
using System.Threading.Tasks;
using VueWebCoreApi.Models;
@@ -10,37 +11,44 @@
public class ExcelCheckDAL
{
public static ToMessage mes = new ToMessage(); //瀹氫箟鍏ㄥ眬杩斿洖淇℃伅瀵硅薄
+ public static string savePath = "";
#region銆怑xcel瀵煎叆妯℃澘楠岃瘉銆�
- public static ToMessage ExcelCheck(string fileCode, string savePath)
+ public static ToMessage ExcelCheck(string fileCode, List<DataTable> dataTable)
{
string StuCode = "";
string Message = "";
switch (fileCode)
{
- case "1": //瑙掕壊鏉冮檺
- Message = ImportExcelData.One(savePath, out StuCode);
+ case "0": //缁勭粐鏋舵瀯
+ Message = ImportExcelData.Zerro(savePath, out StuCode);
break;
- case "2"://鐢ㄦ埛瑙掕壊
- Message = ImportExcelData.Two(savePath, out StuCode);
+ case "1"://宀椾綅绠＄悊
+ Message = ImportExcelData.One(dataTable, out StuCode);
break;
- case "3"://宸ヤ綅娓呭崟
- Message = ImportExcelData.Three(savePath, out StuCode);
+ case "2"://鐝粍绠＄悊
+ Message = ImportExcelData.Two(dataTable, out StuCode);
break;
- case "4"://寰�鏉ュ崟浣�
- Message = ImportExcelData.Four(savePath, out StuCode);
+ case "3"://浜哄憳绠＄悊
+ Message = ImportExcelData.Three(dataTable, out StuCode);
break;
- case "6"://浠撳簱銆佸簱浣嶅畾涔�
- Message = ImportExcelData.SixOne(savePath, out StuCode);
+ case "4"://瑙掕壊绠＄悊
+ Message = ImportExcelData.Four(dataTable, out StuCode);
break;
- case "7"://瀹瑰櫒瀹氫箟
- Message = ImportExcelData.Seven(savePath, out StuCode);
+ case "5"://寰�鏉ュ崟浣�
+ Message = ImportExcelData.Five(dataTable, out StuCode);
+ break;
+ case "6"://浠撳簱璁剧疆
+ Message = ImportExcelData.Six(dataTable, out StuCode);
+ break;
+ case "7"://搴撲綅璁剧疆
+ 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);
@@ -102,7 +110,7 @@
#endregion
#region銆怑xcel瀵煎叆鏁版嵁楠岃瘉銆�
- public static List<ExcelErro> ExcelCheckData(string fileCode, string savePath, out string stuCode, out string message, out int count)
+ public static List<ExcelErro> ExcelCheckData(string fileCode, List<DataTable> dataTable, out string stuCode, out string message, out int count)
{
stuCode = "";
message = "";
@@ -110,29 +118,35 @@
List<ExcelErro> list = new List<ExcelErro>();
switch (fileCode)
{
- case "1": //瑙掕壊鏉冮檺
- list = ImportExcelData.OneData(savePath, out stuCode, out message, out count);
+ case "0": //缁勭粐鏋舵瀯
+ list = ImportExcelData.ZerroData(savePath, out stuCode, out message, out count);
break;
- case "2"://鐢ㄦ埛瑙掕壊
- list = ImportExcelData.TwoData(savePath, out stuCode, out message, out count);
+ case "1": //宀椾綅绠＄悊
+ list = ImportExcelData.OneData(dataTable, out stuCode, out message, out count);
break;
- case "3"://宸ヤ綅娓呭崟
- list = ImportExcelData.ThreeData(savePath, out stuCode, out message, out count);
+ case "2"://鐝粍绠＄悊
+ list = ImportExcelData.TwoData(dataTable, out stuCode, out message, out count);
break;
- case "4"://寰�鏉ュ崟浣嶆竻鍗�
- list = ImportExcelData.FourData(savePath, out stuCode, out message, out count);
+ case "3"://浜哄憳绠＄悊
+ list = ImportExcelData.ThreeData(dataTable, out stuCode, out message, out count);
break;
- case "6"://浠撳簱銆佸簱浣嶅畾涔�
- list = ImportExcelData.SixOneData(savePath, out stuCode, out message, out count);
+ case "4"://瑙掕壊绠＄悊
+ list = ImportExcelData.FourData(dataTable, out stuCode, out message, out count);
break;
- case "7"://瀹瑰櫒瀹氫箟
- list = ImportExcelData.SevenData(savePath, out stuCode, out message, out count);
+ case "5"://寰�鏉ュ崟浣�
+ list = ImportExcelData.FiveData(dataTable, out stuCode, out message, out count);
+ break;
+ case "6"://浠撳簱璁剧疆
+ list = ImportExcelData.SixData(dataTable, out stuCode, out message, out count);
+ break;
+ case "7"://搴撲綅璁剧疆
+ 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);
@@ -186,36 +200,43 @@
}
#endregion
- #region銆怑xcel瀵煎叆鏁版嵁楠岃瘉銆�
- public static ToMessage ExcelImportSubmit(string FileCode, string savePath, string User)
+ #region銆怑xcel瀵煎叆鏁版嵁銆�
+ public static ToMessage ExcelImportSubmit(string FileCode, List<DataTable> dataTable, User us)
{
string StuCode = "";
string Message = "";
+ string User = "";
switch (FileCode)
{
- case "1": //瑙掕壊鏉冮檺
- Message = ImportExcelData.OneSubmit(savePath, User, out StuCode);
+ case "0": //缁勭粐鏋舵瀯
+ Message = ImportExcelData.ZerroSubmit(savePath, User, out StuCode);
break;
- case "2"://鐢ㄦ埛瑙掕壊
- Message = ImportExcelData.TwoSubmit(savePath, User, out StuCode);
+ case "1": //宀椾綅绠＄悊
+ Message = ImportExcelData.OneSubmit(dataTable, us, out StuCode);
break;
- case "3"://宸ヤ綅娓呭崟
- Message = ImportExcelData.ThreeSubmit(savePath, User, out StuCode);
+ case "2"://鐝粍绠＄悊
+ Message = ImportExcelData.TwoSubmit(dataTable, us, out StuCode);
break;
- case "4"://寰�鏉ュ崟浣嶆竻鍗�
- Message = ImportExcelData.FourSubmit(savePath, User, out StuCode);
+ case "3"://浜哄憳绠＄悊
+ Message = ImportExcelData.ThreeSubmit(dataTable, us, out StuCode);
break;
- case "6"://浠撳簱銆佸簱浣嶅畾涔�
- Message = ImportExcelData.SixOneSubmit(savePath, User, out StuCode);
+ case "4"://瑙掕壊绠＄悊
+ Message = ImportExcelData.FourSubmit(dataTable, us, out StuCode);
break;
- case "7"://瀹瑰櫒瀹氫箟
- Message = ImportExcelData.SevenSubmit(savePath, User, out StuCode);
+ case "5"://寰�鏉ュ崟浣�
+ Message = ImportExcelData.FiveSubmit(dataTable, us, out StuCode);
+ break;
+ case "6"://浠撳簱璁剧疆
+ Message = ImportExcelData.SixSubmit(dataTable, us, out StuCode);
+ break;
+ case "7"://搴撲綅璁剧疆
+ 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);
--
Gitblit v1.9.3