XinYu_LZMES/.svn/pristine/4f/4f0c748295a9a87e053d1e8e02d70272874d79b8.svn-base

package UIM;

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

import UIB.COM.XmlSqlParsersFactory;

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

/**
 * 冷轧成品库库存数据查询
 * @author siy
 * @date 2011-08-08
 */
public class UIM010232 extends CoreIComponent {
	/**
	 * 查询成品库库存数据
	 * @param list 参数集
	 * @return CoreReturnObject
	 * @throws SQLException
	 */
	public CoreReturnObject queryYardList(ArrayList<Object> 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("UIM010232_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 queryYardListfjh(ArrayList<Object> 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("UIM010232_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;
	}
	public CoreReturnObject queryPackList(ArrayList<Object> 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 coilNo = queryParams[0];//钢卷号
		String sql = XmlSqlParsersFactory.getSql("UIM010232_03.SELECT");
		
		
		cro = this.getDao("KgDao").ExcuteQuery(sql,new Object[]{coilNo});

		return cro;
	}
	
	public CoreReturnObject queryPackwaitList(ArrayList<Object> 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 coilNo = queryParams[0];//钢卷号
		String sql = XmlSqlParsersFactory.getSql("UIM010232_04.SELECT");
		
		
		cro = this.getDao("KgDao").ExcuteQuery(sql,new Object[]{coilNo});

		return cro;
	}
}