From b5259578bcc4bc648d281ba0d5468ab408e3f675 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期五, 10 十一月 2023 12:18:25 +0800
Subject: [PATCH] 销售订单：根据客户获取对应的客户信用额度
---
WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs
index 5e4b100..8f2d331 100644
--- a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs
+++ b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs
@@ -1797,9 +1797,11 @@
,cur.HName HCurName
,cur.HExchangeRate HExRate
,c.HTaxRate
+ ,ISNULL(cre.HCreditRating_Now,0) HCreditRating_Now
from Gy_Customer as c
left join Gy_SettleStyle as s on c.HSSID = s.HItemID
left join Gy_Currency as cur on c.HCurID = cur.HItemID
+ left join Gy_Customer_Credit as cre on c.HItemID = cre.HCusID
where c.HItemID = " + HCusID;
ds = oCN.RunProcReturn(sql,"Gy_Customer");
--
Gitblit v1.9.1