From eaeff1134f0e4e35ba050d0809500d05ee869cc8 Mon Sep 17 00:00:00 2001
From: wangyi <2946747746@qq.com>
Date: 星期一, 30 三月 2026 18:33:07 +0800
Subject: [PATCH] 出运单修改
---
DAL/ClsWL_YayBillMain.cs | 22 +++++++++++-----------
1 files changed, 11 insertions(+), 11 deletions(-)
diff --git a/DAL/ClsWL_YayBillMain.cs b/DAL/ClsWL_YayBillMain.cs
index 5a7a9f1..6214bad 100644
--- a/DAL/ClsWL_YayBillMain.cs
+++ b/DAL/ClsWL_YayBillMain.cs
@@ -92,11 +92,8 @@
",HMainSourceInterID='" + omodel.HMainSourceInterID.ToString() + "'" +
",HMainSourceEntryID='" + omodel.HMainSourceEntryID.ToString() + "'" +
- ",HCusID='" + omodel.HCusID.ToString() + "'" +
",HBeginAddr='" + omodel.HBeginAddr.ToString() + "'" +
",HEndAddr='" + omodel.HEndAddr.ToString() + "'" +
- ",HPickAddr='" + omodel.HPickAddr.ToString() + "'" +
- ",HArriverAddr='" + omodel.HArriverAddr.ToString() + "'" +
",HTransType='" + omodel.HTransType.ToString() + "'" +
",HCarTypeID='" + omodel.HCarTypeID.ToString() + "'" +
",HCarTypeMaxVolume='" + omodel.HCarTypeMaxVolume.ToString() + "'" +
@@ -145,7 +142,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,HScatteredVolume,HMouldQty) values("
+ ",HMouldFoldHeight,HVolume,HQty,HSNP,HScatteredVolume,HMouldQtym,,HCusID,HPickAddr,HArriverAddr) values("
+ SafeInt(omodel.HInterID.ToString(), 0) + ",'" // HInterID int
+ SafeString(omodel.HBillNo.ToString()) + "'," // HBillNo_bak varchar(50)
+ (oSub.HEntryID) + ",'" // HEntryID int
@@ -170,7 +167,10 @@
+ (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)
+ + (oSub.HMouldQty.ToString() == "" ? 0 : oSub.HMouldQty) + ","
+ + (oSub.HCusID) + "," // HSNP dec(18,8)
+ + "'" + SafeString(oSub.HPickAddr?.ToString(), "") + "',"
+ + "'" + SafeString(oSub.HArriverAddr?.ToString(), "") + "')"; // HMouldQty dec(18,8)
oCn.RunProc(sql);
}
@@ -236,7 +236,7 @@
string sql = "Insert Into WL_YayBillMain " +
"(HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate,HBillNo,HBillStatus," +
"HRemark,HMaker,HMakeDate,HMainSourceBillType,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo," +
- "HOrgID,HCusID,HBeginAddr,HEndAddr,HPickAddr,HArriverAddr,HTransType,HCarTypeID,HCarTypeMaxVolume,HTotalVolume," +
+ "HOrgID,HBeginAddr,HEndAddr,HTransType,HCarTypeID,HCarTypeMaxVolume,HTotalVolume," +
"HLoadingRate,HContractTransportInterID,HContractTransportEntryID," +
"HContractTransportBillNo,HCarrierID,HDistance,HTransportTimes," +
"HTransportTyep,HSSID,HCurID,HMoney,HDateForRequestedPick," +
@@ -258,11 +258,8 @@
",'" + omodel.HMainSourceEntryID + "'" +
",'" + omodel.HMainSourceBillNo + "'" +
",'" + omodel.HOrgID + "'" +
- ",'" + omodel.HCusID + "'" +
",'" + omodel.HBeginAddr + "'" +
",'" + omodel.HEndAddr + "'" +
- ",'" + omodel.HPickAddr + "'" +
- ",'" + omodel.HArriverAddr + "'" +
",'" + omodel.HTransType + "'" +
",'" + omodel.HCarTypeID + "'" +
",'" + omodel.HCarTypeMaxVolume + "'" +
@@ -292,7 +289,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,HScatteredVolume,HMouldQty) values("
+ ",HMouldFoldHeight,HVolume,HQty,HSNP,HScatteredVolume,HMouldQty,HCusID,HPickAddr,HArriverAddr) values("
+ SafeInt(omodel.HInterID.ToString(), 0) + ",'" // HInterID int
+ SafeString(omodel.HBillNo.ToString()) + "'," // HBillNo_bak varchar(50)
+ (oSub.HEntryID) + ",'" // HEntryID int
@@ -317,7 +314,10 @@
+ (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)
+ + (oSub.HMouldQty.ToString() == "" ? 0 : oSub.HMouldQty) + ","
+ + (oSub.HCusID) + "," // HSNP dec(18,8)
+ + "'" + SafeString(oSub.HPickAddr?.ToString(), "") + "',"
+ + "'" + SafeString(oSub.HArriverAddr?.ToString(), "") + "')"; // HMouldQty dec(18,8)
oCn.RunProc(sql);
}
//=========================淇濆瓨鍚庢帶鍒�
--
Gitblit v1.9.1