/** 
 * method GBS_ProductAvailabilityConditionActionLogic.java
 * created on 08-04-2004
 * 
 * @author   GXK
 * @version  1.0
 */

package LOGIC;

import java.util.ArrayList;

import javax.sql.DataSource;

import COMMON.ReturnValue;
import COMMON.SystemConstants;
import DB.GBS_MCountryProductR_DB;
//import DB.GBS_MProduct_DB;//Delete by Gxk 2004/08/23


public class GBS_ProductAvailabilityListSubActionLogic implements SystemConstants {
	private DataSource datasource = null;

	/**
	 * trans datasource to db
	 * @param datasource
	 */
	public GBS_ProductAvailabilityListSubActionLogic(DataSource datasource) {
	  this.datasource = datasource;
	}
	
	/**
	 * get the country and producd info from DB.M_COUNTRY_PRODUCT_R
	 * @param String[] country
	 * @param String[] product
	 * @return		ArrayList
	 * @exception	Exception    Exception for information of other errors
	 * @author gxk
	 * @since		2004/08/03
	 */
	public ReturnValue getCountryProductInfo(String country[],String product[],String loginAdmin,ArrayList controlCountryList)throws Exception{
		GBS_MCountryProductR_DB DB = new GBS_MCountryProductR_DB(this.datasource);
		return DB.selectCountryProductInfo("","","","","","",null,country,product,loginAdmin,controlCountryList);
	}

	/**
	 * get the country and producd info from DB.M_COUNTRY_PRODUCT_R
	 * @param String subsidiary
	 * @return		ArrayList
	 * @exception	Exception    Exception for information of other errors
	 * @author gxk
	 * @since		2004/08/03
	 */
	public ReturnValue getControlCountry(String subsidiary)throws Exception{
		GBS_MCountryProductR_DB DB = new GBS_MCountryProductR_DB(this.datasource);
		return DB.seletCountryCodeBySubsidiary( subsidiary );
	}
	
	/**
	 * updateHandling at DB
	 * @param country String[]
	 * @param product String[]
	 * @param handling String[]
	 * @param user String
	 * @return		boolean 
	 * @exception	Exception    Exception for information of other errors
	 * @author gxk
	 * @since		2004/08/04
	 */
	public ReturnValue updateHandling(String[] country, String[] product, String[] handling,String user)throws Exception{
		GBS_MCountryProductR_DB DB = new GBS_MCountryProductR_DB(this.datasource);
		return DB.updateHandling( country, product, handling, user );
	}
	
	//Delete by Gxk 2004/08/23
//	/**
//	 * get product code and name list by sql
//	 * @param String productId
//	 * @return boolean
//	 * @exception ExceptionException for information of other errors
//	 * @since 2004/08/04
//	 * @author Gxk
//	 */
//	public ReturnValue getCanDownload(String productId) throws Exception {
//		GBS_MProduct_DB Product_DB = new GBS_MProduct_DB(this.datasource);
//		return Product_DB.getCanDownload( productId );
//	}
}