package restaurant;

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


public class RestaurantMenu23{
	
    private DBCon con;
	private Read read;
	private Write write;
	private Exit exit;
	private Common common;
	ResultSet rs=null;
    
	public void input(Vector inputMessage){
         common = new Common();
	     String sql="insert into commodityIn values(";
		        sql+="'"+common.toChinese((String)inputMessage.get(0))+"',";
		        sql+="'"+common.toChinese((String)inputMessage.get(1))+"',";		        
    	        sql+="'"+common.toChinese((String)inputMessage.get(2))+"',";
    	        sql+=Integer.parseInt(common.toChinese((String)inputMessage.get(3)))+",";
    	        sql+=Integer.parseInt(common.toChinese((String)inputMessage.get(4)))+",";
    	        sql+=Integer.parseInt(common.toChinese((String)inputMessage.get(5)))+",";
    	        sql+=Integer.parseInt(common.toChinese((String)inputMessage.get(3)))*Integer.parseInt(common.toChinese((String)inputMessage.get(4)))*Integer.parseInt(common.toChinese((String)inputMessage.get(5)))/10+",";      	        
    	        sql+="now(),";     
    	        sql+="'"+common.toChinese((String)inputMessage.get(6))+"')";   	        
    	             
    	    con = new DBCon();
	        write = new Write(con.getConnection());    
            write.executeUpdate(sql); 
            
            common=new Common();
            common.WriteSystemLog("酒店經(jīng)理:"+common.toChinese((String)inputMessage.get(2))+"進(jìn)貨入庫."+common.getNowTime());
  
            exit = new Exit(con.getConnection());
            exit.Close();		
	}    

}