package UIM.UIM07;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.util.ArrayList;

import UIB.COM.XmlSqlParsersFactory;

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

/**
 * 酸轧上料管理
 * 
 * @author zsx
 * @date 2017-7-26
 */
public class UIM070010 extends CoreIComponent {
	/**
	 * 查询原料库库存数据
	 * 
	 * @param list
	 *            参数集
	 * @return CoreReturnObject
	 * @throws SQLException
	 */
	public CoreReturnObject queryHYardList(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 devlmtDate = queryParams[10];// 交货期
		String progCd = queryParams[11];// 进程状态
		
		
		
		String smptime = queryParams[12];// 牌号
		String isspm = queryParams[13];// 宽度最小值
		String xsqy = queryParams[14];// 宽度最大值
		String cpcoil = queryParams[15];// 厚度最小值
		String dlivtp = queryParams[16];// 厚度最大值
		String prodline = queryParams[17];// 垛位
		String ordxz = queryParams[18];// 钢卷号
		String rollmin = queryParams[19];// 订单号
		String rollmax = queryParams[20];// 订单区分
		

			String sql = XmlSqlParsersFactory.getSql("UIM070010_01.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(
					sql,
					new Object[] { startTime, endTime, specStlGrd, coilWthMin, coilWthMax, 
		                    coilThkMin, coilThkMax, curLoadLoc, coilNo, ordNo, devlmtDate, progCd,
		                    smptime,  isspm,xsqy, cpcoil,dlivtp, prodline,ordxz,rollmin,rollmax } );
			return cro;
		

	}
	
	public CoreReturnObject queryHYardListCount(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 devlmtDate = queryParams[10];// 交货期
		String progCd = queryParams[11];// 进程状态
		
		
		
		String smptime = queryParams[12];// 牌号
		String isspm = queryParams[13];// 宽度最小值
		String xsqy = queryParams[14];// 宽度最大值
		String cpcoil = queryParams[15];// 厚度最小值
		String dlivtp = queryParams[16];// 厚度最大值
		String prodline = queryParams[17];// 垛位
		String ordxz = queryParams[18];// 钢卷号
		String rollmin = queryParams[19];// 订单号
		String rollmax = queryParams[20];// 订单区分
		

			String sql = XmlSqlParsersFactory.getSql("UIM070010_02.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(
					sql,
					new Object[] { startTime, endTime, specStlGrd, coilWthMin, coilWthMax, 
		                    coilThkMin, coilThkMax, curLoadLoc, coilNo, ordNo, devlmtDate, progCd,
		                    smptime,  isspm,xsqy, cpcoil,dlivtp, prodline,ordxz,rollmin,rollmax } );
			return cro;
		

	}
	public CoreReturnObject queryHYardSpm(ArrayList list) throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String[] queryParams = (String[]) list.get(0);
		String startTime = queryParams[0];// 入库开始时间
		String endTime = queryParams[1];// 入库结束时间
		
		

			String sql = XmlSqlParsersFactory.getSql("UIM070050_01.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(
					sql,
					new Object[] { startTime, endTime} );
			return cro;
		

	}
	
	public CoreReturnObject queryHYardSpmdETAL(ArrayList list) throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String[] queryParams = (String[]) list.get(0);
		String startTime = queryParams[0];// 入库开始时间
		String endTime = queryParams[1];// 入库结束时间
		String coilno = queryParams[2];// 入库开始时间
		String ord_no = queryParams[3];// 入库结束时间
		

			String sql = XmlSqlParsersFactory.getSql("UIM070060_01.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(
					sql,
					new Object[] { coilno,ord_no,startTime, endTime} );
			return cro;
		

	}
}