stocktransfercheckframe.java

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

    //清空文本框的内容
    jTextArea1.setText("");
    //清空表格的内容
    this.showTableData(stockSubLedgerObjects);
    //取得面板上的所有控件
    Component[] components = contentPane.getComponents();
    //创建临时编辑框控件
    JTextField tmpTextField = new JTextField();
    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 showSearchStockLedger(){
    listData1.clear();
    //为商品调入单列表框加入商品调入单数据
    for(int i = 0; i < stockLedgers.length; i++){
      listData1.addElement(stockLedgers[i][0]);
    }
  }
  //显示单个商品调入单的方法
  public void showStockLedger(){
    //取得当前选择项的位置
    int selectedIndex = jList1.getSelectedIndex();
    //当列表框不处于选择状态，不显示数据
    if(selectedIndex == -1){
       return;
    }
    //显示商品调入单的数据
    jTextField4.setText(stockLedgers[selectedIndex][0]);   //票据编号
    jTextField5.setText(stockLedgers[selectedIndex][2]);   //关联标识
    jTextField6.setText(stockLedgers[selectedIndex][3]);   //商品调出员
    jTextField7.setText(stockLedgers[selectedIndex][5]);   //商品验收员
    jTextField8.setText(stockLedgers[selectedIndex][4]);   //商品调出仓库
    jTextField9.setText(stockLedgers[selectedIndex][8]);   //商品调入仓库
    jTextField10.setText(stockLedgers[selectedIndex][9]);  //调出日期
    jTextField11.setText(stockLedgers[selectedIndex][10]); //验收日期
    jTextField12.setText(onProcesses[Integer.parseInt(stockLedgers[selectedIndex][11])]);
    jTextArea1.setText(stockLedgers[selectedIndex][12]);
    //显示商品调入单明细数据
    this.showStockSubLedger();
  }
  //显示商品调入单明细数据的方法
  public void showStockSubLedger(){
    //取得当前选择项的位置
    int selectedIndex = jList1.getSelectedIndex();
    String orderId = stockLedgers[selectedIndex][0];
    stockSubLedgers = stockManagementData.getStockSubLedgerByOrderId(ledgerDate, orderId);
    //将数组数据转换为表格数据
    stockSubLedgerObjects = new Object[stockSubLedgers.length][7];
    double total = 0;
    for(int i = 0; i < stockSubLedgers.length; i++){
      stockSubLedgerObjects[i][0] = new Integer(stockSubLedgers[i][0]);
      stockSubLedgerObjects[i][1] = stockSubLedgers[i][1];
      stockSubLedgerObjects[i][2] = stockSubLedgers[i][2];
      double costPrice = dataMethod.round(Double.parseDouble(stockSubLedgers[i][3]));
      int quantity = Integer.parseInt(stockSubLedgers[i][4]);
      stockSubLedgerObjects[i][3] = new Double(costPrice);
      stockSubLedgerObjects[i][4] = new Integer(quantity);
      double amount = dataMethod.round(costPrice * quantity);
      stockSubLedgerObjects[i][5] = new Double(amount);
      stockSubLedgerObjects[i][6] = dataMethod.transferShortDate(stockSubLedgers[i][5]).toString();
      total += amount;
    }
    //显示总价
    jTextField13.setText(String.valueOf(dataMethod.round(total)));
    //显示表格的内容
    this.showTableData(stockSubLedgerObjects);
  }
  //显示表格内容的方法
  public void showTableData(Object[][] detail){
    //设置表格的标题
    sslTableModel.setColumnNames(colNames);
    //设置表格的数据
    sslTableModel.setData(detail);
    //使表格不可编辑
    sslTableModel.setColumnEditState(1);
    jTable1 = new JTable(sslTableModel);
    //设置表格的字体
    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(50);
  }
  //清空单个商品调入单显示的方法
  public void clearStockLedger(){
    jTextField4.setText("");
    jTextField5.setText("");
    jTextField6.setText("");
    jTextField7.setText("");
    jTextField8.setText("");
    jTextField9.setText("");
    jTextField10.setText("");
    jTextField11.setText("");
    jTextField12.setText("");
    jTextField13.setText("");
    jTextArea1.setText("");
    stockSubLedgers = new String[0][6];
    stockSubLedgerObjects = new Object[0][7];
    this.showTableData(stockSubLedgerObjects);
  }
  //列表1的选择事件
  void jList1_valueChanged(ListSelectionEvent e) {
    if(listData1.size() > 0){
      this.showStockLedger();
    }else{
      this.clearStockLedger();
    }
  }
  //查询方法
  public void search(){
    //取得查询选项
    int selectedIndex = jComboBox1.getSelectedIndex();
    //取得编辑框的变量
    String searchValue = jTextField1.getText().trim();
    String startDateStr = jTextField2.getText().trim();
    String endDateStr = jTextField3.getText().trim();
    if (selectedIndex == 0 | selectedIndex == 1 | selectedIndex == 2 |
        selectedIndex == 3 | selectedIndex == 4 | selectedIndex == 5) {
      if (searchValue.length() == 0) {
        JOptionPane.showMessageDialog(null, "请输入查询值");
        return;
      }
      switch (selectedIndex) {
        case 0:
          //根据商品调入单编号取得记录
          stockLedgers = stockManagementData.getStockLedgerByStringField(
              ledgerDate, "orderId", searchValue, 3);
          break;
        case 1:
          //根据商品调出员取得记录
          stockLedgers = stockManagementData.getStockLedgerByStringField(
              ledgerDate, "submitUser", searchValue, 3);
          break;
        case 2:
          //根据商品验收员取得记录
          stockLedgers = stockManagementData.getStockLedgerByStringField(
              ledgerDate, "checkUser", searchValue, 3);
          break;
        case 3:
          //根据调出仓库名字取得记录,调出仓库名字保存在调入单的commitUser字段
          stockLedgers = stockManagementData.getStockLedgerByStringField(
              ledgerDate, "commitUser", searchValue, 3);
          break;
        case 4:
          //根据调入仓库名字取得记录
          stockLedgers = stockManagementData.getStockLedgerByStringField(
              ledgerDate, "warehouse", searchValue, 3);
          break;
        case 5:
          if(dataMethod.checkInt(searchValue) == 0){
            JOptionPane.showMessageDialog(null, "按完成状态查询时，输入值必须是整数，"
                                          + "0表示进行，1表示撤消，2表示完成.");
            return;
          }
          //根据完成状态取得记录
          stockLedgers = stockManagementData.getStockLedgerByOnProcess(
              ledgerDate, 3, Integer.parseInt(searchValue));
          break;
      }
    }else{
      java.sql.Timestamp startDate = dataMethod.transferDate(startDateStr);
      java.sql.Timestamp endDate = dataMethod.transferEndDate(endDateStr);
      if(startDate == null | endDate == null){
        JOptionPane.showMessageDialog(null, "日期输入错误，正确的日期格式是"
                                      + "yyyy-mm-dd（年-月-日），如2004-1-1");
        return;
      }
      //根据日期取得记录
      stockLedgers = stockManagementData.getStockLedgerByOrderDate(ledgerDate,
          startDate, endDate, 3);
    }
    this.showSearchStockLedger();
  }
  //单击事件
  public void actionPerformed(ActionEvent e) {
    //取得按钮的动作字符串
    String actionCommand = e.getActionCommand().trim();
    int selectedIndex = 0;
    String remark = jTextArea1.getText().trim();
    int onProcess = 0;
    if (actionCommand.equals("signStockLedger") |
        actionCommand.equals("cancelStockLedger") |
        actionCommand.equals("restoreStockLedger")) {
      //检查打开的账套是否当前账套
      int result = stockManagementData.isCurrentLedger(ledgerDate);
      if(result == 0){
        JOptionPane.showMessageDialog(null, ledgerDate + "是往期账套，不能进行添加、修改和撤消操作.");
        return;
      }
      if(jList1.isSelectionEmpty()){
        JOptionPane.showMessageDialog(null, "请选择商品调入单.");
        return;
      }
      selectedIndex = jList1.getSelectedIndex();
      //检查商品调入单是否完成
      onProcess = Integer.parseInt(stockLedgers[selectedIndex][11]);
      if(onProcess == 2){
        JOptionPane.showMessageDialog(null, stockLedgers[selectedIndex][0]
                                      + "商品调入单已经完成，不可以进行电子签名、撤消、恢复操作.");
        return;
      }
    }
    int result = 0;
    if (actionCommand.equals("search")) {
      //查询
      search();
    }else if(actionCommand.equals("signStockLedger")){
      //检查商品调入单是否撤消
      if(onProcess == 1){
        JOptionPane.showMessageDialog(null, stockLedgers[selectedIndex][0]
                                      + "商品调入单已经撤消，不可以进行电子签名操作.");
        return;
      }
      //验收员进行调入单和调出单的电子签名并且更新完成状态
      result = stockManagementData.signStockLedgerAndSubForFinish(ledgerDate,
          "checkUser", user.getUserName(), stockLedgers[selectedIndex][0], 2, remark);
      result = stockManagementData.signStockLedgerAndSubForFinish(ledgerDate,
          "checkUser", user.getUserName(), stockLedgers[selectedIndex][2], 2, remark);
      if(result == 1){
        JOptionPane.showMessageDialog(null, "商品调入单电子签名成功.");
        //更新编辑框的值
        jTextField7.setText(user.getUserName());
        jTextField12.setText(onProcesses[2]);
        //更新数组的数据
        stockLedgers[selectedIndex][5] = user.getUserName();
        stockLedgers[selectedIndex][11] = "2";
        stockLedgers[selectedIndex][12] = remark;
      }else{
        JOptionPane.showMessageDialog(null, "商品调入单电子签名失败.");
      }
    }else if(actionCommand.equals("cancelStockLedger")){
      //撤消商品调入单
      result = stockManagementData.cancelOrRestoreTransferOrder(ledgerDate,
          stockLedgers[selectedIndex][0], stockLedgers[selectedIndex][2], 1, remark);
      if(result == 1){
        JOptionPane.showMessageDialog(null, "商品调入单撤消成功.");
        //更新完成状态编辑框的值
        jTextField12.setText(onProcesses[1]);
        //更新数组的数据
        stockLedgers[selectedIndex][11] = "1";
        stockLedgers[selectedIndex][12] = remark;
      }else{
        JOptionPane.showMessageDialog(null, "商品调入单撤消失败.");
      }
    }else if(actionCommand.equals("restoreStockLedger")){
      //恢复商品调入单
      result = stockManagementData.cancelOrRestoreTransferOrder(ledgerDate,
          stockLedgers[selectedIndex][0], stockLedgers[selectedIndex][2], 0, remark);
      if(result == 1){
        JOptionPane.showMessageDialog(null, "商品调入单恢复成功.");
        //更新完成状态编辑框的值
        jTextField12.setText(onProcesses[0]);
        //更新数组的数据
        stockLedgers[selectedIndex][11] = "0";
        stockLedgers[selectedIndex][12] = remark;
      }else{
        JOptionPane.showMessageDialog(null, "商品调入单恢复失败.");
      }
    }else if(actionCommand.equals("exit")){
      exit();
    }
  }
}