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

📄 productpricereport.jsp

📁 (Java+SQL)-大型企业JAVA的ERP系统
💻 JSP
字号:
<jsp:useBean id="ProductPriceReport" class="src.report.ProductPriceReport" scope="page"/>
<%@page errorPage="Err.jsp?errString=出错"%>
<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>
<%! int recordNum; %>
<%
    recordNum = ProductPriceReport.query("", "classId"); 
    ProductPriceReport.next();
    String classId = ProductPriceReport.getClassId();
    System.out.println("recordNum="+recordNum);
    int i = 1;
%>
<%if (recordNum==0) {%>
	<jsp:forward page="../pub/DBErr.jsp?rtcode=-103"/>
<%}%>
<body  leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" height="90%" cellspacing="0" cellpadding="0" align="center"  >
  <tr> 
    <td valign="top" > 
<br><br><blockquote>
<center><br>
      <b><span class="f16">产品销售定价表</span></b><span ><center><span > 
      单位:元/吨</span></span> 
        <table border="1" cellspacing="0" cellpadding="2" bordercolor="#000000">
          <tr > 
            <td > 
              <div align="center">品 名</div>
            </td>
            <td > 
              <div align="center">产 地</div>
            </td>
            <td > 
              <div align="center">价 格</div>
            </td>
          </tr>
          <tr> 
            <td colspan="3" ><%=i%>.<%=ProductPriceReport.getClassDesc()%></td>
          </tr>
          <%
do {
    if (ProductPriceReport.getClassId().equals(classId)) {
%>
          <tr > 
            <td align="center"><%
            	if ((ProductPriceReport.getProductName()!=null)&&(!ProductPriceReport.getProductName().equals(""))) {
            		out.println(ProductPriceReport.getProductName());}
            	else
            		{out.println("&nbsp;");}%></td>
            <td align="center"><%
            	if ((ProductPriceReport.getProductAddress()!=null)&&(!ProductPriceReport.getProductAddress().equals(""))) {
            		out.println(ProductPriceReport.getProductAddress());}
            	else
            		{out.println("&nbsp;");}%></td>
            <td align="right"><%
            	if (ProductPriceReport.getRefPrice()!=0) {
            		out.println(ProductPriceReport.doubleFormat(ProductPriceReport.getRefPrice(),2));}
            	else
            		{out.println("&nbsp;");} %></td>
          </tr>
          <%  } else {
     i++;
%>
          <tr> 
            <td colspan="3" ><%=i%>.<%=ProductPriceReport.getClassDesc()%></td>
          </tr>
          <tr > 
            <td align="center"><%
            	if ((ProductPriceReport.getProductName()!=null)&&(!ProductPriceReport.getProductName().equals(""))) {
            		out.println(ProductPriceReport.getProductName());}
            	else
            		{out.println("&nbsp;");}%></td>
            <td align="center"><%
            	if ((ProductPriceReport.getProductAddress()!=null)&&(!ProductPriceReport.getProductAddress().equals(""))) {
            		out.println(ProductPriceReport.getProductAddress());}
            	else
            		{out.println("&nbsp;");}%></td>
            <td align="right"><%
            	if (ProductPriceReport.getRefPrice()!=0) {
            		out.println(ProductPriceReport.doubleFormat(ProductPriceReport.getRefPrice(),2));}
            	else
            		{out.println("&nbsp;");} %></td>
          </tr>
          <%
    }
} while (ProductPriceReport.next() > 0);
%>
          <p> 
        </table>
<p>
<div id = "pannel" >
		<input type="button" value=" 打印 " onclick=" window.pannel.style.visibility='hidden';window.print(); window.pannel.style.display='block';">
</div>	</blockquote>
</td>
</tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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