加拿大MES项目
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
ZengTao
2023-12-13 9c8c7cfb894c9377bdecba898058c9ec8d8b48c1 
 springboot-vue3/src/main/java/com/example/springboot/service/JdbcConnections.java


@@ -5,10 +5,12 @@


import java.sql.PreparedStatement;


import java.sql.ResultSet;


import java.sql.SQLException;


import java.util.ArrayList;


import java.util.List;




import org.springframework.stereotype.Component;




import com.example.springboot.entity.Glass;


import com.example.springboot.entity.Queue;


import com.example.springboot.entity.north_glass_buffer1;


@Component


public class JdbcConnections {


@@ -38,6 +40,171 @@


       conn.close();


         return glass;


    }




   public  north_glass_buffer1 SelectGlassByGlassIdOrderIdFrameId(String glassid,String orderid,String frameid) throws SQLException {


        conn = getConn();


        north_glass_buffer1 north_glass_buffer1s=new north_glass_buffer1();


        String sql = "select * from north_glass_buffer1 where barcode=? or ordernumber=? or FrameBarcode=?";


         ps = conn.prepareStatement(sql);


         ps.setString(1, glassid);


       ps.setString(2, orderid);


       ps.setString(3, frameid);


         rs= ps.executeQuery();


         while (rs.next()) {


         north_glass_buffer1s.setId(rs.getInt("Id"));


         north_glass_buffer1s.setordernumber(rs.getString("ordernumber"));


         north_glass_buffer1s.setlistnumber(rs.getString("listnumber"));


         north_glass_buffer1s.setboxnumber(rs.getString("boxnumber"));


         north_glass_buffer1s.setbarcode(rs.getString("barcode"));


         north_glass_buffer1s.setglasslength(rs.getDouble("glasslength"));


         north_glass_buffer1s.setglassheight(rs.getDouble("glassheight"));


         north_glass_buffer1s.setglasslengthmm(rs.getDouble("glasslength_mm"));


         north_glass_buffer1s.setglassheightmm(rs.getDouble("glassheight_mm"));


         north_glass_buffer1s.setitemtype(rs.getString("itemtype"));


         north_glass_buffer1s.setslotnumber(rs.getString("slotnumber"));


         north_glass_buffer1s.setdatemodified(rs.getString("datemodified"));


         north_glass_buffer1s.setdatecreated(rs.getString("datecreated"));


         north_glass_buffer1s.setFrameBarcode(rs.getString("FrameBarcode"));


         }


      //  conn.close();


         return north_glass_buffer1s;


    }


   //根据玻璃id，订单id，铝框id查询客户玻璃信息


   public  Queue SelectGlassByGlassIdOrderIdFrameIdQueue(String glassid,String orderid,String frameid) throws SQLException {


        conn = getConn();


        Queue queue=new Queue();


        String sql = "select * from north_glass_buffer1 where barcode=? or ordernumber=? or FrameBarcode=?";


         ps = conn.prepareStatement(sql);


         ps.setString(1, glassid);


       ps.setString(2, orderid);


       ps.setString(3, frameid);


         rs= ps.executeQuery();


         while (rs.next()) {


         queue.setid(rs.getInt("Id"));


         queue.setorderId(rs.getString("ordernumber"));


         queue.setlistId(rs.getString("listnumber"));


         queue.setboxId(rs.getString("boxnumber"));


         queue.setglassId(rs.getString("barcode"));


         queue.setglasswidthmm(rs.getDouble("glasslength"));


         queue.setglassheightmm(rs.getDouble("glassheight"));


         queue.setglasswidth(rs.getDouble("glasslength_mm"));


         queue.setglassheight(rs.getDouble("glassheight_mm"));


         // queue.setitemtype(rs.getString("itemtype"));


         // queue.setslotnumber(rs.getString("slotnumber"));


         // queue.setdatemodified(rs.getString("datemodified"));


         // queue.setdatecreated(rs.getString("datecreated"));


         // queue.setFrameBarcode(rs.getString("FrameBarcode"));


         }


      //  conn.close();


         return queue;


    }




	




   //根据玻璃id，订单id，铝框id查询客户玻璃信息


   public  List<north_glass_buffer1> SelectGlassByGlassIdOrderIdFrameIds(String glassid,String orderid,String frameid) throws SQLException {


        conn = getConn();


        // north_glass_buffer1 glass=new north_glass_buffer1();


      List<north_glass_buffer1> glass=new ArrayList<north_glass_buffer1>();


        String sql = "select * from north_glass_buffer1 where position(? in barcode) and position(? in ordernumber) and position(? in FrameBarcode)";


         ps = conn.prepareStatement(sql);


         ps.setString(1, glassid);


       ps.setString(2, orderid);


       ps.setString(3, frameid);


         rs= ps.executeQuery();


         while (rs.next()) {


         north_glass_buffer1 north_glass_buffer1s=new north_glass_buffer1();




         north_glass_buffer1s.setId(rs.getInt("Id"));


         north_glass_buffer1s.setordernumber(rs.getString("ordernumber"));


         north_glass_buffer1s.setlistnumber(rs.getString("listnumber"));


         north_glass_buffer1s.setboxnumber(rs.getString("boxnumber"));


         north_glass_buffer1s.setbarcode(rs.getString("barcode"));


         north_glass_buffer1s.setglasslength(rs.getDouble("glasslength"));


         north_glass_buffer1s.setglassheight(rs.getDouble("glassheight"));


         north_glass_buffer1s.setglasslengthmm(rs.getDouble("glasslength_mm"));


         north_glass_buffer1s.setglassheightmm(rs.getDouble("glassheight_mm"));


         north_glass_buffer1s.setitemtype(rs.getString("itemtype"));


         north_glass_buffer1s.setslotnumber(rs.getString("slotnumber"));


         north_glass_buffer1s.setdatemodified(rs.getString("datemodified"));


         north_glass_buffer1s.setdatecreated(rs.getString("datecreated"));


         north_glass_buffer1s.setFrameBarcode(rs.getString("FrameBarcode"));






         glass.add(north_glass_buffer1s);


			


         }


      //  conn.close();


         return glass;


    }




   //根据铝框id查询客户玻璃信息


   public  List<north_glass_buffer1> SelectGlassByGlassIdOrderIdFrameIdss(String frameid) throws SQLException {


        conn = getConn();


        // north_glass_buffer1 glass=new north_glass_buffer1();


      List<north_glass_buffer1> glass=new ArrayList<north_glass_buffer1>();


        String sql = "select * from north_glass_buffer1 where FrameBarcode=?";


         ps = conn.prepareStatement(sql);


       ps.setString(1, frameid);


         rs= ps.executeQuery();


         while (rs.next()) {


         north_glass_buffer1 north_glass_buffer1s=new north_glass_buffer1();




         north_glass_buffer1s.setId(rs.getInt("Id"));


         north_glass_buffer1s.setordernumber(rs.getString("ordernumber"));


         north_glass_buffer1s.setlistnumber(rs.getString("listnumber"));


         north_glass_buffer1s.setboxnumber(rs.getString("boxnumber"));


         north_glass_buffer1s.setbarcode(rs.getString("barcode"));


         north_glass_buffer1s.setglasslength(rs.getDouble("glasslength"));


         north_glass_buffer1s.setglassheight(rs.getDouble("glassheight"));


         north_glass_buffer1s.setglasslengthmm(rs.getDouble("glasslength_mm"));


         north_glass_buffer1s.setglassheightmm(rs.getDouble("glassheight_mm"));


         north_glass_buffer1s.setitemtype(rs.getString("itemtype"));


         north_glass_buffer1s.setslotnumber(rs.getString("slotnumber"));


         north_glass_buffer1s.setdatemodified(rs.getString("datemodified"));


         north_glass_buffer1s.setdatecreated(rs.getString("datecreated"));


         north_glass_buffer1s.setFrameBarcode(rs.getString("FrameBarcode"));






         glass.add(north_glass_buffer1s);


			


         }


      //  conn.close();


         return glass;


    }




   //根据铝框id查询l铝框是否翻转


   public String SelectFlipByFrameBarcode(String frameBarcode) throws SQLException {


      conn = getConn();


        // north_glass_buffer1 glass=new north_glass_buffer1();


      String flip="";


        String sql1 = "select * from north_glass_buffer1_frames where Barcode=? limit 1";


         ps = conn.prepareStatement(sql1);


       ps.setString(1, frameBarcode);


         rs= ps.executeQuery();


         while (rs.next()) {


         flip=rs.getString("Flip");


			


         }


      //  conn.close();


         return flip;


   }


   //根据铝框id查询是否铝框摆放


   public String SelectPositionByFrameBarcode(String frameBarcode) throws SQLException {


          conn = getConn();


        // north_glass_buffer1 glass=new north_glass_buffer1();


      String position="";


        String sql1 = "select * from north_glass_buffer1_frames where Barcode=? limit 1";


         ps = conn.prepareStatement(sql1);


       ps.setString(1, frameBarcode);


         rs= ps.executeQuery();


         while (rs.next()) {


         position=rs.getString("position");


         }


      //  conn.close();


         return position;


    }


	


   /**


    * 1. 加载驱动


    * 2. 获取连接   conn


@@ -69,5 +236,8 @@


      }


   }




    








}