esmainmenu.java~301~

管理系统

                    sql = "update asset set anumber = anumber + "+Integer.parseInt(snum)+" where aid = '"+aid+"'";//增加库存售出数量
                    SDBManager.dbUpdate(sql);
                    sql = "update asset set acount = acount - "+Integer.parseInt(snum)+" where aid = '"+aid+"'";//减少库存现存数量
                    SDBManager.dbUpdate(sql);
                    if(SDBManager.getOne("select acount from asset where aid = '"+aid+"'").elementAt(0).toString().equals("0")){
                        JOptionPane.showMessageDialog(this,"效益不错呀！“"+aid+"”目前库存已空！","库存数量提示",1);
                        jTextField6.setText("");
                    }
                    jTable3.setModel(new DefaultTableModel(SDBManager.getAll("select aid,aname from asset where acount != 0"),v_asset));
                    this.notenumber();
                    this.getNumber();
                    jTextField9.setText(SDBManager.getOne("select acount from asset where aid = '"+aid+"'").elementAt(0).toString());
                    jTextField14.setText("");
                    jTable1.scrollRectToVisible(jTable1.getCellRect(jTable1.getRowCount()-1,0,false));
                    JTable a = (JTable)SDBManager.getOne("select sid from sell where sid = '"+sid+"'").elementAt(0);
                    a.setBackground(Color.red);
                    number = -1;
                }else{
                    JOptionPane.showMessageDialog(this,"增加操作失败，请检查:"+sql+"","增加操作提示",0);
                }
            }else{
                JOptionPane.showMessageDialog(this,"增加明细表操作失败，请检查:"+sql+"","增加操作提示",0);
            }
        }else{
            if(clickcount > 10){
                JOptionPane.showMessageDialog(this,"不要一直点好不好？,请严格按照操作流程完成上面的销售清单,OK?","增加操作提示",0);
                clickcount = (int)Math.round(Math.random()*6 + 3);
            }
        }
    }

    public void jButton8_actionPerformed(ActionEvent e) { //合计按钮
        String sid = txtsell.getText();//销售编号
        String aid = jTextField6.getText(); //珠宝编号
        String cid = txtEclient.getText();   //客户编号
        String pid = txtPerson.getText();   //人员编号
        String sellnum = acount.getModel().getValue().toString();
        //数量
        if(aid.equals("")){
            jLabel16.setText("          ←    珠宝编号不能为空，请双击左边表格中的珠宝编号!");
            jLabel16.setForeground(Color.yellow);
            return;
        }
        if(cid.equals("")){
            jLabel3.setForeground(Color.yellow);
            jLabel16.setText("              客户编号不能为空，请填写或点“查键”选择!");
            jLabel16.setForeground(Color.yellow);
            return;
        }else{
            String sql = "select cid from client where cid = '"+cid+"'";//判断客户是否存在
            if(SDBManager.getOne(sql).isEmpty()){
                jLabel3.setForeground(Color.yellow);
                jLabel16.setText("              客户编号未找到，请重写或点“查键”选择!");
                jLabel16.setForeground(Color.yellow);
                return;
            }
        }
        if(pid.equals("")){
            jLabel4.setForeground(Color.yellow);
            jLabel16.setText("              收款人不能为空，请填写或点“查键”选择!");
            jLabel16.setForeground(Color.yellow);
            return;
        }else{
            String sql = "select pid from person where pid = '"+pid+"'";//判断收款人是否存在
            if(SDBManager.getOne(sql).isEmpty()){
                jLabel4.setForeground(Color.yellow);
                jLabel16.setText("              收款人编号未找到，请重写或点“查键”选择!");
                jLabel16.setForeground(Color.yellow);
                return;
            }
        }
        if(sellnum.equals("")){  //判断数量不能为空
            jLabel7.setForeground(Color.yellow);
            jLabel16.setText("  数量不能为空，请填写或点“+”键增加!");
            jLabel16.setForeground(Color.yellow);
            return;
        }
        int snum = Integer.parseInt(acount.getModel().getValue().toString());//销售数量
        int anum = Integer.parseInt(jTextField9.getText());  //库存数量
        if(snum > anum){
            jLabel7.setForeground(Color.yellow);
            jLabel16.setText("              销售数量不能超过库存数，请重填或重选!");
            jLabel16.setForeground(Color.yellow);
            return;
        }
        jLabel3.setForeground(null);jLabel4.setForeground(null);jLabel16.setForeground(null);
        jLabel16.setText("请仔细检查你填写的内容，如不需修改，请点选“增加明细”键填加此张销售单记录，谢谢合作！");
        jLabel16.setForeground(Color.yellow);
        double value = Double.parseDouble(jTextField13.getText());//应收价
        Vector vec = SDBManager.getOne("select cdiscut from client where cid = '"+cid+"'");//折扣率
        String cidDouble = vec.elementAt(0).toString();
        double result = Math.round((value * snum * Double.parseDouble(cidDouble))*100)/100.0;
        jTextField14.setText(String.valueOf(result));//实收金额
        number = 1;
    }

    public void acount_stateChanged(ChangeEvent e) {
        int snum = Integer.parseInt(acount.getModel().getValue().toString());//销售数量
        int anum = Integer.parseInt(jTextField9.getText());  //库存数量
        if(snum > anum){
            JOptionPane.showMessageDialog(this,"晕死！销售数量有可能超过库存数吗？,请重新选择","警告",0);
        }
    }

    public void jButton12_actionPerformed(ActionEvent e) { //删除明细与销售表
        String sql = "select sid from sell where sid = '"+sellid+"'";
        if(SDBManager.getOne(sql).isEmpty()){
            JOptionPane.showMessageDialog(this,"请点销售表格,点选需要删除的记录","删除警告",0);
            return;
        }else{
            sql = "delete from selllist where sid = '"+sellid+"'";
            SDBManager.dbUpdate(sql); //删除销售明细
            sql = "delete from sell where sid = '"+sellid+"'";
            SDBManager.dbUpdate(sql); //删除销售记录表
            JOptionPane.showMessageDialog(this,"恭喜!删除操作成功!","删除成功",1);
            sellid = null;
            //删除成功后,相应的减少库存售出数量
            sql = "update asset set anumber = anumber - "+Integer.parseInt(scount)+" where aid = '"+assetid+"'";
            SDBManager.dbUpdate(sql);
            //并且增加,库存 现存数量
            sql = "update asset set acount = acount + "+Integer.parseInt(scount)+" where aid = '"+assetid+"'";
            SDBManager.dbUpdate(sql);
            assetid = null;
            scount = null;
            sql = "select * from sell";
            jTable1.setModel(new DefaultTableModel(SDBManager.getAll(sql),v_sell));
            jTable3.setModel(new DefaultTableModel(SDBManager.getAll("select aid,aname from asset where acount != 0"),v_asset));
            this.notenumber();
        }
    }

    public void jTable1_mouseClicked(MouseEvent e) {//销售表事件
        jTable1.setSelectionBackground(Color.GREEN);
        int row = jTable1.getSelectedRow();
        if(row >= 0){
             sellid = jTable1.getValueAt(row,0).toString(); //销售编号
             assetid = jTable1.getValueAt(row,1).toString();//珠宝编号
             scount = jTable1.getValueAt(row,5).toString(); //销售数量
             String sql = "select * from selllist where sid = '"+sellid+"'";
             jTable2.setModel(new DefaultTableModel(SDBManager.getAll(sql),v_list));
             jTable2.setRowHeight(30);
        }
    }

    public void jButton13_actionPerformed(ActionEvent e) {//增加销售单
        this.getNumber();
        jTextField6.setText("");
        txtEclient.setText("");
        txtPerson.setText("");
        jComboBox1.setSelectedIndex(0);
        acount.setModel(new SpinnerNumberModel(1,1,100,1));
        jTextField13.setText("");
        jTextField14.setText("");
    }

    public void jTextField8_actionPerformed(ActionEvent e) {

    }

    public void jMenuItem22_actionPerformed(ActionEvent e) {
        SellMap sm = new SellMap();
        sm.setTitle("销售分析图");
        sm.setSize(600,400);
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = sm.getSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        sm.setLocation((screenSize.width - frameSize.width) / 2,
                         (screenSize.height - frameSize.height) / 2);
        sm.setVisible(true);
    }
    //基础信息
    public void jMenuItem1_actionPerformed(ActionEvent e) {
        SMainMenu sm = new SMainMenu(); //
        sm.baseButton(e); //
        Thread thr = new Thread(sm);
        thr.start();
        this.dispose();
    }
    //人员信息
    public void jMenuItem3_actionPerformed(ActionEvent e) {
        new PMainMenu();
        this.dispose();
    }
    //客户信息
    public void jMenuItem17_actionPerformed(ActionEvent e) {
        new CSMainMenu();
        this.dispose();
    }
    //采购入库信息
    public void jMenuItem7_actionPerformed(ActionEvent e) {
        new ASMainMenu();
        this.dispose();
    }
    //人员信息1
    public void jMenuItem8_actionPerformed(ActionEvent e) {
        new PMainMenu();
        this.dispose();
    }
    //人员信息2
    public void jMenuItem6_actionPerformed(ActionEvent e) {
        new PMainMenu();
        this.dispose();
    }
    //销售信息
    public void jMenuItem11_actionPerformed(ActionEvent e) {
        new ESMainMenu();
        this.dispose();
    }
    //客户信息
    public void jMenuItem13_actionPerformed(ActionEvent e) {
        new CSMainMenu();
        this.dispose();
    }
    //库存信息
    public void jMenuItem2_actionPerformed(ActionEvent e) {
        new ASMainMenu();
        this.dispose();
    }

    public void jTable2_mouseClicked(MouseEvent e) {
        jTable2.setSelectionBackground(Color.GREEN);
    }

}


