From 00d2dab9f1367067b27906be93a43949beb43aa7 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期一, 18 九月 2023 15:42:14 +0800
Subject: [PATCH] 1
---
DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs b/DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs
index 3ebb340..af0bcce 100644
--- a/DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs
+++ b/DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs
@@ -110,9 +110,10 @@
{
//若MAINDI重复则重新获取
oCn.BeginTran();
- string sql = "Insert into Sc_ICMOBillQualityStatus_Tmp(HBarCode,HInterID,HBillNo,HCheckManID,HBadReasonID,HWasterReasonID,HResult,HAddr," +
+ string sql = "Insert into Sc_ICMOBillQualityStatus_Tmp"+
+ "(HBarCode,HInterID,HBillNo,HCheckManID,HBadReasonID,HWasterReasonID,HResult,HAddr," +
"HRemark,HSaveType,HICMOInterID,HICMOEntryID,HICMOBillNo,HSplitNo,HMaterID,HProcID,HSourceID,HDate,HGroupID,HDeptID,HStationID," +
- "HPRDORGID,HAuxPropID,HBillType,HReportType,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationInterID," +
+ "HPRDORGID,HAuxPropID,HBillType,HBillSubType,HReportType,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationInterID," +
"HRelationEntryID,HRelationBillNo,HMaker,HMakeDate)" +
"values(" +
"'" + omodel.HBarCode +
@@ -139,6 +140,7 @@
"," + omodel.HPRDORGID +
"," + omodel.HAuxPropID +
",'" + BillType +
+ "','" + "" +
"'," + omodel.HReportType +
"," + omodel.HSourceInterID +
"," + omodel.HSourceEntryID +
--
Gitblit v1.9.1