expitem.java

OBPM是一个开源

package cn.myapps.core.expimp.exp.ejb;

import java.util.ArrayList;
import java.util.Collection;
import java.util.LinkedHashMap;
import java.util.Map;

import cn.myapps.core.expimp.exp.util.SQLPackage;

public class ExpItem extends ExpElement {
	public ExpItem(boolean expAll) {
		super(expAll);
	}

	private final static String NAME = "T_ITEM";

	public Map exportItemSQLS(String[] formids, Collection ignoreIds)
			throws Exception {
		ArrayList newformids = new ArrayList();

		for (int i = 0; i < formids.length; i++) {
			if (ignoreIds.contains("item_" + formids[i])) {
				continue;
			} else {
				ignoreIds.add("item_" + formids[i]);

				newformids.add(formids[i]);
			}
		}

		Map rtn = new LinkedHashMap();

		if (newformids.size() > 0) {
			StringBuffer sqlBuffer = new StringBuffer();

			sqlBuffer.append("SELECT * FROM " + NAME);
			sqlBuffer.append(" WHERE doc_id IN (");

			sqlBuffer.append("SELECT id FROM " + ExpDocument.NAME);
			sqlBuffer.append(" WHERE formid IN (");
			for (int i = 0; i < formids.length; i++) {
				sqlBuffer.append("'" + formids[i] + "'");
				if (i < formids.length - 1) {
					sqlBuffer.append(",");
				}
			}
			sqlBuffer.append(") )");

			SQLPackage sqlPackage = new SQLPackage(NAME, sqlBuffer.toString());

			rtn.put("document_items", sqlPackage);
		}
		return rtn;
	}

	public String getName() {
		return NAME;
	}

	public Map exportSQLS(String[] ids, Collection ignoreIds) throws Exception {
		return null;
	}
}