From 0a9319f5d192666d6e8f210c223b01206e9645d2 Mon Sep 17 00:00:00 2001
From: eight <641137800@qq.com>
Date: 星期二, 08 十月 2024 17:13:37 +0800
Subject: [PATCH] 设备三个编号
---
jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/room/RoomMapper.java | 5 ++++-
1 files changed, 4 insertions(+), 1 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 a99128c..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
@@ -36,7 +36,7 @@
@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