jccx.asp

人事管理系统 人事管理系统 人事管理系统 人事管理系统

<%
set db=server.createobject("adodb.connection")
db.open "DBQ="&server.mappath("database/rsxt.mdb")&";driver={microsoft access driver (*.mdb)}"
bmxz1=trim(request("bmxz"))
set rs=server.createobject("adodb.recordset")
if len(bmxz1)<>0 then
sql="select * from rsxt where bm='"&bmxz1&"' order by id desc"
end if
if len(bmxz1)=0  then
response.Write("没有你要查询的信息!")
end if
rs.open sql,db,1,1
%>

<!-- #include file="Inc/Head.asp" -->
<%if rs.eof or rs.bof then
response.write "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><center>没有你要查询的信息!</center>"
response.end
end if
%>
 <span class="t style2"><%=rs("bm")%>&nbsp;有<%=rs.recordcount%>人</span>
 <div align="center">
<img src="img/hr.gif" width="100%" height="4"></div>
<table width="100%" height="32" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#666666">
  <tr>
    <td><table width="100%" border="0" cellpadding="0" cellspacing="1">
      <tr>
        <td bgcolor="#F5F5F5"><table width="100%" height="110" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
          <tr bgcolor="#E3E3E3">
            <td width="6%" height="25"><span style="font-family: &quot;仿宋_GB2312&quot;"> 工号</span></td>
            <td width="6%" height="25"><span style="font-family: &quot;仿宋_GB2312&quot;">&nbsp;姓名</span></td>
            <td width="7%" height="25"><span style="font-family: &quot;仿宋_GB2312&quot;">性别</span></td>
            <td width="11%" height="25"><span style="font-family: &quot;楷体_GB2312&quot;">&nbsp;<span style="font-family: &quot;仿宋_GB2312&quot;">身份证号</span></span></td>
            <td width="7%" height="25"><span style="font-family: &quot;仿宋_GB2312&quot;">&nbsp;入职时间</span></td>
            <td width="11%" height="25"><span style="font-family: &quot;仿宋_GB2312&quot;">&nbsp;学历</span></td>
            <td width="11%" height="25"><span style="font-family: &quot;仿宋_GB2312&quot;">&nbsp;证书编号</span></td>
            <td width="11%" height="25"><span style="font-family: &quot;仿宋_GB2312&quot;">&nbsp;职务</span></td>
            <td width="10%" height="25"><span style="font-family: &quot;仿宋_GB2312&quot;">&nbsp;部门</span></td>
			<td width="7%" height="25"><span style="font-family: &quot;仿宋_GB2312&quot;">&nbsp;民族</span></td>
			<td width="10%" height="25"><span style="font-family: &quot;仿宋_GB2312&quot;">操作</span></td>
          </tr>   
		  <%do while not rs.eof%>
          <tr valign="top" bgcolor="#F5F5F5" class="h25">
            <td height="30">&nbsp;<%=rs("gh")%></td>
            <td height="25">&nbsp;<a href="xxxx.asp?ID=<%=rs("id")%>" target="_blank"><%=rs("name")%></a></td>
            <td height="25">&nbsp;<%=rs("xb")%></td>
            <td height="25"><span style="font-family: &quot;楷体_GB2312&quot;">&nbsp;<%=rs("sfzh")%></span></td>
            <td height="25">&nbsp;<%=rs("rzsj")%></td>
            <td height="25">&nbsp;<%=rs("xl")%></td>
            <td height="25">&nbsp;<%=rs("zsh")%></td>
            <td height="25">&nbsp;<%=rs("zw")%></td>
            <td height="25">&nbsp;<%=rs("bm")%></td>
			<td height="25">&nbsp;<%=rs("mz")%></td>
			<td height="25">&nbsp;<span style="font-family: &quot;仿宋_GB2312&quot;"><a href="xiugai.asp?ID=<%=rs("id")%>" style="">修改</a> &nbsp;&nbsp;<a href="Del.asp?ID=<%=rs("ID")%>&Action=Del" onclick="return ConfirmDel();">删除</a></span></td>
          </tr> 
		  <%
            rs.movenext
           loop
         %>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>