package xin.glue.ui.B.B02; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.SortedMap; 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-6 下午07:45:51 * @JDK Version jdk1.4.2 */ public class FindJudgeChargeSingle extends PosActivity { public String runActivity(PosContext context) { ///ready PosGenericDao dao = this.getDao("mesdao"); PosParameter param = null; PosRowSet rowset = context.getRowSet("ListResult");//获取订单号和厂内钢号 if(rowset.count() <= 0) { return PosBizControlConstants.SUCCESS; } ///获得请求参数 PosRow[] pp = rowset.getAllRow(); String STL_GRD = pp[0].getAttribute("STL_GRD").toString();//厂内钢号 String[]CHARGE_NO = (String[])context.get("QQ");//炉次 号 String[]DORD = (String[])context.get("DORD"); String[]DSEQ = (String[])context.get("DSEQ"); //LST_INGR_CD中存储的是工序+最后的次数 ,在品质部分,工序只会是JJ,即连铸 String rocCount = pp[0].getAttribute("LST_INGR_CD")==null ? "XX" : pp[0].getAttribute("LST_INGR_CD").toString();//最后工序 if("XX".equals(rocCount)) return PosBizControlConstants.SUCCESS; if(null == DORD) { param = new PosParameter(); param.setWhereClauseParameter(0, STL_GRD); param.setWhereClauseParameter(1, STL_GRD); param.setWhereClauseParameter(2, CHARGE_NO[0]); param.setWhereClauseParameter(3, rocCount); param.setWhereClauseParameter(4, CHARGE_NO[0]); param.setWhereClauseParameter(5, rocCount); rowset = dao.find("UIB020040_CHARGE_02.SELECT", param); context.put("CHEMINFO", rowset); } else { param = new PosParameter(); param.setWhereClauseParameter(0, DORD[0]); param.setWhereClauseParameter(1, DSEQ[0]); param.setWhereClauseParameter(2, DORD[0]); param.setWhereClauseParameter(3, DSEQ[0]); param.setWhereClauseParameter(4, DORD[0]); param.setWhereClauseParameter(5, DSEQ[0]); param.setWhereClauseParameter(6, STL_GRD); param.setWhereClauseParameter(7, CHARGE_NO[0]); param.setWhereClauseParameter(8, pp[0].getAttribute("LST_INGR_CD").toString()); param.setWhereClauseParameter(9, CHARGE_NO[0].subSequence(0, 10)); param.setWhereClauseParameter(10, pp[0].getAttribute("LST_INGR_CD").toString()); rowset = dao.find("UIB020040_SLAB_02.SELECT" , param); context.put("CHEMINFO", rowset); } return PosBizControlConstants.SUCCESS; } }