From 6bad812c69f2adbcc7ffc386e18db701f5c8fe93 Mon Sep 17 00:00:00 2001 From: 野心家 <1051256694@qq.com> Date: 星期六, 21 十二月 2024 15:22:06 +0800 Subject: [PATCH] 找库位:深浅一起找 --- src/main/java/com/zy/asrs/controller/BasDevpController.java | 44 ++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 44 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/BasDevpController.java b/src/main/java/com/zy/asrs/controller/BasDevpController.java index cd89e40..d69797b 100644 --- a/src/main/java/com/zy/asrs/controller/BasDevpController.java +++ b/src/main/java/com/zy/asrs/controller/BasDevpController.java @@ -5,7 +5,10 @@ import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.baomidou.mybatisplus.mapper.Wrapper; import com.baomidou.mybatisplus.plugins.Page; +import com.core.exception.CoolException; import com.zy.asrs.entity.BasDevp; +import com.zy.asrs.entity.param.BasDevpInitParam; +import com.zy.asrs.mapper.BasDevpMapper; import com.zy.asrs.service.BasDevpService; import com.zy.common.web.BaseController; import com.core.annotations.ManagerAuth; @@ -13,6 +16,9 @@ import com.core.common.Cools; import com.core.common.DateUtils; import com.core.common.R; +import org.apache.ibatis.session.ExecutorType; +import org.apache.ibatis.session.SqlSession; +import org.apache.ibatis.session.SqlSessionFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; @@ -23,6 +29,44 @@ @Autowired private BasDevpService basDevpService; + @Autowired + private SqlSessionFactory sqlSessionFactory; + + @RequestMapping(value = "/basDevp/init/auth") + @ManagerAuth(memo = "鍒濆鍖栫珯鐐�") + public R init(BasDevpInitParam param) { + List<BasDevp> list = new ArrayList<>(); + SqlSession sqlSession = null; + try { + sqlSession = sqlSessionFactory.openSession(ExecutorType.SIMPLE,false); + BasDevpMapper sessionMapper = sqlSession.getMapper(BasDevpMapper.class); + for (int devNo = param.getStartDev() ; devNo<=param.getEndDev() ; devNo++){ + BasDevp basDevp = basDevpService.selectById(devNo); + if (Cools.isEmpty(basDevp)){ + BasDevp basDevp1 = new BasDevp(); + basDevp1.setDevNo(devNo); + basDevp1.setInEnable("Y"); + basDevp1.setOutEnable("Y"); + basDevp1.setAutoing("Y"); + basDevp1.setLoading("Y"); + basDevp1.setCanining("Y"); + basDevp1.setCanouting("Y"); + basDevp1.setModiUser(getUserId()); + basDevp1.setModiTime(new Date()); + sessionMapper.insert(basDevp1); +// list.add(basDevp1); + } + } + sqlSession.flushStatements(); + sqlSession.clearCache(); + }catch (Exception e) { + throw new CoolException(e.getMessage()); + }finally { + sqlSession.close(); + return R.ok("鍒濆鍖栨垚鍔�"); + } + + } @RequestMapping(value = "/basDevp/{id}/auth") @ManagerAuth -- Gitblit v1.9.1