package xin.glue.ui.H.H05;

import java.sql.CallableStatement;
import java.sql.SQLException;

import com.posdata.glue.PosException;
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 CoilYardRem extends PosActivity{
	public String runActivity(PosContext context) {
		
//		钢卷号
		String[] coil_no = (String[])context.get("coil_no");
		
//		备注信息
		String[] REM = (String[])context.get("REM");
		
		//用户名 add by ganjun 2010-08-17
		String[] regId = (String[])context.get("REG_ID");
		
		PosParameter param1 = new PosParameter();
		String sql2 = "select a.CUR_PROG_CD,a.SHIP_PROG_CD,a.COIL_STAT,a.SEND_WGT from tbh02_coil_comm a where a.old_sampl_no = ?";
		param1.setWhereClauseParameter(0,coil_no[0] );
		PosRowSet CoilVo = getDao("mesdao").findByQueryStatement(sql2, param1);
		
		if(CoilVo.hasNext()){
			
			PosParameter param2 = new PosParameter();
			
			param2.setWhereClauseParameter(0, REM[0]);
			param2.setWhereClauseParameter(1,regId[0]);
			param2.setWhereClauseParameter(2, coil_no[0]);
			//增加操作人，操作时间 add by ganjun 2010-08-17
			
			getDao("mesdao").update("UIH051500_05.update", param2);
			System.out.println("-----------------------");
			
		}else{
			//此卷在库中没有，给出相应的提示
			logger.logDebug("CoilWGTSEND 钢卷在公共表中不存在，卷号为; "+coil_no[0]);
			String vtemp="old_sampl_no";
			context.put("rs", vtemp);
		}
		
		
		return PosBizControlConstants.SUCCESS;
	}

}