XinYu_RZMES/.svn/pristine/c8/c824839c701706313139075508ed1e7974a9ea11.svn-base

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 XinSaveCoil_Yard_Out extends PosActivity{
	public String runActivity(PosContext context){
		//钢卷号
		String[] COIL_NO = (String[]) context.get("COIL_NO");
		//合同号
		String[] ORD_NO = (String[]) context.get("ORD_NO");
		//车辆号
		String[] CAR_NO = (String[]) context.get("CAR_NO");
		//卷重
		String[] COIL_WGT = (String[]) context.get("COIL_WGT");
		//客户
		String[] CUST_NM = (String[]) context.get("CUST_NM");
		//收货单位
		String[] ORD_NM = (String[]) context.get("ORD_NM");
		//运输方式
		String[] DLIV_TP = (String[]) context.get("DLIV_TP");
		//是否水运
		String[] BY_SEA_YN = (String[]) context.get("BY_SEA_YN");
		//专用线
		String[] EXLV_LINE_CD = (String[]) context.get("EXLV_LINE_CD");
		//发货指示号  
		String[] DLIV_DIRNO = (String[]) context.get("DLIV_DIRNO");
		//目的地 
		String[] DEST_CD = (String[]) context.get("DEST_CD");
		//登陆人
		String[] REG_ID = (String[]) context.get("REG_ID");
		String[] rowStuts = (String[]) context.get("rowStuts");
		//出库班次
		String[] ENTRY_SHIFT = (String[]) context.get("ENTRY_SHIFT");
		//出库班组
		String[] ENTRY_GROUP = (String[]) context.get("ENTRY_GROUP");
		//出库人
		String[] ENTRY_REG = (String[]) context.get("ENTRY_REG");
		//出库时间
		String[] ENTRY_DTIME = (String[]) context.get("ENTRY_DTIME");
		//选择标志
		String[] CHK = (String[]) context.get("CHK");
		
		//需要处理多个钢卷一起出的情况
		for(int i=0;i<rowStuts.length;i++){
			//通过选择标志来清库，选择标志不存在的不能清
			if(CHK[i].equals("Y")){
				PosParameter param0 = new PosParameter();
				
				param0.setWhereClauseParameter(0, COIL_NO[i]);
				
				PosRowSet rows = getDao("mesdao").find("UIH050800_07.select", param0);
				
				if(rows.hasNext()){
					//进行相应的更新操作
					PosParameter param1 = new PosParameter();
					
					param1.setWhereClauseParameter(0, DLIV_DIRNO[0]);
					param1.setWhereClauseParameter(1, COIL_WGT[i]);
					param1.setWhereClauseParameter(2, CAR_NO[0]);
					param1.setWhereClauseParameter(3, EXLV_LINE_CD[0]);
					param1.setWhereClauseParameter(4, DLIV_TP[0]);
					param1.setWhereClauseParameter(5, CUST_NM[0]);
					param1.setWhereClauseParameter(6, ORD_NM[0]);
					param1.setWhereClauseParameter(7, ENTRY_REG[0]);
					param1.setWhereClauseParameter(8, DEST_CD[i]);
					param1.setWhereClauseParameter(9, ENTRY_SHIFT[0]);
					param1.setWhereClauseParameter(10, ENTRY_GROUP[0]);
					param1.setWhereClauseParameter(11, ENTRY_DTIME[0]);
					
					param1.setWhereClauseParameter(12, COIL_NO[i]);
					
					getDao("mesdao").update("UIH050800_01.update", param1);
					
					//不处理运送表
					//判断发货指示号是否存在
//					PosParameter param33 = new PosParameter();
//					
//					param33.setWhereClauseParameter(0, DLIV_DIRNO[0]);
//					
//					PosRowSet rows11 = getDao("mesdao").find("UIH050800_09.select", param33);
//					
//					if(rows11.hasNext()){
//						PosParameter param2 = new PosParameter();
//						
//						param2.setWhereClauseParameter(0, ORD_NO[0]);
//						param2.setWhereClauseParameter(1, CAR_NO[0]);
//						param2.setWhereClauseParameter(2, EXLV_LINE_CD[0]);
//						param2.setWhereClauseParameter(3, DLIV_TP[0]);
//						param2.setWhereClauseParameter(4, CUST_NM[0]);
//						param2.setWhereClauseParameter(5, ORD_NM[0]);
//						param2.setWhereClauseParameter(6, BY_SEA_YN[0]);
//						param2.setWhereClauseParameter(7, DLIV_DIRNO[0]);
//						
//						
//						getDao("mesdao").update("UIH050800_02.update", param2);
//					}else{
//						PosParameter param2 = new PosParameter();
//						
//						param2.setWhereClauseParameter(0, ORD_NO[0]);
//						param2.setWhereClauseParameter(1, CAR_NO[0]);
//						param2.setWhereClauseParameter(2, EXLV_LINE_CD[0]);
//						param2.setWhereClauseParameter(3, DLIV_TP[0]);
//						param2.setWhereClauseParameter(4, CUST_NM[0]);
//						param2.setWhereClauseParameter(5, ORD_NM[0]);
//						param2.setWhereClauseParameter(6, BY_SEA_YN[0]);
//						param2.setWhereClauseParameter(7, DLIV_DIRNO[0]);
//						
//						
//						getDao("mesdao").update("UIH050800_01.insert", param2);
//					}

					PosParameter param3 = new PosParameter();
					
					param3.setWhereClauseParameter(0, COIL_NO[i]);
					
					PosRowSet rows1 = getDao("mesdao").find("UIH050800_08.select", param3);
					
					if(rows1.hasNext()){
						PosRow row1 = rows1.next();
						
						String YARD_CLF = null;
						String STEP_CLF = null;
						String STORELAY = null;
						String STORE_SEQ = null;
						
						YARD_CLF =  (String) row1.getAttribute("YARD_CLF");
						STEP_CLF =  (String) row1.getAttribute("STEP_CLF");
						STORELAY =  (String) row1.getAttribute("STORELAY");
						STORE_SEQ =  (String) row1.getAttribute("STORE_SEQ");
						
						PosParameter param4 = new PosParameter();
						param4.setWhereClauseParameter(0, YARD_CLF);
						param4.setWhereClauseParameter(1, STEP_CLF);
						param4.setWhereClauseParameter(2, STORELAY);
						param4.setWhereClauseParameter(3, STORE_SEQ);
						
						getDao("mesdao").update("UIH050800_03.update", param4);
						
					}else{
						logger.logInfo("XinSaveCoil_Yard_Out 此钢卷在库存垛位中不存子啊！！"+COIL_NO[0]);
					}
					
				}else{
					//抛出异常
					logger.logInfo("XinSaveCoil_Yard_Out 人工出库的钢卷在轧制中或者已经出库");
					String vtemp="ERROR";
					context.put("rs", vtemp);
				}
			}
		}
		return PosBizControlConstants.SUCCESS;
	}
}