<%@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 yemian = request.getParameter("yemian");
|
if ("半成品仓储".equals(yemian)) {
|
String caozuo = request.getParameter("caozuo");
|
String leixing = request.getParameter("leixing");
|
String pLine = request.getParameter("line");
|
DBSession sn = null;
|
boolean ok = false;
|
try {
|
|
sn = mes.getMesDBHelper().createSession(false);
|
String qSQL = "";
|
|
if ("获取列表".equals(caozuo)) {
|
String zhuangtai = request.getParameter("zhuangtai");
|
if("0".equals(zhuangtai)){
|
qSQL = "select st.id,taskphase,taskstatus,sr.processcard_id,beginaddress,endaddress,endgroups,groups,st.starttime,st.isrepeal,null as xz from gmms_shelf_tasks2 st left join gmms_shelf_rack_2 sr on st.rackid=sr.id where taskstatus!='已完成' and isrepeal='正常'";
|
}else if("1".equals(zhuangtai)){
|
qSQL = "select st.id,taskphase,taskstatus,sr.processcard_id,beginaddress,endaddress,endgroups,groups,st.starttime,st.isrepeal,null as xz from gmms_shelf_tasks2 st left join gmms_shelf_rack_2 sr on st.rackid=sr.id where taskstatus='已完成' and (isrepeal='正常' or isrepeal='完成')";
|
}else{
|
qSQL = "select st.id,taskphase,taskstatus,sr.processcard_id,beginaddress,endaddress,endgroups,groups,st.starttime,st.isrepeal,null as xz from gmms_shelf_tasks2 st left join gmms_shelf_rack_2 sr on st.rackid=sr.id";
|
}
|
|
}
|
|
|
sn.createSql(qSQL);
|
|
|
if ("修改".equals(leixing)) {
|
|
if ("撤销".equals(caozuo)) {
|
|
String Id = request.getParameter("Id");
|
qSQL="update gmms_shelf_tasks2 set isrepeal='撤销' where id="+Id ;
|
sn.createSql(qSQL);
|
int s=sn.update();//括号内是参数，没有参数不输入
|
out.print(s);
|
}if ("完成".equals(caozuo)) {
|
String Id = request.getParameter("Id");
|
qSQL="update gmms_shelf_tasks2 set isrepeal='完成',taskstatus='已下车' where id="+Id+" and (taskstatus='正在上车' or taskstatus='正在下车')";
|
sn.createSql(qSQL);
|
int s=sn.update();
|
out.print(s);
|
}
|
if ("重新开始".equals(caozuo)) {
|
String Id = request.getParameter("Id");
|
qSQL="update gmms_shelf_tasks2 set isrepeal='重新开始',taskstatus='等待上车' where id="+Id+" and (taskstatus='正在上车' or taskstatus='正在下车')";
|
sn.createSql(qSQL);
|
int s=sn.update();
|
out.print(s);
|
}
|
|
}
|
if ("查询".equals(leixing)) {
|
JSONArray a = sn.query().resultToJson(false);
|
if (a != null) {
|
out.print(a.toString());
|
} else {
|
out.print("[]");
|
}
|
}
|
//sn.createStdCall("aaa",3);
|
//String s= sn.stdCall(1,2,3).ResultMessage;
|
|
} catch (Exception e) {
|
e.printStackTrace();
|
|
} finally {
|
if (sn != null)
|
sn.close();
|
}
|
}
|
|
|
%>
|
