📄 contact_person_detail.asp
字号:
<!--#include file="../config.asp"-->
<!--#include file="../inc/check_login.asp"-->
<!--#include file="../inc/functions.asp"-->
<%
Application_ID = 1000100 '本功能编号，含义请查看编码表
if not CheckAuth(Session("Employee_ID"),Application_ID) then '验证权限
Server.Transfer "../err/un_authorized.htm"
response.end
end if
%>
<!--**************身份验证部分****************-->
<%
Contact_Person_ID = request("Contact_Person_ID")
if not IsNot(Contact_Person_ID,"n") then
response.write "客户联系人编号丢失"
response.end
end if
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
conn.open connstr
'取得客户名称
sql = "select Customers_Contact_Person.*,Customers.Customer_Name from Customers_Contact_Person,Customers where Customers_Contact_Person.Contact_Person_ID = " & Contact_Person_ID & " and Customers_Contact_Person.Customer_ID = Customers.Customer_ID"
set rs = conn.execute(sql)
if not rs.eof then
Contact_Person_Name = rs("Contact_Person_Name")
Gender = rs("Gender")
Rank = rs("Rank")
Tel = rs("Tel")
Fax = rs("Fax")
Mobile = rs("Mobile")
Email = rs("Email")
Customer_Name = rs("Customer_Name")
if Gender then
Gender = "男"
else
Gender = "女"
end if
else
response.write "没有该客户联系人"
response.end
end if
rs.close
set rs = nothing
conn.close
set conn = nothing
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK rel="stylesheet" type="text/css" href="../style.css">
</head>
<body>
客户联系人 → <%= Contact_Person_Name %>
<hr size=1>
<table border=0 cellpadding=1 cellspacing=1 width="100%">
<tr>
<td bgcolor="#EFEFEF">性别</td><td><%= Gender %></td>
<td bgcolor="#EFEFEF">职务</td><td><%= Rank %></td>
</tr>
<tr>
<td bgcolor="#EFEFEF">电话</td><td><%= Tel %></td>
<td bgcolor="#EFEFEF">传真</td><td><%= Fax %></td>
</tr>
<tr>
<td bgcolor="#EFEFEF">手机</td><td><%= Mobile %></td>
<td bgcolor="#EFEFEF">电子邮件</td><td><a href="mailto:<%= Email %>"><%= Email %></a></td>
</tr>
<tr>
<td bgcolor="#EFEFEF">公司名称</td><td colspan="3"><%= Customer_Name %></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -