From 247d5855038f8d485c1d3a4b4a7bf148c66cbfd4 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期一, 11 一月 2021 15:19:53 +0800
Subject: [PATCH] 领料单改为缺料单
---
src/BLL/Demo.TimedTaskPlugIn/PRD/StockChangeDynamicAlignment.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/BLL/Demo.TimedTaskPlugIn/PRD/StockChangeDynamicAlignment.cs b/src/BLL/Demo.TimedTaskPlugIn/PRD/StockChangeDynamicAlignment.cs
index 182f9cf..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
--
Gitblit v1.9.1