XinYu_RZMES/.svn/pristine/07/07cf6cf6dd4e479c40d95fd930c30162a7736486.svn-base

package xin.glue.nui.G.G04;

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

public class SlabStoreLayMgr extends PosActivity {

	public String runActivity(PosContext context) {
		
		String[] V_YARD_ADDR    	= new String[25];
		String[] V_STORELAY   		= new String[25];
		String[] V_SLAB_NO    		= new String[25];
		String[] V_BEF_STORE_LOC    = new String[25];
		String[] V_CR_NO    		= new String[25];
		String[] V_REG_ID   		= new String[25];
		String[] V_REG_DTIME    	= new String[25];
		String[] V_ORD_FLAG    		= new String[25];
		
		int i = 0;
		PosMessage message = context.getMessage();
		String YARD_ADDR    = (String)message.get("YARD_ADDR"); 
		
		PosParameter param = new PosParameter();
		param.setWhereClauseParameter(0, YARD_ADDR);
		PosRowSet ordStsVO = getDao("mesdao").find("NIG040200_SLAB_YARD.select", param); 
		while(ordStsVO.hasNext()){
			PosRow ordStsRow 	= ordStsVO.next();
			V_YARD_ADDR[i] 		= (String)ordStsRow.getAttribute("YARD_ADDR");
			V_STORELAY[i] 		= (String)ordStsRow.getAttribute("STORELAY");
			V_SLAB_NO[i] 		= (String)ordStsRow.getAttribute("SLAB_NO");
			V_BEF_STORE_LOC[i] 	= (String)ordStsRow.getAttribute("BEF_STORE_LOC");
			V_CR_NO[i] 			= (String)ordStsRow.getAttribute("CR_NO");
			V_REG_ID[i] 		= (String)ordStsRow.getAttribute("REG_ID");
			V_REG_DTIME[i] 		= (String)ordStsRow.getAttribute("REG_DTIME");
			V_ORD_FLAG[i] 		= (String)ordStsRow.getAttribute("ORD_FLAG");
			
			i++;
		}
		
		for(int j=0 ; j<V_YARD_ADDR.length ; j++){
			
			String storelay = "";
			if(j<9)storelay = "0" + (j+1); 
			else storelay = (j+1)+"";
			
			param = new PosParameter();
			
			if(V_YARD_ADDR[j] == null){
				param.setWhereClauseParameter(0, YARD_ADDR);
				param.setWhereClauseParameter(1, storelay);
				
				int yardClearCnt = getDao("mesdao").update("NIG040200_SLAB_YARD_CLEAR.update", param);
			}
			
			param = new PosParameter();
			param.setWhereClauseParameter(0, V_SLAB_NO[j]);
			param.setWhereClauseParameter(1, V_BEF_STORE_LOC[j]);
			param.setWhereClauseParameter(2, V_CR_NO[j]);
			param.setWhereClauseParameter(3, V_REG_ID[j]);
			param.setWhereClauseParameter(4, V_REG_DTIME[j]);
			param.setWhereClauseParameter(5, V_ORD_FLAG[j]);
			param.setWhereClauseParameter(6, V_YARD_ADDR[j]);
			param.setWhereClauseParameter(7, storelay);
			
			int yardCnt = getDao("mesdao").update("NIG040200_SLAB_YARD.update", param);
			
			param = new PosParameter();
			param.setWhereClauseParameter(0, V_YARD_ADDR[j]+storelay);
			param.setWhereClauseParameter(1, V_SLAB_NO[j]);
			
			int commCnt = getDao("mesdao").update("NIG040200_SLAB_COMM.update",param);
			
			logger.logInfo("----------------------yardCnt--" + yardCnt + "----------commCnt--"+commCnt);
		}
		return PosBizControlConstants.SUCCESS;
	}

}