XinYu_RZMES/.svn/pristine/34/34d61f480527f58ce1bb523e83e9f1cf6679a74b.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIG04COMM_STORELAY_CHK.select" desc=" " fetchSize="10">
        <![CDATA[ 
	     SELECT  
	        DECODE(LENGTH(STORELAY),1,'0'||STORELAY ,STORELAY)  STORELAY
	     FROM 
	     (         
	      SELECT  decode(MAX(STORELAY),null,'01','','01', MAX(STORELAY)+1) STORELAY  
	         FROM  TBG04_SLAB_YARD 
	        WHERE ( SLAB_NO IS NOT NULL OR SLAB_NO = '')
	         AND  YARD_ADDR = ?
	     )   	
        ]]>
    </query>
    <query id="UIG04COMM_FROM_ADDR_CLEAR.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG04_SLAB_YARD 
		SET SLAB_NO = ''
			,BEF_STORE_LOC = ''
			,REG_ID = ''
			,REG_DTIME = ''
			,CR_NO = ''
			,ORD_FLAG = ''
		WHERE YARD_ADDR = ?
		AND   STORELAY = ?
		]]>
	</query>
	<query id="UIG04COMM_FROM_ADDR_CLEAR_BY_SLABN0.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG04_SLAB_YARD 
		SET SLAB_NO = ''
			,BEF_STORE_LOC = ''
			,REG_ID = ''
			,REG_DTIME = ''
			,CR_NO = ''
			,ORD_FLAG = ''
		WHERE SLAB_NO = ?
		]]>
	</query>
	<query id="UIG04COMM_TO_ADDR_SET.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG04_SLAB_YARD 
		SET SLAB_NO = ?
			,BEF_STORE_LOC = ?
			,CR_NO = ?
			,REG_ID = ?
			,REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
			,ORD_FLAG = ?
		WHERE YARD_ADDR = ?
		AND   STORELAY = ?
		]]>
	</query>
	
	<query id="UIG04COMM_SLAB_G_COMM_TAKEOUT.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG02_SLAB_COMM 
		SET    CUR_LOAD_LOC = ? 
			   ,FINAL_ORD_NO = ORD_NO
           	   ,FINAL_ORD_SEQ = ORD_SEQ
			   ,SMS_YARD_EXT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
		WHERE  SLAB_NO  = ?
		]]>
	</query>
	<query id="UIG04COMM_SLAB_H_COMM_TAKEOUT.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG02_SLAB_COMM 
		SET    CUR_LOAD_LOC = ? 
			   ,SLAB_STOCK_EXT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
		WHERE  SLAB_NO  = ?
		]]>
	</query>
	<query id="UIG04COMM_SLAB_G_COMM_TAKEIN.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG02_SLAB_COMM 
			SET    CUR_LOAD_LOC = ? 
	         	   ,SMS_YARD_ENT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
	    WHERE  SLAB_NO  = ?
		]]>
	</query>
	<query id="UIG04COMM_SLAB_G_COMM_TAKEIN_02.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG02_SLAB_COMM 
			SET    CUR_LOAD_LOC = ?
				   ,SLAB_STOCK_TYPE = ?
				   ,BEF_LOAD_LOC =  CUR_LOAD_LOC 
				   ,CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
				   ,BEF_LOAD_LOC_DTIME  = CUR_LOAD_LOC_DTIME
				   ,HCR_CLF = 'C'
				   ,MILL_SCH_STAT = NULL
	         	   ,SMS_YARD_ENT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
	    WHERE  SLAB_NO  = ?
		]]>
	</query>
	<query id="UIG04COMM_SLAB_G_COMM_TAKEIN_03.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG02_SLAB_COMM 
			SET    CUR_LOAD_LOC = ?
				   ,SLAB_STOCK_TYPE = ?
				   ,BEF_LOAD_LOC =  CUR_LOAD_LOC 
				   ,CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
				   ,BEF_LOAD_LOC_DTIME  = CUR_LOAD_LOC_DTIME
				   ,HCR_CLF = ?
				   ,MILL_SCH_STAT = NULL
	         	   ,SMS_YARD_ENT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
	    WHERE  SLAB_NO  = ?
		]]>
	</query>
	<query id="UIG04COMM_SLAB_H_COMM_TAKEIN.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG02_SLAB_COMM 
			SET    CUR_LOAD_LOC = ? 
				   ,SLAB_STOCK_ENT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
	    WHERE  SLAB_NO  = ?
		]]>
	</query>
	<query id="UIG04COMM_SLAB_H_COMM_TAKEIN_02.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG02_SLAB_COMM 
			SET    CUR_LOAD_LOC = ?
				   ,SLAB_STOCK_TYPE = ?
				   ,BEF_LOAD_LOC =  CUR_LOAD_LOC 
				   ,CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
				   ,BEF_LOAD_LOC_DTIME  = CUR_LOAD_LOC_DTIME
				   ,HCR_CLF = 'C'
				   ,MILL_SCH_STAT = NULL
	         	   ,SLAB_STOCK_ENT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
	         	   ,SLAB_EXT_RZ_TIME = (CASE WHEN SLAB_EXT_RZ_TIME IS NULL THEN TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') ELSE SLAB_EXT_RZ_TIME END)
	         	   --新增二钢出库到热轧时间  jiangxin 20201010
	    WHERE  SLAB_NO  = ?
		]]>
	</query>
	<query id="UIG04COMM_SLAB_H_COMM_TAKEIN_03.update" desc="  " fetchSize="10">
		<![CDATA[
	    UPDATE TBG02_SLAB_COMM 
			SET    CUR_LOAD_LOC = ?
				   ,SLAB_STOCK_TYPE = ?
				   ,BEF_LOAD_LOC =  CUR_LOAD_LOC 
				   ,CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
				   ,BEF_LOAD_LOC_DTIME  = CUR_LOAD_LOC_DTIME
				   ,HCR_CLF = ?
				   ,MILL_SCH_STAT = NULL
	         	   ,SLAB_STOCK_ENT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
	    WHERE  SLAB_NO  = ?
		]]>
	</query>
	<query id="UIG04COMM_CRATE_CRNO_CHECK_01.select" desc="  " fetchSize="10">
		<![CDATA[
		    SELECT
	            a.STORELAY,ORD_FLAG  
	        FROM 
	        (     
	         SELECT  STORELAY ,ORD_FLAG
	           FROM TBG04_SLAB_YARD
	          WHERE SLAB_NO = ?
	            AND YARD_ADDR = ?
	        ) a,
	        (     
	         SELECT  MAX(STORELAY) STORELAY 
	           FROM   TBG04_SLAB_YARD
	          WHERE  SLAB_NO IS NOT NULL  
	            AND YARD_ADDR = ?
	            AND ORD_FLAG IS NULL
	        ) b 
	        WHERE a.STORELAY = b.STORELAY 
		]]>
	</query>
	<query id="UIG04COMM_CRATE_CRNO_CHECK_02.select" desc="  " fetchSize="10">
		<![CDATA[
		    SELECT  a.SLAB_NO, a.ORD_FLAG              
	         FROM 
	          ( 
	          SELECT   SLAB_NO,STORELAY ,ORD_FLAG
	              FROM   TBG04_SLAB_YARD
	             WHERE  
	                  SLAB_NO  IS NOT NULL  
	             AND  YARD_ADDR = ?
	          ) a,   
	          (
	            SELECT   STORELAY 
	              FROM   TBG04_SLAB_YARD
	             WHERE   SLAB_NO = ?
	               AND   YARD_ADDR = ?
	           ) b
	           WHERE ORD_FLAG IS NULL
	             AND  a.STORELAY > b.STORELAY
		]]>
	</query>
	<query id="UIG04COMM_CRATE_CRNO_CHECK_03.select" desc="  " fetchSize="10">
		<![CDATA[
		    SELECT * FROM TBG04_SLAB_CRANE_ORDER T WHERE T.ORD_STAT = '1' AND T.ORD_SLAB_NO1 = ?
		]]>
	</query>
	<query id="UIG04COMM_CR_ORD.update" desc="" fetchSize="10">
        <![CDATA[
			UPDATE TBG04_SLAB_CRANE_ORDER SET ORD_STAT = ?
			WHERE SEQ_NO = ? 
        ]]>
    </query>
    <query id="UIG04COMM_L1_TAKEIN.update" desc="" fetchSize="10">
        <![CDATA[
          UPDATE TBH06_L1_SEND_SLAB_TAKEIN SET    
             MSG_FLAG       = 'N' 
            ,TC_ID          =  ? 
            ,TRANS_DTIME    = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
            ,SLAB_NO        = ?
            ,LINE_POSITION  = ?
            ,HCR_CLF        = ?
            ,DEST_POSITION  = ?
		  WHERE SEQ_NO = ?
        ]]>
    </query>
    <query id="UIG04COMM_L1_TAKEIN.insert" desc="" fetchSize="10">
        <![CDATA[
			INSERT INTO TBH06_L1_SEND_SLAB_TAKEIN  
	      (	 SEQ_NO
			,MSG_FLAG  
            ,TC_ID
            ,TRANS_DTIME
            ,SLAB_NO
            ,LINE_POSITION
            ,HCR_CLF 
            ,DEST_POSITION
		  ) VALUES
		  ( 
		    TBH06_L1_SEND_SLAB_TAKEIN_SEQ.NEXTVAL
		   ,'N'
		   ,?
		   ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		   ,?
		   ,?
		   ,?
		   ,?
		  )	  
        ]]>
    </query>
    <query id="UIG04COMM_L2_TAKEIN.update" desc="" fetchSize="10">
        <![CDATA[
          UPDATE  TBH06_L2_SEND_SLAB_TAKEIN   SET
           
             MSG_FLAG        =  'N'
            ,TC_ID           = ?
            ,TRANS_DTIME     = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
            ,SEND_DC         = 'FU'
            ,RECV_DC         = 'HM'
            ,SERIAL_NO       = ' '
            ,RESERVED        = ' '
            ,LINE_POSITON    = ?
            ,SLAB_NO         = ?
            ,COIL_NO         = ? 
            ,LINE_UP_DTIME   = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
           WHERE SEQ_NO = ?
        ]]>
    </query>
    <query id="UIG04COMM_L2_TAKEIN.insert" desc="" fetchSize="10">
        <![CDATA[
            INSERT INTO TBH06_L2_SEND_SLAB_TAKEIN  
          (  SEQ_NO
            ,MSG_FLAG  
            ,TC_ID
            ,TRANS_DTIME
			,SEND_DC
			,RECV_DC
			,SERIAL_NO
			,RESERVED 
            ,LINE_POSITON
			,SLAB_NO
			,COIL_NO
            ,LINE_UP_DTIME 
          ) VALUES
          ( 
            TBH06_L1_SEND_SLAB_TAKEIN_SEQ.NEXTVAL
           ,'N'
           ,?
           ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		   ,'FU'
		   ,'HM'
		   ,''
		   ,''   			
           ,?
           ,?
           ,?
           ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
          )   
        ]]>
    </query>
    <query id="UIGCOMM_L1_LOCK.update" desc="" fetchSize="10">
        <![CDATA[
          UPDATE  TBH06_L1_SEND_SLAB_LOCK  SET
          
             MSG_FLAG       = ?
            ,TC_ID          = ?
            ,TRANS_DTIME    = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
            ,LOCK_FLAG      = ?
            ,LINE_POSITION  = ?
            ,SEND_DTIME     = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
           WHERE SEQ_NO = ?
        ]]>
    </query>
    <query id="UIGCOMM_L1_LOCK.insert" desc="" fetchSize="10">
        <![CDATA[
			INSERT INTO TBH06_L1_SEND_SLAB_LOCK 
	      (	 SEQ_NO
			,MSG_FLAG 
            ,TC_ID
            ,TRANS_DTIME
            ,LOCK_FLAG
            ,LINE_POSITION
            ,SEND_DTIME
		  ) VALUES
		  ( 
		    TBH06_L1_SEND_SLAB_LOCK_SEQ.NEXTVAL
		   ,?
		   ,?
		   ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		   ,?
		   ,?
		   ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
		  )	  
        ]]>
    </query>
</queryMap>