| | |
| | | } |
| | | strSQL += " group by operator"; |
| | | } |
| | | |
| | | if(gongyi.equals("ä¿®æ¹åç使ç¨")){ |
| | | System.out.println(11); |
| | | String width = request.getParameter("width"); |
| | | String height = request.getParameter("height"); |
| | | String thickness = request.getParameter("thickness"); |
| | | String colour = request.getParameter("colour"); |
| | | String batch = request.getParameter("batch"); |
| | | |
| | | int quantity = Integer.parseInt(request.getParameter("quantity")); |
| | | int groups = Integer.parseInt(request.getParameter("line")); |
| | | String teams = request.getParameter("teams"); |
| | | String reportingTime = request.getParameter("reportingTime"); |
| | | String type="æå¨æ°å¢"; |
| | | if(batch==""){ |
| | | strSQL = "insert into gmms_cutmanage(width,height,thickness,color,batch_id,pieces,groups,dengluname,BgTime,engineering_id)"+ |
| | | "values ("+width+","+height+","+thickness+",'"+colour+"',"+null+","+quantity+","+groups+",'"+teams+"','"+reportingTime+"','"+type+"')"; |
| | | }else{ |
| | | strSQL = "insert into gmms_cutmanage(width,height,thickness,color,batch_id,pieces,groups,dengluname,BgTime,engineering_id)"+ |
| | | "values ("+width+","+height+","+thickness+",'"+colour+"','"+batch+"',"+quantity+","+groups+",'"+teams+"','"+reportingTime+"','"+type+"')"; |
| | | } |
| | | |
| | | |
| | | System.out.println(strSQL); |
| | | } |
| | | //2023-09-19 æ°å¢ ç»æ |
| | | //System.out.println("æ¥è¡¨SQLï¼" + strSQL); |
| | | sn.createSql(strSQL); |