package xin.glue.ui.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;

/*
 *  
 * 
 * @author tangliang
 * @date 2008.11.03
 */

public class DeleteCrCommand extends PosActivity{
	
	public String runActivity(PosContext context)
	{
		 
	 
		String[] SEQ_NO = (String[])context.get("SEQ_NO"); 
		 
		PosParameter param1 = new PosParameter();
		param1.setWhereClauseParameter(0, SEQ_NO[0]); 
		PosRowSet CrCmdVO = getDao("mesdao").find("UIG040041_04.select", param1);
		
		String FromAddr = null;
		String SlabNo = null;
		
	    if (CrCmdVO.hasNext()) {
	      PosRow CrCmdROW = CrCmdVO.next(); 
	      FromAddr = (String)CrCmdROW.getAttribute("FROM_ADDR");
	      SlabNo   = (String)CrCmdROW.getAttribute("ORD_SLAB_NO1");
	      
	      
	      PosParameter param2 = new PosParameter();
	      param2.setValueParamter(0, "");
	      param2.setValueParamter(1, SlabNo);
	      param2.setValueParamter(2, FromAddr);
	      getDao("mesdao").update("UIG040041_01.update", param2);
	      
	      //when delete crane command set tbg02_charge_comm 'MILL_SCH_STAT' to "" 
	      PosParameter param3 = new PosParameter();
	      param3.setValueParamter(0, "");
	      param3.setValueParamter(1, SlabNo);
	      getDao("mesdao").update("UIG040042_SLAB_COMM.update", param3);
	      
          //  Crane Command set  'CRD' TO  CUR_LOAD_LOC column  of TBG02_SLAB_COMM  
		 
			
	    }
	    
		PosParameter param3 = new PosParameter();
		   
		param3.setValueParamter(0, SEQ_NO[0]);
		 
		getDao("mesdao").update("UIG040041_01.delete", param3);
		 
		 
		return PosBizControlConstants.SUCCESS;
	}

}