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; /** * @Description 改变样片现状,使其从进入入库待机进入检验待机状态{界面ID:UIB020110} * @author 梅贵平{meiguiping} * @date 2008-10-31 下午06:09:54 * @JDK Version jdk1.4.2 */ public class ChangeLotActuality extends PosActivity { public String runActivity(PosContext context) { String[] REG_NM = (String[])context.get("REG_NM");//登录人 String[] SMP_NO = (String[])context.get("SMP_NO"); //试样号 String[] SMP_CUT_LOC = (String[])context.get("SMP_CUT_LOC");//获得状态,如入库待机为B String[] CHK = (String[])context.get("CHK"); String[] rowStatus = (String[])context.get("rowStatus"); //状态 //获得要更新的次数,因为在两个表中,试样号肯定都会存在,所以以它做为循环条件 if(rowStatus == null) return PosBizControlConstants.SUCCESS; int iCount = rowStatus.length; PosParameter param = null;//对TBB02_LOT_COM的更新 PosGenericDao dao = this.getDao("mesdao"); for(int i=0; i < iCount; i++) { //更新TBB02_LOT_COM表中满足条件的试样的状态,从B到C,即从入库待机进入检验待机状态 if("Y".equals(CHK[i])) { param = new PosParameter(); param.setWhereClauseParameter(0, REG_NM[0]); param.setWhereClauseParameter(1, SMP_NO[i]); param.setWhereClauseParameter(2, SMP_CUT_LOC[i]); dao.update("UIB020110_01.UPDATE" , param); param = new PosParameter(); param.setWhereClauseParameter(0, SMP_NO[i]); param.setWhereClauseParameter(1, SMP_CUT_LOC[i]); dao.update("UIB020110_02.UPDATE", param); } } return PosBizControlConstants.SUCCESS; } }