gbs_serviceinfosubactionlogic.java

对日软件外包 为东芝做的一个全球商业管理系统

package LOGIC;

import javax.sql.DataSource;

import org.apache.struts.upload.FormFile;

import COMMON.ReturnValue;
import COMMON.SystemConstants;
import DB.GBS_MServiceInfo_DB;


/**
 * GBS_ServiceInfosubActionLogic implements SystemConstants 
 * created on 29-07-2004
 * @author mxx
 * @version  1.0
 */

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

/**
 * method GBS_ServiceInfosubActionLogic 
 * @param datasource
 * @return
 * @throws Exception
 */	
	public GBS_ServiceInfosubActionLogic(DataSource datasource) {
	  this.datasource = datasource;
	}
/**
 * method getServiceInfosub 
 * @param Seqno
 * @return ReturnValue
 * @throws Exception
 */	
	
	public  ReturnValue getServiceInfosub(String Seqno) throws Exception {
		
		GBS_MServiceInfo_DB mService_DB = new GBS_MServiceInfo_DB(this.datasource);
		return mService_DB.selectBySeqno(Seqno);
		
	}
/**
 * method insertService 
 * @param Seqno
 * @param Title
 * @param Createdate
 * @param Createuser
 * @param AttachmentFile
 * @return ReturnValue
 * @throws Exception
 */	
		
	public ReturnValue insertService(	String Seqno,
										String Title,
										String Createdate,
										String Createuser,
										FormFile AttachmentFile)  throws Exception {
		int seqNo = 0;
		ReturnValue returnValue = new ReturnValue();		
		
		GBS_MServiceInfo_DB mService_DB = new GBS_MServiceInfo_DB(this.datasource);
		returnValue = mService_DB.addService(	Seqno,
												Title,
												Createdate,
												Createuser,
												AttachmentFile);	
	
				
		return returnValue;
	}
	
/**
 * method updateService 
 * @param Seqno
 * @param Title
 * @param Createdate
 * @param Createuser
 * @param AttachmentFile
 * @param FileDelete
 * @return ReturnValue
 * @throws Exception
 */	
	public ReturnValue updateService(  String Seqno,
							   String Title,
							   String Updatedate,
							   String Updateuser,
							   FormFile attachmentFile,
							   boolean FileDelete)
	 throws Exception {
		//byte[] data = null;
		int ret = 0;
		ReturnValue returnValue = new ReturnValue();
			GBS_MServiceInfo_DB mService_DB = new GBS_MServiceInfo_DB(this.datasource);	
					//mService_DB.updateAttachmentFile(Seqno,data);
			returnValue = mService_DB.updateService(Seqno,
													Title,
													Updatedate,
													Updateuser,
													attachmentFile,
													FileDelete);	
			
		return returnValue;
	}	

		
/**
 * method deleteBySeqno 
 * @param Seqno
 * @return ReturnValue
 * @throws Exception
 */	
	public ReturnValue deleteBySeqno(String Seqno) throws Exception {
		GBS_MServiceInfo_DB mService_DB = new GBS_MServiceInfo_DB(this.datasource);	
		return mService_DB.deleteService(Seqno);
	}
}