<%@page import="com.northglass.Globel.mes"%>
|
<%@page import="com.northglass.SqlHelper.*"%>
|
<%@page import="org.json.*"%>
|
<%@ page language="java" import="java.sql.*" %>
|
<%@ 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)) {
|
qSQL = "call d_dapingxianshi1()";
|
}
|
if ("原片出入库".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi2()";
|
}
|
if ("原片出入库3".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi3()";
|
}
|
if ("原片出入库4".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi4()";
|
}
|
if ("原片出入库5".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi15()";
|
}
|
if ("原片出入库6".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi6()";
|
}
|
if ("原片出入库7".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi7()";
|
}
|
if ("原片出入库8".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi8()";
|
}
|
if ("原片出入库9".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi9()";
|
}
|
if ("原片出入库13".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi13()";
|
}
|
if ("原片出入库14".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi14()";
|
}
|
if ("原片出入库15".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi15_1()";
|
}
|
if ("原片出入库16".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi6_1()";
|
}
|
|
|
|
|
|
|
|
//System.out.println(qSQL);
|
sn.createSql(qSQL);
|
//System.out.print(qSQL);
|
if ("修改".equals(leixing)) {
|
String Id = request.getParameter("Id");
|
sn.createSql(qSQL);
|
int q = sn.update();
|
out.print(q);
|
}
|
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();
|
}
|
}
|
|
/* String shuzu="["; */
|
if ("吊装管理1".equals(yemian)) {
|
String caozuo = request.getParameter("caozuo");
|
String leixing = request.getParameter("leixing");
|
String pLine = request.getParameter("line");
|
String dingdanhao = request.getParameter("dingdanhao");
|
DBSession sn = null;
|
boolean ok = false;
|
try {
|
sn = mes.getMesDBHelper().createSession1(false);
|
String qSQL="";
|
/* //连接数据库
|
String driverClass = "com.mysql.cj.jdbc.Driver";
|
String url="jdbc:mysql://10.153.19.35/gmms?serverTimezone=GMT%2B8&useSSL=false";
|
String user = "root";
|
String password = "beibo.123/";
|
|
|
Class.forName(driverClass);{
|
Connection con=DriverManager.getConnection( url,user,password);
|
CallableStatement cs =con.prepareCall("{call A_ceshi()}");
|
|
ResultSet rs = cs.executeQuery();
|
while(rs.next()){
|
shuzu+="["+rs.getString(1)+"]";
|
}
|
con.close();
|
}
|
shuzu+="]"; */
|
if ("原片出入库10".equals(caozuo)) {
|
qSQL = "call dapinxianshi10()";
|
}
|
if ("原片出入库11".equals(caozuo)) {
|
qSQL = "call dapinxianshi11()";
|
}
|
if ("原片出入库12".equals(caozuo)) {
|
qSQL = "call dapinxianshi12()";
|
}
|
if ("订单查询".equals(caozuo)) {
|
|
qSQL = "select "
|
+"concat(c.liuchengkahao,'/',c.gyqrxh),c.shuliang,"
|
+"sum(case when a.bengongxu='磨边' and POSITION(a.bengongxu in c.gongyiliucheng) then b.wangongshuliang else 0 end),"
|
+"sum(case when a.bengongxu='钢化' and POSITION(a.bengongxu in c.gongyiliucheng) then b.wangongshuliang else 0 end),"
|
+"sum(case when a.bengongxu='中空' and POSITION(a.bengongxu in c.gongyiliucheng) then b.wangongshuliang else 0 end),"
|
+"sum(case when a.bengongxu='包装' and POSITION(a.bengongxu in c.gongyiliucheng) then b.wangongshuliang else 0 end),"
|
+"a.xiaoshoudanhao,xiangmumingcheng,chanpinmingcheng "
|
+"from (select liuchengkahao,gyqrxh,sum(shuliang) as shuliang,gongyiliucheng,chanpinmingcheng from liuchengkafua where length(liuchengkahao)=13 group by left(liuchengkahao,13),gyqrxh) c "
|
+"left join baogongzhu a on a.liuchengkahao=c.liuchengkahao "
|
+"left join baogongfua b on a.baogongbianhao=b.baogongbianhao and b.gyqrxh=c.gyqrxh "
|
+"and a.shenhezhuangtai!=2 and b.zhijianzhuangtai!=2 "
|
+"where a.xiaoshoudanhao='"+dingdanhao+"' "
|
+"group by c.liuchengkahao,c.gyqrxh;";
|
|
}
|
if ("原片出入库3".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi3()";
|
}
|
if ("原片出入库5".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi5_1()";
|
}
|
if ("原片出入库6".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi6_1()";
|
}
|
if ("原片出入库15".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi5()";
|
}
|
if ("原片出入库16".equals(caozuo)) {
|
qSQL = "call d_dapingxianshi6()";
|
}
|
if ("原片出入库20".equals(caozuo)) {
|
qSQL = "call dapinxianshijiajiao()";
|
}
|
if ("原片出入库21".equals(caozuo)) {
|
qSQL = "call dapingxianshiqiegedangyuezongchanliang()";
|
}
|
if ("破损".equals(caozuo)) {
|
String sdate = request.getParameter("sDate");
|
String edate = request.getParameter("eDate");
|
String banzu = request.getParameter("banzu");
|
String xianlu = request.getParameter("xianlu");
|
qSQL = "call d_dapingxianshiposun('"+sdate+"','"+edate+"','"+banzu+"','"+xianlu+"')";
|
System.out.println(qSQL);
|
}
|
|
|
|
|
|
|
//System.out.println(qSQL);
|
sn.createSql(qSQL);
|
|
if ("查询".equals(leixing)) {
|
JSONArray a = sn.query().resultToJson(false);
|
if (a != null) {
|
out.print(a.toString());
|
} else {
|
out.print("[]");
|
}
|
}
|
|
} catch (Exception e) {
|
e.printStackTrace();
|
|
} finally {
|
if (sn != null)
|
sn.close();
|
}
|
}
|
|
|
|
%>
|
