From 0fcc730fb3fa804c6e38f6f980eb15ee0a84eb33 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期三, 08 九月 2021 13:24:15 +0800
Subject: [PATCH] 送货计划保存删除 反写提料计划 服务插件
---
src/BLL/Demo.BillView/PRD/Pro_RJHYLQDBGSH.cs | 47 ++++++++---------------------------------------
1 files changed, 8 insertions(+), 39 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_RJHYLQDBGSH.cs b/src/BLL/Demo.BillView/PRD/Pro_RJHYLQDBGSH.cs
index 5d18c50..baba209 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_RJHYLQDBGSH.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_RJHYLQDBGSH.cs
@@ -27,13 +27,13 @@
e.FieldKeys.Add("FSrcBillNo");
e.FieldKeys.Add("FBillNo");
e.FieldKeys.Add("FDayPlanId");
- e.FieldKeys.Add("FDayPlanFentryId");
- e.FieldKeys.Add("FHQtyMust");
+ e.FieldKeys.Add("FDayPlanFentryId");
+ e.FieldKeys.Add("FHQtyMust");
e.FieldKeys.Add("FHQtyMustNew");
e.FieldKeys.Add("FUseRate");
e.FieldKeys.Add("FUseRateNew");
e.FieldKeys.Add("FHPPBomEntryID");
- e.FieldKeys.Add("FDwyl");
+ e.FieldKeys.Add("FDwyl");
}
/// <summary>
///瀹℃牳鏇存柊鏃ヨ鍒掔敤鏂欐竻鍗曢鏂欐暟閲�
@@ -48,44 +48,13 @@
Entity entity = this.BusinessInfo.GetEntity("FEntity");//鑾峰彇鏄庣粏淇℃伅
foreach (var billObj in e.SelectedRows)
{
- DynamicObjectCollection entryRows = entity.DynamicProperty.GetValue(billObj.DataEntity)
- as DynamicObjectCollection;
- foreach (var entryRow in entryRows)
- {
- string fDayPlanFentryId = entryRow["FDayPlanFentryId"].ToString();
- string fHQtyMustNew = entryRow["FHQtyMustNew"].ToString();
- string fUseRateNew = entryRow["FUseRateNew"].ToString();
- string fDwyl = entryRow["FDwyl"].ToString();
- string fHPPBomEntryID = entryRow["FHPPBomEntryID"].ToString();
- if (fHQtyMustNew == "0")
- continue;
- sql = string.Format($"/*dialect*/update Sc_DayPlanPPBomBillSub set FHQtyMust = {fHQtyMustNew},FUseRate = { fUseRateNew} where FEntryID ={fDayPlanFentryId} ");
- sqlList.Add(sql);
- sql = string.Format(@"/*dialect*/
-update T_PRD_PPBOMENTRY set
-FBASENEEDQTY = c.FHQtyMust,
-FBASEMUSTQTY = c.FHQtyMust,
-FSTDQTY = c.FHQtyMust,
-FNEEDQTY = c.FHQtyMust,
-FMUSTQTY = c.FHQtyMust,
-FUSERATE = (c.FHQtyMust / {0} / b.FQTY *100)
-from T_PRD_PPBOMENTRY a
-join T_PRD_PPBOM b on a.FID=b.FID
-join (select sum(FHQtyMust) FHQtyMust,FHPPBomEntryID from Sc_DayPlanPPBomBillSub where FHPPBomEntryID = {1} group by FHPPBomEntryID) c on a.FENTRYID=c.FHPPBomEntryID
-where a.FENTRYID = {1}", fDwyl, fHPPBomEntryID);
- sqlList.Add(sql);
- sql = string.Format(@"/*dialect*/
-update T_PRD_PPBOMENTRY_Q set
-FNOPICKEDQTY = b.FMUSTQTY - a.FPICKEDQTY,
-FBASENOPICKEDQTY = b.FMUSTQTY - a.FPICKEDQTY
-from T_PRD_PPBOMENTRY_Q a
-join T_PRD_PPBOMENTRY b on a.FENTRYID=b.FENTRYID
-where a.FENTRYID = {0}
-", fHPPBomEntryID);
- sqlList.Add(sql);
- }
+ sql = $"/*dialect*/ exec pr_SHRjhylqdBgUpdate {billObj["Id"].ToString()}";
+ sqlList.Add(sql);
}
DBServiceHelper.ExecuteBatch(Context, sqlList);
}
}
}
+
+
+
--
Gitblit v1.9.1