XinYu_RZMES/.svn/pristine/16/16b9117b1b55e1b544b9da7e4b5e9dc9d39ed32c.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH050030_CR_COMM.select" desc="" fetchSize="10">
		<![CDATA[
	   SELECT '' CHK,FROM_ADDR,TO_ADDR,COIL_NO OLD_SAMPL_NO,CR_NO,REG_DTIME,ORD_SEQ,CMD_CLF

        FROM TBH05_COIL_CRANE_ORDER
       WHERE FROM_ADDR LIKE ? || '%'
         AND (CR_NO IS NULL OR CR_NO LIKE ?||'%')
		AND ORD_STAT = '1'	
		 
		]]>
	</query> 
	<query id="UIH050030_YARD_FROM.select" desc="" fetchSize="10">
		<![CDATA[
	     SELECT STORELAY,YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ FROM_ADDR
               ,a.COIL_NO FROM_COIL_NO 
			         ,b.COIL_OUTDIA FROM_OUT_DIA
           FROM TBH05_COIL_YARD a,TBH02_COIL_COMM b
           WHERE  a.COIL_NO = b.OLD_SAMPL_NO(+)
		   AND b.COIL_STAT = '2'	
           AND YARD_CLF LIKE ?||'%'
		]]>
	</query> 
	<query id="UIH050030_YARD_TO.select" desc="" fetchSize="10">
		<![CDATA[
	     SELECT STORELAY,YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ TO_ADDR
               ,a.COIL_NO TO_COIL_NO,
               b.COIL_OUTDIA TO_OUT_DIA
           FROM TBH05_COIL_YARD a,TBH02_COIL_COMM b 
           WHERE  a.COIL_NO = b.OLD_SAMPL_NO(+) 
			 AND  b.COIL_STAT = '2' 
             AND YARD_CLF LIKE ?||'%'
		]]>
	</query> 
	<query id="UIH050030_LOCK.select" desc="查询是否已经锁定标志位信息 2是已锁定 1是未锁定" fetchSize="10">
		<![CDATA[
	     SELECT DECODE(LOCK_YN,'2','已锁定','未锁定' ) LOCK_YN
           FROM TBH05_STD_COIL_YARD 
         WHERE YARD_ADDR = ?
		]]>
	</query> 
	<query id="UIH050030_STEP_CLF.select" desc=" 通过选择仓库区分来获得具体的位置信息 " fetchSize="10">
		<![CDATA[
	     SELECT DISTINCT SUBSTR(YARD_CLF,3,1) LABEL,SUBSTR(YARD_CLF,3,1) VALUE FROM TBH05_COIL_YARD WHERE YARD_CLF LIKE ?||'%'  
		]]>
	</query> 
	<query id="UIH050030_FROM.update" desc="   " fetchSize="10">
		<![CDATA[
		 UPDATE  TBH05_COIL_YARD SET
            COIL_NO = NULL
           ,CR_NO = NULL
           ,REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
         WHERE YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ = ?  
		]]>
	</query>
	<query id="UIH050030_TO.update" desc="   " fetchSize="10">
		<![CDATA[
		 UPDATE  TBH05_COIL_YARD SET
           COIL_NO = ? 
          ,CR_NO   = ? 
          ,REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
         WHERE YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ = ?   
		]]>
	</query>
	<query id="UIH050030_cr_cmd.update" desc="   " fetchSize="10">
		<![CDATA[
		 UPDATE  TBH05_COIL_CRANE_ORDER SET
		   REG_ID = ? 	
          ,ORD_STAT = '2'  
          ,REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
         WHERE ORD_SEQ = ?   
		]]>
	</query>
	<query id="UIH050030_RESERV_FL.update" desc=" 解除对钢卷仓库内位置和步进梁的锁定操作  " fetchSize="10">
		<![CDATA[
		 UPDATE  TBH05_COIL_YARD SET
            RESERV_FL = '' 
         WHERE YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ = ?  
		]]>
	</query>
	<query id="UIH050030_LOCK_SEND.insert" desc=" 发送锁定电文信息 这里LOCK_FLAG标志给为1，待锁定 " fetchSize="10">
		<![CDATA[
		  INSERT INTO TBH06_L1_SEND_COIL_LOCK 
		  (
		     SEQ_NO
		    ,MSG_FLAG
		    ,TC_ID
		    ,TRANS_DTIME
		    ,LINE_POSITION
		    ,SEND_DTIME
			,LOCK_FLAG
		  )
		  VALUES
		  (
		     TBH06_L1_SEND_COIL_LOCK_SEQ.NEXTVAL
		    ,'N'
		    ,?
		    ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		    ,?
		    ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
			,'1'
		  )
		]]>
	</query>
	<query id="UIH050030_TAKEIN_SEND.insert" desc=" 放入保存的同时要给出这个信息  " fetchSize="10">
		<![CDATA[
		  INSERT INTO TBH06_L1_SEND_COIL_TAKEIN 
		  (
		     SEQ_NO
		    ,MSG_FLAG
		    ,TC_ID
		    ,TRANS_DTIME
		    ,COIL_NO
		    ,LINE_POSITION
		    ,YARD_LOC
		    ,TAKE_IN_DTIME
		  )
		  VALUES
		  (
		     TBH06_L1_SEND_COIL_TAKEIN_SEQ.NEXTVAL
		    ,'N'
		    ,?
		    ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		    ,?
		    ,?
		    ,?
		    ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		  )
		]]>
	</query>
	<query id="UIH050030_TAKEOUT_SEND.insert" desc="  拿出保存要更新这个信息 " fetchSize="10">
		<![CDATA[
		  INSERT INTO TBH06_L1_SEND_COIL_TAKEOUT 
		  (
		     SEQ_NO
		    ,MSG_FLAG
		    ,TC_ID
		    ,TRANS_DTIME
		    ,COIL_NO
		    ,LINE_POSITION
		    ,YARD_LOC
		    ,TAKE_OUT_DTIME
		  )
		  VALUES
		  (
		     TBH06_L1_SEND_COIL_TAKEOUT_SEQ.NEXTVAL
		    ,'N'
		    ,?
		    ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		    ,?
		    ,?
		    ,?
		    ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		  )
		]]>
	</query>
	<query id="UIH050030_COIL_COMM" desc=" 保存去向位置到钢卷公共表的现在存放位置字段 " fetchSize="10">
		<![CDATA[
		    UPDATE tbh02_coil_comm SET
                     CUR_LOAD_LOC = ?
                     ,CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
                     ,BEF_LOAD_LOC = CUR_LOAD_LOC
                     ,BEF_LOAD_LOC_DTIME = CUR_LOAD_LOC_DTIME 
			      where OLD_SAMPL_NO = ? 
		]]>
	</query>
	<query id="UIH050030_CUR_PROG_CD" desc=" 下车行车命令执行完成改变物料进程状态 " fetchSize="10">
		<![CDATA[
		    UPDATE tbh02_coil_comm SET
                      SHIP_PROG_CD = '06',
                      CUR_LOAD_LOC = ?,
			          TRNF_DTIME   = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),
                      CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),
                      BEF_LOAD_LOC = CUR_LOAD_LOC,
                      BEF_LOAD_LOC_DTIME = CUR_LOAD_LOC_DTIME   
			                          where OLD_SAMPL_NO = ? 
		]]>
	</query>
</queryMap>