<%@page import="com.northglass.Optima.OptimaHelper"%>
|
<%@page import="org.json.*"%>
|
<%@ page contentType="text/html;charset=UTF-8"%>
|
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
|
<%@page import="com.northglass.Globel.mes"%>
|
<%@page import="com.northglass.SqlHelper.*"%>
|
<%@page import="java.io.*"%>
|
<%@ page contentType="text/html;charset=UTF-8"%>
|
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
|
|
|
<%
|
BufferedReader in=request.getReader();
|
StringBuffer jsonStr=new StringBuffer();
|
String str="";
|
while((str=in.readLine())!=null){
|
jsonStr.append(str);
|
}
|
JSONObject rsp=null;
|
JSONObject input=new JSONObject(jsonStr.toString());
|
String method=input.getString("method");
|
if("getView".equals(method)){
|
String sql1="SELECT a.id as id, a.layout_number as number,a.gongchenghao as gongcheng,a.width as width,a.height as height,a.wuliao_bianma as wuliao from gmms_optimize_stock a inner join laser_machine b on a.gongchenghao=b.gongchenghao where b.id=1"
|
+" order by layout_number;";
|
String sql2="select a.x,a.y,a.w,a.h,a.id,a.isremain,a.stock_number from gmms_optimize_glass a inner join laser_machine b on a.gongchenghao=b.gongchenghao "
|
|
+" where b.id=1 order by a.stock_number;";
|
|
String sql3="select 1,a.glass_id,a.mark,a.x,a.y,c.layout_number from gmms_laser_task a inner join laser_machine b on a.gongchenghao=b.gongchenghao "+
|
"inner join gmms_optimize_stock c on a.stock_id=c.id "+
|
"where b.id=1 order by c.layout_number,a.glass_id;";
|
|
String sql4="select work_state,gongchenghao,current_stock_id,last_message from laser_machine where id=1;";
|
String sql5="select gongchenghao from gmms_optimize_gongcheng;";
|
|
DBSession sn=null;
|
try{
|
sn=mes.getMesDBHelper().createSession(false);
|
sn.createSql(sql1);
|
JSONArray obj1= sn.query().resultToJson(true);
|
sn.createSql(sql2);
|
JSONArray obj2= sn.query().resultToJson(true);
|
sn.createSql(sql3);
|
JSONArray obj3= sn.query().resultToJson(true);
|
sn.createSql(sql4);
|
JSONArray obj4= sn.query().resultToJson(true);
|
sn.createSql(sql5);
|
JSONArray obj5= sn.query().resultToJson(true);
|
rsp=new JSONObject();
|
rsp.put("stocks",obj1);
|
rsp.put("glasses",obj2);
|
rsp.put("marks",obj3);
|
rsp.put("states",obj4);
|
rsp.put("gongchengs",obj5);
|
rsp.put("result","ok");
|
}
|
catch(Exception e){
|
|
}
|
finally{
|
if(sn!=null)
|
sn.close();
|
}
|
}
|
|
if("getData".equals(method)){
|
String sql1="select work_state,gongchenghao,current_stock_id,last_message from laser_machine where id=1;";
|
|
DBSession sn=null;
|
try{
|
sn=mes.getMesDBHelper().createSession(false);
|
sn.createSql(sql1);
|
JSONArray obj1= sn.query().resultToJson(true);
|
|
rsp=new JSONObject();
|
rsp.put("states",obj1);
|
rsp.put("result","ok");
|
}
|
catch(Exception e){
|
|
}
|
finally{
|
if(sn!=null)
|
sn.close();
|
}
|
}
|
|
|
|
|
|
if("loadPiece".equals(method)){
|
DBSession sn=null;
|
try{
|
sn=mes.getMesDBHelper().createSession(false);
|
sn.createStdCall("laser_after_load",1);
|
String s= sn.stdCall(input.getString("stock_number")).ResultMessage;
|
|
|
rsp=new JSONObject();
|
|
rsp.put("result",s);
|
}
|
catch(Exception e){
|
|
}
|
finally{
|
if(sn!=null)
|
sn.close();
|
}
|
}
|
|
if("useGongcheng".equals(method)){
|
DBSession sn=null;
|
try{
|
sn=mes.getMesDBHelper().createSession(false);
|
sn.createStdCall("laser_create_task",1);
|
String s= sn.stdCall(input.getString("gongchenghao")).ResultMessage;
|
|
rsp=new JSONObject();
|
|
rsp.put("result",s);
|
}
|
catch(Exception e){
|
e.printStackTrace();
|
}
|
finally{
|
if(sn!=null)
|
sn.close();
|
}
|
}
|
|
|
if(rsp==null){
|
rsp=new JSONObject();
|
rsp.put("result","无响应");
|
}
|
out.print(rsp.toString());
|
|
|
|
|
%>
|
