From a05018727c284e1d24967e0cf120a934796191b8 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期二, 02 三月 2021 16:02:05 +0800
Subject: [PATCH] 更改
---
src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs | 6 +++++-
1 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs b/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
index 585f532..fcde28b 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
@@ -112,13 +112,15 @@
where FEntryID={1}", FRealQty, selectedRow["Id"]);
sqlList.Add(sql);
}
+ var fid = this.View.Model.GetPKValue();
+ sqlList.Add($"update Sc_WorkBillSortBillMain set FCloseCount = (select sum(FNotInStockCount) from Sc_WorkBillSortBillSub where FID ={fid}) where FID ={fid}");
DBServiceHelper.ExecuteBatch(Context, sqlList);
this.View.Refresh();
if (string.IsNullOrEmpty(result.ToString()))
this.View.ShowMessage("鎿嶄綔鎴愬姛");
else
this.View.ShowErrMessage(result.ToString());
-
+
}
else if (e.BarItemKey.ToUpper() == "TBROWCANCELCLOSE")
{
@@ -140,6 +142,8 @@
where FEntryID={0}", selectedRow["Id"]);
sqlList.Add(sql);
}
+ var fid = this.View.Model.GetPKValue();
+ sqlList.Add($"update Sc_WorkBillSortBillMain set FCloseCount = (select sum(FNotInStockCount) from Sc_WorkBillSortBillSub where FID ={fid}) where FID ={fid}");
DBServiceHelper.ExecuteBatch(Context, sqlList);
this.View.Refresh();
this.View.ShowMessage("鎿嶄綔鎴愬姛");
--
Gitblit v1.9.1