package UIM.UIM02;

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

import UIB.COM.XmlSqlParsersFactory;

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

/**
 * 重卷计划查询
 * 
 * @author siy
 * @date 2011-09-21
 */
public class UIM020070 extends CoreIComponent {
	/**
	 * 查询重卷计划
	 * 
	 * @param pFromDate
	 * @param pToDate
	 * @param mFromDate
	 * @param mToDate
	 * @param ordNo
	 * @param ordSeq
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryReelPlan(String pFromDate, String pToDate,
			String mFromDate, String mToDate, String ordNo, String ordSeq,
			String coilNo,String trnfShift,String trnfGroup ) throws SQLException {
		CoreReturnObject cro = null;
		String sqlQuery = XmlSqlParsersFactory.getSql("UIM020070_01.SELECT");
		cro = this.getDao("KgDao").ExcuteQuery(
				sqlQuery,
				new Object[] { pFromDate, pToDate, mFromDate, mToDate, ordNo,
						ordSeq, coilNo,trnfShift,trnfGroup });
		return cro;
	}
}