package UIK.UIK02;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Hashtable;

import UIB.COM.XmlSqlParsersFactory;

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

/**
 * 酸轧实绩查询
 * 
 * @author siy
 * @date 2010-9-19
 */
public class UIK020050 extends CoreIComponent {
	/**
	 * 查询酸轧作业实绩冷轧卷基础信息
	 * 
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryColdCoilResult(String rollManaNo,
			String beginTime, String endTime, String coilNo)
			throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = XmlSqlParsersFactory.getSql("UIK020050_01.SELECT");
		cro = this.getDao("KgDao").ExcuteQuery(sql,
				new Object[] { rollManaNo, beginTime, endTime, coilNo });
		return cro;
	}

	/**
	 * 查询酸轧作业实绩
	 * 
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryAcidRollingResult(String rollManaNo,
			String beginTime, String endTime, String coilNo)
			throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = XmlSqlParsersFactory.getSql("UIK020030_02.SELECT");
		cro = this.getDao("KgDao").ExcuteQuery(sql,
				new Object[] { rollManaNo, beginTime, endTime, coilNo });
		return cro;
	}

	/**
	 * 查询酸轧作业实绩缺陷信息
	 * 
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryRollingDefectResult(String rollManaNo,
			String beginTime, String endTime, String coilNo)
			throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = XmlSqlParsersFactory.getSql("UIK020030_03.SELECT");
		cro = this.getDao("KgDao").ExcuteQuery(sql,
				new Object[] { rollManaNo, beginTime, endTime, coilNo });
		return cro;
	}
}