From b6b46e1c4d390c80cf9bd7d4daa23202f2d11a22 Mon Sep 17 00:00:00 2001 From: Junjie <fallin.jie@qq.com> Date: 星期五, 26 五月 2023 13:47:57 +0800 Subject: [PATCH] 站点管理编辑高低库位 --- src/main/java/com/zy/asrs/service/impl/StaDescServiceImpl.java | 66 +++++++++++++++++++++++++++++++++ 1 files changed, 66 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/service/impl/StaDescServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/StaDescServiceImpl.java index 38c9dd1..adb917a 100644 --- a/src/main/java/com/zy/asrs/service/impl/StaDescServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/StaDescServiceImpl.java @@ -1,6 +1,10 @@ package com.zy.asrs.service.impl; +import com.baomidou.mybatisplus.mapper.EntityWrapper; +import com.baomidou.mybatisplus.mapper.Wrapper; import com.baomidou.mybatisplus.service.impl.ServiceImpl; +import com.core.common.Cools; +import com.core.exception.CoolException; import com.zy.asrs.entity.StaDesc; import com.zy.asrs.mapper.StaDescMapper; import com.zy.asrs.service.StaDescService; @@ -15,4 +19,66 @@ public List<Integer> queryOutStaNosByLocNo(String locNo, Integer typeNo) { return this.baseMapper.queryOutStaNosByLocNo(locNo, typeNo); } + + @Override + public StaDesc queryCrnStn(Integer typeNo, Integer crnNo, Integer stnNo, Integer row1) { + StaDesc staDesc = null; + if(crnNo==2){ + Integer sourceStaNo = 204; + switch (stnNo){ + case 100: + sourceStaNo = 104; + break; + case 200: + sourceStaNo = 204; + break; + case 300: + sourceStaNo = row1 < 12 ? 104 : 204; + break; + } + Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>() + .eq("type_no", typeNo) + .eq("stn_no", stnNo) + .eq("crn_no", crnNo) + .eq("crn_stn", sourceStaNo); + staDesc = this.selectOne(wrapper); + } else { + Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>() + .eq("type_no", typeNo) + .eq("stn_no", stnNo) + .eq("crn_no", crnNo); + staDesc = this.selectOne(wrapper); + } + if (staDesc == null) { + throw new CoolException("鍑哄簱璺緞涓嶅瓨鍦�"); + } + return staDesc; + } + + @Override + public StaDesc queryCrnStnAuto(Integer typeNo, Integer crnNo, Integer stnNo) { + Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>() + .eq("type_no", typeNo) + .eq("stn_no", stnNo) + .eq("crn_no", crnNo); + StaDesc staDesc = this.selectOne(wrapper); + if (staDesc == null) { + wrapper = new EntityWrapper<StaDesc>() + .eq("type_no", typeNo) + .eq("crn_no", crnNo); + List<StaDesc> staDescs = this.selectList(wrapper); + if (Cools.isEmpty(staDescs)) { + throw new CoolException("鍑哄簱璺緞涓嶅瓨鍦�"); + } + // todo:luxiaotao + return staDescs.get(0); + } + return staDesc; + } + + @Override + public StaDesc queryCrnStn(Integer crnNo) { + return this.baseMapper.queryCrnStn(crnNo); + } + } -- Gitblit v1.9.1