From a4e554b7e6c5b98e728f96be80a12b0b04eebd48 Mon Sep 17 00:00:00 2001 From: cuijian <cuijian@xalxzn.com> Date: 星期三, 22 十一月 2023 19:10:28 +0800 Subject: [PATCH] 设备完好率、设备开动率报表逻辑开发 --- lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/EquipmentWorklineMapper.java | 4 ++++ 1 files changed, 4 insertions(+), 0 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 c2ea7db..4e2248e 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 @@ -32,4 +32,8 @@ @InterceptorIgnore(tenantLine = "1") @Select("select CollectTime ${columns} from [${tableName}] where CollectTime > #{startTime} and CollectTime <= #{endTime} order by CollectTime asc") List<Map<String, Object>> getWorkLineList(Map<String, Object> param); + + @InterceptorIgnore(tenantLine = "1") + @Select("SELECT COUNT(*) FROM SysObjects WHERE XType='U' AND name = '${tableName}'") + Integer isTableExist(@Param("tableName") String tableName); } -- Gitblit v1.9.3