oa_timequeryresult.jsp

使用jsp,数据库使用orcale

<%@include file="/internet/common.jsp"%>
<SCRIPT language="JavaScript" src="/pageComponent/resources/scripts/checkBox.js"></SCRIPT>
<SCRIPT language="JavaScript" src="/pageComponent/resources/scripts/pagination.js"></SCRIPT>
<SCRIPT language="JavaScript" src="/pageComponent/resources/scripts/dataformcheck.js"></SCRIPT>
<link rel="stylesheet" href="/pageComponent/resources/theme/style.css" type="text/css">
<PG:DataGrid>
<%--自动生成代码，请不要手动修改
<?xml version="1.0" encoding="GB2312" standalone="no"?>
<wizardContent version="1.0">
    <content>
        <iteratorXpath value="list[@type='OA_TIME']" type="String"/>
        <updateAction value="admin.pr.prOA_TIMEUpdate.do" type="String"/>
        <oddClass value="pg_result_content" type="String"/>
        <title value="查询结果" type="String"/>
        <insertTarget value="_self" type="String"/>
        <isPage value="true" type="Boolean"/>
        <insertAction value="forward.do?nextPage=/admin/page/OA_TIMEInsert.jsp" type="String"/>
        <highLightClass value="onmouseover" type="String"/>
        <updateTarget value="_self" type="String"/>
        <deleteAction value="admin.pr.prOA_TIMEDelete.do" type="String"/>
        <deleteTarget value="_top" type="String"/>
        <selectFieldStyle value="checkbox" type="String"/>
        <evenClass value="pg_result_content_" type="String"/>
        <pageAction value="admin.pr.prOA_TIMEQuery.do" type="String"/>
        <selectFieldName value="TIME_ID" type="String"/>
        <formName value="form1" type="String"/>
    </content>
    <entity name="OA_TIME" id="entity">
        <field name="TIME_ID" displayName="TIME_ID" length="20" isKey="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="ON_TIME" displayName="上班时间" isNullable="true">
            <showType value="show"/>
            <fieldType value="Time"/>
        </field>
        <field name="OFF_TIME" displayName="下班时间" isNullable="true">
            <showType value="show"/>
            <fieldType value="Time"/>
        </field>
    </entity>
</wizardContent>
 --%>
<form action="admin.pr.prOA_TIMEQuery.do" name="form1" method="POST">
 <pagecom:hiddenData property="PageCond"/> 
		<pagecom:hiddenData property="OA_TIME"/>

	<TABLE width="80%" border="0" align="center" cellPadding="0" cellSpacing="0" class="pg_result">
		<TR>
			<TD class="pg_result_title" colspan="4">查询结果
			</TD>
		</TR>

		<TR class="pg_result_head">
		  <TD align="left">&nbsp;<logic:notEqual property="list[@type='OA_TIME']/@rowNum" value="0">
				<html:checkbox name="chkAll" onclick="checkAll('checkall')"/>
			   </logic:notEqual>选择</TD><TD>TIME_ID</TD><TD>上班时间</TD><TD>下班时间</TD>		    	
		</TR>		            
		<logic:iterate id="ResultSet" property="list[@type='OA_TIME']">       
		
		<TR class="<pagecom:trclass oddClass='pg_result_content' evenClass='pg_result_content_'/>" onmouseover='this.className="onmouseover"' onmouseout='this.className="<pagecom:trclass oddClass="pg_result_content" evenClass="pg_result_content_" mapping="oddClass|oddClass,evenClass|evenClass"/>"'>
		
			<TD>
			<logic:present id="ResultSet" property="OA_TIME/TIME_ID">
			&nbsp;<html:checkbox styleId="checkall" name="list[@name='update']/OA_TIME/TIME_ID" id="ResultSet" property="OA_TIME/TIME_ID"  indexed="true" />
			</logic:present>
			</TD>						
				
			<TD>
			<bean:write id="ResultSet" property="OA_TIME/TIME_ID"/>
			</TD>
			
			<TD>
			<bean:write id="ResultSet" property="OA_TIME/ON_TIME"/>
			</TD>
			
			<TD>
			<bean:write id="ResultSet" property="OA_TIME/OFF_TIME"/>
			</TD>
													
		</TR>
		</logic:iterate>

		<TR>
			<TD colspan="4">
			<table width="100%"><tr class="pg_result_bottom">
		
			<td align="left">
				<div>						
		 <input type="button" value="增加" onclick="javascript:prepareInsert(document.form1, 'forward.do?nextPage=/admin/page/OA_TIMEInsert.jsp','_self')"> 

		<logic:notEqual property="list[@type='OA_TIME']/@rowNum" value="0">
		 <input type="button" value="修改" onclick="javascript:prepareUpdateRow(document.form1, 'admin.pr.prOA_TIMEUpdate.do', 'checkall','_self')">  
		 <input type="button" value="删除" onclick="javascript:deleteRows(document.form1, 'admin.pr.prOA_TIMEDelete.do', 'checkall','_top')">  
		</logic:notEqual>
</div>
			</td>
<logic:notEqual property="list[@type='OA_TIME']/@rowNum" value="0">
			<td align="right">
		<div>
	<SCRIPT LANGUAGE="JavaScript">
	<!--						
		var myPage = new page();
		myPage.init("form1", "admin.pr.prOA_TIMEQuery.do", "PageCond/begin", "PageCond/length", "PageCond/count");
		var currCount = <bean:write property="list[@type='OA_TIME']/@rowNum"/>;
		var htmltext = "";
		if (!myPage.noCount){
			htmltext += myPage.current + "页/"+myPage.total+"页";
			htmltext += " 共"+myPage.count + "条";
		}
		if(myPage.current>1){
			htmltext += "<input type=\"button\" value=\"首页\" onclick=\"myPage.firstPage()\">";
			htmltext += "<input type=\"button\" value=\"上页\" onclick=\"myPage.previousPage()\">";
		}
		else
		{
			htmltext += "<input type=\"button\" value=\"首页\" disabled>";
			htmltext += "<input type=\"button\" value=\"上页\" disabled>";
		}
		if (!myPage.noCount){
			if (myPage.current<myPage.total ) {
				htmltext += "<input type=\"button\" value=\"下页\" onclick=\"myPage.nextPage()\">";
				htmltext += "<input type=\"button\" value=\"尾页\" onclick=\"myPage.lastPage()\"> ";
			}
			else
			{
				htmltext += "<input type=\"button\" value=\"下页\" disabled>";
				htmltext += "<input type=\"button\" value=\"尾页\" disabled> ";
			}
		}else{
			if (myPage.length<=currCount){
				htmltext += "<input type=\"button\" value=\"下页\" onclick=\"myPage.nextPage()\"> ";
			}
			else
			{
				htmltext += "<input type=\"button\" value=\"下页\" disabled> ";
			}
		}
		htmltext += "<input type='text' name='pageno' size=2 value='"+myPage.current+"' eos_datatype='number' eos_caption='页码' onBlur='checkInput(this)'>";
		htmltext += "<input type='button' onclick=myPage.goPage('pageno'); value='go' name='gopage'> ";
		document.write( htmltext );
	//-->
	</SCRIPT>
</div>
			</td>
</logic:notEqual>
			</tr></table>
			</TD>
		</TR>
</TABLE>
</FORM>
</PG:DataGrid>