package xin.glue.ui.H.H05;

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;
/************
 * 预装车取消功能，便于业务操作。
 * 回退功能
 * *************/

public class CancelCoilResultYZC extends PosActivity{
	public String runActivity(PosContext context){
		//行状态
		String[] rowStuts = (String[]) context.get("rowStuts");
		//钢卷号
		String[] OLD_SAMPL_NO = (String[]) context.get("OLD_SAMPL_NO");
		//钢卷重量
		String[] ACT_WGT = (String[]) context.get("ACT_WGT");
		//预装车标志位
		String[] CHK = (String[]) context.get("CHK");
		//录入人
		String[] REG_ID = (String[]) context.get("REG_ID");
		//垛位
		String[] CUR_LOAD_LOC = (String[]) context.get("CUR_LOAD_LOC");
		
		String coil_no = null;
		
		for(int i=0;i<rowStuts.length;i++){
			if(CHK[i].equals("Y")){
				//如果是选中预装车的行，就改变卷的状态信息。清空垛位
				PosParameter param1 = new PosParameter();
				param1.setWhereClauseParameter(0, ACT_WGT[i]);
				param1.setWhereClauseParameter(1, REG_ID[0]);
				param1.setWhereClauseParameter(2, CUR_LOAD_LOC[i]);
				param1.setWhereClauseParameter(3, OLD_SAMPL_NO[i]);
				
				getDao("mesdao").update("UIH051300_03.update", param1);
				
				//查询此垛位上面是否存在钢卷
				PosParameter param11 = new PosParameter();
				param11.setWhereClauseParameter(0,CUR_LOAD_LOC[i]);
				
				PosRowSet rows = getDao("mesdao").find("UIH051300_03_SELECT", param11);
				
				if(rows.hasNext()){
					PosRow row = rows.next();
					
					coil_no = (String) row.getAttribute("COIL_NO");
					
					if(coil_no == null){
//						清除垛位表信息
						PosParameter param2 = new PosParameter();
						
						param2.setWhereClauseParameter(0, OLD_SAMPL_NO[i]);
						param2.setWhereClauseParameter(1, CUR_LOAD_LOC[i].substring(0, 5));
						param2.setWhereClauseParameter(2, CUR_LOAD_LOC[i].substring(5, 7));
						param2.setWhereClauseParameter(3, CUR_LOAD_LOC[i].substring(7, 8));
						param2.setWhereClauseParameter(4, CUR_LOAD_LOC[i].substring(8, 9));
						
						getDao("mesdao").update("UIH051300_04.update", param2);
					}else{
						logger.logInfo("CancelCoilResultYZC中,垛位"+CUR_LOAD_LOC[i]+"上已经存在钢卷！");
						String vtemp="ERROR";
						context.put("rs", vtemp);
					}
				}
				
				
			}
		}
		
		return PosBizControlConstants.SUCCESS;
	}

}