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 FrmRollingReport extends DBCommon{

	/***
	 * 查询
	 * @param parm
	 * @return
	 */
	public CoreReturnObject doQueryData(ArrayList<String> parm,String[] plineCode)
	{
		String sql = CoreXmlSqlParsersFactory.getSql("FrmRollingReport.doQueryData");
		sql += CoreConverter.toSqlConditionString("T2.PLINE_CODE",plineCode);
		sql += " GROUP BY T2.LOT_NO,T.JUDGE_STOVE_NO,T1.STEELNAME,T1.GRADENAME, T.TUBESIZE,T.LIMIT_SPEED,T.RACK_SPEED1,T.RACK_SPEED2,T.RACK_SPEED3,T.PLINE_CODE,";
		sql += " T.RACK_SPEED4,T.RACK_SPEED5,T.RACK_SPEED6,T.RACK_SPACE1,T.RACK_SPACE2,T.RACK_SPACE3,T.RACK_SPACE4,T.RACK_SPACE5,T.RACK_SPACE6,T.EXT1_RACK_SPEED,T2.SCRAP_REASON,T2.STATUS,T2.END_ROLLING_TIME,T2.COL_SHIFT,T2.COL_GROUP,T2.COL_USER,T2.END_ROLLING_TIME,T.REMARK,";
		sql += " t.vrs_speed,t.INSERT_LENGTH,t.ROLLING_FORCE1,t.ROLLING_FORCE2,t.ROLLING_FORCE3,t.ROLLING_FORCE4,t.ROLLING_FORCE5,t.ROLLING_FORCE6,t.ROLLING_FORCE7";
		sql += " ORDER BY T2.END_ROLLING_TIME ASC";
	    return this.getData(sql, parm.toArray());	
	}
}
