XinYu_RZMES/.svn/pristine/42/4278d90df2ffe98e0a6f5f2a14ee11fc236d9c67.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH050700_01.select" desc="查询库存的列">
        <![CDATA[
			select distinct a.YARD_CLF LABEL ,A.YARD_CLF VALUE from tbh05_coil_yard a  
					where a.YARD_CLF like 'C1%' or a.YARD_CLF like 'C2%' or a.YARD_CLF like 'C3%'
					order by a.YARD_CLF  
		]]>
    </query>
	<query id="UIH050700_02.select" desc="查询库存临时垛位的列">
        <![CDATA[
			select distinct a.YARD_CLF LABEL ,A.YARD_CLF VALUE from tbh05_coil_yard a  
				where a.YARD_CLF like 'C4%'
				order by a.YARD_CLF 
		]]>
    </query>
	<query id="UIH050700_03.select" desc="查询库存信息">
        <![CDATA[
			select ''CHK,A.YARD_CLF||A.STEP_CLF||A.STORELAY||A.STORE_SEQ COIL_YARD,A.COIL_NO from tbh05_coil_yard a 
				   where a.YARD_CLF = ? 
					ORDER BY A.YARD_CLF,A.STEP_CLF,A.STORELAY,A.STORE_SEQ 
		]]>
    </query>
	<query id="UIH050700_04.select" desc="">
        <![CDATA[
			select A.COIL_NO from tbh05_coil_yard a where a.yard_clf||a.step_clf||a.storelay||a.store_seq = ? 
		]]>
    </query>
	<query id="UIH050700_05.select" desc=" 获取移动表的最大行数 ">
        <![CDATA[
			select max(ROLL_SEQ) ROLL_SEQ from tbh05_coil_move 
		]]>
    </query>
	<query id="UIH050700_04.update" desc="更新库存信息">
        <![CDATA[
		  update tbh05_coil_yard a set 
       			  a.COIL_NO = ?,
				  a.REG_ID  = ?,
			      a.REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')  
				   where a.YARD_CLF = ?
				  and  a.STEP_CLF = ?
				  and  a.STORELAY = ?
				  and a.STORE_SEQ = ? 
		]]>
    </query>
	<query id="UIH050700_05.update" desc="更新钢卷公共信息">
        <![CDATA[
      update tbh02_coil_comm a set 
               A.BEF_LOAD_LOC = CUR_LOAD_LOC,
               A.BEF_LOAD_LOC_DTIME = A.CUR_LOAD_LOC_DTIME,
               a.CUR_LOAD_LOC= ?,
               A.CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
           where a.OLD_SAMPL_NO = ?
		]]>
    </query>
	<query id="UIH050700_01.insert" desc=" 更新移垛操作表 ">
        <![CDATA[
			insert into tbh05_coil_move  T
      (    
           T.ROLL_SEQ,
           T.CUR_LOAD_LOC_F,
           T.CUR_LOAD_LOC_T,
           T.COIL_NO,
           T.REG_ID,
           T.REG_SHIFT,
           T.REG_GROUP,
           T.REG_DTIME,
           T.REG_USE_ID,
           T.REG_USE_DTIME        
      ) 
      VALUES
      (   
           ?,
           ?,
           ?,
           ?,
           ?,
           ?,
           ?,
           ?,
           ?,
           TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')   
      ) 
		]]>
    </query>
	<query id="UIH050700_06.update" desc="">
        <![CDATA[
		  update tbh05_coil_yard a set 
       			  a.COIL_NO = '',
				  a.REG_ID  = '',
			      a.REG_DTIME = ''  
				   where a.YARD_CLF = ?
				  and  a.STEP_CLF = ?
				  and  a.STORELAY = ?
				  and a.STORE_SEQ = ? 
		]]>
    </query>
	<query id="UIH050710_01.select" desc="手工移动，获取当前钢卷的位置">
        <![CDATA[
			select a.YARD_CLF||A.STEP_CLF||A.STORELAY||A.STORE_SEQ F_YARD_L 
				   from tbh05_coil_yard a where  a.COIL_NO = ? 
		]]>
    </query>
	<query id="UIH050710_02.select" desc="手工移动，获取当前位置上放的钢卷">
        <![CDATA[
			select a.COIL_NO T_COIL_L from tbh05_coil_yard a 
				where  a.YARD_CLF||A.STEP_CLF||A.STORELAY||A.STORE_SEQ = ? 
		]]>
    </query>
	<query id="UIH050710_03.select" desc="手工移动，查看希望移动卷的状态。为SFF的不能进行移动操作">
        <![CDATA[
			SELECT A.CUR_PROG_CD FROM TBH02_COIL_COMM A WHERE A.OLD_SAMPL_NO = ? 
		]]>
    </query>
</queryMap>