From 385da37de94758dfe8befb0635307409869ec68a Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 08 四月 2025 11:06:07 +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