package xin.glue.ui.B.B02.O1;

import java.sql.CallableStatement;

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.PosGenericDao;
import com.posdata.glue.dao.vo.PosParameter;
import com.posdata.glue.dao.vo.PosRow;
import com.posdata.glue.dao.vo.PosRowSet;

public class SaveCretNoTOZB extends PosActivity
{

	public String runActivity(PosContext context)
	{
		String[]CRET_NO			=		(String[])context.get("CRET_NO");
		PosGenericDao	dao		=		this.getDao("mesdao");
		PosParameter	param	=		new PosParameter();
		CallableStatement	cstm =	null;
//		
//		param.setValueParamter(0, CRET_NO[0]);
//		dao.insert("UIB021100_02.INSERT", param);
		
		
		try
		{
			cstm	       =	dao.getCallableStatement("UIB021100_01.CALL");
			cstm.setString(1, CRET_NO[0]);//×¢Ò⣬ÐòºÅ´Ó1¿ªÊ¼
			cstm.registerOutParameter(2, java.sql.Types.VARCHAR);
			cstm.execute();
//			PosRowSet rowSet1 = mesdao.findByQueryStatement(selectTransL3);
//			while(rowSet1.hasNext()){
//				
//				param1	=	new PosParameter();
//				
//				PosRow row1 = rowSet1.next();
//				row1.get
//			}
		}catch(Exception ex)
		{
			
		}
		return PosBizControlConstants.SUCCESS;
	}

}