From 0d16effeead91ab14bef60cfd556bcc3056f793c Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期四, 11 三月 2021 09:01:46 +0800 Subject: [PATCH] 生产计划平台(虚拟齐套)插件 --- src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs | 35 +++++++++++++++++++++-------------- 1 files changed, 21 insertions(+), 14 deletions(-) diff --git a/src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs b/src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs index 9688acf..83fd6ca 100644 --- a/src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs +++ b/src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs @@ -16,13 +16,13 @@ namespace Demo.DynamicForm.PRD { /// <summary> - /// 鎻掍欢绀轰緥锛氬紩鍏ラ攢鍞嚭搴撳崟锛屽缓绔嬩笌閿�鍞鍗曠殑鍏宠仈 + /// 鎻掍欢绀轰緥锛氭棩璁″垝鐢ㄦ枡娓呭崟涓嬫帹鍚庯紝寤虹珛鐢熶骇棰嗘枡鍗曚笌鐢熶骇鐢ㄦ枡娓呭崟鍏宠仈鍏崇郴 /// </summary> /// <remarks> /// 瑕佹眰锛� /// 1. 闇�瑕佸紩鍏ュ崟鎹綋鐨勬簮鍗曠被鍨嬨�佹簮鍗曠紪鍙峰瓧娈� - /// 2. 鏈彃浠舵寕鍦ㄩ攢鍞嚭搴撳崟鐨勪繚瀛樻搷浣滀笂 - /// 鍑哄簱鍏宠仈閿�鍞鍗� + /// 2. 鏈彃浠舵寕鍦ㄧ敓浜ч鏂欏崟鐨勪繚瀛樻搷浣滀笂 + /// 鐢熶骇棰嗘枡鍗曚笌鐢熶骇鐢ㄦ枡娓呭崟鍏宠仈 /// </remarks> [Description("鏃ヨ鍒掔敤鏂欐竻鍗曚笅鎺ㄥ悗锛屽缓绔嬬敓浜ч鏂欏崟涓庣敓浜х敤鏂欐竻鍗曞叧鑱斿叧绯�")] [HotUpdate] @@ -59,6 +59,9 @@ as DynamicObjectCollection; foreach (var entryRow in entryRows) { + //鐢熶骇鐢ㄦ枡娓呭崟涓虹┖鏃� + if (Convert.ToString(entryRow["FDayPlanBillNo"]) == "") + continue; string srcFormId = ""; string srcSrcBillNo = ""; string FPPBOMFENTRYID = ""; @@ -152,24 +155,28 @@ public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e) { base.AfterExecuteOperationTransaction(e); + if (FentryIdList.Count == 0) + return; string FentryId = string.Join(",", FentryIdList.ToArray()); List<string> sqlList = new List<string>(); string sql = string.Format(@"/*dialect*/ - update a set FBASEACTUALQTY = b.FBASEACTUALQTY - from T_PRD_PICKMTRLDATA_LK a - join T_PRD_PICKMTRLDATA b on a.FENTRYID = b.FENTRYID - where a.FSTABLENAME = 'T_PRD_PPBOMENTRY' and a.FENTRYID in ({0})", FentryId); + update a set FSTOCKAPPQTY = FAPPQTY,FSTOCKACTUALQTY=FACTUALQTY + from T_PRD_PICKMTRLDATA a + where a.FENTRYID in ({0})", FentryId); sqlList.Add(sql); sql = string.Format(@"/*dialect*/ - update T_PRD_PICKMTRLDATA set - FSrcBillType = 'PRD_PPBOM', - FSRCENTRYID=FPPBomEntryId, - FSrcBillNo=FPPBOMBILLNO - where FENTRYID in ({0}) +update a set +FSrcBillType='PRD_PPBOM', +FSrcBillNo = b.FPPBOMBILLNO, +FSRCINTERID =FHPPBomInterID, +FSRCENTRYID = FHPPBomEntryID, +FSRCENTRYSEQ =FPPBOMFSEQINT +from T_PRD_PICKMTRLDATA a +join Sc_DayPlanPPBomBillSub b on a.FDAYPLANFENTRYID = b.FEntryID +where a.FEntryID in ({0}) ", FentryId); sqlList.Add(sql); DBServiceHelper.ExecuteBatch(Context, sqlList); - //DBServiceHelper.Execute(Context, sql); } /// <summary> /// 鍔犺浇鐩稿叧鐨勯攢鍞鍗曟暟鎹� @@ -245,7 +252,7 @@ //鍓╀綑棰嗘枡鏁伴噺 decimal remainQty = DBServiceHelper.ExecuteScalar<decimal>(Context, $"select FMustQty -isnull(FSelPickedQty,0) from T_PRD_PPBOMENTRY t1 left join T_PRD_PPBOMENTRY_Q t2 on t1.FENTRYID = t2.FENTRYID where t1.FENTRYID={toRow["PPBomEntryId"]?.ToString()}", 0); linkRow["FlowId"] = srcRow["BFLowId_Id"]; - linkRow["FlowLineId"] = 0; + linkRow["FlowLineId"] = 5; linkRow["RuleId"] = "PRD_PPBOM2PICKMTRL_NORMAL"; linkRow["SBillId"] = ((DynamicObject)srcRow.Parent)[0]; linkRow["STableId"] = ((DynamicObject)srcRow.Parent)[0]; -- Gitblit v1.9.1