📄 orderlogreport.jsp
字号:
<%@page import="java.sql.*"%>
<jsp:useBean id="orderLogReport" class="src.report.OrderLogReport" 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>
<%
//orderLogReport.setGlobal(global);
//orderLogReport.conditionSetup(request);
int position,state,curPage,totalPage;
int numInOnePage = orderLogReport.getNumInOnePage();
orderLogReport.listPage(request);
//查询出每页的纪录
orderLogReport.orderLogReport();
//totalPage = orderLogReport.totalPage;
%>
<body>
<center><br><FONT class="f16">江苏五洋集团有限公司 <%= orderLogReport.getStringDate(orderLogReport.beginDate,1) %> 年定货记录表</FONT><center>
<%= orderLogReport.getStringDate(orderLogReport.beginDate,1) %>-<%= orderLogReport.getStringDate(orderLogReport.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>
</tr>
<%
for(int listCount = 0; listCount < numInOnePage && (orderLogReport.next() > 0) ; listCount++) {
//while (orderLogReport.next() > 0) {
%>
<tr>
<td align="center">
<%if ((orderLogReport.getNeedDate()!=null)&&(!orderLogReport.getNeedDate().equals(""))) {
out.println(orderLogReport.getStringDate(orderLogReport.getNeedDate(),1)+"-"+orderLogReport.getStringDate(orderLogReport.getNeedDate(),2)+"-"+orderLogReport.getStringDate(orderLogReport.getNeedDate(),3)); }
else {out.println(" ");}%>
</td>
<td align="center">
<%if ((orderLogReport.getDeptName()!=null)&&(!orderLogReport.getDeptName().equals(""))) {
out.println(orderLogReport.getDeptName()); }
else {out.println(" ");} %></td>
<td align="center">
<%if ((orderLogReport.getCustomerName()!=null)&&(!orderLogReport.getCustomerName().equals(""))) {
out.println(orderLogReport.getCustomerName()); }
else {out.println(" ");} %></td>
<td align="left">
<%if ((orderLogReport.getUseFor()!=null)&&(!orderLogReport.getUseFor().equals(""))) {
out.println(orderLogReport.getUseFor()+" "); }
else
{out.println(" ");} %></td>
<td align="center">
<%if ((orderLogReport.getProductName()!=null)&&(!orderLogReport.getProductName().equals(""))) {
out.println(orderLogReport.getProductName()); }
else {out.println(" ");} %></td>
<td align="right">
<%if (orderLogReport.getPrepayQty()!=0) {
out.println(orderLogReport.doubleFormat(orderLogReport.getPrepayQty(),4)); }
else {out.println(" ");} %></td>
<td align="right">
<%if (orderLogReport.getUnitPrice()!=0) {
out.println(orderLogReport.doubleFormat(orderLogReport.getUnitPrice(),2)); }
else {out.println(" ");}%></td>
<td align="right">
<%if (orderLogReport.getPrepayAmt()!=0) {
out.println(orderLogReport.doubleFormat(orderLogReport.getPrepayAmt(),2)); }
else {out.println(" ");} %></td>
<td align="center">
<%if (orderLogReport.getUseWay()<3) {
switch (orderLogReport.getUseWay()) {
case 0:
out.println("现金");
break;
case 1:
out.println("汇票");
break;
case 2:
out.println("转帐");
break;
default:
break;
}
}
else {out.println(" "); }%></td>
<td align="center"><%= orderLogReport.getBank() %> <%= orderLogReport.getBankAccount() %></td>
<td align="left">
<%if ((orderLogReport.getComment()!=null)&&(!orderLogReport.getComment().equals(""))) {
out.println(orderLogReport.getComment()+" ");}
else {out.println(" ");} %></td>
</tr>
<%
}
orderLogReport.setRecordNum(orderLogReport.getCountNum());
orderLogReport.setTotalPage();
position = orderLogReport.listPosition;
state = orderLogReport.state;
curPage = orderLogReport.curPage;
//orderLogReport.totalPage=orderLogReport.getCountNum();
totalPage = orderLogReport.totalPage;
orderLogReport.rs.close();
%>
<%if (orderLogReport.getCountNum()==0) {%>
<jsp:forward page="../pub/DBErr.jsp?rtcode=-103"/>
<%}%>
<%
orderLogReport.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 %> / <%=totalPage%>
<% } else if (curPage==1/*position==0&&state==2*/){ %>
<a href="OrderLogReport.jsp?browseMode=next&position=<%=position%>&curPage=<%=curPage%>">下一页</a>   页码 <%=curPage %> / <%=totalPage%>
<% } else if (curPage==totalPage/*position>0&&state==-1*/){ %>
<a href="OrderLogReport.jsp?browseMode=previous&position=<%=position%>&curPage=<%=curPage%>">上一页</a>     页码 <%=curPage %> / <%=totalPage%>
<% } else if (curPage<totalPage/*position>0&&state==1*/){ %>
<a href="OrderLogReport.jsp?browseMode=previous&position=<%=position%>&curPage=<%=curPage%>">上一页</a>  <a href="OrderLogReport.jsp?browseMode=next&position=<%=position%>&curPage=<%=curPage%>">下一页</a>  页码 <%=curPage %> / <%=totalPage%>
<% } %>
</tr></td>
</div>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -