package restaurant;

import java.io.*;
import java.sql.*;
import javax.swing.JOptionPane;
import java.util.Vector;
import java.util.Calendar;
import java.util.Date;

public class RestaurantMenu51{
    
    private DBCon con;
	private Read read;
	private Write write;
	private Exit exit;
	private Common common;
	ResultSet rs=null;

	public void selectStockInfo(){
	     
	     String sql="select * from commodityIn";

         
         con = new DBCon();
	     read = new Read(con.getConnection());    
         rs=read.executeQuery(sql);  
    }
      
      
	public String selectStockInfo(String commodity){
         Vector vec = new Vector();
		 common = new Common();
		 commodity=common.toChinese(commodity);
		 
         String sql="select * from commodityIn where commodity='"+commodity+"'";
            con = new DBCon();
	        read = new Read(con.getConnection());    
            rs=read.executeQuery(sql); 
            
         try{
            while(rs.next()){
    			vec.addElement(rs.getString("stockNo"));
    			vec.addElement(rs.getString("commodity")); 
    			vec.addElement(rs.getString("operator"));
    			vec.addElement(rs.getString("amount"));
    			vec.addElement(rs.getString("price"));
    			vec.addElement(rs.getString("discount"));
    			vec.addElement(rs.getString("totalPrice"));
    			vec.addElement(rs.getString("stockDate"));
    			vec.addElement(rs.getString("remark"));
            }
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }   
          exit = new Exit(con.getConnection());
          exit.Close();
          
         
          String  str="";
          if(vec.size()==9)
          {
                  str="商品編號:"+vec.get(0)+"<br>";
                  str+="名稱:"+vec.get(1)+"<br>";
			      str+="進貨人:"+vec.get(2)+"<br>";
                  str+="數(shù)量:"+vec.get(3)+"<br>";
                  str+="單價:"+vec.get(4)+"<br>";
			      str+="折扣:"+vec.get(5)+"<br>";
                  str+="總金額:"+vec.get(6)+"<br>";
                  str+="金貨日期:"+vec.get(7)+"<br>";
			      str+="備注:"+vec.get(8)+"<br>";
          }
          if(vec.size()==0)
              str="該商品不存在!";
          
          
          return str;
    }  
      
      
    public Vector getStockInfoInfo(){
    	Vector vec = new Vector();
    	try{
    		while(rs.next()){
    			vec.addElement(rs.getString("stockNo"));
    			vec.addElement(rs.getString("commodity")); 
    			vec.addElement(rs.getString("operator"));
    			vec.addElement(rs.getString("amount"));
    			vec.addElement(rs.getString("price"));
    			vec.addElement(rs.getString("discount"));
    			vec.addElement(rs.getString("totalPrice"));
    			vec.addElement(rs.getString("stockDate"));
    			vec.addElement(rs.getString("remark"));
    		}
        }catch(SQLException e){
		   System.err.println(e.getMessage());
		}
		exit = new Exit(con.getConnection());
        exit.Close();
        
		return vec;
    }
}