⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 arrivedlogreport.jsp

📁 (Java+SQL)-大型企业JAVA的ERP系统
💻 JSP
字号:
<%@page import="java.sql.*"%>
<jsp:useBean id="arrivedLogReport" class="src.report.ArrivedLogReport" scope="session"/>
<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="report.css">
</head>
<%
//arrivedLogReport.setGlobal(global);
//arrivedLogReport.conditionSetup(request);
//分页
int position,state,curPage,totalPage,recordNum;    
int numInOnePage = arrivedLogReport.getNumInOnePage();
arrivedLogReport.listPage(request);
//查询出每页的纪录
arrivedLogReport.arrivedLogReport();

%>

<body>
<center><br><FONT class="f16">江苏五洋集团有限公司 <%= arrivedLogReport.getStringDate(arrivedLogReport.beginDate,1) %> 年到货记录表</FONT><center>
<%= arrivedLogReport.getStringDate(arrivedLogReport.beginDate,1) %>-<%= arrivedLogReport.getStringDate(arrivedLogReport.beginDate,2) %>
<table border="1"border="1" cellspacing="0" cellpadding="2" bordercolor="#000000">
	<tr>
		<td align="center">定货日</td>
		<td align="center">到货日</td>		
		<td align="center">定货部门</td>
		<td align="center">销货部门</td>		
		<td align="center">品种</td>
		<td align="center">预定数量</td>		
		<td align="center">实到数量</td>
		<td align="center">单价</td>				
		<td align="center">金额</td>
		<td align="center">预付金额</td>		
		<td align="center">余额</td>
		<td align="center">备注</td>		
	</tr>	
<%
for(int listCount = 0; listCount < numInOnePage && (arrivedLogReport.next() > 0) ; listCount++) {
//while (arrivedLogReport.next() > 0) {
%>
  
	<tr> 
		<td align="center">
			<%if ((arrivedLogReport.getContractDate()!=null)&&(!arrivedLogReport.getContractDate().equals(""))) {
				out.print(arrivedLogReport.getStringDate(arrivedLogReport.getContractDate(),1)+"-"+arrivedLogReport.getStringDate(arrivedLogReport.getContractDate(),2)+"-"+arrivedLogReport.getStringDate(arrivedLogReport.getContractDate(),3)); }
			else {out.print("&nbsp;");}%>
		</td>
		<td align="center">
			<%if ((arrivedLogReport.getInventoryDate()!=null)&&(!arrivedLogReport.getInventoryDate().equals(""))) {
				out.print(arrivedLogReport.getStringDate(arrivedLogReport.getInventoryDate(),1)+"-"+arrivedLogReport.getStringDate(arrivedLogReport.getInventoryDate(),2)+"-"+arrivedLogReport.getStringDate(arrivedLogReport.getInventoryDate(),3)); }
			else {out.print("&nbsp;");}%>
		</td>		
		<td align="center">
			<%if ((arrivedLogReport.getCustomerName()!=null)&&(!arrivedLogReport.getCustomerName().equals(""))) {
				out.print(arrivedLogReport.getCustomerName()); }
			else {out.print("&nbsp;");}%>
		</td>		
		<td align="center">
			<%if ((arrivedLogReport.getDeptName()!=null)&&(!arrivedLogReport.getDeptName().equals(""))) {
				out.print( arrivedLogReport.getDeptName()); }
			else {out.print("&nbsp;");}%>
		</td>		
		<td align="center">
			<%if ((arrivedLogReport.getProductName()!=null)&&(!arrivedLogReport.getProductName().equals(""))) {
				out.print( arrivedLogReport.getProductName()); }
			else {out.print("&nbsp;");}%>
		</td>				
		<td align="right">
			<%if (arrivedLogReport.getContractProductQty()!=0) {
				out.print( arrivedLogReport.doubleFormat(arrivedLogReport.getContractProductQty(),4)); }
			else {out.print("&nbsp;");}%>
		</td>		
		<td align="right">
			<%if (arrivedLogReport.getInventoryQty()!=0) {
				out.print( arrivedLogReport.doubleFormat(arrivedLogReport.getInventoryQty(),4)); }
			else {out.print("&nbsp;");}%>
		</td>						
		<td align="right">
			<%if (arrivedLogReport.getUnitPrice()!=0) {
				out.print( arrivedLogReport.doubleFormat(arrivedLogReport.getUnitPrice(),2)); }
			else {out.print("&nbsp;");}%>
		</td>
		<td align="right">
			<%if (arrivedLogReport.getAmt()!=0) {
				out.print( arrivedLogReport.doubleFormat(arrivedLogReport.getAmt(),2)); }
			else {out.print("&nbsp;");}%>
		</td>
		<td align="right">
			<%if (arrivedLogReport.getPrepayAmt()!=0) {
				out.print( arrivedLogReport.doubleFormat(arrivedLogReport.getPrepayAmt(),2)); }
			else {out.print("&nbsp;");}%>
		</td>		
		<td align="right">
			<%if (arrivedLogReport.getSpareAmt()!=0) {
				out.print( arrivedLogReport.doubleFormat(arrivedLogReport.getSpareAmt(),2)); }
			else {out.print("&nbsp;");}%>
		</td>		
    	        <td align="center">
    	        	<%if ((arrivedLogReport.getRemark()!=null)&&(!arrivedLogReport.getRemark().equals(""))) {
    	        		out.print( arrivedLogReport.getRemark()); }
    	        	else {out.print("&nbsp;");}%>
    	        </td>		
	</tr>

<%
}
arrivedLogReport.setRecordNum(arrivedLogReport.getCountNum());
recordNum=arrivedLogReport.getCountNum();
arrivedLogReport.setTotalPage();
position = arrivedLogReport.listPosition;
state = arrivedLogReport.state;
curPage = arrivedLogReport.curPage;
totalPage = arrivedLogReport.totalPage;
arrivedLogReport.rs.close();
%>
<%if (arrivedLogReport.getCountNum()==0) {%>
	<jsp:forward page="../pub/DBErr.jsp?rtcode=-103"/>
<%}%>
<%
arrivedLogReport.countNum=0;
%>

