__stockledgerview.java

一个较大的java进销存系统

                String endDateStr = request.getParameter("endDate"); //[ /stockledgerview.jsp; Line: 32]
                if (selectedIndex == 0 | selectedIndex == 1 | selectedIndex == 2 | //[ /stockledgerview.jsp; Line: 33]
                selectedIndex == 3 | selectedIndex == 4 | selectedIndex == 5  | selectedIndex == 6) { //[ /stockledgerview.jsp; Line: 34]
                    if (searchValue.length() == 0) { //[ /stockledgerview.jsp; Line: 35]
                        out.print("<h3>请输入查询值</h3>"); //[ /stockledgerview.jsp; Line: 36]
                        return; //[ /stockledgerview.jsp; Line: 37]
                    } //[ /stockledgerview.jsp; Line: 38]
                    switch (selectedIndex) { //[ /stockledgerview.jsp; Line: 39]
                        case 0: //[ /stockledgerview.jsp; Line: 40]
                        //根据进货单编号取得记录 //[ /stockledgerview.jsp; Line: 41]
                        stockLedgers = stockManagementData.getStockLedgerByStringField( //[ /stockledgerview.jsp; Line: 42]
                        ledgerDate, "orderId", searchValue, 0); //[ /stockledgerview.jsp; Line: 43]
                        break; //[ /stockledgerview.jsp; Line: 44]
                        case 1: //[ /stockledgerview.jsp; Line: 45]
                        //根据请购员取得记录 //[ /stockledgerview.jsp; Line: 46]
                        stockLedgers = stockManagementData.getStockLedgerByStringField( //[ /stockledgerview.jsp; Line: 47]
                        ledgerDate, "submitUser", searchValue, 0); //[ /stockledgerview.jsp; Line: 48]
                        break; //[ /stockledgerview.jsp; Line: 49]
                        case 2: //[ /stockledgerview.jsp; Line: 50]
                        //根据订购员取得记录 //[ /stockledgerview.jsp; Line: 51]
                        stockLedgers = stockManagementData.getStockLedgerByStringField( //[ /stockledgerview.jsp; Line: 52]
                        ledgerDate, "commitUser", searchValue, 0); //[ /stockledgerview.jsp; Line: 53]
                        break; //[ /stockledgerview.jsp; Line: 54]
                        case 3: //[ /stockledgerview.jsp; Line: 55]
                        //根据验收员取得记录 //[ /stockledgerview.jsp; Line: 56]
                        stockLedgers = stockManagementData.getStockLedgerByStringField( //[ /stockledgerview.jsp; Line: 57]
                        ledgerDate, "checkUser", searchValue, 0); //[ /stockledgerview.jsp; Line: 58]
                        break; //[ /stockledgerview.jsp; Line: 59]
                        case 4: //[ /stockledgerview.jsp; Line: 60]
                        //根据收货地址取得记录 //[ /stockledgerview.jsp; Line: 61]
                        stockLedgers = stockManagementData.getStockLedgerByStringField( //[ /stockledgerview.jsp; Line: 62]
                        ledgerDate, "address", searchValue, 0); //[ /stockledgerview.jsp; Line: 63]
                        break; //[ /stockledgerview.jsp; Line: 64]
                        case 5: //[ /stockledgerview.jsp; Line: 65]
                        //根据仓库名字取得记录 //[ /stockledgerview.jsp; Line: 66]
                        stockLedgers = stockManagementData.getStockLedgerByStringField( //[ /stockledgerview.jsp; Line: 67]
                        ledgerDate, "warehouse", searchValue, 0); //[ /stockledgerview.jsp; Line: 68]
                        break; //[ /stockledgerview.jsp; Line: 69]
                        case 6: //[ /stockledgerview.jsp; Line: 70]
                        if(dataMethod.checkInt(searchValue) == 0){ //[ /stockledgerview.jsp; Line: 71]
                            out.print("<h3>按完成状态查询时，输入值必须是整数，" //[ /stockledgerview.jsp; Line: 72]
                            + "0表示进行，1表示撤消，2表示完成.</h3>"); //[ /stockledgerview.jsp; Line: 73]
                            return; //[ /stockledgerview.jsp; Line: 74]
                        } //[ /stockledgerview.jsp; Line: 75]
                        //根据完成状态取得记录 //[ /stockledgerview.jsp; Line: 76]
                        stockLedgers = stockManagementData.getStockLedgerByOnProcess( //[ /stockledgerview.jsp; Line: 77]
                        ledgerDate, 0, Integer.parseInt(searchValue)); //[ /stockledgerview.jsp; Line: 78]
                        break; //[ /stockledgerview.jsp; Line: 79]
                    } //[ /stockledgerview.jsp; Line: 80]
                }else{ //[ /stockledgerview.jsp; Line: 81]
                    java.sql.Timestamp startDate = dataMethod.transferDate(startDateStr); //[ /stockledgerview.jsp; Line: 82]
                    java.sql.Timestamp endDate = dataMethod.transferEndDate(endDateStr); //[ /stockledgerview.jsp; Line: 83]
                    if(startDate == null | endDate == null){ //[ /stockledgerview.jsp; Line: 84]
                        out.print("<h3>日期输入错误，正确的日期格式是" //[ /stockledgerview.jsp; Line: 85]
                        + "yyyy-mm-dd（年-月-日），如2004-1-1.</h3>"); //[ /stockledgerview.jsp; Line: 86]
                        return; //[ /stockledgerview.jsp; Line: 87]
                    } //[ /stockledgerview.jsp; Line: 88]
                    //根据日期取得记录 //[ /stockledgerview.jsp; Line: 89]
                    stockLedgers = stockManagementData.getStockLedgerByOrderDate(ledgerDate, //[ /stockledgerview.jsp; Line: 90]
                    startDate, endDate, 0); //[ /stockledgerview.jsp; Line: 91]
                } //[ /stockledgerview.jsp; Line: 92]
            } //[ /stockledgerview.jsp; Line: 93]
            //创建表格标题数组 //[ /stockledgerview.jsp; Line: 94]
            String[] colNames = {"单据编号", "单据类型", "供应商", "请购员", "订购员", "验收员", //[ /stockledgerview.jsp; Line: 95]
                "现金管理员", "收货地址", "仓库名", "订单日期", "到货日期", "完成状态", "备注"}; //[ /stockledgerview.jsp; Line: 96]
            out.print("\r\n<html>\r\n<head>\r\n<title>进货单查看页面：用户(");
            out.print(String.valueOf(userName));  //[ /stockledgerview.jsp; Line: 100]
            out.print("):账套(");
            out.print(String.valueOf(ledgerDate));  //[ /stockledgerview.jsp; Line: 100]
            out.print(")</title>\r\n</head>\r\n<body bgcolor=\"#ffffff\">\r\n<center>\r\n<h3>进货单查看页面:用户(");
            out.print(String.valueOf(userName));  //[ /stockledgerview.jsp; Line: 104]
            out.print("):账套(");
            out.print(String.valueOf(ledgerDate));  //[ /stockledgerview.jsp; Line: 104]
            out.print(")</h3>\r\n<form action=\"stockledgerview.jsp\" method=\"get\">\r\n<p>\r\n  查询条件：\r\n  <select name=\"selectedIndex\">\r\n    <option value=\"0\">根据单据编号查询</option>\r\n    <option value=\"1\">根据请购员查询</option>\r\n    <option value=\"2\">根据订购员查询</option>\r\n    <option value=\"3\">根据验收员查询</option>\r\n    <option value=\"4\">根据收货地址查询</option>\r\n    <option value=\"5\">根据仓库名查询</option>\r\n    <option value=\"6\">根据完成状态查询</option>\r\n    <option value=\"7\">根据订单日期查询</option>\r\n  </select>\r\n  查询值：\r\n  <input name=\"searchValue\" type=\"text\" size=\"18\">\r\n</p>\r\n<p>\r\n  开始日期：\r\n  <input name=\"startDate\" type=\"text\" size=\"12\">\r\n  结束日期：\r\n  <input name=\"endDate\" type=\"text\" size=\"12\">\r\n  <input name=\"search\" type=\"submit\" value=\"查询\">\r\n</p>\r\n</form>\r\n<hr size=\"3\" color=\"#0066FF\">\r\n<!--根据库存账套数组显示表格内容-->\r\n<table width=\"100%\" border=\"1\">\r\n  <tr align=\"center\">\r\n    ");
            for(int i = 0; i < colNames.length; i++){ //[ /stockledgerview.jsp; Line: 133]
                //[ /stockledgerview.jsp; Line: 133]
                out.print("\r\n      <td><font size=\"-1\">");
                out.print(String.valueOf(colNames[i]));  //[ /stockledgerview.jsp; Line: 134]
                out.print("</font></td>\r\n    ");
            } //[ /stockledgerview.jsp; Line: 135]
            //[ /stockledgerview.jsp; Line: 135]
            out.print("\r\n  </tr>\r\n  ");
            for (int i = 0; i < stockLedgers.length; i++){ //[ /stockledgerview.jsp; Line: 137]
                //[ /stockledgerview.jsp; Line: 137]
                out.print("\r\n    <tr align=\"left\">\r\n      ");
                for(int j = 0; j < stockLedgers[0].length; j++){ //[ /stockledgerview.jsp; Line: 139]
                    if(j == stockLedgers[0].length - 1){ //[ /stockledgerview.jsp; Line: 140]
                        //[ /stockledgerview.jsp; Line: 140]
                        out.print("\r\n          <td>\r\n            <font size=\"-1\">\r\n\t      <textarea name=\"remark\" cols=\"10\" rows=\"1\">");
                        out.print(String.valueOf(stockLedgers[i][j]));  //[ /stockledgerview.jsp; Line: 143]
                        out.print("</textarea>\r\n\t    </font>\r\n          </td>\r\n        ");
                    }else if(j == 0){ //[ /stockledgerview.jsp; Line: 146]
                        //[ /stockledgerview.jsp; Line: 146]
                        out.print("\r\n            <td>\r\n              <font size=\"-1\">\r\n                 <a href=\"stocksubledgerview.jsp?orderId=");
                        out.print(String.valueOf(stockLedgers[i][j]));  //[ /stockledgerview.jsp; Line: 149]
                        out.print("\" target=\"stocksubledger\">\r\n                   ");
                        out.print(String.valueOf(stockLedgers[i][j]));  //[ /stockledgerview.jsp; Line: 150]
                        out.print("\r\n                 </a>\r\n              </font>\r\n            </td>\r\n        ");
                    }else{ //[ /stockledgerview.jsp; Line: 154]
                        //[ /stockledgerview.jsp; Line: 154]
                        out.print("\r\n            <td><font size=\"-1\">");
                        out.print(String.valueOf(stockLedgers[i][j]));  //[ /stockledgerview.jsp; Line: 155]
                        out.print("&nbsp;</font></td>\r\n      ");
                    } //[ /stockledgerview.jsp; Line: 156]
                } //[ /stockledgerview.jsp; Line: 157]
                //[ /stockledgerview.jsp; Line: 157]
                out.print("\r\n    </tr>\r\n  ");
            } //[ /stockledgerview.jsp; Line: 159]
            //[ /stockledgerview.jsp; Line: 159]
            out.print("\r\n</table>\r\n</center>\r\n</body>\r\n</html>");
        } catch (Throwable __ee) {
            while (out != null && out != _originalOut) out = pageContext.popBody();
            ((weblogic.servlet.jsp.PageContextImpl)pageContext).handlePageException((Throwable)__ee);
        }
        
        
        //before final close brace...
    }
    
    
}