package UIM;

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

import UIB.COM.XmlSqlParsersFactory;

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

/**
 * 冷轧中间库库存数据查询
 * @author siy
 * @date 2010-08-14
 */
public class UIM010160 extends CoreIComponent {
	/**
	 * 查询中间库库存数据
	 * @param list 参数集
	 * @return CoreReturnObject
	 * @throws SQLException
	 */
	public CoreReturnObject queryYardList(ArrayList list) throws SQLException
	{
		CoreReturnObject cro = new CoreReturnObject();
		
		String []queryParams = (String[])list.get(0);
		
		String startTime = queryParams[0];//入库开始时间
		String endTime = queryParams[1];//入库结束时间
		String specStlGrd = queryParams[2];//牌号
		String coilWthMin = queryParams[3];//宽度最小值
		String coilWthMax = queryParams[4];//宽度最大值
		String coilThkMin = queryParams[5];//厚度最小值
		String coilThkMax = queryParams[6];//厚度最大值
		String curLoadLoc = queryParams[7];//垛位
		String coilNo = queryParams[8];//钢卷号
		String ordNo = queryParams[9];//订单号
		String ordFl = queryParams[11];//订单区分
		String devlmtDate = queryParams[12];//交货期
		String progCd = queryParams[13];//进程状态
		String smpSendTime = queryParams[14];//送样时间
		String prodnmCd = queryParams[15];//产品类型

		String sql = XmlSqlParsersFactory.getSql("UIM010160_01.SELECT");
		
		
		cro = this.getDao("KgDao").ExcuteQuery(sql,new Object[]{coilNo,specStlGrd,curLoadLoc,
				coilThkMin,coilThkMax,coilWthMin,coilWthMax,startTime,endTime,ordNo,progCd,
				devlmtDate,smpSendTime,prodnmCd,ordFl});

		return cro;
	}
	public CoreReturnObject queryYardListSx(ArrayList list) throws SQLException
	{
		CoreReturnObject cro = new CoreReturnObject();
		
		String []queryParams = (String[])list.get(0);
		
		String startTime = queryParams[0];//入库开始时间
		String endTime = queryParams[1];//入库结束时间
		String specStlGrd = queryParams[2];//牌号
		String coilWthMin = queryParams[3];//宽度最小值
		String coilWthMax = queryParams[4];//宽度最大值
		String coilThkMin = queryParams[5];//厚度最小值
		String coilThkMax = queryParams[6];//厚度最大值
		String curLoadLoc = queryParams[7];//垛位
		String coilNo = queryParams[8];//钢卷号
		String ordNo = queryParams[9];//订单号
		String ordFl = queryParams[11];//订单区分
		String devlmtDate = queryParams[12];//交货期
		String progCd = queryParams[13];//进程状态
		String smpSendTime = queryParams[14];//送样时间
		String prodnmCd = queryParams[15];//产品类型

		String sql = XmlSqlParsersFactory.getSql("UIM010160_02.SELECT");
		
		
		cro = this.getDao("KgDao").ExcuteQuery(sql,new Object[]{coilNo,specStlGrd,curLoadLoc,
				coilThkMin,coilThkMax,coilWthMin,coilWthMax,startTime,endTime,ordNo,progCd,
				devlmtDate,smpSendTime,prodnmCd,ordFl});

		return cro;
	}
}