望美最新程序

严智鑫

2024-05-13 cedce4883f0d204f5bf7bf87c0bf4858dabb0c23

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
<%@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();
        }
    }
 
    
%>