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/仓存管理/领料发货/Kf_MateOutBillController.cs | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_MateOutBillController.cs" "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_MateOutBillController.cs" index 9d51f56..09d363f 100644 --- "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_MateOutBillController.cs" +++ "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_MateOutBillController.cs" @@ -705,7 +705,7 @@ { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); - string sql = "select a.HItemID HMaterID,a.HNumber HMaterNumber,a.HName HMaterName,a.HMaterRuleType,a.HModel HMaterModel,a.HUnitID, b.HNumber HUnitNumber, b.HName HUnitName" + + string sql = "select a.HItemID HMaterID,a.HNumber HMaterNumber,a.HName HMaterName,a.HMaterRuleType,a.HModel HMaterModel,a.HUnitID, b.HNumber HUnitNumber, b.HName HUnitName, a.HMaterRuleExternType" + " from Gy_Material AS a " + " LEFT OUTER JOIN Gy_Unit AS b on a.HUnitID = b.HItemID " + " where a.HItemID =" + HMaterID; -- Gitblit v1.9.1