
	<!-- 郯傧嚼 GEA05 GE0017 -->
<!-- 晄梫
	<tr>
		<td>
			<og:link gamenId="GE0017" href="index.jsp" target="CONTENTS"
				keys="command,SYSTEM_ID,ROLES,KBROLE,USRUPD,DYUPDFROM,DYUPDTO,FGJ"
				vals="NEW,{@SYSTEM_ID},{@ROLES},{@KBROLE},{@USRUPD},{@DYUPDFROM},{@DYUPDTO},{@FGJ}" >{@LBL.GE0017}
			</og:link>
		</td>
		<td>GEA05.xml</td><td id="GEA05"></td>
	</tr>
-->

<!-- 郯傧嚼 GEA05 GE0017 -->
<!-- 晄梫
<og:text caseNN="{@VIEW}">******************** GEA05 {@LBL.GEA05} ********************</og:text>
	<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}" notfoundMsg="">
		select SYSTEM_ID,ROLES,NMROLE,KBROLE,FGJ
		from GEA05
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		order by ROLES,KBROLE
	</og:query>

	<script type="text/javascript">
		gea05 = document.getElementById("GEA05");
		gea05.textContent = "<og:text>{@DB.COUNT}</og:text>";
	</script>

	<og:view command="{@command}" selectedType="none" useScrollBar="false" pageSize="{@pageSize}" caseNN="{@VIEW}" />

	<og:writeTable
		fileURL        = "{@DIR}"
		filename       = "GEA05.xml"
		writerClass    = "XML"
		encode         = "UTF-8" >
		<og:writeTableParam key="TableName" value="GEA05" />
		<og:equals val1="{@EXT_SQL}" val2="DELETE" >
		  <og:writeTableParam key="First" >
			delete from GEA05 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		  </og:writeTableParam>
		</og:equals>
		<og:equals val1="{@EXT_SQL}" val2="MERGE" >
		  <og:writeTableParam key="MergeSql" >
			update GEA05
			set
				NMROLE			= [NMROLE]
			,	FGJ				= [FGJ]
			where 	SYSTEM_ID	= [SYSTEM_ID]
			and		ROLES		= [ROLES]
			and		KBROLE		= [KBROLE]
		  </og:writeTableParam>
		</og:equals>
	</og:writeTable>
-->
