| | |
|---|
| | | " <foreach collection='curStatusList' separator=',' item='curStatus'>" + |
|---|
| | | " #{curStatus.status} " + |
|---|
| | | " </foreach> )" + |
|---|
| | | " and deleted = 0;" + |
|---|
| | | " and deleted = 0" + |
|---|
| | | " order by room_id;" + |
|---|
| | | "</script>") |
|---|
| | | @Results({ |
|---|
| | | @Result(property = "checkTypes", column = "check_types", typeHandler=com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler.class) |
|---|
| | |
|---|
| | | @Select("SELECT * FROM lihu.clinic_room where room_id=#{roomId} and bed_no=#{bedNo} and doc_id=#{docId}") |
|---|
| | | RoomDO getRoomByRoomBedDoc(@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); |
|---|
| | | @Select("SELECT * FROM lihu.clinic_room where doc_id=#{docId}") |
|---|
| | | List<RoomDO> getRoomByDocId(@Param("docId")Long docId); |
|---|
| | | |
|---|
| | | @Update("<script> " + |
|---|
| | | "update lihu.clinic_room set status=#{newStatus.status} " + |
|---|
