warehousemanagepanel.java

自己做的超市管理系统

                String sql = "select * from WarehouseInfo";
                try {
                    rs = cs.GetRs(sql);

                    while (rs.next()) {
                        if (txtStockId.getText().equals(rs.getString(1))) {
                            i++;
                            break;
                        }
                    }
                } catch (Exception ex) {

                } finally {
                    cs.closed();
                }
                if (i != 0) {
                    String strSql =
                            " update WarehouseInfo set GAmount=GAmount+'" +
                            Float.valueOf(txtStockNo.getText()) +
                            "',GInTotalMoney=GInPrice*(GAmount+'" +
                            Float.valueOf(txtStockNo.getText()) +
                            "'),GDateTime='" + date +
                            "' where GId='" +
                            txtStockId.getText() + "'";
                    try {
                        cs.ResultSql(strSql);
                    } catch (Exception ex) {

                    } finally {
                        cs.closed();
                    }
                    JOptionPane.showMessageDialog(this, "您已成功进货！", "进货成功",
                                                  JOptionPane.
                                                  INFORMATION_MESSAGE);
                } else {
                    String strSql = "insert into WarehouseInfo(GId,GName,GType,GInPrice,GAmount,GInTotalMoney,GDateTime)values('" +
                                    txtStockId.getText() + "','" +
                                    txtStockName.getText() + "','" +
                                    cmbStockType.getSelectedItem() + "','" +
                                    (Float.valueOf(txtStockPrice.getText().
                            toString())) +
                                    "','" +
                                    Float.valueOf(txtStockNo.getText().toString()) +
                                    "','" +
                                    (Float.valueOf(txtStockPrice.getText().
                            toString())) *
                                    (Float.valueOf(txtStockNo.getText().
                            toString())) +
                                    "','" + date + "')";
                    try {
                        cs.ResultSql(strSql);
                    } catch (Exception ex) {

                    } finally {
                        cs.closed();
                    }

                    //获取出货货号
                    cmbShipmentId.removeAllItems();
                    cmbShipmentId.addItem("请选择货物号");
                    try {
                        rs = cs.GetRs(sql);
                        while (rs.next()) {
                            cmbShipmentId.addItem(rs.getString(1));
                        }
                    } catch (Exception ex) {

                    } finally {
                        cs.closed();
                    }
                    JOptionPane.showMessageDialog(this, "您已成功进货！", "进货成功",
                                                  JOptionPane.
                                                  INFORMATION_MESSAGE);
                }
            }
        }
    }

    //清空进货文本框
    public void btnOrderReset_actionPerformed(ActionEvent e) {
        txtStockId.setText("");
        txtStockName.setText("");
        txtStockNo.setText("");
        txtStockPrice.setText("");
        cmbStockType.setSelectedIndex(0);
    }

    //规范出货格式并出货
    public void btnShipmentOk_actionPerformed(ActionEvent e) {
        String sql = "select * from warehouseinfo";

        //货物出价必须大于进价
        int i = 0;
        try {
            rs = cs.GetRs(sql);
            while (rs.next()) {
                if (Float.valueOf(txtOutPrice.getText()) <
                    Float.valueOf(rs.getString(4)) &&
                    cmbShipmentId.getSelectedItem().equals(rs.getString(1))) {
                    i++;
                    strStockPrice = rs.getString(4);
                    break;
                }
            }
        } catch (Exception ex) {

        } finally {
            cs.closed();
        }

        //出货数量小于库存数量
        int j = 0;
        try {
            rs = cs.GetRs(sql);
            while (rs.next()) {
                if (Float.valueOf(txtOutNo.getText()) >
                    Float.valueOf(rs.getString(6)) &&
                    cmbShipmentId.getSelectedItem().equals(rs.getString(1))) {
                    j++;
                    strAmount = rs.getString(6);
                    break;
                }
            }

        } catch (Exception ex) {

        } finally {
            cs.closed();
        }

        //规范用户输入格式
        if (cmbShipmentId.getSelectedItem().toString().equals(
                cmbShipmentId.
                getItemAt(0).toString())) {
            JOptionPane.showConfirmDialog(this, "请您选择出货号!", "警告",
                                          JOptionPane.OK_CANCEL_OPTION,
                                          JOptionPane.WARNING_MESSAGE);
        } else if (txtOutPrice.getText().equals("")) {
            JOptionPane.showConfirmDialog(this, "出货单价不能为空!请您重新输入!", "警告",
                                          JOptionPane.OK_CANCEL_OPTION,
                                          JOptionPane.WARNING_MESSAGE);
        } else if (isFloatNum(txtOutPrice.getText().toString()) <
                   txtOutPrice.getText().length()) {
            JOptionPane.showConfirmDialog(this, "出货单价必须为数值型!请您重新输入!", "警告",
                                          JOptionPane.OK_CANCEL_OPTION,
                                          JOptionPane.WARNING_MESSAGE);
        } else if (i != 0) {
            JOptionPane.showConfirmDialog(this,
                                          "您输入的出货单价小于进货单价!进货单价为：" +
                                          strStockPrice + " 请您重新输入!",
                                          "警告",
                                          JOptionPane.OK_CANCEL_OPTION,
                                          JOptionPane.WARNING_MESSAGE);

        } else if (txtOutNo.getText().equals("")) {
            JOptionPane.showConfirmDialog(this, "出货数量不能为空!请您重新输入!", "警告",
                                          JOptionPane.OK_CANCEL_OPTION,
                                          JOptionPane.WARNING_MESSAGE);

        } else if (isIntNum(txtOutNo.getText().toString()) <
                   txtOutNo.getText().length()) {
            JOptionPane.showConfirmDialog(this, "出货数量必须为整型数值型!请您重新输入!", "警告",
                                          JOptionPane.OK_CANCEL_OPTION,
                                          JOptionPane.WARNING_MESSAGE);
        } else if (j != 0) {
            JOptionPane.showConfirmDialog(this,
                                          "您输入的出货数量大于存货数量!存货数量为" + strAmount +
                                          "请您重新输入!",
                                          "警告",
                                          JOptionPane.OK_CANCEL_OPTION,
                                          JOptionPane.WARNING_MESSAGE);

        } else {
            int n = JOptionPane.showConfirmDialog(this,
                                                  "您确定要出货号为: " +
                                                  cmbShipmentId.
                                                  getSelectedItem() +
                                                  " 的货物吗?", "询问",
                                                  JOptionPane.OK_CANCEL_OPTION,
                                                  JOptionPane.
                                                  INFORMATION_MESSAGE);
            if (n == JOptionPane.OK_OPTION) {
                String strSql = " update WarehouseInfo set GName='" +
                                txtOutName.getText() + "',GOutPrice='" +
                                (Float.valueOf(txtOutPrice.getText().toString())) +
                                "',GAmount=GAmount-'" +
                                Float.valueOf(txtOutNo.getText().toString()) +
                                "',GDateTime='" + date +
                                "',GInTotalMoney=GInPrice*(GAmount-'" +
                                Float.valueOf(txtOutNo.getText().toString()) +
                                "') where GId='" +
                                cmbShipmentId.getSelectedItem() + "'";
                try {
                    cs.ResultSql(strSql);
                } catch (Exception ex) {

                } finally {
                    cs.closed();
                }
                JOptionPane.showMessageDialog(this, "您已成功出货！", "出货成功",
                                              JOptionPane.INFORMATION_MESSAGE);

            }
        }

    }

    //清空出货文本框
    public void btnShipmentReset_actionPerformed(ActionEvent e) {
        txtOutName.setText("");
        txtOutNo.setText("");
        txtOutPrice.setText("");
        cmbShipmentId.setSelectedIndex(0);
    }

    //刷新库存预警列表
    public void btnWarningRefurbish_actionPerformed(ActionEvent e) {
        vc.clear();
        String sql = "select * from WarehouseInfo where GAmount<=20";
        try {
            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));
                vc.addElement(vt);
            }
            tm.fireTableStructureChanged();
        } catch (Exception ex) {

        } finally {
            cs.closed();
        }
    }

    //查询用户规定条件的货物
    public void btnParticularRefurbish_actionPerformed(ActionEvent e) {
        if (isFloatNum(txtInStart.getText().toString()) <
            txtInStart.getText().length() ||
            isFloatNum(txtInLast.getText().toString()) <
            txtInLast.getText().length() ||
            isFloatNum(txtOutStart.getText().toString()) <
            txtOutStart.getText().length() ||
            isFloatNum(txtOutLast.getText().toString()) <
            txtOutLast.getText().length() ||
            isFloatNum(txtAmountStart.getText().toString()) <
            txtAmountStart.getText().length() ||
            isFloatNum(txtAmountLast.getText().toString()) <
            txtAmountLast.getText().length()) {
            JOptionPane.showConfirmDialog(this, "文本框内必须用数值型!请您重新输入!", "警告",
                                          JOptionPane.OK_CANCEL_OPTION,
                                          JOptionPane.WARNING_MESSAGE);

        } else {
            //清空原有列表
            this.vct.clear();
            //查询现规定条件列表
            String sql = "select * from WarehouseInfo";
            try {
                if (txtInLast.getText().equals("") == false &&
                    txtOutLast.getText().equals("") == false &&
                    txtAmountLast.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<='" +