QueryManualOperate.xml.svn-base 1013 B

123456789101112131415161718192021222324252627282930
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <queryMap desc="作业管理手动操作公共类">
  3. <query id="GetStoveActivityPath.Select" desc="查询作业路线" fetchSize="10">
  4. <![CDATA[
  5. select fact_route from PPC_STEEL_HEAT where HeatNo=?
  6. ]]>
  7. </query>
  8. <query id="IsExistNextPosIDLE.Select" desc="判断下道工序IDLE位置是否有炉号" fetchSize="10">
  9. <![CDATA[
  10. select T.OBJECTPOS, T.OBJECTID
  11. from tpm_trackobjectinfor t
  12. WHERE OBJECTPOS = ?
  13. ]]>
  14. </query>
  15. <query id="SetManualOperateValue.Seting" desc="作业管理手动操作设置时间节点值" fetchSize="10">
  16. <![CDATA[
  17. job_lg_manage.JobManualOperatValue
  18. ]]>
  19. </query>
  20. <query id="GetNextPosIdleHeatNo.Select" desc="查询下道工序IDLE位是否有炉号" fetchSize="10">
  21. <![CDATA[
  22. select T.OBJECTPOS, T.OBJECTID
  23. from tpm_trackobjectinfor t
  24. WHERE OBJECTPOS = ?
  25. ]]>
  26. </query>
  27. </queryMap>