廖井涛
2025-06-12 864b0203990d308294e0d8a9331158374822dbba
河北望美项目/MES_11/src/main/java/com/northglass/service/cutmanage/CutManageService.java
@@ -206,6 +206,10 @@
         model.addAttribute("line", prodLine);
         model.addAttribute("groups", prodLine);
         model.addAttribute("rawPackageslist", html.toString());
         StringBuffer html3 = new StringBuffer();
         html3.append("<button type='button' onclick='task()' class='btn btn-primary' id='app'>鎵嬪姩浠诲姟</button>");
         model.addAttribute("app", html3.toString());
         
@@ -269,7 +273,7 @@
   public String getTasks(String prodLine, Model model) {
         StringBuffer html = new StringBuffer();
         List<RawFile> rawPackageslist = rawFileDao.findAcceptedByGroups(Long.valueOf(prodLine));
         List<RawFile> rawPackageslist = rawFileDao.findTasks(Long.valueOf(prodLine));
         int num = 1;
         for (RawFile rawPackages : rawPackageslist) {
            int galssTaskcount = galssTaskBufferDao.findbygalsstaskcount(rawPackages.getFileName());
@@ -290,8 +294,11 @@
         StringBuffer html2 = new StringBuffer();
         UserDetails userDetails=userDetailsDao.findgroups(prodLine);
         html2.append("<button id='dengluname' style='background-color: #5CADFE' class='btn btn-large btn-success' onclick='updatedengluname()'>"+userDetails.getName()+"</button>");
         model.addAttribute("rawPackageslist", html.toString());
         model.addAttribute("rawPackageslistname", html2.toString());
         model.addAttribute("line", prodLine);
         model.addAttribute("groups", prodLine);
         return "cutmanage/gettask";
      
      
@@ -549,8 +556,9 @@
   //缁撴潫浠诲姟
   public String delecttask(Long id,Long line) {
      RawFile rawFile=rawFileDao.findAcceptedByGroup2(id);
      System.out.println(1111);
      int lipiancount =galssTaskDao.finlipian2(rawFile.getFileName());
      System.out.println(2222);
      int slicecount;
      if (line==1) {
          slicecount=horizontalDao.findfall3(rawFile.getFileName());
@@ -577,7 +585,7 @@
               c.close();
            }else{
               CallableStatement c=conn.prepareCall("{call workmanship(?)}");
               c.setLong(1,line);
               c.setLong(1,id);
               c.execute(); 
               c.close();
                  
@@ -756,7 +764,7 @@
         int count=patternTaskDao.findcount(rawFile.getId());
         int sum=patternTaskDao.findsum(rawFile.getId());
         html.append("<tr>");
         html.append("<td>").append(rawFile.getFileName()).append("</td>");
         html.append("<td id='fileName'>").append(rawFile.getFileName()).append("</td>");
         /*html.append("<td>").append(patternTask.getRawWidth()).append("</td>");
         html.append("<td>").append(patternTask.getRawHeight()).append("</td>");
         html.append("<td>").append(patternTask.getRawThickness()).append("</td>");
@@ -850,7 +858,14 @@
         html.append("<td>").append(patternTask.getRawThickness()).append("</td>");
         html.append("<td>").append(patternTask.getColor()).append("</td>");
         html.append("<td>").append(patternTask.getContent()).append("</td>");
         html.append("<td><button style='background-color: #5CADFE' class='btn btn-large btn-success' onclick='updatetask(").append(patternTask.getId()).append(")'>淇敼鏁伴噺</button>");
         html.append("<td><button style='background-color: #5CADFE' class='btn btn-large btn-success' onclick='updatetask(")
         .append(patternTask.getId()).append(",")
         .append(patternTask.getRawWidth()).append(",")
         .append(patternTask.getRawHeight()).append(",")
         .append(patternTask.getRawThickness()).append(",")
         .append("\""+patternTask.getColor()+"\"").append(",")
         .append(patternTask.getContent())
         .append(")'>鎻愪氦浜ч噺</button>");
         html.append("</tr>");
      }
         
@@ -879,6 +894,32 @@
      }
   }
   
   public void updatepieces(Long id,String width,String height,String thinkness,String color,String count) {
//      PatternTask patternTask=patternTaskDao.findOne(id);
//      if(patternTask!=null){
//         patternTask.setContent(count);
//         patternTaskDao.save(patternTask);
//      }
      //娣诲姞鎵嬪姩鎶ュ伐浠诲姟
      Connection conn=DeviceService.getConnection();
      try {
         CallableStatement c=conn.prepareCall("{call GalssCutmanage4(?,?,?,?,?,?)}");
         c.setString(1,width);
         c.setString(2, height);
         c.setString(3, thinkness);
         c.setString(4, color);
         c.setString(5, count);
         c.registerOutParameter(5, java.sql.Types.INTEGER);
         c.execute();
         c.close();
      } catch (SQLException e) {
         e.printStackTrace();
      }finally{
         messageProcessor.close(conn);
      }
   }
   
   public void updatetask(Long id) {
      PatternTask patternTask=patternTaskDao.findOne(id);