Strona główna Odkrywaj Pomoc
Zaloguj się
wudonglin
/
XinYu_RZMES
1
0
Forkuj 0
Pliki Problemy 0 Oczekujące zmiany 0 Wiki
Drzewo: 1105ec3dbe
Gałęzie Tagi
XinYu_RZMES
/
.svn
/
pristine
/
87
/
87bcb57d5dba011debb8c22b79cdd2a1efbbf6f8.svn-base

87bcb57d5dba011debb8c22b79cdd2a1efbbf6f8.svn-base 2.4 KB
Historia Czysty

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566 
  1. <?xml version="1.0" encoding='UTF-8'?>
    2. 

  2. <queryMap desc="STEEL MAKING QUERY ">
    3. 

  3. 	<query id="UIH040060_01.select" desc="查询现有轧辊现况 带两个参数" fetchSize="10">
    4. 

  4. 		<![CDATA[
    5. 

  5. 			select ROLL_NO,
    6. 

  6.               decode(ROLL_STAT,NVL('I',''),'新辊入库',NVL('G',''),'磨削完成',NVL('S',''),'磨削待机',NVL('W',''),'装配完成',NVL('U',''),'使用中',NVL('D',''),'废弃') ROLL_STAT,
    7. 

  7.               STAND_NO,
    8. 

  8.               ROLL_TYPE,
    9. 

  9.               ROLL_MAT_QLTY,
    10. 

  10.               ROLL_UCOST,
    11. 

  11.               ENT_DIA,
    12. 

  12.               ROLL_SHAPE_CD,
    13. 

  13.               DISUSE_DIA,
    14. 

  14.               CUR_DIA,
    15. 

  15.               ROLL_MAKER,
    16. 

  16.               ENT_DTIME,
    17. 

  17.               GRIND_DTIME,
    18. 

  18.               GRIND_STEPNO,
    19. 

  19.               decode(TOP_BOT_CLF,NVL('T',''),'上部轧辊',NVL('B',''),'下部轧辊') TOP_BOT_CLF,
    20. 

  20.               GRIND_USE_DTIME
    21. 

  21.                 from tbh04_roll where ROLL_TYPE = ? and ROLL_STAT = ?
    22. 

  22. 		]]>
    23. 

  23. 	</query>
    24. 

  24. 	<query id="UIH040060_02.select" desc="查询现有轧辊现况 带一个参数" fetchSize="10">
    25. 

  25. 		<![CDATA[
    26. 

  26. 			select ROLL_NO,
    27. 

  27. 			        decode(ROLL_STAT,NVL('I',''),'新辊入库',NVL('G',''),'磨削完成',NVL('S',''),'磨削待机',NVL('W',''),'装配完成',NVL('U',''),'使用中',NVL('D',''),'废弃') ROLL_STAT,
    28. 

  28. 			        STAND_NO,
    29. 

  29. 			        ROLL_TYPE,
    30. 

  30. 			        ROLL_MAT_QLTY,
    31. 

  31. 			        ROLL_UCOST,
    32. 

  32. 			        ENT_DIA,
    33. 

  33. 			        ROLL_SHAPE_CD,
    34. 

  34. 			        DISUSE_DIA,
    35. 

  35. 			        CUR_DIA,
    36. 

  36. 			        ROLL_MAKER,
    37. 

  37. 			        ENT_DTIME,
    38. 

  38. 			        GRIND_DTIME,
    39. 

  39. 			        GRIND_STEPNO,
    40. 

  40. 					decode(TOP_BOT_CLF,NVL('T',''),'上部轧辊',NVL('B',''),'下部轧辊') TOP_BOT_CLF,
    41. 

  41. 					GRIND_USE_DTIME   
    42. 

  42. 			         from tbh04_roll where ROLL_TYPE = ? 
    43. 

  43. 		]]>
    44. 

  44. 	</query>
    45. 

  45. 	<query id="UIH040060_03.select" desc="查询现有轧辊现况 不带参数" fetchSize="10">
    46. 

  46. 		<![CDATA[
    47. 

  47. 			select ROLL_NO,
    48. 

  48. 			        decode(ROLL_STAT,NVL('I',''),'新辊入库',NVL('G',''),'磨削完成',NVL('S',''),'磨削待机',NVL('W',''),'装配完成',NVL('U',''),'使用中',NVL('D',''),'废弃') ROLL_STAT,
    49. 

  49. 			        STAND_NO,
    50. 

  50. 			        ROLL_TYPE,
    51. 

  51. 			        ROLL_MAT_QLTY,
    52. 

  52. 			        ROLL_UCOST,
    53. 

  53. 			        ENT_DIA,
    54. 

  54. 			        ROLL_SHAPE_CD,
    55. 

  55. 			        DISUSE_DIA,
    56. 

  56. 			        CUR_DIA,
    57. 

  57. 			        ROLL_MAKER,
    58. 

  58. 			        ENT_DTIME,
    59. 

  59. 			        GRIND_DTIME,
    60. 

  60. 			        GRIND_STEPNO,
    61. 

  61. 					decode(TOP_BOT_CLF,NVL('T',''),'上部轧辊',NVL('B',''),'下部轧辊') TOP_BOT_CLF,
    62. 

  62. 				    GRIND_USE_DTIME   
    63. 

  63. 			         from tbh04_roll 
    64. 

  64. 		]]>
    65. 

  65. 	</query>
    66. 

  66. </queryMap>
    67.