using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using VueWebApi.Models; using VueWebApi.Tools; namespace VueWebApi.DLL.DAL { public class ExcelCheckDAL { public static ToMessage mes = new ToMessage(); //定义全局返回信息对象 #region【Excel导入模板验证】 public static ToMessage ExcelCheck(string fileCode, string savePath) { string StuCode = ""; string Message = ""; switch (fileCode) { case "1": //角色权限 Message = ImportExcelData.One(savePath, out StuCode); break; case "2"://用户角色 Message = ImportExcelData.Two(savePath, out StuCode); break; case "3"://工位清单 Message = ImportExcelData.Three(savePath, out StuCode); break; case "4"://往来单位 Message = ImportExcelData.Four(savePath, out StuCode); break; case "6"://仓库、库位定义 Message = ImportExcelData.SixOne(savePath, out StuCode); break; case "7"://容器定义 Message = ImportExcelData.Seven(savePath, out StuCode); break; case "8"://存货档案 Message = ImportExcelData.Eight(savePath, out StuCode); break; case "9"://设备清单 Message = ImportExcelData.Nine(savePath, out StuCode); break; case "10"://设备点检项目 Message = ImportExcelData.Ten(savePath, out StuCode); break; case "22"://设备点检标准 Message = ImportExcelData.Ten(savePath, out StuCode); break; case "11"://设备保养项目 Message = ImportExcelData.Eleven(savePath, out StuCode); break; case "23"://设备保养标准 Message = ImportExcelData.Eleven(savePath, out StuCode); break; case "12"://工装清单 Message = ImportExcelData.Twelve(savePath, out StuCode); break; case "13"://工装点检 Message = ImportExcelData.Thirteen(savePath, out StuCode); break; case "14"://工装保养 Message = ImportExcelData.Fourteen(savePath, out StuCode); break; case "15"://工序定义 Message = ImportExcelData.Fifteen(savePath, out StuCode); break; case "16"://工艺路线 Message = ImportExcelData.Sixteen(savePath, out StuCode); break; case "17"://质检标准 Message = ImportExcelData.Seventeen(savePath, out StuCode); break; case "18"://缺陷定义 Message = ImportExcelData.Eighteen(savePath, 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, string savePath, out string stuCode, out string message, out int count) { stuCode = ""; message = ""; count = 0; List list = new List(); switch (fileCode) { case "1": //角色权限 list = ImportExcelData.OneData(savePath, out stuCode, out message, out count); break; case "2"://用户角色 list = ImportExcelData.TwoData(savePath, out stuCode, out message, out count); break; case "3"://工位清单 list = ImportExcelData.ThreeData(savePath, out stuCode, out message, out count); break; case "4"://往来单位清单 list = ImportExcelData.FourData(savePath, out stuCode, out message, out count); break; case "6"://仓库、库位定义 list = ImportExcelData.SixOneData(savePath, out stuCode, out message, out count); break; case "7"://容器定义 list = ImportExcelData.SevenData(savePath, out stuCode, out message, out count); break; case "8"://存货档案 list = ImportExcelData.EightData(savePath, out stuCode, out message, out count); break; case "9"://设备清单 list = ImportExcelData.NineData(savePath, out stuCode, out message, out count); break; case "10"://设备点检项目 list = ImportExcelData.TenData(savePath, out stuCode, out message, out count); break; case "22"://设备点检标准 list = ImportExcelData.TenData(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.ElevenData(savePath, out stuCode, out message, out count); break; case "12"://工装清单 list = ImportExcelData.TwelveData(savePath, out stuCode, out message, out count); break; case "13"://工装点检 list = ImportExcelData.ThirteenData(savePath, 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(savePath, out stuCode, out message, out count); break; case "16"://工艺路线 list = ImportExcelData.SixteenData(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(savePath, 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, string savePath, string User) { string StuCode = ""; string Message = ""; switch (FileCode) { case "1": //角色权限 Message = ImportExcelData.OneSubmit(savePath, User, out StuCode); break; case "2"://用户角色 Message = ImportExcelData.TwoSubmit(savePath, User, out StuCode); break; case "3"://工位清单 Message = ImportExcelData.ThreeSubmit(savePath, User, out StuCode); break; case "4"://往来单位清单 Message = ImportExcelData.FourSubmit(savePath, User, out StuCode); break; case "6"://仓库、库位定义 Message = ImportExcelData.SixOneSubmit(savePath, User, out StuCode); break; case "7"://容器定义 Message = ImportExcelData.SevenSubmit(savePath, User, out StuCode); break; case "8"://存货档案 Message = ImportExcelData.EightSubmit(savePath, User, out StuCode); break; case "9"://设备清单 Message = ImportExcelData.NineSubmit(savePath, User, out StuCode); break; case "10"://设备点检项目 Message = ImportExcelData.TenSubmit(savePath, User, out StuCode); break; case "22"://设备点检标准 Message = ImportExcelData.TenSubmit(savePath, User, out StuCode); break; case "11"://设备保养项目 Message = ImportExcelData.ElevenSubmit(savePath, User, out StuCode); break; case "23"://设备保养标准 Message = ImportExcelData.ElevenSubmit(savePath, User, out StuCode); break; case "12"://工装清单 Message = ImportExcelData.TwelveSubmit(savePath, User, out StuCode); break; case "13"://工装点检 Message = ImportExcelData.ThirteenSubmit(savePath, User, out StuCode); break; case "14"://工装保养 Message = ImportExcelData.FourteenSubmit(savePath, User, out StuCode); break; case "15"://工序定义 Message = ImportExcelData.FifteenSubmit(savePath, User, out StuCode); break; case "16"://工艺路线 Message = ImportExcelData.SixteenSubmit(savePath, User, out StuCode); break; case "17"://质检标准 Message = ImportExcelData.SeventeenSubmit(savePath, User, out StuCode); break; case "18"://缺陷定义 Message = ImportExcelData.EighteenSubmit(savePath, User, 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 } }