From 2cf1565485060fd56e1f1f1cffbba7a4d70d42a6 Mon Sep 17 00:00:00 2001 From: lyh <925863403@qq.com> Date: 星期五, 11 四月 2025 11:06:22 +0800 Subject: [PATCH] 优化dnc,设备结构树查询,优化原有代码 --- lxzn-module-dnc/src/main/java/org/jeecg/modules/dnc/service/impl/DeviceManagementServiceImpl.java | 5 +++++ 1 files changed, 5 insertions(+), 0 deletions(-) diff --git a/lxzn-module-dnc/src/main/java/org/jeecg/modules/dnc/service/impl/DeviceManagementServiceImpl.java b/lxzn-module-dnc/src/main/java/org/jeecg/modules/dnc/service/impl/DeviceManagementServiceImpl.java index 716979e..bd5c852 100644 --- a/lxzn-module-dnc/src/main/java/org/jeecg/modules/dnc/service/impl/DeviceManagementServiceImpl.java +++ b/lxzn-module-dnc/src/main/java/org/jeecg/modules/dnc/service/impl/DeviceManagementServiceImpl.java @@ -5,7 +5,9 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import org.apache.shiro.SecurityUtils; import org.jeecg.common.api.vo.Result; +import org.jeecg.common.system.vo.LoginUser; import org.jeecg.modules.dnc.entity.DeviceManagement; import org.jeecg.modules.dnc.entity.DeviceType; import org.jeecg.modules.dnc.exception.ExceptionCast; @@ -143,10 +145,13 @@ */ @Override public Result<?> query(DeviceManagement deviceManagement, Integer pageNo, Integer pageSize){ + LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal(); + List<String> productIdList = Arrays.asList(user.getProductionIds().split(",")); QueryWrapper<DeviceManagement> queryWrapper = new QueryWrapper<>(); queryWrapper.eq(StrUtil.isNotEmpty(deviceManagement.getProductionId()),"production_id",deviceManagement.getProductionId()); queryWrapper.like(StrUtil.isNotEmpty(deviceManagement.getDeviceManagementName()),"device_management_name",deviceManagement.getDeviceManagementName()); queryWrapper.like(StrUtil.isNotEmpty(deviceManagement.getDeviceManagementCode()),"device_management_code",deviceManagement.getDeviceManagementCode()); + queryWrapper.in("production_id",productIdList); queryWrapper.orderByDesc("create_time"); Page<DeviceManagement> page = new Page<>(pageNo, pageSize); IPage<DeviceManagement> pageList = super.page(page, queryWrapper); -- Gitblit v1.9.3