mreportcolumnset.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 Smart Business Solution
 * The Initial Developer of the Original Code is Jorg Janke  and ComPiere, Inc.
 * Portions created by Jorg Janke are Copyright (C) 1999-2003 Jorg Janke, parts
 * created by ComPiere are Copyright (C) ComPiere, Inc.;   All Rights Reserved.
 * Contributor(s): ______________________________________.
 *****************************************************************************/
package org.compiere.report;

import java.util.*;
import java.sql.*;
import java.math.*;
import java.io.Serializable;

import org.compiere.model.*;
import org.compiere.util.*;


/**
 *  Report Column Set Model
 *
 *  @author Jorg Janke
 *  @version $Id: MReportColumnSet.java,v 1.3 2003/02/14 06:43:43 jjanke Exp $
 */
public class MReportColumnSet
  extends PO
{
	/**
	 * 	Constructor
	 * 	@param ctx context
	 * 	@param PA_ReportColumnSet_ID id
	 */
	public MReportColumnSet (Properties ctx, int PA_ReportColumnSet_ID)
	{
		super (ctx, PA_ReportColumnSet_ID);
		if (PA_ReportColumnSet_ID == 0)
		{
			setProcessing (null);
			setName (null);
		}
		else
			loadColumns();
	}	//	MReportColumnSet

	/** Contained Columns		*/
	private MReportColumn[]	m_columns = null;

	/**
	 * 	Initialize
	 * 	@param ctx context
	 * 	@return meta data
	 */
	protected POInfo initPO (Properties ctx)
	{
		int AD_Table_ID = 447;
		POInfo poi = POInfo.getPOInfo (ctx, AD_Table_ID);
		return poi;
	}	//	initPO

	/**
	 *	Load contained columns
	 */
	private void loadColumns()
	{
		ArrayList list = new ArrayList();
		String sql = "SELECT * FROM PA_ReportColumn WHERE PA_ReportColumnSet_ID=? AND IsActive='Y' ORDER BY SeqNo";
		PreparedStatement pstmt = null;
		try
		{
			pstmt = DB.prepareStatement(sql);
			pstmt.setInt(1, getPA_ReportColumnSet_ID());
			ResultSet rs = pstmt.executeQuery();
			while (rs.next())
				list.add(new MReportColumn (getCtx(), rs));
			rs.close();
			pstmt.close();
			pstmt = null;
		}
		catch (Exception e)
		{
			Log.error("MReportColumnSet.loadColumns", e);
		}
		finally
		{
			try
			{
				if (pstmt != null)
					pstmt.close ();
			}
			catch (Exception e)
			{}
			pstmt = null;
		}
		//
		m_columns = new MReportColumn[list.size()];
		list.toArray(m_columns);
		Log.trace(8, "MReportColumnSet.loadColumns ID=" + getPA_ReportColumnSet_ID(),
			"Size=" + list.size());
	}	//	loadColumns

	public MReportColumn[] getColumns()
	{
		return m_columns;
	}

	/**
	 * 	List Info
	 */
	public void list()
	{
		System.out.println(toString());
		if (m_columns == null)
			return;
		for (int i = 0; i < m_columns.length; i++)
			System.out.println("- " + m_columns[i].toString());
	}	//	list

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



	public String toString ()
	{
		StringBuffer sb = new StringBuffer ("MReportColumnSet[")
			.append(getID()).append(" - ").append(getName())
			.append ("]");
		return sb.toString ();
	}


	public boolean save ()
	{
		Log.trace (Log.l4_Data, "MReportColumnSet.save");
		return super.save ();
	}

	public void setDescription (String Description)
	{
		setValue ("Description", Description);
	}

	public String getDescription ()
	{
		return (String)getValue ("Description");
	}

	public void setProcessing (String Processing)
	{
		if (Processing == null)
			throw new IllegalArgumentException ("Processing is mandatory");
		setValue ("Processing", Processing);
	}

	public String getProcessing ()
	{
		return (String)getValue ("Processing");
	}

	public void setName (String Name)
	{
		if (Name == null)
			throw new IllegalArgumentException ("Name is mandatory");
		setValue ("Name", Name);
	}

	public String getName ()
	{
		return (String)getValue ("Name");
	}

	public int getPA_ReportColumnSet_ID ()
	{
		return getID();
	}
}