__saleledgerview.java

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

                        return; //[ /saleledgerview.jsp; Line: 40]
                    } //[ /saleledgerview.jsp; Line: 41]
                    switch (selectedIndex) { //[ /saleledgerview.jsp; Line: 42]
                        case 0: //[ /saleledgerview.jsp; Line: 43]
                        //根据销售单编号取得记录 //[ /saleledgerview.jsp; Line: 44]
                        saleLedgers = stockManagementData.getSaleLedgerByStringField( //[ /saleledgerview.jsp; Line: 45]
                        ledgerDate, "saleId", searchValue, saleType); //[ /saleledgerview.jsp; Line: 46]
                        break; //[ /saleledgerview.jsp; Line: 47]
                        case 1: //[ /saleledgerview.jsp; Line: 48]
                        //根据客户取得记录 //[ /saleledgerview.jsp; Line: 49]
                        saleLedgers = stockManagementData.getSaleLedgerByStringField( //[ /saleledgerview.jsp; Line: 50]
                        ledgerDate, "customerName", searchValue, saleType); //[ /saleledgerview.jsp; Line: 51]
                        break; //[ /saleledgerview.jsp; Line: 52]
                        case 2: //[ /saleledgerview.jsp; Line: 53]
                        if(saleType == 0 | saleType == 2){ //[ /saleledgerview.jsp; Line: 54]
                            //根据前台销售员取得记录 //[ /saleledgerview.jsp; Line: 55]
                            saleLedgers = stockManagementData.getSaleLedgerByStringField( //[ /saleledgerview.jsp; Line: 56]
                            ledgerDate, "counterUser", searchValue, saleType); //[ /saleledgerview.jsp; Line: 57]
                        }else{ //[ /saleledgerview.jsp; Line: 58]
                            //根据信用销售员取得记录 //[ /saleledgerview.jsp; Line: 59]
                            saleLedgers = stockManagementData.getSaleLedgerByStringField( //[ /saleledgerview.jsp; Line: 60]
                            ledgerDate, "creditUser", searchValue, saleType); //[ /saleledgerview.jsp; Line: 61]
                        } //[ /saleledgerview.jsp; Line: 62]
                        break; //[ /saleledgerview.jsp; Line: 63]
                        case 3: //[ /saleledgerview.jsp; Line: 64]
                        //根据现金管理员取得记录 //[ /saleledgerview.jsp; Line: 65]
                        saleLedgers = stockManagementData.getSaleLedgerByStringField( //[ /saleledgerview.jsp; Line: 66]
                        ledgerDate, "cashUser", searchValue, saleType); //[ /saleledgerview.jsp; Line: 67]
                        break; //[ /saleledgerview.jsp; Line: 68]
                        case 4: //[ /saleledgerview.jsp; Line: 69]
                        //根据送货地址取得记录 //[ /saleledgerview.jsp; Line: 70]
                        saleLedgers = stockManagementData.getSaleLedgerByStringField( //[ /saleledgerview.jsp; Line: 71]
                        ledgerDate, "address", searchValue, saleType); //[ /saleledgerview.jsp; Line: 72]
                        break; //[ /saleledgerview.jsp; Line: 73]
                        case 5: //[ /saleledgerview.jsp; Line: 74]
                        if(dataMethod.checkInt(searchValue) == 0){ //[ /saleledgerview.jsp; Line: 75]
                            out.print("<h3>按完成状态查询时，输入值必须是整数，" //[ /saleledgerview.jsp; Line: 76]
                            + "0表示进行，1表示撤消，2表示完成.</h3>"); //[ /saleledgerview.jsp; Line: 77]
                            return; //[ /saleledgerview.jsp; Line: 78]
                        } //[ /saleledgerview.jsp; Line: 79]
                        //根据完成状态取得记录 //[ /saleledgerview.jsp; Line: 80]
                        saleLedgers = stockManagementData.getSaleLedgerByOnProcess( //[ /saleledgerview.jsp; Line: 81]
                        ledgerDate, saleType, Integer.parseInt(searchValue)); //[ /saleledgerview.jsp; Line: 82]
                        break; //[ /saleledgerview.jsp; Line: 83]
                    } //[ /saleledgerview.jsp; Line: 84]
                }else{ //[ /saleledgerview.jsp; Line: 85]
                    java.sql.Timestamp startDate = dataMethod.transferDate(startDateStr); //[ /saleledgerview.jsp; Line: 86]
                    java.sql.Timestamp endDate = dataMethod.transferEndDate(endDateStr); //[ /saleledgerview.jsp; Line: 87]
                    if(startDate == null | endDate == null){ //[ /saleledgerview.jsp; Line: 88]
                        out.print("<h3>日期输入错误，正确的日期格式是" //[ /saleledgerview.jsp; Line: 89]
                        + "yyyy-mm-dd（年-月-日），如2004-1-1.</h3>"); //[ /saleledgerview.jsp; Line: 90]
                        return; //[ /saleledgerview.jsp; Line: 91]
                    } //[ /saleledgerview.jsp; Line: 92]
                    //根据日期取得记录 //[ /saleledgerview.jsp; Line: 93]
                    saleLedgers = stockManagementData.getSaleLedgerByOrderDate(ledgerDate, //[ /saleledgerview.jsp; Line: 94]
                    startDate, endDate, saleType); //[ /saleledgerview.jsp; Line: 95]
                } //[ /saleledgerview.jsp; Line: 96]
            } //[ /saleledgerview.jsp; Line: 97]
            //创建表格标题数组 //[ /saleledgerview.jsp; Line: 98]
            String[] counterColNames = {"单据编号", "单据类型", "客户", "销售员", "柜台", "现金管理员", //[ /saleledgerview.jsp; Line: 99]
                "送货地址", "填写日期", "完成日期", "完成状态", "备注"}; //[ /saleledgerview.jsp; Line: 100]
            String[] creditColNames = {"单据编号", "单据类型", "客户", "柜台", "销售员", "现金管理员", //[ /saleledgerview.jsp; Line: 101]
                "送货地址", "填写日期", "完成日期", "完成状态", "备注"}; //[ /saleledgerview.jsp; Line: 102]
            out.print("\r\n<html>\r\n<head>\r\n<title>销售单查看页面：用户(");
            out.print(String.valueOf(userName));  //[ /saleledgerview.jsp; Line: 106]
            out.print("):账套(");
            out.print(String.valueOf(ledgerDate));  //[ /saleledgerview.jsp; Line: 106]
            out.print(")</title>\r\n</head>\r\n<body bgcolor=\"#ffffff\">\r\n<center>\r\n<h3>销售单查看页面:用户(");
            out.print(String.valueOf(userName));  //[ /saleledgerview.jsp; Line: 110]
            out.print("):账套(");
            out.print(String.valueOf(ledgerDate));  //[ /saleledgerview.jsp; Line: 110]
            out.print(")</h3>\r\n<form action=\"saleledgerview.jsp\" method=\"get\">\r\n<p>\r\n  单据类型\r\n  <select name=\"saleType\">\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  </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    ");
            if(saleType == 0 | saleType == 2){ //[ /saleledgerview.jsp; Line: 145]
                for(int i = 0; i < counterColNames.length; i++){ //[ /saleledgerview.jsp; Line: 146]
                    //[ /saleledgerview.jsp; Line: 146]
                    out.print("\r\n      <td><font size=\"-1\">");
                    out.print(String.valueOf(counterColNames[i]));  //[ /saleledgerview.jsp; Line: 147]
                    out.print("</font></td>\r\n    ");
                } //[ /saleledgerview.jsp; Line: 148]
            }else{ //[ /saleledgerview.jsp; Line: 149]
                for(int i = 0; i < creditColNames.length; i++){ //[ /saleledgerview.jsp; Line: 150]
                    //[ /saleledgerview.jsp; Line: 150]
                    out.print("\r\n      <td><font size=\"-1\">");
                    out.print(String.valueOf(creditColNames[i]));  //[ /saleledgerview.jsp; Line: 151]
                    out.print("</font></td>\r\n    ");
                } //[ /saleledgerview.jsp; Line: 152]
            } //[ /saleledgerview.jsp; Line: 153]
            //[ /saleledgerview.jsp; Line: 153]
            out.print("\r\n  </tr>\r\n  ");
            for (int i = 0; i < saleLedgers.length; i++){ //[ /saleledgerview.jsp; Line: 155]
                //[ /saleledgerview.jsp; Line: 155]
                out.print("\r\n    <tr align=\"left\">\r\n      ");
                for(int j = 0; j < saleLedgers[0].length; j++){ //[ /saleledgerview.jsp; Line: 157]
                    if(j == saleLedgers[0].length - 1){ //[ /saleledgerview.jsp; Line: 158]
                        //[ /saleledgerview.jsp; Line: 158]
                        out.print("\r\n          <td>\r\n            <font size=\"-1\">\r\n\t      <textarea name=\"remark\" cols=\"10\" rows=\"1\">");
                        out.print(String.valueOf(saleLedgers[i][j]));  //[ /saleledgerview.jsp; Line: 161]
                        out.print("</textarea>\r\n\t    </font>\r\n          </td>\r\n        ");
                    }else if(j == 0){ //[ /saleledgerview.jsp; Line: 164]
                        //[ /saleledgerview.jsp; Line: 164]
                        out.print("\r\n          <td>\r\n            <font size=\"-1\">\r\n               <a href=\"salesubledgerview.jsp?saleId=");
                        out.print(String.valueOf(saleLedgers[i][j]));  //[ /saleledgerview.jsp; Line: 167]
                        out.print("\" target=\"salesubledger\">\r\n                 ");
                        out.print(String.valueOf(saleLedgers[i][j]));  //[ /saleledgerview.jsp; Line: 168]
                        out.print("\r\n               </a>\r\n            </font>\r\n          </td>\r\n        ");
                    }else{ //[ /saleledgerview.jsp; Line: 172]
                        //[ /saleledgerview.jsp; Line: 172]
                        out.print("\r\n          <td><font size=\"-1\">");
                        out.print(String.valueOf(saleLedgers[i][j]));  //[ /saleledgerview.jsp; Line: 173]
                        out.print("&nbsp;</font></td>\r\n        ");
                    } //[ /saleledgerview.jsp; Line: 174]
                } //[ /saleledgerview.jsp; Line: 175]
                //[ /saleledgerview.jsp; Line: 175]
                out.print("\r\n    </tr>\r\n  ");
            } //[ /saleledgerview.jsp; Line: 177]
            //[ /saleledgerview.jsp; Line: 177]
            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...
    }
    
    
}