XinYu_RZMES/.svn/pristine/67/6754bc93749df77e25253f73c1cf04e4a2f7f41d.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH050100_01.init" desc="init" fetchSize="10">
		<![CDATA[
			select LG_NM LABEL ,SM_CD VALUE  from TBZ00_COMMCD where lg_cd like 'H05003%' 
		]]>
	</query> 
	<query id="UIH050100_01.select" desc="init" fetchSize="10">
		<![CDATA[
			select '～' MIDDLE_STL_GRD,'' CHK,AREA_KIND,YARD_ADDR,FROM_STL_GRD,TO_STL_GRD,STL_GRD1,STL_GRD2,STL_GRD3,STL_GRD4,STL_GRD5,STL_GRD6,STL_GRD7  from TBH05_YARD_STD_STOCK 
			 where AREA_KIND LIKE ?||'%' AND YARD_ADDR LIKE ?||'%'
			 order by  YARD_ADDR
		]]>
	</query> 
	<query id="UIH050100_01.update" desc="" fetchSize="10">
		<![CDATA[
			update TBH05_YARD_STD_STOCK set 
				FROM_STL_GRD =?,
				TO_STL_GRD =?,
				STL_GRD1 =?,
				STL_GRD2 =?,
				STL_GRD3 =?,
				STL_GRD4 =?,
				STL_GRD5 =?,
				STL_GRD6 =?,
				STL_GRD7 =?
					
			where AREA_KIND = ? and YARD_ADDR = ? 
		]]>
	</query> 
	<query id="UIH050100_01.insert" desc="" fetchSize="10">
		<![CDATA[
			insert into TBH05_YARD_STD_STOCK 
			(
				AREA_KIND,
				YARD_ADDR,
				FROM_STL_GRD,
				TO_STL_GRD,
				STL_GRD1,
				STL_GRD2,
				STL_GRD3,
				STL_GRD4,
				STL_GRD5,
				STL_GRD6,
				STL_GRD7 
			)
			values(?,?,?,?,?,?,?,?,?,?,?)		
		]]>
	</query>
	<query id="UIH050100_01.delete" desc="" fetchSize="10">
		<![CDATA[
			delete TBH05_YARD_STD_STOCK  
			where 	AREA_KIND = ? and YARD_ADDR = ? 
		]]>
	</query> 

</queryMap>