XinYu_RZMES/.svn/pristine/6f/6f1c97ffa6c953b12768d7e94a4e44345101ab71.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
     <query id="UIG020020_01.select" desc=" 转炉实绩查询 " fetchSize="10">
        <![CDATA[
select 
        a.CHARGE_NO
       ,a.PLAN_CHARGE_NO 
       ,a.STL_GRD
       ,a.CAST_EDT_CHARGE_CNT ||'-'||a.CAST_CHARGE_SEQ  CAST_SEQ  
       ,b.XIN_DATE     
       ,b.WKSHIFT
       ,b.WKGROUP
       ,b.BOF_NO
       ,decode(b.MOD_ID,null,b.REG_ID,b.MOD_ID) EMP_ID
       ,a.LD_NO
       ,c.LD_CYCLIC_CNT LD_USE_CNT
       ,c.LD_STAT   
       ,REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(a.INSTR_RT,'B1','BOF1:'),
        'B2','BOF2:'),'C1','CAS1:'),'C2','CAS2:'),'R1','RH1:'),'L1','LF1:'),'J1','CCM1 '),'J22','CCM2')  
         INSTR_RT
       ,b.TAPPING_WGT
       ,d.PREV_CHARGE_WGT   
       ,b.TAPPING_AFT_TEMP
       ,b.RATEIO
       ,b.IRON_CHARGE_WGT
       ,b.SCRAP_CHARGE_wGT
       ,b.SUBRAW_WGT 
       ,b.SCRAP_ZINC_CHARGE_WGT
       ,b.O2_LANCE_ID
       ,b.O2_LANCE_USE_CNT
       ,b.BOF_USE_STEPNO
       ,b.TAPPING_GATE_STEPNO
       ,b.CHARGE_TEMP
       ,b.TAPPING_AFT_TEMP
       ,b.O2BLOW_AFT_TEMP
       ,b.O2_CONSUME
       ,b.AR_CONSUME
       ,b.N2_CONSUME
       ,b.BOF_WK_HOUR
       ,b.CHARGE_HOUR
       ,b.TAPPING_HOUR
       ,b.SCRAP_CHARGE_STA_DTIME
       ,b.IRON_CHARGE_STA_DTIME
       ,b.TAPPING_STA_DTIME
       ,b.TAPPING_END_DTIME 
     ,a.RTN_CHARGE_NO   
     ,a.RTN_IN_BOF_WGT 
     ,a.RTN_CHARGE_OCR_DTIME 
      from  TBG02_CHARGE_COMM a,
            TBG02_BOF_RESULT  b,
            TBG03_LADLE_PROG  c ,
            TBF01_SPEC_CHARGE d
      where  c.LD_NO(+) = A.LD_NO 
        and  a.PLAN_CHARGE_NO  = d.CHARGE_MANA_NO
        and a.CHARGE_NO = b.CHARGE_NO(+) 
        and  a.CHARGE_NO =?
        ]]>
    </query> 
   
	<query id="UIG020020_01.insert" desc=" 无某炉次号时的插入操作 ">
     <![CDATA[
      insert into TBG02_BOF_RESULT
      (
      CHARGE_NO,
      XIN_DATE, 
      BOF_NO,
      WKSHIFT, 
      WKGROUP, 
      REG_ID,
      TAPPING_WGT,
      IRON_CHARGE_WGT, 
      SCRAP_CHARGE_WGT,
      SCRAP_ZINC_CHARGE_WGT, 
      SUBRAW_WGT,
      TAPPING_AFT_TEMP,
      O2_CONSUME,
      AR_CONSUME,
      N2_CONSUME,
      PLAN_CH_NO
      )
      values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
     ]]>
    </query>
	
	<query id="UIG020020_01.update" desc=" 更新某炉次号的信息 ">
      <![CDATA[
        update TBG02_BOF_RESULT set  
        XIN_DATE=?
       ,BOF_NO=?
       ,WKSHIFT=? 
       ,WKGROUP=?
       ,MOD_ID=?
       ,TAPPING_WGT=?
       ,IRON_CHARGE_WGT=?
       ,SCRAP_CHARGE_WGT=?
       ,SCRAP_ZINC_CHARGE_WGT=?
       ,SUBRAW_WGT=?
       ,TAPPING_AFT_TEMP=?
       ,O2_CONSUME=?
       ,AR_CONSUME=?
       ,N2_CONSUME=?
       WHERE CHARGE_NO=?
      ]]>
    </query>
	<query id="UIG020020_02.select" desc=" 4次吹炼的时间、温度、02用量查询 " fetchSize="10">
		<![CDATA[
	(SELECT '001' SEQ, 
      FST_O2BLOW_STA_DTIME STA_DTIME,
       FST_O2BLOW_END_DTIME END_DTIME,
       FST_O2BLOW_AFT_TEMP AFT_TEMP,
       FST_O2BLOW_AFT_O2_CONSUME AFT_O2_CONSUME
       FROM TBG02_BOF_RESULT a,TBG02_CHARGE_COMM b
	   WHERE a.CHARGE_NO=b.CHARGE_NO
	   AND a.CHARGE_NO=? 
       UNION
       SELECT '002' SEQ, 
       SND_O2BLOW_STA_DTIME STA_DTIME,
       SND_O2BLOW_END_DTIME END_DTIME,
       SND_O2BLOW_AFT_TEMP AFT_TEMP,
       SND_O2BLOW_AFT_O2_CONSUME AFT_O2_CONSUME       
       FROM TBG02_BOF_RESULT a,TBG02_CHARGE_COMM b
	   WHERE a.CHARGE_NO=b.CHARGE_NO
	   AND a.CHARGE_NO=? 
       UNION
       SELECT '003' SEQ, 
       TRD_O2BLOW_STA_DTIME STA_DTIME,
       TRD_O2BLOW_END_DTIME END_DTIME,
       TRD_O2BLOW_AFT_TEMP AFT_TEMP,
       TRD_O2BLOW_AFT_O2_CONSUME AFT_O2_CONSUME       
       FROM TBG02_BOF_RESULT a,TBG02_CHARGE_COMM b
	   WHERE a.CHARGE_NO=b.CHARGE_NO
	   AND a.CHARGE_NO=? 
       UNION
       SELECT '004' SEQ, 
       FTH_O2BLOW_STA_DTIME STA_DTIME,
       FTH_O2BLOW_END_DTIME END_DTIME,
       FTH_O2BLOW_AFT_TEMP  AFT_TEMP,
       FTH_O2BLOW_AFT_O2_CONSUME AFT_O2_CONSUME       
       FROM TBG02_BOF_RESULT a,TBG02_CHARGE_COMM b
	   WHERE a.CHARGE_NO=b.CHARGE_NO
	   AND a.CHARGE_NO=?   
       )
	   ORDER BY SEQ   
		]]>
	</query> 
	<query id="UIG020020_EMP.select" desc=" 查询转炉作业人信息，这里PROC_CD为JJB " fetchSize="10">
		<![CDATA[
		SELECT  EMP_NM  label  
                ,EMP_NM  value  
         FROM   TBZ01_FAC_EMP_GROUP   
         WHERE  GROUP_CD = ? 
		  AND   PROC_CD  = 'JB'	
          AND   FAC_CD = 'J' 
		]]>
	</query>
	<query id="UIG020020_L2_SEND_CHARGE.select" desc=" 查询炉次是否已经下发 " fetchSize="10">
		<![CDATA[
		SELECT CHARGE_MANA_NO FROM TBF01_CHARGE_IDX  WHERE CHARGE_MANA_NO = ? AND L2_SEND = 'Y'
		]]>
	</query>
	<query id="UIG020020_CH_COM.select" desc="   " fetchSize="10">
		<![CDATA[
		SELECT  CUR_PROG_CD ,BOF_TAPPING_WGT,CHARGE_STAT,BEF_PROG_CD
         FROM   TBG02_CHARGE_COMM   
         WHERE  CHARGE_NO = ? 
		]]>
	</query>
	<query id="UIG020020_CH_COM.update" desc="   " fetchSize="10">
		<![CDATA[
		   UPDATE TBG02_CHARGE_COMM SET
		     CUR_PROG_CD           = ?
		    ,CUR_PROG_CD_REG_PGM   = ?
		    ,CUR_PROG_CD_REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		    ,BEF_PROG_CD           = ?
		    ,BEF_PROG_CD_REG_PGM   = CUR_PROG_CD_REG_PGM
		    ,BEF_PROG_CD_REG_DTIME = CUR_PROG_CD_REG_DTIME 
		    ,BOF_TAPPING_WGT = ? 
		    ,CHARGE_WGT  = ?
			,ACT_BOF_RT = ?
			,SLAB_RT = ?
		   WHERE CHARGE_NO = ?    
		]]>
	</query>
	<query id="UIG020020_CH_COM.insert" desc="   " fetchSize="10">
		<![CDATA[
              INSERT INTO TBG02_CHARGE_COMM             
              (                                         
                 CHARGE_NO                              
                ,PLAN_CHARGE_NO                         
                ,STL_GRD                                
                ,PRODNM_CD                              
                ,INSTR_RT                           
                ,HCR_CLF                                
                ,SPEC_ABBSYM                            
                ,CAST_NO                           
                ,CAST_CHARGE_SEQ   
                ,CAST_EDT_CHARGE_CNT                     
                ,CUR_PROG_CD                            
                ,CUR_PROG_CD_REG_PGM                    
                ,CUR_PROG_CD_REG_DTIME   
                ,CHARGE_STAT     
		        ,BOF_TAPPING_WGT  
		        ,CHARGE_WGT 
			    ,ACT_BOF_RT    
		        ,REG_DTIME
			    ,SLAB_RT 
			    ,BEF_PROG_CD    
			    ,BEF_PROG_CD_REG_DTIME
              )                                         
              VALUES                                    
              (                                         
                ?                                       
               ,?                                       
               ,?                                       
               ,?                                       
               ,? 
               ,?                                      
               ,?                                       
               ,?                                       
               ,?                                       
               ,?                                       
               ,?                                       
               ,?                                       
               ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')      
               ,'2' 
               ,?
               ,?
			   ,?
               ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
			   ,?
			   ,'JBB'
			   ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
              )                                         

		]]>
	</query>
	<query id="UIG020020_02_L2_DEMO" desc="   " fetchSize="10">
		<![CDATA[
		   	SELECT wmsys.wm_concat(DISTINCT D.L2_MEMO) L2DEMO
			FROM TBG02_CHARGE_COMM A 
			     ,TBG02_SLAB_COMM B
			     ,TBF01_SPEC_SLAB C
			     ,TBD01_SLABDN_OBJ2 D
			WHERE A.CHARGE_NO = SUBSTR(B.SLAB_NO,1,10)
			AND   B.PLAN_SLAB_NO = C.SLAB_MANA_NO
			AND   C.DSN_SLAB_NO = D.DSN_SLAB_NO
			AND   D.L2_MEMO IS NOT NULL     
			AND   A.CHARGE_NO = ? 
		]]>
	</query>
</queryMap>