From 4215644b7b4f775a41cc6b22a3f0def39727dd5c Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期四, 19 十一月 2020 10:13:06 +0800
Subject: [PATCH] 测试调整后上传
---
src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs | 49 +++++++++++++++++++++----------------------------
1 files changed, 21 insertions(+), 28 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs b/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
index 5bea80b..d4ac0a7 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
@@ -934,12 +934,11 @@
});
//鎵ｉ櫎鏃ヨ鍒掓槑缁嗗凡琚垎閰嶇殑鏁伴噺
- var _ls = DayPlanPpbom.Where(c => c.FENTRYID == id && c.FMATERIALID == _item.FMATERIALID).FirstOrDefault();
- _ls.NeedQty = 0;
+ DayPlanPpbomls.NeedQty = 0;
}
FEntryIdList.Clear();
//鏇存柊閲囪喘璁㈠崟
- sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount += '{NeedQty}' where FENTRYID = {Purchase.FENTRYID}");
+ sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount =isnull(FPODemandPlanCount,0)+ '{NeedQty}' where FENTRYID = {Purchase.FENTRYID}");
//鎵ｉ櫎褰撳墠琛屽搴旈噰璐鍗曟暟閲�
var ls = PurchaseInventory.Where(c => c.FENTRYID == Purchase.FENTRYID).FirstOrDefault();
ls.FQTY -= NeedQty;
@@ -947,7 +946,8 @@
}
else
{
- decimal _NeedQty = Purchase.FQTY;
+ NeedQty = NeedQty - Purchase.FQTY;
+ decimal _NeedQty = Purchase.FQTY;//閲囪喘璁㈠崟鏁伴噺
List<int> mmm = new List<int>();
foreach (int id in FEntryIdList)
{
@@ -979,15 +979,14 @@
});
+ DayPlanPpbomls.NeedQty -= Qty;
//鏇存柊閲囪喘璁㈠崟
- sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount += '{Purchase.FQTY}' where FENTRYID = {Purchase.FENTRYID}");
- //鏇存柊Model
- var ls = PurchaseInventory.Where(c => c.FENTRYID == Purchase.FENTRYID ).FirstOrDefault();
- ls.FQTY = 0;
+ sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount = isnull(FPODemandPlanCount,0)+ '{Qty}' where FENTRYID = {Purchase.FENTRYID}");
- var _ls = DayPlanPpbom.Where(c => c.FENTRYID == id && c.FMATERIALID == _item.FMATERIALID).FirstOrDefault();
- _ls.NeedQty -= Qty;
+ //鏇存柊Model
+ var ls = PurchaseInventory.Where(c => c.FENTRYID == Purchase.FENTRYID).FirstOrDefault();
+ ls.FQTY -= Qty;
if (_NeedQty < 0)
{
@@ -995,18 +994,16 @@
{
FEntryIdList.Remove(mm);
}
-
-
break;
}
- NeedQty = NeedQty - Qty;
+
mmm.Add(id);
}
foreach (var mm in mmm)
{
FEntryIdList.Remove(mm);
}
- NeedQty = NeedQty - Purchase.FQTY;
+
}
}
NeedQty = 0;
@@ -1052,12 +1049,11 @@
});
//鎵ｉ櫎鏃ヨ鍒掓槑缁嗗凡琚垎閰嶇殑鏁伴噺
- var _ls = DayPlanPpbom.Where(c => c.FENTRYID == id && c.FMATERIALID == _item.FMATERIALID).FirstOrDefault();
- _ls.NeedQty = 0;
+ DayPlanPpbomls.NeedQty = 0;
}
FEntryIdList.Clear();
//鏇存柊閲囪喘璁㈠崟
- sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount += '{NeedQty}' where FENTRYID = {Purchase.FENTRYID}");
+ sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount =isnull(FPODemandPlanCount,0)+ '{NeedQty}' where FENTRYID = {Purchase.FENTRYID}");
//鎵ｉ櫎褰撳墠琛屽搴旈噰璐鍗曟暟閲�
var ls = PurchaseInventory.Where(c => c.FENTRYID == Purchase.FENTRYID).FirstOrDefault();
ls.FQTY -= NeedQty;
@@ -1065,7 +1061,8 @@
}
else
{
- decimal _NeedQty = Purchase.FQTY;
+ NeedQty = NeedQty - Purchase.FQTY;
+ decimal _NeedQty = Purchase.FQTY;//閲囪喘璁㈠崟鏁伴噺
List<int> mmm = new List<int>();
foreach (int id in FEntryIdList)
{
@@ -1097,15 +1094,13 @@
});
-
+ DayPlanPpbomls.NeedQty -= Qty;
//鏇存柊閲囪喘璁㈠崟
- sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount += '{Purchase.FQTY}' where FENTRYID = {Purchase.FENTRYID}");
+ sqlList.Add($"/*dialect*/ update t_PUR_POOrderEntry set FPODemandPlanCount = isnull(FPODemandPlanCount,0)+ '{Qty}' where FENTRYID = {Purchase.FENTRYID}");
+
//鏇存柊Model
var ls = PurchaseInventory.Where(c => c.FENTRYID == Purchase.FENTRYID).FirstOrDefault();
- ls.FQTY = 0;
-
- var _ls = DayPlanPpbom.Where(c => c.FENTRYID == id && c.FMATERIALID == _item.FMATERIALID).FirstOrDefault();
- _ls.NeedQty -= Qty;
+ ls.FQTY -= Qty;
if (_NeedQty < 0)
{
@@ -1113,18 +1108,16 @@
{
FEntryIdList.Remove(mm);
}
-
-
break;
}
- NeedQty = NeedQty - Qty;
+
mmm.Add(id);
}
foreach (var mm in mmm)
{
FEntryIdList.Remove(mm);
}
- NeedQty = NeedQty - Purchase.FQTY;
+
}
}
NeedQty = 0;
--
Gitblit v1.9.1