package UIJ.UIJ03;

import java.sql.SQLException;

import UIB.COM.XmlSqlParsersFactory;

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

/**
 * 发运计划查询
 * 
 * @author siy
 * @date 2010-9-6
 */
public class UIJ030010 extends CoreIComponent {

	/**
	 * 查询发运计划
	 * 
	 * @param dlivDirDate
	 * @param dlivTp
	 * @param ordNo
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryShippingPlan(String dlivDirDate,String dlivDirDateED,
			String dlivTp, String ordNo) throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = XmlSqlParsersFactory.getSql("UIJ030010_01.SELECT");
		cro = this.getDao("KgDao").ExcuteQuery(sql,
				new Object[] { dlivDirDate,dlivDirDateED, dlivTp, ordNo });

		return cro;
	}
	public CoreReturnObject queryShippingPlanSuanX(String dlivDirDate,String dlivDirDateED,
			String dlivTp, String ordNo) throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = XmlSqlParsersFactory.getSql("UIJ030011_01.SELECT");
		cro = this.getDao("KgDao").ExcuteQuery(sql,
				new Object[] { dlivDirDate,dlivDirDateED, dlivTp, ordNo });

		return cro;
	}
	/**
	 * 查询发运计划对应的钢卷
	 * 
	 * @param dlivDirNo
	 * @return
	 */
	public CoreReturnObject queryShippingCoil(String dlivDirNo) {
		CoreReturnObject cro = new CoreReturnObject();

		String sql = XmlSqlParsersFactory.getSql("UIJ030010_02.SELECT");

		cro = this.getDao("KgDao").ExcuteQuery(sql,
				new Object[] { dlivDirNo });

		return cro;
	}
	/*
	 * 查询发运计划连退
	 */
	public CoreReturnObject LtqueryShippingPlan(String dlivDirDate,String dlivDirDateED,
			String dlivTp, String ordNo) throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = XmlSqlParsersFactory.getSql("UIJ050010_01.SELECT");
		cro = this.getDao("KgDao").ExcuteQuery(sql,
				new Object[] { dlivDirDate,dlivDirDateED, dlivTp, ordNo });

		return cro;
	}
	/**
	 * 查询发运计划对应的钢卷连退
	 * 
	 * @param dlivDirNo
	 * @return
	 */
	public CoreReturnObject queryShippingCoilLt(String dlivDirNo) {
		CoreReturnObject cro = new CoreReturnObject();

		String sql = XmlSqlParsersFactory.getSql("UIJ050010_02.SELECT");

		cro = this.getDao("KgDao").ExcuteQuery(sql,
				new Object[] { dlivDirNo });

		return cro;
	}
}