class ESMainMenu_jTable2_mouseAdapter extends MouseAdapter {
    private ESMainMenu adaptee;
    ESMainMenu_jTable2_mouseAdapter(ESMainMenu adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jTable2_mouseClicked(e);
    }
}


class ESMainMenu_jMenuItem2_actionAdapter implements ActionListener {
    private ESMainMenu adaptee;
    ESMainMenu_jMenuItem2_actionAdapter(ESMainMenu adaptee) {
        this.adaptee = adaptee;
    }

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


class ESMainMenu_jMenuItem13_actionAdapter implements ActionListener {
    private ESMainMenu adaptee;
    ESMainMenu_jMenuItem13_actionAdapter(ESMainMenu adaptee) {
        this.adaptee = adaptee;
    }

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


class ESMainMenu_jMenuItem11_actionAdapter implements ActionListener {
    private ESMainMenu adaptee;
    ESMainMenu_jMenuItem11_actionAdapter(ESMainMenu adaptee) {
        this.adaptee = adaptee;
    }

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


class ESMainMenu_jMenuItem6_actionAdapter implements ActionListener {
    private ESMainMenu adaptee;
    ESMainMenu_jMenuItem6_actionAdapter(ESMainMenu adaptee) {
        this.adaptee = adaptee;
    }

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


class ESMainMenu_jMenuItem7_actionAdapter implements ActionListener {
    private ESMainMenu adaptee;
    ESMainMenu_jMenuItem7_actionAdapter(ESMainMenu adaptee) {
        this.adaptee = adaptee;