package xin.glue.ui.D.D01;

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

/**
 * 根据不同条件查询板坏设计结果
 *
 * @author 王黎
 * @date 2008-8-22
 */
public class FindSlabDnResult extends PosActivity
{

	public String runActivity(PosContext context)
	{
		// 获取查询条件钢号、通过工序、排列标准、最大板坏宽度、最小板坏宽度、排列顺序

		String[]    sDb_FacStlGrd            =    (String[])context.get("FAC_STL_GRD"      ) ;
		String[]    sDb_ProcPath             =    (String[])context.get("PROC_PATH"        ) ;
		String[]    sDb_SlabWthMin           =    (String[])context.get("SLAB_WTH_MIN"     ) ;
		String[]    sDb_SlabWthMax           =    (String[])context.get("SLAB_WTH_MAX"     ) ;
		String[]    sDb_OrderBy              =    (String[])context.get("ARRAY_NORM"       ) ;
		String[]    sDb_Desc                 =    (String[])context.get("DESC"             ) ;

		PosParameter	param 	= null;
		PosRowSet 		rowSet 	= null;

		PosJdbcDao		dao		=  (PosJdbcDao)getDao("mesdao");
		String			sQuery	=	dao.getQueryManager().getQueryDefinition("SearchSlabDnRst.Select").getQueryStatement();
		StringBuffer 	sbQuery	=	new StringBuffer(sQuery);

		sbQuery.append("\n").append("ORDER SIBLINGS BY ").append( sDb_OrderBy[0] ).append(" ").append( sDb_Desc[0] );

		param	= new PosParameter();
		param.setWhereClauseParameter( 0,	sDb_FacStlGrd[0]	);
		param.setWhereClauseParameter( 1,	sDb_ProcPath[0]		);
		param.setWhereClauseParameter( 2,	sDb_SlabWthMin[0]	);
		param.setWhereClauseParameter( 3,	sDb_SlabWthMax[0]	);

 		rowSet = getDao("mesdao").findByQueryStatement(sbQuery.toString(), param);

		context.put("ListResult_1", rowSet);

		return PosBizControlConstants.SUCCESS;
	}
}