| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110 |
- package xin.glue.ui.D.D02;
- //import java.math.BigDecimal;
- 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.vo.PosParameter;
- import com.posdata.glue.dao.vo.PosRow;
- import com.posdata.glue.dao.vo.PosRowSet;
- public class SearchSrcSlabDnRst extends PosActivity
- {
- public String runActivity(PosContext context)
- {
- String[] FrDevlmtDate = (String[])context.get("FrDevlmtDate" ) ;
- String[] ToDevlmtDate = (String[])context.get("ToDevlmtDate" ) ;
-
- String[] FACSTLGEP = (String[])context.get("FACSTLGEP" ) ;
- String[] FACSTLGED = (String[])context.get("FACSTLGED" ) ;
- String[] SALABWTH1 = (String[])context.get("SALABWTH" ) ;
- String[] SALABWTH2 = (String[])context.get("SALABWTH" ) ;
- String[] FrCoilThk = (String[])context.get("FrCoilThk" ) ;
- String[] ToCoilThk = (String[])context.get("ToCoilThk" ) ;
- String[] SlabThk_1 = (String[])context.get("SlabThk_1");
- String[] SlabThk_2 = (String[])context.get("SlabThk_2");
-
- PosParameter param0 = new PosParameter();
- // param0.setWhereClauseParameter(0, FrDevlmtDate[0]);
- //param0.setWhereClauseParameter(1, ToDevlmtDate[0]);
- param0.setWhereClauseParameter(0, FACSTLGEP[0]);
- param0.setWhereClauseParameter(1, FACSTLGED[0]);
- param0.setWhereClauseParameter(2, SALABWTH1[0]);
- param0.setWhereClauseParameter(3, SALABWTH2[0]);
- param0.setWhereClauseParameter(4, FrCoilThk[0]);
- param0.setWhereClauseParameter(5, ToCoilThk[0]);
- param0.setWhereClauseParameter(6, SlabThk_1[0]);
- param0.setWhereClauseParameter(7, SlabThk_2[0]);
-
- //param0.setWhereClauseParameter(10, FrDevlmtDate[0]);
- // param0.setWhereClauseParameter(11, ToDevlmtDate[0]);
- param0.setWhereClauseParameter(8, FACSTLGEP[0]);
- param0.setWhereClauseParameter(9, FACSTLGED[0]);
- param0.setWhereClauseParameter(10, SALABWTH1[0]);
- param0.setWhereClauseParameter(11, SALABWTH2[0]);
- param0.setWhereClauseParameter(12, FrCoilThk[0]);
- param0.setWhereClauseParameter(13, ToCoilThk[0]);
- param0.setWhereClauseParameter(14, SlabThk_1[0]);
- param0.setWhereClauseParameter(15, SlabThk_2[0]);
-
- PosRowSet rowSet = getDao("mesdao").find("UID020020.SrcSlabDnRst.Select",param0);
-
- PosRow row = null;
- PosRowSet rowSet2 = null;
- Map map = new HashMap();
- Map map2 = null;
- String ord_no = "";
- String CHEM = "";
- List list = new ArrayList();
- String ord_seq = "";
- while(rowSet.hasNext())
- {
- map2 = new HashMap();
- row = rowSet.next();
-
- map = row.getAttributes();
- ord_no = (String)map.get("ORD_NO");
- ord_seq = (String)map.get("ORD_SEQ");
- PosParameter param1 = new PosParameter();
- param1.setWhereClauseParameter(0, ord_no);
- param1.setWhereClauseParameter(1, ord_seq);
-
- rowSet2 = getDao("mesdao").find("UID020020.SrcSlabDnRstChem.Select",param1);
- String CHEM2 = "";
- while(rowSet2.hasNext())
- {
- row = rowSet2.next();
- map2 = row.getAttributes();
- CHEM = (String)map2.get("CHEM");
- if(CHEM2 == "")
- {
- CHEM2 = CHEM;
- }
- else
- {
- CHEM2 = CHEM2 +":"+ CHEM;
- }
- }
- map2.putAll(map);
- map2.put("ORD_NO", ord_no);
- map2.put("ORD_SEQ", ord_seq);
- map2.put("CHEM", CHEM2);
- list.add(map2);
- //row.setAttributes(map2);
- }
-
- context.put("ListResult_0", list );
- //UID020020.SrcSlabDnRst.Select
- //ListResult_0
-
- return PosBizControlConstants.SUCCESS;
- }
- }
|