| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="NIH040010_01.select" desc=" " fetchSize="10">
- <![CDATA[
- SELECT
- GRIND_DTIME
- ,GRIND_STEPNO
- FROM TBH04_ROLL
- WHERE ROLL_NO = ?
- ]]>
- </query>
- <query id="NIH040010_01.update" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBH04_ROLL T SET
- T.GRINDER_NO = ?
- ,T.GRIND_BEF_DTIME = ?
- ,T.GRIND_USE_DTIME = ?
- ,T.GRIND_STEPNO = ?
- ,T.BEFORE_DIAMETER_HEAD = ?
- ,T.BEFORE_DIAMETER_POSITION =?
- ,T.BEFORE_DIAMETER_MIDDLE = ?
- ,T.BEFORE_DIAMETER_M_POSITION = ?
- ,T.BEFORE_DIAMETER_TAIL = ?
- ,T.BEFORE_DIAMETER_T_POSITION = ?
- ,T.AFTER_DIAMETER_HEAD = ?
- ,T.AFTER_DIAMETER_POSITION = ?
- ,T.AFTER_DIAMETER_MIDDLE = ?
- ,T.AFTER_DIAMETER_MIDDLE_POSITION = ?
- ,T.AFTER_DIAMETER_TAIL = ?
- ,T.AFTER_DIAMETER_T_POSITION = ?
- ,T.STOCK_REMOVAL = ?
- ,T.ROLL_CROWN_MAX = ?
- ,T.ROLL_CROWN_MIN = ?
- ,T.ROLL_CODE = ?
- ,T.GPROG_CODE = ?
- ,T.TAPER = ?
- ,T.ROUNDESS = ?
- ,T.RUNOUT = ?
- ,T.ROLL_ROUGHNESS = ?
- ,T.ROLL_SHAPE_CD = ?
- ,T.DRESS_CODE = ?
- ,T.OEPARTORID = ?
- ,T.HARDNESS = ?
- ,T.VALIDATE_OR_DISCARD = ?
- ,T.Crack_SEVERITY = ?
- ,T.Crack_Position = ?
- ,T.Crack_Angle = ?
- ,T.BRUISE_SEVERITY = ?
- ,T.BRUISE_POSITION = ?
- ,T.BRUISE_ANGLE = ?
- ,T.DEFECT_CODE = ?
- ,T.PROFILE_POINTS_NUM = ?
- ,T.PROFILE_POINT1 = ?
- ,T.PROFILE_POINT = ?
- ,T.PROFILE_POINT200 = ?
- ,T.ROLL_STAT = ?
- ,T.BEF_DIA = CUR_DIA
- ,T.CUR_DIA = ?/1000
- ---磨削时间 （结束时间-开始时间）
- ,T.GRIND_DTIME = ?
- WHERE ROLL_NO = ?
-
- ]]>
- </query>
-
- </queryMap>
|
