9b893ed237fb63d734bcb434ad51524edc01530e.svn-base 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110
  1. package xin.glue.ui.D.D02;
  2. //import java.math.BigDecimal;
  3. import java.util.ArrayList;
  4. import java.util.HashMap;
  5. import java.util.List;
  6. import java.util.Map;
  7. import com.posdata.glue.biz.activity.PosActivity;
  8. import com.posdata.glue.biz.constants.PosBizControlConstants;
  9. import com.posdata.glue.context.PosContext;
  10. import com.posdata.glue.dao.vo.PosParameter;
  11. import com.posdata.glue.dao.vo.PosRow;
  12. import com.posdata.glue.dao.vo.PosRowSet;
  13. public class SearchSrcSlabDnRst extends PosActivity
  14. {
  15. public String runActivity(PosContext context)
  16. {
  17. String[] FrDevlmtDate = (String[])context.get("FrDevlmtDate" ) ;
  18. String[] ToDevlmtDate = (String[])context.get("ToDevlmtDate" ) ;
  19. String[] FACSTLGEP = (String[])context.get("FACSTLGEP" ) ;
  20. String[] FACSTLGED = (String[])context.get("FACSTLGED" ) ;
  21. String[] SALABWTH1 = (String[])context.get("SALABWTH" ) ;
  22. String[] SALABWTH2 = (String[])context.get("SALABWTH" ) ;
  23. String[] FrCoilThk = (String[])context.get("FrCoilThk" ) ;
  24. String[] ToCoilThk = (String[])context.get("ToCoilThk" ) ;
  25. String[] SlabThk_1 = (String[])context.get("SlabThk_1");
  26. String[] SlabThk_2 = (String[])context.get("SlabThk_2");
  27. PosParameter param0 = new PosParameter();
  28. // param0.setWhereClauseParameter(0, FrDevlmtDate[0]);
  29. //param0.setWhereClauseParameter(1, ToDevlmtDate[0]);
  30. param0.setWhereClauseParameter(0, FACSTLGEP[0]);
  31. param0.setWhereClauseParameter(1, FACSTLGED[0]);
  32. param0.setWhereClauseParameter(2, SALABWTH1[0]);
  33. param0.setWhereClauseParameter(3, SALABWTH2[0]);
  34. param0.setWhereClauseParameter(4, FrCoilThk[0]);
  35. param0.setWhereClauseParameter(5, ToCoilThk[0]);
  36. param0.setWhereClauseParameter(6, SlabThk_1[0]);
  37. param0.setWhereClauseParameter(7, SlabThk_2[0]);
  38. //param0.setWhereClauseParameter(10, FrDevlmtDate[0]);
  39. // param0.setWhereClauseParameter(11, ToDevlmtDate[0]);
  40. param0.setWhereClauseParameter(8, FACSTLGEP[0]);
  41. param0.setWhereClauseParameter(9, FACSTLGED[0]);
  42. param0.setWhereClauseParameter(10, SALABWTH1[0]);
  43. param0.setWhereClauseParameter(11, SALABWTH2[0]);
  44. param0.setWhereClauseParameter(12, FrCoilThk[0]);
  45. param0.setWhereClauseParameter(13, ToCoilThk[0]);
  46. param0.setWhereClauseParameter(14, SlabThk_1[0]);
  47. param0.setWhereClauseParameter(15, SlabThk_2[0]);
  48. PosRowSet rowSet = getDao("mesdao").find("UID020020.SrcSlabDnRst.Select",param0);
  49. PosRow row = null;
  50. PosRowSet rowSet2 = null;
  51. Map map = new HashMap();
  52. Map map2 = null;
  53. String ord_no = "";
  54. String CHEM = "";
  55. List list = new ArrayList();
  56. String ord_seq = "";
  57. while(rowSet.hasNext())
  58. {
  59. map2 = new HashMap();
  60. row = rowSet.next();
  61. map = row.getAttributes();
  62. ord_no = (String)map.get("ORD_NO");
  63. ord_seq = (String)map.get("ORD_SEQ");
  64. PosParameter param1 = new PosParameter();
  65. param1.setWhereClauseParameter(0, ord_no);
  66. param1.setWhereClauseParameter(1, ord_seq);
  67. rowSet2 = getDao("mesdao").find("UID020020.SrcSlabDnRstChem.Select",param1);
  68. String CHEM2 = "";
  69. while(rowSet2.hasNext())
  70. {
  71. row = rowSet2.next();
  72. map2 = row.getAttributes();
  73. CHEM = (String)map2.get("CHEM");
  74. if(CHEM2 == "")
  75. {
  76. CHEM2 = CHEM;
  77. }
  78. else
  79. {
  80. CHEM2 = CHEM2 +":"+ CHEM;
  81. }
  82. }
  83. map2.putAll(map);
  84. map2.put("ORD_NO", ord_no);
  85. map2.put("ORD_SEQ", ord_seq);
  86. map2.put("CHEM", CHEM2);
  87. list.add(map2);
  88. //row.setAttributes(map2);
  89. }
  90. context.put("ListResult_0", list );
  91. //UID020020.SrcSlabDnRst.Select
  92. //ListResult_0
  93. return PosBizControlConstants.SUCCESS;
  94. }
  95. }