?? stockledgersearchframe.java
字號:
contentPane.add(jLabel10, null); contentPane.add(jLabel8, null); contentPane.add(jLabel6, null); contentPane.add(jLabel4, null); contentPane.add(jLabel2, null); contentPane.add(jLabel14, null); contentPane.add(jLabel13, null); contentPane.add(jLabel12, null); //設置窗口類的字體和為按鈕加入動作接收器 setupFontAndListener(); } //設置窗口類的字體和為按鈕加入動作接收器的方法 public void setupFontAndListener(){ Component[] components = contentPane.getComponents(); //創建臨時按鈕控件 JButton tmpBtn = new JButton(); for(int i = 0; i < components.length; i++){ components[i].setFont(dialog13); if(components[i].getClass().getName().equals("javax.swing.JButton")){ tmpBtn = (JButton)components[i]; tmpBtn.addActionListener(this); } } } //退出方法 public void exit(){ //隱藏窗口 this.setVisible(false); //清空數組的內容 stockLedgers = new String[0][13]; stockSubLedgers = new String[0][6]; stockSubLedgerObjects = new Object[0][7]; //清空列表框的內容 listData1.clear(); //清空文本框的內容 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.setColumnEditState(1); //設置表格的數據 sslTableModel.setData(detail); 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 orderType = orderTypes[jComboBox2.getSelectedIndex()]; //取得查詢選項 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, orderType); break; case 1: //根據填寫用戶取得記錄 stockLedgers = stockManagementData.getStockLedgerByStringField( ledgerDate, "submitUser", searchValue, orderType); break; case 2: //根據檢查用戶取得記錄 stockLedgers = stockManagementData.getStockLedgerByStringField( ledgerDate, "checkUser", searchValue, orderType); break; case 3: //根據調出/調入倉庫名字取得記錄 stockLedgers = stockManagementData.getStockLedgerByStringField( ledgerDate, "commitUser", searchValue, orderType); break; case 4: //根據倉庫名取得記錄 stockLedgers = stockManagementData.getStockLedgerByStringField( ledgerDate, "warehouse", searchValue, orderType); break; case 5: if(dataMethod.checkInt(searchValue) == 0){ JOptionPane.showMessageDialog(null, "按完成狀態查詢時,輸入值必須是整數," + "0表示進行,1表示撤消,2表示完成,3表示盤點單撤消,4表示盤點單完成."); return; } //根據完成狀態取得記錄 stockLedgers = stockManagementData.getStockLedgerByOnProcess( ledgerDate, orderType, 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, orderType); } this.showSearchStockLedger(); } //單擊事件 public void actionPerformed(ActionEvent e) { //取得按鈕的動作字符串 String actionCommand = e.getActionCommand().trim(); if (actionCommand.equals("search")) { //查詢 search(); }else if(actionCommand.equals("exit")){ exit(); } }}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -