<%@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"%>
<c:set var="ctx" value="${pageContext.request.contextPath}" />
<%
boolean ok=false;
try{
	String s=mes.getRequestBody(request);
  JSONObject obj=new JSONObject(s);
  if(obj.getString("method").equals("query")){
	  String liuchengka=obj.getString("liuchengka");
	  JSONArray arr1= mes.getMesDBHelper().getTableToJson("select a.id,a.edg_width,a.edg_height,a.thickness,a.color,b.stop_rank FROM  gmms_galss_task_buffer a"+ 
			"  left join gmms_galss_task_shelf b on a.id=b.id "
			+"  where a.processcard_id='"+liuchengka+"' order by b.stop_rank asc",false);
	  
  	  JSONObject ret=new JSONObject();
  	  ret.put("datas",arr1);
  	  ret.put("result","ok");
  	  out.print(ret.toString());
  	  ok=true;
  }
  if(obj.getString("method").equals("comit")){
	  	
	  String datas=obj.getString("datas");
	  String lck=obj.getString("liuchengka");
	  DBSession sn=mes.getMesDBHelper().createSession(false);
	  sn.createStdCall("web_alter_rank_copy1",3);
	  String result= sn.stdCall("钢化后",lck,datas).ResultMessage;
	  sn.close();
	  JSONObject ret=new JSONObject();
	  ret.put("result",result);
	  out.print(ret.toString());
	  ok=true;
	   System.out.println("alert ok");
	 }
}
catch(Exception e){
	e.printStackTrace();
}
if(ok==false){
	  JSONObject ret=new JSONObject();
	  ret.put("result","fail");
	  out.print(ret.toString());
}

%>