Главная Обзор Помощь
Вход
wudonglin
/
XinYu_RZMES
1
0
Ответвить 0
Файлы Задачи 0 Запросы на слияние 0 Вики
Дерево: 1105ec3dbe
Ветки Метки
XinYu_RZMES
/
.svn
/
pristine
/
92
/
9280299f25309f9b97cc56b13cca2cc9dad072bb.svn-base

9280299f25309f9b97cc56b13cca2cc9dad072bb.svn-base 2.0 KB
История Исходник

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

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

  3. 	<query id="NIH020010.select" desc=" 这里用板坯号和钢卷号做为联合主键，为了板坯在做回炉处理的时候状态的改变情况 " fetchSize="10">
    4. 

  4. 		<![CDATA[
    5. 

  5. 			select * from TBH02_REHEATFUR where slab_no = ? and COIL_NO = ?
    6. 

  6. 		]]>
    7. 

  7. 	</query>
    8. 

  8. 	<query id="NIH020010.update" desc="init " fetchSize="10">
    9. 

  9. 		<![CDATA[
    10. 

  10. 			update TBH02_REHEATFUR set  
    11. 

  11. 						DEVNO           = ?
    12. 

  12. 						,RHF_STAT        = '1'
    13. 

  13. 						,CHARING_DTIME  = ?
    14. 

  14. 						,CHRGING_BEF_WGT = ?
    15. 

  15. 						,CHRGING_BEF_TEMP= ?
    16. 

  16. 						,ROW_NUM  = ?
    17. 

  17. 						,CHRGING_WKSHIFT  = ?
    18. 

  18. 						,CHRGING_WKGROUP  = ?
    19. 

  19. 						,ROLL_MANA_NO  = ?
    20. 

  20. 						,ROLL_SLAB_SEQ  = ?
    21. 

  21. 			            ,MOD_ID         = 'NIH020010'
    22. 

  22. 			            ,MOD_DTIME      = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')   
    23. 

  23. 			where       SLAB_NO = ?  AND COIL_NO = ? 
    24. 

  24. 		]]>
    25. 

  25. 	</query>
    26. 

  26. 	<query id="NIH020010.insert" desc="init " fetchSize="10">
    27. 

  27. 		<![CDATA[
    28. 

  28. 			insert into    TBH02_REHEATFUR
    29. 

  29.  			 (           SLAB_NO         
    30. 

  30. 						  ,COIL_NO         
    31. 

  31. 						  ,DEVNO    
    32. 

  32. 						  ,RHF_STAT       
    33. 

  33. 						  ,CHARING_DTIME   
    34. 

  34. 						  ,CHRGING_BEF_WGT 
    35. 

  35. 						  ,CHRGING_BEF_TEMP  
    36. 

  36. 						  ,ROW_NUM
    37. 

  37. 						  ,CHRGING_WKSHIFT
    38. 

  38. 						  ,CHRGING_WKGROUP
    39. 

  39. 						  ,ROLL_MANA_NO
    40. 

  40. 						  ,ROLL_SLAB_SEQ
    41. 

  41. 			              ,REG_ID 
    42. 

  42. 			              ,REG_DTIME
    43. 

  43. 			   ) 
    44. 

  44. 			   VALUES
    45. 

  45. 			   (          ?
    46. 

  46. 						  ,?
    47. 

  47. 						  ,?
    48. 

  48. 						  ,'1'
    49. 

  49. 						  ,?
    50. 

  50. 						  ,?
    51. 

  51. 						  ,?
    52. 

  52. 						  ,?
    53. 

  53. 						  ,?
    54. 

  54. 						  ,?
    55. 

  55. 						  ,?
    56. 

  56. 						  ,?
    57. 

  57. 			              ,'NIH020010'
    58. 

  58. 			              ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
    59. 

  59. 				) 
    60. 

  60. 		]]>
    61. 

  61. 	</query>
    62. 

  62. 	<query id="NIH020010_ROLLER.select" desc="   " fetchSize="10">
    63. 

  63. 		<![CDATA[
    64. 

  64. 		  SELECT YARD_ADDR FROM TBG04_SLAB_YARD
    65. 

  65. 		   WHERE SLAB_NO = ?
    66. 

  66. 		    AND  YARD_ADDR LIKE 'A%'	  
    67. 

  67. 			 
    68. 

  68. 		]]>
    69. 

  69. 	</query>
    70. 

  70. 	<query id="NIH020010_ROLLER.update" desc="   " fetchSize="10">
    71. 

  71. 		<![CDATA[
    72. 

  72. 		   UPDATE TBG04_SLAB_YARD SET
    73. 

  73. 			  SLAB_NO = null
    74. 

  74. 			 ,CR_NO = null
    75. 

  75. 			 ,BEF_STORE_LOC = null
    76. 

  76. 			 ,ORD_FLAG = null
    77. 

  77. 			 , REG_ID = null
    78. 

  78. 			 ,REG_DTIME = null
    79. 

  79. 			WHERE  YARD_ADDR = ?
    80. 

  80. 		]]>
    81. 

  81. 	</query>
    82. 

  82. </queryMap>
    83.