📄 show_emly.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>人力资源管理系统≡员工详细信息≡</title>
<link href="../Include/type.css" rel="stylesheet" type="text/css">
</head>
<body>
<!--#include file="../Include/conn.asp"-->
<!--#include file="../Include/Head.asp"-->
<!--#include file="../Include/Syscheck.asp"-->
<div id="content" style="position:absolute; width:90%; height:115px; z-index:3; left: 48px; top: 190px;">
<!--内容开始-->
<%
call checkin_sys(session("UsersId"),session("PerId"),18)
%>
当前员工编号：
<%
id=request.QueryString("id")
response.Write id
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from personnel where personnel_id="&id&"",conn,1,1
%> 员工姓名：<%=rs("personnel_name")%>
<br>
<table width="80%" border="1" align="center" cellpadding="0" cellspacing="0" class="table1">
<tr height="25">
<td width="93" valign="top" align="right"><p>部门编号: </p></td>
<td width="185" valign="top"> <%=rs("dept_id")%></td>
<td width="139" valign="top" align="right">员工状态:</td>
<td width="139" valign="top"> <%=rs("personnel_state")%></td>
<td width="122" colspan="2" rowspan="7" valign="middle">
<div align="center">
<%if isnull(rs("personnel_photo")) then%>
<img src="../images/emptybook.gif">
<%else%>
<img src="showimg.asp?id=<%=rs("personnel_id")%>" width=100 height=120 border=0>
<%end if%>
</div>
</td>
</tr>
<tr height="25">
<td valign="top" align="right">行政级别：</td>
<td valign="top">
<%
dim rs_pleve
set rs_pleve=server.CreateObject("ADODB.recordset")
rs_pleve.open "select plevel_id,plevel_name from plevel",conn,1,1
while not rs_pleve.eof=true
if rs_pleve.Fields(0).value=rs("plevel_id") then
response.Write (rs_pleve.Fields(1).value)
end if
rs_pleve.movenext
wend
rs_pleve.Close
set rs_pleve=nothing
%>
</td>
<td valign="top" align="right">工作性质：</td>
<td valign="top"> <%=rs("work_property")%></td>
</tr>
<tr height="25">
<td width="93" valign="top" align="right"><p>性别:</p></td>
<td width="185" valign="top"> <%=rs("personnel_sex")%></td>
<td width="139" valign="top" align="right">民族:</td>
<td width="139" valign="top"> <%=rs("personnel_nation")%></td>
</tr>
<tr height="25">
<td width="93" valign="top" align="right"><p>出生日期:</p></td>
<td width="185" valign="top"> <%=rs("personnel_birthday")%></td>
<td width="139" valign="top" align="right">籍贯:</td>
<td width="139" valign="top"> <%=rs("personnel_hometown")%></td>
</tr>
<tr height="25">
<td width="93" valign="top" align="right"><p>婚姻状况:</p></td>
<td width="185" valign="top"> <%=rs("personnel_marry")%></td>
<td width="139" valign="top" align="right">身份证号码:</td>
<td width="139" valign="top"> <%=rs("personnel_idcode")%></td>
</tr>
<tr height="25">
<td width="93" valign="top" align="right"><p>政治面貌: </p></td>
<td width="185" valign="top"> <%=rs("personnel_political")%></td>
<td width="139" valign="top" align="right">最高学历:</td>
<td width="139" valign="top"> <%=rs("personnel_educ")%></td>
</tr>
<tr height="25">
<td width="93" valign="top" align="right"><p> 家庭地址: </p></td>
<td width="185" valign="top"> <%=rs("personnel_address")%></td>
<td width="139" valign="top" align="right">邮政编码:</td>
<td width="139" valign="top"> <%=rs("personnel_postcode")%></td>
</tr>
<tr height="25">
<td width="93" valign="top" align="right"><p>移动电话:</p></td>
<td width="185" valign="top"> <%=rs("personnel_mphone")%></td>
<td width="139" valign="top" align="right">住宅电话:</td>
<td width="139" valign="top"> <%=rs("personnel_fphone")%></td>
</tr>
<tr height="25">
<td width="93" valign="top" align="right"><p>E_mail地址:</p></td>
<td width="185" valign="top"> <%=rs("personnel_email")%></td>
<td width="139" valign="top" align="right">简历来源:</td>
<td width="139" valign="top"> <%=rs("resume_id")%></td>
</tr>
<tr height="25">
<td width="93" valign="top" align="right"><p>专业：</p></td>
<td width="185" valign="top"> <%=rs("personnel_major")%></td>
<td width="139" valign="top" align="right">毕业院校：</td>
<td width="139" valign="top"> <%=rs("personnel_graduate")%></td>
</tr>
<tr height="25">
<td width="93" valign="top" align="right"><p>职称:</p></td>
<td width="185" valign="top">
<%
dim rs_zc
set rs_zc=server.CreateObject("ADODB.recordset")
rs_zc.open "select tp_id,tp_name from techpost",conn,1,1
while not rs_zc.eof=true
if rs_zc.Fields(0).value=rs("personnel_level") then
response.Write (rs_zc.Fields(1).value)
end if
rs_zc.movenext
wend
rs_zc.Close
set rs_zc=nothing
%>
</td>
<td width="139" valign="top" align="right">技术技能:</td>
<td width="139" valign="top"> <%=rs("personnel_skill")%></td>
</tr>
<tr height="25">
<td valign="top" align="right"><p>岗位:</p></td>
<td valign="top">
<%
dim rs_post
set rs_post=server.CreateObject("ADODB.recordset")
rs_post.open "select post_id,post_name from post",conn,1,1
while not rs_post.eof=true
if rs_post.Fields(0).value=rs("post_id") then
response.Write (rs_post.Fields(1).value)
end if
rs_post.movenext
wend
rs_post.Close
set rs_post=nothing
%>
</td>
<td valign="top" align="right">是否部门负责人：</td>
<td valign="top">
<%
if rs("personnel_deptman")=1 then
response.Write("是")
elseif rs("personnel_deptman")=0 then
response.Write("否")
end if
%>
</td>
</tr>
<tr height="25">
<td valign="top" align="right">入职时间:</td>
<td valign="top"> <%=rs("personnel_sdate")%></td>
<td valign="top" align="right">离职日期:</td>
<td valign="top"> <%=rs("personnel_ldate")%></td>
</tr>
<tr height="25">
<td valign="top" align="right">个人描述：</td>
<td colspan="3" valign="top"><%=rs("personnel_descript")%></td>
</tr>
<tr>
<td colspan="6" valign="top"><div align="center" class="td1"><a href="Search_emly.asp">返回</a></div></td>
</tr>
</table></div>
<!--#include file="../Include/bottom.asp"-->
<!--内容结束-->
<%
rs.Close
set rs = Nothing
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -