package xin.glue.ui.H.H05;

import xin.glue.ui.common.ProduceFactory;

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 Administrator
 *
 */
public class ReturnTrans extends PosActivity {
	public String runActivity(PosContext context) {
		// TODO Auto-generated method stub
		//		行状态
		String[] rowStuts = (String[]) context.get("rowStuts");
		//		选择标志
		String[] CHK = (String[]) context.get("CHK");
		//		钢卷号
		String[] coilNo = (String[]) context.get("OLD_SAMPL_NO");
		//		堆放位置
		String[] curLoadLoc = (String[]) context.get("CUR_LOAD_LOC");
		//		 班次
		String[] TRNF_SHIFT = (String[]) context.get("TRNF_SHIFT");
		// 班组
		String[] TRNF_GROUP = (String[]) context.get("TRNF_GROUP");
		// 操作人
		String[] TRNF_REG = (String[]) context.get("TRNF_REG");
		// 操作时间
		String[] TRNF_DTIME = (String[]) context.get("TRNF_DTIME");
		//登录人
		String []LOGIN_ID = (String[])context.get("LOGIN_ID");
		
		//		循环rowStuts，取出相应的节点行数
		for(int i=0;i<rowStuts.length;i++){
			//如果选择标志为Y的情况，说明是需要操作的。
			if(CHK[i].equals("Y")){
				
				//进行冷轧是否已经接收的判断
				String sqlc = "SELECT * FROM c_tbk02_coil_comm T WHERE T.OLD_SAMPL_NO = ? AND T.COIL_STAT='2' AND T.CUR_LOAD_LOC IS NOT NULL";
				PosParameter paramc = new PosParameter();
				paramc.setWhereClauseParameter(0,coilNo[i]);
				PosRowSet CoilVo1 = getDao("mesdao").findByQueryStatement(sqlc, paramc);
				if (CoilVo1.hasNext()) {
	
							String vtemp="COILIN";
							context.put("rs", vtemp);
							return PosBizControlConstants.SUCCESS;	
				}
				
				PosParameter param = new PosParameter();
				param.setValueParamter(0, TRNF_SHIFT[0]);
				param.setValueParamter(1, TRNF_GROUP[0]);
				param.setValueParamter(2, TRNF_REG[0]);
				param.setValueParamter(3, curLoadLoc[i]);
				param.setValueParamter(4, TRNF_DTIME[0]);
				param.setWhereClauseParameter(0, coilNo[i]);
				getDao("mesdao").update("UIH052400_05.update", param);
				
				PosParameter param1 = new PosParameter();
				param1.setValueParamter(0, coilNo[i]);
				param1.setValueParamter(1, TRNF_REG[0]);
				param1.setWhereClauseParameter(0, curLoadLoc[i]);
				param1.setWhereClauseParameter(1, curLoadLoc[i]);
				param1.setWhereClauseParameter(2, curLoadLoc[i]);
				param1.setWhereClauseParameter(3, curLoadLoc[i]);
				getDao("mesdao").update("UIH052400_06.update", param1);
				
				
			
				
				//删除冷轧原料中还未入库的数据 20190909 wl
				PosParameter paramD = new PosParameter();
				paramD.setWhereClauseParameter(0, coilNo[i]);
				getDao("mesdao").delete("UIH052400_01.delete", paramD);
				
				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, curLoadLoc[0]);
					param4.setValueParamter(3, coilNo[i]);
					param4.setValueParamter(4, TRNF_REG[0]);
					param4.setValueParamter(5, TRNF_SHIFT[0]);
					param4.setValueParamter(6, TRNF_GROUP[0]);
					param4.setValueParamter(7, TRNF_DTIME[0]);
					param4.setValueParamter(8, LOGIN_ID[0]);				
					getDao("mesdao").insert("UIH050700_01.insert", param4);
				}
				
				//新增退回记录
				PosParameter param2 = new PosParameter();
				param2.setValueParamter(0, coilNo[i]);
				param2.setValueParamter(1, curLoadLoc[0]);
				param2.setValueParamter(2, TRNF_REG[0]);
				param2.setValueParamter(3, TRNF_SHIFT[0]);
				param2.setValueParamter(4, TRNF_GROUP[0]);
				param2.setValueParamter(5, TRNF_DTIME[0]);
				getDao("mesdao").update("UIH052400_04.insert", param2);
			}
		}
		
		return PosBizControlConstants.SUCCESS;
	}
}