requestprocessorvo.java

Java写的ERP系统

/******************************************************************************
 * The contents of this file are subject to the   Compiere License  Version 1.1
 * ("License"); You may not use this file except in compliance with the License
 * You may obtain a copy of the License at http://www.compiere.org/license.html
 * Software distributed under the License is distributed on an  "AS IS"  basis,
 * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
 * the specific language governing rights and limitations under the License.
 * The Original Code is                  Compiere  ERP & CRM  Business Solution
 * The Initial Developer of the Original Code is Jorg Janke  and ComPiere, Inc.
 * Portions created by Jorg Janke are Copyright (C) 1999-2002 Jorg Janke, parts
 * created by ComPiere are Copyright (C) ComPiere, Inc.;   All Rights Reserved.
 * Contributor(s): ______________________________________.
 *****************************************************************************/
package org.compiere.request;

import java.sql.*;
import java.util.*;

import org.apache.log4j.Logger;
import org.compiere.util.*;

/**
 *	Request Value Object
 *
 * 	@author 	Jorg Janke
 * 	@version 	$Id: RequestProcessorVO.java,v 1.1 2002/11/17 00:51:49 jjanke Exp $
 */
public class RequestProcessorVO
{
	/**
	 * 	Get Request Processor Definitions (Value Object).
	 *
	 * 	@return Array of Request Processors
	 */
	public static RequestProcessorVO[] get ()
	{
		String sql = "SELECT rp.R_RequestProcessor_ID, rp.AD_Client_ID, rp.Name,"   //  1..3
			+ " rp.FrequencyType, rp.Frequency, rp.DateNextRun,"                    //  4..6
			+ " rp.OverdueAlertDays, rp.OverdueAssignDays,"                         //  7..8
			+ " c.SMTPHost, c.RequestEMail,"                                        //  9..10
			+ " c.RequestUser, c.RequestUserPW, c.RequestFolder, "                  //  11..13
			+ " c.AD_Language, rp.Supervisor_ID "                                   //  14..15
			+ "FROM R_RequestProcessor rp, AD_Client c "
			+ "WHERE rp.AD_Client_ID=c.AD_Client_ID"
			+ " AND rp.IsActive='Y'";

		ArrayList list = new ArrayList();
		try
		{
			PreparedStatement pstmt = DB.prepareStatement(sql);
			ResultSet rs = pstmt.executeQuery();
			while (rs.next())
			{
				RequestProcessorVO vo = new RequestProcessorVO (
					rs.getInt(1), rs.getInt(2), rs.getString(3),
					rs.getString(4), rs.getInt(5), rs.getTimestamp(6),
					rs.getInt(7), rs.getInt(8),
					rs.getString(9), rs.getString(10),
					rs.getString(11), rs.getString(12), rs.getString(13),
					rs.getString(14), rs.getInt(15));
				list.add(vo);
			}
			rs.close();
			pstmt.close();
		}
		catch (SQLException e)
		{
			log.error("get", e);
		}
		//
		RequestProcessorVO[] retValue = new RequestProcessorVO[list.size()];
		list.toArray(retValue);
		return retValue;
	}	//	get

	/*************************************************************************/

	/**	Logger					*/
	private static Logger	log = Logger.getLogger(RequestProcessorVO.class);


	public static final String	FREQUENCY_DAY = "D";
	public static final String	FREQUENCY_HOUR = "H";
	public static final String	FREQUENCY_MINUTE = "M";


	/*************************************************************************/

	/**
	 *  Value Object Constructor
	 *
	 *  @param R_RequestProcessor_ID id
	 *  @param AD_Client_ID client
	 *  @param Name name
	 *  @param FrequencyType frequency type
	 *  @param Frequency frequency
	 *  @param DateNextRun next run
	 *  @param OverdueAlertDays overdue alert days
	 *  @param OverdueAssignDays overdue assign days
	 *  @param SMTPHost SMTP host
	 *  @param RequestEMail mail id
	 *  @param RequestUser user id
	 *  @param RequestUserPW user password
	 *  @param RequestFolder folder
	 *  @param AD_Language language
	 *  @param Supervisor_ID ultimate supervisor
	 */
	public RequestProcessorVO (int R_RequestProcessor_ID, int AD_Client_ID, String Name,
		String FrequencyType, int Frequency, Timestamp DateNextRun,
		int OverdueAlertDays, int OverdueAssignDays,
		String SMTPHost, String RequestEMail,
		String RequestUser, String RequestUserPW, String RequestFolder,
		String AD_Language, int Supervisor_ID)
	{
		this.R_RequestProcessor_ID = R_RequestProcessor_ID;
		this.AD_Client_ID = AD_Client_ID;
		this.Name = Name;
		this.FrequencyType = FrequencyType;
		this.Frequency = Frequency;
		this.DateNextRun = DateNextRun;
		this.OverdueAlertDays = OverdueAlertDays;
		this.OverdueAssignDays = OverdueAssignDays;
		this.SMTPHost = SMTPHost;
		this.RequestEMail = RequestEMail;
		this.RequestUser = RequestUser;
		this.RequestUserPW = RequestUserPW;
		this.RequestFolder = RequestFolder;
		this.AD_Language = AD_Language;
		this.Supervisor_ID = Supervisor_ID;
	}   //  RequestProcessorVO

	int R_RequestProcessor_ID;
	int AD_Client_ID;
	String Name;
	String FrequencyType;
	int Frequency;
	Timestamp DateNextRun;
	int OverdueAlertDays;
	int OverdueAssignDays;
	String SMTPHost;
	String RequestEMail;
	String RequestUser;
	String RequestUserPW;
	String RequestFolder;
	String AD_Language;
	int Supervisor_ID;

}