jf_view_kcpd.java

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

package appjxc.view;

import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.FlowLayout;
import javax.swing.BorderFactory;
import java.awt.Color;
import javax.swing.table.DefaultTableModel;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import appjxc.model.Obj_Stock;
import appjxc.model.obj_medicine;
import java.awt.Font;
import java.util.Calendar;
import java.util.Locale;

public class JF_view_kcpd extends JInternalFrame{//JFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    JScrollPane jScrollPane1 = new JScrollPane();
    JPanel jPanel1 = new JPanel();
    JTable jTable1 = new JTable();
    FlowLayout flowLayout1 = new FlowLayout();
    JButton jBpd = new JButton();
    JButton jBsave = new JButton();
    JButton jBexit = new JButton();
    DefaultTableModel tableModel = null;
    JButton jBquery = new JButton();

    java.util.List liststock = null;
    public JF_view_kcpd() {
        try {
            jbInit();
            buildTable();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }


    public void buildTable(){
        String[] tname = {"药品编号","药品名称","药品批号","规格","产地","单位","剂型","有效期至","库存数量","盘点数量"};
        java.util.Vector vname = new java.util.Vector();
        for (int i = 0 ; i < tname.length ; i++){
            vname.addElement(tname[i]);
        }
        tableModel = new DefaultTableModel(vname,0);
        jTable1.setModel(tableModel);

    }
    private void jbInit() throws Exception {
        this.getContentPane().setLayout(borderLayout1);
        jPanel1.setBorder(BorderFactory.createLineBorder(Color.black));
        jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_LAST_COLUMN);
        jScrollPane1.setVerticalScrollBarPolicy(JScrollPane.
                                                VERTICAL_SCROLLBAR_ALWAYS);
        jBquery.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jBquery.setText("查询库存");
        jBquery.addActionListener(new JF_view_kcpd_jBquery_actionAdapter(this));
        jBexit.addActionListener(new JF_view_kcpd_jBexit_actionAdapter(this));
        jBpd.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jBpd.addActionListener(new JF_view_kcpd_jBpd_actionAdapter(this));
        jBsave.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jBexit.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        this.setClosable(true);
        this.setTitle("医药进销存管理系统-[库存盘点]");
        this.getContentPane().add(jScrollPane1, java.awt.BorderLayout.CENTER);
        jBpd.setText("盘点");
        jPanel1.setLayout(flowLayout1);
        this.getContentPane().add(jPanel1, java.awt.BorderLayout.NORTH);
        jBsave.setVisible(false);
        jBsave.setText("导出Excel");
        jBexit.setText("退出");
        jPanel1.add(jBquery);
        jPanel1.add(jBpd);
        flowLayout1.setAlignment(FlowLayout.RIGHT);
        jPanel1.add(jBsave);
        jPanel1.add(jBexit);
        jScrollPane1.getViewport().add(jTable1);
        setSize(700,500);
        setVisible(true);
       //UIManager.setLookAndFeel("javax.swing.plaf.metal.MetalLookAndFeel");
        //SwingUtilities.updateComponentTreeUI(this);
    }

