From c9bed37a4a8186b71564c9fc8c77934c5839f912 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期三, 01 二月 2023 13:33:07 +0800
Subject: [PATCH] 111
---
WebAPI/Controllers/POInStockController.cs | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/WebAPI/Controllers/POInStockController.cs b/WebAPI/Controllers/POInStockController.cs
index f6dce2b..331ff54 100644
--- a/WebAPI/Controllers/POInStockController.cs
+++ b/WebAPI/Controllers/POInStockController.cs
@@ -1193,7 +1193,7 @@
oCn.RunProc($"exec h_p_SRM_UpDatePPBomRelationQty {HinterID}");
}
//鍒ゆ柇鏈叧鑱旀暟閲忔槸鍚︿负0
- DataSet ds = oCn.RunProcReturn($"select hqty-hrelationqty as hqty from Cg_POOrderBillSub where hentryid in ({string.Join(", ", entryList)}) ", "H_v_SRM_POOrderBillList");
+ DataSet ds = oCn.RunProcReturn($"select T1.hqty-T1.hrelationqty as hqty,鍗曟嵁鍙�,鐗╂枡缂栫爜 from H_v_SRM_POOrderBillList t1 where hentryid in ({string.Join(", ", entryList)}) ", "H_v_SRM_POOrderBillList");
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
@@ -1202,7 +1202,7 @@
{
objJsonResult.code = "0";
objJsonResult.count = 0;
- objJsonResult.Message = $"璇锋鏌ユ暟鎹紝鍗曟嵁鍙凤細{dr[0]["鍗曟嵁鍙�"]},鐗╂枡浠ｇ爜锛歿dr[0]["鐗╂枡浠ｇ爜"]},鏈彂璐ф暟閲忎负0锛屽凡鍏ㄩ儴鐢熸垚閫佽揣鍗曪紒";
+ objJsonResult.Message = $"璇锋鏌ユ暟鎹紝鍗曟嵁鍙凤細{dr[0]["鍗曟嵁鍙�"]},鐗╂枡缂栫爜锛歿dr[0]["鐗╂枡缂栫爜"]},鍙互鍙戣揣鏁伴噺涓�0锛屽凡鍏ㄩ儴鐢熸垚閫佽揣鍗曪紒";
objJsonResult.data = null;
return objJsonResult;
}
--
Gitblit v1.9.1