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

📄 allocatcostlist.jsp

📁 (Java+SQL)-大型企业JAVA的ERP系统
💻 JSP
字号:
<jsp:useBean id="allocat" class="src.wuyang.Allocat" scope="session"/>
<jsp:useBean id="dept" class="src.wuyang.Department" scope="page"/>
<jsp:useBean id="allocatproduct" class="src.wuyang.ReportAllocat" 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" type="text/css">
</head>
<% 
	int position,state,curPage,totalPage;    
	int numInOnePage = allocat.getNumInOnePage();
	allocat.listPage(request);
	
	position = allocat.listPosition;
        state = allocat.state;
        curPage = allocat.curPage;
        totalPage = allocat.totalPage;
	
%>

<body bgcolor=#949b93>
<table width="100%" border="1" height="90%" bordercolorlight="#616860" bordercolordark="#CCCCCC" bgcolor="#4c7171" cellpadding="0" cellspacing="0">
  <tr> 
    <td valign="top" class="textb">
      <blockquote>
        <br>
          <br>
        <table width="1200" border="1" class="textb" height="76" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
          <tr bgcolor="#949b93" class="textb"> 
            <td width="80" > 
              <div align="center"><font color="#000000"><b>调拨单编号</b></font></div>
            </td>
            <td width="100" > 
              <div align="center"><font color="#000000"><b>部门名称</b></font></div>
            </td>
            <td width="80" > 
              <div align="center"><font color="#000000"><b>申请人员</b></font></div>
            </td>
            <td width="80" > 
              <div align="center"><font color="#000000"><b>申请日期</b></font></div>
            </td>
            <td width="100" > 
              <div align="center"><font color="#000000"><b>产品名称</b></font></div>
            </td>
            <td width="100" > 
              <div align="center"><font color="#000000"><b>规格/型号</b></font></div>
            </td>
            <td width="60" > 
              <div align="center"><font color="#000000"><b>单价</b></font></div>
            </td>
            <td width="80" > 
              <div align="center"><font color="#000000"><b>申请数量</b></font></div>
            </td>
            <td width="80" > 
              <div align="center"><font color="#000000"><b>实际数量</b></font></div>
            </td>
            <td width="100" > 
              <div align="center"><font color="#000000"><b>总价</b></font></div>
            </td>
            <td width="80" > 
              <div align="center"><font color="#000000"><b>仓储费</b></font></div>
            </td>
            <td width="80" > 
              <div align="center"><font color="#000000"><b>力费</b></font></div>
            </td>
            <td width="80" > 
              <div align="center"><font color="#000000"><b>运费</b></font></div>
            </td>
            <td width="100" > 
              <div align="center"><font color="#000000"><b>总费用</b></font></div>
            </td>
          </tr>
          <%
        float totalStoreFee = 0;
        float totalCarryFee = 0;
        float totalDeliveFee = 0;
        float totalFee = 0;
	for(int listCount = 0; listCount < numInOnePage && (allocat.next() > 0) ; listCount++) {
		float totalPrice = 0;
		allocatproduct.query("allocatId='"+allocat.getAllocatId()+"'","productId");
		for(;allocatproduct.next() > 0;) {
			totalPrice = allocatproduct.getActQuantity() * allocatproduct.getUnitPrice();
%> 
          <tr class="text"> 
            <td width="80" > 
              <div align="left"></div>
            </td>
            <td width="100" > 
              <div align="left"></div>
            </td>
            <td width="80" > 
              <div align="left"></div>
            </td>
            <td width="80" > 
              <div align="left"></div>
            </td>
            <td width="100"> 
              <div align="left"><%=allocatproduct.getProductName()%></div>
            </td>
            <td width="100"> 
              <div align="left"><%=allocatproduct.getProductDesc()%></div>
            </td>
            <td width="60"> 
              <div align="right"><%=allocatproduct.doubleFormat(allocatproduct.getUnitPrice(),2)%></div>
            </td>
            <td width="80"> 
              <div align="right"><%=allocatproduct.doubleFormat(allocatproduct.getQuantity(),2)%></div>
            </td>
            <td width="80"> 
              <div align="right"><%=allocatproduct.doubleFormat(allocatproduct.getActQuantity(),2)%></div>
            </td>
            <td width="100"> 
              <div align="right"><%=allocatproduct.doubleFormat(totalPrice,2)%></b></div>
            </td>
            <td width="80" > 
              <div align="right"></div>
            </td>
            <td width="80" > 
              <div align="right"></div>
            </td>
            <td width="80" > 
              <div align="right"></div>
            </td>
            <td width="100" > 
              <div align="right"></div>
            </td>
          </tr>
          <%
		}
		dept.load(allocat.getSubCompanyId());
		float subFee=allocat.getStoreFee()+allocat.getCarryFee()+allocat.getDeliveFee()+totalPrice;
		totalStoreFee = totalStoreFee + allocat.getStoreFee();
		totalCarryFee = totalCarryFee + allocat.getCarryFee();
		totalDeliveFee = totalDeliveFee + allocat.getDeliveFee();
		totalFee = totalFee + subFee;
%> 
          <tr class="textb"> 
            <td width="80" height="17" > 
              <div align="left"><font color="#000000"><%=allocat.getAllocatId()%></font></div>
            </td>
            <td width="100" height="17" > 
              <div align="left"><font color="#000000"><%=dept.getDeptName()%></font></div>
            </td>
            <td width="80" height="17" > 
              <div align="left"><font color="#000000"><%=allocat.getProposer()%></font></div>
            </td>
            <td width="80" height="17" > 
              <div align="left"><font color="#000000"><%=allocat.getStringDate(allocat.getAllocatDate(),0)%> 
                </b></font></div>
            </td>
            <td width="100" height="17" > 
              <div align="left"><font color="#000000">&nbsp;</font></div>
            </td>
            <td width="100" height="17" > 
              <div align="left"><font color="#000000">&nbsp;</font></div>
            </td>
            <td width="60" height="17" > 
              <div align="right"><font color="#000000">&nbsp;</font></div>
            </td>
            <td width="80" height="17" > 
              <div align="right"><font color="#000000">&nbsp;</font></div>
            </td>
            <td width="80" height="17" > 
              <div align="right"><font color="#000000">&nbsp;</font></div>
            </td>
            <td width="100" height="17" > 
              <div align="right"><font color="#000000"><%=allocat.doubleFormat(totalPrice,2)%></font></div>
            </td>
            <td width="80" height="17" > 
              <div align="right"><font color="#000000"><%=allocat.doubleFormat(allocat.getStoreFee(),2)%></font></div>
            </td>
            <td width="80" height="17" > 
              <div align="right"><font color="#000000"><%=allocat.doubleFormat(allocat.getCarryFee(),2)%></font></div>
            </td>
            <td width="80" height="17" > 
              <div align="right"><font color="#000000"><%=allocat.doubleFormat(allocat.getDeliveFee(),2)%></font></div>
            </td>
            <td width="100" height="17" > 
              <div align="right"><font color="#000000"><%=allocat.doubleFormat(subFee,2)%></font></div>
            </td>
          </tr>
          <%
	}
