📄 queryinventory.jsp

📁 (Java+SQL)-大型企业JAVA的ERP系统

💻 JSP

字号:

<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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -