From 0021d241b6c343fac242f526c872f7485f912d08 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 06 一月 2023 16:23:00 +0800
Subject: [PATCH] App生产看板接口修改
---
VueWebApi/DLL/DAL/AppAnalyticsDAL.cs | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/VueWebApi/DLL/DAL/AppAnalyticsDAL.cs b/VueWebApi/DLL/DAL/AppAnalyticsDAL.cs
index 8adf1e8..6b303d8 100644
--- a/VueWebApi/DLL/DAL/AppAnalyticsDAL.cs
+++ b/VueWebApi/DLL/DAL/AppAnalyticsDAL.cs
@@ -64,7 +64,7 @@
case "prt": //鎸変骇鍝佺粺璁�
sql2 = @"select top 5 sum(AA.plan_qty) as plan_qty,AA.partname,sum(AA.ng_qty)+sum(AA.bad_qty) as defect_qty from (
select A.plan_qty,M.partname,S.ng_qty,S.bad_qty from TK_Wrk_Man A
- inner join (select wo_code, isnull(sum(ng_qty),0) as ng_qty,isnull(sum(bad_qty),0) as bad_qty from TK_Wrk_Step group by wo_code) S on A.wo_code=S.wo_code
+ inner join (select wo_code, isnull(sum(ng_qty),0) as ng_qty,isnull(sum(bad_qty),0) as bad_qty from TK_Wrk_Step where ng_qty>0 or bad_qty>0 group by wo_code) S on A.wo_code=S.wo_code
inner join TMateriel_Info M on A.materiel_code=M.partcode
where A.lm_date between @startopendate and @endclosedate and S.ng_qty>0 or S.bad_qty>0
) as AA
@@ -74,7 +74,7 @@
case "stp"://鎸夊伐搴忕粺璁�
sql2 = @"select top 5 sum(AA.plan_qty) as plan_qty,AA.stepname,sum(AA.ng_qty)+sum(AA.bad_qty) as defect_qty from (
select A.plan_qty,T.stepname,S.ng_qty,S.bad_qty from TK_Wrk_Man A
- inner join (select wo_code,step_code, isnull(sum(ng_qty),0) as ng_qty,isnull(sum(bad_qty),0) as bad_qty from TK_Wrk_Step group by wo_code,step_code) S on A.wo_code=S.wo_code
+ inner join (select wo_code,step_code, isnull(sum(ng_qty),0) as ng_qty,isnull(sum(bad_qty),0) as bad_qty from TK_Wrk_Step where ng_qty>0 or bad_qty>0 group by wo_code,step_code) S on A.wo_code=S.wo_code
inner join TStep T on S.step_code=T.stepcode
where A.lm_date between @startopendate and @endclosedate and S.ng_qty>0 or S.bad_qty>0
) as AA
--
Gitblit v1.9.3