/*
 * 創建日期 2008-4-23
 *
 * TODO 要更改此生成的文件的模板，請轉至
 * 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
package appsm.view;

import java.util.Vector;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.JLabel;
import appsm.util.RetrieveObject;
/**
 * @author Administrator
 *
 * TODO 要更改此生成的類型注釋的模板，請轉至
 * 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
public class Pandian extends JFrame {

	private javax.swing.JPanel jContentPane = null;
	private JTextField jTextField = null;
	private JTextField jTextField1 = null;
	private JButton jButton = null;
	private JLabel jLabel = null;
	private JLabel jLabel1 = null;
	/**
	 * This is the default constructor
	 */
	public Pandian() {
		super();
		initialize();
	}
	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(412, 167);
		this.setContentPane(getJContentPane());
		this.setTitle("盤點");
	}
	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private javax.swing.JPanel getJContentPane() {
		if(jContentPane == null) {
			jLabel1 = new JLabel();
			jLabel = new JLabel();
			jContentPane = new javax.swing.JPanel();
			jContentPane.setLayout(null);
			jLabel.setBounds(47, 15, 221, 21);  // Generated
			jLabel.setText("請輸入盤點日期：格式如2008-05-01");  // Generated
			jLabel.setFont(new java.awt.Font("Dialog", java.awt.Font.PLAIN, 12));  // Generated
			jLabel1.setBounds(143, 46, 40, 27);  // Generated
			jLabel1.setText("至");  // Generated
			jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);  // Generated
			jContentPane.add(getJTextField(), null);  // Generated
			jContentPane.add(getJTextField1(), null);  // Generated
			jContentPane.add(getJButton(), null);  // Generated
			jContentPane.add(jLabel, null);  // Generated
			jContentPane.add(jLabel1, null);  // Generated
		}
		return jContentPane;
	}
	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */    
	private JTextField getJTextField() {
		if (jTextField == null) {
			try {
				jTextField = new JTextField();
				jTextField.setBounds(48, 47, 90, 26);  // Generated
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jTextField;
	}
	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */    
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			try {
				jTextField1 = new JTextField();
				jTextField1.setBounds(187, 47, 89, 26);  // Generated
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jTextField1;
	}
	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */    
	private JButton getJButton() {
		if (jButton == null) {
			try {
				jButton = new JButton();
				jButton.setBounds(301, 48, 66, 25);  // Generated
				jButton.setText("盤點");  // Generated
				jButton.setFont(new java.awt.Font("Dialog", java.awt.Font.PLAIN, 14));  // Generated
				jButton.addActionListener(new java.awt.event.ActionListener() { 
					public void actionPerformed(java.awt.event.ActionEvent e) {  
						String jt1=jTextField.getText().trim();
						String jt2=jTextField1.getText().trim();
						
						String sql="select  sum(goodsPrice*goodsNumber) from tb_sellHistory where cast(left(goodstime,charindex(' ' , goodstime)-1) as datetime) between '"+jt1+"' and '"+jt2+"'";
						Vector vdata=null;
						RetrieveObject ro=new RetrieveObject();
						vdata=ro.getObjectRow(sql);
						JOptionPane.showMessageDialog(null,"金額合計："+vdata.get(0)+"");
						
						
						
					}
				});
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jButton;
	}
   }  //  @jve:decl-index=0:visual-constraint="10,10"