补充提交

严智鑫

2025-03-14 c41e1c8b82b8f4c7b149e0576c9a37bc5b2dbb85

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
<%@page import="ng.db.*"%>
<%@page import="ng.db.NGFunction"%>
<%@page import="org.json.*"%>
<%@ page contentType="text/json;charset=UTF-8"%>
 
<%
boolean ok=false;
try{
    String s= NGFunction.getReaderContent(request.getReader()); 
  JSONObject obj=new JSONObject(s);
  if(obj.getString("method").equals("query")){
      String liuchengka=obj.getString("liuchengka");
      
      DBSession sn=null;
      try{
      sn=DBHelper.createDBSession("mes",false);
      sn.createSql("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_stock b on a.id=b.id "
            +"  where a.processcard_id='"+liuchengka+"' order by b.stop_rank asc");
      JSONArray arr1= sn.query().resultToJson(false);
      
        JSONObject ret=new JSONObject();
        ret.put("datas",arr1);
        ret.put("result","ok");
        out.print(ret.toString());
        ok=true;
      }
      catch(Exception e){
          
      }
      finally{
          if(sn!=null)
              sn.close();
      }
  }
  if(obj.getString("method").equals("comit")){
          
      String datas=obj.getString("datas");
      String lck=obj.getString("liuchengka");
      DBSession sn=null;
       try{
      sn= DBHelper.createDBSession("mes",false);
      sn.createStdCall("web_alter_rank",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();
      }
    }
}
catch(Exception e){
    e.printStackTrace();
}
if(ok==false){
      JSONObject ret=new JSONObject();
      ret.put("result","fail");
      out.print(ret.toString());
}
 
%>