    public void jBquery_actionPerformed(ActionEvent e) {
        if (jTable1.getRowCount() > 0 ) return;
        String queryStr = null;
        //queryStr = "SELECT m.ypbh, m.ypmc, m.ph, m.gg, m.cd, m.dw, m.jx, m.yxq, s.rksl, s.pdsl " +
         //             "FROM Obj_Stock s , obj_medicine m where s.ypbh = m.ypbh";

         //用表关联的方式进行数据统计：从两个一一对应的表中进行组合查询数据( 感觉真酷!!!!)
        queryStr = "FROM Obj_Stock s JOIN s.objmedicine where kcsl > 0";
        java.util.List list = null;
        list = appjxc.dao.AdapterDao.QueryObject(queryStr);
        Object obj[] = null;
        liststock = list;
        for (int i = 0  ; i < list.size() ; i++){
            obj = (Object[])list.get(i);
            Obj_Stock stock = (Obj_Stock)obj[0];//获得关联中的对象
            obj_medicine objmed = (obj_medicine)obj[1];
            java.util.Vector vdata = new java.util.Vector();

            vdata.addElement(objmed.getYpbh());
            vdata.addElement(objmed.getYpmc());
            vdata.addElement(objmed.getPh());
            vdata.addElement(objmed.getGg());
            vdata.addElement(objmed.getCd());
            vdata.addElement(objmed.getDw());
            vdata.addElement(objmed.getJx());
            vdata.addElement(objmed.getYxq());
            vdata.addElement(String.valueOf(stock.getKcsl()));

            tableModel.addRow(vdata);
//            jTable1.setValueAt(String.valueOf(stock.getKcsl()),i,8);
//            jTable1.setValueAt("0",i,9);
//            System.out.println("objmed.getypmc() = " + objmed.getYpmc());
  //          System.out.println("stock.getkcsl() = " + stock.getKcsl());
        }
        jTable1.setRowHeight(20);
        /*java.util.List list = null;
        java.util.List list1 = null;
        java.util.Iterator iterator = null;
        java.util.Iterator iterator1 = null;
        if (jTable1.getRowCount() > 0 ) {
            return;
        }
        queryStr = "from obj_medicine";
        list = appjxc.dao.AdapterDao.QueryObject(queryStr);
        iterator = list.iterator();
        queryStr = "from Obj_Stock";
        list1 = appjxc.dao.AdapterDao.QueryObject(queryStr);
        iterator1 = list1.iterator();

        int i = 0;
        while(iterator.hasNext()){
            obj_medicine objmed = (obj_medicine)iterator.next();
            Obj_Stock stock = (Obj_Stock)iterator1.next();
            java.util.Vector vdata = new java.util.Vector();

            vdata.addElement(objmed.getYpbh());
            vdata.addElement(objmed.getYpmc());
            vdata.addElement(objmed.getPh());
            vdata.addElement(objmed.getGg());
            vdata.addElement(objmed.getCd());
            vdata.addElement(objmed.getDw());
            vdata.addElement(objmed.getJx());
            vdata.addElement(objmed.getYxq());
            tableModel.addRow(vdata);
            jTable1.setValueAt(String.valueOf(stock.getKcsl()),i,8);
            i++;
        }   */


    }

    public void jBexit_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 jBpd_actionPerformed(ActionEvent e) {
        if (jTable1.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 pdrq = java.sql.Date.valueOf(rqStr);

        for (int i = 0 ; i < jTable1.getRowCount() ; i++){
           // if (jTable1.getValueAt(i,9)==null){
         //       JOptionPane.showMessageDialog(null, "盘点数量不允许为空,请录入!!!", "系统提示",
             //                                 JOptionPane.ERROR_MESSAGE);
       //         return;
            //}
            Object[] obj = (Object[])liststock.get(i);
            Obj_Stock stock = null;
            String ypbh = null;
            String sqlStr = null;
            ypbh = jTable1.getValueAt(i,0).toString();
            sqlStr = " from Obj_Stock where ypbh = '" + ypbh + "'";
            java.util.List list = null;
            list = appjxc.dao.AdapterDao.QueryObject(sqlStr);
            stock = (Obj_Stock)list.get(0);

            int kcsl,pdsl;
            try{
                kcsl = Integer.parseInt(String.valueOf(jTable1.getValueAt(i, 8)));
                pdsl = Integer.parseInt(String.valueOf(jTable1.getValueAt(i, 9)));
            }catch(java.lang.NumberFormatException format){
                JOptionPane.showMessageDialog(null,"盘点数量非法,请填写!!!\n" + format.getMessage(),"系统提示",JOptionPane.ERROR_MESSAGE);
                return;
            }
            if (pdsl < 0 ){

            }
            /*if (pdsl > kcsl){
                JOptionPane.showMessageDialog(null,"盘点数量【" + pdsl + "】不能大于库存数量【" + kcsl + "】,请修改！！！","系统提示",JOptionPane.ERROR_MESSAGE);
                return;
            }*/
            stock.setKcsl(kcsl);
            stock.setPdsl(pdsl);
            stock.setPdrq(pdrq);
            appjxc.dao.AdapterDao.InsertStock(stock);
        }
        JOptionPane.showMessageDialog(null,"盘点数据存盘成功!!!","系统提示",JOptionPane.OK_OPTION);
    }
}


class JF_view_kcpd_jBpd_actionAdapter implements ActionListener {
    private JF_view_kcpd adaptee;
    JF_view_kcpd_jBpd_actionAdapter(JF_view_kcpd adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_kcpd_jBexit_actionAdapter implements ActionListener {
    private JF_view_kcpd adaptee;
    JF_view_kcpd_jBexit_actionAdapter(JF_view_kcpd adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_kcpd_jBquery_actionAdapter implements ActionListener {
    private JF_view_kcpd adaptee;
    JF_view_kcpd_jBquery_actionAdapter(JF_view_kcpd adaptee) {
        this.adaptee = adaptee;
    }

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