From fb1c355f7b38d493816b4cf94a20060887c524a0 Mon Sep 17 00:00:00 2001
From: eight <641137800@qq.com>
Date: 星期日, 29 九月 2024 10:25:42 +0800
Subject: [PATCH] 设备状态特性
---
jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/room/RoomMapper.java | 7 +++++--
1 files changed, 5 insertions(+), 2 deletions(-)
diff --git a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/room/RoomMapper.java b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/room/RoomMapper.java
index 3e6fd43..052bf5a 100644
--- a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/room/RoomMapper.java
+++ b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/room/RoomMapper.java
@@ -31,12 +31,12 @@
.orderByDesc(RoomDO::getId));
}
- @Select("select lihu.clinic_room where ip = #{ip}")
+ @Select("select * from lihu.clinic_room where ip = #{ip}")
List<RoomDO> queueByIp(@Param("ip") String ip);
@Update("<script> " +
"update lihu.clinic_room set status=#{newStatus}, doc_id=null, doc_name=null " +
- " where 1 = 1 " +
+ " where deleted = 0 " +
"</script>")
Integer resetRoom(@Param("newStatus") Integer newStatus);
@@ -56,6 +56,9 @@
@Select("SELECT * FROM lihu.clinic_room where room_id=#{roomId} and bed_no=#{bedNo} and doc_id=#{docId}")
RoomDO getRoom(@Param("roomId")Long roomId, @Param("bedNo")String bedNo, @Param("docId")Long docId);
+ @Select("SELECT * FROM lihu.clinic_room where doc_id=#{docId} limit 1")
+ RoomDO getRoomByDocId(@Param("docId")Long docId);
+
@Update("<script> " +
"update lihu.clinic_room set status=#{newStatus.status} " +
" where room_id=#{roomId} and bed_no=#{bedNo} and isNull(doc_id) " +
--
Gitblit v1.9.3