From 6cb6d56102ce66fc348655c112d9f178c08aaeb8 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期二, 23 三月 2021 18:22:11 +0800
Subject: [PATCH] EndOperationTransaction 方法 更新此次调拨数量
---
src/BLL/Demo.BillView/PRD/Pro_DayPlanPushZJDB.cs | 16 ++++++++++++++--
1 files changed, 14 insertions(+), 2 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_DayPlanPushZJDB.cs b/src/BLL/Demo.BillView/PRD/Pro_DayPlanPushZJDB.cs
index fb78513..fcccd16 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_DayPlanPushZJDB.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_DayPlanPushZJDB.cs
@@ -137,6 +137,18 @@
dbService.AutoSetPrimaryKey(this.Context, allNewLinkRows.ToArray(), linkEntry.DynamicObjectType);
}
+
+ public override void EndOperationTransaction(EndOperationTransactionArgs e)
+ {
+ base.EndOperationTransaction(e);
+ string sql = @"/*dialect*/
+ update a set FBASEQTY = FQTY
+ from T_STK_STKTRANSFERINENTRY_LK a
+ join T_STK_STKTRANSFERINENTRY b on a.FENTRYID = b.FENTRYID
+ where a.FSTABLENAME = 'T_PRD_PPBOMENTRY' and a.FBASEQTY = 0";
+ DBServiceHelper.Execute(Context, sql);
+ }
+
/// <summary>
/// 鍔犺浇鐩稿叧鐨勯攢鍞鍗曟暟鎹�
/// </summary>
@@ -159,7 +171,7 @@
fields.Add(new SelectorItemInfo("FBASEPICKEDQTY")); //
fields.Add(new SelectorItemInfo("FBFLOWID")); //
fields.Add(new SelectorItemInfo("FSelTranslateQty")); //
-
+
// 鎸囧畾杩囨护鏉′欢
string filter = string.Format(" FBillNo IN ('{0}') ", string.Join("','", poBillNos));
OQLFilter ofilter = OQLFilter.CreateHeadEntityFilter(filter);
@@ -221,7 +233,7 @@
linkRow["BaseQty"] = toRow["QTY"]; //鏈闇�瑕佽皟鎷ㄦ暟閲�
linkRow["SALBASEQTY"] = toRow["QTY"]; //鏈闇�瑕佽皟鎷ㄦ暟閲�
-
+
}
/// <summary>
--
Gitblit v1.9.1