package xin.glue.ui.D.D02;

//import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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.vo.PosParameter;
import com.posdata.glue.dao.vo.PosRow;
import com.posdata.glue.dao.vo.PosRowSet;

public class SearchSrcSlabDnRst extends PosActivity
{

	public String runActivity(PosContext context)
	{
		String[]    FrDevlmtDate          =    (String[])context.get("FrDevlmtDate"    ) ;
		String[]    ToDevlmtDate          =    (String[])context.get("ToDevlmtDate"    ) ;
		
		String[]    FACSTLGEP          =    (String[])context.get("FACSTLGEP"    ) ;
		String[]    FACSTLGED          =    (String[])context.get("FACSTLGED"    ) ;
		String[]    SALABWTH1         =    (String[])context.get("SALABWTH"    ) ;
		String[]    SALABWTH2          =    (String[])context.get("SALABWTH"    ) ;
		String[]    FrCoilThk          =    (String[])context.get("FrCoilThk"    ) ;
		String[]    ToCoilThk          =    (String[])context.get("ToCoilThk"    ) ;
		String[]    SlabThk_1		   =	(String[])context.get("SlabThk_1");
		String[]	SlabThk_2		   =	(String[])context.get("SlabThk_2");
		
		PosParameter param0 = new PosParameter();
	   // param0.setWhereClauseParameter(0, FrDevlmtDate[0]); 
	    //param0.setWhereClauseParameter(1, ToDevlmtDate[0]);
	    param0.setWhereClauseParameter(0, FACSTLGEP[0]);
	    param0.setWhereClauseParameter(1, FACSTLGED[0]);
	    param0.setWhereClauseParameter(2, SALABWTH1[0]);
	    param0.setWhereClauseParameter(3, SALABWTH2[0]);
	    param0.setWhereClauseParameter(4, FrCoilThk[0]);
	    param0.setWhereClauseParameter(5, ToCoilThk[0]);
	    param0.setWhereClauseParameter(6, SlabThk_1[0]);
	    param0.setWhereClauseParameter(7, SlabThk_2[0]);
	    
	    //param0.setWhereClauseParameter(10, FrDevlmtDate[0]); 
	   // param0.setWhereClauseParameter(11, ToDevlmtDate[0]);
	    param0.setWhereClauseParameter(8, FACSTLGEP[0]);
	    param0.setWhereClauseParameter(9, FACSTLGED[0]);
	    param0.setWhereClauseParameter(10, SALABWTH1[0]);
	    param0.setWhereClauseParameter(11, SALABWTH2[0]);
	    param0.setWhereClauseParameter(12, FrCoilThk[0]);
	    param0.setWhereClauseParameter(13, ToCoilThk[0]);
	    param0.setWhereClauseParameter(14, SlabThk_1[0]);
	    param0.setWhereClauseParameter(15, SlabThk_2[0]);
	    
	    PosRowSet rowSet = getDao("mesdao").find("UID020020.SrcSlabDnRst.Select",param0);
	    
	    PosRow row = null;

	    PosRowSet rowSet2 = null;
		Map map = new HashMap();
		Map map2 = null;
		String ord_no = "";
		String CHEM = "";
		List list = new ArrayList();
		String ord_seq = "";
	    while(rowSet.hasNext())
		{
	    	map2 = new HashMap();
			row = rowSet.next();
		
			map = row.getAttributes();
			ord_no = (String)map.get("ORD_NO");
			ord_seq = (String)map.get("ORD_SEQ");
			PosParameter param1 = new PosParameter();
		    param1.setWhereClauseParameter(0, ord_no); 
		    param1.setWhereClauseParameter(1, ord_seq); 
			
			rowSet2 = getDao("mesdao").find("UID020020.SrcSlabDnRstChem.Select",param1);
			String CHEM2 = "";
			while(rowSet2.hasNext())
			{
				row = rowSet2.next();
				map2 = row.getAttributes();
				CHEM = (String)map2.get("CHEM");
				if(CHEM2 == "")
				{
					CHEM2 = CHEM;
				}
				else
				{
					CHEM2 = CHEM2 +":"+ CHEM;
				}
			}
			map2.putAll(map);
			map2.put("ORD_NO", ord_no);
			map2.put("ORD_SEQ", ord_seq);
			map2.put("CHEM", CHEM2);
			list.add(map2);
			//row.setAttributes(map2);
		}
		
		context.put("ListResult_0", list );
		//UID020020.SrcSlabDnRst.Select
		//ListResult_0
		
		return PosBizControlConstants.SUCCESS;
	}

}