📄 stockoutsearch.jsp
字号:
<%@ page language="java" contentType="text/html; charset=GB2312" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="com.logistic.business.StockOutManager" %>
<%@ page import="com.logistic.model.StockOutInfo" %>
<% request.setCharacterEncoding("gb2312");%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>出库单信息查询</title>
<style type="text/css">
<!--
body {
background-color: #168AC2;
}
-->
</style>
<link href="../../cssjs/comcss.css" rel="stylesheet" type="text/css">
<jsp:useBean id="dblink" class="com.logistic.data.DataConnect" scope="page"/>
</head>
<body>
<%
String soid=request.getParameter("stockoutid");
%>
<table width="375" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#FF9999">
<tr>
<td width="369" align="center" class="style9">按出库单编号查询出库单信息</td>
</tr>
<tr>
<td height="30" align="center"><form name="stockout" method="post" action="stockoutsearch.jsp">
<table width="350" border="0" cellpadding="1" cellspacing="0">
<tr>
<td width="114" height="21" align="right" class="code">请输入出库单编号:</td>
<td width="152"><label>
<input name="stockoutid" type="text" class="style9" id="stockoutid" size="20" maxlength="20">
</label></td>
<td width="78" align="center"><label>
<input name="Submit" type="submit" class="buttonstyle" value="查询">
</label></td>
</tr>
</table>
</form></td>
</tr>
</table>
<%
if(soid!=null){
String charger=null;
String goods=null;
String type=null;
String receive=null;
String goodscate=null;
StockOutInfo soi=null;
StockOutManager som=new StockOutManager();
soi=som.StockOutSearchById(soid);
//取得入库单负责人
String sqlcharger="select *from employeeinfotable where EmployeeId="+soi.getChargeid();
Statement statcharger=dblink.getStmtread();
ResultSet rscharger=statcharger.executeQuery(sqlcharger);
while(rscharger.next()){
charger=rscharger.getString("EmployeeName");
}
dblink.close();
//取得入库单接受人
String sqlreceive="select *from employeeinfotable where EmployeeId="+soi.getGoodsreceiveid();
Statement statreceive=dblink.getStmtread();
ResultSet rsreceive=statreceive.executeQuery(sqlreceive);
while(rsreceive.next()){
receive=rsreceive.getString("EmployeeName");
}
dblink.close();
//取得入库商品名称
String sqlgoods="select *from goodsinfotable where GoodsId="+soi.getGoodsid();
Statement statgoods=dblink.getStmtread();
ResultSet rsgoods=statgoods.executeQuery(sqlgoods);
while(rsgoods.next()){
goods=rsgoods.getString("GoodsName");
}
dblink.close();
//取得商品分类名称
String sqlcate="select *from commcatetable where CommodityId="+soi.getCommodityid();
Statement statcate=dblink.getStmtread();
ResultSet rscate=statcate.executeQuery(sqlcate);
while(rscate.next()){
goodscate=rscate.getString("CommodityName");
}
dblink.close();
//取得商品型号名称
String sqltype="select *from typetable where TypeId="+soi.getTypeid();
Statement stattype=dblink.getStmtread();
ResultSet rstype=stattype.executeQuery(sqltype);
while(rstype.next()){
type=rstype.getString("TypeName");
}
dblink.close();
%>
<table width="515" height="186" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#FF9999">
<tr>
<td width="103" height="22" align="right" class="style9">出库负责人:</td>
<td width="186" align="center"><%=charger %></td>
<td width="73" align="right" class="style9">商品名称:</td>
<td width="135" align="center"><%=goods %></td>
</tr>
<tr>
<td height="24" align="right" class="style9">商品出库数量:</td>
<td align="center"><%=soi.getGoodsoutnumber() %></td>
<td align="right" class="style9">商品型号:</td>
<td align="center"><%=type %></td>
</tr>
<tr>
<td height="23" align="right" class="style9">商品收货人:</td>
<td align="center"><%=receive %></td>
<td align="right" class="style9">商品分类:</td>
<td align="center"><%=goodscate %></td>
</tr>
<tr>
<td height="22" align="center" class="style9">商品出库日期:</td>
<td height="22" align="center"><%=soi.getStockoutdate() %></td>
<td colspan="2" align="center" class="style9">商品出库备注信息如下 </td>
</tr>
<tr>
<td height="80" colspan="4" align="center"><%=soi.getGoodsoutmemo() %></td>
</tr>
</table>
<%
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -