esmainmenu.java~296~

管理系统

        jLabel16.setText("             请完整填写以上信息，珠宝编号请点选左边表格中物品");
        jLabel16.setBounds(new Rectangle(5, 154, 609, 30));
        jComboBox1.setBorder(border1);
        jComboBox1.setBounds(new Rectangle(107, 98, 107, 21));
        acount.setBounds(new Rectangle(287, 95, 51, 22));
        acount.setBorder(border1);
        acount.addChangeListener(new ESMainMenu_acount_changeAdapter(this));
        jTextField5.setBackground(Color.cyan);
        jTextField5.setEnabled(false);
        jTextField5.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField5.setDisabledTextColor(Color.blue);
        jTextField5.setText("（库存量）");
        jTextField5.setBounds(new Rectangle(375, 96, 64, 21));
        jTextField7.setBackground(Color.cyan);
        jTextField7.setEnabled(false);
        jTextField7.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField7.setDisabledTextColor(Color.blue);
        jTextField7.setText("≤");
        jTextField7.setBounds(new Rectangle(338, 96, 18, 21));
        jTextField9.setBackground(Color.cyan);
        jTextField9.setEnabled(false);
        jTextField9.setBorder(BorderFactory.createRaisedBevelBorder());
        jTextField9.setDisabledTextColor(Color.blue);
        jTextField9.setBounds(new Rectangle(353, 96, 25, 21));
        jButton12.setBounds(new Rectangle(372, 206, 140, 25));
        jButton12.setText("删除明细与销售表");
        jButton12.addActionListener(new ESMainMenu_jButton12_actionAdapter(this));
        jTable1.addMouseListener(new ESMainMenu_jTable1_mouseAdapter(this));
        jButton13.setBounds(new Rectangle(512, 206, 123, 25));
        jButton13.setText("增加销售单");
        jButton13.addActionListener(new ESMainMenu_jButton13_actionAdapter(this));
        txtshow.setBackground(new Color(125, 0, 0));
        txtshow.setEnabled(false);
        txtshow.setForeground(Color.yellow);
        txtshow.setBorder(BorderFactory.createRaisedBevelBorder());
        txtshow.setDisabledTextColor(Color.yellow);
        txtshow.setBounds(new Rectangle(84, 15, 525, 23));
        jMenuItem22.setText("销售分析比列图");
        jMenuItem22.addActionListener(new ESMainMenu_jMenuItem22_actionAdapter(this));
        jTree2.addMouseListener(new ESMainMenu_jTree2_mouseAdapter(this));
        jTable2.addMouseListener(new ESMainMenu_jTable2_mouseAdapter(this));
        jPanel8.setBorder(BorderFactory.createEtchedBorder());
        jPanel8.setBounds(new Rectangle(11, 51, 184, 34));
        jRadioButton1.setText("宝石类查询");
        jRadioButton2.setText("金银类查询");
        jMenuBar1.add(jMenu1);
        jMenuBar1.add(jMenu2);
        jMenuBar1.add(jMenu3);
        jMenuBar1.add(jMenu4);
        jMenuBar1.add(jMenu5);
        jMenuBar1.add(jMenu6);
        jMenuBar1.add(jMenu7);
        jMenu1.add(jMenuItem1);
        jMenu1.add(jMenuItem2);
        jMenu1.add(jMenuItem3);
        jMenu1.add(jMenuItem17);
        jMenu2.add(jMenu8);
        jMenu2.add(jMenu9);
        jMenu3.add(jMenuItem7);
        jMenu4.add(jMenuItem8);
        jMenu4.add(jMenuItem6);
        jMenu5.add(jMenuItem11);
        jMenu5.add(jMenuItem22);
        jMenu6.add(jMenuItem13);
        jMenu7.add(jMenuItem15);
        jMenu7.add(jMenuItem16);
        jSplitPane1.add(jPanel3, JSplitPane.RIGHT);
        jPanel3.add(jPanel7);
        jPanel7.add(jLabel1);
        jPanel7.add(jLabel3);
        jPanel7.add(txtsell);
        jPanel7.add(jLabel2);
        jPanel7.add(jTextField6);
        jPanel7.add(txtdate);
        jPanel7.add(jLabel5);
        jPanel7.add(txtEclient);
        jPanel7.add(jButton7);
        jPanel7.add(jLabel4);
        jPanel7.add(txtPerson);
        jPanel7.add(jButton9);
        jPanel7.add(jLabel7);
        jPanel7.add(jLabel12);
        jPanel7.add(jTextField13);
        jPanel7.add(jLabel14);
        jPanel7.add(jLabel13);
        jPanel7.add(jTextField14);
        jPanel7.add(jLabel15);
        jPanel7.add(jButton8);
        jPanel7.add(jLabel16);
        jPanel7.add(jLabel6);
        jPanel7.add(jComboBox1);
        jPanel7.add(acount);
        jPanel7.add(jTextField7);
        jPanel7.add(jTextField9);
        jPanel7.add(jTextField5);
        jPanel3.add(jPanel9);
        jPanel9.add(jScrollPane5);
        jScrollPane5.getViewport().add(jTable3);
        jPanel9.add(jTextField4);
        jPanel9.add(jButton11);
        jPanel9.add(jPanel8);
        jPanel8.add(jRadioButton1);
        jPanel8.add(jRadioButton2);
        jPanel3.add(jPanel5);
        jPanel5.add(jScrollPane4);
        jScrollPane4.getViewport().add(jTable2);
        jPanel3.add(jButton10);
        jPanel3.add(jPanel6);
        jPanel6.add(jScrollPane3);
        jPanel6.add(txtshow);
        jPanel3.add(jButton12);
        jPanel3.add(jButton13);
        jScrollPane3.getViewport().add(jTable1);
        jPanel7.setBorder(BorderFactory.createTitledBorder(BorderFactory.
                createLineBorder(Color.black, 1),
                "销售单填写信息", TitledBorder.LEFT, TitledBorder.TOP));
        jSplitPane1.add(jSplitPane2, JSplitPane.LEFT);
        jSplitPane2.add(jScrollPane1, JSplitPane.TOP);
        jSplitPane2.add(jScrollPane6, JSplitPane.BOTTOM);
        showTree2();
        jScrollPane6.getViewport().add(jTree2);
        this.getContentPane().add(jPanel1, java.awt.BorderLayout.CENTER);
        jPanel1.add(jPanel4, java.awt.BorderLayout.NORTH);
        jPanel1.add(jSplitPane1, java.awt.BorderLayout.CENTER);
        jPanel1.add(jPanel2, java.awt.BorderLayout.SOUTH);
        jMenu8.add(jMenuItem4);
        jMenu8.add(jMenuItem9);
        jMenu8.add(jMenuItem10);
        jMenu8.add(jMenuItem12);
        jMenu8.add(jMenuItem18);
        jMenu8.add(jMenuItem19);
        jMenu9.add(jMenuItem5);
        jMenu9.add(jMenuItem20);
        jMenu9.add(jMenuItem14);
        jMenu9.add(jMenuItem21);
        jPanel4.add(jButton1, null);
        jPanel4.add(jButton2, null);
        jPanel4.add(jButton3, null);
        jPanel4.add(jButton4, null);
        jPanel4.add(jButton5, null);
        jPanel4.add(jButton6, null);
        this.getContentPane().add(jScrollPane2, java.awt.BorderLayout.WEST);
        jButton1.setLocation(4, 5);
        getNumber();
        getTime();
        jComboBox1.setModel(new DefaultComboBoxModel(SDBManager.getOne("select model from paymodel")));
        jComboBox1.setSelectedIndex(0);//RightToLeft;
        //树型结构
        root.add(parent);
        parent.add(nparent);
        jScrollPane1.getViewport().add(jTree1);
        jPanel2.add(jTextField1);
        jPanel2.add(jTextField2);
        jPanel2.add(jTextField3);
        acount.setModel(new SpinnerNumberModel(1,1,100,1));
        String[] selhead = {"销售编号","珠宝编号","销售日期","客户编号","收款人编号","数量","支付方式","应收价格","实售价格"};
        for (int i = 0; i < selhead.length; i++) {
            v_sell.addElement(selhead[i]);
        }
        v_list.addElement("销售编号");v_list.addElement("数量");v_list.addElement("原价");
        v_list.addElement("折扣比列");v_list.addElement("折扣价格");v_list.addElement("实售金额");
        v_asset.addElement("珠宝编号");v_asset.addElement("珠宝名称");
        jTable3.setModel(new DefaultTableModel(SDBManager.getAll("select aid,aname from asset where acount != 0"),v_asset));
        jTable1.setModel(new DefaultTableModel(SDBManager.getAll("select * from sell"),v_sell));
        notenumber();
    }
    public void getNumber(){
        boolean sidd = true;
        do{
            String str = "SXL00" + Math.round(Math.random()*1000 + 1);
            if(SDBManager.getOne("select sid from selllist where sid = '"+str+"'").isEmpty()){
                txtsell.setText(str);
                sidd = false;
            }
        }while(sidd);
    }
    public void showTree2(){
            DefaultMutableTreeNode root = new DefaultMutableTreeNode("系统设置");
            DefaultMutableTreeNode roo1 = new DefaultMutableTreeNode("字体颜色");
            DefaultMutableTreeNode roo2 = new DefaultMutableTreeNode("背景颜色");
            DefaultMutableTreeNode roo3 = new DefaultMutableTreeNode("文本框颜色");
            DefaultMutableTreeNode roo4 = new DefaultMutableTreeNode("默认颜色");
            DefaultMutableTreeNode leaf1 = new DefaultMutableTreeNode("黑");
            DefaultMutableTreeNode leaf2 = new DefaultMutableTreeNode("黄");
            DefaultMutableTreeNode leaf3 = new DefaultMutableTreeNode("蓝");
            DefaultMutableTreeNode leaf4 = new DefaultMutableTreeNode("浅灰");
            DefaultMutableTreeNode leaf5 = new DefaultMutableTreeNode("深灰");
            DefaultMutableTreeNode leaf6 = new DefaultMutableTreeNode("白");
            DefaultMutableTreeNode leaf7 = new DefaultMutableTreeNode("黑色");
           DefaultMutableTreeNode leaf8 = new DefaultMutableTreeNode("黄色");
           DefaultMutableTreeNode leaf9 = new DefaultMutableTreeNode("蓝色");

            roo1.add(leaf1);roo1.add(leaf2);roo1.add(leaf3);
            roo2.add(leaf4);roo2.add(leaf5);roo2.add(leaf6);
            roo3.add(leaf7);roo3.add(leaf8);roo3.add(leaf9);
            root.add(roo1);root.add(roo2);root.add(roo3);root.add(roo4);
            jTree2.setModel(new DefaultTreeModel(root));
    }
    public void jTree2_mouseClicked(MouseEvent e) { //设置事件
        JTree tree = (JTree) e.getSource();
        DefaultMutableTreeNode node = (DefaultMutableTreeNode)tree.getLastSelectedPathComponent();
        Vector vlter = new Vector();
        vlter.addElement(jLabel1);vlter.addElement(jLabel2);vlter.addElement(jLabel3);
        vlter.addElement(jLabel4);vlter.addElement(jLabel5);vlter.addElement(jLabel6);vlter.addElement(jLabel7);
        Vector vbut = new Vector();
        vbut.addElement(jButton7);vbut.addElement(jButton8);vbut.addElement(jButton9);
        vbut.addElement(jButton10);vbut.addElement(jButton11);vbut.addElement(jButton12);vbut.addElement(jButton13);
        Vector vpnl = new Vector();
        vpnl.addElement(jPanel3);vpnl.addElement(jPanel5);vpnl.addElement(jPanel6);vpnl.addElement(jPanel7);vpnl.addElement(jPanel9);
        Vector vtxt = new Vector();
        vtxt.addElement(txtEclient);vtxt.addElement(txtPerson);
        if(!node.isRoot()){
           if(node.isLeaf()){
               if(node.toString().equals("黑")){
                   for (int i = 0; i < vlter.size(); i++) {
                       JLabel jab = (JLabel)vlter.elementAt(i);
                       jab.setForeground(Color.black);
                       JButton jbt = (JButton)vbut.elementAt(i);
                       jbt.setBackground(Color.white);
                       jbt.setForeground(Color.black);
                   }
                   jLabel16.setForeground(Color.black);
               }
               if(node.toString().equals("黄")){
                   for (int i = 0; i < vlter.size(); i++) {
                       JLabel jab = (JLabel)vlter.elementAt(i);
                       jab.setForeground(Color.yellow);
                       JButton jbt = (JButton)vbut.elementAt(i);
                       jbt.setBackground(Color.yellow);
                       jbt.setForeground(Color.black);
                   }
                   jLabel16.setForeground(Color.yellow);
               }
               if(node.toString().equals("蓝")){
                   for (int i = 0; i < vlter.size(); i++) {
                       JLabel jab = (JLabel)vlter.elementAt(i);
                       jab.setForeground(Color.blue);
                       JButton jbt = (JButton)vbut.elementAt(i);
                       jbt.setBackground(Color.blue);
                       jbt.setForeground(Color.orange);
                   }
                   jLabel16.setForeground(Color.blue);
               }
               if(node.toString().equals("黑色")){
                   for (int i = 0; i < vtxt.size(); i++) {
                       JTextField jtf = (JTextField)vtxt.elementAt(i);
                       jtf.setForeground(Color.black);
                   }
               }
               if(node.toString().equals("黄色")){
                   for (int i = 0; i < vtxt.size(); i++) {
                       JTextField jtf = (JTextField)vtxt.elementAt(i);
                       jtf.setForeground(Color.yellow);
                   }
               }
               if(node.toString().equals("蓝色")){
                   for (int i = 0; i < vtxt.size(); i++) {
                       JTextField jtf = (JTextField)vtxt.elementAt(i);
                       jtf.setForeground(Color.BLUE);
                   }
               }

               if(node.toString().equals("默认颜色")){
                   new ESMainMenu();
                   this.dispose();
               }
               if(node.toString().equals("浅灰")){
                   for (int i = 0; i < vpnl.size(); i++) {
                       JPanel jab = (JPanel)vpnl.elementAt(i);
                       jab.setBackground(Color.lightGray);
                   }
               }
               if(node.toString().equals("深灰")){
                   for (int i = 0; i < vpnl.size(); i++) {
                       JPanel jab = (JPanel)vpnl.elementAt(i);
                       jab.setBackground(Color.GRAY);
                   }

               }
               if(node.toString().equals("白")){
                   for (int i = 0; i < vpnl.size(); i++) {
                       JPanel jab = (JPanel)vpnl.elementAt(i);
                       jab.setBackground(Color.WHITE);
                   }
               }
           }
       }

    }

    //树型结构
    DefaultMutableTreeNode root = new DefaultMutableTreeNode("菜单选项");
    DefaultMutableTreeNode parent = new DefaultMutableTreeNode("销售信息");
    DefaultMutableTreeNode nparent = new DefaultMutableTreeNode("查询");