📄 handle_log.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.lang.*,java.io.*" %>
<%@include file="/db/dbPool.inc"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="/lib/main.css" rel="stylesheet" type="text/css">
<title>提交工位修改日志</title>
<script src="/lib/jsFunc.js"></script>
<jsp:useBean id="queryBean" scope="page" class="Query.Query"/>
<body>
<%
String bID="";
String schID="";
String wID="";
String wName="";
String logCon="";
String logTime="";
String str_isSuc1="";
String tmp_logCon="";
int sFlags=0;
int isSuc1=0;
int isSuc2=0;
bID=request.getParameter("bID");
schID=request.getParameter("schID");
wID=request.getParameter("wID");
wName=request.getParameter("wName");
logCon=request.getParameter("logCon");//工位修改描述
isSuc1=java.lang.Integer.parseInt(request.getParameter("str_isSuc1"));
java.util.Date d=new java.util.Date();
logTime=d.toLocaleString();
Statement stmt=null;
String lineID="";
String prodID="";
String sID="";
int pNum=0;
String proTo="";
stmt=conn1.createStatement();
ResultSet rs=stmt.executeQuery("select * from pTab where bID='"+bID+"'");
if(rs.next()){
lineID=rs.getString("lineID");
pNum=rs.getInt("pNum");
prodID=rs.getString("prodID");
sID=rs.getString("sID");
byte temp=rs.getByte("proTo");
switch(temp)
{
case 1:proTo="整装";break;
case 2:proTo="包装";break;
default:proTo="走向未知";
}
}
if(logCon.equals("无"))
{
%>
<script language="javascript">
self.location="bInfo.jsp?bID=<%=bID%>&&lineID=<%=lineID%>&&prodID=<%=prodID%>&&sID=<%=sID%>&&pNum=<%=pNum%>&&proTo=<%=proTo%>";
</script>
<%
}
else
{
logCon+=";";
rs=stmt.executeQuery("select logCon,sFlags from logInfo where bID='"+bID+"' and wID='"+wID+"'");
if(!rs.next())
isSuc2=stmt.executeUpdate("insert into logInfo(bID,schID,wName,wID,logTime,logCon,sFlags) values('"+bID+"','"+schID+"','"+wName+"','"+wID+"','"+logTime+"','"+logCon+"','"+sFlags+"')");
else{
tmp_logCon=rs.getString("logCon");
sFlags=rs.getInt("sFlags");
if(sFlags==0){
tmp_logCon+=logCon;
isSuc2=stmt.executeUpdate("update logInfo set logTime='"+logTime+"',logCon='"+tmp_logCon+"' where bID='"+bID+"' and wID='"+wID+"'");
}else{
sFlags=0;
isSuc2=stmt.executeUpdate("update logInfo set logTime='"+logTime+"',logCon='"+logCon+"',sFlags='"+sFlags+"' where bID='"+bID+"' and wID='"+wID+"'");
}
}
if(isSuc1>0&&isSuc2>0){
%>
<script language="javascript">
successTips("恭喜，您的信息已修改成功！",false,true,"bInfo.jsp?bID=<%=bID%>&&lineID=<%=lineID%>&&prodID=<%=prodID%>&&sID=<%=sID%>&&pNum=<%=pNum%>&&proTo=<%=proTo%>");
</script>
<%}else{%>
<script language="javascript">
failTips("抱歉，数据插入错误，请重试！",false,true);
</script>
<%}}%>
</body>
</html>
<%@ include file="/db/dbpoolEnd.inc" %>
<script src="/lib/jsFooter.js"></script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -