oa_emp_infoqueryresult.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_EMP_INFO']" type="String"/>
        <updateAction value="admin.pr_automata.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="default.pr_automata.forward.do?nextPage=/internet/admin/page/OA_EMP_INFOInsert.jsp" type="String"/>
        <highLightClass value="onmouseover" type="String"/>
        <updateTarget value="_self" type="String"/>
        <deleteAction value="admin.pr_automata.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_automata.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>
        <field name="PWD" displayName="密码" length="100">
            <showType value="show"/>
            <fieldType value="Password"/>
        </field>
    </entity>
</wizardContent>
 --%>
<title>员工信息查询</title>
<body background="../../image/admin/adminmodify.JPG">
<form action="admin.pr_automata.pr.prOA_EMP_INFOQuery.do" name="form1" method="POST">
 <pagecom:hiddenData property="PageCond"/> 
		<pagecom:hiddenData property="OA_EMP_INFO"/>

	
  <TABLE width="96%" border="0" align="center" cellPadding="0" cellSpacing="0" class="pg_result">
    <TR> 
      <TD class="pg_result_title" colspan="16"><p><font size="5" face="华文新魏">查询结果 
          </font></p>
        <p>&nbsp;</p></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>
      <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>
      <TD> <bean:write id="ResultSet" property="OA_EMP_INFO/PWD"/> </TD>
    </TR>
    </logic:iterate> 
    <TR> 
      <TD colspan="16"> <table width="100%">
          <tr class="pg_result_bottom"> 
            <td align="left"> <div> 
                <div align="right"> 
                  <input type="button" value="增加" onclick="javascript:prepareInsert(document.form1, 'default.pr_automata.forward.do?nextPage=/internet/admin/page/OA_EMP_INFOInsert.jsp','_self')">
                  <logic:notEqual property="list[@type='OA_EMP_INFO']/@rowNum" value="0"> 
                  <input type="button" value="修改" onclick="javascript:prepareUpdateRow(document.form1, 'admin.pr_automata.pr.prOA_EMP_INFOUpdate.do', 'checkall','_self')">
                  <input type="button" value="删除" onclick="javascript:deleteRows(document.form1, 'admin.pr_automata.pr.prOA_EMP_INFODelete.do', 'checkall','_top')">
                  </logic:notEqual> </div>
              </div></td>
            <logic:notEqual property="list[@type='OA_EMP_INFO']/@rowNum" value="0"> 
            <td align="right"> <div> 
                <SCRIPT LANGUAGE="JavaScript">
	<!--						
		var myPage = new page();
		myPage.init("form1", "admin.pr_automata.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>