jf_view_xstk.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;
import java.awt.Dimension;
import appjxc.model.Obj_BuyDetaile;
import appjxc.model.Obj_SellDetaile;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;

public class JF_view_xstk extends JInternalFrame {//implements javax.swing.event.TableModelListener{//JFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    JScrollPane jScrollPane1 = new JScrollPane();
    JPanel jPanel1 = new JPanel();
    JTable jTable1 = new JTable();
    FlowLayout flowLayout1 = new FlowLayout();
    JButton jBth = new JButton();
    JButton jBexit = new JButton();
    DefaultTableModel tableModel = null;
    DefaultTableModel tableMode2 = null;
    JButton jBquery = new JButton();
    JLabel jLabel1 = new JLabel();
    JTextField jTdjh = new JTextField();
    JSplitPane jSplitPane1 = new JSplitPane();
    JScrollPane jScrollPane2 = new JScrollPane();
    JTable jTable2 = new JTable();
    Obj_SellDetaile selldetaile[] = null;
    public JF_view_xstk() {
        try {
            jbInit();
            buildTable();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public static void main(String[] args) {
        JF_view_xstk jf_view_kcpd = new JF_view_xstk();
    }
    public void buildTable(){
        String[] tname = {"药品编号","药品名称","药品批号","规格","产地","单位","剂型","有效期至"};
        String[] tname1 = {"销售流水号","药品编号","销售价格","销售数量","销售金额","销售日期","退库数量","退库金额","退库日期","经办人"};
        java.util.Vector vname = new java.util.Vector();
        java.util.Vector vname1 = new java.util.Vector();
        for (int i = 0 ; i < tname.length ; i++){
            vname.addElement(tname[i]);
        }
        for (int i = 0 ; i < tname1.length ; i++){
            vname1.addElement(tname1[i]);
        }

        tableModel = new DefaultTableModel(vname,0);
        tableMode2 = new DefaultTableModel(vname1,0);
        jTable1.setModel(tableModel);
        jTable2.setModel(tableMode2);


    }
    private void jbInit() throws Exception {
        this.getContentPane().setLayout(borderLayout1);
        jPanel1.setBorder(BorderFactory.createLineBorder(Color.black));
        jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_LAST_COLUMN);
        jTable1.addMouseListener(new JF_view_xstk_jTable1_mouseAdapter(this));

        jScrollPane1.setVerticalScrollBarPolicy(JScrollPane.
                                                VERTICAL_SCROLLBAR_ALWAYS);
        jBquery.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jBquery.setText("查询");
        jBquery.addActionListener(new JF_view_xstk_jBquery_actionAdapter(this));
        jBexit.addActionListener(new JF_view_xstk_jBexit_actionAdapter(this));
        jBth.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jBth.addActionListener(new JF_view_xstk_jBpd_actionAdapter(this));
        jBexit.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        this.setClosable(true);
        this.setTitle("医药进销存管理系统-[销售退货]");
        jLabel1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jLabel1.setText("销售单据号:");
        jTdjh.setPreferredSize(new Dimension(226, 27));
        jTdjh.setText("");
        jTdjh.addKeyListener(new JF_view_xstk_jTdjh_keyAdapter(this));
        flowLayout1.setHgap(10);
        jBth.setText("退货");
        jPanel1.setLayout(flowLayout1);
        jBexit.setText("退出");
        jSplitPane1.setOrientation(JSplitPane.VERTICAL_SPLIT);
        jPanel1.add(jLabel1);
        jPanel1.add(jTdjh);
        jPanel1.add(jBquery);
        jPanel1.add(jBth);
        jPanel1.add(jBexit);
        this.getContentPane().add(jSplitPane1, java.awt.BorderLayout.CENTER);
        jScrollPane1.getViewport().add(jTable1);
        jSplitPane1.add(jScrollPane1, JSplitPane.TOP);
        jSplitPane1.add(jScrollPane2, JSplitPane.BOTTOM);
        jScrollPane2.getViewport().add(jTable2);
        this.getContentPane().add(jPanel1, java.awt.BorderLayout.NORTH);

        setSize(700,500);
        setVisible(true);
        UIManager.setLookAndFeel("javax.swing.plaf.metal.MetalLookAndFeel");
        SwingUtilities.updateComponentTreeUI(this);
        jSplitPane1.setDividerLocation(110);
    }

    public void jBquery_actionPerformed(ActionEvent e) {
        if (jTdjh.getText().trim().length() <= 0 ){
            JOptionPane.showMessageDialog(null,"销售单据号不允许为空,请输入!!!","系统提示",JOptionPane.ERROR_MESSAGE);
            jTdjh.requestFocus();
            return;
        }
        String[] tname = {"药品编号","药品名称","药品批号","规格","产地","单位","剂型","有效期至"};
        String[] tname1 = {"销售流水号","药品编号","销售价格","销售数量","销售金额","销售日期","退库数量","退库金额","退库日期","经办人"};
        java.util.Vector vname = new java.util.Vector();
        java.util.Vector vname1 = new java.util.Vector();
        for (int i = 0 ; i < tname.length ; i++){
            vname.addElement(tname[i]);
        }
        for (int i = 0 ; i < tname1.length ; i++){
            vname1.addElement(tname1[i]);
        }

        tableModel = new DefaultTableModel(vname,0);
        tableMode2 = new DefaultTableModel(vname1,0);
        jTable1.setModel(tableModel);
        jTable2.setModel(tableMode2);


        String djh = null,queryStr = null;
        djh = jTdjh.getText().trim();
         //用表关联的方式进行数据统计：从两个多(t_selldetaile)对一(t_medicinel)的表中进行组合查询数据( 感觉真酷!!!!)
        queryStr = "FROM Obj_SellDetaile s JOIN s.medicine where s.thsts = 'F' and s.xsdjh = '" + djh + "'";
        java.util.List list = null;
        list = appjxc.dao.AdapterDao.QueryObject(queryStr);
        if (list.size() <= 0 ){
            JOptionPane.showMessageDialog(null,"销售单据号码不存在,请从新输入!!!","系统提示",JOptionPane.ERROR_MESSAGE);
            jTdjh.requestFocus();
            return;
        }
        System.out.println(list.size());
        Object obj[] = null;
        selldetaile = new Obj_SellDetaile[list.size()];

        //jTable1.setModel(tableModel);

        for (int i = 0  ; i < list.size() ; i++){
            obj = (Object[])list.get(i);
            selldetaile[i] = (Obj_SellDetaile)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());
            tableModel.addRow(vdata);

        }
        jTable1.setModel(tableModel);
        jTable1.setRowHeight(20);
    }

    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){