guestqueryframe.java

一个KTV管理系统

package view.mainframe.operationqueryframe;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.util.Iterator;
import java.util.Vector;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
import view.mainframe.MainFrame;
import vo.GuestConsumedInfo;
import common.centerwindow.CenterWindow;
import common.checkinputvalue.Check;
import dao.consumeddao.GuestConsumedDao;

//顾客查询主界面
public class GuestQueryFrame implements ActionListener {

	private static GuestQueryFrame instance = null;
	private static JFrame jFrameGuestQuery = null;
	private JPanel jContentPaneGuestQuery = null;
	private JLabel jLabelGuestNameQuery = null;
	private JLabel jLabelRoomNumber = null;
	private JScrollPane jScrollPaneGuestQuery = null;
	private JTable jTableGuestQuery = null;
	private JTextField jTextFieldgetGuestQuery = null;
	private JTextField jTextFieldgetRoomNumber = null;
	private JButton jButtonRoomNumberQuery = null;
	private JButton jButtonFlushGuestQuery = null;
	private JLabel startLabel = null;
	private JTextField startTextField = null;
	private JLabel endLabel = null;
	private JTextField endTextField = null;

	public static GuestQueryFrame getInstance() {
		if (instance == null) {
			instance = new GuestQueryFrame();
		}
		instance.jTableGuestQuery = instance.getJTableGuestQuery();
		instance.jFrameGuestQuery.setVisible(true);
		return instance;
	}

	private GuestQueryFrame() {
		getJFrameGuestQuery();
	}

	/**
	 * This method initializes jFrameGuestQuery
	 * 
	 * @return javax.swing.JFrame
	 */
	// 初始化顾客查寻面板
	private JFrame getJFrameGuestQuery() {
		if (jFrameGuestQuery == null) {
			jFrameGuestQuery = new JFrame();
			jFrameGuestQuery.setSize(new java.awt.Dimension(476, 320));
			jFrameGuestQuery.setTitle("宾客查询");
			jFrameGuestQuery.setContentPane(getJContentPaneGuestQuery());
			jFrameGuestQuery.setResizable(false);
			new CenterWindow().centerWindow(jFrameGuestQuery);
			jFrameGuestQuery.addWindowListener(new WindowAdapter() {

				public void windowClosing(WindowEvent e) {
					jFrameGuestQuery.setVisible(false);
					// 关闭窗口时，清空可编辑区域
					jTextFieldgetGuestQuery.setText("");
					jTextFieldgetRoomNumber.setText("");
					// 更新主界面的数据
					MainFrame.getInstance().refresh();
				}
			});
		}
		return jFrameGuestQuery;
	}

	/**
	 * This method initializes jContentPaneGuestQuery
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPaneGuestQuery() {
		if (jContentPaneGuestQuery == null) {
			endLabel = new JLabel();
			endLabel.setBounds(new java.awt.Rectangle(183, 85, 20, 20));
			endLabel.setText("到");
			startLabel = new JLabel();
			startLabel.setBounds(new java.awt.Rectangle(15, 85, 65, 20));
			startLabel.setText("结账时间从");
			jLabelRoomNumber = new JLabel();
			jLabelRoomNumber.setBounds(new java.awt.Rectangle(40, 56, 100, 20));
			jLabelRoomNumber.setText("按包间号码查询");
			jLabelGuestNameQuery = new JLabel();
			jLabelGuestNameQuery.setBounds(new java.awt.Rectangle(40, 25, 100,
					20));
			jLabelGuestNameQuery.setText("按宾客姓名查询");
			jContentPaneGuestQuery = new JPanel();
			jContentPaneGuestQuery.setLayout(null);
			jContentPaneGuestQuery.add(jLabelGuestNameQuery, null);
			jContentPaneGuestQuery.add(jLabelRoomNumber, null);
			jContentPaneGuestQuery.add(getJScrollPaneGuestQuery(), null);
			jContentPaneGuestQuery.add(getJTextFieldgetGuestQuery(), null);
			jContentPaneGuestQuery.add(getJTextFieldgetRoomNumber(), null);
			jContentPaneGuestQuery.add(getJButtonRoomNumberQuery(), null);
			jContentPaneGuestQuery.add(getJButtonFlushGuestQuery(), null);
			jContentPaneGuestQuery.add(startLabel, null);
			jContentPaneGuestQuery.add(getStartTextField(), null);
			jContentPaneGuestQuery.add(endLabel, null);
			jContentPaneGuestQuery.add(getEndTextField(), null);
		}
		return jContentPaneGuestQuery;
	}

	/**
	 * This method initializes jScrollPaneGuestQuery
	 * 
	 * @return javax.swing.JScrollPane
	 */
	private JScrollPane getJScrollPaneGuestQuery() {
		if (jScrollPaneGuestQuery == null) {
			jScrollPaneGuestQuery = new JScrollPane();
			jScrollPaneGuestQuery.setBounds(new java.awt.Rectangle(1, 114, 464,
					170));
			jScrollPaneGuestQuery.setViewportView(getJTableGuestQuery());
		}
		return jScrollPaneGuestQuery;
	}

