XinYu_RZMES/.svn/pristine/43/4320173f241e27b1b39ce27ec5fc614c169f0089.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH040040_01.select" desc="轧辊状态是磨削等待(‘S’)为条件" fetchSize="10">
		<![CDATA[
        select '' CHK,
          ROLL_NO,
          ROLL_TYPE,
          ROLL_SHAPE_CD,
          DISUSE_DIA,
          ENT_DIA,
          BEF_DIA,
          ROLL_MAT_QLTY,
          SURFACE_HARD,
          GRIND_STEPNO,
          CHANG_DTIME,
          GRIND_DTIME,
          SONIC_SIGHT ,
          GRID_SCH,
          SEND_CLF,
          POSITION_CLF,
          ASSEM_ROLL_L1,
          ROLL_CUR_DIA,
          SURFACE_ROUGH_L1,
          ROLL_SHAPE_CD_L1,
          DRESS_CODE_L1,
          GPROG_CODE_L1,
          ROLL_CODE_L1,
          GRINDER_NO   
           from TBH04_ROLL 
           where ROLL_STAT = 'S' or ROLL_STAT = 'I'
      AND ROLL_NO LIKE ?||'%'
		]]>
	</query>
	<query id="UIH040040_02.select" desc="轧辊状态是磨削等待(‘G’)为条件" fetchSize="10">
		<![CDATA[
        select '' CHK,
          ROLL_NO,
          ROLL_TYPE,
          ENT_DIA,
          DISUSE_DIA,
          BEF_DIA,
          CUR_DIA,
          GRIND_STEPNO,
          GRIND_DTIME,
          ENT_ROLL_WKSHIFT,
          ENT_ROLL_WKSGROUP,
          ROLL_ENT_EMP_ID,
          ROLL_SHAPE_CD,
          SONIC_SIGHT,
          ROLL_MAT_QLTY,
          GRIND_USE_DTIME,
          BEFORE_DIAMETER_HEAD,
          BEFORE_DIAMETER_MIDDLE,
          BEFORE_DIAMETER_TAIL,
          AFTER_DIAMETER_HEAD,
          AFTER_DIAMETER_MIDDLE,
          AFTER_DIAMETER_TAIL,
          STOCK_REMOVAL,
          ROLL_CROWN_MAX,
          ROLL_CROWN_MIN,
          TAPER,
          ROUNDESS,
          RUNOUT,
          ROLL_ROUGHNESS,
          OEPARTORID,
          HARDNESS,
          CRACK_SEVERITY,
          CRACK_POSITION,
          CRACK_ANGLE,
          BRUISE_SEVERITY,
          BRUISE_POSITION,
          BRUISE_ANGLE    
          
           from tbh04_roll 
           where ROLL_STAT = 'G'
		]]>
	</query>
	<query id="UIH040040_01.update" desc="更新" fetchSize="10">
		<![CDATA[
		    update tbh04_roll
			set
			ROLL_TYPE =?,
			ENT_DIA =?,
			DISUSE_DIA =?,
			BEF_DIA =?,
			CUR_DIA =?,
			GRIND_STEPNO =?,
			GRIND_DTIME =?,
			ENT_ROLL_WKSHIFT =?,
			ENT_ROLL_WKSGROUP =?,
			ROLL_ENT_EMP_ID =?,
			ROLL_SHAPE_CD =?,
			SONIC_SIGHT =?,
			SURFACE_HARD =?,
			ROLL_STAT = ?,
			GRIND_USE_DTIME = ?,
			GRID_SCH = null
			where ROLL_NO =?
		]]>
	</query>
	<query id="UIH040040_01.insert" desc="废弃" fetchSize="10">
		<![CDATA[
		    insert into tbh04_roll
			(
			ROLL_NO,
			ROLL_TYPE,
			ENT_DIA,
			DISUSE_DIA,
			BEF_DIA,
			CUR_DIA,
			GRIND_STEPNO,
			GRIND_DTIME,
			ENT_ROLL_WKSHIFT,
			ENT_ROLL_WKSGROUP,
			ROLL_ENT_EMP_ID,
			ROLL_SHAPE_CD,
			ROLL_STAT 
			)
			values(?,?,?,?,?,?,?,?,?,?,?,?,'G')
		]]>
	</query>	
	<query id="UIH040040_L1_SEND.insert" desc="废弃" fetchSize="10">
        <![CDATA[
             INSERT INTO TBH06_L1_SEND_ROLL T
        (
         SEQ_NO 
         ,MSG_FLAG
         ,ROLL_NO 
         ,CUR_DIA 
         ,ROLL_TYPE 
         ,MILL_MCH_CLF
         ,POSITION_CLF
         ,ASSEM_ROLL
         ,SURFACE_ROUGH
         ,ROLL_SHAPE_CD
         ,DRESS_CODE
         ,GPROG_CODE
         ,ROLL_CODE
         ,GRINDER_NO
		 ,ROLL_MAT_QLTY
         ,TRANS_DTIME 
         )
        values
        (tbh06_l1_send_roll_seq.nextval
        ,'N'
        ,?
        ,?
        ,?
        ,?
        ,?
        ,?
        ,?
        ,?
        ,?
        ,?
        ,?
        ,?
		,?
        ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'))
        ]]>
    </query>    
	<query id="UIH040040_SCH_UPD.update" desc="更新" fetchSize="10">
        <![CDATA[
             UPDATE TBH04_ROLL SET  
              GRID_SCH  = ?,
              SEND_CLF  = ?,
              POSITION_CLF = ?,
              ASSEM_ROLL_L1 = ?,
              ROLL_CUR_DIA  = ?,
              SURFACE_ROUGH_L1 = ?,
              ROLL_SHAPE_CD_L1 = ?,
              DRESS_CODE_L1 = ?,
              GPROG_CODE_L1 = ?,
              ROLL_CODE_L1  = ?,
              GRINDER_NO = ?,
              GRIND_EMPNO_L1 = ?,
              GRIND_EMPNO_L1_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')    
            WHERE ROLL_NO =?
        ]]>
    </query>
		<query id="UIH040040_11.update" desc="接收电文后更新磨削后直径" fetchSize="10">
		<![CDATA[
		    update tbh04_roll  set 
				  BEF_DIA =?,
				  CUR_DIA =?,
				  GRIND_XG_NO_L1 = ?,
				  GRIND_XG_DTIME_L1 = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
				  where ROLL_NO =?
		]]>
	</query>
</queryMap>