queryinventory.jsp

来自「(Java+SQL)-大型企业JAVA的ERP系统」· JSP 代码 · 共 50 行

JSP
50
字号
<jsp:useBean id="stockInfoTra" class="src.wuyang.StockInfoTra" 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>
</head>
<% 
/*
	0 出库(销售)
	1 入库(采购)
	2 调拨
	3 调整
	4 完成	

*/
	String flag[]={"销售","采购","调拨"};
	String str[]={"SalesReceiptList.jsp","AllocatReceiptList.jsp","PurchReceiptList.jsp"};
	String str2[]={"slipId","allocatId","purchId"};	
	String whereClause="state !=3 and state != 4";
	stockInfoTra.query(whereClause,"");
%>
<body>
<table border="1">
  <tr>
     <td>凭证</td>
     <td>凭证类型</td>     
  </tr>
<%
	while (stockInfoTra.next()>0) {
%>
  <tr>
     <td><a href="<%=str[stockInfoTra.getReceiptType()]%>?<%=str2[stockInfoTra.getReceiptType()]%>=<%=stockInfoTra.getReceiptId()%>"><%=stockInfoTra.getReceiptId()%></a></td>
     <td><%=flag[stockInfoTra.getReceiptType()]%></td>
  </tr>
<%
	}
%>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?