From 5339020eae4f4ed4938302a902087a0693743898 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期三, 22 五月 2024 11:28:00 +0800 Subject: [PATCH] 器具模块功能完善(器具档案、器具分类、器具保养项目,器具保养规程、器具保养计划、器具保养记录 器具维修项目、器具故障登记、器具维修记录单、器具维修验收单 器具寿命调整单、器具寿命耗用单 产品器具清单) --- WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs | 7 ++++--- 1 files changed, 4 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs index 5b456da..6c2ae4d 100644 --- a/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs +++ b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs @@ -110,9 +110,10 @@ return objJsonResult; } DLL.ClsSb_EquipDotCheckRuleBill oBill = new DLL.ClsSb_EquipDotCheckRuleBill(); - if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + ds = oCN.RunProcReturn("select * from Sb_EquipDotCheckRuleBillMain where HInterID=" + HInterID, "Sb_EquipDotCheckRuleBillMain"); + if (ds.Tables[0].Rows.Count>0) { - if (oBill.omodel.HBillStatus > 1) + if (int.Parse(ds.Tables[0].Rows[0]["HBillStatus"].ToString()) > 1) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -176,7 +177,7 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql1 = @"select * from h_v_Sb_EquipDotCheckRuleList a - left join Gy_QCCheckItem b on a.鐐规椤圭洰ID =b.HItemID where 1 = 1 "; + left join Gy_DotCheck b on a.鐐规椤圭洰ID =b.HItemID where 1 = 1 "; string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckRuleList"); objJsonResult.code = "0"; -- Gitblit v1.9.1