From 6c584c489a317cee78729707890db4bb1ee3f062 Mon Sep 17 00:00:00 2001 From: ZengTao <2773468879@qq.com> Date: 星期三, 29 五月 2024 14:33:36 +0800 Subject: [PATCH] 修改进片找格子的判断 --- springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java | 357 +++++++++++++++++++++++++++++++++++++++++++++-------------- 1 files changed, 273 insertions(+), 84 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 8c127a6..ed6791b 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,6 +1,13 @@ package com.example.springboot.service; +import java.io.BufferedReader; +import java.io.FileInputStream; +import java.io.FileNotFoundException; +import java.io.IOException; +import java.io.InputStreamReader; +import java.io.UnsupportedEncodingException; import java.nio.charset.StandardCharsets; +import java.time.LocalDateTime; import java.util.ArrayList; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; @@ -8,6 +15,7 @@ import com.example.springboot.component.S7control; import com.example.springboot.entity.StorageCage; import com.example.springboot.entity.north_glass_buffer1; +import com.example.springboot.mapper.HomeMapper; import com.example.springboot.mapper.SpianMapper; import com.google.common.primitives.Bytes; @@ -15,11 +23,15 @@ public class SpianService { @Autowired private SpianMapper spianMapper; - + @Autowired + private HomeMapper homeMapper; + public static List<String> result=new ArrayList<String>(); // @GetMapping("/all") - public Short selectAll(String glassid) { - - int cage1; + public Short selectAll(north_glass_buffer1 glasslist) { + try { + + + int cage1 = 0; int cells; int ids; int prcid; @@ -27,14 +39,23 @@ int prctier; double width; double minwidth = 0; - - north_glass_buffer1 glasslist = spianMapper.selectGlass(glassid); // 鑾峰彇鐜荤拑鍙傛暟 + double widths; + // north_glass_buffer1 glasslist = spianMapper.selectGlass(glassid); // 鑾峰彇鐜荤拑鍙傛暟 + // 濡傛灉娌℃湁姝d鏃� if (glasslist == null) { return (300); } - double widths = glasslist.getglasslengthmm(); - String orderids = glasslist.getordernumber(); + if(glasslist.getglasslengthmm()>glasslist.getglassheightmm()) { + widths= glasslist.getglasslengthmm(); + }else{ + widths= glasslist.getglassheightmm(); + } + // Map result=new HashMap(); + + String orderids = glasslist.getordernumber(); + String FrameBarcode = glasslist.getFrameBarcode(); + String glassid = glasslist.getbarcode(); List<String> adddresslist = new ArrayList<>(); adddresslist.add("DB105.0");// 杩涚墖杞﹁捣濮嬩綅缃� adddresslist.add("DB105.2");// 杩涚墖杞︾洰鏍囦綅缃� @@ -45,8 +66,14 @@ List<Short> datas = new ArrayList<>(); // String orderid="A001"; - // 鑾峰彇璁㈠崟鐩稿叧搴︽渶楂樼殑绗煎瓙鎺掑簭 - List<StorageCage> storageCage = spianMapper.selectAll(orderids.toString()); + // 鑾峰彇閾濇鐩稿叧搴︽渶楂樼殑绗煎瓙鎺掑簭 + List<StorageCage> storageCage = spianMapper.selectAllFbarcode(FrameBarcode, widths, 600); + // 鍒ゆ柇閾濇鎸囧畾绌烘牸鏄惁闇�瑕侀棿闅旂┖闂� + + if (storageCage.size() == 0) { + storageCage = spianMapper.selectAll(orderids, FrameBarcode); + } + if (storageCage == null) { return (400); } @@ -54,24 +81,29 @@ // 淇濆瓨璁㈠崟浼樺厛椤哄簭绗煎瓙鍙� cage1 = storageCage2.getCage(); // 鍒ゆ柇璇ョ瀛愬彿鐩搁偦鏈�澶х殑绌烘牸鏁� - int cages = spianMapper.selectCage(cage1); + StorageCage cages = spianMapper.selectCage(cage1); + + // 濡傛灉鐩搁偦绗煎瓙娌℃湁绌烘牸,鎴栬�呮湁姝e湪鎵ц鐨勫嚭鐗囦换鍔℃椂杩斿洖400 + if (cages == null) { + return (400); + } StorageCage cages1; // 鍒ゆ柇鏄惁鏄浜岀墖闇�瑕佸姞闂撮殧鐗� prctier = spianMapper.selectsum(cage1, storageCage2.getCell());// 浼犵粰prc鐨勬牸瀛愬唴鐜荤拑鏁� if (prctier > 0) { - cages1 = spianMapper.selectCage1(cage1, storageCage2.getCell(), widths + 400); + cages1 = spianMapper.selectCage1(cage1, storageCage2.getCell(), widths + 600); } else { cages1 = spianMapper.selectCage1(cage1, storageCage2.getCell(), widths); } // 鍒ゆ柇閫変腑绗煎瓙鏄惁鏈夊悎閫傚搴︾┖鏍� // 鏈夊悎閫傜┖鏍兼椂杩涚墖 - if (cages1 != null && cages >= 1 && storageCage2.getDisabled() == 0) { + if (cages1 != null && cages.getCell() >= 1 && storageCage2.getDisabled() == 0) { ids = cages1.getId();// 鏁版嵁搴揑D tiers = cages1.getTier();// 鍐呭鐗� cells = cages1.getCell();// 鏍煎瓙鍙� prcid = cages1.getPrcId();// 浼犵粰prc鐨勭洰鏍囧湴id width = cages1.getWidth();// 鏍煎瓙鍓╀綑瀹藉害 - widths = glasslist.getglasslengthmm(); + // 鎵ц杩涚墖 datas.add((short) 1000);// 璧峰浣嶇疆 @@ -82,38 +114,66 @@ // 鑾峰彇璇ユ牸瀛愬唴鏄惁鏈夌幓鐠� int cellint = spianMapper.selectcell(cage1, cells); if (cellint == 1) { - // 灏嗗鐗囩幓鐠冪殑鏁版嵁鏇存柊鍒板唴鐗� - spianMapper.UpdateDBCage(ids, cage1, cells, 1); - // 灏嗘柊鍏ョ殑鐜荤拑瀛樺叆澶栫墖 - // spianMapper.UpdataAddCage(orderids, glassid, widths, cage1, cells, ids-1, 2); - spianMapper.UpdataAddCage2(orderids, glassid, glasslist, cage1, cells, ids - 1, 2); - spianMapper.UpdataAddCage1(widths, cage1, cells);// 鍑忓皯鏍煎瓙瀹藉害 - spianMapper.Inserttask(0, 0, 1000, ids, glassid.toString(), prctier);// 鏂板浠诲姟 + result.add("杩涚墖浠诲姟|feedstart1:" + datas+ LocalDateTime.now()); + outmesid(glassid, "DB105.20"); S7control.getinstance().WriteWord(adddresslist, datas); - System.out.println("鍑虹墖浠诲姟|" + datas); + boolean qidong = listbool("DB105.16"); + int qidong2 = 0; + if (qidong == true) { + qidong2 = 1; + } else { + while (qidong) { + S7control.getinstance().WriteWord("DB105.16", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + qidong = listbool("DB105.16"); + } + } + // 灏嗗鐗囩幓鐠冪殑鏁版嵁鏇存柊鍒板唴鐗� + spianMapper.UpdateDBCageAdd(ids, cage1, cells, 1); + // 灏嗘柊鍏ョ殑鐜荤拑瀛樺叆澶栫墖 + spianMapper.UpdataAddCage2(orderids, glassid, glasslist, cage1, cells, ids - 1, 2,widths); + spianMapper.UpdataAddCage1(widths, cage1, cells);// 鍑忓皯鏍煎瓙瀹藉害 + spianMapper.Inserttask(0, 0, 1000, ids, glassid.toString(), prctier, qidong2);// 鏂板浠诲姟 + result.add("杩涚墖浠诲姟|feedend1" + datas+ LocalDateTime.now()); + } else { // 鏁版嵁搴撲慨鏀圭瀛愯〃鏂板涓�鏉$幓鐠� - // spianMapper.UpdataAddCage(orderids, glassid, widths, cage1, cells, ids, 2); - spianMapper.UpdataAddCage2(orderids, glassid, glasslist, cage1, cells, ids, 2); + result.add("杩涚墖浠诲姟|feedstart2" + datas+ LocalDateTime.now()); + outmesid(glassid, "DB105.20"); + S7control.getinstance().WriteWord(adddresslist, datas); + boolean qidong = listbool("DB105.16"); + int qidong2 = 0; + if (qidong == true) { + qidong2 = 1; + } else { + while (qidong) { + S7control.getinstance().WriteWord("DB105.16", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + qidong = listbool("DB105.16"); + } + } + spianMapper.UpdataAddCage2(orderids, glassid, glasslist, cage1, cells, ids, 2,widths); spianMapper.UpdataAddCage1(widths, cage1, cells);// 鍑忓皯鏍煎瓙瀹藉害 - spianMapper.Inserttask(0, 0, 1000, ids, glassid.toString(), prctier);// 鏂板浠诲姟 - S7control.getinstance().WriteWord(adddresslist, datas); - System.out.println("鍑虹墖浠诲姟|" + datas); + spianMapper.Inserttask(0, 0, 1000, ids, glassid.toString(), prctier, qidong2);// 鏂板浠诲姟 + result.add("杩涚墖浠诲姟|feedend2" + datas+ LocalDateTime.now()); - // S7control.getinstance().WriteByte("DB105.16",glassid); } - outmesid(glassid, "DB105.20"); + return (200); } } return (400); + } catch (Exception e) { + e.printStackTrace(); + return (500); + // TODO: handle exception + } } public Short selectout2(String glassid) { + try { // 瀹氫箟PRC鏁版嵁浼犻�佹暟缁� List<String> adddresslist = new ArrayList<>(); char[] a = glassid.toCharArray(); @@ -138,6 +198,7 @@ int cages; int cells; double glasswidth = cageout.getGlassWidth(); + // 鍒ゆ柇鐜荤拑鍐呭鐗� if (tier == 2) { int state = spianMapper.selectGlassState(cage, cell);// 鑾峰彇鏍煎瓙鏁伴噺 @@ -147,20 +208,26 @@ datas.add((short) 1000); datas.add((short) state); datas.add((short) 1); - spianMapper.OverOutSlice(glassid, 1);// 鏇存柊鍑虹墖闃熷垪浠诲姟鐘舵�佷负杩涜涓� + spianMapper.OverOutSlice(glassid.toString(), 1, 0);// 鏇存柊鍑虹墖闃熷垪浠诲姟鐘舵�佷负杩涜涓� spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� - spianMapper.UpdataGlassCageState(glassid, 3);// 鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵�� + spianMapper.UpdataGlassCageState(glassid.toString(), 3);// 鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵�� - spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid, state);// 鏂板浠诲姟 - // int state = spianMapper.selectGlassState(cage, cell);//鑾峰彇鏍煎瓙鏁伴噺 - if (state == 2) { - spianMapper.UpdateDBCage1(cage, cell);// 灏嗗唴鐗囨暟鎹洿鏂板埌澶栫墖閲� - spianMapper.UpdateDBCage2(cage, cell);// 娓呴櫎鍐呯墖鏁版嵁 - } - System.out.println("鍑虹墖浠诲姟|" + datas); + result.add("鍑虹墖浠诲姟|outstart1" + datas+ LocalDateTime.now()); S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� + //S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + boolean qidong = listbool("DB105.18"); + int qidong2 = 0; + if (qidong == true) { + qidong2 = 1; + } else { + while (qidong) { + S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + qidong = listbool("DB105.18"); + } + } + spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid, state, qidong2);// 鏂板浠诲姟 outmesid(glassid, "DB105.34");// 娲惧彂鍑虹墖ID - + result.add("鍑虹墖浠诲姟|outend1" + datas+ LocalDateTime.now()); return (200);// 缁撴潫 } else { // 鑾峰彇鏍煎瓙鐨勭幓鐠冩暟閲� @@ -172,21 +239,31 @@ datas.add((short) 1000); datas.add((short) 1); datas.add((short) 1); - spianMapper.OverOutSlice(glassid, 1);// 鏇存柊鍑虹墖闃熷垪浠诲姟鐘舵�佷负杩涜涓� - spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid, 1);// 鏂板浠诲姟 - spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� - spianMapper.UpdataGlassCageState(glassid, 3);// 鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵�� - spianMapper.OverOutSlice(glassid, 1);// 鏇存柊鍑虹墖闃熷垪浠诲姟 - System.out.println("鍑虹墖浠诲姟|" + datas); + result.add("鍑虹墖浠诲姟|outstart2" + datas+ LocalDateTime.now()); outmesid(glassid, "DB105.34");// 娲惧彂鍑虹墖ID S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� - + //S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + boolean qidong = listbool("DB105.18"); + int qidong2 = 0; + if (qidong == true) { + qidong2 = 1; + } else { + while (qidong) { + S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + qidong = listbool("DB105.18"); + } + } + spianMapper.OverOutSlice(glassid.toString(), 1, 0);// 鏇存柊鍑虹墖闃熷垪浠诲姟鐘舵�佷负杩涜涓� + spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� + spianMapper.UpdataGlassCageState(glassid, 3);// 鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵�� + spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid, 1, qidong2);// 鏂板浠诲姟 + result.add("鍑虹墖浠诲姟|outend2" + datas+ LocalDateTime.now()); return (200);// 缁撴潫 } else { // 鐜荤拑闇�瑕佽皟鎷ㄦ椂锛屽垽鏂睘浜庡摢涓崐鍖虹殑绗煎瓙 if (cage < 6) { - StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 0, 6); + StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 0, 6, cell); if (cagecell == null) { return (300); } @@ -202,23 +279,33 @@ datas.add((short) 2); datas.add((short) 1); // 鏇存崲鐜荤拑鐨勭瀛� - spianMapper.UpdataGlassCageState(glassid, 3);// 鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵�� - String glassids = spianMapper.SelectGlassid(cage, cell); // 鑾峰彇琚皟鎷ㄧ殑鐜荤拑id - spianMapper.UpdateDBCage(ids, cage, cell, 2);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲� - spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴� - spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� - //spianMapper.UpdataGlassCageState(glassids, 3);// 鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵�� - spianMapper.Inserttask(2, 0, cageout.getId(), ids, glassid, 2);// 鏂板璋冨害浠诲姟 - // spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid);// 鏂板鍑虹墖浠诲姟 - // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹� - System.out.println("鍑虹墖浠诲姟|" + datas); - S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� + StorageCage glassids = spianMapper.SelectGlassid(cage, cell); // 鑾峰彇琚皟鎷ㄧ殑鐜荤拑id - outmesid(glassids, "DB105.34");// 娲惧彂璋冩嫧鐜荤拑ID + // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹� + result.add("鍑虹墖浠诲姟|outstart3" + datas+ LocalDateTime.now()); + outmesid(glassids.getGlassId(), "DB105.34");// 娲惧彂璋冩嫧鐜荤拑ID + S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� + //S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + boolean qidong = listbool("DB105.18"); + int qidong2 = 0; + if (qidong == true) { + qidong2 = 1; + } else { + while (qidong) { + S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + qidong = listbool("DB105.18"); + } + } + spianMapper.UpdataGlassCageState(glassids.getGlassId(), 3);// 鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵�� + spianMapper.UpdateDBCage(ids, cage, cell, 2);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲� + spianMapper.UpdataAddCage1(glassids.getGlassWidth(), cages, cells);// 鍑忓皯鏂版牸瀛愬搴� + spianMapper.UpdataOutCage1(glassids.getGlassWidth(), cage, cell);// 澧炲姞鍘熸牸瀛愬搴� + spianMapper.Inserttask(2, 0, cageout.getId(), ids, glassids.getGlassId(), 2, qidong2);// 鏂板璋冨害浠诲姟 + result.add("鍑虹墖浠诲姟|outend3" + datas+ LocalDateTime.now()); return (200); // 缁撴潫 } else {// 绗煎瓙鍙峰ぇ浜�5鏃� - StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 5, 11); + StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 5, 11, cell); if (cagecell == null) { return (300); } @@ -232,28 +319,45 @@ datas.add((short) prcid2); datas.add((short) 2); datas.add((short) 1); - String glassids = spianMapper.SelectGlassid(cage, cell); // 鑾峰彇琚皟鎷ㄧ殑鐜荤拑id - spianMapper.UpdataGlassCageState(glassid, 3);// 鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵�� - spianMapper.Inserttask(2, 0, cageout.getId() + 1, ids, glassid, 2);// 鏂板璋冨害浠诲姟 - // spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid);// 鏂板鍑虹墖浠诲姟 - spianMapper.UpdateDBCage(ids, cage, cell, 2);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲� - spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴� - spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� + StorageCage glassids = spianMapper.SelectGlassid(cage, cell); // 鑾峰彇琚皟鎷ㄧ殑鐜荤拑id // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹� - System.out.println("鍑虹墖浠诲姟|" + datas); + result.add("鍑虹墖浠诲姟|outstart4" + datas+ LocalDateTime.now()); + outmesid(glassids.getGlassId(), "DB105.34");// 娲惧彂璋冩嫧鐜荤拑ID S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� - - outmesid(glassids, "DB105.34");// 娲惧彂璋冩嫧鐜荤拑ID + //S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + boolean qidong = listbool("DB105.18"); + int qidong2 = 2; + if (qidong == true) { + qidong2 = 1; + } else { + while (qidong) { + S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + qidong = listbool("DB105.18"); + } + } + spianMapper.UpdataGlassCageState(glassids.getGlassId(), 3);// 鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵�� + spianMapper.UpdateDBCage(ids, cage, cell, 2);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲� + spianMapper.UpdataAddCage1(glassids.getGlassWidth(), cages, cells);// 鍑忓皯鏂版牸瀛愬搴� + spianMapper.UpdataOutCage1(glassids.getGlassWidth(), cage, cell);// 澧炲姞鍘熸牸瀛愬搴� + spianMapper.Inserttask(2, 0, cageout.getId() + 1, ids, glassids.getGlassId(), 2, qidong2);// 鏂板璋冨害浠诲姟 + result.add("鍑虹墖浠诲姟|outend4" + datas+ LocalDateTime.now()); return (200);// 缁撴潫 } } } - + } catch (Exception e) { + e.printStackTrace(); + return (500); + // TODO: handle exception } +} // 娲惧彂浠诲姟鐜荤拑id public void outmesid(String glassid, String address) { + try { + + // System.out.println("outmesid:" + glassid); List<Byte> glassidlist = new ArrayList(); char ds[] = glassid.toCharArray(); @@ -263,6 +367,9 @@ byte[] bytes = Bytes.toArray(glassidlist); System.out.println("outmesidbytes:" + bytes.length); S7control.getinstance().WriteByte(address, bytes);// 娲惧彂鍑虹墖id + } catch (Exception e) { + e.printStackTrace(); + } } // 鑾峰彇鍦板潃鍐呯殑鐜荤拑id杞瓧绗︿覆 @@ -299,20 +406,102 @@ // 鏍规嵁鐜荤拑id瀹屾垚鍦ㄨ繘琛屼腑鐨勪换鍔� public void overtask(String glassid) { + + spianMapper.UpdatetaskOut(glassid.toString());// 瀹屾垚涓婁竴娆� 鍑虹墖鎴栬�呰繘鐗囦换鍔� + spianMapper.OverOutSlice(glassid.toString(), 2, 1);// 瀹屾垚鍑虹墖闃熷垪浠诲姟 + spianMapper.UpdataGlassCage(glassid.toString(), 0);// 娓呴櫎鍑虹墖鏍煎瓙鐜荤拑淇℃伅 + spianMapper.UpdateCageOver(glassid.toString(), 0);// 鏇存敼绗煎瓙琛ㄥ嚭鐗囩姸鎬� + spianMapper.UpdateCageadd(glassid.toString(), 1);// 鏇存敼绗煎瓙琛ㄨ繘鐗囩姸鎬� + String barcode = spianMapper.SelectBarcode(glassid.toString());// 鑾峰彇璇ョ幓鐠冪殑閾濇id + //spianMapper.UpdateAddQueue(glassid.toString());// 鎶婅繘鐗囩殑鐜荤拑鏇存柊鍒板嚭鐗囬槦鍒椾腑 - spianMapper.UpdatetaskOut(glassid); // 瀹屾垚涓婁竴娆″嚭鐗囨垨鑰呰繘鐗囦换鍔� - spianMapper.OverOutSlice(glassid, 2);// 瀹屾垚鍑虹墖闃熷垪浠诲姟 - spianMapper.UpdataGlassCage(glassid, 0);// 娓呴櫎鍑虹墖鏍煎瓙鐜荤拑淇℃伅 - spianMapper.UpdateCageOver(glassid, 0);// 鏇存敼绗煎瓙琛ㄥ嚭鐗囩姸鎬� - spianMapper.UpdateCageadd(glassid,1); - String barcode = spianMapper.SelectBarcode(glassid);// 鑾峰彇璇ョ幓鐠冪殑閾濇id - spianMapper.UpdateAddQueue(glassid);// 鎶婅繘鐗囩殑鐜荤拑鏇存柊鍒板嚭鐗囬槦鍒椾腑 - if (barcode != null) { - int barcodeState = spianMapper.SelectOverState(barcode);// 鑾峰彇璇ラ摑妗嗙殑鐘舵�� - if (barcodeState == 2) {// 褰撹閾濇鎵�鏈夌殑鐜荤拑閮芥槸瀹屾垚鐘舵�佹椂鍒犻櫎鍦ㄥ嚭鐗囬槦鍒楃殑鏁版嵁 - spianMapper.DeleteQueue(barcode); - } - } } + + + public Short selectAlls(north_glass_buffer1 glasslist) { + try { + + int cage1 = 0; + int cells; + int ids; + int prcid; + int tiers; + int prctier; + double width; + double minwidth = 0; + double widths; + // north_glass_buffer1 glasslist = spianMapper.selectGlass(glassid); // 鑾峰彇鐜荤拑鍙傛暟 + // 濡傛灉娌℃湁姝d鏃� + if (glasslist == null) { + return (300); + } + //鍒ゆ柇鏄惁瀛樺湪绗煎瓙閲� + short result = homeMapper.SelectStorageByGlassId(glasslist.getbarcode()); + if (result > 0) { + return (500); + } + + + if(glasslist.getglasslengthmm()>glasslist.getglassheightmm()) { + widths= glasslist.getglasslengthmm(); + }else{ + widths= glasslist.getglassheightmm(); + } + // Map result=new HashMap(); + + + String orderids = glasslist.getordernumber(); + String FrameBarcode = glasslist.getFrameBarcode(); + String glassid = glasslist.getbarcode(); + + + // String orderid="A001"; + // 鑾峰彇閾濇鐩稿叧搴︽渶楂樼殑绗煎瓙鎺掑簭 + List<StorageCage> storageCage = spianMapper.selectAllFbarcode(FrameBarcode, widths, 400); + // 鍒ゆ柇閾濇鎸囧畾绌烘牸鏄惁闇�瑕侀棿闅旂┖闂� + + if (storageCage.size() == 0) { + storageCage = spianMapper.selectAll(orderids, FrameBarcode); + } + + if (storageCage == null) { + return (400); + } + for (StorageCage storageCage2 : storageCage) { + // 淇濆瓨璁㈠崟浼樺厛椤哄簭绗煎瓙鍙� + cage1 = storageCage2.getCage(); + // 鍒ゆ柇璇ョ瀛愬彿鐩搁偦鏈�澶х殑绌烘牸鏁� + StorageCage cages = spianMapper.selectCage(cage1); + + // 濡傛灉鐩搁偦绗煎瓙娌℃湁绌烘牸,鎴栬�呮湁姝e湪鎵ц鐨勫嚭鐗囦换鍔℃椂杩斿洖400 + if (cages == null) { + return (400); + } + StorageCage cages1; + // 鍒ゆ柇鏄惁鏄浜岀墖闇�瑕佸姞闂撮殧鐗� + prctier = spianMapper.selectsum(cage1, storageCage2.getCell());// 浼犵粰prc鐨勬牸瀛愬唴鐜荤拑鏁� + if (prctier > 0) { + cages1 = spianMapper.selectCage1(cage1, storageCage2.getCell(), widths + 400); + } else { + cages1 = spianMapper.selectCage1(cage1, storageCage2.getCell(), widths); + } + // 鍒ゆ柇閫変腑绗煎瓙鏄惁鏈夊悎閫傚搴︾┖鏍� + // 鏈夊悎閫傜┖鏍兼椂杩涚墖 + if (cages1 != null && cages.getCell() >= 1 && storageCage2.getDisabled() == 0) { + + return (0); + + } + + } + return (400); + } catch (Exception e) { + e.printStackTrace(); + return (500); + // TODO: handle exception + } + + } + } -- Gitblit v1.8.0