package UIJ.UIJ03;

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

import UIB.COM.XmlSqlParsersFactory;

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

/**
 * 发运计划回退
 * 
 * @author siy
 * @date 2010-9-13
 */
public class UIJ030040 extends CoreIComponent {

	/**
	 * 查询发运计划信息
	 * 
	 * @param fromDate
	 * @param toDate
	 * @param dlivTp
	 * @param dlivDirNo
	 * @param isCancel
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryDlivPlan(String fromDate, String toDate,
			String dlivTp, String dlivDirNo, String isCancel)
			throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = XmlSqlParsersFactory.getSql("UIJ030040_01.SELECT");
		cro = this.getDao("KgDao").ExcuteQuery(
				sql,
				new Object[] { fromDate, toDate, fromDate, toDate, dlivTp,
						dlivTp, isCancel, dlivDirNo });

		return cro;
	}

	/**
	 * 发运计划回退
	 * 
	 * @param regId
	 * @param params
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject returnShipDir(String regId, ArrayList<String> params)
			throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = XmlSqlParsersFactory.getSql("UIJ030040_01.UPDATE");

		for (int i = 0; i < params.size(); i++) {
			String dlivDirNo = params.get(i);
			this.getDao("KgDao").ExcuteNonQuery(sql,
					new Object[] { regId, dlivDirNo });
		}

		return cro;
	}
}