开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > JavaScript > 查看源码
JF_view_kcpd.java
资源名称：Appjxc.rar　[点击查看]
上传用户：whbcdz
上传日期：2008-08-04
资源大小：7683k
文件大小：11k
源码类别：

JavaScript

开发平台：

Java

JF_view_kcpd.java：源码内容
  1. package appjxc.view;
  3. import javax.swing.*;
  4. import java.awt.BorderLayout;
  5. import java.awt.FlowLayout;
  6. import javax.swing.BorderFactory;
  7. import java.awt.Color;
  8. import javax.swing.table.DefaultTableModel;
  9. import java.awt.event.ActionEvent;
  10. import java.awt.event.ActionListener;
  11. import appjxc.model.Obj_Stock;
  12. import appjxc.model.obj_medicine;
  13. import java.awt.Font;
  14. import java.util.Calendar;
  15. import java.util.Locale;
  17. public class JF_view_kcpd extends JInternalFrame{//JFrame {
  18.     BorderLayout borderLayout1 = new BorderLayout();
  19.     JScrollPane jScrollPane1 = new JScrollPane();
  20.     JPanel jPanel1 = new JPanel();
  21.     JTable jTable1 = new JTable();
  22.     FlowLayout flowLayout1 = new FlowLayout();
  23.     JButton jBpd = new JButton();
  24.     JButton jBsave = new JButton();
  25.     JButton jBexit = new JButton();
  26.     DefaultTableModel tableModel = null;
  27.     JButton jBquery = new JButton();
  29.     java.util.List liststock = null;
  30.     public JF_view_kcpd() {
  31.         try {
  32.             jbInit();
  33.             buildTable();
  34.         } catch (Exception ex) {
  35.             ex.printStackTrace();
  36.         }
  37.     }
  40.     public void buildTable(){
  41.         String[] tname = {"药品编号","药品名称","药品批号","规格","产地","单位","剂型","有效期至","库存数量","盘点数量"};
  42.         java.util.Vector vname = new java.util.Vector();
  43.         for (int i = 0 ; i < tname.length ; i++){
  44.             vname.addElement(tname[i]);
  45.         }
  46.         tableModel = new DefaultTableModel(vname,0);
  47.         jTable1.setModel(tableModel);
  49.     }
  50.     private void jbInit() throws Exception {
  51.         this.getContentPane().setLayout(borderLayout1);
  52.         jPanel1.setBorder(BorderFactory.createLineBorder(Color.black));
  53.         jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_LAST_COLUMN);
  54.         jScrollPane1.setVerticalScrollBarPolicy(JScrollPane.
  55.                                                 VERTICAL_SCROLLBAR_ALWAYS);
  56.         jBquery.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  57.         jBquery.setText("查询库存");
  58.         jBquery.addActionListener(new JF_view_kcpd_jBquery_actionAdapter(this));
  59.         jBexit.addActionListener(new JF_view_kcpd_jBexit_actionAdapter(this));
  60.         jBpd.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  61.         jBpd.addActionListener(new JF_view_kcpd_jBpd_actionAdapter(this));
  62.         jBsave.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  63.         jBexit.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  64.         this.setClosable(true);
  65.         this.setTitle("医药进销存管理系统-[库存盘点]");
  66.         this.getContentPane().add(jScrollPane1, java.awt.BorderLayout.CENTER);
  67.         jBpd.setText("盘点");
  68.         jPanel1.setLayout(flowLayout1);
  69.         this.getContentPane().add(jPanel1, java.awt.BorderLayout.NORTH);
  70.         jBsave.setVisible(false);
  71.         jBsave.setText("导出Excel");
  72.         jBexit.setText("退出");
  73.         jPanel1.add(jBquery);
  74.         jPanel1.add(jBpd);
  75.         flowLayout1.setAlignment(FlowLayout.RIGHT);
  76.         jPanel1.add(jBsave);
  77.         jPanel1.add(jBexit);
  78.         jScrollPane1.getViewport().add(jTable1);
  79.         setSize(700,500);
  80.         setVisible(true);
  81.        //UIManager.setLookAndFeel("javax.swing.plaf.metal.MetalLookAndFeel");
  82.         //SwingUtilities.updateComponentTreeUI(this);
  83.     }
  85.     public void jBquery_actionPerformed(ActionEvent e) {
  86.         if (jTable1.getRowCount() > 0 ) return;
  87.         String queryStr = null;
  88.         //queryStr = "SELECT m.ypbh, m.ypmc, m.ph, m.gg, m.cd, m.dw, m.jx, m.yxq, s.rksl, s.pdsl " +
  89.          //             "FROM Obj_Stock s , obj_medicine m where s.ypbh = m.ypbh";
  91.          //用表关联的方式进行数据统计：从两个一一对应的表中进行组合查询数据( 感觉真酷!!!!)
  92.         queryStr = "FROM Obj_Stock s JOIN s.objmedicine where kcsl > 0";
  93.         java.util.List list = null;
  94.         list = appjxc.dao.AdapterDao.QueryObject(queryStr);
  95.         Object obj[] = null;
  96.         liststock = list;
  97.         for (int i = 0  ; i < list.size() ; i++){
  98.             obj = (Object[])list.get(i);
  99.             Obj_Stock stock = (Obj_Stock)obj[0];//获得关联中的对象
  100.             obj_medicine objmed = (obj_medicine)obj[1];
  101.             java.util.Vector vdata = new java.util.Vector();
  103.             vdata.addElement(objmed.getYpbh());
  104.             vdata.addElement(objmed.getYpmc());
  105.             vdata.addElement(objmed.getPh());
  106.             vdata.addElement(objmed.getGg());
  107.             vdata.addElement(objmed.getCd());
  108.             vdata.addElement(objmed.getDw());
  109.             vdata.addElement(objmed.getJx());
  110.             vdata.addElement(objmed.getYxq());
  111.             vdata.addElement(String.valueOf(stock.getKcsl()));
  113.             tableModel.addRow(vdata);
  114. //            jTable1.setValueAt(String.valueOf(stock.getKcsl()),i,8);
  115. //            jTable1.setValueAt("0",i,9);
  116. //            System.out.println("objmed.getypmc() = " + objmed.getYpmc());
  117.   //          System.out.println("stock.getkcsl() = " + stock.getKcsl());
  118.         }
  119.         jTable1.setRowHeight(20);
  120.         /*java.util.List list = null;
  121.         java.util.List list1 = null;
  122.         java.util.Iterator iterator = null;
  123.         java.util.Iterator iterator1 = null;
  124.         if (jTable1.getRowCount() > 0 ) {
  125.             return;
  126.         }
  127.         queryStr = "from obj_medicine";
  128.         list = appjxc.dao.AdapterDao.QueryObject(queryStr);
  129.         iterator = list.iterator();
  130.         queryStr = "from Obj_Stock";
  131.         list1 = appjxc.dao.AdapterDao.QueryObject(queryStr);
  132.         iterator1 = list1.iterator();
  134.         int i = 0;
  135.         while(iterator.hasNext()){
  136.             obj_medicine objmed = (obj_medicine)iterator.next();
  137.             Obj_Stock stock = (Obj_Stock)iterator1.next();
  138.             java.util.Vector vdata = new java.util.Vector();
  140.             vdata.addElement(objmed.getYpbh());
  141.             vdata.addElement(objmed.getYpmc());
  142.             vdata.addElement(objmed.getPh());
  143.             vdata.addElement(objmed.getGg());
  144.             vdata.addElement(objmed.getCd());
  145.             vdata.addElement(objmed.getDw());
  146.             vdata.addElement(objmed.getJx());
  147.             vdata.addElement(objmed.getYxq());
  148.             tableModel.addRow(vdata);
  149.             jTable1.setValueAt(String.valueOf(stock.getKcsl()),i,8);
  150.             i++;
  151.         }   */
  154.     }
  156.     public void jBexit_actionPerformed(ActionEvent e) {
  157.         javax.swing.DefaultDesktopManager manger = new DefaultDesktopManager();
  158.         int result = JOptionPane.showOptionDialog(null,"是否真的退出药品药品盘点情况?","系统提示",
  159.                                    JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,
  160.                                    null,new String[]  {"是","否"},"否");
  161.         if (result == JOptionPane.YES_OPTION) {
  162.             try{
  163.                // UIManager.setLookAndFeel("com.sun.java.swing.plaf.motif.MotifLookAndFeel");
  164.                 //SwingUtilities.updateComponentTreeUI(this);
  165.             }catch(Exception ex){
  166.                 ex.printStackTrace();
  167.             }
  168.            manger.closeFrame(this);
  169.         }
  170.     }
  172.     public void jBpd_actionPerformed(ActionEvent e) {
  173.         if (jTable1.getRowCount() <= 0 ) return;
  174.         int result = JOptionPane.showOptionDialog(null,"是否真的存盘药品入库信息情况?","系统提示",
  175.                                    JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,
  176.                                    null,new String[]  {"是","否"},"否");
  177.         if (result == JOptionPane.NO_OPTION) return;
  179.         java.util.Calendar calendar = null;
  180.         Locale loc = new Locale("CN");
  181.         calendar = Calendar.getInstance(loc);
  182.         calendar.setTimeInMillis(System.currentTimeMillis());
  183.         int year = calendar.get(Calendar.YEAR);
  184.         int month = calendar.get(Calendar.MONTH) + 1;
  185.         int day = calendar.get(Calendar.DAY_OF_MONTH);
  186.         String rqStr = year + "-" + month + "-" + day;
  187.         java.sql.Date pdrq = java.sql.Date.valueOf(rqStr);
  189.         for (int i = 0 ; i < jTable1.getRowCount() ; i++){
  190.            // if (jTable1.getValueAt(i,9)==null){
  191.          //       JOptionPane.showMessageDialog(null, "盘点数量不允许为空,请录入!!!", "系统提示",
  192.              //                                 JOptionPane.ERROR_MESSAGE);
  193.        //         return;
  194.             //}
  195.             Object[] obj = (Object[])liststock.get(i);
  196.             Obj_Stock stock = null;
  197.             String ypbh = null;
  198.             String sqlStr = null;
  199.             ypbh = jTable1.getValueAt(i,0).toString();
  200.             sqlStr = " from Obj_Stock where ypbh = '" + ypbh + "'";
  201.             java.util.List list = null;
  202.             list = appjxc.dao.AdapterDao.QueryObject(sqlStr);
  203.             stock = (Obj_Stock)list.get(0);
  205.             int kcsl,pdsl;
  206.             try{
  207.                 kcsl = Integer.parseInt(String.valueOf(jTable1.getValueAt(i, 8)));
  208.                 pdsl = Integer.parseInt(String.valueOf(jTable1.getValueAt(i, 9)));
  209.             }catch(java.lang.NumberFormatException format){
  210.                 JOptionPane.showMessageDialog(null,"盘点数量非法,请填写!!!n" + format.getMessage(),"系统提示",JOptionPane.ERROR_MESSAGE);
  211.                 return;
  212.             }
  213.             if (pdsl < 0 ){
  215.             }
  216.             /*if (pdsl > kcsl){
  217.                 JOptionPane.showMessageDialog(null,"盘点数量【" + pdsl + "】不能大于库存数量【" + kcsl + "】,请修改！！！","系统提示",JOptionPane.ERROR_MESSAGE);
  218.                 return;
  219.             }*/
  220.             stock.setKcsl(kcsl);
  221.             stock.setPdsl(pdsl);
  222.             stock.setPdrq(pdrq);
  223.             appjxc.dao.AdapterDao.InsertStock(stock);
  224.         }
  225.         JOptionPane.showMessageDialog(null,"盘点数据存盘成功!!!","系统提示",JOptionPane.OK_OPTION);
  226.     }
  227. }
  230. class JF_view_kcpd_jBpd_actionAdapter implements ActionListener {
  231.     private JF_view_kcpd adaptee;
  232.     JF_view_kcpd_jBpd_actionAdapter(JF_view_kcpd adaptee) {
  233.         this.adaptee = adaptee;
  234.     }
  236.     public void actionPerformed(ActionEvent e) {
  237.         adaptee.jBpd_actionPerformed(e);
  238.     }
  239. }
  242. class JF_view_kcpd_jBexit_actionAdapter implements ActionListener {
  243.     private JF_view_kcpd adaptee;
  244.     JF_view_kcpd_jBexit_actionAdapter(JF_view_kcpd adaptee) {
  245.         this.adaptee = adaptee;
  246.     }
  248.     public void actionPerformed(ActionEvent e) {
  249.         adaptee.jBexit_actionPerformed(e);
  250.     }
  251. }
  254. class JF_view_kcpd_jBquery_actionAdapter implements ActionListener {
  255.     private JF_view_kcpd adaptee;
  256.     JF_view_kcpd_jBquery_actionAdapter(JF_view_kcpd adaptee) {
  257.         this.adaptee = adaptee;
  258.     }
  260.     public void actionPerformed(ActionEvent e) {
  261.         adaptee.jBquery_actionPerformed(e);
  262.     }
  263. }