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 saveCoilYardResult extends PosActivity{
	public String runActivity(PosContext context){
		//行状态
		String[] rowStuts = (String[]) context.get("rowStuts");
		//库存位置
		String[] COIL_YARD = (String[]) context.get("YARD");
		//钢卷号
		String[] COIL_NO = (String[]) context.get("COIL_NO");
		//操作人
		String[] REG_ID = (String[]) context.get("REG_ID");
		//入库班次
		String[] YARD_ENTRY_SHIFT = (String[]) context.get("ENTRY_SHIFT");	
		//入库班组
		String[] YARD_ENTRY_GROUP = (String[]) context.get("ENTRY_GROUP");
		//入库人
		String[] YARD_ENTRY_REG = (String[]) context.get("ENTRY_REG");
		//入库时间
		String[] YARD_ENTRY_DTIME = (String[]) context.get("ENTRY_DTIME");
		
		//String user = null;
		//钢卷实际重量 ACT_WGT
		String[] ACT_WGT = (String[]) context.get("ACT_WGT");
		
				
		if(rowStuts != null){
			//循环所有的结果，一个一个的录入表中
			for(int i=0;i<rowStuts.length;i++){
				//进行入库操作
				PosParameter param0 = new PosParameter();
				param0.setWhereClauseParameter(0, COIL_YARD[0]);
				PosRowSet rows = getDao("mesdao").find("UIH050600_05.select", param0);
				if(!rows.hasNext()){
					logger.logInfo("垛位不存在！");
					String vtemp = "COIL_NO";
					context.put("rs", vtemp);
					return PosBizControlConstants.SUCCESS;
				}
				param0 = new PosParameter();
				param0.setWhereClauseParameter(0, COIL_NO[i]);
				
				//入库的限制条件没有
				rows = getDao("mesdao").find("UIH050600_01.select",param0);
				
				if(!rows.hasNext()){
					//抛出异常
					logger.logInfo("saveCoilYardResult类中此钢卷没有轧制完成,或者已经出库");
					String vtemp = "COIL_NO";
					context.put("rs", vtemp);
				}else{
					//钢卷的状态为2的情况下，进行入库操作
					PosParameter param1 = new PosParameter();
					
					param1.setWhereClauseParameter(0, COIL_NO[i]);
					
					PosRowSet rows1 = getDao("mesdao").find("UIH050600_03.select",param1);
					
					if(rows1.hasNext()){
						logger.logInfo("saveCoilYardResult类中此钢卷已在垛位表中存在");
						String vtemp = "COIL_YARD";
						context.put("rs", vtemp);
					}else{
						//把钢卷入库
						PosParameter param2 = new PosParameter();
						
						param2.setWhereClauseParameter(0, COIL_YARD[0]);
						param2.setWhereClauseParameter(1, YARD_ENTRY_SHIFT[0]);
						param2.setWhereClauseParameter(2, YARD_ENTRY_GROUP[0]);
						param2.setWhereClauseParameter(3, YARD_ENTRY_REG[0]);
						param2.setWhereClauseParameter(4, YARD_ENTRY_DTIME[0]);
						param2.setWhereClauseParameter(5, REG_ID[0]);
						param2.setWhereClauseParameter(6, COIL_NO[i]);
						
						getDao("mesdao").update("UIH050600_05.update",param2);
						
						PosParameter param3 = new PosParameter();
						
						param3.setWhereClauseParameter(0, COIL_NO[i]);
						param3.setWhereClauseParameter(1, REG_ID[0]);
						param3.setWhereClauseParameter(2, COIL_YARD[0]);
						param3.setWhereClauseParameter(3, COIL_YARD[0]);
						param3.setWhereClauseParameter(4, COIL_YARD[0]);
						param3.setWhereClauseParameter(5, COIL_YARD[0]);
						
						getDao("mesdao").update("UIH050600_01.update",param3);
						
						Number SEQ = null;
						int SEQ_1 = 0;
						
	//					记录库存移动的情况
						PosParameter param11 = new PosParameter();
						
						PosRowSet rows11 = getDao("mesdao").find("UIH050700_05.select", param11);
						
						if(rows11.hasNext()){
							PosRow row11 = rows11.next();
							
							SEQ = (Number) row11.getAttribute("ROLL_SEQ");
							
							if(null == SEQ){
								SEQ_1 = 1;
							}else{
								SEQ_1 = SEQ.intValue()+1;
							}
							
							//取出主键后，更新移动表
							PosParameter param4 = new PosParameter();
							
							param4.setValueParamter(0, new Integer(SEQ_1));
							param4.setValueParamter(1, "");
							param4.setValueParamter(2, COIL_YARD[0]);
							param4.setValueParamter(3, COIL_NO[i]);
							param4.setValueParamter(4, YARD_ENTRY_REG[0]);
							param4.setValueParamter(5, YARD_ENTRY_SHIFT[0]);
							param4.setValueParamter(6, YARD_ENTRY_GROUP[0]);
							param4.setValueParamter(7, YARD_ENTRY_DTIME[0]);
							param4.setValueParamter(8, REG_ID[0]);
							
							getDao("mesdao").insert("UIH050700_01.insert", param4);
	
						}
					}
				}
			}
		}
		return PosBizControlConstants.SUCCESS;
	}
}