3042d5d6508f500762df38070172bc7f905feb42.svn-base 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  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 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.PosGenericDao;
  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. /**
  14. *
  15. * @Description 单一成分,板坯号判定实绩查询{界面ID:UIB020040}
  16. * @author 梅贵平{meiguiping}
  17. * @date 2009-1-9 下午03:19:43
  18. * @JDK Version jdk1.4.2
  19. */
  20. public class FindJudgeSlabSingle extends PosActivity
  21. {
  22. public String runActivity(PosContext context)
  23. {
  24. ///ready
  25. PosParameter param = null;
  26. PosGenericDao dao = this.getDao("mesdao");
  27. PosRowSet rowset = null;
  28. PosRow row = null;
  29. ///获得参数信息
  30. PosRowSet prs = context.getRowSet("ListResult");
  31. if(prs.count()<=0)
  32. {
  33. return PosBizControlConstants.SUCCESS;
  34. }
  35. PosRow[] pr = prs.getAllRow();
  36. String ORD_NO = pr[0].getAttribute("ORD_NO")==null ? "XX":pr[0].getAttribute("ORD_NO").toString();//合同号
  37. String ORD_SEQ = pr[0].getAttribute("ORD_SEQ")==null ? "XX":pr[0].getAttribute("ORD_SEQ").toString();//厂内钢号
  38. String[] CHARGENO = (String[])context.get("QQ");//炉号
  39. String LSTCD = pr[0].getAttribute("LST_INGR_CD").toString();
  40. String FACSTLGRD = pr[0].getAttribute("STL_GRD").toString();
  41. if("XX".equals(ORD_NO))
  42. return PosBizControlConstants.SUCCESS;
  43. param = new PosParameter();
  44. param.setWhereClauseParameter(0, ORD_NO);
  45. param.setWhereClauseParameter(1, ORD_SEQ);
  46. param.setWhereClauseParameter(2, ORD_NO);
  47. param.setWhereClauseParameter(3, ORD_SEQ);
  48. param.setWhereClauseParameter(4, ORD_NO);
  49. param.setWhereClauseParameter(5, ORD_SEQ);
  50. param.setWhereClauseParameter(6, FACSTLGRD);
  51. param.setWhereClauseParameter(7, CHARGENO[0]);
  52. param.setWhereClauseParameter(8, LSTCD);
  53. param.setWhereClauseParameter(9, CHARGENO[0].subSequence(0, 10));
  54. param.setWhereClauseParameter(10, LSTCD);
  55. // System.out.println(sql);
  56. rowset = dao.find("UIB020040_SLAB_02.SELECT" , param);
  57. context.put("CHEMINFO", rowset);
  58. return PosBizControlConstants.SUCCESS;
  59. }
  60. }