From 975c04c0181b3da82a79cb04abe6a2f1799eb363 Mon Sep 17 00:00:00 2001
From: hjg <hjg@123.com>
Date: 星期三, 22 十一月 2023 17:33:04 +0800
Subject: [PATCH] 科技LED、公司简称
---
JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java b/JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java
index c016dfd..12ae025 100644
--- a/JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java
+++ b/JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java
@@ -166,14 +166,14 @@
})
public List<Map> getHwList(String sdepartNo);
- // 涔夌憺LED鏄剧ず 搴忓彿 杞﹀彿 瑁呰溅鍖� 鐘舵��
+ /** 涔夌憺銆佺鎶�LED鏄剧ず 搴忓彿 杞﹀彿 瑁呰溅鍖� 鐘舵�� **/
@Select({
"select bs.numberplates,businessNo,zcWz,firstzxhtime," ,
"case WHEN EXISTS ( SELECT * FROM bussinessitems WHERE bussinessNo = x.businessNo ) THEN '鍦ㄨ'" ,
" when x.firstgbtime is not null then '寰呰' else '瀹屾垚' end zcStatus " ,
" from xs_taskmonitor x" ,
" join bussinesssheet bs on x.businessNo=bs.bussinessNo and bs.sstatus='鍦ㄥ姙' " ,
- " where sdepartNo=#{sdepartNo} and firstgbtime is not null and x.lastgbtime is null"
+ " where sdepartNo=#{sdepartNo} and firstgbtime is not null and x.lastgbtime is null order by jctime"
})
public List<Map> yRZcList(String sdepartNo);
--
Gitblit v1.9.3