XinYu_RZMES/.svn/pristine/7a/7aa3af3f1f29af39fb7dce6cc7a3de641f2c0ba6.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">    
    <query id="UIG040010_01.select" desc="板坯库板坯移动查询，FROM_YARD  数据来源：TBG02_SLAB_COMM，TBG04_SLAB_YARD">
        <![CDATA[
		  SELECT   YARD_ADDR FROM_YARD_ADDR
				   ,A.STORELAY FROM_STORELAY
			   	   ,A.SLAB_NO FROM_SLAB_NO
				   ,B.SLAB_THK FROM_SLAB_THK
				   ,B.SLAB_WTH FROM_SLAB_WTH
				   ,B.SLAB_LEN FROM_SLAB_LEN
				   ,B.SLAB_WGT FROM_SLAB_WGT
				   ,B.STL_GRD  FROM_STL_GRD
				   ,B.RHF_SCH_YN FROM_RHF_SCH_YN
       FROM        TBG04_SLAB_YARD A
				   ,TBG02_SLAB_COMM B
       WHERE       A.SLAB_NO = B.SLAB_NO(+)
       AND         A.YARD_ADDR = ?
	   ORDER BY    A.STORELAY DESC 	
        ]]>
    </query>
	<query id="UIG040010_02.select" desc="板坯库板坯移动查询，TO_YARD 数据来源：TBG02_SLAB_COMM，TBG04_SLAB_YARD">
        <![CDATA[
		  SELECT   YARD_ADDR TO_YARD_ADDR
				   ,A.STORELAY TO_STORELAY
			   	   ,A.SLAB_NO TO_SLAB_NO
				   ,B.SLAB_THK TO_SLAB_THK
				   ,B.SLAB_WTH TO_SLAB_WTH
				   ,B.SLAB_LEN TO_SLAB_LEN
				   ,B.SLAB_WGT TO_SLAB_WGT
				   ,B.STL_GRD  TO_STL_GRD
				   ,B.RHF_SCH_YN TO_RHF_SCH_YN
       FROM        TBG04_SLAB_YARD A
				   ,TBG02_SLAB_COMM B
       WHERE       A.SLAB_NO = B.SLAB_NO(+)
       AND         A.YARD_ADDR = ?
	   ORDER BY    A.STORELAY DESC 
        ]]>
    </query>
	<query id="UIG040010_03.select" desc="板坯库板坯移动查询，TO_YARD 数据来源：TBG02_SLAB_COMM，TBG04_SLAB_YARD">
        <![CDATA[
		   SELECT DISTINCT YARD_ADDR LABEL,YARD_ADDR VALUE FROM TBG04_SLAB_YARD WHERE SUBSTR(YARD_ADDR,1,3)  = ?
        ]]>
    </query>
	<query id="UIG040010_04.select" desc=" 按板坯号查询板坯所在位置 ">
        <![CDATA[
		   SELECT YARD_ADDR FROM TBG04_SLAB_YARD WHERE SLAB_NO = ?
        ]]>
    </query>
	<query id="UIG040010_01.update" desc="板坯库板坯移动修改  数据来源：TBG04_SLAB_YARD">
        <![CDATA[
		UPDATE TBG04_SLAB_YARD
		SET    SLAB_NO = ?
		WHERE YARD_ADDR = ?
		AND   STORELAY = ?
        ]]>
    </query>
	<query id="UIG040010_02.update" desc="板坯库板坯移动修改 数据来源：TBG04_SLAB_YARD">
        <![CDATA[
		UPDATE TBG04_SLAB_YARD
		SET    SLAB_NO = ?
		WHERE YARD_ADDR = ?
		AND   STORELAY = ?
        ]]>
    </query>
	<query id="UIG040010_01.delete" desc="板坯库板坯移动修改，FROM_YARD
		数据来源：TBG04_SLAB_YARD">
        <![CDATA[
		DELETE FROM TBG04_SLAB_YARD
		WHERE YARD_ADDR = ?
		AND   STORELAY = ?
        ]]>
    </query>
	<query id="UIG040010_02.insert" desc="板坯库板坯移动修改，TO_YARD
		数据来源：TBG04_SLAB_YARD">
        <![CDATA[
		INSERT INTO TBG04_SLAB_YARD
			(YARD_ADDR,STORELAY,SLAB_NO)
			VALUES(?,?,?)
        ]]>
    </query>
	<query id="UIG040010.INIT_PARAM_01" desc="This step query is update query   to TBG03_STLMAKE_PROG     ">
        <![CDATA[
        SELECT DISTINCT SUBSTR(YARD_ADDR,1,3) LABEL,SUBSTR(YARD_ADDR,1,3) VALUE  FROM TBG04_SLAB_YARD 
        ]]>
    </query>
    <query id="UIG040010_LOC.update" desc="板坯库板坯移动修改 数据来源：TBG02_SLAB_COMM">
        <![CDATA[
		UPDATE TBG02_SLAB_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 
		 ,HCR_CLF = 'C'	
		 ,MILL_SCH_STAT = null	
		WHERE SLAB_NO = ? 
        ]]>
    </query>
	<query id="UIG040010_FROM_SLAB_COMM.update" desc="板坯库板坯移动修改 数据来源：TBG02_SLAB_COMM">
        <![CDATA[
			/** UIG040010_FROM_SLAB_COMM.update **/
		UPDATE TBG02_SLAB_COMM  SET
      	 	 CUR_LOAD_LOC = ?
			 ,CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
			 ,CUR_PROG_CD_PGM = 'UIG040010'
			 ,BEF_LOAD_LOC =  CUR_LOAD_LOC
			 ,BEF_LOAD_LOC_DTIME  = CUR_LOAD_LOC_DTIME
			 ,BEF_PROG_CD_PGM = BEF_PROG_CD_PGM 
		WHERE SLAB_NO = ? 
        ]]>
    </query>
</queryMap>