package windows;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import odbc.Conn;



public class Load implements ActionListener {
	private JFrame log;
	private JLabel midl;
	private JTextField midtf;
	private JButton ok,dbuy,querym,queryg;
	private JPanel p1,p2,p3;
	private static float money=0;
	
    public Load() {                                //構造方法，初始化窗口
    	
        //log
        log=new JFrame("登錄");
        log.setSize(new Dimension(350,180));        
        //Label
        midl=new JLabel("會員卡號");
        midl.setFont(new Font("黑體",18,18));    
        //TextField
        midtf=new JTextField(15);
        midtf.setText("");
        midtf.setFont(new Font("黑體",18,18));
        //Button
        ok=new JButton("確定");
        dbuy=new JButton("直接購買");
        querym=new JButton("查詢會員信息");
        queryg=new JButton("查詢商品信息");
        ok.setFont(new Font("黑體",15,15));
        dbuy.setFont(new Font("黑體",15,15));
        querym.setFont(new Font("黑體",15,15));
        queryg.setFont(new Font("黑體",15,15));
        //Panel
        p1=new JPanel();
        p2=new JPanel();
        p3=new JPanel();
        //log布局
        p1.setLayout(new FlowLayout(FlowLayout.CENTER,12,12));
        p1.add(midl);
        p1.add(midtf);
        p2.setLayout(new FlowLayout(FlowLayout.CENTER,12,12));
        p2.add(ok);
        p2.add(dbuy);
        p3.setLayout(new FlowLayout(FlowLayout.CENTER,12,12));
        p3.add(querym);
        p3.add(queryg);        
        log.setLayout(new BorderLayout());
        log.add("North",p1);
        log.add("Center",p2);
        log.add("South",p3);
        log.setBackground(Color.darkGray);
        log.setLocation(350,300);
        log.setVisible(true);
        log.setResizable(false);
        log.setDefaultCloseOperation (JFrame.EXIT_ON_CLOSE);
        //按鈕事件監聽
        ok.addActionListener(this);
        dbuy.addActionListener(this);
        querym.addActionListener(this);
        queryg.addActionListener(this);
        
    }            //Load()
    
public void actionPerformed(ActionEvent e) {      
		String mid=midtf.getText();
		Pos pos;
		Inf_m inf_m;
		Inf_g inf_g;
		
		if(e.getSource()==ok)                               //會員購買
		 {if( mid.equalsIgnoreCase("") || Integer.parseInt(mid)<=0 || Integer.parseInt(mid)>Conn.mSum())
		   {JOptionPane.showMessageDialog(null,"請輸入正確的會員卡號","出錯",JOptionPane.ERROR_MESSAGE);
		  }else   
		     {midtf.setText("");
			  try{String sql3="select Mname from members where Mid="+Integer.parseInt(mid);
	              Statement stmt = Conn.getConnection().createStatement();
	              ResultSet rs=stmt.executeQuery(sql3);
	              rs.next();
	              String ss=rs.getString("Mname");
	              JOptionPane.showMessageDialog(null,"歡迎光臨","尊敬的會員",JOptionPane.DEFAULT_OPTION);
			      pos=new Pos(ss,mid);
			      stmt.executeUpdate(sql3);
		          rs.close();
		          stmt.close();
		       }catch(Exception e1){
		                e1.getStackTrace();
		        } //catch
		     } //else		    	
		}                                                     
		
	    if(e.getSource()==dbuy)                          //非會員購買
 	    {JOptionPane.showMessageDialog(null,"歡迎光臨","尊敬的顧客",JOptionPane.DEFAULT_OPTION);
    	 pos=new Pos("顧客","0");
 	    }                                                    
	    
	    if(e.getSource()==querym)                      //查詢會員信息
	    {midtf.setText("");
	     try{if( mid.equalsIgnoreCase("") || Integer.parseInt(mid)<=0 || Integer.parseInt(mid)>Conn.mSum())
		        JOptionPane.showMessageDialog(null,"請輸入正確的會員卡號","出錯",JOptionPane.ERROR_MESSAGE);		      
	         else  inf_m=new Inf_m(mid);
	      }catch (Exception e1) {
			e1.printStackTrace();
	       }                                            
	    }                                                  
	    
		if(e.getSource()==queryg)                  //查詢貨品庫存量和該收銀臺的銷售量
		{ inf_g=new Inf_g();			
		}                                               
		
	}  //actionPerformed()	
    
    public static void setMoney(float mon) {
    	if(mon>=0)   money=money+mon;
    }
	public static float getMoney() {
		return money;
	}

}