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_SCLLFSH.cs | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_SCLLFSH.cs b/src/BLL/Demo.BillView/PRD/Pro_SCLLFSH.cs
index b20422c..386b031 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_SCLLFSH.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_SCLLFSH.cs
@@ -33,6 +33,7 @@
e.FieldKeys.Add("FBaseJoinQty");
e.FieldKeys.Add("FDayPlanBillNo");
e.FieldKeys.Add("FDayPlanFentryId");
+ e.FieldKeys.Add("FisFX");
}
/// <summary>
///鍙嶅鏍� 鍙嶆洿鏂版棩璁″垝鐢ㄦ枡娓呭崟璋冩嫧鏁伴噺
@@ -52,12 +53,14 @@
foreach (var entryRow in entryRows)
{
//鐢熶骇鐢ㄦ枡娓呭崟涓虹┖鏃�
- if (Convert.ToString(entryRow["FDayPlanBillNo"]) == "")
+ if (Convert.ToString(entryRow["FDayPlanBillNo"]) == "" || !Convert.ToBoolean(entryRow["FisFX"]))
continue;
string fentryId = entryRow["FDayPlanFentryId"].ToString();
decimal FBaseQty = Convert.ToDecimal(entryRow["BaseActualQty"]);
sql = string.Format($"/*dialect*/update Sc_DayPlanPPBomBillSub set FPickedQty -= {FBaseQty} where FEntryID = { fentryId} ");
sqlList.Add(sql);
+ sql = string.Format($"/*dialect*/update T_PRD_PICKMTRLDATA set FisFX = 0 where FentryId = {entryRow["Id"]}");
+ sqlList.Add(sql);
}
}
DBServiceHelper.ExecuteBatch(Context, sqlList);
--
Gitblit v1.9.1