XinYu_RZMES/.svn/pristine/ba/ba18fff9882a76fabfcede9c9092f26863e93f79.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS    ">
              
   <query id="NIG020200_SPEC_CHARGE.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 通过电文中接收的炉次号查询炉次参数表 TBF01_SPEC_CHARGE 取得的数据项 ，修改炼钢公共表 TBF02_CHARGE_COMM */
           SELECT      a.CAST_CHARGE_SEQ
               , a.CAST_EDT_CHARGE_CNT
               , a.PRODNM_CD
               , a.STL_GRD  
               , a.LINE_PROC_CD
               , a.HCR_CLF
               , a.SPEC_ABBSYM
               , a.CAST_MANA_NO
               , a.CHARGE_MANA_NO
               , a.CAST_EDT_CHARGE_CNT
               , a.PREV_CHARGE_WGT
               , b.SLAB_RT
			   , a.STATUS_CD 
           FROM TBF01_SPEC_CHARGE a,
                TBF01_SPEC_SLAB b 
          WHERE  a.CHARGE_MANA_NO =  b.CHARGE_MANA_NO
            AND a.CHARGE_MANA_NO =  ?
            AND ROWNUM = 1  
        ]]>
    </query>
    <query id="NIG020200_SPEC_SLAB.select" desc="   " fetchSize="10">
        <![CDATA[
		 SELECT SLAB_EDT_SEQ,SLAB_MANA_NO,STL_GRD,SLAB_THK,SLAB_WTH,SLAB_LEN,SLAB_WGT,PRODNM_CD,
		        ORD_FL,ORD_NO,ORD_SEQ,HCR_CLF,SPEC_ABBSYM,ORD_THK,ORD_WTH,
		        ORD_LEN,ORD_WGT,COIL_INDIA,COIL_OUTDIA,ORD_WGT,SLAB_RT,CAST_MANA_NO 
		   FROM  TBF01_SPEC_SLAB     
          WHERE SUBSTR(SLAB_MANA_NO,1,10) = ? 
          ORDER BY SLAB_EDT_SEQ
        ]]>
    </query>
    <query id="NIG020200_SPEC_SLAB_D.select" desc="   " fetchSize="10">
        <![CDATA[
		 SELECT SLAB_CUT_SEQ,SLAB_THK,SLAB_WTH,SLAB_LEN,SLAB_WGT,ORD_THK,ORD_WTH,
		        ORD_LEN,ORD_WGT,COIL_INDIA,COIL_OUTDIA,ORD_NO,ORD_SEQ,ORD_FL 
		   FROM  TBF01_SPEC_SLAB_D     
          WHERE SLAB_EDT_SEQ = ? 
        ]]>
    </query>
    <query id="NIG020200_CREATE_SLAB.select" desc="   " fetchSize="10">
        <![CDATA[
		 SELECT SLAB_NO 
		  FROM  TBG02_SLAB_COMM
          WHERE SLAB_NO = ? 
        ]]>
    </query>
    <query id="NIG020200_CREATE_SLAB_D.select" desc="   " fetchSize="10">
        <![CDATA[
		 SELECT SLAB_NO 
		  FROM  TBG02_SLAB_COMM_D
          WHERE SLAB_NO = ? 
        ]]>
    </query>
	<query id="NIG020200_LD_CCM_DEP_DTIME.update" desc="   " fetchSize="10">
        <![CDATA[
		 UPDATE TBG03_LADLE_PROG  
         SET CURR_CHARGE_NO = ''
             ,CCM_DEP_DTIME = ?
         WHERE CURR_CHARGE_NO = ?
        ]]>
    </query>
    <query id="NIG020200_CREATE_SLAB.insert" desc="   " fetchSize="10">
        <![CDATA[
		 INSERT INTO TBG02_SLAB_COMM 
		 ( SLAB_NO
		  ,PLAN_SLAB_NO
		  ,SLAB_STAT
		  ,STL_GRD
		  ,INSTR_SLAB_THK
		  ,INSTR_SLAB_WTH
		  ,INSTR_SLAB_LEN
		  ,INSTR_SLAB_WGT
		  ,PRODNM_CD
		  ,ORD_FL
		  ,ORD_NO
		  ,ORD_SEQ
		  ,HCR_CLF
		  ,SPEC_ABBSYM 
		  ,REG_DTIME
		  ,INSTR_ORD_FL
		  ,ORG_ORD_NO
		  ,ORG_ORD_SEQ 
		  ,INSTR_COIL_THK
		  ,INSTR_COIL_WTH
		  ,INSTR_COIL_LEN
		  ,INSTR_COIL_INDIA
		  ,INSTR_COIL_OUTDIA
		  ,INSTR_COIL_WGT
	      ,SLAB_RT
		  ,CAST_NO	
		  )
		 VALUES 
		 ( ?
		  ,?
		  ,'1'
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?
		  ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?
		  ,?		
		     ) 
        
        ]]>
    </query>
    <query id="NIG020200_CREATE_SLAB_D.insert" desc="   " fetchSize="10">
        <![CDATA[
		 INSERT INTO TBG02_SLAB_COMM_D 
		 ( SLAB_NO,SLAB_CUT_SEQ,SLAB_THK,SLAB_WTH,SLAB_LEN,ORD_THK,ORD_WTH,ORD_LEN,ORD_WGT,COIL_INDIA,COIL_OUTDIA,ORD_NO,ORD_SEQ,ORD_FL  )
		 VALUES 
		 ( ?,?,?,?,?,?,?,?,?,?,?,?,?,? ) 
        
        ]]>
    </query>
    <query id="NIG020200_SMS_PROG.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 通过电文信息中的 炉次号 工序号 机号 查询 炼钢进程信息表 BG03_STLMAKE_PROG 
			   如果没有返回记录 则当前炼钢进程刚发生 在炼钢进程信息表中增加一条记录，否则修改记录 */
          SELECT CHARGE_NO
          FROM TBG03_STLMAKE_PROG      
          WHERE CHARGE_NO = ?
            AND PROC_CD = ?
            AND TREAT_CD = ? 
        ]]>
    </query>
    <query id="NIG020200_CHARGE_COMM.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 通过电文中接收的炉次号查询炉次参数表 TBF01_SPEC_CHARGE 取得的数据项 ，修改炼钢公共表 TBF02_CHARGE_COM */
         update TBG02_CHARGE_COMM set
              CHARGE_STAT         = '2' 
             ,INSTR_RT            =?
             ,STL_GRD             =?
             ,PRODNM_CD           =?
             ,SPEC_ABBSYM         =?
             ,HCR_CLF             =?
             ,CAST_EDT_CHARGE_CNT = ?
             ,CAST_CHARGE_SEQ     = ? 
             ,CUR_PROG_CD         = ? 
             ,BEF_PROG_CD         = ?
             ,TD_NO               = ?
             ,MD_NO1              = ?
             ,MD_NO2              = ?
             ,BOF_STA_DTIME       = ? 
             ,BOF_END_DTIME       = ?        
             ,RH_STA_DTIME        = ? 
             ,RH_END_DTIME        = ? 
             ,LF_STA_DTIME        = ? 
             ,LF_END_DTIME        = ? 
             ,CAS_STA_DTIME       = ? 
             ,CAS_END_DTIME       = ? 
             ,LT_ARRV_DTIME       = ? 
             ,CASTING_STA_DTIME   = ? 
             ,CASTING_END_DTIME   = ?  
			 ,CAST_NO             = ? 
			 ,RTN_CHARGE_NO       = ? 
			 ,RTN_IN_BOF_WGT      = ? 
			 ,SLAB_RT             = ? 
			 ,CHARGE_WGT          = ?
			 ,BOF_TAPPING_WGT     = ? 
            where CHARGE_NO       = ?    
        ]]>
    </query>
    
    <query id="NIG020200_STLMAKE_PROG.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 用电文中的信息修改 当前炼钢进程信息表 */
         update TBG03_STLMAKE_PROG set
         	  REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
              , TREAT_TEMP         =? 
              ,TREAT_WGT          =? 
              ,TREAT_DTIME         =? 
              ,CHARGE_STAT        = ?
            where CHARGE_NO       =?    
             and  PROC_CD     = ?
             and  TREAT_CD   = ? 
        ]]>
    </query>
    
    <query id="NIG020200_BOF_STAT_DTIME.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 炉次冶炼实绩为空解决 */
            UPDATE tbg02_charge_comm T
			SET t.BOF_STA_DTIME = (
			SELECT  min(T1.TREAT_DTIME) FROM TBG03_STLMAKE_PROG t1
			WHERE t1.TREAT_DTIME IS NOT NULL 
			AND t1.CHARGE_NO = t.CHARGE_NO
			)
			WHERE t.REG_DTIME > '20120101000101'
			AND t.BOF_STA_DTIME IS NULL 
        ]]>
    </query>
    <query id="NIG020200_CASTING_STA_DTIME.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 炉次冶炼实绩为空解决 */
              UPDATE tbg02_charge_comm T
		      SET t.CASTING_STA_DTIME = (
		      SELECT  min(T1.TREAT_DTIME) FROM TBG03_STLMAKE_PROG t1
		      WHERE t1.TREAT_DTIME IS NOT NULL 
		      AND t1.CHARGE_NO = t.CHARGE_NO
		      and t1.TREAT_CD like 'J%'
		      )
		      WHERE t.REG_DTIME > '20120101000101'
		      AND t.CASTING_STA_DTIME IS NULL   
        ]]>
    </query>
    <query id="NIG020200_CASTING_END_DTIME.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 炉次冶炼实绩为空解决 */
              UPDATE tbg02_charge_comm T
		      SET t.CASTING_END_DTIME = (
		      SELECT  max(T1.TREAT_DTIME) FROM TBG03_STLMAKE_PROG t1
		      WHERE t1.TREAT_DTIME IS NOT NULL 
		      AND t1.CHARGE_NO = t.CHARGE_NO
		      and t1.TREAT_CD like 'J%'
		      )
		      WHERE t.REG_DTIME > '20120101000101'
		      AND t.CASTING_END_DTIME IS NULL  
        ]]>
    </query>
    <query id="NIG020200_CHARGE_COMM.insert" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 通过电文中接收的炉次号查询炉次参数表 TBF01_SPEC_CHARGE 取得的数据项 ，插入炼钢公共表 TBF02_CHARGE_COM */
          insert into TBG02_CHARGE_COMM (
            CHARGE_NO
			,PLAN_CHARGE_NO
			,CHARGE_STAT
			,INSTR_RT,PRODNM_CD
			,SPEC_ABBSYM
			,STL_GRD
			,HCR_CLF
			,CAST_EDT_CHARGE_CNT
			,CAST_CHARGE_SEQ
			,TD_NO
			,MD_NO1
			,MD_NO2
			,BOF_STA_DTIME
			,BOF_END_DTIME
			,RH_STA_DTIME
			,RH_END_DTIME
			,LF_STA_DTIME
			,LF_END_DTIME
			,CAS_STA_DTIME
			,CAS_END_DTIME
			,LT_ARRV_DTIME
			,CASTING_STA_DTIME
			,CASTING_END_DTIME
			,CUR_PROG_CD
			,CUR_PROG_CD_REG_PGM
			,CUR_PROG_CD_REG_DTIME
			,BEF_PROG_CD 
			,CAST_NO
			,REG_DTIME
			,RTN_CHARGE_NO
			,RTN_IN_BOF_WGT
			,SLAB_RT
			,CHARGE_WGT
			,BOF_TAPPING_WGT
          ) 
          values
          (
            ?, ?, '2', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?,?,?,?,?,?,?,?,?,?,?,'NIG020200',TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),?,?,
            TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),?,?,?,?,?
          )
          
        ]]>
    </query>
    <query id="NIG020200_STLMAKE_PROG.insert" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 用电文中的信息修改 当前炼钢进程信息表 */
          insert into TBG03_STLMAKE_PROG (
            CHARGE_NO,PROC_CD,TREAT_CD, TREAT_TEMP,TREAT_WGT,
            REG_PGM_ID,REG_DTIME,TREAT_DTIME,CHARGE_STAT
          ) 
          values
          (
            ?,?,?,?,?,'XinSaveChargeProc',to_char(SYSDATE,'YYYYMMDDHH24MISS'),?,?
          )
        ]]>
    </query>
	<query id="NIG020200_TD_MD.select" desc="   " fetchSize="10">
        <![CDATA[
		SELECT  TD_NO,
                  MAX(DECODE(MD_UP_SIDE,'L',MD_NO,NULL))  MD_NO1 ,
                  MAX(DECODE(MD_UP_SIDE,'R',MD_NO,NULL))  MD_NO2 
            FROM  TBG03_TD_PROG a,
                  TBG03_MD_PROG b 
           WHERE  TD_STATUS  = ?
             AND  MD_STATUS  = ?
             AND  a.USE_MC_NO = ?
             AND  b.USE_MC_NO = ?  
           GROUP BY  TD_NO  
        ]]>
    </query> 
    
    <query id="NIG020200_SPEC_PROG.update" desc="  " fetchSize="10">
        <![CDATA[
			 
         update TBF01_SPEC_CHARGE set
              PROG_CD    = ? 
             ,STATUS_CD  = ? 
            where CHARGE_MANA_NO    = ?     
        ]]>
    </query>
     <query id="NIG020200_SPEC_PROG_02.update" desc="  " fetchSize="10">
        <![CDATA[
			 
         update TBF01_SPEC_CHARGE set
             STATUS_CD  = ? 
            where CHARGE_MANA_NO    = ?     
        ]]>
    </query>
    <query id="NIG020200_SPEC_CHARGE_IDX.update" desc="  " fetchSize="10">
        <![CDATA[
			 
         update TBF01_CHARGE_IDX set 
              STATUS_CD  = ? 
            where CHARGE_MANA_NO    = ? 
            AND   L2_SEND = 'Y'
                
        ]]>
    </query>
     <query id="NIG020200_SPEC_SLAB.update" desc="  " fetchSize="10">
        <![CDATA[
			 
         update TBF01_SPEC_SLAB set 
              STATUS_CD  = ? 
            where CHARGE_MANA_NO    = ?     
        ]]>
    </query>
    <query id="NIG020200_SPEC_SLAB_D.update" desc="  " fetchSize="10">
        <![CDATA[
			 
         update TBF01_SPEC_SLAB_D set 
              STATUS_CD  = ? 
            where SLAB_EDT_SEQ    = ?     
        ]]>
    </query>
    <query id="NIG020200_SMS_TRACK.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 用电文中的信息修改 当前炼钢进程信息表 */
         UPDATE TBG03_SMS_TRACKING SET
           EVENT_CD         = ?          
          ,CHARGE_NO        = ?
          ,STL_GRD          = ?
          ,CAST_NO          = ? || ? 
          ,TREAT_DTIME      = ? 
	      ,TREAT_TEMP       = ? 
          ,TREAT_WGT        = ?
         WHERE TREAT_CD     = ?   
			
        ]]>
    </query> 
     <query id="NIG020200_SMS_TRACK.select" desc="   " fetchSize="10">
        <![CDATA[
		 SELECT TREAT_CD  
           FROM TBG03_SMS_TRACKING
          WHERE CHARGE_NO = ?
            AND TREAT_CD != ?
        ]]>
    </query> 
    <query id="NIG020200_TRACK_SAME.update" desc="   " fetchSize="10">
        <![CDATA[
		 UPDATE TBG03_SMS_TRACKING  SET 
             EVENT_CD     = null
            ,CHARGE_NO    = null
            ,STL_GRD      = null
            ,TREAT_WGT    = null
            ,TREAT_TEMP   = null
            ,TREAT_DTIME  = null
            ,CAST_NO      = null
          WHERE  TREAT_CD  = ?
        ]]>
    </query> 
</queryMap>