<%@ 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="org.json.*"%>
<%@ page contentType="text/html;charset=UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
String ret="未知操作";
int mdflag=0;
String s1= request.getParameter("a");
String s2 = request.getParameter("b");
JSONObject obj=new JSONObject();
if("update".equals(s1)){
String sql1= "SELECT a.id as id,a.galss_id as glass_id,a.furnace as layout_number,a.processcard_id,a.work_procedure as proc,a.work_state as state,"
+"b.x as y,b.y as x,"
+"(case when rotate=true then b.width else b.height end) as width,"
+"(case when rotate=false then b.width else b.height end) as height"
+" from gmms_galss_task_2 a inner join gmms_tempere_layout b on a.id=b.glass_id and a.furnace=b.layout_number where a.groups=1 and (select count(*) from gmms_galss_task_2 where processcard_id=a.processcard_id and work_state!='破损' and furnace=a.furnace and !(work_procedure='钢化后下片' and work_state='已完成'))>0 and (not (a.work_procedure='钢化后下片' and a.work_state='已完成')) order by a.furnace";
String sql2= "SELECT a.id as id,a.galss_id as glass_id,a.furnace as layout_number,a.processcard_id,a.work_procedure as proc,a.work_state as state,"
+"b.x as y,b.y as x,"
+"(case when rotate=true then b.width else b.height end) as width,"
+"(case when rotate=false then b.width else b.height end) as height"
+" from gmms_galss_task_2 a inner join gmms_tempere_layout b on a.id=b.glass_id and a.furnace=b.layout_number where a.groups=2 and (select count(*) from gmms_galss_task_2 where processcard_id=a.processcard_id and work_state!='破损' and furnace=a.furnace and !(work_procedure='钢化后下片' and work_state='已完成'))>0 and (not (a.work_procedure='钢化后下片' and a.work_state='已完成')) order by a.furnace";
mdflag=1;
DBSession sn=null;
int flag=0;
try{
sn=mes.getMesDBHelper().createSession(false);
if("1".equals(s2)){
sn.createSql(sql1);
flag=1;
}
if("2".equals(s2)){
sn.createSql(sql2);
flag=2;
}
if(flag!=0){
JSONArray arr= sn.query().resultToJson(true);
ret="ok";
int f=0;
JSONObject data=new JSONObject();
obj.put("result","ok");
obj.put("data",arr);
out.print(obj.toString());
}
else{
JSONObject data=new JSONObject();
obj.put("result","fail");
obj.put("message","错误的产线编号");
out.print(obj.toString());
}
}
catch(Exception e){
e.printStackTrace();
obj.put("result","fail");
obj.put("message","刷新失败");
out.print(obj.toString());
}
finally{
if(sn!=null)
sn.close();
}
}
%>