	/**
	 * This method initializes jTableGuestQuery
	 * 
	 * @return javax.swing.JTable
	 */
	private JTable getJTableGuestQuery() {
		if (jTableGuestQuery == null) {
			Object[][] pi = {};
			String[] name = { "消费流水号", "宾客姓名", "包间号", "宾客身份证号", "开房时间", "结账时间",
					"消费时间", "商品消费额", "包间费", "消费类型", "押金", "打折比例", "总费用" };
			DefaultTableModel md = new DefaultTableModel(pi, name);
			jTableGuestQuery = new JTable(md);
			// jTableGuestQuery.setPreferredScrollableViewportSize(new
			// Dimension(15,500));
			jTableGuestQuery.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
		}
		DefaultTableModel model = (DefaultTableModel) jTableGuestQuery
				.getModel();
		int rows = model.getRowCount();
		// 删除表格中目前的数据
		for (int i = rows - 1; i >= 0; i--) {
			model.removeRow(i);
		}
		return jTableGuestQuery;
	}

	/**
	 * This method initializes jTextFieldgetGuestQuery
	 * 
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextFieldgetGuestQuery() {
		if (jTextFieldgetGuestQuery == null) {
			jTextFieldgetGuestQuery = new JTextField();
			jTextFieldgetGuestQuery.setBounds(new java.awt.Rectangle(170, 25,
					100, 20));
		}
		return jTextFieldgetGuestQuery;
	}

	/**
	 * This method initializes jTextFieldgetRoomNumber
	 * 
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextFieldgetRoomNumber() {
		if (jTextFieldgetRoomNumber == null) {
			jTextFieldgetRoomNumber = new JTextField();
			jTextFieldgetRoomNumber.setBounds(new java.awt.Rectangle(170, 56,
					100, 20));
		}
		return jTextFieldgetRoomNumber;
	}

	/**
	 * This method initializes jButtonRoomNumberQuery
	 * 
	 * @return javax.swing.JButton
	 */
	private JButton getJButtonRoomNumberQuery() {
		if (jButtonRoomNumberQuery == null) {
			jButtonRoomNumberQuery = new JButton();
			jButtonRoomNumberQuery.setBounds(new java.awt.Rectangle(300, 25,
					60, 20));
			jButtonRoomNumberQuery.setText("查询");
			jButtonRoomNumberQuery.addActionListener(this);
		}
		return jButtonRoomNumberQuery;
	}

	/**
	 * This method initializes jButtonFlushGuestQuery
	 * 
	 * @return javax.swing.JButton
	 */
	private JButton getJButtonFlushGuestQuery() {
		if (jButtonFlushGuestQuery == null) {
			jButtonFlushGuestQuery = new JButton();
			jButtonFlushGuestQuery.setBounds(new java.awt.Rectangle(300, 70,
					60, 20));
			jButtonFlushGuestQuery.setText("刷新");
			jButtonFlushGuestQuery.addActionListener(this);
		}
		return jButtonFlushGuestQuery;
	}

