package com.steering.mes.zgmil.report;

import java.util.ArrayList;

import CoreFS.SA06.CoreReturnObject;
import CoreFS.SA08.CoreXmlSqlParsersFactory;

import com.steering.comm.converter.CoreConverter;
import com.steering.comm.db.DBCommon;

public class FrmSizingReport extends DBCommon{

	/***
	 * 查询
	 * @param parm
	 * @return
	 */
	public CoreReturnObject doQueryData(ArrayList<String> parm,String[] plineCode)
	{
		String sql = CoreXmlSqlParsersFactory.getSql("FrmSizingReport.doQueryData");
		sql += CoreConverter.toSqlConditionString("T2.PLINE_CODE", plineCode);
		sql += " GROUP BY T2.LOT_NO,T.JUDGE_STOVE_NO ,T1.GRADENAME,T.PIPE_SIZE,T.HOST_ELE_SPEED1,T.FOLD_ELE_SPEED1,T.ENTRANCE_SPEED,T.EXIT_SPEED,T.ENTRANCE_TEMP,T.EXIT_TEMP,T.PLINE_CODE,";
		sql += " T.PASS_SERIES,T.FINISH_ROLL_NUM,T.PRODUCT_SIZE,T2.SCRAP_REASON,T2.STATUS,T2.END_SIZING_TIME,T2.COL_SHIFT,T2.COL_GROUP,T2.COL_USER,T.REMARK,  T.EXIT_TEMP2," +
				" T.EXIT_TEMP3";
		sql += " ORDER BY T2.END_SIZING_TIME ASC";
		return this.getData(sql, parm.toArray());
	}
}
