package com.steering.mes.zgmil.report;

import java.util.ArrayList;

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

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

public class FrmPerforationReport extends DBCommon{

	/**
	 * 查询
	 * @param parm
	 * @return
	 */
	public CoreReturnObject doQueryData(ArrayList<String> parm,String[] plineCode)
	{
		String sql  = CoreXmlSqlParsersFactory.getSql("FrmPerforationReport.doQueryData");
		sql += CoreConverter.toSqlConditionString("T2.PLINE_CODE", plineCode);	    
		sql += " GROUP BY T2.LOT_NO,T.JUDGE_STOVE_NO,T.PLINE_CODE,T1.STEELNAME,T1.GRADENAME,T.CAPILLARY_SIZE,T.AMOUNT_OF_BORAX,T.BORAX_PRESSURE,";
		sql += " T.HEAD_DIAMETER,T.DP_GG,T.ZG_ZJ,T.BITE_ANGLE,T.ZG_LOCA_UP,T.ZG_LOCA_DOWN,T.DB_LOCA,T.ROLL_MOTOR_SJB,T.ROLL_MOTOR_SPEED,T2.SCRAP_REASON,T2.STATUS,t2.END_PERFORATION_TIME,t2.COL_SHIFT,t2.COL_GROUP,t2.COL_USER,T.REMARK,";
		sql += " T.ROLLER_SPACE,T.GUIDE_SPACE,T.FRONT_EXTENDING_QUANTITY,T.KZ_TEMP,T.GUIDE_DISC_MOTOR_LOCA,T.DT_CODE,T.ZG_LOCA_UP,T.ZG_LOCA_DOWN";
		sql += " ORDER BY t2.END_PERFORATION_TIME ASC";
		return this.getData(sql, parm.toArray());
	}
}
