mainframe.java

是一个功能齐全的ERP系统

        dlg.setVisible(true);
    }

    public void jMenuItem1_actionPerformed(ActionEvent e) {
        System.exit(0);
    }

    private void select1(String nubmer) { //输入商品类别参数,把结果显示到表中
        Vector tablehead = new Vector();
        tablehead = Select_Means.tablehead();
        Vector dqselect = new Vector();
        dqselect = Select_Means.Select_sort1(nubmer);
        jTable1 = Mytable.maketable(dqselect, tablehead); //显示内容
        jScrollPane2.getViewport().add(jTable1); //把表装入容器

    }

    private void select_number() { //按商品编号查询
        String nubmer = JOptionPane.showInputDialog(this, "请输入商品编号", "提示",
                JOptionPane.INFORMATION_MESSAGE);

        if (nubmer.length() != 0) {
            Vector tablehead = new Vector();
            tablehead = Select_Means.tablehead();
            Vector dqselect = new Vector();
            dqselect = Select_Means.Select_sort2(nubmer);
            if (dqselect.size() == 0) {
                JOptionPane.showMessageDialog(this, "商品编号不存在", "提示",
                                              JOptionPane.INFORMATION_MESSAGE);
                return;
            }
            jTable1 = Mytable.maketable(dqselect, tablehead); //显示内容
            jScrollPane2.getViewport().add(jTable1); //把表装入容器
        } else {
            JOptionPane.showMessageDialog(this, "输入不能为空值", "提示",
                                          JOptionPane.INFORMATION_MESSAGE);
            return;
        }
    }

    private void select_name() { //按商品名称查询
        String nubmer = JOptionPane.showInputDialog(this, "请输入商品名称",
                "提示", JOptionPane.INFORMATION_MESSAGE);
        if (nubmer.length() != 0) {
            Vector tablehead = new Vector();
            tablehead = Select_Means.tablehead();
            Vector dqselect = new Vector();
            dqselect = Select_Means.Select_sort3(nubmer);
            if (dqselect.size() == 0) {
                JOptionPane.showMessageDialog(this, "商品不存在", "提示",
                                              JOptionPane.INFORMATION_MESSAGE);
                return;
            }
            jTable1 = Mytable.maketable(dqselect, tablehead); //显示内容
            jScrollPane2.getViewport().add(jTable1); //把表装入容器
        } else {
            JOptionPane.showMessageDialog(this, "输入不能为空值", "提示",
                                          JOptionPane.
                                          INFORMATION_MESSAGE);
            return;
        }
    }

    private void select_TreatyCode() { //按商品条形码查询
        String nubmer = JOptionPane.showInputDialog(this, "请输入按商品条形码",
                "提示", JOptionPane.INFORMATION_MESSAGE);
        if (nubmer.length() != 0) {
            Vector tablehead = new Vector();
            tablehead = Select_Means.tablehead();
            Vector dqselect = new Vector();
            dqselect = Select_Means.Select_sort4(nubmer);
            if (dqselect.size() == 0) {
                JOptionPane.showMessageDialog(this, "商品不存在", "提示",
                                              JOptionPane.INFORMATION_MESSAGE);
                return;
            }
            jTable1 = Mytable.maketable(dqselect, tablehead); //显示内容
            jScrollPane2.getViewport().add(jTable1); //把表装入容器
        } else {
            JOptionPane.showMessageDialog(this, "输入不能为空值", "提示",
                                          JOptionPane.
                                          INFORMATION_MESSAGE);
            return;
        }

    }

    public void jTree1_valueChanged(TreeSelectionEvent e) {
        Object obj1 = jTree1.getLastSelectedPathComponent();
        String s = null;
        if (obj1 != null) {
            s = obj1.toString();

            if (s.equals("销售统计")) {
                Earning earn = new Earning();
                earn.setVisible(true);
                earn.setLocation(200, 0);
            }

            if (s.equals("库存信息浏览")) {
                Vector vec1 = new Vector();
                Vector vec2 = new Vector();
                vec2.add("库存编号");
                vec2.add("商品编码");
                vec2.add("商品名称");
                vec2.add("库存数量");
                vec1 = Select_Means.Select_All_repertory();
                jTable1 = Mytable.maketable(vec1, vec2); //显示内容
                jScrollPane2.getViewport().add(jTable1); //把表装入容器
            }
            if (s.equals("按库存商品编号查询")) {
             String str=  JOptionPane.showInputDialog(this,"请输入商品编号","提示",JOptionPane.INFORMATION_MESSAGE);
                if(str.length()==0){
                    JOptionPane.showMessageDialog(this,"您没有输入商品编号","提示",JOptionPane.INFORMATION_MESSAGE);
                    return;
                }
             Vector vec1 = new Vector();
                Vector vec2 = new Vector();
                vec2.add("库存编号");
                vec2.add("商品编码");
                vec2.add("商品名称");
                vec2.add("库存数量");
                vec1 = Select_Means.Select_repertory(str);
                if(vec1.size()==0){
                   JOptionPane.showMessageDialog(this,"商品不存在","提示",JOptionPane.INFORMATION_MESSAGE);                   return;
               }
                jTable1 = Mytable.maketable(vec1, vec2); //显示内容
                jScrollPane2.getViewport().add(jTable1); //把表装入容器
            }



            if (s.equals("添加/修改用户")) {
                Adminstrator admin_Enter = new Adminstrator();
                admin_Enter.setVisible(true);
                admin_Enter.setTitle("此功能需要管理员权限");
            }
            if (s.equals("个人账户查询")) {
                Select_card seCard = new Select_card();
                seCard.setVisible(true);
                seCard.setTitle("个人账户查询");
            }
            if (s.equals("入库/出库")) {
                Put_Out_Depot put_out = new Put_Out_Depot();
                put_out.setVisible(true);
                put_out.setLocation(200, 100);
                put_out.setTitle("进/出货表");
            }

            if (s.equals("进/退货")) {
                JoinAndExceed join = new JoinAndExceed();
                join.setVisible(true);
                join.setTitle("进/退货表");
                join.setLocation(200, 150);

            }

            if (s.equals("新增商品")) {
                AddMerchandise Merchandise = new AddMerchandise();
                Merchandise.setVisible(true);
                Merchandise.setTitle("新增商品表");
                Merchandise.setLocation(60, 100);

            }

            if (s.equals("电器类查询")) {
                select1("DQ1004");
            }

            if (s.equals("礼品类查询")) {
                select1("LP1006");
            }

            if (s.equals("日用类查询")) {
                select1("RY1005");
            }

            if (s.equals("蔬果类查询")) {
                select1("SG1003");
            }

            if (s.equals("食品类查询")) {
                select1("SP1002");
            }

            if (s.equals("生鲜类查询")) {
                select1("SX1001");
            }

            if (s.equals("按商品编号查询")) {
                select_number();
            }

            if (s.equals("按商品名称查询")) {
                select_name();
            }

            if (s.equals("按商品条形码查询")) {
                select_TreatyCode();
            }
        }

    }

    public void jMenuItem2_actionPerformed(ActionEvent e) {
        Adminstrator admin_Enter = new Adminstrator();
        admin_Enter.setVisible(true);
        admin_Enter.setTitle("此功能需要超级管理员权限");

    }

    public void jMenuItem3_actionPerformed(ActionEvent e) {
        Select_card seCard = new Select_card();
        seCard.setVisible(true);
        seCard.setTitle("个人账户查询");
    }

    public void jMenuItem4_actionPerformed(ActionEvent e) {
        Vendition_dialog vd = new Vendition_dialog();
        vd.setVisible(true);
    }

    public void jMenuItem9_actionPerformed(ActionEvent e) {
        JoinAndExceed join = new JoinAndExceed();
        join.setVisible(true);
        join.setTitle("进/退货表");
        join.setLocation(200, 150);

    }

    public void jMenuItem17_actionPerformed(ActionEvent e) {
        Earning earn = new Earning();
        earn.setVisible(true);
        earn.setLocation(200, 0);
    }

    public void jMenuItem16_actionPerformed(ActionEvent e) {
        AddMerchandise Merchandise = new AddMerchandise();
        Merchandise.setVisible(true);
        Merchandise.setTitle("新增商品表");
        Merchandise.setLocation(60, 100);
    }

    public void jMenuItem10_actionPerformed(ActionEvent e) {
        Stock_Dialog stock = new Stock_Dialog();
        stock.setVisible(true);
        stock.setLocation(150, 150);
        stock.setTitle("采购表");
    }

    public void jMenuItem7_actionPerformed(ActionEvent e) {
        Put_Out_Depot put_out = new Put_Out_Depot();
        put_out.setVisible(true);
        put_out.setLocation(200, 100);
        put_out.setTitle("进/出货表");
    }

    public void jMenuItem11_actionPerformed(ActionEvent e) {
        PaymentList paymentList = new PaymentList();
        paymentList.setVisible(true);
        paymentList.setLocation(100, 100);
        paymentList.setTitle("付款单");
    }

    public void jMenuItem18_actionPerformed(ActionEvent e) {
        select_name();
    }

    public void jMenuItem19_actionPerformed(ActionEvent e) {
        select_number();
    }

    public void jMenuItem8_actionPerformed(ActionEvent e) {
        select1("DQ1004");
    }

    public void jMenuItem20_actionPerformed(ActionEvent e) {
        select1("LP1006");
    }

    public void jMenuItem22_actionPerformed(ActionEvent e) {
        select1("SG1003");
    }

    public void jMenuItem23_actionPerformed(ActionEvent e) {
        select1("SP1002");
    }

    public void jMenuItem24_actionPerformed(ActionEvent e) {
        select1("SX1001");