1c67da13f2a68e2de7185bfa9397aa9b371a5a2d.svn-base 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103
  1. package xin.glue.ui.G.G07;
  2. import java.util.ArrayList;
  3. import java.util.HashMap;
  4. import java.util.List;
  5. import xin.glue.ui.common.PosDateFormat;
  6. import com.posdata.glue.biz.activity.PosActivity;
  7. import com.posdata.glue.biz.constants.PosBizControlConstants;
  8. import com.posdata.glue.context.PosContext;
  9. import com.posdata.glue.dao.vo.PosParameter;
  10. import com.posdata.glue.dao.vo.PosRow;
  11. import com.posdata.glue.dao.vo.PosRowSet;
  12. public class SearchYardOutList extends PosActivity
  13. {
  14. public String runActivity(PosContext context)
  15. {
  16. String[] REP_DATE = (String[])context.get("REP_DATE");
  17. String[] WKGROUP = (String[])context.get("WKGROUP");
  18. String[] WKSHIFT = (String[])context.get("WKSHIFT");
  19. List list1 = new ArrayList();
  20. PosParameter param1 = new PosParameter();
  21. param1.setWhereClauseParameter(0, REP_DATE[0]);
  22. PosRowSet dataVO = getDao("mesdao").find("UIG070010_01.select", param1);
  23. while(dataVO.hasNext()) {
  24. PosRow dataOROW = dataVO.next();
  25. String SEQ_NO = (String)dataOROW.getAttribute("SEQ_NO");
  26. String ORD_NO = (String)dataOROW.getAttribute("ORD_NO");
  27. String SLAB_NO = (String)dataOROW.getAttribute("SLAB_NO");
  28. String STL_GRD = (String)dataOROW.getAttribute("STL_GRD");
  29. String SLAB_SIZE = (String)dataOROW.getAttribute("SLAB_SIZE");
  30. String SLAB_WGT = (String)dataOROW.getAttribute("SLAB_WGT");
  31. String SLAB_RT = (String)dataOROW.getAttribute("SLAB_RT");
  32. String EMP_ID = (String)dataOROW.getAttribute("EMP_ID");
  33. String SLAB_STOCK_EXT_DTIME = (String)dataOROW.getAttribute("SLAB_STOCK_EXT_DTIME");
  34. String MISSNO_CLF = (String)dataOROW.getAttribute("MISSNO_CLF");
  35. PosDateFormat dateFormat = new PosDateFormat();
  36. String sShift = dateFormat.getShift(SLAB_STOCK_EXT_DTIME);
  37. PosParameter paramS = new PosParameter();
  38. paramS.setWhereClauseParameter(0, SLAB_STOCK_EXT_DTIME.substring(0, 6));
  39. paramS.setWhereClauseParameter(1, SLAB_STOCK_EXT_DTIME.substring(6, 8));
  40. paramS.setWhereClauseParameter(2, sShift);
  41. paramS.setWhereClauseParameter(3, "H");
  42. PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramS);
  43. String sGroup = null;
  44. if (groupVO.hasNext()) {
  45. PosRow groupROW = groupVO.next();
  46. sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
  47. }
  48. logger.logInfo("SearchYardOutList runActivity START.WKGROUP:"+WKGROUP[0]+",WKSHIFT:"+WKSHIFT[0]);
  49. logger.logInfo("SearchYardOutList runActivity START.sGroup:"+sGroup+",sShift:"+sShift);
  50. if (WKGROUP[0] !=null && !WKGROUP[0].equals("") ) {
  51. if (!sGroup.equals(WKGROUP[0])) {
  52. continue;
  53. }
  54. }
  55. if (WKSHIFT[0] !=null && !WKSHIFT[0].equals("") ) {
  56. if (!sShift.equals(WKSHIFT[0])) {
  57. continue;
  58. }
  59. }
  60. HashMap map1 = new HashMap(20,100) ;
  61. list1.add(map1);
  62. logger.logInfo("SearchYardOutList runActivity SEQ_NO:"+SEQ_NO);
  63. logger.logInfo("SearchYardOutList runActivity ORD_NO:"+ORD_NO);
  64. map1.put("SEQ_NO" , SEQ_NO );
  65. map1.put("ORD_NO" , ORD_NO );
  66. map1.put("SLAB_NO" , SLAB_NO );
  67. map1.put("STL_GRD" , STL_GRD );
  68. map1.put("SLAB_SIZE" , SLAB_SIZE );
  69. map1.put("SLAB_WGT" , SLAB_WGT );
  70. map1.put("SLAB_RT" , SLAB_RT );
  71. map1.put("EMP_ID" , EMP_ID );
  72. map1.put("SLAB_STOCK_EXT_DTIME" , SLAB_STOCK_EXT_DTIME );
  73. map1.put("MISSNO_CLF" , MISSNO_CLF );
  74. }
  75. context.put("dataEdit",list1);
  76. return PosBizControlConstants.SUCCESS;
  77. }
  78. }