mproductionplan.java

大家共享愉快, 共享愉快, 共享愉快, 共享愉快,共享愉快

/******************************************************************************
 * 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. Portions created by Jorg Janke
 * are Copyright (C) 1999-2005 Jorg Janke.
 * All parts are Copyright (C) 1999-2005 ComPiere, Inc.  All Rights Reserved.
 * Contributor(s): ______________________________________.
 *****************************************************************************/
package org.compiere.model;

import java.sql.*;
import java.util.*;
import java.util.logging.*;
import org.compiere.util.*;

/**
 * 	Production Plan Model
 *
 *	@author Jorg Janke
 *	@version $Id: MProductionPlan.java,v 1.20 2005/03/11 20:26:04 jjanke Exp $
 */
public class MProductionPlan extends X_M_ProductionPlan {
    /**
     * 	Get MProductionPlan from Cache
     *	@param ctx context
     *	@param whereClause
     *	@param trxName
     *	@return MProductionPlan
     */
    public static MProductionPlan[] get(Properties ctx, String whereClause,
                                        String trxName) {
        String sql = "SELECT * FROM M_ProductionPlan";
        if (whereClause != null && whereClause.length() > 0)
            sql += " WHERE " + whereClause;
        ArrayList list = new ArrayList();
        PreparedStatement pstmt = null;
        try {
            pstmt = DB.prepareStatement(sql, trxName);
            ResultSet rs = pstmt.executeQuery();
            while (rs.next())
                list.add(new MProductionPlan(ctx, rs, trxName));
            rs.close();
            pstmt.close();
            pstmt = null;
        } catch (Exception e) {
            s_log.log(Level.SEVERE, "get", e);
        }
        try {
            if (pstmt != null)
                pstmt.close();
            pstmt = null;
        } catch (Exception e) {
            pstmt = null;
        }
        MProductionPlan[] retValue = new MProductionPlan[list.size()];
        list.toArray(retValue);
        return retValue;
    } //	get


    /**	Static Logger	*/
    private static CLogger s_log = CLogger.getCLogger(MProductionPlan.class);

    /**************************************************************************
     * 	Standard Constructor
     *	@param ctx context
     *	@param M_ProductionPlan_ID id
     */
    public MProductionPlan(Properties ctx, int M_ProductionPlan_ID, String trxName) {
        super(ctx, M_ProductionPlan_ID, trxName);
        if (M_ProductionPlan_ID == 0) {
        }
    } //	MProductionPlan

    /**
     * 	Load constructor
     *	@param ctx context
     *	@param rs result set
     */
    public MProductionPlan(Properties ctx, ResultSet rs, String trxName) {
        super(ctx, rs, trxName);
    } //	MProductionPlan

    /**
     *  @param  order parent production
     */
    public MProductionPlan(MProduction production) {
        this(production.getCtx(), 0, production.get_TrxName());
        if (production.get_ID() == 0)
            throw new IllegalArgumentException("Header not saved");

        setM_Production_ID(production.getM_Production_ID());
    } //	MOrderLine
} //	MProductionPlan