<%@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("gongyi");
|
String lineName = request.getParameter("lineName");
|
String caozuo = request.getParameter("caozuo");
|
String startDate = request.getParameter("sDate");
|
String endDate = request.getParameter("eDate");
|
DBSession sn = null;
|
boolean ok = false;
|
//System.out.println("操作类型：" + caozuo + ";工艺：" + lineName+";开始日期："+startDate+";结束日期："+endDate);
|
try {
|
|
|
String strSQL = "";
|
if ("电量".equals(caozuo)) {
|
sn = mes.getMesDBHelper().createErpSession(false,"gmms_data");
|
strSQL = "Select 日期,"+lineName+" from v_daily_dianliang where 日期>='"+startDate+"' and 日期 <= '"+endDate+"'";
|
// System.out.println("信息查询：" + strSQL);
|
|
sn.createSql(strSQL);
|
JSONArray a = sn.query().resultToJson(false);
|
if (a != null) {
|
out.print(a.toString());
|
} else {
|
out.print("[]");
|
}
|
if(sn!=null){
|
sn.close();
|
}
|
}
|
|
if ("产量".equals(caozuo)) {
|
|
sn = mes.getMesDBHelper().createErpSession(false,"sappp");
|
strSQL = "call dapingchanliangchaxun('"+lineName+"','"+startDate+"','"+endDate+"') ";
|
System.out.println("信息查询1：" + strSQL);
|
|
sn.createSql(strSQL);
|
JSONArray a = sn.query().resultToJson(false);
|
if (a != null) {
|
out.print(a.toString());
|
} else {
|
out.print("[]");
|
}
|
}
|
|
|
if("产量2".equals(caozuo)){
|
|
sn = mes.getMesDBHelper().createErpSession(false,"sappp");
|
strSQL = "call proc_dapingDataByDateSelect('"+lineName+"','"+startDate+"','"+endDate+"') ";
|
System.out.println("信息查询2：" + strSQL);
|
|
sn.createSql(strSQL);
|
JSONArray a = sn.query().resultToJson(false);
|
if (a != null) {
|
out.print(a.toString());
|
} else {
|
out.print("[]");
|
}
|
}
|
|
|
if("班组".equals(lineName)){
|
|
|
|
}
|
|
} catch (Exception e) {
|
e.printStackTrace();
|
|
} finally {
|
if (sn != null)
|
sn.close();
|
}
|
|
|
|
%>
|
