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