客户数据库变更，部分铝框没有对应玻璃信息，扫码添加出片队列时，当铝框没有对应玻璃时直接添加到出片队列

ZengTao

2024-05-11 625d2b6dd9bd4a1c63bf7e1b2701393d908f7a81

客户数据库变更，部分铝框没有对应玻璃信息，扫码添加出片队列时，当铝框没有对应玻璃时直接添加到出片队列

 springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java

@@ -117,6 +117,43 @@
                // }

                // }

                // }

                // String frameno ="X226422133V";

                //     if (!frameno.equals(Plchome.FrameNo)) {

                //         Plchome.FrameNo = frameno;

                //         try {

                //             Short num = 0;

                //             List<north_glass_buffer1> north_glass_buffer1s = north_Glass_Buffer1Service

                //                     .SelectAluminumFrameInfoById(Plchome.FrameNo);

                //             for (north_glass_buffer1 north_glass_buffer1 : north_glass_buffer1s) {

                //                 if (north_glass_buffer1.getstorageCage() == null) {

                //                     break;

                //                 }

                //                 num++;

                //             }

                //             if(num==0){

                //                 Plchome.AluminumFrameInfo=dbserve.SelectFrameBarcode(Plchome.FrameNo);

                //                 if(Plchome.AluminumFrameInfo.getbarcode()!=null){

                //                     int sequence = homeMapper.SelectMaxSquence();

                //                     homeMapper.AddOutSliceS("", AluminumFrameInfo.getflip().toString(), Plchome.FrameNo, "0", "0", sequence,  "0", (short)0,  AluminumFrameInfo.getordernumber(),AluminumFrameInfo.getlistnumber() , AluminumFrameInfo.getboxnumber(), "0", "0", AluminumFrameInfo.getframelength().toString(), AluminumFrameInfo.getframeheight().toString());

                //                     Plchome.AluminumFrameInfo=new north_frame_buffer1_frames();

                //                     // void AddOutSliceS(String glassid, String flip, String FrameNo, String glasslengthMm, String glassheightMm,

                //                     //  int sequence, String position, Short state,

                //                     //  String orderid, String listid, String boxid, String glasswidth, String glassheight,String framewidthmm,String frameheightmm);

                //                 }

                //             }else{

                //                 if (num == north_glass_buffer1s.size()) {

                //                     north_Glass_Buffer1Service.AddOutSliceS(Plchome.FrameNo);

                //                 } else {

                //                     Plchome.AluminumFrame = north_glass_buffer1s;

                //                     Plchome.AluminumFrameInfo=dbserve.SelectFrameBarcode(Plchome.FrameNo);

                //                 }

                //             }

                            
                //         } catch (SQLException e) {

                //             // TODO Auto-generated catch block

                //             e.printStackTrace();

                //         }

                //     }



                // 笼子使用情况

                List<StorageCage> tableData = homeMapper.selectAll();

