From 16a061f9c284c607a0470f5c37a03652796c61d0 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期五, 25 四月 2025 14:17:37 +0800
Subject: [PATCH] 从金蝶云同步物料信息、生产订单到小诸葛
---
WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs | 20 ++++++++++++++++----
1 files changed, 16 insertions(+), 4 deletions(-)
diff --git a/WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs b/WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs
index 7432842..386af06 100644
--- a/WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs
+++ b/WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs
@@ -646,10 +646,22 @@
}
string sql= $@"update Cg_POInStockBillMain set " +
- "HRemark='" + HRemark + "', HUpDater ='" + HMaker + "', HUpDateDate=getdate()"+ ",HBillNo='" + HBillNo + "'" +
- ",HSupID=" + HSupID + ",HCurID=" + HCurID
- + ",HExRate=" + HExRate + ",HEmpID=" + HEmpID + ",HManagerID=" + HManagerID + ",HDeptID=" + HDeptID
- + ",HAddress='" + HAddress + "',HInnerBillNo='" + HInnerBillNo + "',HProjectID="+ HProjectID + ",HInvoiceBillNo='"+ HInvoiceBillNo + "' where HInterID=" + HInterID;
+ "HRemark='" + HRemark + "'" +
+ ", HUpDater ='" + HMaker + "'" +
+ ", HUpDateDate=getdate()"+ "" +
+ ",HBillNo='" + HBillNo + "'" +
+ ",HWHID=" + HWHID + "" +
+ ",HSupID=" + HSupID + "" +
+ ",HCurID=" + HCurID + "" +
+ ",HExRate=" + HExRate + "" +
+ ",HEmpID=" + HEmpID + "" +
+ ",HManagerID=" + HManagerID + "" +
+ ",HDeptID=" + HDeptID + "" +
+ ",HAddress='" + HAddress + "'" +
+ ",HInnerBillNo='" + HInnerBillNo + "'" +
+ ",HProjectID="+ HProjectID + "" +
+ ",HInvoiceBillNo='"+ HInvoiceBillNo + "' " +
+ " where HInterID=" + HInterID;
oCN.RunProc(sql);
--
Gitblit v1.9.1