From e7438c176acf8d18c07e1a0946770e0f6cb6fadf Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 21 十一月 2022 15:09:29 +0800
Subject: [PATCH] 灵翔的登陆接口存redis加企业区分
---
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