xiaoshouchaxun.java

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

package internalFrame.shangPinXiaoShou;

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.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
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.JOptionPane;
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 model.TabSellDetail;
import model.TabSellMain;
import model.Userlist;

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

import dao.UserDAO;

public class XiaoShouChaXun extends JInternalFrame
		implements ApplicationContextAware {
	private JButton button;
	private JTextField endDate;
	private JTextField startDate;
	private JTable table;
	private JTextField content;
	private JComboBox operation;
	private JComboBox condition;
	private Userlist user;
	private UserDAO dao;
	private ApplicationContext appContext;
	private DefaultTableModel dftm;
	private JCheckBox selectDate;
	
	public void setApplicationContext(ApplicationContext app)
			throws BeansException {
		appContext = app;
		dao = (UserDAO) appContext.getBean("DAOProxyTransactionFactory");
		user = (Userlist) appContext.getBean("loginUser");
	}

	public XiaoShouChaXun() {
		addInternalFrameListener(new InternalFrameAdapter() {
			public void internalFrameActivated(final InternalFrameEvent e) {
				java.sql.Date date=new java.sql.Date(System.currentTimeMillis());
				endDate.setText(date.toString());
				date.setMonth(0);
				date.setDate(1);
				startDate.setText(date.toString());
			}
		});
		setMaximizable(true);
		setIconifiable(true);
		setClosable(true);
		setTitle("销售信息查询");
		getContentPane().setLayout(new GridBagLayout());
		setBounds(100, 100, 609, 375);

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

		condition = new JComboBox();
		condition.setModel(new DefaultComboBoxModel(new String[] {"客户全称", "销售票号"}));
		condition.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_1 = new GridBagConstraints();
		gridBagConstraints_1.gridy = 0;
		gridBagConstraints_1.gridx = 1;
		getContentPane().add(condition, gridBagConstraints_1);

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

		content = new JTextField();
		content.addKeyListener(new KeyAdapter() {
			public void keyReleased(final KeyEvent e) {
				if(e.getKeyCode()==10) {
					button.doClick();
				}
			}
		});
		content.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_3 = new GridBagConstraints();
		gridBagConstraints_3.gridwidth = 2;
		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 = 5;
		getContentPane().add(content, gridBagConstraints_3);

		button = new JButton();
		button.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				boolean selDate = selectDate.isSelected();
				if(content.getText().equals("")) {
					JOptionPane.showMessageDialog(getContentPane(), "请输入查询内容！");
					return;
				}
				if(selDate) {
					if(startDate.getText()==null||startDate.getText().equals("")) {
						JOptionPane.showMessageDialog(getContentPane(), "请输入查询的开始日期！");
						return;
					}
					if(endDate.getText()==null||endDate.getText().equals("")) {
						JOptionPane.showMessageDialog(getContentPane(), "请输入查询的结束日期！");
						return;
					}
				}
				List list;
				String con = condition.getSelectedIndex() == 0
						? "tabSellMain.khname "
						: "tabSellMain.sellId ";
				int oper = operation.getSelectedIndex();
				String opstr = oper == 0 ? "= " : "like ";
				String cont = content.getText();
				list = dao.queryObject("from TabSellDetail where "
						+ con
						+ opstr
						+ (oper == 0 ? "'"+cont+"'" : "'%" + cont + "%'")
						+ (selDate ? " and tabSellMain.xsdate>'" + startDate.getText()
								+ "' and tabSellMain.xsdate<='" + endDate.getText()+" 23:59:59'" : ""));
				Iterator iterator = list.iterator();
				updateTable(iterator);
			}
		});
		final GridBagConstraints gridBagConstraints_4 = new GridBagConstraints();
		gridBagConstraints_4.insets = new Insets(0, 0, 0, 10);
		gridBagConstraints_4.gridy = 0;
		gridBagConstraints_4.gridx = 7;
		getContentPane().add(button, gridBagConstraints_4);
		button.setFont(new Font("", Font.PLAIN, 12));
		button.setText("查询");

		selectDate = new JCheckBox();
		selectDate.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_7 = new GridBagConstraints();
		gridBagConstraints_7.anchor = GridBagConstraints.EAST;
		gridBagConstraints_7.insets = new Insets(0, 10, 0, 0);
		gridBagConstraints_7.gridy = 1;
		gridBagConstraints_7.gridx = 0;
		getContentPane().add(selectDate, 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);

		startDate = 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(startDate, 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();
		endDate.addKeyListener(content.getKeyListeners()[0]);
		final GridBagConstraints gridBagConstraints_11 = new GridBagConstraints();
		gridBagConstraints_11.ipadx = 90;
		gridBagConstraints_11.anchor = GridBagConstraints.WEST;
		gridBagConstraints_11.insets = new Insets(0, 0, 0, 0);
		gridBagConstraints_11.gridy = 1;
		gridBagConstraints_11.gridx = 6;
		getContentPane().add(endDate, gridBagConstraints_11);

		final JButton button_1 = new JButton();
		button_1.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				content.setText("");
				List list=dao.queryObject("from TabSellDetail");
				Iterator iterator=list.iterator();
				updateTable(iterator);
			}
		});
		final GridBagConstraints gridBagConstraints_5 = new GridBagConstraints();
		gridBagConstraints_5.insets = new Insets(0, 0, 0, 10);
		gridBagConstraints_5.gridy = 1;
		gridBagConstraints_5.gridx = 7;
		getContentPane().add(button_1, gridBagConstraints_5);
		button_1.setFont(new Font("", Font.PLAIN, 12));
		button_1.setText("显示全部数据");

		final JScrollPane scrollPane = new JScrollPane();
		final GridBagConstraints gridBagConstraints_6 = new GridBagConstraints();
		gridBagConstraints_6.weighty = 1.0;
		gridBagConstraints_6.anchor = GridBagConstraints.NORTH;
		gridBagConstraints_6.insets = new Insets(0, 10, 5, 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");
		dftm = (DefaultTableModel)table.getModel();
		String[] tableHeads = new String[]{"销售票号", "商品编号", "商品名称", "规格", "单价",
				"数量", "金额", "客户全称", "销售日期", "操作员", "经手人", "结算方式"};
		dftm.setColumnIdentifiers(tableHeads);
		scrollPane.setViewportView(table);
	}

	private void updateTable(Iterator iterator) {
		int rowCount=dftm.getRowCount();
		for(int i=0;i<rowCount;i++) {
			dftm.removeRow(0);
		}
		while(iterator.hasNext()) {
			Vector vector=new Vector();
			TabSellDetail sellDetail=(TabSellDetail)iterator.next();
			vector.add(sellDetail.getTabSellMain().getSellId());
			vector.add(sellDetail.getTabSpinfo().getId());
			vector.add(sellDetail.getTabSpinfo().getSpname());
			vector.add(sellDetail.getTabSpinfo().getGg());
			vector.add(sellDetail.getDj());
			vector.add(sellDetail.getSl());
			vector.add(sellDetail.getDj()*sellDetail.getSl());
			vector.add(sellDetail.getTabSellMain().getKhname());
			vector.add(sellDetail.getTabSellMain().getXsdate());
			vector.add(sellDetail.getTabSellMain().getCzy());
			vector.add(sellDetail.getTabSellMain().getJsr());
			vector.add(sellDetail.getTabSellMain().getJsfs());
			dftm.addRow(vector);
		}
	}
}