countsalereturnframe.java~337~

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

    for(int i = 0; i < components.length; i++){
      if(components[i].getClass().getName().equals("javax.swing.JTextField")){
        tmpTextField = (JTextField)components[i];
        //清空编辑框的内容
        tmpTextField.setText("");
      }
    }
  }
  //设置用户的方法
  public void setUser(User user) {
    this.user = user;
  }
  //设置账套的方法
  public void setLedgerDate(String ledgerDate) {
    this.ledgerDate = ledgerDate;
  }
  protected void processWindowEvent(WindowEvent e) {
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      exit();
    }
  }
  //显示查询销售退货单的方法
  public void showSearchSaleLedger(){
    listData1.clear();
    //为销售退货单列表框加入销售退货单数据
    for(int i = 0; i < saleLedgers.length; i++){
      listData1.addElement(saleLedgers[i][0]);
    }
  }
  //显示单个销售退货单的方法
  public void showSaleLedger(){
    //取得当前选择项的位置
    int selectedIndex = jList1.getSelectedIndex();
    //当列表框不处于选择状态，不显示商品数据
    if(selectedIndex == -1){
       return;
    }
    //显示销售退货单的数据
    jTextField4.setText(saleLedgers[selectedIndex][0]);    //单据编号
    jTextField5.setText(saleLedgers[selectedIndex][2]);    //客户
    jTextField6.setText(saleLedgers[selectedIndex][3]);    //柜台销售员
    jTextField7.setText(saleLedgers[selectedIndex][4]);    //柜台
    jTextField8.setText(saleLedgers[selectedIndex][7]);    //填写日期
    jTextField9.setText(onProcesses[Integer.parseInt(saleLedgers[selectedIndex][9])]);
    jTextArea1.setText(saleLedgers[selectedIndex][10]);
    //显示销售退货单明细数据
    this.showSaleSubLedger();
  }
  //显示销售退货单明细数据的方法
  public void showSaleSubLedger(){
    //取得当前选择项的位置
    int selectedIndex = jList1.getSelectedIndex();
    String saleId = saleLedgers[selectedIndex][0];
    saleSubLedgers = stockManagementData.getSaleSubLedgerBySaleId(ledgerDate, saleId);
    //将数组数据转换为表格数据
    saleSubLedgerObjects = new Object[saleSubLedgers.length][9];
    double total = 0;
    for(int i = 0; i < saleSubLedgers.length; i++){
      saleSubLedgerObjects[i][0] = new Integer(saleSubLedgers[i][0]);
      saleSubLedgerObjects[i][1] = saleSubLedgers[i][1];
      saleSubLedgerObjects[i][2] = saleSubLedgers[i][2];    //商品条形码
      double actualSaleReturnPrice = dataMethod.round(Double.parseDouble(saleSubLedgers[i][3]));
      int quantity = Integer.parseInt(saleSubLedgers[i][4]);
      saleSubLedgerObjects[i][3] = new Double(0);
      saleSubLedgerObjects[i][4] = new Double(0);
      //计算退货金额
      double amount = dataMethod.round(actualSaleReturnPrice * quantity);
      saleSubLedgerObjects[i][5] = new Double(0);                     //实际售价
      saleSubLedgerObjects[i][6] = new Double(actualSaleReturnPrice); //退货价
      saleSubLedgerObjects[i][7] = new Integer(quantity);       //数量
      saleSubLedgerObjects[i][8] = new Double(amount);          //金额
      total += amount;
    }
    //显示总价
    jTextField10.setText(String.valueOf(dataMethod.round(total)));
    //显示表格的内容
    this.showSaleTableData(saleSubLedgerObjects);
  }
  //显示库存销售出库单明细数据的方法
  public void showStockSubLedger(){
    //取得当前选择项的位置
    int selectedIndex = jList1.getSelectedIndex();
    if(selectedIndex == -1){
      JOptionPane.showMessageDialog(null, "先选择销售退货单.");
      return;
    }
    //取得销售单编号
    String saleId = saleLedgers[selectedIndex][0];
    //取得关联标识
    String saleOrderLink = jTextField11.getText().trim();
    if(saleOrderLink.length() == 0){
      JOptionPane.showMessageDialog(null, "销售单关联标识为空.");
      return;
    }
    //取得库存销售出库单的数量
    stockSubLedgers = stockManagementData.getStockSaleOutBySaleOrderLink(
        ledgerDate, saleOrderLink, saleId);
    //将数组数据转换为表格数据
    stockSubLedgerObjects = new Object[stockSubLedgers.length][4];
    for(int i = 0; i < stockSubLedgers.length; i++){
      stockSubLedgerObjects[i][0] = stockSubLedgers[i][0];
      stockSubLedgerObjects[i][1] = new Double(Double.parseDouble(stockSubLedgers[i][1]));
      stockSubLedgerObjects[i][2] = new Integer(-Integer.parseInt(stockSubLedgers[i][2]));
      stockSubLedgerObjects[i][3] = stockSubLedgers[i][3];
    }
    //显示表格的内容
    this.showStockTableData(stockSubLedgerObjects);
  }
  //转换销售退货单的表格数据的方法
  public void transferSaleReturnTableData(){
    saleSubLedgers = new String[saleSubLedgerObjects.length][5];
    for(int i = 0; i < saleSubLedgerObjects.length; i++){
      saleSubLedgers[i][0] = ((Integer)saleSubLedgerObjects[i][0]).toString();
      saleSubLedgers[i][1] = (String)saleSubLedgerObjects[i][1];
      saleSubLedgers[i][2] = (String)saleSubLedgerObjects[i][2];
      saleSubLedgers[i][3] = ((Double)saleSubLedgerObjects[i][6]).toString(); //退货金额
      saleSubLedgers[i][4] = ((Integer)saleSubLedgerObjects[i][7]).toString();//数量
    }
  }
  //转换库存明细表格数据的方法
  public void transferStockTableData(){
    stockSubLedgers = new String[stockSubLedgerObjects.length][4];
    for(int i = 0; i < stockSubLedgerObjects.length; i++){
      stockSubLedgers[i][0] = ((String)stockSubLedgerObjects[i][0]);
      stockSubLedgers[i][1] = ((Double)stockSubLedgerObjects[i][1]).toString(); //进货价
      stockSubLedgers[i][2] = ((Integer)stockSubLedgerObjects[i][2]).toString();//数量
      stockSubLedgers[i][3] = ((String)stockSubLedgerObjects[i][3]).toString(); //有效期
    }
  }
  //显示销售退货单表格内容的方法
  public void showSaleTableData(Object[][] detail){
    //设置表格的标题
    srTableModel.setColumnNames(saleColNames);
    //设置表格的数据
    srTableModel.setData(detail);
    jTable1 = new JTable(srTableModel);
    //设置表格的字体
    jTable1.setFont(dialog13);
    //将数据表格加入数据滚动框
    jScrollPane3.getViewport().add(jTable1, null);
    //设置列的宽度
    jTable1.getColumnModel().getColumn(0).setPreferredWidth(20);
    jTable1.getColumnModel().getColumn(1).setPreferredWidth(50);
    jTable1.getColumnModel().getColumn(2).setPreferredWidth(50);
    jTable1.getColumnModel().getColumn(3).setPreferredWidth(10);
    jTable1.getColumnModel().getColumn(4).setPreferredWidth(10);
    jTable1.getColumnModel().getColumn(5).setPreferredWidth(10);
    jTable1.getColumnModel().getColumn(6).setPreferredWidth(10);
    jTable1.getColumnModel().getColumn(7).setPreferredWidth(10);
    jTable1.getColumnModel().getColumn(8).setPreferredWidth(10);
    //为表格加入内容接收器
    srTableModel.addTableModelListener(new TableModelListener(){
      public void tableChanged(TableModelEvent e) {
        jTable1_valueChanged(e);
      }
    });
  }
  //显示库存销售出库单的表格内容的方法
  public void showStockTableData(Object[][] detail){
    //设置表格的标题
    srTableMode2.setColumnNames(stockColNames);
    //设置表格的数据
    srTableMode2.setData(detail);
    //设置表格的编辑状态
    srTableMode2.setColumnEditState(1);
    jTable2 = new JTable(srTableMode2);
    //设置表格的字体
    jTable2.setFont(dialog13);
    //将数据表格加入数据滚动框
    jScrollPane4.getViewport().add(jTable2, null);
    //设置列的宽度
    jTable2.getColumnModel().getColumn(0).setPreferredWidth(50);
    jTable2.getColumnModel().getColumn(1).setPreferredWidth(10);
    jTable2.getColumnModel().getColumn(2).setPreferredWidth(10);
    jTable2.getColumnModel().getColumn(3).setPreferredWidth(50);
  }
  //重新计算货物金额
  public void recountGoodsAmount(){
    double actualSaleReturnPrice = 0;
    int quantity = 0;
    double amount = 0;
    double total = 0;
    for(int i = 0; i < saleSubLedgerObjects.length; i++){
      actualSaleReturnPrice = dataMethod.round(((Double)saleSubLedgerObjects[i][6]).doubleValue());
      quantity = ((Integer)saleSubLedgerObjects[i][7]).intValue();
      amount = dataMethod.round(actualSaleReturnPrice * quantity);
      saleSubLedgerObjects[i][8] = new Double(amount);
      total += amount;
    }
    jTextField10.setText(String.valueOf(dataMethod.round(total)));
  }
  //检查销售退货单明细账的商品条形码方法
  public int checkSaleSubLedgerGoodsBarCode(){
    int result = 0;
    for(int i = 0; i < saleSubLedgerObjects.length; i++){
      result = stockManagementData.checkGoodsBarCode((String)saleSubLedgerObjects[i][2]);
      if(result == 0){
        JOptionPane.showMessageDialog(null, "销售退货单明细列表的第" + (i + 1) + "行的商品条形码在商品数据库中"
                                      + "不存在，请打开商品数据管理窗口添加.");
        return 0;
      }
    }
    return 1;
  }
  //检查库存销售退货单明细账的商品条形码方法
  public int checkStockSubLedgerGoodsBarCode(){
    int result = 0;
    for(int i = 0; i < stockSubLedgerObjects.length; i++){
      result = stockManagementData.checkGoodsBarCode((String)stockSubLedgerObjects[i][0]);
      if(result == 0){
        JOptionPane.showMessageDialog(null, "库存明细列表的第" + (i + 1) + "行的商品条形码在商品数据库中"
                                      + "不存在，请打开商品数据管理窗口添加.");
        return 0;
      }
    }
    return 1;
  }
  //检查销售退货单明细列表的退货数量的方法
  public int checkSaleSubLedgerQuantity(){
    int quantity = 0;
    for(int i = 0; i < saleSubLedgerObjects.length; i++){
      quantity = ((Integer)saleSubLedgerObjects[i][7]).intValue();
      if(quantity >= 0){
        JOptionPane.showMessageDialog(null, "销售退货单明细列表的第" + (i + 1) + "行的数量输入错误，该数量必须是负数.");
        return 0;
      }
    }
    return 1;
  }
  //检查库存销售退货单明细列表的数量的方法
  public int checkStockSubLedgerQuantity(){
    int quantity = 0;
    for(int i = 0; i < stockSubLedgerObjects.length; i++){
      quantity = ((Integer)stockSubLedgerObjects[i][2]).intValue();
      if(quantity <= 0){
        JOptionPane.showMessageDialog(null, "库存明细列表的第" + (i + 1) + "行的数量输入错误，该数量必须是正数.");
        return 0;
      }
    }
    return 1;
  }
  //检查库存销售退货单明细账日期的方法
  public int checkStockSubLedgerDate(){
    java.sql.Date date = null;
    for(int i = 0; i < stockSubLedgerObjects.length; i++){
      date = dataMethod.transferShortDate((String)stockSubLedgerObjects[i][3]);
      if(date == null){
        JOptionPane.showMessageDialog(null, "库存明细列表的第" + (i+1) + "行日期输入错误，正确的日期格式是"
                                      + "yyyy-mm-dd（年-月-日），如2004-1-1");
        return 0;
      }
    }
    return 1;
  }
  //检查销售单退货单数量与库存销售退货单数量是否相等
  public int CheckSaleAndStockQuantity(){
    int saleReturnQuantity = 0;
    int stockQuantity = 0;
    //计算销售退货单的数量
    for(int i = 0; i < saleSubLedgerObjects.length; i++){
      saleReturnQuantity = ((Integer)saleSubLedgerObjects[i][7]).intValue();
    }
    //计算库存销售退货单的数量
    for(int i = 0; i < stockSubLedgerObjects.length; i++){
      stockQuantity = ((Integer)stockSubLedgerObjects[i][2]).intValue();
    }
    if(-saleReturnQuantity == stockQuantity){
      return 1;
    }else{
      JOptionPane.showMessageDialog(null, "销售退货单的数量和库存销售退货单的数量不相等.");
      return 0;
    }
  }
  //根据商品条形码取得销售价和折扣
  public void showGoodsPriceAndDiscount(){
    for(int i = 0; i < saleSubLedgerObjects.length; i++){
      String goodsBarcode = (String)saleSubLedgerObjects[i][2];
      double[] data = stockManagementData.getGoodsPriceAndDiscount(goodsBarcode);
      saleSubLedgerObjects[i][3] = new Double(data[0]);            //销售价
      saleSubLedgerObjects[i][4] = new Double(data[1]);            //折扣
      saleSubLedgerObjects[i][5] = new Double(data[0] * data[1]);  //实际售价
    }
  }
  //清空单个销售退货单显示的方法
  public void clearSaleLedger(){
    jTextField4.setText("");
    jTextField5.setText("");
    jTextField6.setText("");
    jTextField7.setText("");
    jTextField8.setText("");
    jTextField9.setText("");
    jTextField10.setText("");
    jTextArea1.setText("");
    saleSubLedgers = new String[0][5];
    saleSubLedgerObjects = new Object[0][9];
    this.showSaleTableData(saleSubLedgerObjects);
  }
  //检查按钮的状态
  public void checkBtn(boolean isManipulated){
    if(isManipulated){
      jButton2.setEnabled(false);
      jButton3.setEnabled(false);
      jButton4.setEnabled(false);
      jButton5.setEnabled(false);
      jButton6.setEnabled(true);
      jButton7.setEnabled(true);
    }else{
      jButton2.setEnabled(true);
      jButton3.setEnabled(true);
      jButton4.setEnabled(true);
      jButton5.setEnabled(true);
      jButton6.setEnabled(false);
      jButton7.setEnabled(false);
    }
  }
  //检查明细账按钮的状态
  public void checkSubBtn(boolean isCreated){
    if(isCreated){
      jButton10.setEnabled(true);
      jButton11.setEnabled(true);
    }else{
      jButton10.setEnabled(false);
      jButton11.setEnabled(false);
    }
  }
  //列表1的选择事件
  void jList1_valueChanged(ListSelectionEvent e) {
    if(listData1.size() > 0){
      this.showSaleLedger();
    }else{
      this.clearSaleLedger();
    }
  }
  //表格内容改变事件
  public void jTable1_valueChanged(TableModelEvent e) {
    //重新计算金额
    this.recountGoodsAmount();
    //根据商品条形码取得销售价和折扣
    this.showGoodsPriceAndDiscount();
  }
  //查询方法
  public void search(){
    //取得查询选项
    int selectedIndex = jComboBox1.getSelectedIndex();
    //取得编辑框的变量
    String searchValue = jTextField1.getText().trim();
    String startDateStr = jTextField2.getText().trim();