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; } }