package UIM.UIM04;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import UIB.COM.XmlSqlParsersFactory;

import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;

/**
 * 中间库行车查询
 * 
 * @author Administrator
 * 
 */
public class UIM040020 extends CoreIComponent {
	/**
	 * 查询行车作业钢卷信息
	 * 
	 * @param queryType
	 *            查询类型 1下线 2上料 3发运
	 * @return CoreReturnObject
	 * @throws SQLException
	 */
	public CoreReturnObject queryCoilList(Integer queryType)
			throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();

		String sql = "";

		if (1 == queryType.intValue()) {
			sql = XmlSqlParsersFactory.getSql("UIM040020_01.SELECT");
		} else if (2 == queryType.intValue()) {
			sql = XmlSqlParsersFactory.getSql("UIM040020_02.SELECT");
		} else if (3 == queryType.intValue()) {
			sql = XmlSqlParsersFactory.getSql("UIM040020_03.SELECT");
		} else {
			return cro;
		}

		cro = this.getDao("KgDao").ExcuteQuery(sql);

		return cro;
	}
}