From dfbc0389d6b9b2bd8e92e976248b9992a03979f4 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期三, 08 九月 2021 13:23:26 +0800
Subject: [PATCH] 提料生成送货单 下推数量 =提料计划数量 - 已生成送货单数量
---
src/BLL/Demo.BillView/PRD/Pro_RJHYLQDBGFSH.cs | 38 +++-----------------------------------
1 files changed, 3 insertions(+), 35 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_RJHYLQDBGFSH.cs b/src/BLL/Demo.BillView/PRD/Pro_RJHYLQDBGFSH.cs
index ac5e1bc..c269c2c 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_RJHYLQDBGFSH.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_RJHYLQDBGFSH.cs
@@ -44,44 +44,12 @@
base.AfterExecuteOperationTransaction(e);
List<string> sqlList = new List<string>();
string sql = "";
- //瀹℃牳鏃舵洿鏂扮敓浜х敤鏂欐竻鍗曡〃鏄庣粏棰嗘枡鏁伴噺
+ //鍙嶅鏍告椂鏇存柊鐢熶骇鐢ㄦ枡娓呭崟琛ㄦ槑缁嗛鏂欐暟閲�
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 fHQtyMust = entryRow["FHQtyMust"].ToString();
- string fUseRate = entryRow["FUseRate"].ToString();
- string fDwyl = entryRow["FDwyl"].ToString();
- string fHPPBomEntryID = entryRow["FHPPBomEntryID"].ToString();
- sql = string.Format($"/*dialect*/update Sc_DayPlanPPBomBillSub set FHQtyMust = {fHQtyMust},FUseRate = { fUseRate} 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_FSHRjhylqdBgUpdate {billObj["Id"].ToString()}";
+ sqlList.Add(sql);
}
DBServiceHelper.ExecuteBatch(Context, sqlList);
}
--
Gitblit v1.9.1