warehousemanagepanel.java

自己做的超市管理系统

                            Float.valueOf(txtOutLast.getText().toString()) +
                            "' and GAmount>'" +
                            Float.valueOf(txtAmountStart.getText().toString()) +
                            "' and GAmount<='" +
                            Float.valueOf(txtAmountLast.getText().toString()) +
                            "'");

                } else if (txtOutLast.getText().equals("") == false &&
                           txtInLast.getText().equals("") == false) {
                    rs = cs.GetRs(
                            "select * from WarehouseInfo where GInPrice>='" +
                            Float.valueOf(txtInStart.getText().toString()) +
                            "' and GInPrice<='" +
                            Float.valueOf(txtInLast.getText().toString()) +
                            "' and GOutPrice>'" +
                            Float.valueOf(txtOutStart.getText().toString()) +
                            "' and GOutPrice<='" +
                            Float.valueOf(txtOutLast.getText().toString()) +
                            "'");

                } else if (txtAmountLast.getText().equals("") == false &&
                           txtOutLast.getText().equals("") == false) {
                    rs = cs.GetRs(
                            "select * from WarehouseInfo where GOutPrice>'" +
                            Float.valueOf(txtOutStart.getText().toString()) +
                            "' and GOutPrice<='" +
                            Float.valueOf(txtOutLast.getText().toString()) +
                            "' and GAmount>'" +
                            Float.valueOf(txtAmountStart.getText().toString()) +
                            "' and GAmount<='" +
                            Float.valueOf(txtAmountLast.getText().toString()) +
                            "'");

                } else if (txtAmountLast.getText().equals("") == false &&
                           txtInLast.getText().equals("") == false) {
                    rs = cs.GetRs(
                            "select * from WarehouseInfo where GInPrice>='" +
                            Float.valueOf(txtInStart.getText().toString()) +
                            "' and GInPrice<='" +
                            Float.valueOf(txtInLast.getText().toString()) +
                            "' and GAmount>'" +
                            Float.valueOf(txtAmountStart.getText().toString()) +
                            "' and GAmount<='" +
                            Float.valueOf(txtAmountLast.getText().toString()) +
                            "'");

                } else if (txtInLast.getText().equals("") == false) {
                    rs = cs.GetRs(
                            "select * from WarehouseInfo where GInPrice>='" +
                            Float.valueOf(txtInStart.getText().toString()) +
                            "' and GInPrice<='" +
                            Float.valueOf(txtInLast.getText().toString()) +
                            "'");

                } else if (txtOutLast.getText().equals("") == false) {
                    rs = cs.GetRs(
                            "select * from WarehouseInfo where GInPrice>='" +
                            Float.valueOf(txtOutStart.getText().toString()) +
                            "' and GInPrice<='" +
                            Float.valueOf(txtOutLast.getText().toString()) +
                            "'");

                } else if (txtAmountLast.getText().equals("") == false) {
                    rs = cs.GetRs(
                            "select * from WarehouseInfo where GInPrice>='" +
                            Float.valueOf(txtAmountStart.getText().toString()) +
                            "' and GInPrice<='" +
                            Float.valueOf(txtAmountLast.getText().toString()) +
                            "'");

                } else {
                    rs = cs.GetRs(sql);
                }
                while (rs.next()) {
                    Vector vt = new Vector();
                    vt.addElement(rs.getString(1));
                    vt.addElement(rs.getString(2));
                    vt.addElement(rs.getString(3));
                    vt.addElement(rs.getString(4));
                    vt.addElement(rs.getString(5));
                    vt.addElement(rs.getString(6));
                    vt.addElement(rs.getString(7));
                    vt.addElement(rs.getString(9));
                    vct.addElement(vt);
                }
                ttm.fireTableStructureChanged();
            } catch (Exception ex) {

            } finally {
                cs.closed();
            }

        }
    }

    //自动设置与该进货号匹配的货物其他信息
    public void txtStockId_focusLost(FocusEvent e) {
        String sql = "select * from warehouseinfo";
        try {
            int i = 0;
            rs = cs.GetRs(sql);
            while (rs.next()) {
                if (txtStockId.getText().equals(rs.getString(1))) {
                    i++;
                    break;
                }
            }
            if (i != 0) {
                txtStockName.setText(rs.getString(2));
                txtStockPrice.setText(rs.getString(4));
                cmbStockType.setSelectedItem(rs.getString(3));
            } else {
                txtStockName.setText("");
                txtStockPrice.setText("");
            }
        } catch (Exception ex) {

        } finally {
            cs.closed();
        }
    }

    //自动设置与该出货号匹配的货物其他信息
    public void cmbShipmentId_focusLost(FocusEvent e) {
        String sql = "select * from warehouseinfo";
        try {
            int i = 0;
            rs = cs.GetRs(sql);
            while (rs.next()) {
                if (cmbShipmentId.getSelectedItem().equals(rs.getString(1))) {
                    i++;
                    break;
                }
            }
            if (i != 0) {
                txtOutName.setText(rs.getString(2));
            } else {
                txtStockName.setText("");
            }
        } catch (Exception ex) {

        } finally {
            cs.closed();
        }

    }

    //清空查询条件
    public void btnParticularReset_actionPerformed(ActionEvent e) {
        setNull();
    }
}


