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-12
 */
public class UIM010060 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];// 钢卷号1
		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 outType = queryParams[18];// 出库类型
		String coilNo2 = queryParams[19];//钢卷号
		String deldatefr = queryParams[20];// 交货期开始
		String deldateto = queryParams[21];//交货期结束
		String yardtype = queryParams[22];//交货期结束
		String sql = "";

		// 入库记录
		if (0 == queryType.intValue()) {
			sql = XmlSqlParsersFactory.getSql("UIM010060_01.SELECT");
		} else {// 出库记录
			sql = XmlSqlParsersFactory.getSql("UIM010060_02.SELECT");
		}

		cro = this.getDao("KgDao").ExcuteQuery(
				sql,
				new Object[] { startTime, endTime, coilNo,coilNo1, coilWthMin,
						coilWthMax, coilThkMin, coilThkMax, curLoadLoc,
						specStlGrd, shift, group, regId, ordNo, ordSeq, custCd,
						ordFl, prodnmCd, outType,coilNo2,deldatefr,deldateto,yardtype});

		return cro;
	}

	/**
	 * 查询收货单位
	 * 
	 * @return CoreReturnObject
	 * @throws SQLException
	 */
	public CoreReturnObject queryCustomers() throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();

		String sql = "SELECT T.CUST_CD VALUE,T.CUST_NM LABEL FROM TBZ00_CUSTOMER T WHERE T.REC_TP='02' order by T.CUST_NM";
		ArrayList list = (ArrayList) this.getDao("KgDao")
				.ExcuteQueryReturnList(sql, new Object[] {});
		cro.setResult(list);

		return cro;
	}
}