From 9961e1ce8da272d09967c9db6eda5f8d33958b1d Mon Sep 17 00:00:00 2001
From: yxj <yxj@hz-kingdee.com>
Date: 星期四, 23 十月 2025 10:51:17 +0800
Subject: [PATCH] 直接调拨单上传调用方法修改，增加客户为小卫时，HSupID字段取值特殊处理
---
WebAPI/DLL/ClsKf_MateOutBill.cs | 14 ++++++++------
1 files changed, 8 insertions(+), 6 deletions(-)
diff --git a/WebAPI/DLL/ClsKf_MateOutBill.cs b/WebAPI/DLL/ClsKf_MateOutBill.cs
index 85dffab..7f65745 100644
--- a/WebAPI/DLL/ClsKf_MateOutBill.cs
+++ b/WebAPI/DLL/ClsKf_MateOutBill.cs
@@ -110,7 +110,8 @@
",HMaterEmpID=" + omodel.HMaterEmpID +
",HMachineSpeed=" + omodel.HMachineSpeed +
",HWaterRush=" + omodel.HWaterRush +
- ",HWaterQty=" + omodel.HWaterQty +
+ ",HHuaGun='" + omodel.HHuaGun +
+ "',HWaterQty=" + omodel.HWaterQty +
",HWaterRate=" + omodel.HWaterRate +
" where HInterID=" + lngBillKey.ToString();
}
@@ -238,7 +239,7 @@
",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" +
",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" +
") " +
- " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
+ " values('" + this.BillType + "','" + omodel.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" +
", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() +
", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) +
@@ -254,10 +255,10 @@
mainSql = "Insert Into Kf_ICStockBillMain" +
"(HBillType,HBillSubType,HInterID,HBillNo,HDate,HYear,HPeriod,HRemark,HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HMaker,HMakeDate,HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID,HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" +
",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo,HMaterID,HMaterName,HVerNo,HModel,HModel2,HPieceQty,HCusID,HWeight,HLong,HSingleWeight,HMaterSumWeight,HMaterEmpID" +
- ",HMachineSpeed,HWaterRush,HWaterQty,HWaterRate) " +
+ ",HMachineSpeed,HWaterRush,HHuaGun,HWaterQty,HWaterRate) " +
" values(" +
"'" + this.BillType +
- "','" + this.HBillSubType +
+ "','" + omodel.HBillSubType +
"'," + omodel.HInterID.ToString() +
",'" + omodel.HBillNo +
"','" + omodel.HDate +
@@ -266,7 +267,7 @@
",'" + omodel.HRemark +
"'," + omodel.HProcExchInterID +
",'" + omodel.HProcExchBillNo +
- "','" + "3772" +
+ "','" + (string.IsNullOrEmpty(omodel.HMainSourceBillType) == true ? "3772" : omodel.HMainSourceBillType) +
"','" + DBUtility.ClsPub.CurUserName +
"',getdate()" +
"," + omodel.HSupID.ToString() +
@@ -300,7 +301,8 @@
"," + omodel.HMaterEmpID +
"," + omodel.HMachineSpeed +
"," + omodel.HWaterRush +
- "," + omodel.HWaterQty +
+ ",'" + omodel.HHuaGun +
+ "'," + omodel.HWaterQty +
"," + omodel.HWaterRate +
")";
}
--
Gitblit v1.9.1