class WarehouseManagePanel_btnParticularReset_actionAdapter implements
        ActionListener {
    private WarehouseManagePanel adaptee;
    WarehouseManagePanel_btnParticularReset_actionAdapter(WarehouseManagePanel
            adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnParticularReset_actionPerformed(e);
    }
}


class WarehouseManagePanel_cmbShipmentId_focusAdapter extends FocusAdapter {
    private WarehouseManagePanel adaptee;
    WarehouseManagePanel_cmbShipmentId_focusAdapter(WarehouseManagePanel
            adaptee) {
        this.adaptee = adaptee;
    }

    public void focusLost(FocusEvent e) {
        adaptee.cmbShipmentId_focusLost(e);
    }
}


class WarehouseManagePanel_txtStockId_focusAdapter extends FocusAdapter {
    private WarehouseManagePanel adaptee;
    WarehouseManagePanel_txtStockId_focusAdapter(WarehouseManagePanel adaptee) {
        this.adaptee = adaptee;
    }

    public void focusLost(FocusEvent e) {
        adaptee.txtStockId_focusLost(e);
    }
}


class WarehouseManagePanel_btnParticularRefurbish_actionAdapter implements
        ActionListener {
    private WarehouseManagePanel adaptee;
    WarehouseManagePanel_btnParticularRefurbish_actionAdapter(
            WarehouseManagePanel adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnParticularRefurbish_actionPerformed(e);
    }
}


class WarehouseManagePanel_btnWarningRefurbish_actionAdapter implements
        ActionListener {
    private WarehouseManagePanel adaptee;
    WarehouseManagePanel_btnWarningRefurbish_actionAdapter(WarehouseManagePanel
            adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent actionEvent) {
        adaptee.btnWarningRefurbish_actionPerformed(actionEvent);
    }
}


class WarehouseManagePanel_btnShipmentOk_actionAdapter implements
        ActionListener {
    private WarehouseManagePanel adaptee;
    WarehouseManagePanel_btnShipmentOk_actionAdapter(WarehouseManagePanel
            adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnShipmentOk_actionPerformed(e);
    }
}


class WarehouseManagePanel_btnShipmentReset_actionAdapter implements
        ActionListener {
    private WarehouseManagePanel adaptee;
    WarehouseManagePanel_btnShipmentReset_actionAdapter(WarehouseManagePanel
            adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnShipmentReset_actionPerformed(e);
    }
}


class WarehouseManagePanel_btnOrderOk_actionAdapter implements ActionListener {
    private WarehouseManagePanel adaptee;
    WarehouseManagePanel_btnOrderOk_actionAdapter(WarehouseManagePanel adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnOrderOk_actionPerformed(e);
    }
}


class WarehouseManagePanel_btnOrderReset_actionAdapter implements
        ActionListener {
    private WarehouseManagePanel adaptee;
    WarehouseManagePanel_btnOrderReset_actionAdapter(WarehouseManagePanel
            adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnOrderReset_actionPerformed(e);
    }
}