package xin.glue.ui.B.B02;

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;

/**
 * 
 * @Description  替代钢号（此处为厂内钢号）成分查询{界面ID:UIB020050}
 * @author       梅贵平{meiguiping}
 * @date         2009-2-4 下午04:00:07
 * @JDK Version  jdk1.4.2
 */
public class FindModGrdChem extends PosActivity
{

	public String runActivity(PosContext context)
	{
		///ready
		PosGenericDao	dao		=	this.getDao("mesdao");
		PosParameter	param	=	null;
		PosRowSet		rowset	=	null;
		PosRow			row		=	null;
		MutilConditionFind	mcf	=	new MutilConditionFind();
		
		///get request data
		String[]	BEFSTLGRD	=	(String[])context.get("BEFSTLGRD");//厂内钢号
		
		param	=	new	PosParameter();
		param.setWhereClauseParameter(0, BEFSTLGRD[0]);
		rowset	=	dao.find("UIB020050_03.SELECT", param);
		context.put("ModChemNm", rowset);
		
		///loop
		String	repl	=	mcf.getQuerySql("UIB020050_04.LOOP").toString();
		String	temp	=	"";
		StringBuffer sb	=	new StringBuffer(400);
		int 	j		=	1;
		while(rowset.hasNext())
		{
			row		=	rowset.next();
			temp	=	repl.replaceAll("[{]+[0]+[}]+", row.getAttribute("CHEM_CD").toString());
			temp	=	temp.replaceAll("[{]+[1]+[}]+", new Integer(j++).toString());
			sb.append(temp);
		}
		
		String	sql	=	mcf.getQuerySql("UIB020050_04.SELECT").toString().replaceFirst("[{]+[1]+[}]+", sb.toString());
		param		=	new PosParameter();
		param.setWhereClauseParameter(0, BEFSTLGRD[0]);
		rowset		=	dao.findByQueryStatement(sql , param);
		context.put("ModGrid", rowset);
		
		return PosBizControlConstants.SUCCESS;
	}

}