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

📄 deptmoneylist.jsp

📁 (Java+SQL)-大型企业JAVA的ERP系统
💻 JSP
字号:
<jsp:useBean id="deptMoney" class="src.wuyang.DeptMoney" scope="page"/>
<jsp:useBean id="global" class="src.com.MyGlobal" scope="session"/>
<jsp:setProperty name="deptMoney" property="*" />

<% if (global.isLogined == false) {
%>
<jsp:forward page="../pub/DBErr.jsp" > 
	<jsp:param name="rtcode" value="-4" />
</jsp:forward>
<%	}
 	
 	String mode = request.getParameter("mode");
 	int recordNum;
 	 	
	deptMoney.whereClause = deptMoney.getWhereClause(request);
	recordNum = deptMoney.query(deptMoney.whereClause,"deptId,endDate"); 
	if(recordNum == -1){
%>
<jsp:forward page="../pub/Err.jsp?ErrNo=3" />
<%
	}else if(recordNum == 0){
%>
<jsp:forward page="../pub/Err.jsp?ErrNo=4" />
<%
	}
%>

<html>
<head>
<title>驻外办收款列表</title>
<link rel="stylesheet" href="css.css" type="text/css">
</head>

<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="90%" border="1" class="textb" height="76" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
          <tr bgcolor="#949b93" class="textb"> 
            <td align="center"><font color="#000000"><b>驻外办名称</b></font> </td>
            <td align="center"><font color="#000000"><b>收款日期</b></font> </td>
            <td align="center"><font color="#000000"><b>收款金额</b></font> </td>
          </tr>
          <%
        float total = 0;
	for(int listCount = 0; listCount < recordNum && (deptMoney.next() > 0) ; listCount++) {
%>
          <tr class="text"> 
            <td align="left"><a href="DeptMoneyDetail.jsp?number=<%=deptMoney.getNumber()%>&mode=<%=mode%>"><font color="#0000FF"><%=deptMoney.getDeptName()%></font></a> 
            </td>
            <td align="left"><%=deptMoney.getStringDate(deptMoney.getEndDate(),0)%> 
            </td>
            <td align="right"><%=deptMoney.doubleFormat(deptMoney.getMoney(),2)%> 
            </td>
          </tr>
          <%
	total = total + deptMoney.getMoney();
	}
%>
          <tr class="textb"> 
            <td align="left" class="textb"><font color="#000000"><b>总计</b></font> </td>
            <td align="left" class="textb"><font color="#000000"></font> </td>
            <td align="right" class="textb"><font color="#000000"><b><%=deptMoney.doubleFormat(total,2)%></b></font> 
            </td>
          </tr>
        </table>
        <p>&nbsp;</p>
      </blockquote>
    </td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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