📄 locationproductquery.jsp
字号:
<jsp:useBean id="product" class="src.wuyang.Production" scope="page"/>
<jsp:useBean id="locationState" class="src.wuyang.LocationState" scope="session"/>
<jsp:useBean id="wearhouse" class="src.wuyang.Wearhouse" scope="page"/>
<jsp:useBean id="global" class="src.com.MyGlobal" scope="session"/>
<% if (global.isLogined == false) {
%>
<jsp:forward page="../pub/DBErr.jsp" >
<jsp:param name="rtcode" value="-4" />
</jsp:forward>
<% }
%>
<html>
<head>
<title> 仓库盘存信息列表</title>
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<body bgcolor="#949B93" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="1" height="90%" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#616860" bordercolordark="#CCCCCC" bgcolor="#4c7171" >
<tr>
<td valign="top" >
<br><br><blockquote>
<% String productId = request.getParameter("productId");%>
<table width="88%" border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC"cellpadding="0" cellspacing="0"> <tr bgcolor="#949b93">
<td class="text">
<div align="center"><b>仓库名称</b></div>
</td>
<td class="text">
<div align="center"><b>货位编码</b></div>
</td>
<td class="text">
<div align="center"><b>产品编码</b></div>
</td>
<td class="text">
<div align="center"><b>产品名称</b></div>
</td>
<td class="text">
<div align="center"><b>规格/型号</b></div>
</td>
<td class="text">
<div align="center"><b>数量</b></div>
</td>
<td class="text">
<div align="center" class="text"><b>件数</b></div>
</td>
</tr>
<%
float counting=0;
float qty=0;
if ((productId == null)||(productId.equals(""))) {
locationState.query("","productId");
} else {
locationState.query("productId='"+productId+"'","productId");
}
for(;locationState.next() > 0;) {
wearhouse.load(locationState.getWearhouseId());
product.load(locationState.getProductId());
%>
<tr>
<td class="textb"><%=wearhouse.getWearhouseName()%></td>
<td class="textb"><%=locationState.getLocationId()%></td>
<td class="textb"><%=product.getProductId()%></td>
<td class="textb"><%=product.getProductName()%></td>
<td class="textb"><%=product.getProductDesc()%></td>
<td class="textb"><div align="right"><%=locationState.doubleFormat(locationState.getQuantity(),2)%></div></td>
<td class="textb"><div align="right"><%=locationState.doubleFormat(locationState.getCounting(),0)%></div></td>
</tr>
<%
counting = counting + locationState.getCounting();
qty = qty + locationState.getQuantity();
}
%>
</table>
<b><span class="textb">件数：<%=locationState.doubleFormat(counting,0)%> 总数量：<%=locationState.doubleFormat(qty,2)%> </span></b></blockquote>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -