XinYu_LZMES/.svn/pristine/08/08e185c60aea3749a247f5dca3a303109ec44b01.svn-base

package UIM;

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

import UIB.COM.XmlSqlParsersFactory;

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

/**
 * ¿É·¢Á¿²éѯ
 * 
 * @author siy
 * @date 2010-09-26
 */
public class UIM010280 extends CoreIComponent {
	/**
	 * ²éѯ¿É·¢Á¿
	 * 
	 * @param dlivTp
	 * @param ordNo
	 * @param specStlGrd
	 * @param hsTot
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryOrdResultForSale(String dlivTp, String ordNo,
			String specStlGrd, Integer hsTot) throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();

		StringBuffer sqlBuffer = new StringBuffer();
		sqlBuffer.append(XmlSqlParsersFactory.getSql("UIM010280_01.SELECT")
				+ "\n");
		if (1 != hsTot.intValue()) {
			sqlBuffer
					.append(" AND CUR_LOAD_LOC IS NOT NULL AND CUR_PROG_CD = 'DFA' AND TOT_DEC_GRD = '1'\n");
		}
		sqlBuffer.append(XmlSqlParsersFactory.getSql("UIM010280_02.SELECT")
				+ "\n");

		cro = this.getDao("KgDao").ExcuteQuery(sqlBuffer.toString(),
				new Object[] { dlivTp, ordNo, specStlGrd });// .ExcuteQuery(sql);

		return cro;
	}

	public CoreReturnObject queryCoilResultByOrd(String ordNo, String ordSeq, Integer hsTot)
			throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = XmlSqlParsersFactory.getSql("UIM010280_03.SELECT");
		if (1 != hsTot.intValue()) {
			sql += "\nAND C.TOT_DEC_GRD = '1' AND C.CUR_PROG_CD = 'DFA' AND C.CUR_LOAD_LOC is not null";
		}

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

		return cro;
	}
}