package LOGIC;

import javax.sql.DataSource;

import org.apache.struts.upload.FormFile;

import COMMON.ReturnValue;
import COMMON.SystemConstants;
import DB.GBS_MProduct_DB;

public class GBS_ProductMasterMaintenanceActionLogic implements SystemConstants {
	private DataSource datasource = null;
	
	
	public GBS_ProductMasterMaintenanceActionLogic(DataSource datasource) {
			this.datasource = datasource;
	}
	
	/**
	 * selectByProductID
	 * @param		String ProductID
	 * @return		returnValue
	 * @exception	Exception    Exception for information of other errors
	 * @since		2004/07/30
	 */	
	public ReturnValue selectByProductID(String proudctId) throws Exception {
		GBS_MProduct_DB mProduct_DB = new GBS_MProduct_DB(this.datasource);
		ReturnValue returnValue = mProduct_DB.selectByProductId(proudctId);
		return  returnValue;
	}
	
	/**
	 * get  insertProductInfo by seqno
	 * @param		String ProductID
	 * @return		returnValue
	 * @exception	Exception    Exception for information of other errors
	 * @since		2004/07/30
	 */	
	public ReturnValue insertProductInfo(
								String ProductID,
								String DispOrder,
								String ProductName,
								String ProductAbbrName,
								String Kind,
								String ProductCategory,
								String OptionCategory,
								String ColorCpm,
								String BwCpm,
								String MonoColorCpm,
								String OtherCpm,
								FormFile VersionList,
								String DelFlag,
								String CreateUser) throws Exception {
			int result=0;
			GBS_MProduct_DB mProduct_DB = new GBS_MProduct_DB(this.datasource);
			
			ReturnValue returnValue = mProduct_DB.insertDB(	
									ProductID,
									DispOrder,
									ProductName,
									ProductAbbrName,
									Kind,
									ProductCategory,
									OptionCategory,
									ColorCpm,
									BwCpm,
									MonoColorCpm,
									OtherCpm,
									VersionList,
									DelFlag,
									CreateUser);
			return returnValue;
			
	}
	
	/**
	 * updateProductInfo
	 * @param		String ProductID
	 * @param		String DispOrder
	 * @param		String ProductName
	 * @param		String ProductAbbrName
	 * @param		String Kind
	 * @param		String ProductCategory
	 * @param		String OptionCategory
	 * @param		String ColorCpm
	 * @param		String BwCpm
	 * @param		String MonoColorCpm
	 * @param		String OtherCpm
	 * @param		FormFile VersionList
	 * @param		String CreateUser
	 * @param		boolean FileDelete
	 * @return		returnValue
	 * @exception	Exception    Exception for information of other errors
	 * @since		2004/07/30
	 */	
	public ReturnValue updateProductInfo(
											String ProductID,
											String DispOrder,
											String ProductName,
											String ProductAbbrName,
											String Kind,
											String ProductCategory,
											String OptionCategory,
											String ColorCpm,
											String BwCpm,
											String MonoColorCpm,
											String OtherCpm,
											FormFile VersionList,
											String CreateUser,
											boolean FileDelete ) 
	throws Exception {
			GBS_MProduct_DB mProduct_DB = new GBS_MProduct_DB(this.datasource);
			ReturnValue returnValue	= mProduct_DB.updateByProductId(
																		ProductID,
																		DispOrder,
																		ProductName,
																		ProductAbbrName,
																		Kind,
																		ProductCategory,
																		OptionCategory,
																		ColorCpm,
																		BwCpm,
																		MonoColorCpm,
																		OtherCpm,
																		VersionList,
																		CreateUser,
																		FileDelete
																	);
		    return returnValue;
	}
	
	/**
	 * deleteByProductId
	 * @param		String ProductID
	 * @return		returnValue
	 * @exception	Exception    Exception for information of other errors
	 * @since		2004/07/30
	 */	
	//Edit by Gxk 2004/08/23:add updateUserid
	public ReturnValue deleteByProductId( String productID ,String updateUserId ) throws Exception {
		GBS_MProduct_DB mProduct_DB = new GBS_MProduct_DB(this.datasource);
		return mProduct_DB.deleteByProductID(productID,updateUserId);
	}
	 
}