📄 oa_emp_infoqueryresult.jsp

📁 使用jsp,数据库使用orcale
💻 JSP
字号:
<%@include file="/internet/common.jsp"%>
<title>查询信息结果</title>
<SCRIPT language="JavaScript" src="/pageComponent/resources/scripts/checkBox.js" type="text/javascript"></SCRIPT>
<SCRIPT language="JavaScript" src="/pageComponent/resources/scripts/pagination.js" type="text/javascript"></SCRIPT>
<SCRIPT language="JavaScript" src="/pageComponent/resources/scripts/dataformcheck.js" type="text/javascript"></SCRIPT>
<LINK href="/pageComponent/resources/theme/style.css" rel="stylesheet" type="text/css">
<PG:DataGrid>
	<%--自动生成代码，请不要手动修改
<?xml version="1.0" encoding="GB2312" standalone="no"?>
<wizardContent version="1.0">
    <content>
        <iteratorXpath value="list[@type='OA_EMP_INFO']" type="String"/>
        <updateAction value="admin.pr.prOA_EMP_INFOUpdate.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_EMP_INFOInsert.jsp" type="String"/>
        <highLightClass value="onmouseover" type="String"/>
        <updateTarget value="_self" type="String"/>
        <deleteAction value="admin.pr.prOA_EMP_INFODelete.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_EMP_INFOQuery.do" type="String"/>
        <selectFieldName value="EMPLOYEE_ID" type="String"/>
        <formName value="form1" type="String"/>
    </content>
    <entity name="OA_EMP_INFO" id="entity">
        <field name="EMPLOYEE_ID" displayName="员工编号" length="20" isKey="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="EMPLOYEE_NAME" displayName="员工姓名" length="20">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="SEX" dataType="number" dictTypeID="BNDICT_gender" displayName="性别" length="22">
            <showType value="show"/>
            <fieldType value="BigDecimal"/>
        </field>
        <field name="BIRTHDAY" dataType="date" displayFormat="yyyy-MM-dd" displayName="出生日期" isNullable="true">
            <showType value="show"/>
            <fieldType value="Date"/>
        </field>
        <field name="PROVINCE" displayName="籍贯" length="20" isNullable="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="DEPARTMENT_ID" displayName="部门编号" length="20">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="CARD_ID" displayName="身份证号" length="20">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="SCHOOL" displayName="毕业学校" length="20" isNullable="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="EDULEVEL" dictTypeID="BNDICT_education" displayName="学历" length="20" isNullable="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="TELPHONE" displayName="办公电话" length="20" isNullable="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="MOBILE" displayName="移动电话" length="20" isNullable="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="ADDRESS" displayName="家庭地址" length="50" isNullable="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="EMAIL" displayName="E－MAIL" length="50" isNullable="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="ROLE_ID" displayName="角色编号" length="20">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
    </entity>
</wizardContent>
 --%>
	<form action="admin.pr.prOA_EMP_INFOQuery.do" name="form1" method="POST">
		<pagecom:hiddenData property="PageCond" />
		<pagecom:hiddenData property="OA_EMP_INFO" />

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

			<TR class="pg_result_head">
				<TD align="left">&nbsp;
					<logic:notEqual property="list[@type='OA_EMP_INFO']/@rowNum" value="0">
						<html:checkbox name="chkAll" onclick="checkAll('checkall')" />
					</logic:notEqual>
					选择</TD>
				<TD>员工编号</TD>
				<TD>员工姓名</TD>
				<TD>性别</TD>
				<TD>出生日期</TD>
				<TD>籍贯</TD>
				<TD>部门编号</TD>
				<TD>身份证号</TD>
				<TD>毕业学校</TD>
				<TD>学历</TD>
				<TD>办公电话</TD>
				<TD>移动电话</TD>
				<TD>家庭地址</TD>
				<TD>E－MAIL</TD>
				<TD>角色编号</TD>
			</TR>
			<logic:iterate id="ResultSet" property="list[@type='OA_EMP_INFO']">

				<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_EMP_INFO/EMPLOYEE_ID">
			&nbsp;<html:checkbox styleId="checkall" name="list[@name='update']/OA_EMP_INFO/EMPLOYEE_ID" id="ResultSet"
								property="OA_EMP_INFO/EMPLOYEE_ID" indexed="true" />
						</logic:present>
					</TD>

					<TD>
						<bean:write id="ResultSet" property="OA_EMP_INFO/EMPLOYEE_ID" />
					</TD>

					<TD>
						<bean:write id="ResultSet" property="OA_EMP_INFO/EMPLOYEE_NAME" />
					</TD>

					<TD>
						<dict:write id="ResultSet" property="OA_EMP_INFO/SEX" businTypeId="BNDICT_gender" />
					</TD>

					<TD>
						<bean:write id="ResultSet" property="OA_EMP_INFO/BIRTHDAY" formatType="yyyy-MM-dd"
							formatClass="com.primeton.eos.webtag.bean.BeanWriteDateFormatImpl" />
					</TD>

					<TD>
						<bean:write id="ResultSet" property="OA_EMP_INFO/PROVINCE" />
					</TD>

					<TD>
						<bean:write id="ResultSet" property="OA_EMP_INFO/DEPARTMENT_ID" />
					</TD>

					<TD>
						<bean:write id="ResultSet" property="OA_EMP_INFO/CARD_ID" />
					</TD>

					<TD>
						<bean:write id="ResultSet" property="OA_EMP_INFO/SCHOOL" />
					</TD>

					<TD>
						<dict:write id="ResultSet" property="OA_EMP_INFO/EDULEVEL" businTypeId="BNDICT_education" />
					</TD>

					<TD>
						<bean:write id="ResultSet" property="OA_EMP_INFO/TELPHONE" />
					</TD>

					<TD>
						<bean:write id="ResultSet" property="OA_EMP_INFO/MOBILE" />
					</TD>

					<TD>
						<bean:write id="ResultSet" property="OA_EMP_INFO/ADDRESS" />
					</TD>

					<TD>
						<bean:write id="ResultSet" property="OA_EMP_INFO/EMAIL" />
					</TD>

					<TD>
						<bean:write id="ResultSet" property="OA_EMP_INFO/ROLE_ID" />
					</TD>

				</TR>
			</logic:iterate>

			<TR>
				<TD colspan="15">
					<table width="100%">
						<tr class="pg_result_bottom">

							<td align="left">
								<div><input value="增加" type="button"
										onclick="javascript:prepareInsert(document.form1, 'forward.do?nextPage=/admin/page/OA_EMP_INFOInsert.jsp','_self')">

									<logic:notEqual property="list[@type='OA_EMP_INFO']/@rowNum" value="0">
										<input value="修改" type="button"
											onclick="javascript:prepareUpdateRow(document.form1, 'admin.pr.prOA_EMP_INFOUpdate.do', 'checkall','_self')">
										<input value="删除" type="button"
											onclick="javascript:deleteRows(document.form1, 'admin.pr.prOA_EMP_INFODelete.do', 'checkall','_top')">
									</logic:notEqual>
								</div>
							</td>
							<logic:notEqual property="list[@type='OA_EMP_INFO']/@rowNum" value="0">
								<td align="right">
									<div>
										<SCRIPT LANGUAGE="JavaScript" type="text/javascript">
										<!--
											var myPage = new page();
											myPage.init("form1", "admin.pr.prOA_EMP_INFOQuery.do", "PageCond/begin", "PageCond/length", "PageCond/count");
											var currCount = <bean:write property="list[@type='OA_EMP_INFO']/@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>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -