<%@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 method=request.getParameter("m");
|
|
JSONObject ret=null;
|
if("in".equals(method)){
|
long id=Long.parseLong(request.getParameter("gid"));
|
long lid=Long.parseLong(request.getParameter("tid"));
|
DBSession sn=null;
|
try{
|
sn=mes.getMesDBHelper().createSession(false);
|
sn.createStdCall("yuliao_input",2);
|
String ss= sn.stdCall(id,lid).ResultMessage;
|
ret=new JSONObject();
|
ret.put("result",ss);
|
ret.put("message",ss);
|
}
|
finally{
|
if(sn!=null)
|
sn.close();
|
}
|
}
|
|
|
if("out".equals(method)){
|
long id=Long.parseLong(request.getParameter("gid"));
|
DBSession sn=null;
|
try{
|
sn=mes.getMesDBHelper().createSession(false);
|
sn.createStdCall("yuliao_output",1);
|
String ss= sn.stdCall(id).ResultMessage;
|
ret=new JSONObject();
|
ret.put("result",ss);
|
ret.put("message",ss);
|
}
|
finally{
|
if(sn!=null)
|
sn.close();
|
}
|
}
|
|
if("q".equals(method)){
|
|
DBSession sn=null;
|
try{
|
sn=mes.getMesDBHelper().createSession(false);
|
sn.createSql("SELECT "+
|
"a.yuliao_id ,b.moxi,b.houdu,b.kuan,b.gao,a.chanxian "
|
+ "from gmms_yuliao_task a inner join gmms_glass_yuliao b on a.yuliao_id=b.Id "
|
+ " where a.state=0;");
|
// sn.createSql("select 1,2,3");
|
JSONArray arr= sn.query().resultToJson(false);
|
sn.createSql(" SELECT "
|
+"b.yuliao_id,a.id,a.slicecage_number,a.slicecage_group,c.moxi,c.houdu,c.kuan,c.gao"
|
+" from gmms_yuliao_slicecage a left join"
|
+" gmms_yuliao_task b on a.id=b.lib_id"
|
+" left join gmms_glass_yuliao c on b.yuliao_id=c.id;");
|
JSONArray arr1=sn.query().resultToJson(false);
|
|
ret=new JSONObject();
|
ret.put("result","ok");
|
ret.put("data",arr);
|
ret.put("data1",arr1);
|
}
|
catch(Exception e){
|
e.printStackTrace();
|
}
|
finally{
|
if(sn!=null)
|
sn.close();
|
}
|
}
|
if(ret!=null)
|
out.print(ret.toString());
|
else
|
{
|
ret=new JSONObject();
|
ret.put("result","fail");
|
out.print(ret.toString());
|
}
|
|
%>
|
