| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103 |
- package xin.glue.ui.G.G07;
- import java.util.ArrayList;
- import java.util.HashMap;
- import java.util.List;
- import xin.glue.ui.common.PosDateFormat;
- 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 SearchYardOutList extends PosActivity
- {
-
- public String runActivity(PosContext context)
- {
-
-
- String[] REP_DATE = (String[])context.get("REP_DATE");
- String[] WKGROUP = (String[])context.get("WKGROUP");
- String[] WKSHIFT = (String[])context.get("WKSHIFT");
-
-
- List list1 = new ArrayList();
-
- PosParameter param1 = new PosParameter();
- param1.setWhereClauseParameter(0, REP_DATE[0]);
- PosRowSet dataVO = getDao("mesdao").find("UIG070010_01.select", param1);
-
- while(dataVO.hasNext()) {
- PosRow dataOROW = dataVO.next();
-
- String SEQ_NO = (String)dataOROW.getAttribute("SEQ_NO");
- String ORD_NO = (String)dataOROW.getAttribute("ORD_NO");
- String SLAB_NO = (String)dataOROW.getAttribute("SLAB_NO");
- String STL_GRD = (String)dataOROW.getAttribute("STL_GRD");
- String SLAB_SIZE = (String)dataOROW.getAttribute("SLAB_SIZE");
- String SLAB_WGT = (String)dataOROW.getAttribute("SLAB_WGT");
- String SLAB_RT = (String)dataOROW.getAttribute("SLAB_RT");
- String EMP_ID = (String)dataOROW.getAttribute("EMP_ID");
- String SLAB_STOCK_EXT_DTIME = (String)dataOROW.getAttribute("SLAB_STOCK_EXT_DTIME");
- String MISSNO_CLF = (String)dataOROW.getAttribute("MISSNO_CLF");
-
- PosDateFormat dateFormat = new PosDateFormat();
- String sShift = dateFormat.getShift(SLAB_STOCK_EXT_DTIME);
-
- PosParameter paramS = new PosParameter();
- paramS.setWhereClauseParameter(0, SLAB_STOCK_EXT_DTIME.substring(0, 6));
- paramS.setWhereClauseParameter(1, SLAB_STOCK_EXT_DTIME.substring(6, 8));
- paramS.setWhereClauseParameter(2, sShift);
- paramS.setWhereClauseParameter(3, "H");
- PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramS);
-
- String sGroup = null;
- if (groupVO.hasNext()) {
- PosRow groupROW = groupVO.next();
- sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
- }
-
- logger.logInfo("SearchYardOutList runActivity START.WKGROUP:"+WKGROUP[0]+",WKSHIFT:"+WKSHIFT[0]);
-
- logger.logInfo("SearchYardOutList runActivity START.sGroup:"+sGroup+",sShift:"+sShift);
-
-
- if (WKGROUP[0] !=null && !WKGROUP[0].equals("") ) {
- if (!sGroup.equals(WKGROUP[0])) {
- continue;
- }
- }
- if (WKSHIFT[0] !=null && !WKSHIFT[0].equals("") ) {
- if (!sShift.equals(WKSHIFT[0])) {
- continue;
- }
- }
-
- HashMap map1 = new HashMap(20,100) ;
- list1.add(map1);
-
- logger.logInfo("SearchYardOutList runActivity SEQ_NO:"+SEQ_NO);
- logger.logInfo("SearchYardOutList runActivity ORD_NO:"+ORD_NO);
-
- map1.put("SEQ_NO" , SEQ_NO );
- map1.put("ORD_NO" , ORD_NO );
- map1.put("SLAB_NO" , SLAB_NO );
- map1.put("STL_GRD" , STL_GRD );
- map1.put("SLAB_SIZE" , SLAB_SIZE );
- map1.put("SLAB_WGT" , SLAB_WGT );
- map1.put("SLAB_RT" , SLAB_RT );
- map1.put("EMP_ID" , EMP_ID );
- map1.put("SLAB_STOCK_EXT_DTIME" , SLAB_STOCK_EXT_DTIME );
- map1.put("MISSNO_CLF" , MISSNO_CLF );
-
- }
- context.put("dataEdit",list1);
-
- return PosBizControlConstants.SUCCESS;
- }
-
- }
|