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.PosRowSet;

/**
 * 
 * @Description  {½çÃæID:UIB020172}
 * @author       ÷¹óƽ{meiguiping}
 * @date         2009-7-11 ÏÂÎç07:40:05
 * @JDK Version  jdk1.4.2
 */
public class FindReSmpGrade extends PosActivity
{

	public String runActivity(PosContext context)
	{
		///ready
		PosGenericDao	dao	=	this.getDao("mesdao");
		PosParameter  param	=	new PosParameter();
		PosRowSet	rowset	=	null;
		///param
		String[]SMP_PROG_CD	=	(String[])context.get("SMP_PROG_CD");
		String[]COILNO_1	=	(String[])context.get("COILNO_1");
		String[]COILNO_2	=	(String[])context.get("COILNO_2");
		
		MutilConditionFind mcf	=	new MutilConditionFind();
		int	j				=	0;
		
		StringBuffer	sql			=	mcf.getQuerySql("UIB020172_04.SELECT");
		if(!"".equals(SMP_PROG_CD[0]))
		{
			param.setWhereClauseParameter(j++, SMP_PROG_CD[0]);
			sql.append("\n AND  LCM.SMP_PROG_CD    =    ?");
		}
		else
		{
//			param.setWhereClauseParameter(j++, SMP_PROG_CD[0]);
			sql.append("\n AND  (LCM.SMP_PROG_CD    =   'C' OR   LCM.SMP_PROG_CD    =   'D')");
		}
		if(!"".equals(COILNO_1[0]) && !"".equals(COILNO_2[0]))
		{
			param.setWhereClauseParameter(j++, COILNO_1[0]);
			param.setWhereClauseParameter(j++, COILNO_2[0]);
			sql.append("\n AND  SUBSTR(CCM.OLD_SAMPL_NO ,1,10)  BETWEEN  ?  AND    ?");
		}
		sql.append("\n ORDER BY      CCM.OLD_SAMPL_NO ");
		rowset	=	dao.findByQueryStatement(sql.toString(), param);
		context.put("RESmpResult", rowset);
		return PosBizControlConstants.SUCCESS;
	}

}