From c1aaabe64ffc526f24826a063209ba9037bffd72 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期三, 30 十一月 2022 15:55:15 +0800
Subject: [PATCH] 销售订单
---
WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs | 11 +++++++----
1 files changed, 7 insertions(+), 4 deletions(-)
diff --git a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs
index dfbd03d..23afaab 100644
--- a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs
+++ b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs
@@ -263,12 +263,13 @@
,HEmpID,HCusID
,HBillSubType,HAddress,HSSDate,HSSID,HSellSID,HCurID,HExRate, HManagerID,HDeptID
,HExplanation,HCheckFlow,HBillStatus,HInnerBillNo
- ,HICMOFlag,HChangeMan,HSALEORGID,HERPInterID,HERPBillType)
+ ,HICMOFlag,HChangeMan,HSALEORGID,HERPInterID,HERPBillType
+ ,HCloseDate,HCloseMan)
values(" + "1401," + HInterID + ",'" + HBillNo + "','" + HDate + "','" +
DateTime.Now.Year + "','" + DateTime.Now.Month + "','" + HRemark + "','" + HMaker + "','" + HMakeDate +
"'," + HEmpID + "," + HCusID + ",'" + HBillType + "','" + HAddress + "','" + HSSDate +
"'," + HSSID + "," + HSellSID + "," + HCurID + "," + HExRate + "," + HManagerID + "," + HDeptID + ",'" + "''" + "'," + "0," + HBillStatus + ",'" + "''" + "'," +
- 0 + ",'" + "''" + "'," + "0," + HERPInterID + ",'" + HERPBillType + "')");
+ 0 + ",'" + "''" + "'," + HSALEORGID + "," + HERPInterID + ",'" + HERPBillType + "','" + HCloseDate + "','" + HCloseMan + "')");
}
else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0)
{ //淇敼
@@ -383,9 +384,11 @@
(HInterID,HENTRYID,HQty,HMaterID,HUnitID,HRemark
,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType
,HRelationQty,HRelationMoney,HPrice,HTaxPrice,HMoney,HDiscountRate
- ,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty)
+ ,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty
+ ,HPropertyID,HBatChNo,HAuxPropID,HMTONo,HERPInterID,HERPEntryID,HBackRelationQty,HWhID,HSPID)
values({HInterID},{NewHEntryID},{(oSub.HQty == null ? 0 : oSub.HQty)}
- ,{oSub.HMaterID},{oSub.HUnitID},'{oSub.HRemark}',{HSourceInterID},{HSourceEntryID},{HSourceBillNo},{HSourceBillType},{HRelationQty},0,{oSub.HPrice},{oSub.HTaxPrice},{oSub.HMoney},{oSub.HDiscountRate},{oSub.HRelTaxPrice},{oSub.HTaxRate},{oSub.HTaxMoney},{oSub.HlineTotal},{oSub.HlineTotalBB},getdate(),0,0)");
+ ,{oSub.HMaterID},{oSub.HUnitID},'{oSub.HRemark}',{HSourceInterID},{HSourceEntryID},{HSourceBillNo},{HSourceBillType},{HRelationQty},0,{oSub.HPrice},{oSub.HTaxPrice},{oSub.HMoney},{oSub.HDiscountRate},{oSub.HRelTaxPrice},{oSub.HTaxRate},{oSub.HTaxMoney},{oSub.HlineTotal},{oSub.HlineTotalBB},getdate(),{oSub.HOutStockQty},{oSub.HInvoiceQty},{HPropertyID},{HBatChNo},{HAuxPropID},
+ {HMTONo},{HERPInterID},{HERPEntryID},{HBackRelationQty},{HWhID},{HSPID})");
}
objJsonResult.code = "1";
--
Gitblit v1.9.1