From 82e5ca26ff07346e93e704852bfe7e80f8ba0f84 Mon Sep 17 00:00:00 2001
From: chenhaozhe <cgz@hz-kingdee.com>
Date: 星期五, 27 二月 2026 16:23:34 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
---
DAL/ClsWL_YayBillMain.cs | 10 +++++++---
1 files changed, 7 insertions(+), 3 deletions(-)
diff --git a/DAL/ClsWL_YayBillMain.cs b/DAL/ClsWL_YayBillMain.cs
index bf3cd02..d45d241 100644
--- a/DAL/ClsWL_YayBillMain.cs
+++ b/DAL/ClsWL_YayBillMain.cs
@@ -126,6 +126,7 @@
",HSurer_Trans='" + omodel.HSurer_Trans.ToString() + "'" +
",HDate_Trans='" + omodel.HDate_Trans.ToString() + "'" +
",HSurer_Receive='" + omodel.HSurer_Receive.ToString() + "'" +
+ ",HExRate='" + omodel.HExRate.ToString() + "'" +
",HDate_Receive='" + omodel.HDate_Receive.ToString() + "'" +
",HSurer_Accounting='" + omodel.HSurer_Accounting.ToString() + "'" +
",HDate_Accounting='" + omodel.HDate_Accounting.ToString() + "'" +
@@ -144,7 +145,7 @@
"(HInterID,HBillNo_bak,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
",HMaterID,HUnitID,HMouldID,HMouldLength,HMouldHeight,HMouldWidth" +
- ",HMouldFoldHeight,HVolume,HQty,HSNP,HMouldQty) values("
+ ",HMouldFoldHeight,HVolume,HQty,HSNP,HScatteredVolume,HMouldQty) values("
+ SafeInt(omodel.HInterID.ToString(), 0) + ",'" // HInterID int
+ SafeString(omodel.HBillNo.ToString()) + "'," // HBillNo_bak varchar(50)
+ (oSub.HEntryID) + ",'" // HEntryID int
@@ -168,6 +169,7 @@
+ (oSub.HVolume.ToString() == "" ? 0 : oSub.HVolume) + "," // HVolume dec(18,8)
+ (oSub.HQty.ToString() == "" ? 0 : oSub.HQty) + "," // HQty dec(18,8)
+ (oSub.HSNP.ToString() == "" ? 0 : oSub.HSNP) + "," // HSNP dec(18,8)
+ + (oSub.HScatteredVolume) + "," // HSNP dec(18,8)
+ (oSub.HMouldQty.ToString() == "" ? 0 : oSub.HMouldQty) + ")"; // HMouldQty dec(18,8)
oCn.RunProc(sql);
}
@@ -245,7 +247,7 @@
"HTransportTyep,HSSID,HCurID,HMoney,HDateForRequestedPick," +
"HDataForRequestedArrived,HCarryStatus,HDate_CarrierSure," +
"HDate_AllocationDriver,HCarID,HDriverID,HSurer_Arrive,HDate_Arrive," +
- "HSurer_Pick,HDate_Pick,HSurer_Trans,HDate_Trans,HSurer_Receive," +
+ "HSurer_Pick,HDate_Pick,HSurer_Trans,HDate_Trans,HSurer_Receive,HExRate," +
"HDate_Receive,HSurer_Accounting,HDate_Accounting) " +
"values(" +
SafeInt(omodel.HInterID.ToString(), 0) + "," + // HInterID
@@ -312,6 +314,7 @@
"'" + SafeString(omodel.HSurer_Trans) + "'," +
SafeDateTime(omodel.HDate_Trans?.ToString(), "'" + currentDateTime + "'") + "," +
"'" + SafeString(omodel.HSurer_Receive) + "'," +
+ "'" + omodel.HExRate + "'," +
SafeDateTime(omodel.HDate_Receive?.ToString(), "'" + currentDateTime + "'") + "," +
"'" + SafeString(omodel.HSurer_Accounting) + "'," +
SafeDateTime(omodel.HDate_Accounting?.ToString(), "'" + currentDateTime + "'") + ")";
@@ -326,7 +329,7 @@
"(HInterID,HBillNo_bak,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
",HMaterID,HUnitID,HMouldID,HMouldLength,HMouldHeight,HMouldWidth" +
- ",HMouldFoldHeight,HVolume,HQty,HSNP,HMouldQty) values("
+ ",HMouldFoldHeight,HVolume,HQty,HSNP,HScatteredVolume,HMouldQty) values("
+ SafeInt(omodel.HInterID.ToString(), 0) + ",'" // HInterID int
+ SafeString(omodel.HBillNo.ToString()) + "'," // HBillNo_bak varchar(50)
+ (oSub.HEntryID) + ",'" // HEntryID int
@@ -350,6 +353,7 @@
+ (oSub.HVolume.ToString() == "" ? 0 : oSub.HVolume) + "," // HVolume dec(18,8)
+ (oSub.HQty.ToString() == "" ? 0 : oSub.HQty) + "," // HQty dec(18,8)
+ (oSub.HSNP.ToString() == "" ? 0 : oSub.HSNP) + "," // HSNP dec(18,8)
+ + (oSub.HScatteredVolume) + "," // HSNP dec(18,8)
+ (oSub.HMouldQty.ToString() == "" ? 0 : oSub.HMouldQty) + ")"; // HMouldQty dec(18,8)
oCn.RunProc(sql);
}
--
Gitblit v1.9.1