XinYu_RZMES/.svn/pristine/7d/7d83b55e44f07266d8262de81af21adec9abbc3b.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS MONITORING  ">

<query id="UIG030020_01.select" desc="出钢指示查询" fetchSize="10">
		<![CDATA[
   SELECT  DISTINCT
      a.CHARGE_NO 
      ,CHARGE_MANA_NO
      ,LINE_PROC_CD
      ,REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LINE_PROC_CD,'B','->B'),'C','->C'),'R','->R'),'L','->L'),'J','->J')  LINE_PROC_CD
      ,b.PROC_CD
      ,STL_GRD 
      ,CAST_SEQ
      ,c.IRON_LD_NO
      ,a.LD_NO
  FROM 
  ( 
    SELECT b.CHARGE_NO,a.CHARGE_MANA_NO ,a.CAST_EDT_CHARGE_CNT||'-'||a.CAST_CHARGE_SEQ CAST_SEQ,
       a.STL_GRD
       ,a.LINE_PROC_CD
       ,b.LD_NO 
       ,KR_SER_NO
    FROM TBF01_SPEC_CHARGE a,
       TBG02_CHARGE_COMM b
       
     WHERE 
        CHARGE_MANA_NO = PLAN_CHARGE_NO(+)
     and  a.STATUS_CD IN('A','B') 
  ) a, 
  ( 
   select  a.CHARGE_NO,a.PROC_CD, a.REG_DTIME  
    from  TBG03_STLMAKE_PROG a,
       ( SELECT CHARGE_NO,MAX(REG_DTIME) REG_DTIME FROM  TBG03_STLMAKE_PROG
      group by CHARGE_NO) b  
     WHERE  a.CHARGE_NO = b.CHARGE_NO
      and a.REG_DTIME = b.REG_DTIME   
   ) b ,
   (
     SELECT a.LD_NO IRON_LD_NO, CHARGE_NO
         FROM  TBG02_CHARGE_COMM b LEFT  JOIN TBG02_KR_RESULT a
           ON KR_CHARGE_NO = KR_SER_NO 
      AND kr_stat='2'
   ) c
   WHERE a.CHARGE_NO = b.CHARGE_NO(+) 
   AND c.CHARGE_NO(+) = a.CHARGE_NO
  ]]>
 </query> 

  <query id="UIG030020_02.select" desc="从钢包进程表中获取正在等待中的钢包信息UIG030020的表2中">
	  select LD_NO,CCM_DEP_DTIME from tbg03_ladle_prog 
	    where LD_STAT = '2' and substr(LD_NO,1,1) = 'R'
  </query>
	
 <query id="UIG030020_03.select" desc="获得铁水包信息">
	  select LD_NO,KR_CHARGE_NO KR_CD   from TBG02_KR_RESULT 
	  where KR_STAT = '1' and substr(LD_NO,1,1) = 'S'
  </query>
	 
  <query id="UIG030020_01.update" desc=" 更新炼刚实绩中的钢包信息 ">
	   update TBG02_CHARGE_COMM  set  LD_NO=?  where CHARGE_NO =?
  </query>
  <query id="UIG030020_02.update" desc=" 更新钢包状态中的钢包信息 ">
	   update  TBG03_LADLE_PROG  set  LD_STAT= '1'  where LD_NO =?
  </query>
  <query id="UIG030020_03.update" desc=" 更新KR实绩中铁水包状态信息 ">
	   update  tbg02_kr_result  set  KR_STAT='2'  where LD_NO =?
  </query>
  <query id="UIG030020_04.update" desc=" 更新炼刚实绩中的铁水包信息 ">
	   update  TBG02_CHARGE_COMM  set  
	     KR_LD_NO=?
	    ,KR_SER_NO =?  
	    where CHARGE_NO =?
  </query>
  <query id="UIG030020_05.update" desc=" 更新铁水包状态中的铁水包信息 ">
	   update  TBG03_LADLE_PROG  set  LD_STAT= '2'  where LD_NO =?
  </query>
</queryMap>