using Dapper;
|
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 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 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
|
{
|
code = "200";
|
Message = "模板检验通过";
|
}
|
return Message;
|
}
|
#endregion
|
|
#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 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> TwoData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
var dynamicParams = new DynamicParameters();
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
List<DataTable> excelTable = new List<DataTable>();
|
list = ImportExcel.ExcelToTableListErro(FileCode); //验证Excel数据必填字段是否为空、唯一字段是否重复
|
excelTable = ImportExcel.ExcelToTableList(FileCode); //获取Excel数据
|
//主表
|
for (int j = 0; j < excelTable[0].Rows.Count; j++)
|
{
|
if (excelTable[0].Rows[j][1].ToString().Trim() != null && excelTable[0].Rows[j][1].ToString().Trim() != "")
|
{
|
sql = @"select * from TGroup where group_code=@group_code";
|
dynamicParams.Add("@group_code", excelTable[0].Rows[j][1].ToString().Trim());
|
dt = DapperHelper.selectdata(sql, dynamicParams);
|
if (dt.Rows.Count > 0)
|
{
|
ExcelErro erro = new ExcelErro();
|
erro.RoeNumber = "/";
|
erro.ErrorField = "{班组编码(唯一)}";
|
erro.ErrorCont = "班组表:{班组编码(唯一)}字段" + excelTable[0].Rows[j][1].ToString().Trim() + "已存在";
|
list.Add(erro);
|
}
|
}
|
}
|
//子表
|
for (int k = 0; k < excelTable[1].Rows.Count; k++)
|
{
|
if (excelTable[1].Rows[k][1].ToString().Trim() != null && excelTable[1].Rows[k][1].ToString().Trim() != "")
|
{
|
sql = @"select * from TUser where usercode=@usercode";
|
dynamicParams.Add("@usercode", excelTable[1].Rows[k][1].ToString().Trim());
|
dt = DapperHelper.selectdata(sql, dynamicParams);
|
if (dt.Rows.Count > 0)
|
{
|
ExcelErro erro = new ExcelErro();
|
erro.RoeNumber = "/";
|
erro.ErrorField = "{用户编码(唯一)}";
|
erro.ErrorCont = "用户表:{用户编码(唯一)}字段" + excelTable[1].Rows[k][2].ToString().Trim() + "已存在";
|
list.Add(erro);
|
}
|
}
|
if (excelTable[1].Rows[k][7].ToString().Trim() != null && excelTable[1].Rows[k][7].ToString().Trim() != "")
|
{
|
sql = @"select * from TOrganization where org_code=@org_code";
|
dynamicParams.Add("@org_code", excelTable[1].Rows[k][7].ToString().Trim());
|
dt = DapperHelper.selectdata(sql, dynamicParams);
|
if (dt == null || dt.Rows.Count <= 0)
|
{
|
ExcelErro erro = new ExcelErro();
|
erro.RoeNumber = "/";
|
erro.ErrorField = "{组织编码}";
|
erro.ErrorCont = "用户表:{组织编码}字段" + excelTable[1].Rows[k][2].ToString().Trim() + "不存在";
|
list.Add(erro);
|
}
|
}
|
}
|
//判断子表外键不存在于主表主键中的数据
|
var dt3 = from r in excelTable[1].AsEnumerable()
|
where !(
|
from rr in excelTable[0].AsEnumerable()
|
select rr.Field<string>("班组编号(唯一)")
|
).Contains(r.Field<string>("用户组编码"))
|
select r;
|
List<DataRow> listRow = dt3.ToList();
|
if (listRow.Count > 0)
|
{
|
ExcelErro erro = new ExcelErro();
|
erro.RoeNumber = "/";
|
erro.ErrorField = "{用户组编码}";
|
erro.ErrorCont = "用户表:{用户组编码}字段中有值在班组表:{班组编号(唯一)}中不存在";
|
list.Add(erro);
|
}
|
if (list.Count > 0)
|
{
|
int index = 0;
|
foreach (ExcelErro item in list)
|
{
|
index++;
|
item.Seq = index.ToString();
|
}
|
StuCode = "300";
|
message = "数据验证失败";
|
}
|
else
|
{
|
StuCode = "200";
|
message = "数据验证成功";
|
count = excelTable[0].Rows.Count + excelTable[1].Rows.Count;
|
}
|
return list;
|
}
|
#endregion
|
|
#region【Excel上传数据验证,角色权限】
|
public static List<ExcelErro> OneData(string FileCode, out string StuCode, out string message, out int count)
|
{
|
message = "";
|
StuCode = "";
|
count = 0;
|
string sql = "";
|
var dynamicParams = new DynamicParameters();
|
DataTable dt;
|
List<ExcelErro> list = new List<ExcelErro>();
|
List<DataTable> excelTable = new List<DataTable>();
|
list = ImportExcel.ExcelToTableListErro(FileCode); //验证Excel数据必填字段是否为空、唯一字段是否重复
|
excelTable = ImportExcel.ExcelToTableList(FileCode); //获取Excel数据
|
//主表
|
for (int j = 0; j < excelTable[0].Rows.Count; j++)
|
{
|
if (excelTable[0].Rows[j][1].ToString().Trim() != null && excelTable[0].Rows[j][1].ToString().Trim() != "")
|
{
|
sql = @"select * from TRoleType where roletype_code=@roletype_code";
|
dynamicParams.Add("@roletype_code", excelTable[0].Rows[j][1].ToString().Trim());
|
dt = DapperHelper.selectdata(sql, dynamicParams);
|
if (dt.Rows.Count > 0)
|
{
|
ExcelErro erro = new ExcelErro();
|
erro.RoeNumber = "/";
|
erro.ErrorField = "{角色类型编码(唯一)}";
|
erro.ErrorCont = "班组表:{角色类型编码(唯一)}字段" + excelTable[0].Rows[j][1].ToString().Trim() + "已存在";
|
list.Add(erro);
|
}
|
}
|
}
|
//子表
|
for (int k = 0; k < excelTable[1].Rows.Count; k++)
|
{
|
if (excelTable[1].Rows[k][1].ToString().Trim() != null && excelTable[1].Rows[k][1].ToString().Trim() != "")
|
{
|
sql = @"select * from TRole where role_code=@role_code";
|
dynamicParams.Add("@role_code", excelTable[1].Rows[k][1].ToString().Trim());
|
dt = DapperHelper.selectdata(sql, dynamicParams);
|
if (dt.Rows.Count > 0)
|
{
|
ExcelErro erro = new ExcelErro();
|
erro.RoeNumber = "/";
|
erro.ErrorField = "{角色编号(唯一)}";
|
erro.ErrorCont = "角色表:{角色编号(唯一)}字段" + excelTable[1].Rows[k][2].ToString().Trim() + "已存在";
|
list.Add(erro);
|
}
|
}
|
}
|
//判断子表外键不存在于主表主键中的数据
|
var dt3 = from r in excelTable[1].AsEnumerable()
|
where !(
|
from rr in excelTable[0].AsEnumerable()
|
select rr.Field<string>("角色类型编号(唯一)")
|
).Contains(r.Field<string>("角色类型编码"))
|
select r;
|
List<DataRow> listRow = dt3.ToList();
|
if (listRow.Count > 0)
|
{
|
ExcelErro erro = new ExcelErro();
|
erro.RoeNumber = "/";
|
erro.ErrorField = "{角色类型编码}";
|
erro.ErrorCont = "角色表:{角色类型编码}字段中有值在角色类型表:{角色类型编号(唯一)}中不存在";
|
list.Add(erro);
|
}
|
if (list.Count > 0)
|
{
|
int index = 0;
|
foreach (ExcelErro item in list)
|
{
|
index++;
|
item.Seq = index.ToString();
|
}
|
StuCode = "300";
|
message = "数据验证失败";
|
}
|
else
|
{
|
StuCode = "200";
|
message = "数据验证成功";
|
count = excelTable[0].Rows.Count + excelTable[1].Rows.Count;
|
}
|
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 TwoSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
string sql = "";
|
string ZZName = "", Enable = "", WageType = "";
|
DataTable dt;
|
List<object> list = new List<object>();
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
list.Clear();
|
List<DataTable> excelTable = new List<DataTable>();
|
excelTable = ImportExcel.ExcelToTableList(FileCode);
|
//导入班组
|
for (int k = 0; k < excelTable[0].Rows.Count; k++)
|
{
|
sql = @"insert into TGroup(group_code,group_name,description,lm_user,lm_date)
|
values(@group_code,@group_name,@description,@Operator,@CreateDate)";
|
list.Add(new
|
{
|
str = sql,
|
parm = new
|
{
|
group_code = excelTable[0].Rows[k][1].ToString().Trim(),
|
group_name = excelTable[0].Rows[k][2].ToString().Trim(),
|
description = excelTable[0].Rows[k][3].ToString().Trim(),
|
CreateDate = DateTime.Now.ToString(),
|
Operator = User
|
}
|
});
|
}
|
//导入用户
|
for (int i = 0; i < excelTable[1].Rows.Count; i++)
|
{
|
if (excelTable[1].Rows[i][3].ToString().Trim() == "在职")
|
{
|
Enable = "Y";
|
}
|
else
|
{
|
Enable = "N";
|
}
|
//工资类型
|
switch (excelTable[1].Rows[i][8].ToString().Trim())
|
{
|
case "计件制":
|
WageType = "2";
|
break;
|
case "计时制":
|
WageType = "1";
|
break;
|
default:
|
break;
|
}
|
|
sql = @"insert into TUser(usercode,username,password,enable,mobile,lm_date,email,lm_user,stu_torgcode,wagetype)
|
values(@UserCode,@UserName,@password,@Enable,@Mobile,@CreateDate,@Email,@Operator,@StuOrg,@wagetype)";
|
list.Add(new
|
{
|
str = sql,
|
parm = new
|
{
|
UserCode = excelTable[1].Rows[i][1].ToString().Trim(),
|
UserName = excelTable[1].Rows[i][2].ToString().Trim(),
|
password= excelTable[1].Rows[i][4].ToString().Trim(),
|
Enable= Enable,
|
Mobile= excelTable[1].Rows[i][5].ToString().Trim(),
|
CreateDate= DateTime.Now.ToString(),
|
Email= excelTable[1].Rows[i][6].ToString().Trim(),
|
Operator= User,
|
StuOrg= excelTable[1].Rows[i][7].ToString().Trim(),
|
wagetype= WageType
|
}
|
});
|
}
|
bool aa = DapperHelper.DoTransaction(list);
|
if (aa)
|
{
|
StuCode = "300";
|
message = "导入失败！";
|
}
|
else
|
{
|
StuCode = "200";
|
message = "导入成功！";
|
}
|
}
|
catch (Exception e)
|
{
|
StuCode = "300";
|
message = e.Message;
|
}
|
return message;
|
}
|
#endregion
|
|
#region[Excel数据上传,角色权限]
|
public static string OneSubmit(string FileCode, string User, out string StuCode)
|
{
|
string message = "";
|
StuCode = "";
|
string sql = "";
|
string ZZName = "", Enable = "", WageType = "";
|
DataTable dt;
|
List<object> list = new List<object>();
|
var dynamicParams = new DynamicParameters();
|
try
|
{
|
list.Clear();
|
List<DataTable> excelTable = new List<DataTable>();
|
excelTable = ImportExcel.ExcelToTableList(FileCode);
|
//导入角色类型
|
for (int k = 0; k < excelTable[0].Rows.Count; k++)
|
{
|
sql = @"insert into TRoleType(roletype_code,roletype_name)
|
values(@roletype_code,@roletype_name)";
|
list.Add(new
|
{
|
str = sql,
|
parm = new
|
{
|
roletype_code = excelTable[0].Rows[k][1].ToString().Trim(),
|
roletype_name = excelTable[0].Rows[k][2].ToString().Trim()
|
}
|
});
|
}
|
//导入角色
|
for (int i = 0; i < excelTable[1].Rows.Count; i++)
|
{
|
sql = @"insert into TRole(role_code,role_name,roletype_code,description,lm_user,lm_date)
|
values(@role_code,@role_name,@roletype_code,@description,@Operator,@CreateDate)";
|
list.Add(new
|
{
|
str = sql,
|
parm = new
|
{
|
role_code = excelTable[1].Rows[i][1].ToString().Trim(),
|
role_name = excelTable[1].Rows[i][2].ToString().Trim(),
|
roletype_code = excelTable[1].Rows[i][3].ToString().Trim(),
|
description = excelTable[1].Rows[i][4].ToString().Trim(),
|
Operator = User,
|
CreateDate = DateTime.Now.ToString()
|
}
|
});
|
}
|
bool aa = DapperHelper.DoTransaction(list);
|
if (aa)
|
{
|
StuCode = "300";
|
message = "导入失败！";
|
}
|
else
|
{
|
StuCode = "200";
|
message = "导入成功！";
|
}
|
}
|
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
|
}
|
}
|