</table>
<p>
<table border="0" align="center">
<tr><td>
<div id = "pannel" class="text">
		<input type="button" value=" 打印 " onclick=" window.pannel.style.visibility='hidden';window.print(); window.pannel.style.display='block';">
<%    if (totalPage==1/*position==0&&state==0*/){ %>
         页码 <%=curPage %>&nbsp/&nbsp<%=totalPage%>                     
<% } else if (curPage==1/*position==0&&state==2*/){ %>
	<a href="ArrivedLogReport.jsp?browseMode=next&position=<%=position%>&curPage=<%=curPage%>">下一页</a>&nbsp&nbsp&nbsp页码 <%=curPage %>&nbsp/&nbsp<%=totalPage%>
<% } else if (curPage==totalPage/*position>0&&state==-1*/){ %>
	<a href="ArrivedLogReport.jsp?browseMode=previous&position=<%=position%>&curPage=<%=curPage%>">上一页</a>&nbsp&nbsp&nbsp&nbsp&nbsp页码 <%=curPage %>&nbsp/&nbsp<%=totalPage%>
<% } else if (curPage<totalPage/*position>0&&state==1*/){ %>
	<a href="ArrivedLogReport.jsp?browseMode=previous&position=<%=position%>&curPage=<%=curPage%>">上一页</a>&nbsp&nbsp<a href="ArrivedLogReport.jsp?browseMode=next&position=<%=position%>&curPage=<%=curPage%>">下一页</a>&nbsp&nbsp页码 <%=curPage %>&nbsp/&nbsp<%=totalPage%>
<% } %>	
</tr></td>
</div>	
</table>
<p>
</body>
</html>

⌨️ 快捷键说明

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