📄 accountreceivableview.jsp~3~

📁 java 通用进销存系统。很完整的说明文档和源码以及源程序。
💻 JSP~3~
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import = "data.*, user.*, method.DataMethod"%>
<%
  //设置取得字符串的编码机制
  request.setCharacterEncoding("GBK");
  String userName = "";
  if(session.getAttribute("user") != null){
    User user = (User)session.getAttribute("user");
    userName = user.getUserName();
  }else{
    out.print("<h3>请先登陆系统.</h3>");
    return;
  }
  String ledgerDate = "";
  if(session.getAttribute("ledgerDate") == null){
    out.print("<h3>请先选择账套.</h3>");
    return;
  }else{
    ledgerDate = (String)session.getAttribute("ledgerDate");
  }
  //创建应收账款数组
  String[][] currentAccountLedger = new String[0][11];
  //创建数据类
  StockManagementData stockManagementData = new StockManagementData();
  //创建方法类
  DataMethod dataMethod = new DataMethod();
  //根据传入参数取得应收账款数组
  if(request.getParameter("selectedIndex") != null){
    int selectedIndex = Integer.parseInt(request.getParameter("selectedIndex"));
    String searchValue = request.getParameter("searchValue");
    String startDateStr = request.getParameter("startDate");
    String endDateStr = request.getParameter("endDate");
    if (selectedIndex == 0 | selectedIndex == 1 | selectedIndex == 2 |
        selectedIndex == 3 | selectedIndex == 4 | selectedIndex == 5) {
      if (searchValue.length() == 0) {
        out.print("<h3>请输入查询值</h3>");
        return;
      }
      switch (selectedIndex) {
        case 0:
          //根据票据编号取得记录
          currentAccountLedger = stockManagementData.getCurrentAccountLedgerByStringField(
              ledgerDate, "currentAccountId", searchValue, 0);
          break;
        case 1:
          //根据关联票据标识取得记录
          currentAccountLedger = stockManagementData.getCurrentAccountLedgerByStringField(
              ledgerDate, "linkId", searchValue, 0);
          break;
        case 2:
          //根据供应商取得记录
          currentAccountLedger = stockManagementData.getCurrentAccountLedgerByStringField(
              ledgerDate, "receiverName", searchValue, 0);
          break;
        case 3:
          //根据验收员取得记录
          currentAccountLedger = stockManagementData.getCurrentAccountLedgerByStringField(
              ledgerDate, "documentFiller", searchValue, 0);
          break;
        case 4:
          //根据现金管理员取得记录
          currentAccountLedger = stockManagementData.getCurrentAccountLedgerByStringField(
              ledgerDate, "cashUser", searchValue, 0);
          break;
        case 5:
          if(dataMethod.checkInt(searchValue) == 0){
            out.print("<h3>按完成状态查询时，输入值必须是整数，"
                                          + "0表示进行，1表示撤消，2表示完成.</h3>");
            return;
          }
          //根据完成状态取得记录
          currentAccountLedger = stockManagementData.getCurrentAccountLedgerByOnProcess(
              ledgerDate, 0, Integer.parseInt(searchValue));
          break;
      }
    }else{
      java.sql.Timestamp startDate = dataMethod.transferDate(startDateStr);
      java.sql.Timestamp endDate = dataMethod.transferEndDate(endDateStr);
      if(startDate == null | endDate == null){
        out.print("<h3>日期输入错误，正确的日期格式是"
                                      + "yyyy-mm-dd（年-月-日），如2004-1-1</h3>");
        return;
      }
      //根据日期取得记录
      currentAccountLedger = stockManagementData.getCurrentAccountLedgerByFillDate(ledgerDate,
          startDate, endDate, 0);
    }
  }
  //创建表格标题数组
  String[] colNames = {"单据编号", "关联票据标识", "票据类型", "金额", "供应商名字", "验收员", "现金管理员",
               "开票据日期", "付款日期", "完成状态", "备注"};
%>
<html>
<head>
<title>应收账款查看页面：用户(<%=userName%>):账套(<%=ledgerDate%>)</title>
</head>
<body bgcolor="#ffffff">
<center>
<h3>应收账款查看页面:用户(<%=userName%>):账套(<%=ledgerDate%>)</h3>
<form action="accountpayableview.jsp" method="get">
<p>
  查询条件：
  <select name="selectedIndex">
    jComboBox1.addItem("根据票据编号查询");
    jComboBox1.addItem("根据客户查询");
    jComboBox1.addItem("根据开票据用户查询");
    jComboBox1.addItem("根据现金管理员查询");
    jComboBox1.addItem("根据完成状态查询");
    jComboBox1.addItem("根据开票据日期查询");

    <option value="0">根据票据编号查询</option>
    <option value="1">根据客户查询</option>
    <option value="2">根据开票据用户查询</option>
    <option value="3">根据现金管理员查询</option>
    <option value="5">根据完成状态查询</option>
    <option value="6">根据开票据日期查询</option>
  </select>
  查询值：
  <input name="searchValue" type="text" size="18">
</p>
<p>
  开始日期：
  <input name="startDate" type="text" size="12">
  结束日期：
  <input name="endDate" type="text" size="12">
  <input name="search" type="submit" value="查询">
</p>
</form>
<hr size="3" color="#0066FF">
<!--根据应收账款数组显示表格内容-->
<table width="100%" border="1">
  <tr align="center">
    <%for(int i = 0; i < colNames.length; i++){%>
      <td><font size="-1"><%=colNames[i]%></font></td>
    <%}%>
  </tr>
  <%for (int i = 0; i < currentAccountLedger.length; i++){%>
    <tr align="left">
      <%for(int j = 0; j < currentAccountLedger[0].length; j++){
        if(j == currentAccountLedger[0].length - 1){%>
          <td>
            <font size="-1">
	      <textarea name="remark" cols="10" rows="1"><%=currentAccountLedger[i][j]%></textarea>
	    </font>
          </td>
        <%}else{%>
            <td><font size="-1"><%=currentAccountLedger[i][j]%>&nbsp;</font></td>
      <%  }
        }%>
    </tr>
  <%}%>
</table>
</center>
</body>
</html>
⌨️ 快捷键说明

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