package UIM;

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

import UIB.COM.XmlSqlParsersFactory;

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

/**
 * 冷轧成品库库存二级库存数据查询
 * @author wl
 * @date 2015-05-18
 */
public class UIM010233 extends CoreIComponent {
	/**
	 * 查询成品库库存数据
	 * @param list 参数集
	 * @return CoreReturnObject
	 * @throws SQLException
	 */
	public CoreReturnObject queryerjiYardList(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[3];//钢卷号
		String wanggou_yn = queryParams[4];//是否网购卷
		//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_06.SELECT");
		cro = this.getDao("KgDao").ExcuteQuery(sql,new Object[]{coilNo,specStlGrd,startTime,endTime,wanggou_yn});
		return cro;
	}
	public CoreReturnObject queryerjizhiliang(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 coilNo = queryParams[3];//钢卷号
		String wanggou_yn = queryParams[4];//是否网购卷

		String sql = XmlSqlParsersFactory.getSql("UIM010232_07.SELECT");
		cro = this.getDao("KgDao").ExcuteQuery(sql,new Object[]{coilNo,specStlGrd,startTime,endTime,wanggou_yn});
		return cro;
	}
	/**
	 * 查询热轧成品库库存数据
	 * @param list 参数集
	 * @return CoreReturnObject
	 * @throws SQLException
	 * KM
	 */
	public CoreReturnObject queryerjiYardListRZ(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 coilNo = queryParams[3];//钢卷号
		String wanggou_yn = queryParams[4];//是否网购卷
		//String coilWthMin = queryParams[3];//宽度最小值
		//String coilWthMax = queryParams[4];//宽度最大值
		//String coilThkMin = queryParams[5];//厚度最小值
		//String coilThkMax = queryParams[6];//厚度最大值
		//String curLoadLoc = queryParams[7];//垛位
		//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_RZ.SELECT");
		cro = this.getDao("KgDao").ExcuteQuery(sql,new Object[]{coilNo,specStlGrd,startTime,endTime,wanggou_yn});
		return cro;
	}
	/**
	 * 查询热轧成品库库存数据质量信息
	 * @param list 参数集
	 * @return CoreReturnObject
	 * @throws SQLException
	 * KM
	 */
	public CoreReturnObject queryerjizhiliangRZ(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 coilNo = queryParams[3];//钢卷号
		String wanggou_yn = queryParams[4];//是否网购卷
		
		String sql = XmlSqlParsersFactory.getSql("UIM010232_RZZL.SELECT");
		cro = this.getDao("KgDao").ExcuteQuery(sql,new Object[]{coilNo,specStlGrd,startTime,endTime,wanggou_yn});
		return cro;
	}
}