From e8eed61d8b70215766a4e5c226e10d2f0d28ff95 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期六, 04 三月 2023 11:31:40 +0800
Subject: [PATCH] 1.工单派发选择工艺路线或选择生产车间时判断绑定条件接口开发 2.组织架构删除update改为delete 3.工艺路线新增else if改为if 4.节拍工价根据工序线编码查找关联设备集合 5.PC/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 6b303d8..9dc1b4c 100644
--- a/VueWebApi/DLL/DAL/AppAnalyticsDAL.cs
+++ b/VueWebApi/DLL/DAL/AppAnalyticsDAL.cs
@@ -66,7 +66,7 @@
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 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
+ where A.lm_date between @startopendate and @endclosedate
) as AA
group by AA.partname
order by defect_qty desc";
@@ -76,7 +76,7 @@
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 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
+ where A.lm_date between @startopendate and @endclosedate
) as AA
group by AA.stepname
order by defect_qty desc";
--
Gitblit v1.9.3