From b445defcf7e9dad85032a8279cca29a2892d3089 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期四, 05 九月 2024 12:38:58 +0800 Subject: [PATCH] 修改生产报表查询方法,物料新增编辑增加事业部与项目保存字段 --- WebAPI/Controllers/SBGL/SB_EquipICMOTechParamBillController.cs | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/SBGL/SB_EquipICMOTechParamBillController.cs b/WebAPI/Controllers/SBGL/SB_EquipICMOTechParamBillController.cs index f525028..0ae4bd1 100644 --- a/WebAPI/Controllers/SBGL/SB_EquipICMOTechParamBillController.cs +++ b/WebAPI/Controllers/SBGL/SB_EquipICMOTechParamBillController.cs @@ -746,7 +746,7 @@ { if (oSystemParameter.omodel.SB_EquipICMOTechParamBill_MustBeginWorkCtl == "Y") { - ds = oCn.RunProcReturn("select * from Sc_ICMOBillStatus_Tmp where HSourceID = '" + oBill.omodel.HSourceID + "' and HICMOBillNo = '" + oBill.omodel.HICMOBillNo + "' and HInterID = '" + oBill.omodel.HICMOInterID + "' and hicmostatus =1", "Sc_ICMOBillStatus_Tmp"); + ds = oCn.RunProcReturn("select * from Sc_ICMOBillStatus_Tmp where HSourceID = '" + oBill.omodel.HSourceID + "' and HSourceBillNo = '" + oBill.omodel.HProcExchBillNo + "' and HSourceInterID = '" + oBill.omodel.HProcExchInterID + "'and HSourceEntryID = '" + oBill.omodel.HProcExchEntryID + "' and hicmostatus =1", "Sc_ICMOBillStatus_Tmp"); if (ds.Tables[0].Rows[0]["HICMOStatus"].ToString() != "1") { objJsonResult.code = "0"; -- Gitblit v1.9.1