From c586783fd62d94259f5b7c6984d6912c89bcf659 Mon Sep 17 00:00:00 2001
From: yxj <1qaz@123>
Date: 星期一, 26 九月 2022 20:15:22 +0800
Subject: [PATCH] 森楷其他入库扫描物料条码写入临时表，源单信息存入数据修改
---
CLOUDWEB/WebService1.asmx.cs | 6 +++++-
1 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/CLOUDWEB/WebService1.asmx.cs b/CLOUDWEB/WebService1.asmx.cs
index cebbb74..06c7630 100644
--- a/CLOUDWEB/WebService1.asmx.cs
+++ b/CLOUDWEB/WebService1.asmx.cs
@@ -38686,7 +38686,11 @@
" select " + model.HInterID.ToString() + ",'" + model.HBillNo + "','" + model.HBillType + "',HMaterID,HAuxPropID," + model.HProcID.ToString() +
"," + model.HWhID.ToString() + "," + model.HSCWHID.ToString() + "," + model.HStockPlaceID.ToString() + "," + model.HOutStockPlaceID.ToString() + "," + model.HGroupID.ToString() + ",'" + model.HAddr + "'" +
"," + model.HQtyMust.ToString() + ",HQty," + model.HPieceQty.ToString() + ",HBatchNo,HBarCode,''" +
- ",'" + model.HMaker + "',getdate()," + model.HSourceInterID.ToString() + "," + model.HSourceEntryID.ToString() + ",'" + model.HSourceBillType + "','" + model.HSourceBillNo + "'" +
+ ",'" + model.HMaker + "',getdate()" +
+ ",case when '" + model.HBillType + "'='1203' then HSourceInterID else " + model.HSourceInterID.ToString() + " end" +
+ ",case when '" + model.HBillType + "'='1203' then HSourceEntryID else " + model.HSourceEntryID.ToString() + " end" +
+ ",case when '" + model.HBillType + "'='1203' then HSourceBillType else '" + model.HSourceBillType + "' end" +
+ ",case when '" + model.HBillType + "'='1203' then HSourceBillNo else '" + model.HSourceBillNo + "' end" +
"," + model.HRelationInterID.ToString() + "," + model.HRelationEntryID.ToString() + ",'" + model.HRelationBillNo + "'," + Convert.ToString(model.HRedBlueFlag ? 1 : 0) + ",'" + model.HMTONo + "',0" +
"," + model.HSTOCKORGID.ToString() + "," + model.HOWNERID.ToString() + "," + model.HSTOCKORGID.ToString() + ",'','','" + model.HSubBillType + "'" +
",0,0,'" + model.HCusBarCode + "'," + model.HMulSourceBill.ToString() +
--
Gitblit v1.9.1