📄 pmember_info.asp
字号:
<!--#include file="../../conn/conn.asp" -->
<!--#include file="../../Inc/Commoncode.asp" -->
<!--#include file="../checkvalid.asp" -->
<%
If Not FRAdminLevel(302) Then
Call ErrorMsg()
End If
member_id=trim(request("id"))
sql="select * from JOB_member where member_id="&member_id
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<html>
<head>
<title>查看会员信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href=../css/style.css rel=stylesheet type="text/css">
</head>
<body>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="1" class="tableBorder">
<tr>
<th height="25" class="tableHeaderText" colspan="2"> 查看会员信息 </th>
</tr>
<tr>
<td width="160" align="right">通行证帐号：</td>
<td width="576"><%=rs("member_login")%> </td>
</tr>
<tr>
<td align="right">真实姓名：</td>
<td><%=rs("Member_name")%></td>
</tr>
<tr>
<td align="right">性别：</td>
<td><%select case rs("Member_sex")
case 1
response.write "男"
case 2
response.write "女"
end select
%></td>
</tr>
<tr>
<td align="right">出生年月：</td>
<td><%=rs("Member_birth")%> </td>
</tr>
<tr>
<td align="right">证件类型：</td>
<td><%=rs("Member_Answer")%> </td>
</tr>
<tr>
<td align="right">证件号码：</td>
<td><%=rs("Member_idcard")%></td>
</tr>
<tr>
<td align="right">婚姻状况：</td>
<td><%set rs1=server.CreateObject("adodb.recordset")
If rs("Member_marriage")<>"" Then
sql="select marriage_name from JOB_marriage where marriage_id="&rs("Member_marriage")
rs1.open sql,conn,1,1
marriage_name=rs1("marriage_name")
rs1.close
%><%=marriage_name%>
<%End If%></td>
</tr>
<tr>
<td align="right">政治面貌：</td>
<td><%
If rs("Member_polity")<>"" Then
sql="select polity_name from JOB_polity where polity_id="&rs("Member_polity")
rs1.open sql,conn,1,1
polity_name=rs1("polity_name")
rs1.close
%><%=polity_name%>
<%End If%> </td>
</tr>
<tr>
<td align="right">户口所在地：</td>
<td><%
If rs("Member_hukouprovinceid")<>"" Then
sql="select * from JOB_provinceandcity where id="&rs("Member_hukouprovinceid")
rs1.open sql,conn,1,1
Member_hukouprovince=rs1("province_city")
rs1.close
%>
<%=Member_hukouprovince%>
<%
End If
If rs("Member_hukoucapitalid")<>"" Then
sql="select * from JOB_provinceandcity where id="&rs("Member_hukoucapitalid")
rs1.open sql,conn,1,1
Member_hukoucapital=rs1("province_city")
rs1.close
%>
<%=Member_hukoucapital%>
<%
End If
If rs("Member_hukoucityid")<>"" Then
sql="select * from JOB_provinceandcity where id="&rs("Member_hukoucityid")
rs1.open sql,conn,1,1
Member_hukoucity=rs1("province_city")
rs1.close
%><%=Member_hukoucity%>
<%End If%></td>
</tr>
<tr>
<td align="right">现所在地：</td>
<td><%
If rs("Member_provinceid")<>"" Then
sql="select * from JOB_provinceandcity where id="&rs("Member_provinceid")
rs1.open sql,conn,1,1
Member_province=rs1("province_city")
rs1.close
%>
<%=Member_province%>
<%
End If
If rs("Member_capitalid")<>"" Then
sql="select * from JOB_provinceandcity where id="&rs("Member_capitalid")
rs1.open sql,conn,1,1
Member_capital=rs1("province_city")
rs1.close
%>
<%=Member_capital%>
<%
End IF
If rs("Member_cityid")<>"" Then
sql="select * from JOB_provinceandcity where id="&rs("Member_cityid")
rs1.open sql,conn,1,1
Member_city=rs1("province_city")
rs1.close
%>
<%=Member_city%>
<%End If%></td>
</tr>
<tr>
<td align="right">最高学历：</td>
<td><%
If rs("Member_edu")<>"" Then
sql="select * from JOB_edu where edu_id="&rs("Member_edu")
rs1.open sql,conn,1,1
edu_name=rs1("edu_name")
rs1.close
%><%=edu_name%>
<%End If%></td>
</tr>
<tr>
<td align="right">联系电话：</td>
<td><%=rs("Member_tel")%> </td>
</tr>
<tr>
<td align="right">聊天号码：</td>
<td><%=rs("Member_chat")%> </td>
</tr>
<tr>
<td align="right">电子邮箱：</td>
<td><%=rs("Member_email")%> </td>
</tr>
<tr>
<td align="right">个人主页：</td>
<td><%=rs("Member_url")%></td>
</tr>
<tr>
<td align="right">通讯地址：</td>
<td><%=rs("Member_address")%> </td>
</tr>
<tr>
<td align="right">邮政编码：</td>
<td><%=rs("Member_post")%> </td>
</tr>
<tr>
<td colspan="2" align="center"><input name="Submit3" type="button" class="inputs" id="Submit3" style="cursor:pointer" onClick="javascript:window.close();" value="关 闭" /></td>
</tr>
</table>
</body>
</html>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -