PDMesApi.git - Gitblit

			@@ -18,57 +18,110 @@
			{
			string Message = "";
			code = "";
			DataTable excelTable = new DataTable();
			excelTable = ImportExcel.ExcelToTable(FileCode);
			if (excelTable.Columns.Count != 6)
			List<DataTable> excelTable = new List<DataTable>();
			excelTable = ImportExcel.ExcelToTableList(FileCode);
			if (excelTable.Count != 4)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "导入模板不符合规范,请检查sheet数";
			return Message;

			}
			else if (excelTable.Columns[0].ColumnName != "序号")
			else if (excelTable[0].Columns.Count != 4)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "用户班组模板不符合规范,请检查列名字段数";
			return Message;
			}
			else if (excelTable.Columns[1].ColumnName != "用户编号(唯一)")
			else if (excelTable[1].Columns.Count != 10)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "用户清单模板不符合规范,请检查列名字段数";
			return Message;
			}
			else if (excelTable.Columns[2].ColumnName != "用户姓名")
			else if (excelTable[0].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "用户班组模板：表头信息不符合规范,第1列应为{序号}";
			return Message;
			}
			else if (excelTable.Columns[3].ColumnName != "密码")
			else if (excelTable[0].Columns[1].ColumnName != "班组编号(唯一)")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "用户班组模板：表头信息不符合规范,第2列应为{班组编号(唯一)}";
			return Message;
			}
			else if (excelTable.Columns[4].ColumnName != "手机号")
			else if (excelTable[0].Columns[2].ColumnName != "班组名称")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "用户班组模板：表头信息不符合规范,第3列应为{班组名称}";
			return Message;
			}
			else if (excelTable.Columns[5].ColumnName != "邮箱")
			else if (excelTable[0].Columns[3].ColumnName != "班组描述")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "用户班组模板：表头信息不符合规范,第4列应为{班组描述}";
			return Message;
			}
			else if (excelTable.Columns[6].ColumnName != "所属组织")
			else if (excelTable[1].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "用户清单模板：表头信息不符合规范,第1列应为{序号}";
			return Message;
			}
			else if (excelTable.Columns[7].ColumnName != "在职状态")
			else if (excelTable[1].Columns[1].ColumnName != "用户编号(唯一)")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "用户清单模板：表头信息不符合规范,第2列应为{用户编号(唯一)}";
			return Message;
			}
			else if (excelTable.Columns[8].ColumnName != "工资类型")
			else if (excelTable[1].Columns[2].ColumnName != "用户姓名")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "用户清单模板：表头信息不符合规范,第3列应为{用户姓名}";
			return Message;
			}
			else if (excelTable[1].Columns[3].ColumnName != "在职状态")
			{
			code = "300";
			Message = "用户清单模板：表头信息不符合规范,第4列应为{在职状态}";
			return Message;
			}
			else if (excelTable[1].Columns[4].ColumnName != "密码")
			{
			code = "300";
			Message = "用户清单模板：表头信息不符合规范,第5列应为{密码}";
			return Message;
			}
			else if (excelTable[1].Columns[5].ColumnName != "手机号")
			{
			code = "300";
			Message = "用户清单模板：表头信息不符合规范,第6列应为{手机号}";
			return Message;
			}
			else if (excelTable[1].Columns[6].ColumnName != "邮箱")
			{
			code = "300";
			Message = "用户清单模板：表头信息不符合规范,第7列应为{邮箱}";
			return Message;
			}
			else if (excelTable[1].Columns[7].ColumnName != "组织编码")
			{
			code = "300";
			Message = "用户清单模板：表头信息不符合规范,第8列应为{组织编码}";
			return Message;
			}
			else if (excelTable[1].Columns[8].ColumnName != "工资类型")
			{
			code = "300";
			Message = "用户清单模板：表头信息不符合规范,第9列应为{工资类型}";
			return Message;
			}
			else if (excelTable[1].Columns[9].ColumnName != "用户组编码")
			{
			code = "300";
			Message = "用户清单模板：表头信息不符合规范,第10列应为{用户组编码}";
			return Message;
			}
			else
			{
			@@ -84,32 +137,74 @@
			{
			string Message = "";
			code = "";
			DataTable excelTable = new DataTable();
			excelTable = ImportExcel.ExcelToTable(FileCode);
			if (excelTable.Columns.Count != 4)
			List<DataTable> excelTable = new List<DataTable>();
			excelTable = ImportExcel.ExcelToTableList(FileCode);
			if (excelTable.Count != 4)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "导入模板不符合规范,请检查sheet数";
			return Message;

			}
			else if (excelTable.Columns[0].ColumnName != "序号")
			else if (excelTable[0].Columns.Count != 3)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "角色类型模板不符合规范,请检查列名字段数";
			return Message;
			}
			else if (excelTable.Columns[1].ColumnName != "角色编号(唯一)")
			else if (excelTable[1].Columns.Count != 5)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "模板角色清单不符合规范,请检查列名字段数";
			return Message;
			}
			else if (excelTable.Columns[2].ColumnName != "角色名称(唯一)")
			else if (excelTable[0].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "角色类型模板：表头信息不符合规范,第1列应为{序号}";
			return Message;
			}
			else if (excelTable.Columns[3].ColumnName != "角色类型")
			else if (excelTable[0].Columns[1].ColumnName != "角色类型编号(唯一)")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "角色类型模板：表头信息不符合规范,第2列应为{角色类型编号(唯一)}";
			return Message;
			}
			else if (excelTable[0].Columns[2].ColumnName != "角色类型名称")
			{
			code = "300";
			Message = "角色类型模板：表头信息不符合规范,第3列应为{角色类型名称}";
			return Message;
			}
			else if (excelTable[1].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "角色清单模板：表头信息不符合规范,第1列应为{序号}";
			return Message;
			}
			else if (excelTable[1].Columns[1].ColumnName != "角色编号(唯一)")
			{
			code = "300";
			Message = "角色清单模板：表头信息不符合规范,第2列应为{角色编号(唯一)}";
			return Message;
			}
			else if (excelTable[1].Columns[2].ColumnName != "角色姓名")
			{
			code = "300";
			Message = "角色清单模板：表头信息不符合规范,第3列应为{角色姓名}";
			return Message;
			}
			else if (excelTable[1].Columns[3].ColumnName != "角色类型编码")
			{
			code = "300";
			Message = "角色清单模板：表头信息不符合规范,第4列应为{角色类型编码}";
			return Message;
			}
			else if (excelTable[1].Columns[4].ColumnName != "角色描述")
			{
			code = "300";
			Message = "角色清单模板：表头信息不符合规范,第5列应为{角色描述}";
			return Message;
			}
			else
			{
			@@ -186,42 +281,67 @@
			}
			#endregion

			#region【Excel模板上传验证,供方清单模板】
			#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)
			List<DataTable> excelTable = new List<DataTable>();
			excelTable = ImportExcel.ExcelToTableList(FileCode);
			if (excelTable.Count != 2)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "导入模板不符合规范,请检查sheet数";
			return Message;

			}
			else if (excelTable.Columns[0].ColumnName != "序号")
			else if (excelTable[0].Columns.Count != 7)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "往来单位模板不符合规范,请检查列名字段数";
			return Message;
			}
			else if (excelTable.Columns[1].ColumnName != "供方编号(唯一)")
			else if (excelTable[0].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "往来单位模板不符合规范：表头信息不符合规范,第1列应为{序号}";
			return Message;
			}
			else if (excelTable.Columns[2].ColumnName != "供方名称（唯一）")
			else if (excelTable[0].Columns[1].ColumnName != "往来单位编号(唯一)")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "往来单位模板不符合规范：表头信息不符合规范,第2列应为{往来单位编号(唯一)}";
			return Message;
			}
			else if (excelTable.Columns[3].ColumnName != "补充描述")
			else if (excelTable[0].Columns[2].ColumnName != "往来单位名称")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "往来单位模板不符合规范：表头信息不符合规范,第3列应为{往来单位名称}";
			return Message;
			}
			else if (excelTable.Columns[4].ColumnName.Trim() != "供方类型（外协供方,外购供方）")
			else if (excelTable[0].Columns[3].ColumnName != "往来单位属性")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "往来单位模板不符合规范：表头信息不符合规范,第4列应为{往来单位属性}";
			return Message;
			}
			else if (excelTable[0].Columns[4].ColumnName != "联系人")
			{
			code = "300";
			Message = "往来单位模板不符合规范：表头信息不符合规范,第5列应为{联系人}";
			return Message;
			}
			else if (excelTable[0].Columns[5].ColumnName != "联系方式")
			{
			code = "300";
			Message = "往来单位模板不符合规范：表头信息不符合规范,第6列应为{联系方式}";
			return Message;
			}
			else if (excelTable[0].Columns[6].ColumnName != "地址")
			{
			code = "300";
			Message = "往来单位模板不符合规范：表头信息不符合规范,第7列应为{地址}";
			return Message;
			}
			else
			{
			@@ -232,180 +352,85 @@
			}
			#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模板上传验证,仓库定义模板】
			#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)
			List<DataTable> excelTable = new List<DataTable>();
			excelTable = ImportExcel.ExcelToTableList(FileCode);
			if (excelTable.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
			Message = "导入模板不符合规范,请检查sheet数";
			return Message;

			#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)
			}
			else if (excelTable[0].Columns.Count != 4)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "仓库清单模板不符合规范,请检查列名字段数";
			return Message;
			}
			else if (excelTable.Columns[0].ColumnName != "序号")
			else if (excelTable[1].Columns.Count != 5)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "库位清单模板不符合规范,请检查列名字段数";
			return Message;
			}
			else if (excelTable.Columns[1].ColumnName != "库区编码(唯一)")
			else if (excelTable[0].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "用户班组模板：表头信息不符合规范,第1列应为{序号}";
			return Message;
			}
			else if (excelTable.Columns[2].ColumnName != "库区名称（唯一）")
			else if (excelTable[0].Columns[1].ColumnName != "仓库编号(唯一)")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "仓库清单模板：表头信息不符合规范,第2列应为{仓库编号(唯一)}";
			return Message;
			}
			else if (excelTable.Columns[3].ColumnName != "功能描述")
			else if (excelTable[0].Columns[2].ColumnName != "仓库名称")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "仓库清单模板：表头信息不符合规范,第3列应为{仓库名称}";
			return Message;
			}
			else if (excelTable.Columns[4].ColumnName != "仓库编码")
			else if (excelTable[0].Columns[3].ColumnName != "仓库描述")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "仓库清单模板：表头信息不符合规范,第4列应为{仓库描述}";
			return Message;
			}
			else if (excelTable.Columns[5].ColumnName != "仓库名称")
			else if (excelTable[1].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "库位清单模板：表头信息不符合规范,第1列应为{序号}";
			return 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)
			else if (excelTable[1].Columns[1].ColumnName != "库位编号(唯一)")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "库位清单模板：表头信息不符合规范,第2列应为{库位编号(唯一)}";
			return Message;
			}
			else if (excelTable.Columns[0].ColumnName != "序号")
			else if (excelTable[1].Columns[2].ColumnName != "库位姓名")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "库位清单模板：表头信息不符合规范,第3列应为{库位姓名}";
			return Message;
			}
			else if (excelTable.Columns[1].ColumnName != "库位编码(唯一)")
			else if (excelTable[1].Columns[3].ColumnName != "所属仓库编码")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "库位清单模板：表头信息不符合规范,第4列应为{所属仓库编码}";
			return Message;
			}
			else if (excelTable.Columns[2].ColumnName != "库位名称（唯一）")
			else if (excelTable[1].Columns[4].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 = "模板不符合规范,请检查列名";
			Message = "库位清单模板：表头信息不符合规范,第5列应为{库位描述}";
			return Message;
			}
			else
			{
			@@ -543,62 +568,117 @@
			{
			string Message = "";
			code = "";
			DataTable excelTable = new DataTable();
			excelTable = ImportExcel.ExcelToTable(FileCode);
			if (excelTable.Columns.Count != 10)
			List<DataTable> excelTable = new List<DataTable>();
			excelTable = ImportExcel.ExcelToThreeTableList(FileCode);
			if (excelTable.Count != 6)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "导入模板不符合规范,请检查Sheet数";
			}
			else if (excelTable.Columns[0].ColumnName != "序号")
			else if (excelTable[0].Columns.Count != 4)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备清单模板(设备类型)不符合规范,请检查列名字段数";
			}
			else if (excelTable.Columns[1].ColumnName != "设备编号(唯一)")
			else if (excelTable[1].Columns.Count != 5)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备清单模板(设备组)不符合规范,请检查列名字段数";
			}
			else if (excelTable.Columns[2].ColumnName != "设备名称")
			else if (excelTable[2].Columns.Count != 9)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备清单模板(设备清单)不符合规范,请检查列名字段数";
			}
			else if (excelTable.Columns[3].ColumnName != "设备类型")
			else if (excelTable[0].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备清单模板(设备类型)：表头信息不符合规范,第1列应为{序号}";
			}
			else if (excelTable.Columns[4].ColumnName != "生产车间")
			else if (excelTable[0].Columns[1].ColumnName != "设备类型编号(唯一)")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备清单模板(设备类型)：表头信息不符合规范,第2列应为{设备类型编号(唯一)}";
			}
			else if (excelTable.Columns[5].ColumnName != "所属产线")
			else if (excelTable[0].Columns[2].ColumnName != "设备类型名称")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备清单模板(设备类型)：表头信息不符合规范,第3列应为{设备类型名称}";
			}
			else if (excelTable.Columns[6].ColumnName != "投入日期")
			else if (excelTable[0].Columns[3].ColumnName != "设备类型描述")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备清单模板(设备类型)：表头信息不符合规范,第4列应为{设备类型描述}";
			}
			else if (excelTable.Columns[7].ColumnName != "稼动率（%）")
			else if (excelTable[1].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备清单模板(设备组)：表头信息不符合规范,第1列应为{序号}";
			}
			else if (excelTable.Columns[8].ColumnName != "使用状态")
			else if (excelTable[1].Columns[1].ColumnName != "设备组编号(唯一)")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备清单模板(设备组)：表头信息不符合规范,第2列应为{设备组编号(唯一)}";
			}
			else if (excelTable.Columns[9].ColumnName != "数采标识1")
			else if (excelTable[1].Columns[2].ColumnName != "设备组名称")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备清单模板(设备组)：表头信息不符合规范,第3列应为{设备组名称}";
			}
			else if (excelTable[1].Columns[3].ColumnName != "设备类型编号(唯一)")
			{
			code = "300";
			Message = "设备清单模板(设备组)：表头信息不符合规范,第4列应为{设备类型编号(唯一)}";
			}
			else if (excelTable[1].Columns[4].ColumnName != "设备组描述")
			{
			code = "300";
			Message = "设备清单模板(设备组)：表头信息不符合规范,第5列应为{设备组描述}";
			}
			else if (excelTable[2].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "设备清单模板(设备清单)：表头信息不符合规范,第1列应为{序号}";
			}
			else if (excelTable[2].Columns[1].ColumnName != "设备编号(唯一)")
			{
			code = "300";
			Message = "设备清单模板(设备清单)：表头信息不符合规范,第1列应为{设备编号(唯一)}";
			}
			else if (excelTable[2].Columns[2].ColumnName != "设备名称")
			{
			code = "300";
			Message = "设备清单模板(设备清单)：表头信息不符合规范,第1列应为{设备名称}";
			}
			else if (excelTable[2].Columns[3].ColumnName != "设备类型编号(唯一)")
			{
			code = "300";
			Message = "设备清单模板(设备清单)：表头信息不符合规范,第1列应为{设备类型编号(唯一)}";
			}
			else if (excelTable[2].Columns[4].ColumnName != "设备组编号(唯一)")
			{
			code = "300";
			Message = "设备清单模板(设备清单)：表头信息不符合规范,第1列应为{设备组编号(唯一)}";
			}
			else if (excelTable[2].Columns[5].ColumnName != "投入日期")
			{
			code = "300";
			Message = "设备清单模板(设备清单)：表头信息不符合规范,第1列应为{投入日期}";
			}
			else if (excelTable[2].Columns[6].ColumnName != "生产车间")
			{
			code = "300";
			Message = "设备清单模板(设备清单)：表头信息不符合规范,第1列应为{生产车间}";
			}
			else if (excelTable[2].Columns[7].ColumnName != "使用状态")
			{
			code = "300";
			Message = "设备清单模板(设备清单)：表头信息不符合规范,第1列应为{使用状态}";
			}
			else if (excelTable[2].Columns[8].ColumnName != "稼动率（%）")
			{
			code = "300";
			Message = "设备清单模板(设备清单)：表头信息不符合规范,第1列应为{稼动率（%）}";
			}
			else
			{
			@@ -609,7 +689,7 @@
			}
			#endregion

			#region【Excel模板上传验证,设备点检模板】
			#region【Excel模板上传验证,设备点检项目模板】
			public static string Ten(string FileCode, out string code)
			{
			string Message = "";
			@@ -619,82 +699,51 @@
			if (excelTable.Count != 2)
			{
			code = "300";
			Message = "模板不符合规范,缺失的Sheet";
			Message = "导入模板不符合规范,请检查sheet数";
			return Message;

			}
			else if (excelTable[0].Columns.Count != 4)
			else if (excelTable[0].Columns.Count != 6)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名字段数";
			}
			else if (excelTable[1].Columns.Count != 9)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名字段数";
			Message = "设备点检项目模板不符合规范,请检查列名字段数";
			return Message;
			}
			else if (excelTable[0].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备点检项目模板不符合规范：表头信息不符合规范,第1列应为{序号}";
			return Message;
			}
			else if (excelTable[0].Columns[1].ColumnName != "点检标准(唯一)")
			else if (excelTable[0].Columns[1].ColumnName != "点检项目编号(唯一)")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备点检项目模板不符合规范：表头信息不符合规范,第2列应为{点检项目编号(唯一)}";
			return Message;
			}
			else if (excelTable[0].Columns[2].ColumnName != "标准名称（唯一）")
			else if (excelTable[0].Columns[2].ColumnName != "点检项目名称")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备点检项目模板不符合规范：表头信息不符合规范,第3列应为{点检项目名称}";
			return Message;
			}
			else if (excelTable[0].Columns[3].ColumnName != "点检管控")
			else if (excelTable[0].Columns[3].ColumnName != "点检周期")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备点检项目模板不符合规范：表头信息不符合规范,第4列应为{点检周期}";
			return Message;
			}
			else if (excelTable[1].Columns[0].ColumnName != "序号")
			else if (excelTable[0].Columns[4].ColumnName != "是否扫码")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备点检项目模板不符合规范：表头信息不符合规范,第4列应为{是否扫码}";
			return Message;
			}
			else if (excelTable[1].Columns[1].ColumnName != "点检标准")
			else if (excelTable[0].Columns[5].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 = "模板不符合规范,请检查列名";
			Message = "设备点检项目模板不符合规范：表头信息不符合规范,第4列应为{点检项目要求}";
			return Message;
			}
			else
			{
			@@ -705,7 +754,72 @@
			}
			#endregion

			#region【Excel模板上传验证,设备保养模板】
			#region【Excel模板上传验证,设备点检标准模板】
			public static string TwentyTwo(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数";
			return Message;

			}
			else if (excelTable[0].Columns.Count != 6)
			{
			code = "300";
			Message = "设备点检项目模板不符合规范,请检查列名字段数";
			return Message;
			}
			else if (excelTable[0].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "设备点检项目模板不符合规范：表头信息不符合规范,第1列应为{序号}";
			return Message;
			}
			else if (excelTable[0].Columns[1].ColumnName != "点检项目编号(唯一)")
			{
			code = "300";
			Message = "设备点检项目模板不符合规范：表头信息不符合规范,第2列应为{点检项目编号(唯一)}";
			return Message;
			}
			else if (excelTable[0].Columns[2].ColumnName != "点检项目名称")
			{
			code = "300";
			Message = "设备点检项目模板不符合规范：表头信息不符合规范,第3列应为{点检项目名称}";
			return Message;
			}
			else if (excelTable[0].Columns[3].ColumnName != "点检周期")
			{
			code = "300";
			Message = "设备点检项目模板不符合规范：表头信息不符合规范,第4列应为{点检周期}";
			return Message;
			}
			else if (excelTable[0].Columns[4].ColumnName != "是否扫码")
			{
			code = "300";
			Message = "设备点检项目模板不符合规范：表头信息不符合规范,第4列应为{是否扫码}";
			return Message;
			}
			else if (excelTable[0].Columns[5].ColumnName != "点检项目要求")
			{
			code = "300";
			Message = "设备点检项目模板不符合规范：表头信息不符合规范,第4列应为{点检项目要求}";
			return Message;
			}
			else
			{
			code = "200";
			Message = "模板检验通过";
			}
			return Message;
			}
			#endregion

			#region【Excel模板上传验证,设备保养项目模板】
			public static string Eleven(string FileCode, out string code)
			{
			string Message = "";
			@@ -715,77 +829,104 @@
			if (excelTable.Count != 2)
			{
			code = "300";
			Message = "模板不符合规范,缺失的Sheet";
			Message = "导入模板不符合规范,请检查sheet数";
			return Message;

			}
			else if (excelTable[0].Columns.Count != 3)
			else if (excelTable[0].Columns.Count != 6)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名字段数";
			}
			else if (excelTable[1].Columns.Count != 9)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名字段数";
			Message = "设备保养项目模板不符合规范,请检查列名字段数";
			return Message;
			}
			else if (excelTable[0].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备保养项目模板不符合规范：表头信息不符合规范,第1列应为{序号}";
			return Message;
			}
			else if (excelTable[0].Columns[1].ColumnName != "保养标准(唯一)")
			else if (excelTable[0].Columns[1].ColumnName != "保养项目编号(唯一)")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备保养项目模板不符合规范：表头信息不符合规范,第2列应为{保养项目编号(唯一)}";
			return Message;
			}
			else if (excelTable[0].Columns[2].ColumnName != "标准名称（唯一）")
			else if (excelTable[0].Columns[2].ColumnName != "保养项目名称")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备保养项目模板不符合规范：表头信息不符合规范,第3列应为{保养项目名称}";
			return Message;
			}
			else if (excelTable[1].Columns[0].ColumnName != "序号")
			else if (excelTable[0].Columns[3].ColumnName != "是否扫码")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备保养项目模板不符合规范：表头信息不符合规范,第4列应为{是否扫码}";
			return Message;
			}
			else if (excelTable[1].Columns[1].ColumnName != "保养标准")
			else if (excelTable[0].Columns[4].ColumnName != "保养项目要求")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备保养项目模板不符合规范：表头信息不符合规范,第4列应为{保养项目要求}";
			return Message;
			}
			else if (excelTable[1].Columns[2].ColumnName != "标准名称")
			else
			{
			code = "200";
			Message = "模板检验通过";
			}
			return Message;
			}
			#endregion

			#region【Excel模板上传验证,设备保养标准模板】
			public static string TwentyThree(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 = "模板不符合规范,请检查列名";
			Message = "导入模板不符合规范,请检查sheet数";
			return Message;

			}
			else if (excelTable[1].Columns[3].ColumnName != "SEQ(部位顺序)")
			else if (excelTable[0].Columns.Count != 6)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备保养项目模板不符合规范,请检查列名字段数";
			return Message;
			}
			else if (excelTable[1].Columns[4].ColumnName != "部位条码（唯一）")
			else if (excelTable[0].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备保养项目模板不符合规范：表头信息不符合规范,第1列应为{序号}";
			return Message;
			}
			else if (excelTable[1].Columns[5].ColumnName != "部位名称")
			else if (excelTable[0].Columns[1].ColumnName != "保养项目编号(唯一)")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备保养项目模板不符合规范：表头信息不符合规范,第2列应为{保养项目编号(唯一)}";
			return Message;
			}
			else if (excelTable[1].Columns[6].ColumnName != "保养要求")
			else if (excelTable[0].Columns[2].ColumnName != "保养项目名称")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备保养项目模板不符合规范：表头信息不符合规范,第3列应为{保养项目名称}";
			return Message;
			}
			else if (excelTable[1].Columns[7].ColumnName != "是否扫码")
			else if (excelTable[0].Columns[3].ColumnName != "是否扫码")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备保养项目模板不符合规范：表头信息不符合规范,第4列应为{是否扫码}";
			return Message;
			}
			else if (excelTable[1].Columns[8].ColumnName != "保养周期")
			else if (excelTable[0].Columns[4].ColumnName != "保养项目要求")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "设备保养项目模板不符合规范：表头信息不符合规范,第4列应为{保养项目要求}";
			return Message;
			}
			else
			{
			@@ -1171,6 +1312,89 @@
			}
			#endregion

			#region【Excel模板上传验证,节拍工价模板】
			public static string TwentyFour(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数";
			return Message;

			}
			else if (excelTable[0].Columns.Count != 9)
			{
			code = "300";
			Message = "节拍工价模板不符合规范,请检查列名字段数";
			return Message;
			}
			else if (excelTable[0].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "节拍工价模板不符合规范：表头信息不符合规范,第1列应为{序号}";
			return Message;
			}
			else if (excelTable[0].Columns[1].ColumnName != "产品名称")
			{
			code = "300";
			Message = "产品名称模板不符合规范：表头信息不符合规范,第2列应为{产品名称}";
			return Message;
			}
			else if (excelTable[0].Columns[2].ColumnName != "工艺路线名称")
			{
			code = "300";
			Message = "节拍工价模板不符合规范：表头信息不符合规范,第3列应为{工艺路线名称}";
			return Message;
			}
			else if (excelTable[0].Columns[3].ColumnName != "工序名称")
			{
			code = "300";
			Message = "节拍工价模板不符合规范：表头信息不符合规范,第4列应为{工序名称}";
			return Message;
			}
			else if (excelTable[0].Columns[4].ColumnName != "设备名称")
			{
			code = "300";
			Message = "节拍工价模板不符合规范：表头信息不符合规范,第4列应为{设备名称}";
			return Message;
			}
			else if (excelTable[0].Columns[5].ColumnName != "计件单价")
			{
			code = "300";
			Message = "节拍工价模板不符合规范：表头信息不符合规范,第4列应为{计件单价}";
			return Message;
			}
			else if (excelTable[0].Columns[6].ColumnName != "设备节拍")
			{
			code = "300";
			Message = "节拍工价模板不符合规范：表头信息不符合规范,第4列应为{设备节拍}";
			return Message;
			}
			else if (excelTable[0].Columns[7].ColumnName != "生产节拍")
			{
			code = "300";
			Message = "节拍工价模板不符合规范：表头信息不符合规范,第4列应为{生产节拍}";
			return Message;
			}
			else if (excelTable[0].Columns[8].ColumnName != "型腔数")
			{
			code = "300";
			Message = "节拍工价模板不符合规范：表头信息不符合规范,第4列应为{型腔数}";
			return Message;
			}
			else
			{
			code = "200";
			Message = "模板检验通过";
			}
			return Message;
			}
			#endregion

			#region【Excel模板上传验证,质检标准模板】
			public static string Seventeen(string FileCode, out string code)
			{
			@@ -1297,73 +1521,39 @@
			if (excelTable.Count != 2)
			{
			code = "300";
			Message = "模板不符合规范,缺失的Sheet";
			Message = "导入模板不符合规范,请检查sheet数";
			return Message;

			}
			else if (excelTable[0].Columns.Count != 4)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名字段数";
			}
			else if (excelTable[1].Columns.Count != 7)
			{
			code = "300";
			Message = "模板不符合规范,请检查列名字段数";
			Message = "缺陷定义模板不符合规范,请检查列名字段数";
			return Message;
			}
			else if (excelTable[0].Columns[0].ColumnName != "序号")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "缺陷定义模板不符合规范：表头信息不符合规范,第1列应为{序号}";
			return Message;
			}
			else if (excelTable[0].Columns[1].ColumnName != "物料编码(唯一)")
			else if (excelTable[0].Columns[1].ColumnName != "缺陷编号(唯一)")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "缺陷定义模板不符合规范：表头信息不符合规范,第2列应为{缺陷编号(唯一)}";
			return Message;
			}
			else if (excelTable[0].Columns[2].ColumnName != "物料名称")
			else if (excelTable[0].Columns[2].ColumnName != "缺陷名称")
			{
			code = "300";
			Message = "模板不符合规范,请检查列名";
			Message = "缺陷定义模板不符合规范：表头信息不符合规范,第3列应为{缺陷名称}";
			return Message;
			}
			else if (excelTable[0].Columns[3].ColumnName != "启用状态")
			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 = "模板不符合规范,请检查列名";
			Message = "缺陷描述模板不符合规范：表头信息不符合规范,第4列应为{缺陷描述}";
			return Message;
			}
			else
			{
			@@ -1692,7 +1882,7 @@
			index++;
			item.Seq = index.ToString();
			}
			StuCode = "300";
			StuCode = "301";
			message = "数据验证失败";
			}
			else
			@@ -1778,7 +1968,7 @@
			index++;
			item.Seq = index.ToString();
			}
			StuCode = "300";
			StuCode = "301";
			message = "数据验证失败";
			}
			else
			@@ -1805,7 +1995,7 @@
			}
			#endregion

			#region【Excel上传数据验证,供方清单】
			#region【Excel上传数据验证,往来单位清单】
			public static List<ExcelErro> FourData(string FileCode, out string StuCode, out string message, out int count)
			{
			message = "";
			@@ -1813,64 +2003,132 @@
			count = 0;
			string sql = "";
			DataTable dt;
			var dynamicParams = new DynamicParameters();
			List<ExcelErro> list = new List<ExcelErro>();
			DataTable excelTable = new DataTable();
			list = ImportExcel.ExcelToTableErro(FileCode); //验证Excel数据必填字段是否为空、唯一字段是否重复
			excelTable = ImportExcel.ExcelToTable(FileCode); //获取Excel数据
			for (int i = 0; i < excelTable.Rows.Count; i++)
			{
			if (excelTable.Rows[i][1].ToString().Trim() != null && excelTable.Rows[i][1].ToString().Trim() != "")
			{
			sql = @"select code from TCustomer where code=@code";

			dynamicParams.Add("@code", excelTable.Rows[i][1].ToString().Trim());
			dt = DapperHelper.selectdata(sql, dynamicParams);
			if (dt.Rows.Count > 0)
			{
			ExcelErro erro = new ExcelErro();
			erro.RoeNumber = "/";
			erro.ErrorField = "{往来单位编码(唯一)}";
			erro.ErrorCont = "往来单位表:{往来单位编码(唯一)}字段" + excelTable.Rows[i][1].ToString().Trim() + "已存在";
			list.Add(erro);
			}
			}
			}
			if (list.Count > 0)
			{
			int index = 0;
			foreach (ExcelErro item in list)
			{
			index++;
			item.Seq = index.ToString();
			}
			StuCode = "301";
			message = "数据验证失败";
			}
			else
			{
			StuCode = "200";
			message = "数据验证成功";
			count = excelTable.Rows.Count;
			}
			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上传数据验证,仓库定义】
			#region【Excel上传数据验证,仓库、库位定义】
			public static List<ExcelErro> SixOneData(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>();

			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>();

			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 T_Sec_Stck where code=@code";
			dynamicParams.Add("@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 T_Sec_Loca where code=@code";
			dynamicParams.Add("@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 = "301";
			message = "数据验证失败";
			}
			else
			{
			StuCode = "200";
			message = "数据验证成功";
			count = excelTable[0].Rows.Count + excelTable[1].Rows.Count;
			}
			return list;
			}
			#endregion
			@@ -1910,17 +2168,187 @@
			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.ExcelToThreeTableListErro(FileCode); //验证Excel数据必填字段是否为空、唯一字段是否重复
			excelTable = ImportExcel.ExcelToThreeTableList(FileCode); //获取Excel数据
			//设备类型表,判断设备类型是否存在
			for (int i = 0; i < excelTable[0].Rows.Count; i++)
			{
			if (excelTable[0].Rows[i][1].ToString().Trim() != null && excelTable[0].Rows[i][1].ToString().Trim() != "")
			{
			sql = @"select * from TEqpType where code=@code";
			dynamicParams.Add("@code", excelTable[0].Rows[i][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[i][1].ToString().Trim() + "已存在";
			list.Add(erro);
			}
			}
			}
			//设备组表,判断设备组是否存在
			for (int j = 0; j < excelTable[1].Rows.Count; j++)
			{
			if (excelTable[1].Rows[j][1].ToString().Trim() != null && excelTable[1].Rows[j][1].ToString().Trim() != "")
			{
			sql = @"select * from TEqpGroup where code=@code";
			dynamicParams.Add("@code", excelTable[1].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[1].Rows[j][1].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);
			}
			//设备清单表
			for (int k = 0; k < excelTable[2].Rows.Count; k++)
			{
			if (excelTable[2].Rows[k][1].ToString().Trim() != null && excelTable[2].Rows[k][1].ToString().Trim() != "")
			{
			sql = @"select * from TEqpInfo where code=@code";
			dynamicParams.Add("@code", excelTable[2].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[2].Rows[k][1].ToString().Trim() + "已存在";
			list.Add(erro);
			}
			//判断设备组是否对应正确的设备类型
			var yourGetData = excelTable[1].AsEnumerable().Where(x => (x.Field<string>("设备类型编号(唯一)") == excelTable[2].Rows[k][3].ToString().Trim()) && x.Field<string>("设备组编号(唯一)") == excelTable[2].Rows[k][4].ToString().Trim()).CopyToDataTable();
			if (yourGetData.Rows.Count <= 0)
			{
			ExcelErro erro = new ExcelErro();
			erro.RoeNumber = "/";
			erro.ErrorField = "{设备类型编号(唯一)}/{设备组编号(唯一)}";
			erro.ErrorCont = "设备表:{设备编号(唯一)}字段" + excelTable[2].Rows[k][1].ToString().Trim() + "对应{设备类型编号(唯一)}:" + excelTable[2].Rows[k][3].ToString().Trim() + "/{设备组编号(唯一)}:" + excelTable[2].Rows[k][4].ToString().Trim() + "与设备组清单中设置对不上";
			list.Add(erro);
			}
			}
			}
			//车间判断
			for (int m = 0; m < excelTable[1].Rows.Count; m++)
			{
			if (excelTable[1].Rows[m][6].ToString().Trim() != null && excelTable[1].Rows[m][6].ToString().Trim() != "")
			{
			sql = @"select * from TOrganization where org_name=@code and description='W'";
			dynamicParams.Add("@code", excelTable[1].Rows[m][6].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[m][6].ToString().Trim() + "不存在";
			list.Add(erro);
			}
			}
			}
			if (list.Count > 0)
			{
			int index = 0;
			foreach (ExcelErro item in list)
			{
			index++;
			item.Seq = index.ToString();
			}
			StuCode = "301";
			message = "数据验证失败";
			}
			else
			{
			StuCode = "200";
			message = "数据验证成功";
			count = excelTable[0].Rows.Count + excelTable[1].Rows.Count;
			}
			return list;
			}
			#endregion

			#region【Excel上传数据验证,设备点检】
			#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;
			var dynamicParams = new DynamicParameters();
			List<ExcelErro> list = new List<ExcelErro>();
			DataTable excelTable = new DataTable();
			list = ImportExcel.ExcelToTableErro(FileCode); //验证Excel数据必填字段是否为空、唯一字段是否重复
			excelTable = ImportExcel.ExcelToTable(FileCode); //获取Excel数据
			for (int i = 0; i < excelTable.Rows.Count; i++)
			{
			if (excelTable.Rows[i][1].ToString().Trim() != null && excelTable.Rows[i][1].ToString().Trim() != "")
			{
			sql = @"select code from TEqpchk_Item where code=@code";

			dynamicParams.Add("@code", excelTable.Rows[i][1].ToString().Trim());
			dt = DapperHelper.selectdata(sql, dynamicParams);
			if (dt.Rows.Count > 0)
			{
			ExcelErro erro = new ExcelErro();
			erro.RoeNumber = "/";
			erro.ErrorField = "{点检项目编号(唯一)}";
			erro.ErrorCont = "设备点检项目表:{点检项目编号(唯一)}字段" + excelTable.Rows[i][1].ToString().Trim() + "已存在";
			list.Add(erro);
			}
			}
			}
			if (list.Count > 0)
			{
			int index = 0;
			foreach (ExcelErro item in list)
			{
			index++;
			item.Seq = index.ToString();
			}
			StuCode = "301";
			message = "数据验证失败";
			}
			else
			{
			StuCode = "200";
			message = "数据验证成功";
			count = excelTable.Rows.Count;
			}
			return list;
			}
			#endregion

			#region【Excel上传数据验证,设备点检标准】
			public static List<ExcelErro> TwentyTwoData(string FileCode, out string StuCode, out string message, out int count)
			{
			message = "";
			StuCode = "";
			count = 0;
			@@ -1932,8 +2360,60 @@
			}
			#endregion

			#region【Excel上传数据验证,设备保养】
			#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;
			var dynamicParams = new DynamicParameters();
			List<ExcelErro> list = new List<ExcelErro>();
			DataTable excelTable = new DataTable();
			list = ImportExcel.ExcelToTableErro(FileCode); //验证Excel数据必填字段是否为空、唯一字段是否重复
			excelTable = ImportExcel.ExcelToTable(FileCode); //获取Excel数据
			for (int i = 0; i < excelTable.Rows.Count; i++)
			{
			if (excelTable.Rows[i][1].ToString().Trim() != null && excelTable.Rows[i][1].ToString().Trim() != "")
			{
			sql = @"select code from TEqpmai_Item where code=@code";

			dynamicParams.Add("@code", excelTable.Rows[i][1].ToString().Trim());
			dt = DapperHelper.selectdata(sql, dynamicParams);
			if (dt.Rows.Count > 0)
			{
			ExcelErro erro = new ExcelErro();
			erro.RoeNumber = "/";
			erro.ErrorField = "{保养项目编号(唯一)}";
			erro.ErrorCont = "设备保养项目表:{点检保养编号(唯一)}字段" + excelTable.Rows[i][1].ToString().Trim() + "已存在";
			list.Add(erro);
			}
			}
			}
			if (list.Count > 0)
			{
			int index = 0;
			foreach (ExcelErro item in list)
			{
			index++;
			item.Seq = index.ToString();
			}
			StuCode = "301";
			message = "数据验证失败";
			}
			else
			{
			StuCode = "200";
			message = "数据验证成功";
			count = excelTable.Rows.Count;
			}
			return list;
			}
			#endregion

			#region【Excel上传数据验证,设备保养标准】
			public static List<ExcelErro> TwentyThreeData(string FileCode, out string StuCode, out string message, out int count)
			{
			message = "";
			StuCode = "";
			@@ -2016,6 +2496,143 @@
			}
			#endregion

			#region【Excel上传数据验证,节拍工价】
			public static List<ExcelErro> TwentyFourData(string FileCode, out string StuCode, out string message, out int count)
			{
			message = "";
			StuCode = "";
			count = 0;
			string sql = "";
			DataTable dt;
			var dynamicParams = new DynamicParameters();
			List<ExcelErro> list = new List<ExcelErro>();
			DataTable excelTable = new DataTable();
			list = ImportExcel.ExcelToTableErro(FileCode); //验证Excel数据必填字段是否为空、唯一字段是否重复
			excelTable = ImportExcel.ExcelToTable(FileCode); //获取Excel数据
			for (int i = 0; i < excelTable.Rows.Count; i++)
			{
			//产品是否存在
			sql = @"select partname from TMateriel_Info
			where partname=@partname";
			dynamicParams.Add("@partname", excelTable.Rows[i][1].ToString().Trim());
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count <= 0)
			{
			ExcelErro erro = new ExcelErro();
			erro.RoeNumber = "/";
			erro.ErrorField = "{产品名称}";
			erro.ErrorCont = "存货档案:{产品名称}字段" + excelTable.Rows[i][1].ToString().Trim() + "不存在";
			list.Add(erro);
			}
			//工艺路线是否存在
			sql = @"select name from TFlw_Rout
			where name=@routename";
			dynamicParams.Add("@routename", excelTable.Rows[i][2].ToString().Trim());
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data0.Rows.Count <= 0)
			{
			ExcelErro erro = new ExcelErro();
			erro.RoeNumber = "/";
			erro.ErrorField = "{工艺路线名称}";
			erro.ErrorCont = "工艺路线:{工艺路线名称}字段" + excelTable.Rows[i][2].ToString().Trim() + "不存在";
			list.Add(erro);
			}
			//工序是否存在
			sql = @"select stepname from TStep
			where stepname=@stepname";
			dynamicParams.Add("@stepname", excelTable.Rows[i][3].ToString().Trim());
			var data1 = DapperHelper.selectdata(sql, dynamicParams);
			if (data1.Rows.Count <= 0)
			{
			ExcelErro erro = new ExcelErro();
			erro.RoeNumber = "/";
			erro.ErrorField = "{工序名称}";
			erro.ErrorCont = "工序定义:{工序名称}字段" + excelTable.Rows[i][3].ToString().Trim() + "不存在";
			list.Add(erro);
			}
			//设备是否存在
			sql = @"select name from TEqpInfo
			where name=@eqpname";
			dynamicParams.Add("@eqpname", excelTable.Rows[i][4].ToString().Trim());
			var data2 = DapperHelper.selectdata(sql, dynamicParams);
			if (data2.Rows.Count <= 0)
			{
			ExcelErro erro = new ExcelErro();
			erro.RoeNumber = "/";
			erro.ErrorField = "{设备名称}";
			erro.ErrorCont = "设备清单:{设备名称}字段" + excelTable.Rows[i][4].ToString().Trim() + "不存在";
			list.Add(erro);
			}
			//判断产品是否关联工艺路线
			sql = @"select M.partname,R.name from TMateriel_Route A
			inner join TMateriel_Info M on A.materiel_code=M.partcode
			inner join TFlw_Rout R on A.route_code=R.code
			where M.partname=@partname and R.name=@routename";
			dynamicParams.Add("@partname", excelTable.Rows[i][1].ToString().Trim());
			dynamicParams.Add("@routename", excelTable.Rows[i][2].ToString().Trim());
			var data3 = DapperHelper.selectdata(sql, dynamicParams);
			if (data3.Rows.Count<=0)
			{
			ExcelErro erro = new ExcelErro();
			erro.RoeNumber = "/";
			erro.ErrorField = "{产品名称/工艺路线名称}";
			erro.ErrorCont = "产品关联工艺路线:{产品名称}字段:【" + excelTable.Rows[i][1].ToString().Trim() + "】对应工艺路线名称：【"+ excelTable.Rows[i][2].ToString().Trim() + "】未关联";
			list.Add(erro);
			}
			//判断工艺路线是否关联工序
			sql = @"select R.name,S.stepname from TFlw_Rtdt A
			inner join TFlw_Rout R on A.rout_code=R.code
			inner join TStep S on A.step_code=S.stepcode
			where R.name=@routename and S.stepname=@stepname";
			dynamicParams.Add("@routename", excelTable.Rows[i][2].ToString().Trim());
			dynamicParams.Add("@stepname", excelTable.Rows[i][3].ToString().Trim());
			var data4 = DapperHelper.selectdata(sql, dynamicParams);
			if (data4.Rows.Count <= 0)
			{
			ExcelErro erro = new ExcelErro();
			erro.RoeNumber = "/";
			erro.ErrorField = "{工艺路线名称/工序名称}";
			erro.ErrorCont = "工艺路线关联工序:{工艺路线名称}字段:【" + excelTable.Rows[i][2].ToString().Trim() + "】对应工序名称：【" + excelTable.Rows[i][3].ToString().Trim() + "】未关联";
			list.Add(erro);
			}
			//判断工序是否关联设备
			sql = @"select E.name,S.stepname from TFlw_Rteqp A
			inner join TStep S on A.step_code=S.stepcode
			inner join TEqpInfo E on A.eqp_code=E.code
			where S.stepname=@stepname and E.name=@eqpname";
			dynamicParams.Add("@stepname", excelTable.Rows[i][3].ToString().Trim());
			dynamicParams.Add("@eqpname", excelTable.Rows[i][4].ToString().Trim());
			var data5 = DapperHelper.selectdata(sql, dynamicParams);
			if (data5.Rows.Count <= 0)
			{
			ExcelErro erro = new ExcelErro();
			erro.RoeNumber = "/";
			erro.ErrorField = "{工序名称/设备名称}";
			erro.ErrorCont = "工序关联设备:{工序名称}字段:【" + excelTable.Rows[i][3].ToString().Trim() + "】对应设备名称：【" + excelTable.Rows[i][4].ToString().Trim() + "】未关联";
			list.Add(erro);
			}
			}
			if (list.Count > 0)
			{
			int index = 0;
			foreach (ExcelErro item in list)
			{
			index++;
			item.Seq = index.ToString();
			}
			StuCode = "301";
			message = "数据验证失败";
			}
			else
			{
			StuCode = "200";
			message = "数据验证成功";
			count = excelTable.Rows.Count;
			}
			return list;
			}
			#endregion

			#region【Excel上传数据验证,质检标准】
			public static List<ExcelErro> SeventeenData(string FileCode, out string StuCode, out string message, out int count)
			{
			@@ -2038,8 +2655,46 @@
			count = 0;
			string sql = "";
			DataTable dt;
			var dynamicParams = new DynamicParameters();
			List<ExcelErro> list = new List<ExcelErro>();
			DataTable excelTable = new DataTable();
			list = ImportExcel.ExcelToTableErro(FileCode); //验证Excel数据必填字段是否为空、唯一字段是否重复
			excelTable = ImportExcel.ExcelToTable(FileCode); //获取Excel数据
			for (int i = 0; i < excelTable.Rows.Count; i++)
			{
			if (excelTable.Rows[i][1].ToString().Trim() != null && excelTable.Rows[i][1].ToString().Trim() != "")
			{
			sql = @"select code from TDefect where code=@code";

			dynamicParams.Add("@code", excelTable.Rows[i][1].ToString().Trim());
			dt = DapperHelper.selectdata(sql, dynamicParams);
			if (dt.Rows.Count > 0)
			{
			ExcelErro erro = new ExcelErro();
			erro.RoeNumber = "/";
			erro.ErrorField = "{缺陷定义编号(唯一)}";
			erro.ErrorCont = "缺陷定义表:{缺陷定义编号(唯一)}字段" + excelTable.Rows[i][1].ToString().Trim() + "已存在";
			list.Add(erro);
			}
			}
			}
			if (list.Count > 0)
			{
			int index = 0;
			foreach (ExcelErro item in list)
			{
			index++;
			item.Seq = index.ToString();
			}
			StuCode = "301";
			message = "数据验证失败";
			}
			else
			{
			StuCode = "200";
			message = "数据验证成功";
			count = excelTable.Rows.Count;
			}
			return list;
			}
			#endregion
			@@ -2180,8 +2835,8 @@
			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)";
			sql = @"insert into TUser(usercode,username,password,enable,mobile,lm_date,email,lm_user,stu_torgcode,wagetype,usergroup_code)
			values(@UserCode,@UserName,@password,@Enable,@Mobile,@CreateDate,@Email,@Operator,@StuOrg,@wagetype,@usergroup_code)";
			list.Add(new
			{
			str = sql,
			@@ -2189,27 +2844,28 @@
			{
			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
			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,
			usergroup_code = excelTable[1].Rows[i][9].ToString().Trim()
			}
			});
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			StuCode = "300";
			message = "导入失败！";
			StuCode = "200";
			message = "导入成功！";
			}
			else
			{
			StuCode = "200";
			message = "导入成功！";
			StuCode = "300";
			message = "导入失败！";
			}
			}
			catch (Exception e)
			@@ -2273,13 +2929,13 @@
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			StuCode = "300";
			message = "导入失败！";
			StuCode = "200";
			message = "导入成功！";
			}
			else
			{
			StuCode = "200";
			message = "导入成功！";
			StuCode = "300";
			message = "导入失败！";
			}
			}
			catch (Exception e)
			@@ -2309,14 +2965,70 @@
			}
			#endregion

			#region【Excel数据上传,供方清单】
			#region【Excel数据上传,往来单位清单】
			public static string FourSubmit(string FileCode, string User, out string StuCode)
			{
			string message = "";
			StuCode = "";
			string sql = "";
			DataTable dt;
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			list.Clear();
			DataTable excelTable = new DataTable();
			excelTable = ImportExcel.ExcelToTable(FileCode);
			//导入往来单位表
			for (int i = 0; i < excelTable.Rows.Count; i++)
			{
			string WGType = "", WXType = "", KHType = "";
			switch (excelTable.Rows[i][3].ToString().Trim())
			{
			case "外购供方":
			WGType = "WG";
			break;
			case "外协供方":
			WXType = "WX";
			break;
			case "客户":
			KHType = "KH";
			break;
			default:
			break;
			}

			sql = @"insert into TCustomer(code,name,mtype,conttacts,conttphone,addr,lm_user,lm_date,btype,htype)
			values(@code,@name,@mtype,@conttacts,@conttphone,@addr,@Operator,@CreateDate,@btype,@htype)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			code = excelTable.Rows[i][1].ToString().Trim(),
			name = excelTable.Rows[i][2].ToString().Trim(),
			mtype = WGType,
			conttacts = excelTable.Rows[i][4].ToString().Trim(),
			conttphone = excelTable.Rows[i][5].ToString().Trim(),
			addr = excelTable.Rows[i][6].ToString().Trim(),
			Operator = User,
			CreateDate = DateTime.Now.ToString(),
			btype = WXType,
			htype = KHType
			}
			});
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			StuCode = "200";
			message = "导入成功！";
			}
			else
			{
			StuCode = "300";
			message = "导入失败！";
			}
			}
			catch (Exception e)
			{
			@@ -2327,68 +3039,67 @@
			}
			#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数据上传,仓库定义】
			#region【Excel数据上传,仓库、库位定义】
			public static string SixOneSubmit(string FileCode, string User, out string StuCode)
			{
			string message = "";
			StuCode = "";
			string sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			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
			{

			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 T_Sec_Stck(code,name,description,lm_user,lm_date)
			values(@code,@name,@description,@Operator,@CreateDate)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			code = excelTable[0].Rows[k][1].ToString().Trim(),
			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++)
			{
			sql = @"insert into T_Sec_Loca(code,name,description,stock_code,lm_user,lm_date)
			values(@code,@name,@description,@stock_code,@Operator,@CreateDate)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			code = excelTable[1].Rows[i][1].ToString().Trim(),
			name = excelTable[1].Rows[i][2].ToString().Trim(),
			stock_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 = "200";
			message = "导入成功！";
			}
			else
			{
			StuCode = "300";
			message = "导入失败！";
			}
			}
			catch (Exception e)
			{
			@@ -2438,11 +3149,95 @@
			#region【Excel数据上传,设备清单】
			public static string NineSubmit(string FileCode, string User, out string StuCode)
			{
			string message = "";
			StuCode = "";
			string message = ""; StuCode = "";
			string sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			list.Clear();
			List<DataTable> excelTable = new List<DataTable>();
			excelTable = ImportExcel.ExcelToThreeTableList(FileCode);
			//写入设备类型
			for (int i = 0; i < excelTable[0].Rows.Count; i++)
			{
			sql = @"insert into TEqpType(code,name,lm_user,lm_date,remark)
			values(@code,@name,@lm_user,@lm_date,@remark)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			code = excelTable[0].Rows[i][1].ToString().Trim(),
			name = excelTable[0].Rows[i][2].ToString().Trim(),
			lm_user = User,
			lm_date = DateTime.Now.ToString(),
			remark = excelTable[0].Rows[i][3].ToString().Trim()

			}
			});
			}
			//写入设备组
			for (int j = 0; j < excelTable[1].Rows.Count; j++)
			{
			sql = @"insert into TEqpGroup(code,name,lm_user,lm_date,remark,eqptype_code)
			values(@code,@name,@lm_user,@lm_date,@remark,@eqptype_code)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			code = excelTable[1].Rows[j][1].ToString().Trim(),
			name = excelTable[1].Rows[j][2].ToString().Trim(),
			lm_user = User,
			lm_date = DateTime.Now.ToString(),
			remark = excelTable[1].Rows[j][4].ToString().Trim(),
			eqptype_code = excelTable[1].Rows[j][3].ToString().Trim()

			}
			});
			}
			//导入设备清单
			for (int k = 0; k < excelTable[2].Rows.Count; k++)
			{
			//获取车间编码
			string sql0 = @"select code,name from TOrganization where org_name=@wkshp and description='W' and is_delete<>'1'";
			dynamicParams.Add("@wkshp", excelTable[2].Rows[k][6].ToString());
			var data = DapperHelper.selectdata(sql0, dynamicParams);

			sql = @"insert into TEqpInfo(code,name,eqptype_code,eqpgroup_code,wksp_code,input_date,operation_ration,enable,opc_uom,lm_user,lm_date)
			values(@devicecode,@devicename,@devicetype,@devicegroup,@workshop,@importdate,@ratio,@status,@uom,@lm_user,@lm_date)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			devicecode = excelTable[2].Rows[k][1].ToString().Trim(),
			devicename = excelTable[0].Rows[k][2].ToString().Trim(),
			devicetype = excelTable[0].Rows[k][3].ToString().Trim(),
			devicegroup = excelTable[0].Rows[k][4].ToString().Trim(),
			workshop = excelTable[0].Rows[k][6].ToString().Trim(),
			importdate = excelTable[0].Rows[k][5].ToString().Trim(),
			ratio = excelTable[0].Rows[k][8].ToString().Trim(),
			status = excelTable[0].Rows[k][7].ToString().Trim(),
			uom = "台",
			lm_user = User,
			lm_date = DateTime.Now.ToString()
			}
			});
			}

			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			StuCode = "200";
			message = "导入成功！";
			}
			else
			{
			StuCode = "300";
			message = "导入失败！";
			}
			}
			catch (Exception e)
			{
			@@ -2453,8 +3248,94 @@
			}
			#endregion

			#region【Excel数据上传,设备点检】
			#region【Excel数据上传,设备点检项目】
			public static string TenSubmit(string FileCode, string User, out string StuCode)
			{
			string message = "";
			StuCode = "";
			string sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			list.Clear();
			DataTable excelTable = new DataTable();
			excelTable = ImportExcel.ExcelToTable(FileCode);
			//导入设备点检项目表
			for (int i = 0; i < excelTable.Rows.Count; i++)
			{
			string Type = "",IsScan="";
			switch (excelTable.Rows[i][3].ToString().Trim())
			{
			case "年":
			Type = "Y";
			break;
			case "季":
			Type = "S";
			break;
			case "月":
			Type = "M";
			break;
			case "周":
			Type = "W";
			break;
			case "日":
			Type = "D";
			break;
			default:
			break;
			}
			switch (excelTable.Rows[i][4].ToString().Trim())
			{
			case "是":
			IsScan = "Y";
			break;
			case "否":
			IsScan = "N";
			break;
			default:
			break;
			}
			sql = @"insert into TEqpchk_Item(code,name,description,isscan,cycle,lm_user,lm_date)
			values(@code,@name,@descr,@Operator,@CreateDate)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			code = excelTable.Rows[i][1].ToString().Trim(),
			name = excelTable.Rows[i][2].ToString().Trim(),
			descr = excelTable.Rows[i][5].ToString().Trim(),
			isscan = IsScan,
			cycle = Type,
			Operator = User,
			CreateDate = DateTime.Now.ToString()
			}
			});
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			StuCode = "200";
			message = "导入成功！";
			}
			else
			{
			StuCode = "300";
			message = "导入失败！";
			}
			}
			catch (Exception e)
			{
			StuCode = "300";
			message = e.Message;
			}
			return message;
			}
			#endregion

			#region【Excel数据上传,设备点检标准】
			public static string TwentyTwoSubmit(string FileCode, string User, out string StuCode)
			{
			string message = "";
			StuCode = "";
			@@ -2471,8 +3352,94 @@
			}
			#endregion

			#region【Excel数据上传,设备保养】
			#region【Excel数据上传,设备保养项目】
			public static string ElevenSubmit(string FileCode, string User, out string StuCode)
			{
			string message = "";
			StuCode = "";
			string sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			list.Clear();
			DataTable excelTable = new DataTable();
			excelTable = ImportExcel.ExcelToTable(FileCode);
			//导入设备点检项目表
			for (int i = 0; i < excelTable.Rows.Count; i++)
			{
			string Type = "", IsScan = "";
			//switch (excelTable.Rows[i][3].ToString().Trim())
			//{
			// case "年":
			// Type = "Y";
			// break;
			// case "季":
			// Type = "S";
			// break;
			// case "月":
			// Type = "M";
			// break;
			// case "周":
			// Type = "W";
			// break;
			// case "日":
			// Type = "D";
			// break;
			// default:
			// break;
			//}
			switch (excelTable.Rows[i][4].ToString().Trim())
			{
			case "是":
			IsScan = "Y";
			break;
			case "否":
			IsScan = "N";
			break;
			default:
			break;
			}
			sql = @"insert into TEqpmai_Item(code,name,description,isscan,cycle,lm_user,lm_date)
			values(@code,@name,@descr,@Operator,@CreateDate)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			code = excelTable.Rows[i][1].ToString().Trim(),
			name = excelTable.Rows[i][2].ToString().Trim(),
			descr = excelTable.Rows[i][5].ToString().Trim(),
			isscan = IsScan,
			cycle = "",
			Operator = User,
			CreateDate = DateTime.Now.ToString()
			}
			});
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			StuCode = "200";
			message = "导入成功！";
			}
			else
			{
			StuCode = "300";
			message = "导入失败！";
			}
			}
			catch (Exception e)
			{
			StuCode = "300";
			message = e.Message;
			}
			return message;
			}
			#endregion

			#region【Excel数据上传,设备保养标准】
			public static string TwentyThreeSubmit(string FileCode, string User, out string StuCode)
			{
			string message = "";
			StuCode = "";
			@@ -2579,6 +3546,168 @@
			}
			#endregion

			#region【Excel数据上传,节拍工价】
			public static string TwentyFourSubmit(string FileCode, string User, out string StuCode)
			{
			string message = "";
			StuCode = "";
			string sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			list.Clear();
			DataTable excelTable = new DataTable();
			excelTable = ImportExcel.ExcelToTable(FileCode);
			//导入设备点检项目表
			for (int i = 0; i < excelTable.Rows.Count; i++)
			{
			string partcode = "", routecode = "",stepcode="",eqpcode="",wkspcode="";
			//查询产品编码
			sql = @"select partcode from TMateriel_Info
			where partname=@partname";
			dynamicParams.Add("@partname", excelTable.Rows[i][1].ToString().Trim());
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			partcode = data.Rows[0]["partcode"].ToString();
			}
			else
			{
			StuCode = "产品名称：【"+ excelTable.Rows[i][1].ToString().Trim() + "】对应编码不存在！";
			message = "导入失败！";
			}
			//查询工艺路线编码
			sql = @"select code from TFlw_Rout
			where name=@routename";
			dynamicParams.Add("@routename", excelTable.Rows[i][2].ToString().Trim());
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data0.Rows.Count > 0)
			{
			routecode = data0.Rows[0]["code"].ToString();
			}
			else
			{
			StuCode = "工艺路线名称：【" + excelTable.Rows[i][2].ToString().Trim() + "】对应编码不存在！";
			message = "导入失败！";
			}
			//查询工序编码
			sql = @"select stepcode from TStep
			where stepname=@stepname";
			dynamicParams.Add("@stepname", excelTable.Rows[i][3].ToString().Trim());
			var data1 = DapperHelper.selectdata(sql, dynamicParams);
			if (data1.Rows.Count > 0)
			{
			stepcode = data1.Rows[0]["stepcode"].ToString();
			}
			else
			{
			StuCode = "工序名称：【" + excelTable.Rows[i][3].ToString().Trim() + "】对应编码不存在！";
			message = "导入失败！";
			}
			//查询设备编码
			sql = @"select code from TEqpInfo
			where name=@eqpname";
			dynamicParams.Add("@eqpname", excelTable.Rows[i][4].ToString().Trim());
			var data4 = DapperHelper.selectdata(sql, dynamicParams);
			if (data4.Rows.Count > 0)
			{
			eqpcode = data4.Rows[0]["code"].ToString();
			}
			else
			{
			StuCode = "设备名称：【" + excelTable.Rows[i][4].ToString().Trim() + "】对应编码不存在！";
			message = "导入失败！";
			}
			//查询车间编码
			sql = @"select wksp_code from TEqpInfo
			where name=@eqpname";
			dynamicParams.Add("@eqpname", excelTable.Rows[i][4].ToString().Trim());
			var data5 = DapperHelper.selectdata(sql, dynamicParams);
			if (data5.Rows.Count > 0)
			{
			wkspcode = data5.Rows[0]["wksp_code"].ToString();
			}
			else
			{
			StuCode = "设备名称：【" + excelTable.Rows[i][4].ToString().Trim() + "】对应车间编码不存在！";
			message = "导入失败！";
			}
			//查询工序节拍表中：产品+工艺路线+工序+设备是否存在
			sql = @"select * from TPrteEqp_Stad
			where materiel_code=@partcode and route_code=@routecode and step_code=@stepcode and eqp_code=@eqpcode";
			dynamicParams.Add("@partcode", partcode);
			dynamicParams.Add("@routecode", routecode);
			dynamicParams.Add("@stepcode", stepcode);
			dynamicParams.Add("@eqpcode", eqpcode);
			var data6 = DapperHelper.selectdata(sql, dynamicParams);
			if (data6.Rows.Count > 0)
			{
			sql = @"update TPrteEqp_Stad set stand_value=@stand_value,eqp_value=@eqp_value,cavity_qty=@cavity_qty,unprice=@unprice,lm_user=@username,lm_date=@userdate
			where materiel_code=@partcode and route_code=@routecode and step_code=@stepcode and eqp_code=@eqpcode ";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			partcode = partcode,
			routecode = routecode,
			stepcode = stepcode,
			eqpcode = eqpcode,
			stand_value = excelTable.Rows[i][7].ToString().Trim(),
			eqp_value = excelTable.Rows[i][6].ToString().Trim(),
			cavity_qty = excelTable.Rows[i][8].ToString().Trim(),
			unprice = excelTable.Rows[i][5].ToString().Trim(),
			username = User,
			userdate = DateTime.Now.ToString()
			}
			});
			}
			else
			{
			sql = @"insert into TPrteEqp_Stad(materiel_code,eqp_code,stand_value,route_code,unprice,eqp_value,cavity_qty,wkspcode,lm_user,lm_date,step_code)
			values(@partcode,@eqpcode,@stand_value,@routecode,@unprice,@eqp_value,@cavity_qty,@wkspcode,@username,@userdate,@stepcode)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			partcode = partcode,
			eqpcode = eqpcode,
			stand_value = excelTable.Rows[i][7].ToString().Trim(),
			routecode = routecode,
			unprice = excelTable.Rows[i][5].ToString().Trim(),
			eqp_value = excelTable.Rows[i][6].ToString().Trim(),
			cavity_qty = excelTable.Rows[i][8].ToString().Trim(),
			wkspcode = wkspcode,
			username = User,
			userdate = DateTime.Now.ToString(),
			stepcode = stepcode
			}
			});
			}
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			StuCode = "200";
			message = "导入成功！";
			}
			else
			{
			StuCode = "300";
			message = "导入失败！";
			}
			}
			catch (Exception e)
			{
			StuCode = "300";
			message = e.Message;
			}
			return message;
			}
			#endregion

			#region【Excel数据上传,质检标准】
			public static string SeventeenSubmit(string FileCode, string User, out string StuCode)
			{
			@@ -2602,9 +3731,44 @@
			{
			string message = "";
			StuCode = "";
			string sql = "";
			DataTable dt;
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{

			list.Clear();
			DataTable excelTable = new DataTable();
			excelTable = ImportExcel.ExcelToTable(FileCode);
			//导入往来单位表
			for (int i = 0; i < excelTable.Rows.Count; i++)
			{
			sql = @"insert into TDefect(code,name,descr,lm_user,lm_date)
			values(@code,@name,@descr,@Operator,@CreateDate)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			code = excelTable.Rows[i][1].ToString().Trim(),
			name = excelTable.Rows[i][2].ToString().Trim(),
			descr = excelTable.Rows[i][3].ToString().Trim(),
			Operator = User,
			CreateDate = DateTime.Now.ToString()
			}
			});
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			StuCode = "200";
			message = "导入成功！";
			}
			else
			{
			StuCode = "300";
			message = "导入失败！";
			}
			}
			catch (Exception e)
			{