From 15a20a91316b726f45ccc9e06bbd632f10eedb43 Mon Sep 17 00:00:00 2001 From: Lius <Lius2225@163.com> Date: 星期五, 13 九月 2024 14:10:55 +0800 Subject: [PATCH] update --- lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/MdcEquipmentMapper.java | 20 +++++++++++++++++--- 1 files changed, 17 insertions(+), 3 deletions(-) diff --git a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/MdcEquipmentMapper.java b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/MdcEquipmentMapper.java index 12f4455..4825207 100644 --- a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/MdcEquipmentMapper.java +++ b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/MdcEquipmentMapper.java @@ -5,6 +5,7 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import org.apache.ibatis.annotations.Param; +import org.apache.ibatis.annotations.Select; import org.jeecg.modules.mdc.dto.MdcEquDepDto; import org.jeecg.modules.mdc.dto.MdcEquProDto; import org.jeecg.modules.mdc.dto.MdcEquipmentDto; @@ -16,6 +17,7 @@ import org.jeecg.modules.mdc.vo.WorkshopEquipmentVo; import java.util.List; +import java.util.Map; /** * @Description: 璁惧琛� @@ -48,12 +50,12 @@ /** * 鏍规嵁閮ㄩ棬id鏌ヨ璁惧 */ - List<MdcEquipment> queryByDepartId(@Param("departId") String departId); + List<MdcEquipment> queryByDepartId(@Param("departId") String departId, @Param("key") String key); /** * 鏍规嵁浜х嚎id鏌ヨ璁惧 */ - List<MdcEquipment> queryByProductionId(@Param("productionId") String productionId); + List<MdcEquipment> queryByProductionId(@Param("productionId") String productionId, @Param("key") String key); /** * 鏌ユ壘璁惧鐩戞帶淇℃伅 @@ -97,12 +99,24 @@ IPage<MdcEquipment> pageList(Page<MdcEquipment> page, @Param("mdcEquipment") MdcEquipmentVo mdcEquipment); @InterceptorIgnore(tenantLine = "1") - MdcEquipmentDto getWorkLineLast(@Param("tableName") String saveTableName); + @Select("select TOP 1 CollectTime ${columns} from [${tableName}] order by CollectTime desc") + Map<String, Object> getWorkLineLast(Map<String, Object> param); /** * 瀵煎嚭list + * * @param mdcEquipment * @return */ List<MdcEquipment> exportXlsList(@Param("mdcEquipment") MdcEquipmentVo mdcEquipment); + + /** + * 鏌ヨ鍗曡〃鏁版嵁 + * + * @param tableName + * @return + */ + @InterceptorIgnore(tenantLine = "1") + MdcEquipmentDto findWorkLineLast(@Param("tableName") String tableName); + } -- Gitblit v1.9.3