c0120bff7d07630815d622cca411684607cd8bf1.svn-base 1.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. <?xml version="1.0" encoding='UTF-8'?>
  2. <queryMap desc="STEEL MAKING QUERY ">
  3. <query id="UIH020010_01.select" desc="1号炉" fetchSize="10">
  4. <![CDATA[
  5. SELECT
  6. '' SEQ
  7. ,SLAB_NO
  8. ,DEVNO
  9. ,CHRGING_BEF_TEMP
  10. ,CHRGING_BEF_WGT
  11. ,CHARING_DTIME
  12. FROM TBH02_REHEATFUR
  13. WHERE RHF_STAT = '1'
  14. and DEVNO = '1'
  15. order by CHARING_DTIME
  16. ]]>
  17. </query>
  18. <query id="UIH020010_02.select" desc="2号炉 " fetchSize="10">
  19. <![CDATA[
  20. SELECT
  21. '' SEQ
  22. ,SLAB_NO
  23. ,DEVNO
  24. ,CHRGING_BEF_TEMP
  25. ,CHRGING_BEF_WGT
  26. ,CHARING_DTIME
  27. FROM TBH02_REHEATFUR
  28. WHERE RHF_STAT = '1'
  29. and DEVNO = '2'
  30. order by CHARING_DTIME
  31. ]]>
  32. </query>
  33. <query id="UIH020010_03.select" desc="3号炉" fetchSize="10">
  34. <![CDATA[
  35. SELECT
  36. '' SEQ
  37. ,SLAB_NO
  38. ,DEVNO
  39. ,CHRGING_BEF_TEMP
  40. ,CHRGING_BEF_WGT
  41. ,CHARING_DTIME
  42. FROM TBH02_REHEATFUR
  43. WHERE RHF_STAT = '1'
  44. and DEVNO = '3'
  45. order by CHARING_DTIME
  46. ]]>
  47. </query>
  48. </queryMap>