From ce61b02c2889a1ebdc71ff048a7836bbf1fe3208 Mon Sep 17 00:00:00 2001 From: lius <Lius2225@163.com> Date: 星期一, 14 八月 2023 10:21:34 +0800 Subject: [PATCH] update --- lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/EquipmentWorklineMapper.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/EquipmentWorklineMapper.java b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/EquipmentWorklineMapper.java index 20d8e9a..c2ea7db 100644 --- a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/EquipmentWorklineMapper.java +++ b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/EquipmentWorklineMapper.java @@ -23,7 +23,7 @@ List<MdcEquipmentDto> getMacingDataList(@Param("tableName") String tableName); @InterceptorIgnore(tenantLine = "1") - @Select("select Sequencenumber,CollectTime from ${tableName} " + + @Select("select Sequencenumber,CollectTime from [${tableName}] " + " where CollectTime > #{startTime} and CollectTime <= #{endTime} and Sequencenumber is not null" + " order by CollectTime desc ") List<Map<String, Object>> getEquipmentSequenceNumber(@Param("tableName") String tableName, @Param("startTime") Date startTime, @Param("endTime") Date endTime); -- Gitblit v1.9.3