package xin.glue.ui.B.B03;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.SortedMap;

import com.posdata.glue.biz.activity.PosActivity;
import com.posdata.glue.biz.constants.PosBizControlConstants;
import com.posdata.glue.context.PosContext;
import com.posdata.glue.dao.PosGenericDao;
import com.posdata.glue.dao.vo.PosParameter;
import com.posdata.glue.dao.vo.PosRow;
import com.posdata.glue.dao.vo.PosRowSet;

public class GetLH extends PosActivity{
	
	public String runActivity(PosContext context)
	{
		String slh="";
		String xlh="";
		String [] BPNO=(String[])context.get("BPNO");  //获取传过来的炉号参数
		if(BPNO.length<=0)
			return PosBizControlConstants.SUCCESS;
		PosParameter param  =  new PosParameter();
		param.setWhereClauseParameter(0,BPNO[0]);
		PosRowSet rowSet = getDao("mesdao").find("UIB030351_02.SELECT",param);
		if(rowSet.hasNext())
		{
			PosRow	rsRow=rowSet.next();
			slh= rsRow.getAttribute("SLAB_NO").toString();    //获得上一个板坯
			//System.out.println("################"+slh+"#########");
		}
 
		PosParameter param1  =  new PosParameter();
		param1.setWhereClauseParameter(0,BPNO[0]);
		PosRowSet rowSet1 = getDao("mesdao").find("UIB030351_03.SELECT",param1);
		if(rowSet1.hasNext())
		{
			PosRow	rsRow1=rowSet1.next();
			xlh= rsRow1.getAttribute("SLAB_NO").toString();    //下一个板坯
			//System.out.println("################"+xlh+"#########");
		}
 
		PosRowSet rowSets=null;
		PosParameter params  =  new PosParameter();
		params.setWhereClauseParameter(0,slh);
		rowSets=getDao("mesdao").find("UIB030351_04.SELECT",params);  //上一炉的成分
		context.put("SResult",rowSets);
		
		PosRowSet rowSetz=null;
		PosParameter paramz  =  new PosParameter();
		paramz.setWhereClauseParameter(0,BPNO[0]);
		rowSetz=getDao("mesdao").find("UIB030351_04.SELECT",paramz);  //当前炉的成分
		context.put("ZResult",rowSetz);
		
		PosRowSet rowSetx=null;
		PosParameter paramx  =  new PosParameter();
		paramx.setWhereClauseParameter(0,xlh);
		rowSetx=getDao("mesdao").find("UIB030351_04.SELECT",paramx);   //下一炉的成分
		context.put("XResult",rowSetx);
		return PosBizControlConstants.SUCCESS;
	}
}