📄 saleledgersearchframe.java~35~
字号:
contentPane.add(jScrollPane3, 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);
//清空数组的内容
saleLedgers = new String[0][11];
saleSubLedgers = new String[0][5];
saleSubLedgerObjects = new Object[0][8];
//清空列表框的内容
listData1.clear();
//清空文本框的内容
jTextArea1.setText("");
//清空表格的内容
this.showTableData(saleSubLedgerObjects);
//取得面板上的所有控件
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 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][6]); //送货地址
if(jComboBox2.getSelectedIndex() == 0 | jComboBox2.getSelectedIndex() == 2){
jTextField7.setText(saleLedgers[selectedIndex][2]); //信用销售员
}else{
jTextField7.setText(saleLedgers[selectedIndex][4]); //信用销售员
}
jTextField8.setText(saleLedgers[selectedIndex][5]); //现金管理员
//信用销售单将柜台数据保存在counterUser字段内
jTextField9.setText(saleLedgers[selectedIndex][3]); //柜台
jTextField10.setText(saleLedgers[selectedIndex][7]); //填写日期
jTextField11.setText(saleLedgers[selectedIndex][8]); //完成日期
jTextField12.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][8];
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 actualSalePrice = 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(actualSalePrice * quantity);
saleSubLedgerObjects[i][5] = new Double(actualSalePrice); //实际售价
saleSubLedgerObjects[i][6] = new Integer(quantity); //数量
saleSubLedgerObjects[i][7] = new Double(amount); //金额
total += amount;
}
//显示总价
jTextField13.setText(String.valueOf(dataMethod.round(total)));
//显示表格的内容
this.showTableData(saleSubLedgerObjects);
}
//显示表格内容的方法
public void showTableData(Object[][] detail){
//设置表格的标题
sslTableModel.setColumnNames(colNames);
//设置表格的数据
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(10);
jTable1.getColumnModel().getColumn(7).setPreferredWidth(10);
}
//清空单个销售单显示的方法
public void clearSaleLedger(){
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
jTextField7.setText("");
jTextField8.setText("");
jTextField9.setText("");
jTextField10.setText("");
jTextField11.setText("");
jTextField12.setText("");
jTextField13.setText("");
jTextArea1.setText("");
saleSubLedgers = new String[0][5];
saleSubLedgerObjects = new Object[0][8];
this.showTableData(saleSubLedgerObjects);
}
//列表1的选择事件
void jList1_valueChanged(ListSelectionEvent e) {
if(listData1.size() > 0){
this.showSaleLedger();
}else{
this.clearSaleLedger();
}
}
//查询方法
public void search(){
//取得单据类型
int saleType = saleTypes[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:
//根据销售单编号取得记录
saleLedgers = stockManagementData.getSaleLedgerByStringField(
ledgerDate, "saleId", searchValue, saleType);
break;
case 1:
//根据客户取得记录
saleLedgers = stockManagementData.getSaleLedgerByStringField(
ledgerDate, "customerName", searchValue, saleType);
break;
case 2:
if(saleType == 0 | saleType == 2){
//根据前台销售员取得记录
saleLedgers = stockManagementData.getSaleLedgerByStringField(
ledgerDate, "counterUser", searchValue, saleType);
}else{
//根据信用销售员取得记录
saleLedgers = stockManagementData.getSaleLedgerByStringField(
ledgerDate, "creditUser", searchValue, saleType);
}
break;
case 3:
//根据现金管理员取得记录
saleLedgers = stockManagementData.getSaleLedgerByStringField(
ledgerDate, "cashUser", searchValue, saleType);
break;
case 4:
//根据送货地址取得记录
saleLedgers = stockManagementData.getSaleLedgerByStringField(
ledgerDate, "address", searchValue, saleType);
break;
case 5:
if(dataMethod.checkInt(searchValue) == 0){
JOptionPane.showMessageDialog(null, "按完成状态查询时,输入值必须是整数,"
+ "0表示进行,1表示撤消,2表示完成.");
return;
}
//根据完成状态取得记录
saleLedgers = stockManagementData.getSaleLedgerByOnProcess(
ledgerDate, saleType, 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;
}
//根据日期取得记录
saleLedgers = stockManagementData.getSaleLedgerByOrderDate(ledgerDate,
startDate, endDate, saleType);
}
this.showSearchSaleLedger();
}
//单击事件
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 + -