%> 
          <tr class="textb"> 
            <td class="textb" width="80" height="2"> 
              <div align="left"><font color="#000000"><b>总计:</b></font></div>
            </td>
            <td width="100" height="2" > 
              <div align="left"></div>
            </td>
            <td width="80" height="2" > 
              <div align="left"></div>
            </td>
            <td width="80" height="2" > 
              <div align="left"></div>
            </td>
            <td width="100" height="2" > 
              <div align="left"></div>
            </td>
            <td width="100" height="2" > 
              <div align="left"></div>
            </td>
            <td width="60" height="2" > 
              <div align="right"></div>
            </td>
            <td width="80" height="2" > 
              <div align="right"></div>
            </td>
            <td width="80" height="2" > 
              <div align="right"></div>
            </td>
            <td class="textb" width="100" height="2"> 
              <div align="right"><font color="#000000"><b><%=allocat.doubleFormat((totalFee-totalStoreFee-totalCarryFee-totalDeliveFee),2)%></b></font></div>
            </td>
            <td class="textb" width="80" height="2"> 
              <div align="right"><font color="#000000"><b><%=allocat.doubleFormat(totalStoreFee,2)%></b></font></div>
            </td>
            <td class="textb" width="80" height="2"> 
              <div align="right"><font color="#000000"><b><%=allocat.doubleFormat(totalCarryFee,2)%></b></font></div>
            </td>
            <td class="textb" width="80" height="2"> 
              <div align="right"><font color="#000000"><b><%=allocat.doubleFormat(totalDeliveFee,2)%></b></font></div>
            </td>
            <td class="textb" width="100" height="2"> 
              <div align="right"><font color="#000000"><b><%=allocat.doubleFormat(totalFee,2)%></b></font></div>
            </td>
          </tr>
        </table>
        <p>&nbsp;</p>
      </blockquote>
    </td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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