jf_view_sell.java

医药进销存管理系统 对医药公司的进销存进行管理

               jcbh.addItem(iterator.next());
           }
           jcbh.addItemListener(new JF_view_sell_jcbh_itemAdapter(this));
       }
       TableColumnModel tcm = jTable1.getColumnModel();
       tcm.getColumn(0).setPreferredWidth(140);
       tcm.getColumn(1).setCellEditor(new DefaultCellEditor(jcbh));
       jTable1.setRowHeight(20);
       jTable1.requestFocus();
       jBdel.setEnabled(true);
       jBsave.setEnabled(true);

    }
    public void tableChanged(javax.swing.event.TableModelEvent e){
        int row = e.getFirstRow();
        int col = e.getColumn();
        if (col == 8){ //为销售数量
            Object obj = jTable1.getValueAt(row,col);
            int xssl,kcsl;
            double xsdj,xsje;
            xsdj = Double.parseDouble(String.valueOf(jTable1.getValueAt(row,7)).trim());
            xssl = Integer.parseInt(String.valueOf(obj).trim());
            kcsl = Integer.parseInt(String.valueOf(jTable1.getValueAt(row,10)));
            if (xssl > kcsl){
                JOptionPane.showMessageDialog(null,"销售数量【" + xssl + "】不能大于库存数量【" + kcsl + "】,请修改！！！","系统提示",JOptionPane.ERROR_MESSAGE);
                return;
            }

            xsje = xsdj * xssl;
            System.out.println("xssl" +  xssl + ";xsdj" + xsdj + ";xsje" + xsje);
            jTable1.setValueAt(String.valueOf(xsje),row,9);
            jTextField1.setText(String.valueOf(jTable1.getRowCount())); //销售品种数
            int xszs = 0;
            double hjje = 0.00;
            for (int i = 0 ; i < jTable1.getRowCount() ; i++){
                xszs = xszs + Integer.parseInt(String.valueOf(jTable1.getValueAt(i,8)).trim());
                hjje = hjje + Double.parseDouble(String.valueOf(jTable1.getValueAt(i,9)).trim());
            }
            jTextField2.setText(String.valueOf(xszs)); //销售总数
            jTextField3.setText(String.valueOf(hjje)); //合计金额
        }

//

    }
    public void jcbh_itemStateChanged(ItemEvent itemEvent) {
            String bh;
            Object obj = jcbh.getSelectedItem();
            if (obj == null)return;
            int row;
            row = jTable1.getSelectedRow();
            if (row < 0 ) return;
            bh = obj.toString();
            String queryStr;
            System.out.println("queryStr = from obj_medicine m where m.ypbh = '" + bh );
            queryStr = "FROM Obj_Stock s JOIN s.objmedicine where s.ypbh = '" + bh + "'";
            List list = AdapterDao.QueryObject(queryStr);
            Object objlist[] = null;
            objlist = (Object[])list.get(0);
            obj_medicine objm = (obj_medicine)objlist[1];
            jTable1.setValueAt(objm.getYpmc(), row, 2);
            jTable1.setValueAt(objm.getPh(), row, 3);
            jTable1.setValueAt(objm.getGg(), row, 4);
            jTable1.setValueAt(objm.getCd(), row, 5);
            jTable1.setValueAt(objm.getDw(), row, 6);
            jTable1.setValueAt(objm.getLsjg(), row, 7);
            Obj_Stock objstock = (Obj_Stock)objlist[0];
            System.out.println(objstock);
             System.out.println(objstock.getKcsl());
            jTable1.setValueAt(String.valueOf(objstock.getKcsl()), row, 10);
           /* java.util.Iterator iterator = null;
            while (iterator.hasNext()) {
                //obj_medicine objm = (obj_medicine) iterator.next();
                jTable1.setValueAt(objm.getYpmc(), row, 2);
                jTable1.setValueAt(objm.getPh(), row, 3);
                jTable1.setValueAt(objm.getGg(), row, 4);
                jTable1.setValueAt(objm.getCd(), row, 5);
                jTable1.setValueAt(objm.getDw(), row, 6);
                jTable1.setValueAt(objm.getLsjg(), row, 7);
            }
            queryStr = "select b.kcsl from Obj_BuyDetaile b where b.ypbh = '" + bh + "'";
            list = AdapterDao.QueryObject(queryStr);
            Object kcsl = list.get(0);
            System.out.println("kcsl = " + kcsl);
            jTable1.setValueAt(kcsl, row, 10);*/


   }
   public void jCbox_itemStateChanged(ItemEvent e){
       if (jComboBox2.getItemCount() > 0) {
                int selectindex;
                selectindex = jComboBox2.getSelectedIndex();
                System.out.println(jComboBox2.getSelectedIndex());
                if (jComboBox21.getItemCount() > 0 ){
                    jComboBox21.setSelectedIndex(selectindex);
                }
                System.out.println(jComboBox21.getItemCount());
                //System.out.println(jComboBox21.getSelectedItem());
            }

   }

    public void jButton3_actionPerformed(ActionEvent e) {
        javax.swing.DefaultDesktopManager manger = new DefaultDesktopManager();
        int result = JOptionPane.showOptionDialog(null,"是否真的退出销售信息情况吗?","系统提示",
                                   JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,
                                   null,new String[]  {"是","否"},"否");
        if (result == JOptionPane.YES_OPTION) {
            try{
               // UIManager.setLookAndFeel("com.sun.java.swing.plaf.motif.MotifLookAndFeel");
               // SwingUtilities.updateComponentTreeUI(this);
            }catch(Exception ex){
                ex.printStackTrace();
            }
           manger.closeFrame(this);
        }

    }

    public void jBsave_actionPerformed(ActionEvent e) {
        javax.swing.DefaultDesktopManager manger = new DefaultDesktopManager();
        int result = JOptionPane.showOptionDialog(null,"是否真的存盘销售信息情况?","系统提示",
                                   JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,
                                   null,new String[]  {"是","否"},"否");
        if (result == JOptionPane.NO_OPTION) return;
        if (jTjbr.getText().trim().length() <= 0){
            JOptionPane.showMessageDialog(null,"经办人不允许为空,请录入!!!","系统提示",JOptionPane.ERROR_MESSAGE);
            jTjbr.requestFocus();
            return;
        }
        if(jTable1.getRowCount() > 1){
            for (int i = 0 ; i < jTable1.getRowCount(); i++) {
                String ypbh, ypbh1;
                ypbh = String.valueOf(jTable1.getValueAt(i, 1));
                System.out.println("ypbh = " + ypbh + "; i = " + i);
                int j = i + 1;
                if (j == jTable1.getRowCount()) continue;
                for (; j < jTable1.getRowCount(); j++) {
                    ypbh1 = String.valueOf(jTable1.getValueAt(j, 1));
                    System.out.println("ypbh1 = " + ypbh1 + "; j = " + j);
                    if(ypbh.equals(ypbh1)){
                        JOptionPane.showMessageDialog(null, "编号【" + ypbh1 + "】重复请从新选择", "系统提示",
                                              JOptionPane.ERROR_MESSAGE);
                        return;
                    }
                }
            }
        }
        if (jTextField4.getText().trim().length() <= 0){
            JOptionPane.showMessageDialog(null,"折扣金额不允许为空,请录入!!!","系统提示",JOptionPane.ERROR_MESSAGE);
            jTextField4.requestFocus();
            return;
        }
        if (jTextField5.getText().trim().length() <= 0){
            JOptionPane.showMessageDialog(null,"应收金额不允许为空,请录入!!!","系统提示",JOptionPane.ERROR_MESSAGE);
            jTextField5.requestFocus();
            return;
        }
        if (jTextField6.getText().trim().length() <= 0){
            JOptionPane.showMessageDialog(null,"实收金额不允许为空,请录入!!!","系统提示",JOptionPane.ERROR_MESSAGE);
            jTextField6.requestFocus();
            return;
        }



        /*------生成主表更新对象 Obj_SellMain--------*/
        Obj_SellMain objsellmain = new Obj_SellMain();
        objsellmain.setKhbh(String.valueOf(jComboBox21.getSelectedItem()));
        int pzs,xszs;
        Double xsje,xszk,ysje,ssje,wsje;
        try{
            pzs = Integer.parseInt(jTextField1.getText().trim());
            xszs = Integer.parseInt(jTextField2.getText().trim());
            xsje = Double.valueOf(jTextField3.getText().trim());
            xszk = Double.valueOf(jTextField4.getText().trim());
            ysje = Double.valueOf(jTextField5.getText().trim());
            ssje = Double.valueOf(jTextField6.getText().trim());
            wsje = Double.valueOf(jTextField8.getText().trim());

        }catch(java.lang.NumberFormatException format){
           JOptionPane.showMessageDialog(null, "输入的数据格式有误,请重新录入!!\n" + format.getMessage(), "系统提示",JOptionPane.ERROR_MESSAGE);
           System.out.println(format.getMessage());
           return;
       }

        objsellmain.setPzs(pzs);
        objsellmain.setXszs(xszs);
        objsellmain.setXsje(xsje);
        objsellmain.setXszk(xszk);
        objsellmain.setYsje(ysje);
        objsellmain.setSsje(ssje);
        objsellmain.setWsje(wsje);

        java.sql.Date xsrq = null;
        try{
            xsrq = java.sql.Date.valueOf(jTldrq.getText().trim());
        }catch(Exception ex){
            ex.printStackTrace();
            return;
        }
        objsellmain.setXsrq(xsrq);
        objsellmain.setSkfs(String.valueOf(jComboBox1.getSelectedItem()));
        objsellmain.setJbr(jTjbr.getText().trim());
        if (wsje.floatValue() <= 0){
            objsellmain.setQssts("T");
        }else{
            objsellmain.setQssts("F");
        }

        objsellmain.setXsdjh(jTxsph.getText().trim());
        if (AdapterDao.InsertSellMain(objsellmain)){
            JOptionPane.showMessageDialog(null,"药品销售情况主表数据录入成功","系统提示",JOptionPane.INFORMATION_MESSAGE);
           }else{
               JOptionPane.showMessageDialog(null,"药品销售情况数据存盘失败","系统提示",JOptionPane.ERROR_MESSAGE);
           }

        /*------生成从表更新对象 Obj_SellDetaile--------*/

        for (int i = 0 ; i < jTable1.getRowCount(); i++){
            Obj_SellDetaile objselldetaile = new Obj_SellDetaile();
            String lsh,ypbh,xsdjh;
            int xssl,kcsl;
            float xsdj,je;
            lsh = String.valueOf(jTable1.getValueAt(i,0));
            ypbh = String.valueOf(jTable1.getValueAt(i,1));
            xsdjh = jTxsph.getText().trim();
            xssl = Integer.parseInt(String.valueOf(jTable1.getValueAt(i,8)));
            kcsl = Integer.parseInt(String.valueOf(jTable1.getValueAt(i,10)));
            if (xssl > kcsl){
                JOptionPane.showMessageDialog(null,"销售数量【" + xssl + "】不能大于库存数量【" + kcsl + "】,请修改！！！","系统提示",JOptionPane.ERROR_MESSAGE);
                return;
            }
            xsdj = Float.parseFloat(String.valueOf(jTable1.getValueAt(i,7)));
            je = Float.parseFloat(String.valueOf(jTable1.getValueAt(i,9)));
            objselldetaile.setXslsh(lsh);
            objselldetaile.setYpbh(ypbh);
            //定义主表的关联对象用来保存主表中的ypbh
            appjxc.model.obj_medicine medicne = new obj_medicine();
            medicne.setYpbh(ypbh);
            objselldetaile.setMedicine(medicne);
            objselldetaile.setXsdjh(xsdjh);
            objselldetaile.setXssl(xssl);
            objselldetaile.setXsdj(xsdj);
            objselldetaile.setXsje(je);
            objselldetaile.setXsrq(xsrq);
            objselldetaile.setThsts("F");
            AdapterDao.InsertSellDetaile(objselldetaile);
            //更新盘点数据表Obj_Stock 以便进行查询
            String stockQuery = "from Obj_Stock where ypbh = '" + ypbh + "'";
            java.util.List list = AdapterDao.QueryObject(stockQuery);
            java.util.Iterator iterator = list.iterator();