jf_view_xstk.java

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

                ex.printStackTrace();
            }
           manger.closeFrame(this);
        }
    }

    public void jBth_actionPerformed(ActionEvent e) {
        if (jTable2.getRowCount() <= 0 ) return;
        int result = JOptionPane.showOptionDialog(null,"是否存盘药品销售退货情况?","系统提示",
                                   JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,
                                   null,new String[]  {"是","否"},"否");
        if (result == JOptionPane.NO_OPTION) return;

        java.util.Calendar calendar = null;
        Locale loc = new Locale("CN");
        calendar = Calendar.getInstance(loc);
        calendar.setTimeInMillis(System.currentTimeMillis());
        int year = calendar.get(Calendar.YEAR);
        int month = calendar.get(Calendar.MONTH) + 1;
        int day = calendar.get(Calendar.DAY_OF_MONTH);
        String rqStr = year + "-" + month + "-" + day;
        java.sql.Date thrq = java.sql.Date.valueOf(rqStr);
        //  "销售价格","销售数量","销售金额","销售日期","退库金额","退库日期","经办人"
        for (int i = 0 ; i < jTable2.getRowCount() ; i++){
            if (jTable1.getValueAt(i,6)==null){
                JOptionPane.showMessageDialog(null, "退库金额不允许为空,请录入!!!", "系统提示",
                                              JOptionPane.ERROR_MESSAGE);
                return;
            }
            //"销售流水号","药品编号","销售价格","销售数量","销售金额","销售日期","退库数量","退库金额","退库日期","经办人"
            float xsje,thje;
            xsje = Float.parseFloat(String.valueOf(jTable2.getValueAt(i,4)));
            thje = Float.parseFloat(String.valueOf(jTable2.getValueAt(i,7)));
            if (thje != xsje){
                JOptionPane.showMessageDialog(null,"退还金额【" + thje + "】必须等于销售金额【" + xsje + "】,请修改！！！","系统提示",JOptionPane.ERROR_MESSAGE);
                return;
            }
            appjxc.model.Obj_SellDetaileTh selldetaileTh = new appjxc.model.Obj_SellDetaileTh();
            selldetaileTh.setXslsh(jTable2.getValueAt(i,0).toString());
            selldetaileTh.setYpbh(jTable2.getValueAt(i,1).toString());
            selldetaileTh.setJbr("经办人");
            selldetaileTh.setThrq(thrq);

            selldetaileTh.setThsl(Integer.parseInt(jTable2.getValueAt(i,6).toString()));
            selldetaileTh.setThje(Float.parseFloat(String.valueOf(thje)));
            selldetaileTh.setThje(thje);
            appjxc.dao.AdapterDao.InsertObj_SellDetaileTh(selldetaileTh);
            //更新退货明晰表状态
            Obj_SellDetaile sell = selldetaile[i];
            sell.setThsts("T");
            appjxc.dao.AdapterDao.InsertSellDetaile(sell);
            //更新盘点数据表中的库存数量
            String strSql = null;
            strSql = "from Obj_Stock where ypbh = '" + jTable2.getValueAt(i,1).toString() + "'";
            java.util.List stockList =  appjxc.dao.AdapterDao.QueryObject(strSql);
            Obj_Stock stock = (Obj_Stock)stockList.get(0);
            stock.setKcsl(stock.getKcsl() + selldetaileTh.getThsl());
            appjxc.dao.AdapterDao.InsertStock(stock);
        }
        JOptionPane.showMessageDialog(null,"销售退货数据存盘成功!!!","系统提示",JOptionPane.OK_OPTION);
        //jTdjh.setText("");

        ActionEvent frase = new ActionEvent(jBquery,0,null);
        this.jBquery_actionPerformed(frase);

    }
   /* public void tableChanged(javax.swing.event.TableModelEvent event){
        if (event.getColumn() == 6) {
            int row = event.getFirstRow();
            int tksl;
            float tkje, xsjg;
            tksl = Integer.parseInt(String.valueOf(jTable2.getValueAt(row, 6)));
            xsjg = Float.parseFloat(String.valueOf(jTable2.getValueAt(row, 2)));
            tkje = tksl * xsjg;
            jTable2.setValueAt(String.valueOf(tkje), row, 7);

        }


    }*/
    public void jTable1_mouseClicked(MouseEvent e) {
        if (jTable1.getRowCount() <= 0 ) return;
        java.util.Calendar calendar = null;
        Locale loc = new Locale("CN");
        calendar = Calendar.getInstance(loc);
        calendar.setTimeInMillis(System.currentTimeMillis());
        int year = calendar.get(Calendar.YEAR);
        int month = calendar.get(Calendar.MONTH) + 1;
        int day = calendar.get(Calendar.DAY_OF_MONTH);
        String rqStr = year + "-" + month + "-" + day;
        java.sql.Date thrq = java.sql.Date.valueOf(rqStr);

        int row = jTable1.getSelectedRow();
        Obj_SellDetaile sell = selldetaile[row];
        String hm = null,hm1 = null;
        hm = String.valueOf(jTable1.getValueAt(row,0));
        System.out.println("hm = " + hm);
        if (jTable2.getRowCount() > 0 ){
            for (int i= 0 ; i < jTable2.getRowCount(); i++){
                hm1 = String.valueOf(jTable2.getValueAt(i,1));
                System.out.println("hm1 = " + hm1);
                if (hm.equals(hm1)) return;
            }

        }
        java.util.Vector vdata = new java.util.Vector();
        vdata.addElement(sell.getXslsh());
        vdata.addElement(sell.getYpbh());
        vdata.addElement(String.valueOf(sell.getXsdj()));
        vdata.addElement(String.valueOf(sell.getXssl()));
        vdata.addElement(String.valueOf(sell.getXsje()));
        vdata.addElement(sell.getXsrq());
        vdata.addElement(String.valueOf(sell.getXssl()));
        vdata.addElement(String.valueOf(sell.getXsje()));
        vdata.addElement(thrq);
        tableMode2.addRow(vdata);
        jTable2.setRowHeight(20);
    }

    public void jTdjh_keyPressed(KeyEvent e) {
        if(e.getKeyCode() == KeyEvent.VK_ENTER){
            ActionEvent query = new ActionEvent(jBquery,0,null);
            this.jBquery_actionPerformed(query);
        }
    }
}


class JF_view_xstk_jBpd_actionAdapter implements ActionListener {
    private JF_view_xstk adaptee;
    JF_view_xstk_jBpd_actionAdapter(JF_view_xstk adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_xstk_jBexit_actionAdapter implements ActionListener {
    private JF_view_xstk adaptee;
    JF_view_xstk_jBexit_actionAdapter(JF_view_xstk adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_xstk_jTable1_mouseAdapter extends MouseAdapter {
    private JF_view_xstk adaptee;
    JF_view_xstk_jTable1_mouseAdapter(JF_view_xstk adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_xstk_jBquery_actionAdapter implements ActionListener {
    private JF_view_xstk adaptee;
    JF_view_xstk_jBquery_actionAdapter(JF_view_xstk adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_xstk_jTdjh_keyAdapter extends KeyAdapter {
    private JF_view_xstk adaptee;
    JF_view_xstk_jTdjh_keyAdapter(JF_view_xstk adaptee) {
        this.adaptee = adaptee;
    }

    public void keyPressed(KeyEvent e) {
        adaptee.jTdjh_keyPressed(e);
    }
}