listData1.addElement(stockLedgers[i][0]);
    }
  }
  //顯示單個(gè)進(jìn)貨單的方法
  public void showStockLedger(){
    //取得當(dāng)前選擇項(xiàng)的位置
    int selectedIndex = jList1.getSelectedIndex();
    //當(dāng)列表框不處于選擇狀態(tài)，不顯示商品數(shù)據(jù)
    if(selectedIndex == -1){
       return;
    }
    //顯示進(jìn)貨單的數(shù)據(jù)
    jTextField4.setText(stockLedgers[selectedIndex][0]);
    jTextField5.setText(stockLedgers[selectedIndex][2]);
    jTextField6.setText(stockLedgers[selectedIndex][7]);
    jTextField7.setText(stockLedgers[selectedIndex][8]);
    jTextField8.setText(stockLedgers[selectedIndex][9]);
    jTextField9.setText(stockLedgers[selectedIndex][10]);
    jTextField10.setText(onProcesses[Integer.parseInt(stockLedgers[selectedIndex][11])]);
    jTextField12.setText(stockLedgers[selectedIndex][3]);
    jTextField13.setText(stockLedgers[selectedIndex][4]);
    jTextField14.setText(stockLedgers[selectedIndex][5]);
    jTextField15.setText(stockLedgers[selectedIndex][6]);
    jTextArea1.setText(stockLedgers[selectedIndex][12]);
    //顯示進(jìn)貨單明細(xì)數(shù)據(jù)
    this.showStockSubLedger();
  }
  //顯示進(jìn)貨單明細(xì)數(shù)據(jù)的方法
  public void showStockSubLedger(){
    //取得當(dāng)前選擇項(xiàng)的位置
    int selectedIndex = jList1.getSelectedIndex();
    String orderId = stockLedgers[selectedIndex][0];
    stockSubLedgers = stockManagementData.getStockSubLedgerByOrderId(ledgerDate, orderId);
    //將數(shù)組數(shù)據(jù)轉(zhuǎn)換為表格數(shù)據(jù)
    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;
    }
    //顯示總價(jià)
    jTextField11.setText(String.valueOf(dataMethod.round(total)));
    //顯示表格的內(nèi)容
    this.showTableData(stockSubLedgerObjects);
  }
  //顯示表格內(nèi)容的方法
  public void showTableData(Object[][] detail){
    //設(shè)置表格的標(biāo)題
    sslTableModel.setColumnNames(colNames);
    //設(shè)置表格的數(shù)據(jù)
    sslTableModel.setData(detail);
    //設(shè)置表格的列編輯狀態(tài),所有列都不能編輯
    sslTableModel.setColumnEditState(1);
    jTable1 = new JTable(sslTableModel);
    //設(shè)置表格的字體
    jTable1.setFont(dialog13);
    //將數(shù)據(jù)表格加入數(shù)據(jù)滾動(dòng)框
    jScrollPane3.getViewport().add(jTable1, null);
    //設(shè)置列的寬度
    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);
  }
  //清空單個(gè)進(jìn)貨單顯示的方法
  public void clearStockLedger(){
    jTextField4.setText("");
    jTextField5.setText("");
    jTextField6.setText("");
    jTextField7.setText("");
    jTextField8.setText("");
    jTextField9.setText("");
    jTextField10.setText("");
    jTextField11.setText("");
    jTextField12.setText("");
    jTextField13.setText("");
    jTextField14.setText("");
    jTextField15.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(){
    //取得查詢選項(xiàng)
    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, "請(qǐng)輸入查詢值");
        return;
      }
      switch (selectedIndex) {
        case 0:
          //根據(jù)進(jìn)貨單編號(hào)取得記錄
          stockLedgers = stockManagementData.getStockLedgerByStringField(
              ledgerDate, "orderId", searchValue, 0);
          break;
        case 1:
          //根據(jù)請(qǐng)購(gòu)員取得記錄
          stockLedgers = stockManagementData.getStockLedgerByStringField(
              ledgerDate, "submitUser", searchValue, 0);
          break;
        case 2:
          //根據(jù)訂購(gòu)員取得記錄
          stockLedgers = stockManagementData.getStockLedgerByStringField(
              ledgerDate, "commitUser", searchValue, 0);
          break;
        case 3:
          //根據(jù)驗(yàn)收員取得記錄
          stockLedgers = stockManagementData.getStockLedgerByStringField(
              ledgerDate, "checkUser", searchValue, 0);
          break;
        case 4:
          //根據(jù)倉(cāng)庫(kù)名字取得記錄
          stockLedgers = stockManagementData.getStockLedgerByStringField(
              ledgerDate, "warehouse", searchValue, 0);
          break;
        case 5:
          if(dataMethod.checkInt(searchValue) == 0){
            JOptionPane.showMessageDialog(null, "按完成狀態(tài)查詢時(shí)，輸入值必須是整數(shù)，"
                                          + "0表示進(jìn)行，1表示撤消，2表示完成.");
            return;
          }
          //根據(jù)完成狀態(tài)取得記錄
          stockLedgers = stockManagementData.getStockLedgerByOnProcess(
              ledgerDate, 0, 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, "日期輸入錯(cuò)誤，正確的日期格式是"
                                      + "yyyy-mm-dd（年-月-日），如2004-1-1");
        return;
      }
      //根據(jù)日期取得記錄
      stockLedgers = stockManagementData.getStockLedgerByOrderDate(ledgerDate,
          startDate, endDate, 0);
    }
    this.showSearchStockLedger();
  }
  //單擊事件
  public void actionPerformed(ActionEvent e) {
    //取得按鈕的動(dòng)作字符串
    String actionCommand = e.getActionCommand().trim();
    int selectedIndex = 0;
    String orderId = "";
    String supplierName = "";
    String userName = user.getUserName();
    String remark = jTextArea1.getText().trim();
    int onProcess = 0;
    //檢查打開(kāi)的賬套是否當(dāng)前賬套
    if (actionCommand.equals("sign") |
        actionCommand.equals("cancel") |
        actionCommand.equals("restore")
        ) {
      int result = stockManagementData.isCurrentLedger(ledgerDate);
      if(result == 0){
        JOptionPane.showMessageDialog(null, ledgerDate + "是往期賬套，不能進(jìn)行電子簽名和撤消操作.");
        return;
      }
      if(jList1.isSelectionEmpty()){
        JOptionPane.showMessageDialog(null, "先選擇進(jìn)貨單.");
        return;
      }
      selectedIndex = jList1.getSelectedIndex();
      //取得進(jìn)貨單標(biāo)識(shí)和供應(yīng)商名字和完成狀態(tài)
      orderId = stockLedgers[selectedIndex][0];
      supplierName = stockLedgers[selectedIndex][2];
      onProcess = Integer.parseInt(stockLedgers[selectedIndex][11]);
      //檢查進(jìn)貨單是否完成
      if(onProcess == 2){
        JOptionPane.showMessageDialog(null, "進(jìn)貨單已完成，不能進(jìn)行電子簽名和撤消操作.");
        return;
      }
      //檢查訂購(gòu)員是否簽名
      String commitUser = stockLedgers[selectedIndex][4].trim();
      if(commitUser.length() == 0){
        JOptionPane.showMessageDialog(null, "驗(yàn)收員要在訂購(gòu)員簽名之后才能進(jìn)行電子簽名和撤消操作.");
        return;
      }
    }
    if(actionCommand.equals("sign")){
      if(onProcess == 1){
        JOptionPane.showMessageDialog(null, "進(jìn)貨單已撤消，不能進(jìn)行電子簽名操作.");
        return;
      }
    }
    if (actionCommand.equals("search")) {
      //查詢
      search();
    }else if(actionCommand.equals("sign")){
      //進(jìn)行電子簽名
      int result = stockManagementData.checkUserSignStockLedgerAndSub(ledgerDate, userName,
          supplierName, orderId, remark);
      if(result == 1){
        JOptionPane.showMessageDialog(null, "電子簽名成功.");
        //更新數(shù)組的數(shù)據(jù)
        stockLedgers[selectedIndex][5] = userName;
        stockLedgers[selectedIndex][11] = "2";
        stockLedgers[selectedIndex][12] = remark;
        //更新驗(yàn)收用戶編輯框的值
        jTextField14.setText(userName);
        //更新完成狀態(tài)編輯框的值
        jTextField10.setText(onProcesses[2]);
      }else{
        JOptionPane.showMessageDialog(null, "電子簽名失敗.");
      }
    }else if(actionCommand.equals("cancel")){
      //撤消進(jìn)貨單
      int result = stockManagementData.cancelStockLedgerAndSub(ledgerDate, orderId, remark);
      if(result == 1){
        JOptionPane.showMessageDialog(null, "進(jìn)貨單撤消成功.");
        //更新完成狀態(tài)編輯框的值
        jTextField10.setText(onProcesses[1]);
        //更新數(shù)組的數(shù)據(jù)
        stockLedgers[selectedIndex][11] = "1";
        stockLedgers[selectedIndex][12] = remark;
      }else{
        JOptionPane.showMessageDialog(null, "進(jìn)貨單撤消失敗.");
      }
    }else if(actionCommand.equals("restore")){
      //恢復(fù)進(jìn)貨單的完成狀態(tài)
      int result = stockManagementData.restoreStockLedgerAndSub(ledgerDate, orderId, remark);
      if(result == 1){
        JOptionPane.showMessageDialog(null, "進(jìn)貨單恢復(fù)成功.");
        //更新完成狀態(tài)編輯框的值
        jTextField10.setText(onProcesses[0]);
        //更新數(shù)組的數(shù)據(jù)
        stockLedgers[selectedIndex][11] = "0";
        stockLedgers[selectedIndex][12] = remark;
      }else{
        JOptionPane.showMessageDialog(null, "進(jìn)貨單恢復(fù)失敗.");
      }
    }else if(actionCommand.equals("printOrder")){
      selectedIndex = jList1.getSelectedIndex();
      if(selectedIndex == -1){
        JOptionPane.showMessageDialog(null, "先選擇進(jìn)貨單.");
        return;
      }
      //取得選擇進(jìn)貨單的數(shù)據(jù)
      String[] stockLedger = new String[13];
      for(int i = 0; i < stockLedger.length; i++){
        if(stockLedgers[selectedIndex][i] == null){
          stockLedger[i] = "";
        }else{
          stockLedger[i] = stockLedgers[selectedIndex][i];
        }
      }
      //取得進(jìn)貨單的明細(xì)賬數(shù)據(jù)
      String[][] stockSubLedgerForPrint = new String[stockSubLedgerObjects.length][5];
      for(int i = 0; i < stockSubLedgers.length; i++){
        stockSubLedgerForPrint[i][0] = (String)stockSubLedgerObjects[i][2];
        stockSubLedgerForPrint[i][1] = ((Double)stockSubLedgerObjects[i][3]).toString();
        stockSubLedgerForPrint[i][2] = ((Integer)stockSubLedgerObjects[i][4]).toString();
        stockSubLedgerForPrint[i][3] = ((Double)stockSubLedgerObjects[i][5]).toString();
        stockSubLedgerForPrint[i][4] = (String)stockSubLedgerObjects[i][6];
      }
      //顯示進(jìn)貨單打印窗口
      if(orderPrintFrame == null){
        orderPrintFrame = new OrderPrintFrame();
        //使窗口居中對(duì)齊
        setCenterPosition(orderPrintFrame);
        orderPrintFrame.setVisible(true);
      }else{
        orderPrintFrame.setVisible(true);
      }
      //為打印窗口傳入數(shù)組參數(shù)
      orderPrintFrame.setStockLedger(stockLedger);
      orderPrintFrame.setStockSubLedger(stockSubLedgerForPrint);
      //顯示總頁(yè)碼
      orderPrintFrame.splitPage();
    }else if(actionCommand.equals("printPayCheck")){
      selectedIndex = jList1.getSelectedIndex();
      if(selectedIndex == -1){
        JOptionPane.showMessageDialog(null, "先選擇進(jìn)貨單.");
        return;
      }
      //取得進(jìn)貨單標(biāo)識(shí)和完成狀態(tài)
      orderId = stockLedgers[selectedIndex][0];
      onProcess = Integer.parseInt(stockLedgers[selectedIndex][11]);
      if(onProcess != 2){
        JOptionPane.showMessageDialog(null, "進(jìn)貨單未完成，不能打印應(yīng)付票據(jù).");
        return;
      }
      //根據(jù)進(jìn)貨單標(biāo)識(shí)取得往來(lái)賬數(shù)組
      String[] currentAccountLedger = stockManagementData.
          getCurrentAccountLedgerBylinkId(ledgerDate, "st" + orderId);
      for(int i = 0; i < currentAccountLedger.length; i++){
        if(currentAccountLedger[i] == null){
          if(i == 9){
            currentAccountLedger[i] = "0";
          }else{
            currentAccountLedger[i] = "";
          }
        }
      }
      //顯示應(yīng)付票據(jù)打印窗口
      if(orderPayCheckPrintFrame == null){
        orderPayCheckPrintFrame = new OrderPayCheckPrintFrame();
        //使窗口居中對(duì)齊
        setCenterPosition(orderPayCheckPrintFrame);
        orderPayCheckPrintFrame.setVisible(true);
      }else{
        orderPayCheckPrintFrame.setVisible(true);
      }
      //為打印窗口傳入數(shù)組參數(shù)
      orderPayCheckPrintFrame.setCurrentAccountLedger(currentAccountLedger);
      //顯示應(yīng)付票據(jù)內(nèi)容
      orderPayCheckPrintFrame.showOnePage();
    }else if(actionCommand.equals("exit")){
      exit();
    }
  }
  //使窗口居中的方法
  public void setCenterPosition(JFrame frame){
    Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
    Dimension frameSize = frame.getSize();
    if (frameSize.height > screenSize.height) {
      frameSize.height = screenSize.height;
    }
    if (frameSize.width > screenSize.width) {
      frameSize.width = screenSize.width;
    }
    frame.setLocation( (screenSize.width - frameSize.width) / 2,
                           (screenSize.height - frameSize.height) / 2);
  }
}