@@ -176,52 +213,52 @@
                    // E02玻璃id

                    // log.info("frame1"+S7controlLK.getinstance().CheckConnected());

                    String E02id="";

                    // try {

                    //     E02id= S7controlLK.getinstance().readStrings("DB17.40");

                    //     plc2=true;

                    // } catch (Exception e) {

                    //     // TODO: handle exception

                    //     plc2=false;

                    //     e.printStackTrace();

                    // }

                    try {

                        E02id= S7controlLK.getinstance().readStrings("DB17.40");

                        plc2=true;

                    } catch (Exception e) {

                        // TODO: handle exception

                        plc2=false;

                        e.printStackTrace();

                    }

                    

                    // jsonObject.append("Plc2", plc2);

                    // // log.info("铝框线读取2"+S7controlLK.getinstance().CheckConnected());

                    jsonObject.append("Plc2", plc2);

                    // log.info("铝框线读取2"+S7controlLK.getinstance().CheckConnected());

                    

                    // // log.info("E02id"+E02id);

                    // outSliceServive.FrameStateUpdate(E02id);

                    // if (CurrentFrame != null) {

                    //     S7controlLK.getinstance().writeStrings(CurrentFrame.getBarCode(), "DB17.0");

                    // }

                    // String J01id = S7controlLK.getinstance().readStrings("DB17.22");

                    // List<Short> liststate = S7controlLK.getinstance().ReadWord("DB17.20", 1);

                    // Short framerequest = liststate.get(0);

                    // // log.info("liststate:" + liststate);

                    // if (framerequest == 1) {

                    //     // 铝框id

                    //     String position;

                    //     try {

                    //         position = dbserve.SelectPositionByFrameBarcode(J01id);

                    //     } catch (SQLException e) {

                    //         // TODO Auto-generated catch block

                    //         position = "0";

                    //         e.printStackTrace();

                    //     }

                    //     Short send;

                    //     if (position.equals("1")) {

                    //         send = 1;

                    //     } else {

                    //         send = 2;

                    //     }

                    //     if (J01id != null) {

                    //         int barcodeState = spianMapper.SelectOverState(J01id);// 获取该铝框的状态

                    //         if (barcodeState == 0) {// 当该铝框所有的玻璃都是完成状态时删除在出片队列的数据

                    //             spianMapper.DeleteQueue(J01id);

                    //             // log.info("deleteoutslice:" + J01id);

                    //         }

                    //     }

                    //     S7controlLK.getinstance().WriteWord("DB17.38", (short) send);

                    // }

                    // log.info("E02id"+E02id);

                    outSliceServive.FrameStateUpdate(E02id);

                    if (CurrentFrame != null) {

                        S7controlLK.getinstance().writeStrings(CurrentFrame.getBarCode(), "DB17.0");

                    }

                    String J01id = S7controlLK.getinstance().readStrings("DB17.22");

                    List<Short> liststate = S7controlLK.getinstance().ReadWord("DB17.20", 1);

                    Short framerequest = liststate.get(0);

                    // log.info("liststate:" + liststate);

                    if (framerequest == 1) {

                        // 铝框id

                        String position;

                        try {

                            position = dbserve.SelectPositionByFrameBarcode(J01id);

                        } catch (SQLException e) {

                            // TODO Auto-generated catch block

                            position = "0";

                            e.printStackTrace();

                        }

                        Short send;

                        if (position.equals("1")) {

                            send = 1;

                        } else {

                            send = 2;

                        }

                        if (J01id != null) {

                            int barcodeState = spianMapper.SelectOverState(J01id);// 获取该铝框的状态

                            if (barcodeState == 0) {// 当该铝框所有的玻璃都是完成状态时删除在出片队列的数据

                                spianMapper.DeleteQueue(J01id);

                                // log.info("deleteoutslice:" + J01id);

                            }

                        }

                        S7controlLK.getinstance().WriteWord("DB17.38", (short) send);

                    }



                    String E01id = S7controlLK.getinstance().readStrings("DB17.0");

                    // log.info("frameno:" + E01id);

