using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Threading.Tasks; using VueWebCoreApi.Models; using VueWebCoreApi.Tools; namespace VueWebCoreApi.DLL.DAL { public class ExcelCheckDAL { public static ToMessage mes = new ToMessage(); //定义全局返回信息对象 public static string savePath = ""; #region【Excel导入模板验证】 public static ToMessage ExcelCheck(string fileCode, List dataTable) { string StuCode = ""; string Message = ""; switch (fileCode) { case "0": //组织架构 Message = ImportExcelData.Zerro(savePath, out StuCode); break; case "1"://岗位管理 Message = ImportExcelData.One(dataTable, out StuCode); break; case "2"://班组管理 Message = ImportExcelData.Two(dataTable, out StuCode); break; case "3"://人员管理 Message = ImportExcelData.Three(dataTable, out StuCode); break; case "4"://角色管理 Message = ImportExcelData.Four(dataTable, out StuCode); break; 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(dataTable, out StuCode); break; case "9"://设备清单 Message = ImportExcelData.Nine(dataTable, out StuCode); break; case "10"://设备点检项目 Message = ImportExcelData.Ten(savePath, out StuCode); break; case "22"://设备点检标准 Message = ImportExcelData.TwentyTwo(savePath, out StuCode); break; case "11"://设备保养项目 Message = ImportExcelData.Eleven(savePath, out StuCode); break; case "23"://设备保养标准 Message = ImportExcelData.TwentyThree(savePath, out StuCode); break; case "12"://模具清单 Message = ImportExcelData.Twelve(dataTable, out StuCode); break; case "13"://模具点检项目 Message = ImportExcelData.Thirteen(dataTable, out StuCode); break; case "14"://工装保养 Message = ImportExcelData.Fourteen(savePath, out StuCode); break; case "15"://工序定义 Message = ImportExcelData.Fifteen(dataTable, out StuCode); break; case "16"://工艺路线 Message = ImportExcelData.Sixteen(savePath, out StuCode); break; case "24"://节拍工价 Message = ImportExcelData.TwentyFour(savePath, out StuCode); break; case "17"://质检标准 Message = ImportExcelData.Seventeen(savePath, out StuCode); break; case "18"://缺陷定义 Message = ImportExcelData.Eighteen(dataTable, out StuCode); break; case "19"://生产订单 Message = ImportExcelData.Nineteen(savePath, out StuCode); break; case "20"://库存查询 Message = ImportExcelData.Twenty(savePath, out StuCode); break; case "21"://物料清单 Message = ImportExcelData.TwentyOne(savePath, out StuCode); break; default: StuCode = "300"; Message = "模板编码错误！"; break; } mes.code = StuCode; mes.Message = Message; return mes; } #endregion #region【Excel导入数据验证】 public static List ExcelCheckData(string fileCode, List dataTable, out string stuCode, out string message, out int count) { stuCode = ""; message = ""; count = 0; List list = new List(); switch (fileCode) { case "0": //组织架构 list = ImportExcelData.ZerroData(savePath, out stuCode, out message, out count); break; case "1": //岗位管理 list = ImportExcelData.OneData(dataTable, out stuCode, out message, out count); break; case "2"://班组管理 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(dataTable, out stuCode, out message, out count); break; 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(dataTable, out stuCode, out message, out count); break; case "9"://设备清单 list = ImportExcelData.NineData(dataTable, out stuCode, out message, out count); break; case "10"://设备点检项目 list = ImportExcelData.TenData(savePath, out stuCode, out message, out count); break; case "22"://设备点检标准 list = ImportExcelData.TwentyTwoData(savePath, out stuCode, out message, out count); break; case "11"://设备保养项目 list = ImportExcelData.ElevenData(savePath, out stuCode, out message, out count); break; case "23"://设备保养标准 list = ImportExcelData.TwentyThreeData(savePath, out stuCode, out message, out count); break; case "12"://模具清单 list = ImportExcelData.TwelveData(dataTable, out stuCode, out message, out count); break; 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); break; case "15"://工序定义 list = ImportExcelData.FifteenData(dataTable, out stuCode, out message, out count); break; case "16"://工艺路线 list = ImportExcelData.SixteenData(savePath, out stuCode, out message, out count); break; case "24"://节拍工价 list = ImportExcelData.TwentyFourData(savePath, out stuCode, out message, out count); break; case "17"://质检标准 list = ImportExcelData.SeventeenData(savePath, out stuCode, out message, out count); break; case "18"://缺陷定义 list = ImportExcelData.EighteenData(dataTable, out stuCode, out message, out count); break; case "19"://生产订单 list = ImportExcelData.NineteenData(savePath, out stuCode, out message, out count); break; case "20"://库存查询 list = ImportExcelData.TwentyData(savePath, out stuCode, out message, out count); break; case "21"://物料清单 list = ImportExcelData.TwentyOneData(savePath, out stuCode, out message, out count); break; default: break; } return list; } #endregion #region【Excel导入数据】 public static ToMessage ExcelImportSubmit(string FileCode, List dataTable, User us) { string StuCode = ""; string Message = ""; string User = ""; switch (FileCode) { case "0": //组织架构 Message = ImportExcelData.ZerroSubmit(savePath, User, out StuCode); break; case "1": //岗位管理 Message = ImportExcelData.OneSubmit(dataTable, us, out StuCode); break; case "2"://班组管理 Message = ImportExcelData.TwoSubmit(dataTable, us, out StuCode); break; case "3"://人员管理 Message = ImportExcelData.ThreeSubmit(dataTable, us, out StuCode); break; case "4"://角色管理 Message = ImportExcelData.FourSubmit(dataTable, us, out StuCode); break; 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(dataTable, us, out StuCode); break; case "9"://设备清单 Message = ImportExcelData.NineSubmit(dataTable, us, out StuCode); break; case "10"://设备点检项目 Message = ImportExcelData.TenSubmit(savePath, User, out StuCode); break; case "22"://设备点检标准 Message = ImportExcelData.TwentyTwoSubmit(savePath, User, out StuCode); break; case "11"://设备保养项目 Message = ImportExcelData.ElevenSubmit(savePath, User, out StuCode); break; case "23"://设备保养标准 Message = ImportExcelData.TwentyThreeSubmit(savePath, User, out StuCode); break; case "12"://模具清单 Message = ImportExcelData.TwelveSubmit(dataTable, us, out StuCode); break; case "13"://模具点检项目 Message = ImportExcelData.ThirteenSubmit(dataTable, us, out StuCode); break; case "14"://工装保养 Message = ImportExcelData.FourteenSubmit(savePath, User, out StuCode); break; case "15"://工序定义 Message = ImportExcelData.FifteenSubmit(dataTable, us, out StuCode); break; case "16"://工艺路线 Message = ImportExcelData.SixteenSubmit(savePath, User, out StuCode); break; case "24"://节拍工价 Message = ImportExcelData.TwentyFourSubmit(savePath, User, out StuCode); break; case "17"://质检标准 Message = ImportExcelData.SeventeenSubmit(savePath, User, out StuCode); break; case "18"://缺陷定义 Message = ImportExcelData.EighteenSubmit(dataTable, us, out StuCode); break; case "19"://生产订单 Message = ImportExcelData.NineteenSubmit(savePath, User, out StuCode); break; case "20"://库存查询 Message = ImportExcelData.TwentySubmit(savePath, User, out StuCode); break; case "21"://物料清单 Message = ImportExcelData.TwentyOneSubmit(savePath, User, out StuCode); break; default: break; } mes.code = StuCode; mes.Message = Message; return mes; } #endregion } }