XinYu_LZMES/.svn/pristine/01/015ef3f1bae732a387d93cabf07083e4f625c2ed.svn-base

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-13
 */
public class UIM010140 extends CoreIComponent {
	/**
	 * 查询钢卷出入库记录
	 * @param queryType 查询类型 0 入库 1出库
	 * @param list 参数集
	 * @return CoreReturnObject
	 * @throws SQLException
	 */
	public CoreReturnObject queryYardList(Integer queryType,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 coilNo1 = queryParams[9];//钢卷号
        String shift = queryParams[10];//班次
        String group = queryParams[11];//班组
        String regId = queryParams[12];//作业人
        String custCd = queryParams[13];//客户编号
        String ordNo = queryParams[14];//订单号
        String ordSeq = queryParams[15];//合同号
        String ordFl = queryParams[16];//订单区分
        String prodnmCd = queryParams[17];//产品类型
        //String coilNo2= queryParams[18];//
        String deldatefr = queryParams[19];//订单交货期开始时间
        String deldateto = queryParams[20];//交货期结束时间
        String line = queryParams[21];//交货期结束时间
        String sql = "";
        
        if("D".equals(line))//代加工酸洗
        {
        	 
        	line="S";
        	//入库记录
            if(0 == queryType.intValue()){
            	sql = XmlSqlParsersFactory.getSql("UIM010140_03.SELECT");
            }
            else{//出库记录
            	sql = XmlSqlParsersFactory.getSql("UIM010140_04.SELECT");
            }
    		
    		cro = this.getDao("KgDao").ExcuteQuery(sql,new Object[]{startTime, endTime, coilNo, coilNo1,coilWthMin, coilWthMax, 
                    coilThkMin, coilThkMax, curLoadLoc, specStlGrd, shift, group, regId, custCd, ordNo, ordSeq,
                    ordFl, prodnmCd,deldatefr,deldateto,line});

    		return cro;	
        }
        else//酸轧
        {
        //入库记录
        if(0 == queryType.intValue()){
        	sql = XmlSqlParsersFactory.getSql("UIM010140_01.SELECT");
        }
        else{//出库记录
        	sql = XmlSqlParsersFactory.getSql("UIM010140_02.SELECT");
        }
		
		cro = this.getDao("KgDao").ExcuteQuery(sql,new Object[]{startTime, endTime, coilNo, coilNo1,coilWthMin, coilWthMax, 
                coilThkMin, coilThkMax, curLoadLoc, specStlGrd, shift, group, regId, custCd, ordNo, ordSeq,
                ordFl, prodnmCd,deldatefr,deldateto,line});

		return cro;
        }
	}
}