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