XinYu_RZMES/.svn/pristine/24/2466c44cf2c0a8591bc76129f447e487a2c86375.svn-base

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:UIB020160}
 * @author       梅贵平{meiguiping}
 * @date         2008-12-23 下午07:25:52
 * @JDK Version  jdk1.4.2
 */
public class FindUnqualifiedCoil extends PosActivity
{

	public String runActivity(PosContext context)
	{
		String[]	SMP	=	(String[])context.get("SMP");
		String[]	SEQ	=	(String[])context.get("SEQ");
		String[]	PROG=	(String[])context.get("PROG");//式样进度代码，包括不合格试样和手动判定试样
//		String[]	COILNO	=	(String[])context.get("COILNO");
		
		PosParameter	param	=	new PosParameter();
		PosGenericDao	dao		=	this.getDao("mesdao");
		MutilConditionFind mcf	=	new MutilConditionFind();
		
		//获得无条件查询的SQL语句
		StringBuffer	sql	=	mcf.getQuerySql("UIB020160_01.SELECT");
		int j	=	0;
		//若试样号不为空则做为查询条件
		if((SMP[0]+SEQ[0]).length() == 15)
		{
			sql.append(" \n AND	B.SMP_NO	=	?");
			param.setWhereClauseParameter(j++, SMP[0]+SEQ[0]);
		}
		
		if("1".equals(PROG[0]))//手工判定试样
		{
			sql.append("\n AND B.QLTY_MAN_INS_TP = 'Y'");
		}
		else if("2".equals(PROG[0]))//不合格试样号，不包括手工判定试样
		{
			sql.append("\n AND  C.MATLQLTY_DEC_GRD =  '2'");
		}
		else
		{
			sql.append("\n AND ( C.MATLQLTY_DEC_GRD =  '2'  OR  B.QLTY_MAN_INS_TP = 'Y')" );
		}
		//若钢卷号不为空，则做为查询条件
//		if(!"".equals(COILNO[0]))
//		{
//			sql.append(" \n AND	 A.COIL_NO	=	?");
//			param.setWhereClauseParameter(j++, COILNO[0]);
//		}
		//查询
		PosRowSet	rowset	=	 dao.findByQueryStatement(sql.toString() , param);
		context.put("LotInfoResult", rowset);
		//push into context
		return PosBizControlConstants.SUCCESS;
	}
}