__stockmanageledgerview.java

一个使用java 写的进销存代码 使用了ejb 等技术 是学习j2ee的好

                int selectedIndex = Integer.parseInt(request.getParameter("selectedIndex")); //[ /stockmanageledgerview.jsp; Line: 31]
                String searchValue = request.getParameter("searchValue"); //[ /stockmanageledgerview.jsp; Line: 32]
                String startDateStr = request.getParameter("startDate"); //[ /stockmanageledgerview.jsp; Line: 33]
                String endDateStr = request.getParameter("endDate"); //[ /stockmanageledgerview.jsp; Line: 34]
                if (selectedIndex == 0 | selectedIndex == 1 | selectedIndex == 2 | //[ /stockmanageledgerview.jsp; Line: 35]
                selectedIndex == 3 | selectedIndex == 4 | selectedIndex == 5) { //[ /stockmanageledgerview.jsp; Line: 36]
                    if (searchValue.length() == 0) { //[ /stockmanageledgerview.jsp; Line: 37]
                        out.print("<h3>请输入查询值</h3>"); //[ /stockmanageledgerview.jsp; Line: 38]
                        return; //[ /stockmanageledgerview.jsp; Line: 39]
                    } //[ /stockmanageledgerview.jsp; Line: 40]
                    switch (selectedIndex) { //[ /stockmanageledgerview.jsp; Line: 41]
                        case 0: //[ /stockmanageledgerview.jsp; Line: 42]
                        //根据单据编号取得记录 //[ /stockmanageledgerview.jsp; Line: 43]
                        stockLedgers = stockManagementData.getStockLedgerByStringField( //[ /stockmanageledgerview.jsp; Line: 44]
                        ledgerDate, "orderId", searchValue, orderType); //[ /stockmanageledgerview.jsp; Line: 45]
                        break; //[ /stockmanageledgerview.jsp; Line: 46]
                        case 1: //[ /stockmanageledgerview.jsp; Line: 47]
                        //根据填写用户取得记录 //[ /stockmanageledgerview.jsp; Line: 48]
                        stockLedgers = stockManagementData.getStockLedgerByStringField( //[ /stockmanageledgerview.jsp; Line: 49]
                        ledgerDate, "submitUser", searchValue, orderType); //[ /stockmanageledgerview.jsp; Line: 50]
                        break; //[ /stockmanageledgerview.jsp; Line: 51]
                        case 2: //[ /stockmanageledgerview.jsp; Line: 52]
                        //根据检查用户取得记录 //[ /stockmanageledgerview.jsp; Line: 53]
                        stockLedgers = stockManagementData.getStockLedgerByStringField( //[ /stockmanageledgerview.jsp; Line: 54]
                        ledgerDate, "checkUser", searchValue, orderType); //[ /stockmanageledgerview.jsp; Line: 55]
                        break; //[ /stockmanageledgerview.jsp; Line: 56]
                        case 3: //[ /stockmanageledgerview.jsp; Line: 57]
                        //根据调出/调入仓库名字取得记录 //[ /stockmanageledgerview.jsp; Line: 58]
                        stockLedgers = stockManagementData.getStockLedgerByStringField( //[ /stockmanageledgerview.jsp; Line: 59]
                        ledgerDate, "commitUser", searchValue, orderType); //[ /stockmanageledgerview.jsp; Line: 60]
                        break; //[ /stockmanageledgerview.jsp; Line: 61]
                        case 4: //[ /stockmanageledgerview.jsp; Line: 62]
                        //根据仓库名取得记录 //[ /stockmanageledgerview.jsp; Line: 63]
                        stockLedgers = stockManagementData.getStockLedgerByStringField( //[ /stockmanageledgerview.jsp; Line: 64]
                        ledgerDate, "warehouse", searchValue, orderType); //[ /stockmanageledgerview.jsp; Line: 65]
                        break; //[ /stockmanageledgerview.jsp; Line: 66]
                        case 5: //[ /stockmanageledgerview.jsp; Line: 67]
                        if(dataMethod.checkInt(searchValue) == 0){ //[ /stockmanageledgerview.jsp; Line: 68]
                            out.print("<h3>按完成状态查询时，输入值必须是整数，" //[ /stockmanageledgerview.jsp; Line: 69]
                            + "0表示进行，1表示撤消，2表示完成，3表示盘点单撤消，4表示盘点单完成.</h3>"); //[ /stockmanageledgerview.jsp; Line: 70]
                            return; //[ /stockmanageledgerview.jsp; Line: 71]
                        } //[ /stockmanageledgerview.jsp; Line: 72]
                        //根据完成状态取得记录 //[ /stockmanageledgerview.jsp; Line: 73]
                        stockLedgers = stockManagementData.getStockLedgerByOnProcess( //[ /stockmanageledgerview.jsp; Line: 74]
                        ledgerDate, orderType, Integer.parseInt(searchValue)); //[ /stockmanageledgerview.jsp; Line: 75]
                        break; //[ /stockmanageledgerview.jsp; Line: 76]
                    } //[ /stockmanageledgerview.jsp; Line: 77]
                }else{ //[ /stockmanageledgerview.jsp; Line: 78]
                    java.sql.Timestamp startDate = dataMethod.transferDate(startDateStr); //[ /stockmanageledgerview.jsp; Line: 79]
                    java.sql.Timestamp endDate = dataMethod.transferEndDate(endDateStr); //[ /stockmanageledgerview.jsp; Line: 80]
                    if(startDate == null | endDate == null){ //[ /stockmanageledgerview.jsp; Line: 81]
                        out.print("<h3>日期输入错误，正确的日期格式是" //[ /stockmanageledgerview.jsp; Line: 82]
                        + "yyyy-mm-dd（年-月-日），如2004-1-1.</h3>"); //[ /stockmanageledgerview.jsp; Line: 83]
                        return; //[ /stockmanageledgerview.jsp; Line: 84]
                    } //[ /stockmanageledgerview.jsp; Line: 85]
                    //根据日期取得记录 //[ /stockmanageledgerview.jsp; Line: 86]
                    stockLedgers = stockManagementData.getStockLedgerByOrderDate(ledgerDate, //[ /stockmanageledgerview.jsp; Line: 87]
                    startDate, endDate, orderType); //[ /stockmanageledgerview.jsp; Line: 88]
                } //[ /stockmanageledgerview.jsp; Line: 89]
            } //[ /stockmanageledgerview.jsp; Line: 90]
            //创建表格标题数组 //[ /stockmanageledgerview.jsp; Line: 91]
            String[] colNames = {"单据编号", "单据类型", "关联标识", "填写用户", "调出/调入仓库", "检查用户", //[ /stockmanageledgerview.jsp; Line: 92]
                "", "", "仓库名", "填写日期", "系统日期", "完成状态", "备注"}; //[ /stockmanageledgerview.jsp; Line: 93]
            out.print("\r\n<html>\r\n<head>\r\n<title>库存单据查看页面：用户(");
            out.print(String.valueOf(userName));  //[ /stockmanageledgerview.jsp; Line: 97]
            out.print("):账套(");
            out.print(String.valueOf(ledgerDate));  //[ /stockmanageledgerview.jsp; Line: 97]
            out.print(")</title>\r\n</head>\r\n<body bgcolor=\"#ffffff\">\r\n<center>\r\n<h3>库存单据查看页面:用户(");
            out.print(String.valueOf(userName));  //[ /stockmanageledgerview.jsp; Line: 101]
            out.print("):账套(");
            out.print(String.valueOf(ledgerDate));  //[ /stockmanageledgerview.jsp; Line: 101]
            out.print(")</h3>\r\n<form action=\"stockmanageledgerview.jsp\" method=\"get\">\r\n<p>\r\n  单据类型\r\n  <select name=\"orderType\">\r\n    <option value=\"2\">商品调出单</option>\r\n    <option value=\"3\">商品调入单</option>\r\n    <option value=\"6\">盘点损失单</option>\r\n    <option value=\"7\">盘点盈收单</option>\r\n    <option value=\"13\">盘点单</option>\r\n  </select>\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  </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=\"17\">\r\n  结束日期：\r\n  <input name=\"endDate\" type=\"text\" size=\"17\">\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++){ //[ /stockmanageledgerview.jsp; Line: 137]
                //[ /stockmanageledgerview.jsp; Line: 137]
                out.print("\r\n      <td><font size=\"-1\">");
                out.print(String.valueOf(colNames[i]));  //[ /stockmanageledgerview.jsp; Line: 138]
                out.print("</font></td>\r\n    ");
            } //[ /stockmanageledgerview.jsp; Line: 139]
            //[ /stockmanageledgerview.jsp; Line: 139]
            out.print("\r\n  </tr>\r\n  ");
            for (int i = 0; i < stockLedgers.length; i++){ //[ /stockmanageledgerview.jsp; Line: 141]
                //[ /stockmanageledgerview.jsp; Line: 141]
                out.print("\r\n    <tr align=\"left\">\r\n      ");
                for(int j = 0; j < stockLedgers[0].length; j++){ //[ /stockmanageledgerview.jsp; Line: 143]
                    if(j == stockLedgers[0].length - 1){ //[ /stockmanageledgerview.jsp; Line: 144]
                        //[ /stockmanageledgerview.jsp; Line: 144]
                        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]));  //[ /stockmanageledgerview.jsp; Line: 147]
                        out.print("</textarea>\r\n\t    </font>\r\n          </td>\r\n        ");
                    }else if(j == 0){ //[ /stockmanageledgerview.jsp; Line: 150]
                        //[ /stockmanageledgerview.jsp; Line: 150]
                        out.print("\r\n            <td>\r\n              <font size=\"-1\">\r\n                 <a href=\"stockmanagesubledgerview.jsp?orderId=");
                        out.print(String.valueOf(stockLedgers[i][j]));  //[ /stockmanageledgerview.jsp; Line: 153]
                        out.print("\" target=\"stockmanagesubledger\">\r\n                   ");
                        out.print(String.valueOf(stockLedgers[i][j]));  //[ /stockmanageledgerview.jsp; Line: 154]
                        out.print("\r\n                 </a>\r\n              </font>\r\n            </td>\r\n        ");
                    }else{ //[ /stockmanageledgerview.jsp; Line: 158]
                        //[ /stockmanageledgerview.jsp; Line: 158]
                        out.print("\r\n            <td><font size=\"-1\">");
                        out.print(String.valueOf(stockLedgers[i][j]));  //[ /stockmanageledgerview.jsp; Line: 159]
                        out.print("&nbsp;</font></td>\r\n      ");
                    } //[ /stockmanageledgerview.jsp; Line: 160]
                } //[ /stockmanageledgerview.jsp; Line: 161]
                //[ /stockmanageledgerview.jsp; Line: 161]
                out.print("\r\n    </tr>\r\n  ");
            } //[ /stockmanageledgerview.jsp; Line: 163]
            //[ /stockmanageledgerview.jsp; Line: 163]
            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...
    }
    
    
}