⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 personinf.asp

📁 企业办公自动化管理系统 asp+sql server 2005
💻 ASP
字号:
<!--#include file="include/sqlstr.asp"-->
<!--#include file="include/bgsub.asp"-->
<!--#include file="include/opendb.asp"-->
<!--#include file="include/checked.asp"-->
<!--#include file="include/keepformat.asp"-->
<%
'-----------------------------------------
oabusyname=request.cookies("oabusyname")
oabusysuid=request.cookies("oabusysuid")
oabusyuserdept=request.cookies("oabusyuserdept")
oabusyuserlevel=request.cookies("oabusyuserlevel")
if oabusysuid="" then response.redirect "default.asp"
'--------------------------------------
'打开数据库,读出编辑通讯录权限
set conn=opendb()
set rs=server.createobject("adodb.recordset")
sql="select * from a_userinf where suid=" & sqlstr(oabusysuid)
rs.open sql,conn,1
allow_edit_person_personinf=rs("allow_edit_person_personinf")
%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link rel="stylesheet" href="css/css.css" type="text/css">
<script language="javascript1.2" src="js/openwin.js"></script>
<title>企业办公系统</title>
</head>
<body bgcolor="#ffffff" topmargin="5" leftmargin="5">
<% call bghead() %>
<center>
<table>
<tr>
<td>
<b><%=oabusyname%>的个人基本档案</b>&nbsp;&nbsp;
</td>
<%
if allow_edit_person_personinf="yes" then
%>
<form method="post" action="editpersoninf.asp"><td>
<input type="submit" value="编辑">
</td>
</form>
<%
end if
%>
</tr>
</table>
</center>
<%
call bgmid()
%>
<%
'打开数据库,读出个人档案
set conn=opendb()
set rs=server.createobject("adodb.recordset")
sql="select * from personinf where suid=" & sqlstr(oabusysuid)
rs.open sql,conn,1
dim a(33)
if not rs.eof and not rs.bof then
for i=1 to 33
a(i)=rs("a" & i)
next
inputdate=rs("inputdate")
updatedate=rs("updatedate")
havephoto=rs("havephoto")
id=rs("id")
else
for i=1 to 33
a(i)=""
next
inputdate=""
updatedate=""
havephoto="no"
end if
%>
<center>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="100%">        
  <tr>        
    <td width="30%"><b>员工编号:</b><%=a(1)%>&nbsp;</td>        
    <td width="35%"><b>录入时间:</b><%=inputdate%>&nbsp;</td>        
    <td align="right"><b>修改时间:</b><%=updatedate%>&nbsp;</td>        
  </tr>        
</table>        
    
<table border="0" cellpadding="0" cellspacing="0" width="100%">        
    <tr>        
      <td width="15%" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000"><b>姓&nbsp;&nbsp;&nbsp;&nbsp;名</b></td>        
      <td width="35%" style="border-right: 1 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000"><%=oabusyname%>&nbsp;</td>        
      <td width="15%" align="center" style="border-right: 1 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000"><b>曾&nbsp;用&nbsp;名</b></td>        
      <td width="35%" style="border-right: 1 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(2))%>&nbsp;</td>        
      <td width="80" height="100" rowspan="5" align="center" valign=center style="border-right: 2 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000">
<%
if havephoto="yes" then
%>
<img src="showphoto.asp?id=<%=id%>" width="80" height="100" border="0">
<%
else
%>
<table width=80>
<tr>
<td align=center>
无<br>照<br>片
</td>
</tr></table>
<%
end if
%>
</td>        
    </tr>        
    <tr>        
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>性&nbsp;&nbsp;&nbsp;&nbsp;别</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(3))%>&nbsp;</td>        
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>民&nbsp;&nbsp;&nbsp;&nbsp;族</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(4))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>所属部门</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=oabusyuserdept%>&nbsp;</td>        
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>职&nbsp;&nbsp;&nbsp;&nbsp;务</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=oabusyuserlevel%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>职&nbsp;&nbsp;&nbsp;&nbsp;称</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(5))%>&nbsp;</td>        
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>出生日期</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(6))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>政治面貌</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(7))%>&nbsp;</td>        
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>健康状况</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(8))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td align="center" height="20" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>籍&nbsp;&nbsp;&nbsp;&nbsp;贯</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(9))%>&nbsp;</td>        
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>体&nbsp;&nbsp;&nbsp;&nbsp;重</b></td>        
      <td colspan="2" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(10))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>身份证号</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(11))%>&nbsp;</td>        
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>身&nbsp;&nbsp;&nbsp;&nbsp;高</b></td>        
      <td colspan="2" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(12))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>婚姻状况</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(13))%>&nbsp;</td>        
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>毕业院校</b></td>        
      <td colspan="2" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(14))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>本人成分</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(15))%>&nbsp;</td>        
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>专&nbsp;&nbsp;&nbsp;&nbsp;业</b></td>        
      <td colspan="2" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(16))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>工&nbsp;&nbsp;&nbsp;&nbsp;龄</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(17))%>&nbsp;</td>        
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>学&nbsp;&nbsp;&nbsp;&nbsp;历</b></td>        
      <td colspan="2" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(18))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>外语语种</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(19))%>&nbsp;</td>        
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>外语水平</b></td>        
      <td colspan="2" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(20))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>普通话程度</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(21))%>&nbsp;</td>        
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>粤语程度</b></td>        
      <td colspan="2" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(22))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>计算机能力</b></td>        
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(23))%>&nbsp;</td>        
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>户口所在地</b></td>        
      <td colspan="2" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(24))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>现&nbsp;住&nbsp;址</b></td>        
      <td colspan="4" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(25))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>档案存放地</b></td>        
      <td colspan="4" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(26))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>个人专长<br>        
        以及爱好</b></td>        
      <td colspan="4" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=checked3(a(27))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>本人曾受<br>过何种奖<br>励和处分</b></td>        
      <td colspan="4" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=keepformat(checked3(a(28)))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>工作经历</b></td>        
      <td colspan="4" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=keepformat(checked3(a(29)))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>家庭情况</b></td>        
      <td colspan="4" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=keepformat(checked3(a(30)))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>本&nbsp;&nbsp;&nbsp;&nbsp;人<br>联系方式</b></td>        
      <td colspan="4" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=keepformat(checked3(a(31)))%>&nbsp;</td>        
    </tr>        
    <tr>        
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>发生意外<br>紧急情况<br>通知何人</b></td>        
      <td colspan="4" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=keepformat(checked3(a(32)))%>&nbsp;</td>         
    </tr>         
    <tr>         
      <td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 2 solid #000000"><b>备&nbsp;&nbsp;&nbsp;&nbsp;注</b></td>        
      <td colspan="4" style="border-right: 2 solid #000000; border-bottom: 2 solid #000000"><%=keepformat(checked3(a(33)))%>&nbsp;</td>        
    </tr>        
</table>        
<table>
<tr>
<td>
<b><%=oabusyname%>的个人基本档案</b>&nbsp;&nbsp;
</td>
<%
if allow_edit_person_personinf="yes" then
%>
<form method="post" action="editpersoninf.asp"><td>
<input type="submit" value="编辑">
</td>
</form>
<%
end if
%>
</tr>
</table>
<br>

</center>
<%
call bgback()
%>
</body>
</html>










⌨️ 快捷键说明

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