<%@page import="com.northglass.Globel.mes"%> <%@page import="com.northglass.SqlHelper.*"%> <%@page import="org.json.*"%> <%@ page contentType="text/json;charset=UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> <% String caozuoName = request.getParameter("name"); String pLine = request.getParameter("line"); String moshi = request.getParameter("moshi"); //System.out.println("操作时间：" + new java.util.Date() + " 当前操作：" + caozuoName + "; 当前生产线：" + pLine + ";模式：" + moshi); //查询 if ("1".equals(moshi)) { DBSession sn = null; boolean ok = false; try { sn = mes.getMesDBHelper().createSession(false); String qSQL = ""; if ("上片位信息".equals(caozuoName)) { qSQL = "select id,stops,processcard_id,state,zongshu,posunshu,yiyouhua,wanchengshu,shengyushu,shangpianshengyushu,noodles,flag,weizhi from v_gh_shangpianwei where groups = " + pLine; } if ("优化模式".equals(caozuoName)) { } //38 2号线机械手 63 1号线机械手 if ("吸片模式".equals(caozuoName)) { String mId = "1".equals(pLine) ? "63" : "38"; qSQL = "select remarks from gmms_machine where id = " + mId; } if ("获取流程卡".equals(caozuoName)) { qSQL = "Select * from v_ghq_liuchengka"; } if ("换架判断".equals(caozuoName)) { String Id = request.getParameter("Id"); qSQL = "select count(*) from gmms_galss_task_2 where processcard_id = (select processcard_id from gmms_drop_frame_2 where Id =" + Id + ") and work_state <> '破损' and work_state <> '未优化' "; } if ("查询流程卡详情".equals(caozuoName)) { String Id = request.getParameter("Id"); qSQL = "select processcard_id,stop_rank,galss_id,thickness,color,edg_width,edg_height,work_state,work_procedure,Id from gmms_galss_task_2 where processcard_id = (select processcard_id from gmms_drop_frame_2 where Id =" + Id + ") order by stop_rank"; } if ("工位信息".equals(caozuoName)) { String Id = request.getParameter("Id"); qSQL = "Select stops,processcard_id,zongshu,posunshu,shengyushu,noodles from v_gh_shangpianwei where id ="+Id; } if ("当前摆片".equals(caozuoName)) { qSQL = "Select width,length,xinterval,yinterval from gmms_furnace where Id ="+pLine; } if("摆片规则".equals(caozuoName)){ qSQL = "Select id,width,length,xinterval,yinterval,description,line from gmms_furnace_config"; } if("进炉时间".equals(caozuoName)){ if("1".equals(pLine)){ qSQL ="Select time_out from gmms_timer where timer_name = 'ganghua_1'"; }else if("2".equals(pLine)){ qSQL ="Select time_out from gmms_timer where timer_name = 'ganghua_2'"; } } sn.createSql(qSQL); //sn.createStdCall("aaa",3); //String s= sn.stdCall(1,2,3).ResultMessage; JSONArray a = sn.query().resultToJson(false); if (a != null) { out.print(a.toString()); } else { out.print("[]"); } //out.print(pLine); ok = true; } catch (Exception e) { System.out.println("操作时间：" + new java.util.Date() + " 出现错误！！！：" + " 当前操作：" + caozuoName + "; 当前生产线：" + pLine + ";模式：" + moshi); e.printStackTrace(); } finally { if (sn != null) { sn.close(); } } } else { } //修改 if ("2".equals(moshi)) { DBSession sn = null; boolean ok = false; try { sn = mes.getMesDBHelper().createSession(false); String qSQL = ""; if ("设置使用面".equals(caozuoName)) { String sId = request.getParameter("Id"); qSQL = "update gmms_drop_frame_2 set flag = if(flag=1,0,1) where stops = " + sId + " and groups = " + pLine; } //2 不吸片 1吸片 if ("吸片模式切换".equals(caozuoName)) { String mId = "1".equals(pLine) ? "63" : "38"; qSQL = "update gmms_machine set remarks = if(remarks=1,2,1) where Id=" + mId; } if ("设置破损".equals(caozuoName)) { String gId = request.getParameter("Id"); qSQL = "update gmms_galss_task_2 set work_state = '破损' where Id = " + gId; } if ("删除上片位信息".equals(caozuoName)) { String Id = request.getParameter("Id"); qSQL = "update gmms_drop_frame_2 set processcard_Id = null ,state='" + "空闲" + "',processcard_count =0 ,surplus_count = 0 where Id=" + Id; } if("修改数量".equals(caozuoName)){ String Id = request.getParameter("Id"); String u_num = request.getParameter("U_Num"); qSQL = "update gmms_drop_frame_2 set surplus_count = "+u_num +" where Id = "+Id; } if("摆片新增".equals(caozuoName)){ String ms = request.getParameter("bpms"); String[] m = ms.split("_"); // n + "_" + w + "_" + l + "_" + x + "_" + y qSQL = "insert into gmms_furnace_config(width,length,xinterval,yinterval,description) values ("+m[1]+","+m[2]+","+m[3]+","+m[4]+",'"+m[0]+"')"; } if("删除摆片规则".equals(caozuoName)){ String Id = request.getParameter("Id"); qSQL = "Delete from gmms_furnace_config where id = "+Id; } if("标记钢化完成".equals(caozuoName)){ String lck = request.getParameter("lck_num"); qSQL ="update gmms_liuchengka set isgang='手动钢化' where liuchengka='"+lck+"'"; } System.out.println("操作时间：" + new java.util.Date() + " 当前操作：钢化前上片位-" + caozuoName + ";SQL：" + qSQL); sn.createSql(qSQL); int s = sn.update(); out.print(s); } catch (Exception e) { e.printStackTrace(); } finally { if (sn != null) { sn.close(); } } } //存储过程 if ("3".equals(moshi)) { DBSession sn = null; boolean ok = false; try { sn = mes.getMesDBHelper().createSession(false); if ("上架确认".equals(caozuoName)) { sn.createStdCall("GlassTask_ganghuaqian", 1); int s = sn.stdCall(pLine).ResultCode; out.print(s); }if("绑定流程卡".equals(caozuoName)){ //GlassTask_ghq_BindRack String Id = request.getParameter("Id"); String lckNum = request.getParameter("lckNum"); sn.createStdCall("GlassTask_ghq_BindRack", 2); DBSession.StdCallResult scr = sn.stdCall(Id,lckNum); int s = scr.ResultCode; String rM = scr.ResultMessage; out.print(s+"_"+rM); }if("摆片修改".equals(caozuoName)){ String Id =request.getParameter("Id"); sn.createStdCall("GlassTask_furnace", 2); DBSession.StdCallResult scr = sn.stdCall(Id,pLine); int s = scr.ResultCode; String rM = scr.ResultMessage; out.print(s+"_"+rM); } } catch (Exception e) { e.printStackTrace(); } finally { if (sn != null) { sn.close(); } } } //需要修改多条数据 if ("4".equals(moshi)) { DBSession sn = null; boolean ok = false; try { sn = mes.getMesDBHelper().createSession(false); String qSQL = ""; //弃用 if ("绑定流程卡".equals(caozuoName)) { String Id = request.getParameter("Id"); String lckNum = request.getParameter("lckNum"); qSQL = "update gmms_drop_frame_2 set processcard_Id ='" + lckNum + "' ,state='" + "使用中" + "',processcard_count =(SELECT count(1) FROM gmms_galss_task_stock WHERE processcard_id = '" + lckNum + "') ,surplus_count = (SELECT count(1) FROM gmms_galss_task_stock WHERE processcard_id = '" + lckNum + "') where Id=" + Id; sn.createSql(qSQL); int s = sn.update(); if (s == 1) { qSQL = "update gmms_liuchengka set Occupied = " + Id + " where liuchengka = '" + lckNum + "';"; sn.createSql(qSQL); int t = sn.update(); if (t == 1) { out.print(t); } else { out.print("上片位信息修改成功，流程卡占用标记失败"); } } else { out.print("上片位信息修改失败，流程卡绑定失败"); } } if ("清空信息".equals(caozuoName)) { String Id = request.getParameter("Id"); qSQL = "delete from gmms_galss_task_2 where processcard_id = (select processcard_id from gmms_drop_frame_2 where id=" + Id + ")"; sn.createSql(qSQL); sn.update(); qSQL = "update gmms_drop_frame_2 set processcard_Id = null ,state='" + "空闲" + "',processcard_count =0 ,surplus_count = 0 where Id=" + Id; sn.createSql(qSQL); int r = sn.update(); if (r == 1) { out.print(r); } else { out.print("收影响行数大于1条，清空信息可能存在异常！"); } } if ("删除上片位信息".equals(caozuoName)) { String Id = request.getParameter("Id"); qSQL = "update gmms_liuchengka set Occupied = 0 where liuchengka =(select processcard_id from gmms_drop_frame_2 where id=" + Id + ")"; sn.createSql(qSQL); sn.update(); qSQL = "update gmms_drop_frame_2 set processcard_Id = null ,state='" + "空闲" + "',processcard_count =0 ,surplus_count = 0 where Id=" + Id; sn.createSql(qSQL); int t = sn.update(); if (t == 1) { out.print(t); } else { out.print("上片位信息修改失败!"); } } } catch (Exception e) { e.printStackTrace(); } finally { if (sn != null) { sn.close(); } } } //System.out.println("操作时间："+new java.util.Date()+" 操作结束"); %>