From 50b5c72ca7fe4db72a4a10fe378ca95bffb1e736 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期三, 28 七月 2021 16:36:40 +0800
Subject: [PATCH] nothing
---
src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs | 18 +++++++++++-------
1 files changed, 11 insertions(+), 7 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs b/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
index 585f532..0c660ec 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
@@ -83,11 +83,11 @@
left join T_PRD_INSTOCKENTRY c on b.FENTRYID = c.FSrcEntryId
where a.FEntryID in ({0})", selectedRow["Id"]);
decimal FRealQty = DBServiceHelper.ExecuteScalar<decimal>(Context, sql, 0);
- if (FRealQty == 0)
- {
- result.Append($"鍒嗗綍琛岋細{selectedRow["Seq"]}锛屾棩璁″垝鏄庣粏鏈笅鎺ㄧ敓鎴愮敓浜у叆搴撳崟\r\n");
- continue;
- }
+ //if (FRealQty == 0)
+ //{
+ // result.Append($"鍒嗗綍琛岋細{selectedRow["Seq"]}锛屾棩璁″垝鏄庣粏鏈笅鎺ㄧ敓鎴愮敓浜у叆搴撳崟\r\n");
+ // continue;
+ //}
sql = string.Format(@"
/*dialect*/
select count(*)res from Sc_WorkBillSortBillSub a
@@ -99,7 +99,7 @@
decimal Count = DBServiceHelper.ExecuteScalar<decimal>(Context, sql, 0);
if (Count > 0)
{
- result.Append($"鍒嗗綍琛岋細{selectedRow["Seq"]}锛屼笅娓搁鏂欏崟鐨勫凡棰嗘枡鏁板皬浜庡叆搴撶殑鏍囧噯鐢ㄩ噺\r\n");
+ result.Append($"鍒嗗綍琛岋細{selectedRow["Seq"]}锛屼笅娓搁鏂欏崟鐨勫凡棰嗘枡鏁板ぇ浜庡叆搴撶殑鏍囧噯鐢ㄩ噺\r\n");
continue;
}
sql = string.Format(@"
@@ -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