@@ -260,7 +297,7 @@
                                height = form6.getglasslengthmm();

                                width = form6.getglassheightmm();

                            }

                            if (height < 380 || width < 380 || height > 1810 || width > 2760) {

                            if (height < 225 || width < 380 || height > 1810 || width > 2760) {

                                zhi = 600;

                            } else {

                                zhi = spianService.selectAlls(form6);

@@ -316,6 +353,8 @@
                    // }

                    // // 获取铝框idDB106.DBW64，添加到出片队列

                    // String frameno="X21763329601FB";



                    
                    String frameno = spianService.queGlassid("DB103.270", 11).toString();

                    if (!frameno.equals(Plchome.FrameNo)) {

                        Plchome.FrameNo = frameno;

@@ -329,12 +368,31 @@
                                }

                                num++;

                            }

                            if (num == north_glass_buffer1s.size()) {

                                north_Glass_Buffer1Service.AddOutSliceS(Plchome.FrameNo);

                            } else {

                                Plchome.AluminumFrame = north_glass_buffer1s;

                            if(num==0){

                                Plchome.AluminumFrameInfo=dbserve.SelectFrameBarcode(Plchome.FrameNo);

                                if(Plchome.AluminumFrameInfo.getbarcode()!=null){

                                    int count=homeMapper.SelectCountFrame(AluminumFrameInfo.getbarcode());

                                    if(count==0){

                                        int sequence = homeMapper.SelectMaxSquence();

                                        homeMapper.AddOutSliceS("", AluminumFrameInfo.getflip().toString(), Plchome.FrameNo, "0", "0", sequence,  "0", (short)3,  AluminumFrameInfo.getordernumber(),AluminumFrameInfo.getlistnumber() , AluminumFrameInfo.getboxnumber(), "0", "0", AluminumFrameInfo.getframelength().toString(), AluminumFrameInfo.getframeheight().toString());

                                        log.info("NoGlass"+AluminumFrameInfo.getbarcode());

                                        Plchome.AluminumFrameInfo=new north_frame_buffer1_frames();

                                    }

                                    
                                    
                                    // void AddOutSliceS(String glassid, String flip, String FrameNo, String glasslengthMm, String glassheightMm,

                                    //  int sequence, String position, Short state,

                                    //  String orderid, String listid, String boxid, String glasswidth, String glassheight,String framewidthmm,String frameheightmm);

                                }

                            }else{

                                if (num == north_glass_buffer1s.size()) {

                                    north_Glass_Buffer1Service.AddOutSliceS(Plchome.FrameNo);

                                } else {

                                    Plchome.AluminumFrame = north_glass_buffer1s;

                                    Plchome.AluminumFrameInfo=dbserve.SelectFrameBarcode(Plchome.FrameNo);

                                }

                            }

                            
                        } catch (SQLException e) {

                            // TODO Auto-generated catch block

                            e.printStackTrace();

@@ -380,7 +438,7 @@
                            height = form3.getglasswidth();

                            width = form3.getglassheight();

                        }

                        if (height < 380 || width < 380 || height > 1810 || width > 2760) {

                        if (height < 225 || width < 380 || height > 1810 || width > 2760) {

                            zhi = 600;

                        } else {

                            if (D01RequestState == true && D01ResponseState != true) {


 springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java

@@ -23,6 +23,7 @@
import com.example.springboot.entity.CarPosition;
import com.example.springboot.entity.StorageCage;
import com.example.springboot.entity.alarmmg;
import com.example.springboot.entity.north_frame_buffer1_frames;
import com.example.springboot.entity.north_glass_buffer1;
import com.example.springboot.entity.Out_slice;
import com.example.springboot.entity.Queue;
@@ -406,7 +407,7 @@
  @PostMapping("/CloseForm7")
  public Result CloseForm7() {
    Plchome.AluminumFrame = null;
    Plchome.AluminumFrameInfo = null;
    Plchome.AluminumFrameInfo = new north_frame_buffer1_frames();
    Map<String, Object> map = new HashMap<>();
    map.put("message", "200");
    return Result.success(map);

 springboot-vue3/src/main/java/com/example/springboot/entity/north_frame_buffer1_frames.java

New file
@@ -0,0 +1,102 @@
package com.example.springboot.entity;


//客户玻璃信息表
public class north_frame_buffer1_frames {
    private Integer id; // 自增id
    private String listnumber;// 集合id
    private String ordernumber;// 订单id
    private String boxnumber;// 箱子id
    private String barcode;// 铝框id
    private double framelength;// 铝框宽
    private double frameheight;// 铝框高
    private double framelengthmm;// 铝框宽mm
    private double frameheightmm;// 铝框高mm
    private Integer flip;// 是否翻转


    public Integer id() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public Integer getId() {
        return id;
    }

    public String getordernumber() {
        return ordernumber;
    }

    public void setordernumber(String ordernumber) {
        this.ordernumber = ordernumber;
    }

    public String getlistnumber() {
        return listnumber;
    }

    public void setlistnumber(String listnumber) {
        this.listnumber = listnumber;
    }

    public String getboxnumber() {
        return boxnumber;
    }

    public void setboxnumber(String boxnumber) {
        this.boxnumber = boxnumber;
    }

    public String getbarcode() {
        return barcode;
    }

    public void setbarcode(String barcode) {
        this.barcode = barcode;
    }

    public Double getframelength() {
        return framelength;
    }

    public void setframelength(Double framelength) {
        this.framelength = framelength;
    }

    public Double getframeheight() {
        return frameheight;
    }

    public void setframeheight(Double frameheight) {
        this.frameheight = frameheight;
    }

    public Double getframelengthmm() {
        return framelengthmm;
    }

    public void setframelengthmm(Double framelengthmm) {
        this.framelengthmm = framelengthmm;
    }

    public Double getframeheightmm() {
        return frameheightmm;
    }

    public void setframeheightmm(Double frameheightmm) {
        this.frameheightmm = frameheightmm;
    }

    public Integer getflip() {
        return flip;
    }

    public void setflip(Integer flip) {
        this.flip = flip;
    }

}

 springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java

@@ -226,6 +226,10 @@
  //获取铝框有没有正在出片的玻璃
  @Select("select count(*) from out_slice where barcode=#{frameNo} and state=1")
  Short SelectOutingQueueCount(String frameNo);

  //获取铝框是否存在玻璃对了
  @Select("select count(*) from out_slice where barcode=#{frameNo}")
  int SelectCountFrame(String getbarcode);
  

}