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