package xin.glue.nui.H.H04; import xin.glue.ui.common.PosGridSave; //import xin.glue.ui.common.component.PosSiteConfig; import xin.glue.ui.common.component.PosSiteLog; 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.PosRowSet; /* * 电文接收后,修改磨削直径 * @author TangLiang 唐亮 * @data 2009.10.26 */ public class rollGSaveUpdate extends PosActivity{ public String runActivity(PosContext context){ //从页面获取提交数据 String[] status = (String[]) context.get("rowStuts"); //轧辊号 String[] ROLL_NO = (String[])context.get("ROLL_NO"); //磨削后直径 String[] CUR_DIA = (String[])context.get("CUR_DIA"); //磨削后直径 String[] REG_ID = (String[])context.get("REG_ID"); PosParameter param0 = new PosParameter(); param0.setWhereClauseParameter(0, ROLL_NO[0]); String sql = "select ROLL_NO from tbh04_roll where ROLL_NO = ?"; PosRowSet rowset1 = getDao("mesdao").findByQueryStatement(sql, param0); //如果值存在就更新 if(rowset1.hasNext()){ PosParameter param1 = new PosParameter(); param1.setWhereClauseParameter(0, CUR_DIA[0]); param1.setWhereClauseParameter(1, CUR_DIA[0]); param1.setWhereClauseParameter(2, REG_ID[0]); param1.setWhereClauseParameter(3, ROLL_NO[0]); getDao("mesdao").update("UIH040040_11.update", param1); }else{ //这里如果轧辊表中不存在轧辊号信息时,说明轧辊号对应不上实物。给予相应的提示 //这里抛出异常,给予提示信息 logger.logDebug("rollGSaveUpdate 输入的轧辊号在轧辊表 TBH04_ROLL 中不存在! "); String vtemp="ROLL_NO"; context.put("rs", vtemp); } return PosBizControlConstants.SUCCESS; } }