From 4b0ac821502f956d7b0acd73f80a384ee41f6a6a Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期一, 01 三月 2021 10:16:55 +0800
Subject: [PATCH] 日计划导入增加生产订单明细行号功能
---
src/BLL/Demo.TimedTaskPlugIn/PRD/StockChangeDynamicAlignment.cs | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/src/BLL/Demo.TimedTaskPlugIn/PRD/StockChangeDynamicAlignment.cs b/src/BLL/Demo.TimedTaskPlugIn/PRD/StockChangeDynamicAlignment.cs
index 9d7cc86..b8f3e36 100644
--- a/src/BLL/Demo.TimedTaskPlugIn/PRD/StockChangeDynamicAlignment.cs
+++ b/src/BLL/Demo.TimedTaskPlugIn/PRD/StockChangeDynamicAlignment.cs
@@ -37,7 +37,7 @@
Context = ctx;
string sql = @"/*dialect*/ select count(*) from
(
-select a.FSTOCKORGID,sum(b.FACTUALQTY)FACTUALQTY,b.FMATERIALID from T_PRD_PICKMTRL A
+select a.FSTOCKORGID,sum(b.FACTUALQTY)FACTUALQTY,b.FMATERIALID from T_PRD_FEEDMTRL A
join T_PRD_PICKMTRLDATA b on a.FID =b.FID
where a.FAPPROVEDATE is not null and DATEDIFF(D,GETDATE(),FDATE)=0
group by FSTOCKORGID,FMATERIALID
@@ -369,6 +369,7 @@
ModelEnty.Add("FHSourceID", new JObject() { ["Fnumber"] = _item.FHSourceID });//鐢熶骇璧勬簮FHSourceID
ModelEnty.Add("FNumerator", _item.FNumerator);//鍒嗘瘝
ModelEnty.Add("FDenominator", _item.FDenominator);//鍒嗗瓙
+ ModelEnty.Add("FDwyl", Convert.ToDecimal(_item.FNumerator) / Convert.ToDecimal(_item.FDenominator));//鍗曚綅鐢ㄦ枡
ModelEnty.Add("FFIXSCRAPQTY", _item.FFIXSCRAPQTY);//鍥哄畾鎹熻��
ModelEnty.Add("FHQtyScrap", _item.FHQtyScrap);//鍙樺姩鎹熻�楃巼%
Entry.Add(ModelEnty);
--
Gitblit v1.9.1