package xin.glue.ui.B.B02;

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;

//界面--UIB020221
public class ReturnSelectResult extends PosActivity {
	
	public String runActivity(PosContext context) 
	{	
		String slh="";  //上炉号
		String xlh="";  //下炉号
		int rn=0;       //行号
		String [] CHNO=(String[])context.get("CHNO");  //获取传过来的炉号参数
		if(CHNO.length<=0)
			return PosBizControlConstants.SUCCESS;
		
		PosParameter param  =  new PosParameter();
		param.setWhereClauseParameter(0,CHNO[0]);
		PosRowSet rowSet = getDao("mesdao").find("UIB020221_01.RETURNSELECT",param);
		if(rowSet.hasNext())
		{
			PosRow	rsRow=rowSet.next();
			rn= Integer.parseInt(rsRow.getAttribute("RN").toString());    //获得指定炉号行号
		}
		
		PosParameter param1  =  new PosParameter();
		param1.setWhereClauseParameter(0,rn+1);
		PosRowSet rowSet1 = getDao("mesdao").find("UIB020221_02.RETURNSELECT",param1);
		if(rowSet1.hasNext())
		{
			PosRow	rsRow1=rowSet1.next();
			xlh=(String)rsRow1.getAttribute("CHARGE_NO").toString();   //获得下炉号
		}
		if(rn==1)                                             //上炉号的处理
			slh="";
		else
		{
			PosParameter param2  =  new PosParameter();
			param2.setWhereClauseParameter(0,rn-1);
			PosRowSet rowSet2 = getDao("mesdao").find("UIB020221_02.RETURNSELECT",param2);
			if(rowSet2.hasNext())
			{
				PosRow	rsRow2=rowSet2.next();
				slh=(String)rsRow2.getAttribute("CHARGE_NO").toString();
			}
		}
		Map map2 = new HashMap();
		List list = new ArrayList();
		map2.put("SLH",slh);
		map2.put("XLH",xlh);
		list.add(map2);
		context.put("LHResult", list );
		return PosBizControlConstants.SUCCESS;
	}
}