From 8427cbd12ab2cd1923054ff72e263f5bdebc0803 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 26 八月 2022 17:04:31 +0800
Subject: [PATCH] 设备点检标准查看接口修改字段
---
VueWebApi/DLL/DAL/GridReportDAL.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/VueWebApi/DLL/DAL/GridReportDAL.cs b/VueWebApi/DLL/DAL/GridReportDAL.cs
index 6621b57..4556ffa 100644
--- a/VueWebApi/DLL/DAL/GridReportDAL.cs
+++ b/VueWebApi/DLL/DAL/GridReportDAL.cs
@@ -28,7 +28,7 @@
var dynamicParams = new DynamicParameters();
//鑾峰彇璁惧绫诲瀷鏁版嵁
- sql = @"select A.seq,A.wo_code,P.partcode,P.partname,P.partspec,R.name as routename,M.plan_qty as orderqty,@username as lm_user,@createdate as lm_date,
+ sql = @"select A.seq,A.wo_code,M.m_po,P.partcode,P.partname,P.partspec,R.name as routename,M.plan_qty as orderqty,@username as lm_user,@createdate as lm_date,
B.stepcode,B.stepname,A.plan_qty,(case when A.good_qty=0 then '' end) as good_qty,(case when A.ng_qty=0 then '' end) as ng_qty,A.wo_code+';'+B.stepcode as stepqrcode
from TK_Wrk_Step A
left join TK_Wrk_Man M on A.wo_code=M.wo_code
--
Gitblit v1.9.3