Inicio Explorar Axuda
Iniciar sesión
wudonglin
/
XinYu_RZMES
1
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Árbore: 1105ec3dbe
Ramas Etiquetas
XinYu_RZMES
/
.svn
/
pristine
/
e5
/
e533971ae5df55eae1662e2798148d13c6e86e5a.svn-base

e533971ae5df55eae1662e2798148d13c6e86e5a.svn-base 1.8 KB
Histórico Raw

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

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

  3.     <query id="NIH040010_01.select" desc=" " fetchSize="10">
    4. 

  4. 		<![CDATA[
    5. 

  5. 		SELECT
    6. 

  6. 		  GRIND_DTIME
    7. 

  7. 		,GRIND_STEPNO  
    8. 

  8. 		FROM   TBH04_ROLL  
    9. 

  9. 		WHERE ROLL_NO = ?  
    10. 

  10. 		]]>
    11. 

  11. 	</query>
    12. 

  12. 	<query id="NIH040010_01.update" desc=" " fetchSize="10">
    13. 

  13. 		<![CDATA[
    14. 

  14.     UPDATE TBH04_ROLL T SET
    15. 

  15.         T.GRINDER_NO = ?
    16. 

  16.        ,T.GRIND_BEF_DTIME = ?
    17. 

  17.        ,T.GRIND_USE_DTIME = ?
    18. 

  18.        ,T.GRIND_STEPNO = ?
    19. 

  19.        ,T.BEFORE_DIAMETER_HEAD = ?
    20. 

  20.        ,T.BEFORE_DIAMETER_POSITION =?
    21. 

  21.        ,T.BEFORE_DIAMETER_MIDDLE = ?
    22. 

  22.        ,T.BEFORE_DIAMETER_M_POSITION = ?
    23. 

  23.        ,T.BEFORE_DIAMETER_TAIL = ?
    24. 

  24.        ,T.BEFORE_DIAMETER_T_POSITION = ? 
    25. 

  25.        ,T.AFTER_DIAMETER_HEAD = ?
    26. 

  26.        ,T.AFTER_DIAMETER_POSITION = ?
    27. 

  27.        ,T.AFTER_DIAMETER_MIDDLE = ?
    28. 

  28.        ,T.AFTER_DIAMETER_MIDDLE_POSITION = ?
    29. 

  29.        ,T.AFTER_DIAMETER_TAIL = ? 
    30. 

  30.        ,T.AFTER_DIAMETER_T_POSITION = ?
    31. 

  31.        ,T.STOCK_REMOVAL = ? 
    32. 

  32.        ,T.ROLL_CROWN_MAX = ?
    33. 

  33.        ,T.ROLL_CROWN_MIN = ? 
    34. 

  34.        ,T.ROLL_CODE = ? 
    35. 

  35.        ,T.GPROG_CODE = ?
    36. 

  36.        ,T.TAPER = ?
    37. 

  37.        ,T.ROUNDESS = ?
    38. 

  38.        ,T.RUNOUT = ?
    39. 

  39.        ,T.ROLL_ROUGHNESS = ?
    40. 

  40.        ,T.ROLL_SHAPE_CD = ?
    41. 

  41.        ,T.DRESS_CODE = ?
    42. 

  42.        ,T.OEPARTORID = ?
    43. 

  43.        ,T.HARDNESS = ?
    44. 

  44.        ,T.VALIDATE_OR_DISCARD = ?
    45. 

  45.        ,T.Crack_SEVERITY = ?
    46. 

  46.        ,T.Crack_Position = ?
    47. 

  47.        ,T.Crack_Angle = ?
    48. 

  48.        ,T.BRUISE_SEVERITY = ?
    49. 

  49.        ,T.BRUISE_POSITION = ?
    50. 

  50.        ,T.BRUISE_ANGLE = ?
    51. 

  51.        ,T.DEFECT_CODE = ?
    52. 

  52.        ,T.PROFILE_POINTS_NUM = ?
    53. 

  53.        ,T.PROFILE_POINT1 = ?
    54. 

  54.        ,T.PROFILE_POINT = ?
    55. 

  55.        ,T.PROFILE_POINT200 = ?
    56. 

  56.        ,T.ROLL_STAT = ? 
    57. 

  57.        ,T.BEF_DIA = CUR_DIA
    58. 

  58.        ,T.CUR_DIA = ?/1000
    59. 

  59.        ---磨削时间 （结束时间-开始时间）
    60. 

  60.        ,T.GRIND_DTIME = ?
    61. 

  61.       WHERE ROLL_NO = ?
    62. 

  62.     
    63. 

  63. 		]]>
    64. 

  64. 	</query>
    65. 

  65. 	 		
    66. 

  66. </queryMap>
    67.