XinYu_RZMES/.svn/pristine/45/45d2759f8aa04cc265e459dccdaba423657c087c.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIG020SHIFT_SHIFT.select" desc=" 班次组查询 " fetchSize="10">
		<![CDATA[
			SELECT DISTINCT C.GR_YYYYMM||C.GR_DD XIN_DATE
			       ,A.GROUP_CD
			       ,C.GR_SHIFT 
			FROM TBZ01_FAC_EMP_GROUP A
			     ,(SELECT SM_CD,SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'F01001') B
			     ,TBG02_SHIFT_GROUP C
			WHERE A.PROC_CD = B.SM_CD
			AND   A.GROUP_CD = C.GR_GROUP_CD    
			AND   A.FAC_CD = :1            -- J 炼钢厂  R 热轧厂
			AND   C.PROC_CD = :2             --S 炼钢厂 H 热轧厂
			AND   C.GR_YYYYMM = :3           --'200907' 
			AND   C.GR_DD = :4               --'01' 
			AND   C.GR_SHIFT = :5            --'3'  
			AND   SUBSTR(A.PROC_CD,2,1) = :6 --'B'     
		]]>
	</query> 
	<query id="UIG020SHIFT_EMP_NM.select" desc=" 操作人查询 " fetchSize="10">
		<![CDATA[
			SELECT A.EMP_NM LABEL,A.EMP_NM VALUE FROM TBZ01_FAC_EMP_GROUP A,
                      (SELECT SM_CD,SM_CFNM FROM TBZ00_COMMCD
               		WHERE LG_CD = 'F01001') B,
					  TBG02_SHIFT_GROUP C
			WHERE A.PROC_CD = B.SM_CD
			AND   A.GROUP_CD = C.GR_GROUP_CD    
			AND   A.FAC_CD = :1              -- J 炼钢厂  R 热轧厂
			AND   C.PROC_CD = :2             --S 炼钢厂 H 热轧厂
			AND   C.GR_YYYYMM = :3           --'200907' 
			AND   C.GR_DD = :4               --'01' 
			AND   C.GR_SHIFT = :5            --'3'  
			AND   SUBSTR(A.PROC_CD,2,1) = :6 --'B'   
		]]>
	</query>
	<query id="UIG020SHIFT_GROUP.select" desc=" 操作人查询 " fetchSize="10">
		<![CDATA[
			SELECT EMP_NM LABEL
			       ,EMP_NM VALUE 
			FROM TBZ01_FAC_EMP_GROUP
            WHERE FAC_CD = :1 
			AND SUBSTR(PROC_CD,2,1) = :2 
			AND GROUP_CD = :3  
		]]>
	</query>
</queryMap>