XinYu_RZMES/.svn/pristine/f5/f57af550d59433c616e22a5de09269f924cf143a.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="炉次号成分现况">
  <!--
  <query id="UIB020020_01.INITSELECT" desc="炉次号选择查询" fetchSize="10">  
      SELECT    X.CHARGE_NO AS LEBEL
	           ,X.CHARGE_NO AS VALUE
	  FROM      TBG02_CHARGE_COMM  X
	  WHERE     EXISTS (SELECT 'X'
	  			        FROM     TBB02_WORK_INGR Y
					    WHERE    Y.CHARGE_NO     =   X.CHARGE_NO
	                    AND      ROWNUM = 1)
	  ORDER BY  X.CHARGE_NO
  </query> 
	
  <query id="UIB020020_02.INITSELECT" desc="物料进程代码">
	  SELECT   SM_CFNM        LABEL
               ,SM_CD         VALUE
      FROM     TBZ00_COMMCD   WHERE  LG_CD = 'E01002'
  </query>	
	-->
  <query id="UIB020020_03.INITSELECT" desc="工厂工序代码 FacProc">
	  SELECT       SM_CD        VALUE 
                 , SM_CFNM      LABEL 
                 , CD_SEQ
      FROM         TBZ00_COMMCD 
      WHERE        LG_CD      =     'B01129'
      ORDER BY     CD_SEQ
  </query>	
	
  <query id="UIB020020_01.SELECT" desc="获取满足条件的成分代码，多条件查询">
	  SELECT    DECODE(X.COMP_YN, 'Y', X.COMP_CAL, X.CHEM_CD) AS CHEM
      ,X.CHEM_CD
      ,X.COMP_YN
      ,X.DISPLAY_SEQ
           FROM     TBB01_SEQ_INGR X
           WHERE    EXISTS (SELECT 'X'
                            FROM   TBB02_WORK_INGR Y
                            WHERE  Y.CHEM_CD       =  X.CHEM_CD
                            AND    Y.CHEM_VAL_TP   =  'L'      --'L'表示炉次，'P'表示钢卷，'S'表示板坯
                            AND    CHEM_VAL IS NOT NULL
	                        AND    ROWNUM          =   1)
	   ORDER BY X.COMP_YN , X.DISPLAY_SEQ
     
  </query>	
	
  <query id="UIB020020_02.START" desc="炉次号成分现况查询">
	  SELECT  
		  WI.CHARGE_NO
		, WI.PROC_CD
		, WI.CHEM_SEQ
		, GC.STL_GRD
		, GC.BEF_STL_GRD
		, decode(WI.PROC_CD||WI.CHEM_SEQ , GC.LST_INGR_CD , GC.INGR_DEC_GRD , NULL) INGR_DEC_GRD
	    , GC.SLAB_RT
	    , decode(GC.LST_INGR_CD, WI.PROC_CD||WI.CHEM_SEQ , GC.LST_INGR_REG_DTIME , '')        LST_INGR_REG_DTIME
	    , decode(GC.LST_INGR_CD, WI.PROC_CD||WI.CHEM_SEQ , GC.CHARGE_INGR_DEC_EMP_ID , '')    CHARGE_INGR_DEC_EMP_ID
  </query>	
	
  <query id="UIB020020_02.MID" desc="循环部分">
	    , max(decode(WI.CHEM_CD , '{0}' , CHEM_L2_VAL )) CHEM_VAL{1}
  </query>	
	
  <query id="UIB020020_02.END" desc="">
	  FROM      TBB02_WORK_INGR   WI  ,   TBG02_CHARGE_COMM_D   GC
	  WHERE     WI.CHARGE_NO      =    GC.CHARGE_NO(+)
  </query>	
	
  <query id="UIB020020_CHARGENO" desc="炉次号">
	  AND      WI.CHARGE_NO(+)   BETWEEN    ?   AND ?
  </query>
		
  <query id="UIB020020_PROCCD" desc="工序">
	  /* AND      (WI.PROC_CD   =  ?  OR  WI.PROC_CD   =  ? OR WI.PROC_CD   =  ? OR WI.PROC_CD   =  ? ) */
	  AND      (WI.PROC_CD IN ( ?,  ?,  ?,  ? )
  </query>	
	
  <query id="UIB020020_SEQ" desc="次数">
	  AND      WI.CHEM_SEQ    =    ?
  </query>	
	 
  <query id="UIB020020_TIME" desc="生产时间">
   	  AND   GC.CHARGE_INIT_DTIME BETWEEN ? || '0000'  AND  ? || '9999'
	 -- AND      SUBSTR(GC.CHARGE_INIT_DTIME , 1 , 8) BETWEEN  ?  AND ?
  </query>	
		
		
  <query id="UIB020020_02.GROUPBY" desc="">
	  GROUP BY 
	  WI.CHARGE_NO
	, WI.PROC_CD
	, WI.CHEM_SEQ
	, GC.STL_GRD
	, GC.BEF_STL_GRD
	, GC.INGR_DEC_GRD  
	, GC.LST_INGR_REG_DTIME
	, GC.LST_INGR_CD
	, GC.SLAB_RT
	, GC.CHARGE_INGR_DEC_EMP_ID   
	  ORDER BY  WI.CHARGE_NO DESC  ,  INGR_DEC_GRD  DESC
  </query>	
	
	<query id="UIB020020_02.SELECT" desc="">
	SELECT *
			  FROM (SELECT DECODE(FAC.COMP_YN, 'Y', SEQ.COMP_CAL, SEQ.CHEM_CD) CHEMCD,
			               FAC.CHEM_CD CHEMCD_CAL,
			               FAC.CHEM_MIN MIN_1,
			               FAC.CHEM_MAX MAX_1
			          FROM TBB01_SEQ_INGR SEQ, TBB01_FAC_INGR FAC
			         WHERE FAC.CHEM_CD = SEQ.CHEM_CD
			           AND FAC.FAC_STL_GRD =   ?) AA,
			       (SELECT DECODE(TAF.COMP_YN, 'Y', SEQ.COMP_CAL, SEQ.CHEM_CD) CHEMCD,
			               TAF.CHEM_CD CHEMCD_CAL,
			               TAF.CHEM_MIN MIN_2,
			               TAF.CHEM_MAX MAX_2
			          FROM TBB01_SEQ_INGR SEQ, TBB01_TAFAC_INGR TAF
			         WHERE TAF.CHEM_CD = SEQ.CHEM_CD
			           AND TAF.TAFAC_STL_GRD =   ?) BB,
			       TBB02_WORK_INGR WO
			 WHERE AA.CHEMCD = BB.CHEMCD
			   AND AA.CHEMCD_CAL = WO.CHEM_CD(+)  --修改复合元素不显示值的问题
			   AND WO.CHARGE_NO(+) =   ?
			   AND WO.PROC_CD(+) =   ?
			   AND WO.CHEM_SEQ(+) =   ? 
	</query>
	
	<query id="UIB020020_03.SELECT" desc="">
	<![CDATA[
		SELECT ZL_HOST_DCS01.FIB020_CHECK_CHEMVAL(? , ?)  MSG FROM DUAL
		]]>
	</query>
	
	<query id="UIB020020_93.INSERT" desc="操作日志insert">
	  INSERT INTO OPTION_LOG (ID, PARAMS, STATUS, THREAD_ID, THREAD_NAME, CREATE_TIME) VALUES (?, ?, ?, ?, ?, ?)
    </query>
    <query id="UIB020020_93.UPDATE" desc="操作日志update">
	  UPDATE OPTION_LOG SET STATUS = ?, MODIFY_TIME = ?, DURATION_TIME = ?, RESULT_SIZE= ? WHERE ID = ?
    </query>
  
	
	<query id="UIB020020_93.INSERT" desc="操作日志insert">
	<![CDATA[
	  INSERT INTO OPTION_LOG (ID, PARAMS, STATUS, THREAD_ID, THREAD_NAME, CREATE_TIME) VALUES (?, ?, ?, ?, ?, ?)
   		]]>
    </query>
    <query id="UIB020020_93.UPDATE" desc="操作日志update">
    <![CDATA[
	  UPDATE OPTION_LOG SET STATUS = ?, MODIFY_TIME = ?, DURATION_TIME = ?, RESULT_SIZE= ? WHERE ID = ?
   		]]>
    </query>
  
</queryMap>