Home Esplora Aiuto
Accedi
wudonglin
/
XinYu_RZMES
1
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Albero (Tree): 1105ec3dbe
Rami (Branch) Tag
XinYu_RZMES
/
.svn
/
pristine
/
a9
/
a9b17d7186c662561e9f6f67df5c6fe10e00b3dc.svn-base

a9b17d7186c662561e9f6f67df5c6fe10e00b3dc.svn-base 1.9 KB
Cronologia Originale

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

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

  3. 

  4. 	<query id="NIH020060_CHANGE_ROLL.select" desc="" fetchSize="10">
    5. 

  5. 		<![CDATA[
    6. 

  6. 		 SELECT ROLL_NO
    7. 

  7. 			,ROLLING_LEN
    8. 

  8. 			--,ROLL_HOUR
    9. 

  9. 			,ROLLING_WGT
    10. 

  10. 			,ROLLING_TOT_LEN
    11. 

  11. 			,ROLLING_TOT_WGT,ROLLING_TOT_HOUR 
    12. 

  12.            FROM  TBH04_ROLL
    13. 

  13.           WHERE ROLL_NO IN(?,?) 		  
    14. 

  14. 		]]>
    15. 

  15. 	</query>
    16. 

  16. 	<query id="NIH020060_DISMOUNT_ROLL.update" desc="" fetchSize="10">
    17. 

  17. 		<![CDATA[
    18. 

  18. 			UPDATE TBH04_ROLL SET
    19. 

  19. 			  ROLL_STAT            = 'S'
    20. 

  20. 			 ,ROLL_STAT_DTIME      = to_char(SYSDATE,'yyyymmddhh24miss')
    21. 

  21. 			 ,ROLL_BEF_STAT1       = ROLL_STAT
    22. 

  22. 			 ,ROLL_BEF_STAT_DTIME1 = ROLL_STAT_DTIME
    23. 

  23. 			 ,ROLL_BEF_STAT2       = ROLL_BEF_STAT1
    24. 

  24. 			 ,ROLL_BEF_STAT_DTIME2 = ROLL_BEF_STAT_DTIME1
    25. 

  25. 			 ,ROLL_BEF_STAT3       = ROLL_BEF_STAT2 
    26. 

  26. 			 ,ROLL_BEF_STAT_DTIME3 = ROLL_BEF_STAT_DTIME2 
    27. 

  27. 			 --,CHANG_DTIME          = to_char(SYSDATE,'yyyymmddhh24miss')
    28. 

  28. 			 --,USE_DTIME            = to_char(SYSDATE,'yyyymmddhh24miss')
    29. 

  29. 			 ,ROLLING_LEN          = ?
    30. 

  30. 			 ,ROLLING_WGT          = ?
    31. 

  31. 			 ,ROLLING_HOUR         = ?
    32. 

  32. 			 ,ROLLING_TOT_LEN      = ?
    33. 

  33. 			 ,ROLLING_TOT_WGT      = ?
    34. 

  34. 			 ,ROLLING_TOT_HOUR     = ?
    35. 

  35. 			 ,CHANG_DTIME          = ? 
    36. 

  36. 			 --,TOP_BOT_CLF          = ''
    37. 

  37. 			 ,ASSEM_ROLL           = '' 
    38. 

  38. 		WHERE ROLL_NO = ?		  
    39. 

  39. 		]]>
    40. 

  40. 	</query> 
    41. 

  41. 	<query id="NIH020060_MOUNT_ROLL.update" desc="" fetchSize="10">
    42. 

  42. 		<![CDATA[
    43. 

  43. 			UPDATE TBH04_ROLL SET
    44. 

  44. 			  ROLL_STAT            = 'U'
    45. 

  45. 			 ,ROLL_STAT_DTIME      = to_char(SYSDATE,'yyyymmddhh24miss')
    46. 

  46. 			 ,ROLL_BEF_STAT1       = ROLL_STAT
    47. 

  47. 			 ,ROLL_BEF_STAT_DTIME1 = ROLL_STAT_DTIME
    48. 

  48. 			 ,ROLL_BEF_STAT2       = ROLL_BEF_STAT1
    49. 

  49. 			 ,ROLL_BEF_STAT_DTIME2 = ROLL_BEF_STAT_DTIME1
    50. 

  50. 			 ,ROLL_BEF_STAT3       = ROLL_BEF_STAT2 
    51. 

  51. 			 ,ROLL_BEF_STAT_DTIME3 = ROLL_BEF_STAT_DTIME2
    52. 

  52. 			 ,STAND_NO             = ? 
    53. 

  53. 		     ,TOP_BOT_CLF          = ? 
    54. 

  54.              ,ASSEM_ROLL           = ?
    55. 

  55. 			 ,USE_DTIME          = ?   
    56. 

  56. 		WHERE ROLL_NO = ?			  
    57. 

  57. 		]]>
    58. 

  58. 	</query> 
    59. 

  59.     
    60. 

  60. </queryMap>
    61.