jf_view_kcpd.java

该代码是一个关于医药进销存管理系统的源代码

package com.lzw.view;

import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.FlowLayout;
import javax.swing.BorderFactory;
import javax.swing.JTable;
import java.awt.Color;
import javax.swing.table.DefaultTableModel;

import com.lzw.model.*;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
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_OFF);
		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 = com.lzw.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 = com.lzw.dao.AdapterDao.QueryObject(queryStr);
		 * iterator = list.iterator(); queryStr = "from Obj_Stock"; list1 =
		 * com.lzw.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) {
			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 = com.lzw.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);
			com.lzw.dao.AdapterDao.InsertStock(stock);
		}
		JOptionPane.showMessageDialog(null, "盘点数据存盘成功!!!", "系统提示",
				JOptionPane.INFORMATION_MESSAGE);
	}
}

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