<!--#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<%=sk%>.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="../inc/input.js"></script>
</head>
<body>
<table width="200" border="0" align="center" cellpadding="2" 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:hand" onClick="javascript:window.close();" value="关 闭" /></td>
  </tr>
</table>
</body>
</html>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>