package xin.glue.ui.B.B01;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;

import xin.glue.ui.B.B02.MutilConditionFind;

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 FindSpecStatus extends PosActivity
{
	public String runActivity(PosContext context)
	{
		
		String[] ABBSYM;
		PosParameter param = null;
		PosRowSet tempRowSet1 = null;
		PosRow tempRow1 = null;
		PosRowSet tempRowSet2 = null;
		PosRow tempRow2 = null;
		List list = null;
		Map map = null;	
		
		ABBSYM = (String[])context.get("ABBSYM");
		param = new PosParameter();
		param.setWhereClauseParameter(0, ABBSYM[0]);
		
		tempRowSet1 = this.getDao("mesdao").find("UIB010340.SELECT", param);
		list = new ArrayList();
		while(tempRowSet1.hasNext())
		{
			tempRow1 = tempRowSet1.next();
			map = tempRow1.getAttributes();
			String FLAG = (String)tempRow1.getAttribute("FLAG");
			if(FLAG.equals("2"))  //当有订单执行此标准，且该标准没有录入完整时
			{	
				param = new PosParameter();
				param.setWhereClauseParameter(0, tempRow1.getAttribute("SPEC_ABBSYM"));
				param.setWhereClauseParameter(1, tempRow1.getAttribute("SPEC_STL_GRD"));
				tempRowSet2 = this.getDao("mesdao").find("UIB010340.ORD.SELECT", param);
				StringBuffer ORD = new StringBuffer();
				while(tempRowSet2.hasNext())
				{
					tempRow2 = tempRowSet2.next();
					ORD.append((String)tempRow2.getAttribute("ORD")+"   ");
				}
				map.put("ORD", ORD);
			}
			else
			{
				map.put("ORD", " ");
			}
			
			list.add(map);
		}
		context.put("SPEC_STATUS_RESULTS", list);
		return PosBizControlConstants.SUCCESS;
	}



}