From d043c31bbd34a01d6b3ab3f16e9404a7aca0bae4 Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期三, 13 九月 2023 17:27:52 +0800
Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/CanadaMes

---
 springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java |  331 +++++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 323 insertions(+), 8 deletions(-)

diff --git a/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java b/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java
index 4498c05..4e5c075 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java
@@ -1,21 +1,336 @@
 package com.example.springboot.service;
 
+import java.util.ArrayList;
+import java.util.List;
+
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 
+import com.example.springboot.common.Result;
+import com.example.springboot.component.S7control;
+import com.example.springboot.entity.Glass;
 import com.example.springboot.entity.StorageCage;
 import com.example.springboot.mapper.SpianMapper;
 
 @Service
 public class SpianService {
-    @Autowired
-    private SpianMapper spianMapper;
-    public void Save(StorageCage spian){
-        if(spian.getId()==null){
-            spianMapper.update();
-        }else{
-            spianMapper.update();
+  @Autowired
+  private SpianMapper spianMapper;
+
+  // @GetMapping("/all2")
+  public Result selectout(String orderid) {
+    // 瀹氫箟PRC鏁版嵁浼犻�佹暟缁�
+    List<String> adddresslist = new ArrayList<>();
+    adddresslist.add("DB105.6");// 鍑虹墖杞﹁捣濮嬩綅缃�
+    adddresslist.add("DB105.8");// 鍑虹墖杞︾洰鏍囦綅缃�
+    adddresslist.add("DB105.10");// 鍑虹墖绗肩幓鐠冩暟
+    adddresslist.add("DB105.14");// 鍑虹墖杞﹀惎鍔� 1涓哄惎鍔�
+    List<Short> datas = new ArrayList<>();
+    // 鑾峰彇浼樺厛鍑虹墖鐨勪綅缃�
+    StorageCage cageout = spianMapper.selectOut(orderid);
+    int cage = cageout.getCage(); // 鍌ㄥ瓨鍑虹墖浣嶇疆锛岀瀛愭牸瀛愬嚑鍙风幓鐠�
+    int cell = cageout.getCell();// 鍑虹墖鏍煎彿
+    int tier = cageout.getTier();// 鍑虹墖鍐呭鐗�
+    int prcid = cageout.getPrcId();// prcid
+    int prcid2;
+    int ids;
+    int cages;
+    int cells;
+    double glasswidth = cageout.getGlassWidth();
+    // 鍒ゆ柇鐜荤拑鍐呭鐗�
+    if (tier == 2) {
+      // 鍒ゆ柇鐜荤拑鍙洿鎺ュ嚭鐗囨椂
+      // 淇敼鏁版嵁搴撶瀛愯〃(鍑虹墖)
+      spianMapper.UpdataOutCage(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
+      spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 0);
+
+      datas.add((short) prcid);
+      datas.add((short) 1000);
+      datas.add((short) 1);
+      datas.add((short) 1);
+      S7control.getinstance().WriteWord(adddresslist, datas);
+      return Result.success(datas);
+    } else {
+      // 鑾峰彇鏍煎瓙鐨勭幓鐠冩暟閲�
+      int state = spianMapper.selectGlassState(cage, cell);
+      // 鍒ゆ柇鍐呯墖鏄惁闇�瑕佽皟鎷�
+      if (state == 0) {
+        spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 0);
+        datas.add((short) prcid);
+        datas.add((short) 1000);
+        datas.add((short) 1);
+        datas.add((short) 1);
+        S7control.getinstance().WriteWord(adddresslist, datas);
+        return Result.success("鐘舵�佷负0,鐩存帴鍑虹墖");
+      } else {
+        // 鐜荤拑闇�瑕佽皟鎷ㄦ椂锛屽垽鏂睘浜庡摢涓崐鍖虹殑绗煎瓙
+        if (cage < 6) {
+          StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 0, 6);
+          if (cagecell == null) {
+            return Result.success(cagecell);
+          }
+          // 鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧
+          prcid2 = cagecell.getPrcId();// 璋冩嫧鐩爣浣峆RCID
+          ids = cagecell.getId();// 璋冩嫧鐩爣浣岻D
+          cages = cagecell.getCage();// 璋冩嫧鐩爣浣嶇瀛�
+          cells = cagecell.getCell();// 璋冩嫧鐩爣浣嶆牸瀛�
+          // 鏇存崲鐜荤拑鐨勭瀛�
+          spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴�
+          spianMapper.UpdateDBCage(ids, cage, cell);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
+          spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 0);// 娓呴櫎鍘熸牸瀛愭暟鎹�
+          spianMapper.UpdataOutCage(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
+          // 濉叆璋冩嫧鏁版嵁
+          datas.add((short) prcid);// 璋冩嫧澶栫墖璧峰浣嶇疆
+          datas.add((short) prcid2);
+          datas.add((short) 2);
+          datas.add((short) 1);
+          // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
+          S7control.getinstance().WriteWord(adddresslist, datas);
+          datas.clear(); // 娓呯┖鏁翠釜鍒楄〃
+          // 鍒ゆ柇璋冩嫧缁撴潫鍚庡啀娆″嚭鐗�,濉叆鍑虹墖鏁版嵁
+          datas.add((short) prcid);
+          datas.add((short) 1000);
+          datas.add((short) 1);
+          datas.add((short) 1);
+          S7control.getinstance().WriteWord(adddresslist, datas);
+          // 淇敼鏁版嵁搴撶瀛愯〃(鍑虹墖)
+
+          return Result.success(cagecell); // 璋冩嫧浣嶇疆鐨勫弬鏁板唴瀹�
+
+        } else {// 绗煎瓙鍙峰ぇ浜�5鏃�
+          StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 5, 11);
+          if (cagecell == null) {
+            return Result.success(cagecell);
+          }
+          // 鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧
+          prcid2 = cagecell.getPrcId();// 璋冩嫧鐩爣浣峱rcID
+          ids = cagecell.getId();// 璋冩嫧鐩爣浣岻D
+          cages = cagecell.getCage();// 璋冩嫧鐩爣浣嶇瀛�
+          cells = cagecell.getCell();// 璋冩嫧鐩爣浣嶆牸瀛�
+          // 濉叆璋冩嫧鏁版嵁
+          datas.add((short) prcid);
+          datas.add((short) prcid2);
+          datas.add((short) 2);
+          datas.add((short) 1);
+          // 杞Щ鍘熻皟鎷ㄦ牸瀛愭暟鎹�
+          spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴�
+          spianMapper.UpdateDBCage(ids, cage, cell);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
+          spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 0);// 娓呴櫎鍘熸牸瀛愭暟鎹�
+          spianMapper.UpdataOutCage(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
+          // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
+          S7control.getinstance().WriteWord(adddresslist, datas);
+          datas.clear(); // 娓呯┖鏁翠釜鍒楄〃
+          // 鍒ゆ柇璋冩嫧缁撴潫鍚庡啀娆″嚭鐗�
+          // 濉叆鍑虹墖鏁版嵁
+          datas.add((short) prcid);
+          datas.add((short) 1000);
+          datas.add((short) 1);
+          datas.add((short) 1);
+          S7control.getinstance().WriteWord(adddresslist, datas);
+          return Result.success(cagecell); // 璋冩嫧浣嶇疆鐨勫弬鏁板唴瀹�
+
         }
+
+      }
     }
-    
+
+  }
+
+  // @GetMapping("/all")
+  // 杩涚墖浠诲姟,浼犺鍗昳d
+  // 鎸夎鍗曚紭鍏堣繘鐗�
+  public Short selectAll(Short glassid) {
+
+    int cage1;
+    int cells;
+    int ids;
+    int prcid;
+    int tiers;
+    int prctier;
+
+    Glass glasslist = spianMapper.selectGlass(glassid);
+    if (glasslist == null) {
+      return (300);
+    }
+    double widths = glasslist.getWidth();
+    Short orderids = glasslist.getOrderId();
+
+    List<String> adddresslist = new ArrayList<>();
+    adddresslist.add("DB105.0");// 杩涚墖杞﹁捣濮嬩綅缃�
+    adddresslist.add("DB105.2");// 杩涚墖杞︾洰鏍囦綅缃�
+    adddresslist.add("DB105.4");// 杩涚墖绗肩幓鐠冩暟
+    adddresslist.add("DB105.12");// 杩涚墖杞﹀惎鍔� 1涓哄惎鍔�
+    List<Short> datas = new ArrayList<>();
+
+    // String orderid="A001";
+    // 鑾峰彇璁㈠崟鐩稿叧搴︽渶楂樼殑绗煎瓙鎺掑簭
+    List<StorageCage> storageCage = spianMapper.selectAll(orderids);
+    if (storageCage == null) {
+      return (400);
+    }
+    for (StorageCage storageCage2 : storageCage) {
+      // 淇濆瓨璁㈠崟浼樺厛椤哄簭绗煎瓙鍙�
+      cage1 = storageCage2.getCage();
+      // 鍒ゆ柇璇ョ瀛愬彿鐩搁偦鏈�澶х殑绌烘牸鏁�
+      int cages = spianMapper.selectCage(cage1);
+      // 鍒ゆ柇閫変腑绗煎瓙鏄惁鏈夊悎閫傚搴︾┖鏍�
+      StorageCage cages1 = spianMapper.selectCage1(cage1, widths);
+      if (cages1 != null) {
+        ids = cages1.getId();// 鏁版嵁搴揑D
+        tiers = cages1.getTier();// 鍐呭鐗�
+        cells = cages1.getCell();// 鏍煎瓙鍙�
+        prcid = cages1.getPrcId();// 浼犵粰prc鐨勭洰鏍囧湴id
+        prctier = spianMapper.selectsum(cage1, cells);// 浼犵粰prc鐨勬牸瀛愬唴鐜荤拑鏁�
+        // 鏈夊悎閫傜┖鏍兼椂杩涚墖
+        if (cages > 1 && cages1.getTier() != null) {
+          // 鎵ц杩涚墖
+          datas.add((short) 1000);
+          datas.add((short) prcid);
+          datas.add((short) prctier);
+          datas.add((short) 1);
+          // 鏁版嵁搴撲慨鏀圭瀛愯〃鏂板涓�鏉＄幓鐠�
+          spianMapper.UpdataAddCage(orderids, glassid, widths, cage1, cells, ids, 1);
+          spianMapper.UpdataAddCage1(widths, cage1, cells);// 鍑忓皯鏍煎瓙瀹藉害
+          S7control.getinstance().WriteWord(adddresslist, datas);
+
+          return (200);
+        }
+      }
+
+    }
+    return (400);
+
+  }
+
+  // @GetMapping("/all2")
+  public Result selectout2(String glassid) {
+    // 瀹氫箟PRC鏁版嵁浼犻�佹暟缁�
+    List<String> adddresslist = new ArrayList<>();
+    adddresslist.add("DB105.6");// 鍑虹墖杞﹁捣濮嬩綅缃�
+    adddresslist.add("DB105.8");// 鍑虹墖杞︾洰鏍囦綅缃�
+    adddresslist.add("DB105.10");// 鍑虹墖绗肩幓鐠冩暟
+    adddresslist.add("DB105.14");// 鍑虹墖杞﹀惎鍔� 1涓哄惎鍔�
+    List<Short> datas = new ArrayList<>();
+    // 鑾峰彇浼樺厛鍑虹墖鐨勪綅缃�
+    StorageCage cageout = spianMapper.selectOut2(glassid);
+    int cage = cageout.getCage(); // 鍌ㄥ瓨鍑虹墖浣嶇疆锛岀瀛愭牸瀛愬嚑鍙风幓鐠�
+    int cell = cageout.getCell();// 鍑虹墖鏍煎彿
+    int tier = cageout.getTier();// 鍑虹墖鍐呭鐗�
+    int prcid = cageout.getPrcId();// prcid
+    int prcid2;
+    int ids;
+    int cages;
+    int cells;
+    double glasswidth = cageout.getGlassWidth();
+    // 鍒ゆ柇鐜荤拑鍐呭鐗�
+    if (tier == 2) {
+      // 鍒ゆ柇鐜荤拑鍙洿鎺ュ嚭鐗囨椂
+      // 淇敼鏁版嵁搴撶瀛愯〃(鍑虹墖)
+      spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 0);
+      spianMapper.UpdataOutCage(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
+      datas.add((short) prcid);
+      datas.add((short) 1000);
+      datas.add((short) 1);
+      datas.add((short) 1);
+      S7control.getinstance().WriteWord(adddresslist, datas);
+      return Result.success(datas);
+    } else {
+      // 鑾峰彇鏍煎瓙鐨勭幓鐠冩暟閲�
+      int state = spianMapper.selectGlassState(cage, cell);
+      // 鍒ゆ柇鍐呯墖鏄惁闇�瑕佽皟鎷�
+      if (state == 0) {
+        return Result.success("鐘舵�佷负0,鐩存帴鍑虹墖");
+      } else {
+        // 鐜荤拑闇�瑕佽皟鎷ㄦ椂锛屽垽鏂睘浜庡摢涓崐鍖虹殑绗煎瓙
+        if (cage < 6) {
+          StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 0, 6);
+          if (cagecell == null) {
+            return Result.success(cagecell);
+          }
+          // 鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧
+          prcid2 = cagecell.getPrcId();// 璋冩嫧鐩爣浣峆RCID
+          ids = cagecell.getId();// 璋冩嫧鐩爣浣岻D
+          cages = cagecell.getCage();// 璋冩嫧鐩爣浣嶇瀛�
+          cells = cagecell.getCell();// 璋冩嫧鐩爣浣嶆牸瀛�
+          // 鏇存崲鐜荤拑鐨勭瀛�
+          spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴�
+          spianMapper.UpdateDBCage(ids, cage, cell);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
+          spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 0);// 娓呴櫎鍘熸牸瀛愭暟鎹�
+          spianMapper.UpdataOutCage(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
+          // 濉叆璋冩嫧鏁版嵁
+          datas.add((short) prcid);// 璋冩嫧澶栫墖璧峰浣嶇疆
+          datas.add((short) prcid2);
+          datas.add((short) 2);
+          datas.add((short) 1);
+          // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
+          S7control.getinstance().WriteWord(adddresslist, datas);
+          datas.clear(); // 娓呯┖鏁翠釜鍒楄〃
+          // 鍒ゆ柇璋冩嫧缁撴潫鍚庡啀娆″嚭鐗�,濉叆鍑虹墖鏁版嵁
+          datas.add((short) prcid);
+          datas.add((short) 1000);
+          datas.add((short) 1);
+          datas.add((short) 1);
+          S7control.getinstance().WriteWord(adddresslist, datas);
+          // 淇敼鏁版嵁搴撶瀛愯〃(鍑虹墖)
+
+          return Result.success(cagecell); // 璋冩嫧浣嶇疆鐨勫弬鏁板唴瀹�
+
+        } else {// 绗煎瓙鍙峰ぇ浜�5鏃�
+          StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 5, 11);
+          if (cagecell == null) {
+            return Result.success(cagecell);
+          }
+          // 鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧
+          prcid2 = cagecell.getPrcId();// 璋冩嫧鐩爣浣峱rcID
+          ids = cagecell.getId();// 璋冩嫧鐩爣浣岻D
+          cages = cagecell.getCage();// 璋冩嫧鐩爣浣嶇瀛�
+          cells = cagecell.getCell();// 璋冩嫧鐩爣浣嶆牸瀛�
+
+          // 濉叆璋冩嫧鏁版嵁
+          datas.add((short) prcid);
+          datas.add((short) prcid2);
+          datas.add((short) 2);
+          datas.add((short) 1);
+          // 杞Щ鍘熻皟鎷ㄦ牸瀛愭暟鎹�
+          spianMapper.UpdateDBCage(ids, cage, cell);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
+          spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴�
+          spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 0);// 娓呴櫎鍘熸牸瀛愭暟鎹�
+          spianMapper.UpdataOutCage(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
+          // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
+          S7control.getinstance().WriteWord(adddresslist, datas);
+          datas.clear(); // 娓呯┖鏁翠釜鍒楄〃
+          // 鍒ゆ柇璋冩嫧缁撴潫鍚庡啀娆″嚭鐗�
+          // 濉叆鍑虹墖鏁版嵁
+          datas.add((short) prcid);
+          datas.add((short) 1000);
+          datas.add((short) 1);
+          datas.add((short) 1);
+          S7control.getinstance().WriteWord(adddresslist, datas);
+          return Result.success(cagecell); // 璋冩嫧浣嶇疆鐨勫弬鏁板唴瀹�
+
+        }
+
+      }
+    }
+
+  }
+
+  /*** 淇敼鐢ㄦ埛* @throws SQLException */
+  // public static int updateUser(Glass user) throws SQLException {conn =
+  // getConn();
+  // String sql = "update t_user set name=?,gender=?,age=?,score=?"+ " where
+  // id=?";ps = conn.prepareStatement(sql);
+  // ps.setString(1, user.getName());ps.setString(2, user.getGender());
+  // ps.setInt(3, user.getAge());ps.setDouble(4, user.getScore());ps.setInt(5,
+  // user.getId());return ps.executeUpdate();}
+  // /*** 澧炲姞鐢ㄦ埛* @throws SQLException */
+  // public static int insertUser(User user) throws SQLException {
+  // conn = getConn();
+  // String sql = "insert into t_user(name,gender,age,score)"+ " values(?,?,?,?)";
+  // ps = conn.prepareStatement(sql);ps.setString(1,
+  // user.getName());ps.setString(2, user.getGender());
+  // ps.setInt(3, user.getAge());ps.setDouble(4, user.getScore());return
+  // ps.executeUpdate();
+  // }
+
 }

--
Gitblit v1.8.0