/*
 * 創(chuàng)建日期 2008-3-15
 *
 * TODO 要更改此生成的文件的模板，請轉(zhuǎn)至
 * 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
package appsm.view;

import javax.swing.JFrame;
import javax.swing.JMenuBar;
import javax.swing.JMenu;
import javax.swing.JMenuItem;
import javax.swing.JToolBar;
import javax.swing.JButton;
import javax.swing.ImageIcon;
import java.awt.BorderLayout;
import javax.swing.JLabel;
import javax.swing.JPanel;
import appsm.util.CommonaJdbc;
import java.awt.CardLayout;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
//import java.io.FileInputStream;

/**
 * @author Administrator
 *
 * TODO 要更改此生成的類型注釋的模板，請轉(zhuǎn)至
 * 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
public class AppMain extends JFrame {

	private javax.swing.JPanel jContentPane = null;
	private JMenuBar jJMenuBar = null;
	private JMenu jMenu = null;
	private JMenu jMenu1 = null;
	private JMenu jMenu2 = null;
	private JMenu jMenu3 = null;
	private JMenu jMenu4 = null;
	private JMenuItem jMenuItem = null;
	private JMenuItem jMenuItem1 = null;
	private JMenuItem jMenuItem2 = null;
	private JMenuItem jMenuItem3 = null;
	private JMenuItem jMenuItem4 = null;
	private JMenuItem jMenuItem5 = null;
	private JMenuItem jMenuItem6 = null;
	private JMenuItem jMenuItem7 = null;
	private JMenuItem jMenuItem8 = null;
	private JMenuItem jMenuItem9 = null;
	private JToolBar jToolBar = null;
	private JButton jButton = null;
	private JButton jButton1 = null;
	private JButton jButton2 = null;
	private JButton jButton3 = null;
	private JPanel jPanel = null;
	CardLayout myc=new CardLayout();
	private JLabel jLabel = null;
    private HSSFWorkbook workbook ;
    static boolean bl=true;
    static boolean gy=true;
	/**
	 * This is the default constructor
	 * @throws IOException
	 * @throws FileNotFoundException
	 * @throws Exception
	 */
	public AppMain() {
		super();
		initialize();
		try {
			DataToExcelSheetAt();
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(Denglu.qx=="銷售員")
		{
		jButton.setEnabled(false);
		jButton1.setEnabled(false);
		jMenu.setEnabled(false);
		jMenu1.setEnabled(false);
		jMenuItem5.setEnabled(false);
		jMenuItem6.setEnabled(false);
		jMenuItem7.setEnabled(false);
		jMenu3.setEnabled(false);
		jMenu4.setEnabled(false);
		}
		
	}
	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setBounds(0, 0, 751, 595);  // Generated
		this.setResizable(false);  // Generated
		this.setEnabled(true);  // Generated
		this.setJMenuBar(getJJMenuBar());
		this.setContentPane(getJContentPane());
		this.setTitle("系統(tǒng)主界面");
		this.addWindowListener(new java.awt.event.WindowAdapter() { 
			public void windowClosing(java.awt.event.WindowEvent e) {    
				try {
					CommonaJdbc.connection.close();
				} catch (SQLException e1) {
					// TODO 自動生成 catch 塊
					e1.printStackTrace();
				}
				System.exit(0);
			}
		});
	}
	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private javax.swing.JPanel getJContentPane() {
		if(jContentPane == null) {
			jContentPane = new javax.swing.JPanel();
			jContentPane.setLayout(new BorderLayout());
			jContentPane.setPreferredSize(new java.awt.Dimension(80,80));
			jContentPane.add(getJToolBar(), java.awt.BorderLayout.NORTH);
			jContentPane.add(getJPanel(), java.awt.BorderLayout.CENTER);  // Generated
		}	
		return jContentPane;
	}
	/**
	 * This method initializes jJMenuBar	
	 * 	
	 * @return javax.swing.JMenuBar	
	 */    
	private JMenuBar getJJMenuBar() {
		if (jJMenuBar == null) {
			jJMenuBar = new JMenuBar();
			jJMenuBar.setComponentOrientation(java.awt.ComponentOrientation.LEFT_TO_RIGHT);
			jJMenuBar.add(getJMenu());
			jJMenuBar.add(getJMenu1());
			jJMenuBar.add(getJMenu2());
			jJMenuBar.add(getJMenu3());
			jJMenuBar.add(getJMenu4());
		}
		return jJMenuBar;
	}
	/**
	 * This method initializes jMenu	
	 * 	
	 * @return javax.swing.JMenu	
	 */    
	private JMenu getJMenu() {
		if (jMenu == null) {
			jMenu = new JMenu();
			jMenu.setText("系統(tǒng)管理");
			jMenu.setFont(new java.awt.Font("Dialog", java.awt.Font.PLAIN, 14));

			jMenu.add(getJMenuItem());
			jMenu.addSeparator();
			jMenu.add(getJMenuItem1());
		}
		return jMenu;
	}
	/**
	 * This method initializes jMenu1	
	 * 	
	 * @return javax.swing.JMenu	
	 */    
	private JMenu getJMenu1() {
		if (jMenu1 == null) {
			jMenu1 = new JMenu();
			jMenu1.setText("商品管理");
			jMenu1.setFont(new java.awt.Font("Dialog", java.awt.Font.PLAIN, 14));
			jMenu1.add(getJMenuItem2());
			jMenu1.add(getJMenuItem3());
		}
		return jMenu1;
	}
	/**
	 * This method initializes jMenu2	
	 * 	
	 * @return javax.swing.JMenu	
	 */    
	private JMenu getJMenu2() {
		if (jMenu2 == null) {
			jMenu2 = new JMenu();
			jMenu2.setText("銷售管理");
			jMenu2.setFont(new java.awt.Font("Dialog", java.awt.Font.PLAIN, 14));
			jMenu2.add(getJMenuItem4());
			jMenu2.add(getJMenuItem5());
			jMenu2.add(getJMenuItem6());
			jMenu2.add(getJMenuItem7());
		}
		return jMenu2;
	}
	/**
	 * This method initializes jMenu3	
	 * 	
	 * @return javax.swing.JMenu	
	 */    
	private JMenu getJMenu3() {
		if (jMenu3 == null) {
			jMenu3 = new JMenu();
			jMenu3.setText("人事管理");
			jMenu3.setFont(new java.awt.Font("Dialog", java.awt.Font.PLAIN, 14));
			jMenu3.add(getJMenuItem8());
		}
		return jMenu3;
	}
	/**
	 * This method initializes jMenu4	
	 * 	
	 * @return javax.swing.JMenu	
	 */    
	private JMenu getJMenu4() {
		if (jMenu4 == null) {
			jMenu4 = new JMenu();
			jMenu4.setText("幫助文檔");
			jMenu4.setFont(new java.awt.Font("Dialog", java.awt.Font.PLAIN, 14));
			jMenu4.add(getJMenuItem9());
		}
		return jMenu4;
	}
	/**
	 * This method initializes jMenuItem	
	 * 	
	 * @return javax.swing.JMenuItem	
	 */    
	private JMenuItem getJMenuItem() {
		if (jMenuItem == null) {
			jMenuItem = new JMenuItem();
			jMenuItem.setText("系統(tǒng)備份與還原 H");
			jMenuItem.setMnemonic('H');//Alt+H 
		
               
			jMenuItem.setActionCommand("");  // Generated
			jMenuItem.addActionListener(new java.awt.event.ActionListener() { 
				public void actionPerformed(java.awt.event.ActionEvent e) {   
					if(bl)
					{jPanel.add("zero",jLabel);
					 myc.show(jPanel,"zero");
					Beifen bf=new Beifen();
					bf.setVisible(true);
					bf.setBounds(300,200,500,400);
					}
				
				}
			});
		}
		return jMenuItem;
	}
	/**
	 * This method initializes jMenuItem1	
	 * 	
	 * @return javax.swing.JMenuItem	
	 */    
	private JMenuItem getJMenuItem1() {
		if (jMenuItem1 == null) {
			jMenuItem1 = new JMenuItem();
			jMenuItem1.setText("退出系統(tǒng)");
			jMenuItem1.addActionListener(new java.awt.event.ActionListener() { 
				public void actionPerformed(java.awt.event.ActionEvent e) {    
					try {
						CommonaJdbc.connection.close();
					} catch (SQLException e1){
						// TODO 自動生成 catch 塊
						e1.printStackTrace();
					}
					System.exit(0);
					
				}
			});
		}
		return jMenuItem1;
	}
	/**
	 * This method initializes jMenuItem2	
	 * 	
	 * @return javax.swing.JMenuItem	
	 */    
	private JMenuItem getJMenuItem2() {
		if (jMenuItem2 == null) {
			jMenuItem2 = new JMenuItem();
			jMenuItem2.setText("商品管理");
			jMenuItem2.addActionListener(new java.awt.event.ActionListener() { 
				public void actionPerformed(java.awt.event.ActionEvent e) {    
					ShangpinGL shangpin= new ShangpinGL();
					
					jPanel.add("one",shangpin);
					 myc.show(jPanel,"one");
		
					 
				
				}
			});
		}
		return jMenuItem2;
	}
	/**
	 * This method initializes jMenuItem3	
	 * 	
	 * @return javax.swing.JMenuItem	
	 */    
	private JMenuItem getJMenuItem3() {
		if (jMenuItem3 == null) {
			jMenuItem3 = new JMenuItem();
			jMenuItem3.setText("商品報表");
			jMenuItem3.addActionListener(new java.awt.event.ActionListener() { 
				public void actionPerformed(java.awt.event.ActionEvent e) {    
				
					String sql="select * from tb_Shangpin";
					
					 try{
				        Connection con=CommonaJdbc.connection;
				        PreparedStatement pstmt=con.prepareStatement(sql);
				        ResultSet rs=null;
						rs=pstmt.executeQuery();
						
						resultSetToExcel(rs,0);
						
						Runtime.getRuntime().exec("cmd /c start ./bb.xls");