<%@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());


%>