预约序号表 初始化逻辑处理

eight

2024-11-12 60e288dfb165eafe7d03d5e22780d61029a4a825

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/queuesequence/QueueSequenceMapper.java

@@ -29,6 +29,12 @@
                .orderByDesc(QueueSequenceDO::getId));
    }

    @Select( "select count(1) from lihu.queue_sequence")
    Integer getQueueSequenceTableRowCount();

    @Delete("delete from lihu.queue_sequence where TO_DAYS(create_time) != TO_DAYS(NOW())")
    void clearQueueSequenceTableNotCurrent();

    @Update("truncate table lihu.queue_sequence")
    void clearQueueSequenceTable();