📄 queryinventory1.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>
<link rel="stylesheet" href="css.css">
</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 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>
        <table width="88%" border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
          <tr class="text" bgcolor="#949b93"> 
            <td width="208"> 
              <div align="center"><b>凭证</b></div>
            </td>
            <td width="402"> 
              <div align="center"><b>凭证类型</b></div>
            </td>
          </tr>
          <%
	while (stockInfoTra.next()>0) {
%> 
          <tr class="textb"> 
            <td width="208"> 
              <div align="left"><a href="<%=str[stockInfoTra.getReceiptType()]%>?<%=str2[stockInfoTra.getReceiptType()]%>=<%=stockInfoTra.getReceiptId()%>"><%=stockInfoTra.getReceiptId()%></a></div>
            </td>
            <td width="402"><div align="center"><%=flag[stockInfoTra.getReceiptType()]%> 
              </div>
            </td>
          </tr>
          <%
	}
%> 
        </table>
</blockquote>
</td>
      
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -