From 67e6f3503c5e28ace45e3ad7c30b0965555b02f5 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期三, 29 五月 2024 16:49:48 +0800 Subject: [PATCH] 递入 参数 单据类型、单据内码、库存更新类型 ; 根据单据类型和单据内码,更新 及时库存表 ;采购入库单 审核时 库存更新类型 为1 , 反审核时 库存更新类型为 2; 1 就是增加 库存,2就是 减少库存; 生产领料单 审核时 库存更新类型 为1 , 反审核时 库存更新类型为 2; 1 就是减少 库存,2就是增加库存 --- WebAPI/DLL/ClsSc_MESReturnStepWorkBill.cs | 7 +++---- 1 files changed, 3 insertions(+), 4 deletions(-) diff --git a/WebAPI/DLL/ClsSc_MESReturnStepWorkBill.cs b/WebAPI/DLL/ClsSc_MESReturnStepWorkBill.cs index 14b7936..aca74cd 100644 --- a/WebAPI/DLL/ClsSc_MESReturnStepWorkBill.cs +++ b/WebAPI/DLL/ClsSc_MESReturnStepWorkBill.cs @@ -146,11 +146,10 @@ ",getdate(),getdate(),'杩斿伐璁″垝','"+omodel.HICMOInterID + "','"+omodel.HSourceEntryID+"','"+omodel.HSourceBillNo+"'" + ",'"+omodel.HSourceBillType+"','0','0','"+omodel.HProcID+"'" + "from Sc_ICMOBillStatus_Tmp where HSourceBillNo='"+omodel.HSourceBillNo.ToString()+"'" + - " and HSourceInterID='"+omodel.HICMOInterID+"' and HSourceEntryID='"+omodel.HSourceEntryID.ToString()+"'" + - " and HSourceID='"+omodel.HSourceID.ToString()+"'"); - //Log.LogInfo(sql1); + " and HSourceInterID='"+omodel.HSourceInterID+"' and HSourceEntryID='"+omodel.HMainSourceEntryID.ToString()+"'" + + " and HSourceID='"+omodel.HSourceID.ToString()+"' and HProcID='"+omodel.HProcID.ToString()+"'"); oCn.RunProc(sql1); - sReturn = omodel.HInterID.ToString(); + sReturn = "鏂板鍗曟嵁鎴愬姛锛�"; oCn.Commit(); return true; } -- Gitblit v1.9.1