package xin.glue.ui.B.B02; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; 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; /** * * @Description 单一成分,板坯号判定实绩查询{界面ID:UIB020040} * @author 梅贵平{meiguiping} * @date 2009-1-9 下午03:19:43 * @JDK Version jdk1.4.2 */ public class FindJudgeSlabSingle extends PosActivity { public String runActivity(PosContext context) { ///ready PosParameter param = null; PosGenericDao dao = this.getDao("mesdao"); PosRowSet rowset = null; PosRow row = null; ///获得参数信息 PosRowSet prs = context.getRowSet("ListResult"); if(prs.count()<=0) { return PosBizControlConstants.SUCCESS; } PosRow[] pr = prs.getAllRow(); String ORD_NO = pr[0].getAttribute("ORD_NO")==null ? "XX":pr[0].getAttribute("ORD_NO").toString();//合同号 String ORD_SEQ = pr[0].getAttribute("ORD_SEQ")==null ? "XX":pr[0].getAttribute("ORD_SEQ").toString();//厂内钢号 String[] CHARGENO = (String[])context.get("QQ");//炉号 String LSTCD = pr[0].getAttribute("LST_INGR_CD").toString(); String FACSTLGRD = pr[0].getAttribute("STL_GRD").toString(); if("XX".equals(ORD_NO)) return PosBizControlConstants.SUCCESS; param = new PosParameter(); param.setWhereClauseParameter(0, ORD_NO); param.setWhereClauseParameter(1, ORD_SEQ); param.setWhereClauseParameter(2, ORD_NO); param.setWhereClauseParameter(3, ORD_SEQ); param.setWhereClauseParameter(4, ORD_NO); param.setWhereClauseParameter(5, ORD_SEQ); param.setWhereClauseParameter(6, FACSTLGRD); param.setWhereClauseParameter(7, CHARGENO[0]); param.setWhereClauseParameter(8, LSTCD); param.setWhereClauseParameter(9, CHARGENO[0].subSequence(0, 10)); param.setWhereClauseParameter(10, LSTCD); // System.out.println(sql); rowset = dao.find("UIB020040_SLAB_02.SELECT" , param); context.put("CHEMINFO", rowset); return PosBizControlConstants.SUCCESS; } }