JavaScript

开发平台：
Java

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

						