using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Web;
|
using VueWebApi.Models;
|
|
namespace VueWebApi.Tools
|
{
|
public class ImportExcelData
|
{
|
public static ToMessage mes = new ToMessage(); //定义全局返回信息对象
|
|
#region【Excel模板上传验证】
|
#region【Excel模板上传验证,角色权限模板】
|
public static string One(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 4)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "角色编号(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "角色名称(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "角色类型")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,用户角色模板】
|
public static string Two(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 6)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "用户编号(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "用户姓名")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "所属组织")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[4].ColumnName != "在职状态")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[5].ColumnName != "工资类型")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,工位清单模板】
|
public static string Three(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 9)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "工位编号(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "工位名称（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "工位类型")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[4].ColumnName != "所属车间")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[5].ColumnName != "所属产线")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[6].ColumnName != "使用状态")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[7].ColumnName != "数采标识1")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[8].ColumnName != "数采标识2")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,供方清单模板】
|
public static string Four(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 5)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "供方编号(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "供方名称（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "补充描述")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[4].ColumnName.Trim() != "供方类型（外协供方,外购供方）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,客户清单模板】
|
public static string Five(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 4)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "客户编号(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "客户名称（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "补充描述")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,仓库定义模板】
|
public static string SixOne(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 4)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "仓库编码(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "仓库名称（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "功能描述")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,库区定义模板】
|
public static string SixTwo(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 6)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "库区编码(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "库区名称（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "功能描述")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[4].ColumnName != "仓库编码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[5].ColumnName != "仓库名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,库位定义模板】
|
public static string SixThree(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 6)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "库位编码(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "库位名称（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "功能描述")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[4].ColumnName != "库区编码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[5].ColumnName != "库区名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,容器定义模板】
|
public static string Seven(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 5)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "容器编码(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "容器名称（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "容器自重（KG）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[4].ColumnName != "容器类型")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,存货档案模板】
|
public static string Eight(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 11)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "物料编码(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "物料名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "物料规格")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[4].ColumnName != "主单位")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[5].ColumnName != "辅单位")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[6].ColumnName != "辅/主")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[7].ColumnName != "物料类别")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[8].ColumnName != "仓库名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[9].ColumnName != "库存下限")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[10].ColumnName != "库存上限")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,设备清单模板】
|
public static string Nine(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 10)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "设备编号(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "设备名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "设备类型")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[4].ColumnName != "生产车间")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[5].ColumnName != "所属产线")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[6].ColumnName != "投入日期")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[7].ColumnName != "稼动率（%）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[8].ColumnName != "使用状态")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[9].ColumnName != "数采标识1")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,设备点检模板】
|
public static string Ten(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
List<DataTable> excelTable = new List<DataTable>();
|
excelTable = ImportExcel.ExcelToTableList(FileCode);
|
if (excelTable.Count != 2)
|
{
|
code = "300";
|
Message = "模板不符合规范,缺失的Sheet";
|
}
|
else if (excelTable[0].Columns.Count != 4)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[1].Columns.Count != 9)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[0].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[1].ColumnName != "点检标准(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[2].ColumnName != "标准名称（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[3].ColumnName != "点检管控")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[1].ColumnName != "点检标准")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[2].ColumnName != "标准名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[3].ColumnName != "SEQ(部位顺序)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[4].ColumnName != "部位条码（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[5].ColumnName != "部位名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[6].ColumnName != "点检要求")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[7].ColumnName != "是否扫码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[8].ColumnName != "点检周期")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,设备保养模板】
|
public static string Eleven(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
List<DataTable> excelTable = new List<DataTable>();
|
excelTable = ImportExcel.ExcelToTableList(FileCode);
|
if (excelTable.Count != 2)
|
{
|
code = "300";
|
Message = "模板不符合规范,缺失的Sheet";
|
}
|
else if (excelTable[0].Columns.Count != 3)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[1].Columns.Count != 9)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[0].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[1].ColumnName != "保养标准(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[2].ColumnName != "标准名称（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[1].ColumnName != "保养标准")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[2].ColumnName != "标准名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[3].ColumnName != "SEQ(部位顺序)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[4].ColumnName != "部位条码（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[5].ColumnName != "部位名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[6].ColumnName != "保养要求")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[7].ColumnName != "是否扫码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[8].ColumnName != "保养周期")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,工装清单模板】
|
public static string Twelve(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 7)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "工装编号(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "工装名称（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "工装类型")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[4].ColumnName != "型腔数量")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[5].ColumnName != "理论寿命（次）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[6].ColumnName != "使用状态")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,工装点检模板】
|
public static string Thirteen(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
List<DataTable> excelTable = new List<DataTable>();
|
excelTable = ImportExcel.ExcelToTableList(FileCode);
|
if (excelTable.Count != 2)
|
{
|
code = "300";
|
Message = "模板不符合规范,缺失的Sheet";
|
}
|
else if (excelTable[0].Columns.Count != 3)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[1].Columns.Count != 8)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[0].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[1].ColumnName != "点检标准(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[2].ColumnName != "标准名称（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[1].ColumnName != "点检标准")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[2].ColumnName != "标准名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[3].ColumnName != "SEQ(部位顺序)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[4].ColumnName != "部位条码（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[5].ColumnName != "部位名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[6].ColumnName != "点检要求")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[7].ColumnName != "点检周期")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,工装保养模板】
|
public static string Fourteen(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
List<DataTable> excelTable = new List<DataTable>();
|
excelTable = ImportExcel.ExcelToTableList(FileCode);
|
if (excelTable.Count != 2)
|
{
|
code = "300";
|
Message = "模板不符合规范,缺失的Sheet";
|
}
|
else if (excelTable[0].Columns.Count != 3)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[1].Columns.Count != 8)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[0].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[1].ColumnName != "保养标准(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[2].ColumnName != "标准名称（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[1].ColumnName != "保养标准")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[2].ColumnName != "标准名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[3].ColumnName != "SEQ(部位顺序)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[4].ColumnName != "部位条码（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[5].ColumnName != "部位名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[6].ColumnName != "保养要求")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[7].ColumnName != "保养等级")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,工序定义模板】
|
public static string Fifteen(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 4)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "工序编码(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "工序名称（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "启用状态")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,工艺路线模板】
|
public static string Sixteen(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
List<DataTable> excelTable = new List<DataTable>();
|
excelTable = ImportExcel.ExcelToTableList(FileCode);
|
if (excelTable.Count != 2)
|
{
|
code = "300";
|
Message = "模板不符合规范,缺失的Sheet";
|
}
|
else if (excelTable[0].Columns.Count != 6)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[1].Columns.Count != 9)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[0].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[1].ColumnName != "工艺路线(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[2].ColumnName != "物料编码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[3].ColumnName != "物料名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[4].ColumnName != "生产周期（天）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[5].ColumnName != "结束装箱")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[1].ColumnName != "工艺路线")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[2].ColumnName != "SEQ(排列顺序)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[3].ColumnName != "工序编码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[4].ColumnName != "工序名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[5].ColumnName != "工序检验")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[6].ColumnName != "初始节拍（秒）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[7].ColumnName != "初始型腔数")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[8].ColumnName != "初始工价（元）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,质检标准模板】
|
public static string Seventeen(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
List<DataTable> excelTable = new List<DataTable>();
|
excelTable = ImportExcel.ExcelToTableList(FileCode);
|
if (excelTable.Count != 2)
|
{
|
code = "300";
|
Message = "模板不符合规范,缺失的Sheet";
|
}
|
else if (excelTable[0].Columns.Count != 8)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[1].Columns.Count != 9)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[0].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[1].ColumnName != "物料编码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[2].ColumnName != "物料名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[3].ColumnName != "检验类型")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[4].ColumnName != "工艺路线")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[5].ColumnName != "工序编码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[6].ColumnName != "工序名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[7].ColumnName != "流程管控")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[1].ColumnName != "主表序列号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[2].ColumnName != "排列顺序")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[3].ColumnName != "检验项目")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[4].ColumnName != "重要度")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[5].ColumnName != "检验工具")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[6].ColumnName != "标准要求")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[7].ColumnName != "下限值")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[8].ColumnName != "上限值")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,缺陷定义模板】
|
public static string Eighteen(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
List<DataTable> excelTable = new List<DataTable>();
|
excelTable = ImportExcel.ExcelToTableList(FileCode);
|
if (excelTable.Count != 2)
|
{
|
code = "300";
|
Message = "模板不符合规范,缺失的Sheet";
|
}
|
else if (excelTable[0].Columns.Count != 4)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[1].Columns.Count != 7)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[0].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[1].ColumnName != "物料编码(唯一)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[2].ColumnName != "物料名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[3].ColumnName != "启用状态")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
|
else if (excelTable[1].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[1].ColumnName != "物料信息序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[2].ColumnName != "缺陷代码（唯一）")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[3].ColumnName != "缺陷名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[4].ColumnName != "主工艺路线")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[5].ColumnName != "责任工序编码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[6].ColumnName != "责任工序名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,生产订单模板】
|
public static string Nineteen(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 7)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "产品编码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "产品名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "产品规格")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[4].ColumnName != "订单数量")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[5].ColumnName != "要求交付时间")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[6].ColumnName != "ERP订单号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,生产订单模板】
|
public static string Twenty(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
DataTable excelTable = new DataTable();
|
excelTable = ImportExcel.ExcelToTable(FileCode);
|
if (excelTable.Columns.Count != 10)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[1].ColumnName != "库位编码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[2].ColumnName != "物料编码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[3].ColumnName != "物料名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[4].ColumnName != "流程卡号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[5].ColumnName != "容器编码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[6].ColumnName != "入厂条码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[7].ColumnName != "炉号批次")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[8].ColumnName != "供方名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable.Columns[9].ColumnName != "当前库存")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#region【Excel模板上传验证,物料清单模板】
|
public static string TwentyOne(string FileCode, out string code)
|
{
|
string Message = "";
|
code = "";
|
List<DataTable> excelTable = new List<DataTable>();
|
excelTable = ImportExcel.ExcelToTableList(FileCode);
|
if (excelTable.Count != 2)
|
{
|
code = "300";
|
Message = "模板不符合规范,缺失的Sheet";
|
}
|
else if (excelTable[0].Columns.Count != 6)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[1].Columns.Count != 8)
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名字段数";
|
}
|
else if (excelTable[0].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[1].ColumnName != "母件编码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[2].ColumnName != "母件名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[3].ColumnName != "基础数量")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[4].ColumnName != "启用状态")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[0].Columns[5].ColumnName != "版本号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[0].ColumnName != "序号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[1].ColumnName != "主表序列号")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[2].ColumnName != "子件编码")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[3].ColumnName != "子件名称")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[4].ColumnName != "发料仓库")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[5].ColumnName != "基本用量")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[6].ColumnName != "损耗率(%)")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else if (excelTable[1].Columns[7].ColumnName != "属性")
|
{
|
code = "300";
|
Message = "模板不符合规范,请检查列名";
|
}
|
else
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#endregion
|
|
#region【Excel上传数据验证】
|
#region【Excel上传数据验证,角色权限】
|
public static List<ExcelErro> OneData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,用户角色】
|
public static List<ExcelErro> TwoData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,工位清单】
|
public static List<ExcelErro> ThreeData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,供方清单】
|
public static List<ExcelErro> FourData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,客户清单】
|
public static List<ExcelErro> FiveData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,仓库定义】
|
public static List<ExcelErro> SixOneData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,库区定义】
|
public static List<ExcelErro> SixTwoData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,库位定义】
|
public static List<ExcelErro> SixThreeData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,容器定义】
|
public static List<ExcelErro> SevenData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,存货档案】
|
public static List<ExcelErro> EightData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,设备清单】
|
public static List<ExcelErro> NineData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,设备点检】
|
public static List<ExcelErro> TenData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,设备保养】
|
public static List<ExcelErro> ElevenData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,工装清单】
|
public static List<ExcelErro> TwelveData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,工装点检】
|
public static List<ExcelErro> ThirteenData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,工装保养】
|
public static List<ExcelErro> FourteenData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,工序定义】
|
public static List<ExcelErro> FifteenData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,工艺路线】
|
public static List<ExcelErro> SixteenData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,质检标准】
|
public static List<ExcelErro> SeventeenData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,缺陷定义】
|
public static List<ExcelErro> EighteenData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,生产订单】
|
public static List<ExcelErro> NineteenData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,库存查询】
|
public static List<ExcelErro> TwentyData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
|
#region【获取库存的容器中是否同一个产品】
|
|
public static Boolean getSamePNofTote(String PN, String Tote_ID)
|
{
|
Boolean bRes = false;
|
String sql = "";
|
String stockPN = "";
|
DataTable dt = null;
|
|
if (String.IsNullOrEmpty(PN))
|
{
|
bRes = true;
|
}
|
else
|
{
|
sql = @"select part_number from mes_tk_wms_stock where tote_id='" + Tote_ID + "' and qty>0 ";
|
dt = DBHelper.GetTable(sql);
|
if (dt.Rows.Count > 0)
|
{
|
stockPN = dt.Rows[0]["part_number"].ToString();
|
if (PN == stockPN)
|
{
|
bRes = true;
|
}
|
}
|
else
|
{
|
//仓库中不存在此容器
|
bRes = true;
|
}
|
}
|
return bRes;
|
}
|
#endregion
|
#endregion
|
|
#region【Excel上传数据验证,物料清单】
|
public static List<ExcelErro> TwentyOneData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
|
return list;
|
}
|
#endregion
|
#endregion
|
|
#region[Excel上传数据提交]
|
#region[Excel数据上传,角色权限]
|
public static string OneSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,用户角色】
|
public static string TwoSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,工位清单】
|
public static string ThreeSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,供方清单】
|
public static string FourSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,客户清单】
|
public static string FiveSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,仓库定义】
|
public static string SixOneSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,库区定义】
|
public static string SixTwoSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,库位定义】
|
public static string SixThreeSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,容器定义】
|
public static string SevenSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,存货档案】
|
public static string EightSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,设备清单】
|
public static string NineSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,设备点检】
|
public static string TenSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,设备保养】
|
public static string ElevenSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,工装清单】
|
public static string TwelveSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,工装点检】
|
public static string ThirteenSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,工装保养】
|
public static string FourteenSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,工序定义】
|
public static string FifteenSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,工艺路线】
|
public static string SixteenSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,质检标准】
|
public static string SeventeenSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,缺陷定义】
|
public static string EighteenSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,生产订单】
|
public static string NineteenSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,库存查询】
|
public static string TwentySubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region【Excel数据上传,物料清单】
|
public static string TwentyOneSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
try
|
{
|
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#endregion
|
}
|
}
|
