📄 employeeopen.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="DataBase/conn.asp" -->
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from tb_Employee where id="&request("id")
rs.open sql,conn,1,1
'部门
function bumen
set rsb=server.CreateObject("adodb.recordset")
sqlb="select * from tb_dept where id="&rs("suoshu")
rsb.open sqlb,conn,1,1
response.Write(rsb("title"))
end function
'职位
function zhiwei
set rsz=server.CreateObject("adodb.recordset")
sqlz="select * from tb_ZhiWei where id="&rs("zhiwei")
rsz.open sqlz,conn,1,1
response.Write(rsz("zhiwei"))
end function
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>个人详细信息</title>
<style type="text/css">
<!--
.style1 { color: #FF0000;
font-size: 16px;
font-weight: bold;
}
.style2 {color: #FF0000}
body {
background-color: #efefef;
}
body,td,th {
font-size: 12px;
}
-->
</style>
<link href="CSS/css.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_goToURL() { //v3.0
var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}
//-->
</script>
</head>
<body>
<table width="453" height="422" border="0" align="center" cellspacing="1">
<tr bgcolor="#EFEFEF">
<td height="47" colspan="4"><div align="center" class="style1">员工信息
<input name="post" type="hidden" id="post" value="true">
</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="94" bgcolor="#efefef"><div align="right">姓名：</div></td>
<td width="135" bgcolor="#EFEFEF"> <%=rs("name")%></td>
<td width="42" bgcolor="#efefef"><div align="right">年龄：</div></td>
<td width="126" bgcolor="#EFEFEF"> <%=rs("age")%>岁</td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#efefef"><div align="right">英文名：</div></td>
<td width="135" bgcolor="#EFEFEF"> <%=rs("ename")%></span></td>
<td width="42" bgcolor="#efefef"><div align="right">性别：</div></td>
<td width="126" bgcolor="#EFEFEF"> <%=rs("sex")%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="right" bgcolor="#efefef">政治面貌：</td>
<td width="135" bgcolor="#EFEFEF"> <%=rs("mianmao")%></td>
<td width="42" bgcolor="#efefef">婚否：</td>
<td width="126" bgcolor="#EFEFEF"> <%=rs("hun")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="26" bgcolor="#EFEFEF"><div align="right">出生年月日：</div></td>
<td colspan="3" bgcolor="#EFEFEF"> <%=rs("chusheng")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="right" bgcolor="#EFEFEF">电子邮件：</td>
<td colspan="3" bgcolor="#EFEFEF"> <%=rs("email")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="right" bgcolor="#EFEFEF">学历：</td>
<td colspan="3" bgcolor="#EFEFEF"> <%=rs("xueli")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="right" bgcolor="#EFEFEF">毕业学校：</td>
<td colspan="3" bgcolor="#EFEFEF"> <%=rs("school")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="right" bgcolor="#EFEFEF">专业：</td>
<td colspan="3" bgcolor="#EFEFEF"> <%=rs("zhuanye")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EFEFEF"><div align="right">籍贯：</div></td>
<td colspan="3" bgcolor="#EFEFEF"> <%=rs("jiguan")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EFEFEF"><div align="right">现在住址：</div></td>
<td colspan="3" bgcolor="#EFEFEF"> <%=rs("xianzhi")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EFEFEF"><div align="right">联系电话：</div></td>
<td colspan="3" bgcolor="#EFEFEF"> <%=rs("tel")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EFEFEF"><div align="right">手机：</div></td>
<td colspan="3" bgcolor="#EFEFEF"> <%=rs("hander")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EFEFEF"><div align="right">进公司时间：</div></td>
<td colspan="3" bgcolor="#EFEFEF"> <%=rs("jingongsi")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="27" align="right" bgcolor="#EFEFEF">所属部门：</td>
<td colspan="3" bgcolor="#EFEFEF"> <%call bumen%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="27" align="right" bgcolor="#EFEFEF">职位：</td>
<td colspan="3" bgcolor="#EFEFEF"> <%call zhiwei%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="4" bgcolor="#EFEFEF"><div align="center">
<input name="Submit" type="button" class="botton" onClick="MM_goToURL('parent','employeeadde.asp?id=<%=rs("id")%>');return document.MM_returnValue" value=" 修 改 " >
<input name="Submit2" type="button" class="botton" value=" 关 闭 " onClick="window.close()">
<br>
</div></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -