caigouchaxun.java

企业进销存管理 包括了基本的企业管理的基本功能

package internalFrame.caiGouGuanLi;

import java.awt.Font;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;

import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.event.InternalFrameAdapter;
import javax.swing.event.InternalFrameEvent;
import javax.swing.table.DefaultTableModel;

import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;

import dao.UserDAO;

import model.TabCgdan;

public class CaiGouChaXun extends JInternalFrame
		implements
			ApplicationContextAware {
	private JTextField endDate;

	private JTextField beginDate;

	private JTable table;

	private JTextField conditionContent;

	private JComboBox conditionOperation;

	private JComboBox conditionName;
	private ApplicationContext appContext;
	private UserDAO dao;

	public void setApplicationContext(ApplicationContext app)
			throws BeansException {
		appContext = app;
		dao = (UserDAO) appContext.getBean("DAOProxyTransactionFactory");
	}
	public CaiGouChaXun() {
		addInternalFrameListener(new InternalFrameAdapter() {
			public void internalFrameActivated(final InternalFrameEvent e) {
				Date date = new Date();
				String year = (date.getYear() + 1900) + "";
				String month = "-" + (date.getMonth() + 1);
				String day = "-" + (date.getDate());
				beginDate.setText(year + "-01-01");
				endDate.setText(year + month + day);
			}
		});
		setMaximizable(true);
		setIconifiable(true);
		setClosable(true);
		setTitle("采购查询");
		getContentPane().setLayout(new GridBagLayout());
		setBounds(100, 100, 609, 375);

		final JScrollPane scrollPane = new JScrollPane();
		scrollPane.setAutoscrolls(true);
		final GridBagConstraints gridBagConstraints_6 = new GridBagConstraints();
		gridBagConstraints_6.weighty = 1.0;
		gridBagConstraints_6.anchor = GridBagConstraints.NORTH;
		gridBagConstraints_6.insets = new Insets(0, 10, 0, 10);
		gridBagConstraints_6.fill = GridBagConstraints.BOTH;
		gridBagConstraints_6.gridwidth = 9;
		gridBagConstraints_6.gridy = 2;
		gridBagConstraints_6.gridx = 0;
		getContentPane().add(scrollPane, gridBagConstraints_6);

		table = new JTable();
		table.setEnabled(false);
		table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
		table.setShowGrid(true);
		table.putClientProperty("Quaqua.Table.style", "striped");
		final DefaultTableModel dftm = (DefaultTableModel) table.getModel();
		String[] tableHeads = new String[]{"采购单号", "商品名称", "厂商", "规格", "包装",
				"单位", "数量", "单价", "金额", "采购日期", "备注"};
		dftm.setColumnIdentifiers(tableHeads);
		scrollPane.setViewportView(table);

		final JLabel label = new JLabel();
		label.setFont(new Font("", Font.PLAIN, 14));
		label.setText(" 选择查询条件：");
		final GridBagConstraints gridBagConstraints = new GridBagConstraints();
		gridBagConstraints.gridy = 0;
		gridBagConstraints.gridx = 0;
		getContentPane().add(label, gridBagConstraints);

		conditionName = new JComboBox();
		conditionName.setModel(new DefaultComboBoxModel(new String[]{"商品名称"}));
		conditionName.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_1 = new GridBagConstraints();
		gridBagConstraints_1.gridy = 0;
		gridBagConstraints_1.gridx = 1;
		getContentPane().add(conditionName, gridBagConstraints_1);

		conditionOperation = new JComboBox();
		conditionOperation.setModel(new DefaultComboBoxModel(new String[]{"等于",
				"包含"}));
		conditionOperation.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_2 = new GridBagConstraints();
		gridBagConstraints_2.gridy = 0;
		gridBagConstraints_2.gridx = 4;
		getContentPane().add(conditionOperation, gridBagConstraints_2);

		conditionContent = new JTextField();
		conditionContent.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_3 = new GridBagConstraints();
		gridBagConstraints_3.ipadx = 105;
		gridBagConstraints_3.insets = new Insets(0, 10, 0, 10);
		gridBagConstraints_3.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_3.weightx = 1.0;
		gridBagConstraints_3.gridy = 0;
		gridBagConstraints_3.gridx = 6;
		getContentPane().add(conditionContent, gridBagConstraints_3);

		final JCheckBox setupQueryDate = new JCheckBox();
		setupQueryDate.setFont(new Font("", Font.PLAIN, 14));
		setupQueryDate.setText("指定查询日期");
		final GridBagConstraints gridBagConstraints_7 = new GridBagConstraints();
		gridBagConstraints_7.gridy = 1;
		gridBagConstraints_7.gridx = 0;
		getContentPane().add(setupQueryDate, gridBagConstraints_7);

		final JLabel label_1 = new JLabel();
		label_1.setFont(new Font("", Font.PLAIN, 14));
		label_1.setText("从");
		final GridBagConstraints gridBagConstraints_8 = new GridBagConstraints();
		gridBagConstraints_8.anchor = GridBagConstraints.EAST;
		gridBagConstraints_8.gridy = 1;
		gridBagConstraints_8.gridx = 1;
		getContentPane().add(label_1, gridBagConstraints_8);

		beginDate = new JTextField();
		final GridBagConstraints gridBagConstraints_9 = new GridBagConstraints();
		gridBagConstraints_9.ipadx = 70;
		gridBagConstraints_9.insets = new Insets(0, 0, 0, 0);
		gridBagConstraints_9.gridwidth = 3;
		gridBagConstraints_9.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_9.gridy = 1;
		gridBagConstraints_9.gridx = 2;
		getContentPane().add(beginDate, gridBagConstraints_9);

		final JLabel label_2 = new JLabel();
		label_2.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_10 = new GridBagConstraints();
		gridBagConstraints_10.gridy = 1;
		gridBagConstraints_10.gridx = 5;
		getContentPane().add(label_2, gridBagConstraints_10);
		label_2.setText("到");

		endDate = new JTextField();
		final GridBagConstraints gridBagConstraints_11 = new GridBagConstraints();
		gridBagConstraints_11.anchor = GridBagConstraints.WEST;
		gridBagConstraints_11.insets = new Insets(0, 0, 0, 110);
		gridBagConstraints_11.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_11.gridy = 1;
		gridBagConstraints_11.gridx = 6;
		getContentPane().add(endDate, gridBagConstraints_11);

		final JButton showAllButton = new JButton();
		showAllButton.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				conditionContent.setText("");
				List list = dao.queryObject("from TabCgdan");
				updateTable(list, dftm);
			}
		});
		final GridBagConstraints gridBagConstraints_5 = new GridBagConstraints();
		gridBagConstraints_5.gridy = 1;
		gridBagConstraints_5.gridx = 7;
		getContentPane().add(showAllButton, gridBagConstraints_5);
		showAllButton.setFont(new Font("", Font.PLAIN, 12));
		showAllButton.setText("显示全部数据");

		final JButton queryButton = new JButton();
		queryButton.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				String conOperation, content, beginTime, endTime;
				List list;
				conOperation = conditionOperation.getSelectedItem().toString();
				content = conditionContent.getText().trim();
				beginTime = beginDate.getText().trim();
				endTime = getMaxDate(endDate.getText());
				if (setupQueryDate.isSelected()) {
					System.out.println(conOperation);
					if (conOperation.equals("等于")) {
						String sql = "from TabCgdan where id.spname='"
								+ content + "' and id.cgdate>'" + beginTime
								+ "' and id.cgdate<'" + endTime + "'";
						list = dao.queryObject(sql);
						System.out.println(sql);
						System.out.println(list.size());
					} else
						list = dao
								.queryObject("from TabCgdan where id.spname like '%"
										+ content
										+ "%' and id.cgdate>'"
										+ beginTime
										+ "' and id.cgdate<'"
										+ endTime + "'");
				} else {
					if (conOperation.equals("等于"))
						list = dao
								.queryObject("from TabCgdan where id.spname='"
										+ content + "'");
					else
						list = dao
								.queryObject("from TabCgdan where id.spname like '%"
										+ content + "%'");
				}
				updateTable(list, dftm);
			}
		});
		final GridBagConstraints gridBagConstraints_4 = new GridBagConstraints();
		gridBagConstraints_4.gridy = 0;
		gridBagConstraints_4.gridx = 7;
		getContentPane().add(queryButton, gridBagConstraints_4);
		queryButton.setFont(new Font("", Font.PLAIN, 12));
		queryButton.setText("查询");
	}

	private void updateTable(List list, final DefaultTableModel dftm) {
		int num = dftm.getRowCount();
		for (int i = 0; i < num; i++)
			dftm.removeRow(0);
		if (list == null)
			return;
		Iterator iterator = list.iterator();
		TabCgdan cgInfo;
		while (iterator.hasNext()) {
			cgInfo = (TabCgdan) iterator.next();
			Vector rowData = new Vector();
			rowData.add(cgInfo.getId().trim());
			rowData.add(cgInfo.getSpname().trim());
			rowData.add(cgInfo.getCs().trim());
			rowData.add(cgInfo.getGg().trim());
			rowData.add(cgInfo.getBz().trim());
			rowData.add(cgInfo.getDw().trim());
			rowData.add(cgInfo.getSl().trim());
			rowData.add(cgInfo.getDj().trim());
			rowData.add(cgInfo.getJe().trim());
			rowData.add(cgInfo.getCgdate().toLocaleString());
			rowData.add(cgInfo.getMemo().trim());
			dftm.addRow(rowData);
		}
	}

	private String getMaxDate(String str) {
		str = str.trim();
		str = str.replaceAll("-", "/");
		Date d = new Date(str);
		d.setDate(d.getDate() + 1);
		return d.toLocaleString();
	}
}