From 87af5a2fe700262234b2f660db6c26ba49d1bcf7 Mon Sep 17 00:00:00 2001
From: chenhaozhe <cgz@hz-kingdee.com>
Date: 星期二, 19 八月 2025 16:03:15 +0800
Subject: [PATCH] ClsGy_Material_Model 添加 HMaterRuleExternType 字段 Kf_MateOutBill/getMaterialByMaterID 查询语句添加 HMaterRuleExternType 返回值 ClsGy_Material_Ctl 插入语句/更新语句 添加 HMaterRuleExternType 字段

---
 WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs |   47 +++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 47 insertions(+), 0 deletions(-)

diff --git a/WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs b/WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs
index aec4b11..498150e 100644
--- a/WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs
+++ b/WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs
@@ -2033,6 +2033,53 @@
         }
         #endregion
 
+        #region 閿�鍞嚭搴撳崟 浠锋牸鏌ヨ
+        [Route("Kf_SellOutBill/GetKf_CheckSellOutBill_BalanceQuery")]
+        [HttpGet]
+        public object GetKf_CheckSellOutBill_BalanceQuery(string HInterID, string user)
+        {
+            try
+            {
+                //鍒ゆ柇鏌ヨ鏉冮檺
+                if (!DBUtility.ClsPub.Security_Log("Kf_SellOutBill_Money", 1, false, user))
+                {
+                    objJsonResult.code = "0";
+                    objJsonResult.count = 0;
+                    objJsonResult.Message = "鏃犳潈闄愭煡璇�!";
+                    objJsonResult.data = null;
+                    return objJsonResult;
+                }
+
+                DataSet ds2 = oCN.RunProcReturn("exec h_p_Kf_CheckSellOutBill_BalanceQuery " + HInterID, "h_p_Kf_CheckSellOutBill_BalanceQuery");
+
+                if ((int)ds2.Tables[0].Rows[0]["HBack"] == 1)
+                {
+                    objJsonResult.code = "0";
+                    objJsonResult.count = 0;
+                    objJsonResult.Message = ds2.Tables[0].Rows[0]["HRemark"].ToString();
+                    objJsonResult.data = null;
+                    return objJsonResult;
+                }
+                else
+                {
+                    objJsonResult.code = "1";
+                    objJsonResult.count = 1;
+                    objJsonResult.Message = "Sucess锛�";
+                    objJsonResult.data = ds2.Tables[1];
+                    return objJsonResult;
+                }
+            }
+            catch (Exception e)
+            {
+                objJsonResult.code = "0";
+                objJsonResult.count = 0;
+                objJsonResult.Message = "Exception锛�" + e.ToString();
+                objJsonResult.data = null;
+                return objJsonResult;
+            }
+        }
+        #endregion
+
         #region 鏍峰搧閿�鍞嚭搴� 瀹℃牳/鍙嶅鏍�
         /// <summary>
         /// </summary>

--
Gitblit v1.9.1