	/**
	 * This method initializes startTextField
	 * 
	 * @return javax.swing.JTextField
	 */
	private JTextField getStartTextField() {
		if (startTextField == null) {
			startTextField = new JTextField();
			startTextField.setBounds(new java.awt.Rectangle(87, 85, 90, 20));
		}
		return startTextField;
	}

	/**
	 * This method initializes endTextField
	 * 
	 * @return javax.swing.JTextField
	 */
	private JTextField getEndTextField() {
		if (endTextField == null) {
			endTextField = new JTextField();
			endTextField.setBounds(new java.awt.Rectangle(208, 85, 90, 20));
		}
		return endTextField;
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		GuestQueryFrame s = new GuestQueryFrame();
		s.getInstance();
	}

	public void actionPerformed(ActionEvent e) {
		JButton jb = (JButton) e.getSource();
		DefaultTableModel model = (DefaultTableModel) jTableGuestQuery
				.getModel();
		if (jb.getText().equals("查询")) {
			if (checkinput()) {
				String value2 = jTextFieldgetGuestQuery.getText().trim();
				if (value2.equals("")) {
					value2 = "0";
				}
				String value1 = jTextFieldgetRoomNumber.getText().trim();
				if (value1.equals("")) {
					value1 = "0";
				}
				String start = startTextField.getText().trim();
				if (start.equals("")) {
					start = "0";
				}
				String end = endTextField.getText().trim();
				if (end.equals("")) {
					end = "0";
				}
				int rows = model.getRowCount();
				// 删除表格中目前的数据
				for (int i = rows - 1; i >= 0; i--) {
					model.removeRow(i);
				}
				Vector v = getConsumed(value1, value2, start, end);
				Iterator iter = v.iterator();
				while (iter.hasNext()) {
					GuestConsumedInfo gci = (GuestConsumedInfo) iter.next();
					Object[] date = { String.valueOf(gci.getConsumedId()),
							gci.getGuestName(), gci.getRoomNumber(),
							String.valueOf(gci.getGuestId()),
							gci.getGuestCheckInTime(),
							gci.getGuestCheckOutTime(), gci.getConsumedTime(),
							String.valueOf(gci.getGoodsConsumedMoney()),
							String.valueOf(gci.getRoomMoney()),
							gci.getConsumedTypeName(),
							String.valueOf(gci.getDeposit()),
							String.valueOf(gci.getRebate()),
							String.valueOf(gci.getFee()) };
					model.addRow(date);
				}
			}
		}
		if (jb.getText().equals("刷新")) {
			int rows = model.getRowCount();
			// 删除表格中目前的数据
			for (int i = rows - 1; i >= 0; i--) {
				model.removeRow(i);
			}
			Vector v = getsConsumed();
			Iterator iter = v.iterator();
			while (iter.hasNext()) {
				GuestConsumedInfo gci = (GuestConsumedInfo) iter.next();
				Object[] date = { String.valueOf(gci.getConsumedId()),
						gci.getGuestName(), gci.getRoomNumber(),
						String.valueOf(gci.getGuestId()),
						gci.getGuestCheckInTime(), gci.getGuestCheckOutTime(),
						gci.getConsumedTime(),
						String.valueOf(gci.getGoodsConsumedMoney()),
						String.valueOf(gci.getRoomMoney()),
						gci.getConsumedTypeName(),
						String.valueOf(gci.getDeposit()),
						String.valueOf(gci.getRebate()),
						String.valueOf(gci.getFee()) };
				model.addRow(date);
			}
		}
	}

	private boolean checkinput() {
		Check c = new Check();
		if (c.checkdate(startTextField.getText().trim())
				|| c.checkdate(endTextField.getText().trim())) {
			return true;
		} else {
			JOptionPane.showMessageDialog(null, "请输入正确的查询条件", "提示信息",
					JOptionPane.YES_OPTION);
		}
		return false;
	}

	private Vector getConsumed(String value, String value2, String start,
			String end) {
		return new GuestConsumedDao().getGuestConsumedInfo(value, value2,
				start, end);
	}

	private Vector getsConsumed() {
		return new GuestConsumedDao().getsGuestConsumedInfo();
	}
}