<%@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;
|
DBSession sn=null;
|
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 left join gmms_galss_task_stock as gts on a.id=gts.id"
|
+" where a.processcard_id='"+liuchengka+"' and a.processcard_id is not null and a.processcard_id!='' order by b.stop_rank asc,gts.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");
|
sn=mes.getMesDBHelper().createSession(false);
|
sn.createStdCall("web_alter_rank_copy1",3);
|
String result= sn.stdCall("钢化后",lck,datas).ResultMessage;
|
JSONObject ret=new JSONObject();
|
ret.put("result",result);
|
out.print(ret.toString());
|
ok=true;
|
System.out.println("alert ok");
|
}
|
}
|
catch(Exception e){
|
e.printStackTrace();
|
}finally {
|
|
if (sn != null) {
|
sn.close();
|
}
|
}
|
if(ok==false){
|
JSONObject ret=new JSONObject();
|
ret.put("result","fail");
|
out.print(ret.toString());
|
}
|
|
%>
|
