01b7b1025c898523be20783e67bc03d77d134f22.svn-base 2.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980
  1. package xin.glue.ui.B.B02;
  2. import java.util.ArrayList;
  3. import java.util.HashMap;
  4. import java.util.List;
  5. import java.util.Map;
  6. import java.util.SortedMap;
  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.PosGenericDao;
  11. import com.posdata.glue.dao.vo.PosParameter;
  12. import com.posdata.glue.dao.vo.PosRow;
  13. import com.posdata.glue.dao.vo.PosRowSet;
  14. /**
  15. *
  16. * @Description 单一成分,炉次号判定实绩查询{界面ID:UIB020040}
  17. * @author 梅贵平{meiguiping}
  18. * @date 2009-1-6 下午07:45:51
  19. * @JDK Version jdk1.4.2
  20. */
  21. public class FindJudgeChargeSingle extends PosActivity
  22. {
  23. public String runActivity(PosContext context)
  24. {
  25. ///ready
  26. PosGenericDao dao = this.getDao("mesdao");
  27. PosParameter param = null;
  28. PosRowSet rowset = context.getRowSet("ListResult");//获取订单号和厂内钢号
  29. if(rowset.count() <= 0)
  30. {
  31. return PosBizControlConstants.SUCCESS;
  32. }
  33. ///获得请求参数
  34. PosRow[] pp = rowset.getAllRow();
  35. String STL_GRD = pp[0].getAttribute("STL_GRD").toString();//厂内钢号
  36. String[]CHARGE_NO = (String[])context.get("QQ");//炉次 号
  37. String[]DORD = (String[])context.get("DORD");
  38. String[]DSEQ = (String[])context.get("DSEQ");
  39. //LST_INGR_CD中存储的是工序+最后的次数 ,在品质部分,工序只会是JJ,即连铸
  40. String rocCount = pp[0].getAttribute("LST_INGR_CD")==null ? "XX" : pp[0].getAttribute("LST_INGR_CD").toString();//最后工序
  41. if("XX".equals(rocCount))
  42. return PosBizControlConstants.SUCCESS;
  43. if(null == DORD)
  44. {
  45. param = new PosParameter();
  46. param.setWhereClauseParameter(0, STL_GRD);
  47. param.setWhereClauseParameter(1, STL_GRD);
  48. param.setWhereClauseParameter(2, CHARGE_NO[0]);
  49. param.setWhereClauseParameter(3, rocCount);
  50. param.setWhereClauseParameter(4, CHARGE_NO[0]);
  51. param.setWhereClauseParameter(5, rocCount);
  52. rowset = dao.find("UIB020040_CHARGE_02.SELECT", param);
  53. context.put("CHEMINFO", rowset);
  54. }
  55. else
  56. {
  57. param = new PosParameter();
  58. param.setWhereClauseParameter(0, DORD[0]);
  59. param.setWhereClauseParameter(1, DSEQ[0]);
  60. param.setWhereClauseParameter(2, DORD[0]);
  61. param.setWhereClauseParameter(3, DSEQ[0]);
  62. param.setWhereClauseParameter(4, DORD[0]);
  63. param.setWhereClauseParameter(5, DSEQ[0]);
  64. param.setWhereClauseParameter(6, STL_GRD);
  65. param.setWhereClauseParameter(7, CHARGE_NO[0]);
  66. param.setWhereClauseParameter(8, pp[0].getAttribute("LST_INGR_CD").toString());
  67. param.setWhereClauseParameter(9, CHARGE_NO[0].subSequence(0, 10));
  68. param.setWhereClauseParameter(10, pp[0].getAttribute("LST_INGR_CD").toString());
  69. rowset = dao.find("UIB020040_SLAB_02.SELECT" , param);
  70. context.put("CHEMINFO", rowset);
  71. }
  72. return PosBizControlConstants.SUCCESS;
  73. }
  74. }