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 "11"://设备保养
|
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<ExcelErro> ExcelCheckData(string fileCode, string savePath, out string stuCode, out string message, out int count)
|
{
|
stuCode = "";
|
message = "";
|
count = 0;
|
List<ExcelErro> list = new List<ExcelErro>();
|
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 "11"://设备保养
|
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 "11"://设备保养
|
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
|
|
}
|
}
|
