esmainmenu.java~306~

管理系统

    JSplitPane jSplitPane2 = new JSplitPane();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTree jTree1 = new JTree(root);
    JMenuBar jMenuBar1 = new JMenuBar();
    JMenu jMenu1 = new JMenu();
    JMenu jMenu2 = new JMenu();
    JMenu jMenu3 = new JMenu();
    JMenu jMenu4 = new JMenu();
    JMenu jMenu5 = new JMenu();
    JMenu jMenu6 = new JMenu();
    JMenuItem jMenuItem1 = new JMenuItem();
    JMenuItem jMenuItem2 = new JMenuItem();
    JMenuItem jMenuItem3 = new JMenuItem();
    JMenuItem jMenuItem7 = new JMenuItem();
    JMenuItem jMenuItem8 = new JMenuItem();
    JMenuItem jMenuItem11 = new JMenuItem();
    JMenuItem jMenuItem13 = new JMenuItem();
    JMenu jMenu7 = new JMenu();
    JMenuItem jMenuItem15 = new JMenuItem();
    JMenuItem jMenuItem16 = new JMenuItem();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    BorderLayout borderLayout3 = new BorderLayout();
    int num = (int) Math.round(Math.random() * 9);
    JPanel jPanel4 = new JPanel();
    BorderLayout borderLayout2 = new BorderLayout();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();
    JButton jButton6 = new JButton();
    JMenuItem jMenuItem17 = new JMenuItem();
    JMenuItem jMenuItem6 = new JMenuItem();
    JMenu jMenu8 = new JMenu();
    JMenuItem jMenuItem4 = new JMenuItem();
    JMenuItem jMenuItem9 = new JMenuItem();
    JMenuItem jMenuItem10 = new JMenuItem();
    JMenuItem jMenuItem12 = new JMenuItem();
    JMenuItem jMenuItem18 = new JMenuItem();
    JMenuItem jMenuItem19 = new JMenuItem();
    JMenu jMenu9 = new JMenu();
    JMenuItem jMenuItem5 = new JMenuItem();
    JMenuItem jMenuItem20 = new JMenuItem();
    GridLayout gridLayout1 = new GridLayout();
    JMenuItem jMenuItem14 = new JMenuItem();
    JMenuItem jMenuItem21 = new JMenuItem();
    JScrollPane jScrollPane2 = new JScrollPane();
    JScrollPane jScrollPane3 = new JScrollPane();
    JTable jTable1 = new JTable();
    JOptionPane jp = new JOptionPane();
    JPanel jPanel5 = new JPanel();
    ButtonGroup buttonGroup1 = new ButtonGroup();
    private String txtname;
    private String txtsprice;
    private String txtprice;
    private String txtrofit;
    JButton jButton8 = new JButton();
    private Icon image;
    JPanel jPanel6 = new JPanel();
    JPanel jPanel7 = new JPanel();
    GridLayout gridLayout2 = new GridLayout();
    JPanel jPanel9 = new JPanel();
    JScrollPane jScrollPane5 = new JScrollPane();
    JTextField jTextField4 = new JTextField();
    JButton jButton11 = new JButton();
    JTable jTable3 = new JTable();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField txtsell = new JTextField();
    JTextField jTextField6 = new JTextField();
    static JTextField txtEclient = new JTextField();
    Border border1 = BorderFactory.createMatteBorder(0, 0, 1, 0, Color.yellow);
    JButton jButton7 = new JButton();
    JLabel jLabel5 = new JLabel();
    JTextField txtdate = new JTextField();
    static JTextField txtPerson = new JTextField();
    JButton jButton9 = new JButton();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    JTextField jTextField13 = new JTextField();
    JTextField jTextField14 = new JTextField();
    JLabel jLabel14 = new JLabel();
    JLabel jLabel15 = new JLabel();
    JButton jButton10 = new JButton();
    JScrollPane jScrollPane4 = new JScrollPane();
    JTable jTable2 = new JTable();
    int number = -1;
    int clickcount = 0;
    JLabel jLabel16 = new JLabel();
    JComboBox jComboBox1 = new JComboBox();
    JSpinner acount = new JSpinner();
    JTextField jTextField5 = new JTextField();
    JTextField jTextField7 = new JTextField();
    JTextField jTextField9 = new JTextField();
    JButton jButton12 = new JButton();
    JButton jButton13 = new JButton();
    JTextField txtshow = new JTextField();
    JMenuItem jMenuItem22 = new JMenuItem();
    JScrollPane jScrollPane6 = new JScrollPane();
    JTree jTree2 = new JTree();
    JPanel jPanel8 = new JPanel();
    JRadioButton jRadioButton1 = new JRadioButton();
    JRadioButton jRadioButton2 = new JRadioButton();
    public void run(){ //线程设置
        while(true){
            SimpleDateFormat sdf = new SimpleDateFormat("hh:mm:ss aaa");
            jTextField3.setText(SGetDate.getDate().concat(sdf.format(new Date())));
            try {
                Thread.sleep(1000);
            } catch (InterruptedException ex) {
                ex.printStackTrace();
            }
        }
    }
    public void getTime() {  //获得当前时间以格式化输出
        Date date = new Date();
        DateFormat dft = new SimpleDateFormat("yyyy-MM-dd");
        txtdate.setText(dft.format(date));
    }

    public void jButton6_actionPerformed(ActionEvent e) { //主面版
        SMainMenu sm = new SMainMenu();
        Thread thr = new Thread(sm);
        thr.start();
        this.dispose();
    }

    public void jMenuItem15_actionPerformed(ActionEvent e) { //帮助关于我们
        Icon n2 = new ImageIcon("/Jewelry/logo/20.jpg");
        JOptionPane.showOptionDialog(null, "程序名称：\n   Jewelry\n" +
                                     "程序设计：\n   SEX小组所有成员\n" +
                                     "简介:\n   本软件主要针对珠宝店的管理\n" +
                                     "   欢迎大家下载使用，但下载地址不详！\n" +
                                     "   htpp:\\www.sex.jewelry\\.....\n"+
                                     "小组成员介绍：\n   赵睿--界面及基础信息模块\n" +
                                     "   杨凯--人员面版及代码实现模块\n" +
                                     "   严靖--客户关系及代码实现模块\n" +
                                     "   杨天伟--采购库存面版及代码实现模块\n" +
                                     "   廖理军--销售面版及代码实现模块\n"+
                                     "   联系我们：[e-mail]\n"+
                                     "   QQ:12153016   电话：[phone]", "SEX小组简介",
                                     JOptionPane.DEFAULT_OPTION,
                                     JOptionPane.INFORMATION_MESSAGE,
                                     n2, null, null);


    }

    public void jMenuItem16_actionPerformed(ActionEvent e) { //退出菜单
        int option = JOptionPane.showConfirmDialog(this, "真的要退出本系统吗？", "退出",
                     JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE, null);
         if (option == JOptionPane.NO_OPTION) {
             return;
         }else{
             this.dispose();
         }

    }

    public void jButton1_actionPerformed(ActionEvent e) {//返回
        SMainMenu sm = new SMainMenu();
        sm.baseButton(e);
        Thread thr = new Thread(sm);
        thr.start();
        this.dispose();
    }

    public void jButton2_actionPerformed(ActionEvent e) { //入库表
        ASMainMenu as = new ASMainMenu();
        Thread thr = new Thread(as);
        thr.start();
        this.dispose();
    }

    public void jButton4_actionPerformed(ActionEvent e) {//人员表
        PMainMenu pm = new PMainMenu();
        Thread thr = new Thread(pm);
        thr.start();
        this.dispose();
    }

    public void jButton5_actionPerformed(ActionEvent e) {//客户
        CSMainMenu cs = new CSMainMenu();
        Thread thr = new Thread(cs);
        thr.start();
        this.dispose();
    }

    public static void eclick(String ename){
        txtEclient.setText(ename);
    }
    public void jButton7_actionPerformed(ActionEvent e) { //客户查询小键
        Aclientstate acs = new Aclientstate();
        acs.setSize(260,355);
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = acs.getSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        acs.setLocation((screenSize.width - frameSize.width) / 2,
                         (screenSize.height - frameSize.height) / 2);
        acs.setVisible(true);
    }
    public static void pclick(String ename){
       txtPerson.setText(ename);
   }

    public void jButton9_actionPerformed(ActionEvent e) { //人员查询小键
        EPerson eps = new EPerson();
        eps.setSize(260,355);
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = eps.getSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        eps.setLocation((screenSize.width - frameSize.width) / 2,
                         (screenSize.height - frameSize.height) / 2);
        eps.setVisible(true);

    }

    public void jTable3_mousePressed(MouseEvent e) { //点JTable3的事件
        jTable3.setSelectionBackground(Color.GREEN);
        int row = jTable3.getSelectedRow();
        if(row >= 0){
            if(e.getClickCount() == 2){  //点击填加珠宝编号
                String id = jTable3.getValueAt(row,0).toString();
                jTextField6.setText(id);
                //应收价格
                jTextField13.setText(SDBManager.getOne("select aprice from asset where aid = '"+id+"'").elementAt(0).toString());
                //库存量
                jTextField9.setText(SDBManager.getOne("select acount from asset where aid = '"+id+"'").elementAt(0).toString());
            }
        }
    }

    public void jButton11_actionPerformed(ActionEvent e) {//模糊查询
        String str = jTextField4.getText();
        jTable3.setModel(new DefaultTableModel(SDBManager.getOtherAll(str),v_asset));
    }
    public void notenumber(){  //显示统计信息
        String rownum = SDBManager.getAll("select count(*) from sell").elementAt(0).toString();
        String sumprice = SDBManager.getAll("select sum(convert(float,sprice)) from sell").elementAt(0).toString();
        String sumcount = SDBManager.getAll("select sum(convert(int,scount)) from sell").elementAt(0).toString();
        txtshow.setText("            总销售记录 "+rownum+" 条        总销售金额 "+sumprice+" ￥        总销售珠宝数量 "+sumcount+" 件");
    }
    public void jButton10_actionPerformed(ActionEvent e) {//增加明细按钮功能，显示明细表,同时增加销售表，并显示
        clickcount++;
        if(number == 1){ //表示只点了合计价格按钮后，才执行下面操作
            String sid = txtsell.getText(); //销售编号
            String aid = jTextField6.getText();//珠宝编号
            String snum = acount.getModel().getValue().toString();//数量
            //成本价格
            String acost = SDBManager.getOne("select acost from asset where aid = '"+aid+"'").elementAt(0).toString();
            String cid = txtEclient.getText();   //客户编号
            //折扣比列
            String discut = SDBManager.getOne("select cdiscut from client where cid = '"+cid+"'").elementAt(0).toString();
            //计算折扣价格
            double dprice = Math.round((Double.parseDouble(acost) * (1 - Double.parseDouble(discut)))*100)/100.0;
            System.out.println(dprice);
            String disprice = String.valueOf(dprice);
            String result = jTextField14.getText(); //实售价格
            String sql = "insert into selllist values('"+sid+"','"+snum+"','"+acost+"','"+discut+"','"+disprice+"','"+result+"')";
            if(SDBManager.dbUpdate(sql)){ //填加明细表
                number = -1;
                sql = "select * from selllist where sid = '"+sid+"'";
                jTable2.setModel(new DefaultTableModel(SDBManager.getAll(sql),v_list));//显示明细表
                jTable2.setRowHeight(30);
                String sdate = txtdate.getText();//销售日期
                String pid = txtPerson.getText();//员工编号
                String aprice = jTextField13.getText();//应收价
                String smodel = jComboBox1.getSelectedItem().toString();//付款方式
                sql = "insert into sell values('"+sid+"','"+aid+"','"+sdate+"','"+cid+"','"+pid+"','"+snum+"','"+smodel+"','"+aprice+"','"+result+"')";
                if(SDBManager.dbUpdate(sql)){     //填加销售表
                    sql = "select * from sell";
                    //显示JTable
                    jTable1.setModel(new DefaultTableModel(SDBManager.getAll(sql),v_sell));
                    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显示存货
                    jTable3.setModel(new DefaultTableModel(SDBManager.getAll("select aid,aname from asset where acount != 0"),v_asset));