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

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIG060020_SHIFT.select" desc="" fetchSize="10">
		<![CDATA[
			SELECT  GR_DD,GR_SHIFT,GR_GROUP_CD
			FROM    TBG02_SHIFT_GROUP 
			WHERE   GR_YYYYMM = ?
			AND     PROC_CD = ? 
		]]>
	</query> 
	<query id="UIG060020_shift.insert" desc="" fetchSize="10">
		<![CDATA[
		INSERT INTO TBG02_SHIFT_GROUP 
            		( GR_GROUP_CD
					  ,PROC_CD
					  ,FAC_CD
					  ,GR_YYYYMM
					  ,GR_DD
					  ,GR_SHIFT
					  
					)
		VALUES      (?,?,?,?,?)
		]]>
	</query>
	<query id="UIG060020_shift.update" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBG02_SHIFT_GROUP 
			SET           GR_GROUP_CD = ?
			WHERE         PROC_CD = ?
			AND           FAC_CD = ?
			AND           GR_YYYYMM = ?
			AND           GR_DD = ?
			AND           GR_SHIFT = ?    
		]]>
	</query> 
</queryMap>