📄 view_cus.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="../../config.asp"-->
<!--#include file="../checklogin.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<SCRIPT language=JavaScript src="../../inc/meizzDate.js"></SCRIPT>
<link href="../img/css1.css" type=text/css rel=stylesheet>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.style1 {
color: #FFFFFF;
font-weight: bold;
}
.style3 {color: #414141; font-weight: bold; }
.style6 {color: #FEFEFE; font-weight: bold; }
-->
</style>
</head>
<%
id=replace(request.QueryString("id"),"'","")
sql="select a.*,b.truename from oa_crm_cus as a inner join oa_admin as b on a.uid=b.id where a.id="&id
set rs=conn.execute(sql)
if not isnumeric(id) then
response.Write("参数错误")
response.End()
end if
if not rs.eof then
'基本信息
cus_num=trim(rs("cus_num"))
cus_name=trim(rs("cus_name"))
cus_hangye=trim(rs("cus_hangye"))
cus_comefrom=trim(rs("cus_comefrom"))
'联系人信息
uname=trim(rs("cus_contactname"))
mobile=trim(rs("cus_contactmobile"))
phone=trim(rs("cus_contactphone"))
fax=trim(rs("cus_contactfax"))
email=trim(rs("cus_contactemail"))
'单位信息
cus_address=trim(rs("cus_address"))
cus_post=trim(rs("cus_post"))
cus_url=trim(rs("cus_url"))
cus_txt=trim(rs("cus_txt"))
truename=trim(rs("truename"))
end if
%>
<body>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#F2F2F2" class="tabel1">
<tr align="center">
<td height="25" bgcolor="#CC0000"><span class="style1">客户信息</span></td>
</tr>
<tr bgcolor="#F9F9F9">
<td height="25" align="center"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="47%" height="20" align="left"><b>基本信息</b></td>
<td width="53%" height="20" align="left"><B>联系人信息</B></td>
</tr>
<tr>
<td align="left" valign="top"><TABLE width="100%" BORDER=0 CELLPADDING=0 CELLSPACING=5>
<TR>
<TD WIDTH=72 height="20">客户编号</TD>
<TD WIDTH=300 height="20"><%=cus_num%></TD>
</TR>
<TR>
<TD height="20">客户名称</TD>
<TD WIDTH=300 height="20"><%=cus_name%></TD>
</TR>
<TR>
<TD height="20">行业</TD>
<TD height="20"><%=cus_hangye%></TD>
</TR>
<TR>
<TD height="20">客户来源</TD>
<TD height="20"><%=cus_comefrom%></TD>
</TR>
<TR>
<TD height="20">业务人员</TD>
<TD height="20"><%=truename%></TD>
</TR>
</TABLE></td>
<td align="left" valign="top"><TABLE width="100%" BORDER=0 CELLPADDING=0 CELLSPACING=5>
<TR>
<TD WIDTH=72>联系人姓名</TD>
<TD WIDTH=300 height="20"><%=uname%></TD>
</TR>
<TR>
<TD>手机</TD>
<TD height="20"><%=mobile%></TD>
</TR>
<TR>
<TD>电话</TD>
<TD height="20"><%=phone%></TD>
</TR>
<TR>
<TD>传真</TD>
<TD height="20"><%=fax%></TD>
</TR>
<TR>
<TD>E-Mail</TD>
<TD height="20"><%=email%></TD>
</TR>
</TABLE></td>
</tr>
<tr>
<td align="left"><B>单位信息</B></td>
<td align="left"><b>其它信息</b></td>
</tr>
<tr>
<td align="left" valign="top"><TABLE width="100%" BORDER=0 CELLPADDING=0 CELLSPACING=5>
<TR>
<TD WIDTH=72>通讯地址</TD>
<TD WIDTH=300 height="20"><%=cus_address%></TD>
</TR>
<TR>
<TD>邮政编码</TD>
<TD WIDTH=300 height="20"><%=cus_post%></TD>
</TR>
<TR>
<TD>单位网站</TD>
<TD height="20"><a href="<%=cus_url%>"><%=cus_url%></a></TD>
</TR>
</TABLE></td>
<td align="left" valign="top"><TABLE width="100%" BORDER=0 CELLPADDING=0 CELLSPACING=5>
<TR>
<TD WIDTH=72>其他描述</TD>
<TD WIDTH=300 rowspan="2" valign="top"><%=cus_txt%></TD>
</TR>
<TR>
<TD VALIGN=top></TD>
</TR>
</TABLE></td>
</tr>
<tr>
<td height="25" colspan="2" align="left"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#B2B2B2">
<tr bgcolor="#F9F9F9">
<td height="25" colspan="5"><span class="style3"> <img src="../img/item_point.gif" width="4" height="7"> 关联项目</span></td>
</tr>
<tr align="center" bgcolor="#CC0000">
<td width="18%" height="25"><span class="style6"> 项目编号 </span></td>
<td width="40%"><span class="style6"> 项目名称 </span></td>
<td width="15%"><span class="style6"> 联系人 </span></td>
<td width="12%"><span class="style6"> 电话 </span></td>
<td width="15%"><span class="style6"> 手机 </span></td>
</tr>
<%
psql="select id,pro_num,title,uname,tel,mobile from oa_cus_project where cusid="&id
set prs=server.CreateObject("adodb.recordset")
prs.open psql,conn,1,3
for i=1 to prs.recordcount
bgColor="#efefef"
if i mod 2=0 then bgColor="#ffffff"
%>
<tr align="center" bgcolor="<%=bgColor%>">
<td height="25"><%=prs(1)%></td>
<td><%=prs(2)%></td>
<td><%=prs(3)%></td>
<td><%=prs(4)%></td>
<td><%=prs(5)%></td>
</tr>
<%
prs.movenext
next
prs.close
set prs=nothing
%>
</table> </td>
</tr>
<tr>
<td height="10" colspan="2" align="left"></td>
</tr>
<tr>
<td height="25" colspan="2" align="left"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#B2B2B2">
<tr bgcolor="#F9F9F9">
<td height="25" colspan="6"><span class="style3"> <img src="../img/item_point.gif" width="4" height="7"> 联系人信息</span></td>
</tr>
<tr align="center" bgcolor="#CC0000">
<td width="18%" height="25"><span class="style6"> 联系人姓名 </span></td>
<td width="18%"><span class="style6"> 手机 </span></td>
<td width="17%"><span class="style6"> 电话 </span></td>
<td width="16%"><span class="style6"> 传真 </span></td>
<td width="16%"><span class="style6"> E-Mail </span></td>
<td width="15%"><span class="style6">QQ</span></td>
</tr>
<%
psql="select id,uname,mobile,tel,fax,email,qq from oa_cus_contact where cusid="&id
set prs=server.CreateObject("adodb.recordset")
prs.open psql,conn,1,3
for i=1 to prs.recordcount
bgColor="#efefef"
if i mod 2=0 then bgColor="#ffffff"
%>
<tr align="center" bgcolor="<%=bgColor%>">
<td height="25"><%=prs(1)%></td>
<td><%=prs(2)%></td>
<td><%=prs(3)%></td>
<td><%=prs(4)%></td>
<td><%=prs(5)%></td>
<td><%=prs(6)%></td>
</tr>
<%
prs.movenext
next
prs.close
set prs=nothing
%>
</table></td>
</tr>
<tr>
<td height="10" colspan="2" align="left"></td>
</tr>
<tr>
<td height="25" colspan="2" align="left"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#B2B2B2">
<tr bgcolor="#F9F9F9">
<td height="25" colspan="4"> <strong><span class="style3"> <img src="../img/item_point.gif" width="4" height="7"> </span>客户跟单信息</strong></td>
</tr>
<tr align="center" bgcolor="#CC0000">
<td width="18%" height="25"><span class="style6">项目名称 </span></td>
<td width="11%"><span class="style6">跟单日期 </span></td>
<td width="9%"><span class="style6">联系人</span></td>
<td width="62%"><span class="style6"> 跟单内容 </span></td>
</tr>
<%
psql="select title,gdtime,a.uname,a.content from oa_cus_form as a inner join oa_cus_project as b on a.projectid=b.id where a.cusid="&id
set prs=server.CreateObject("adodb.recordset")
prs.open psql,conn,1,3
for i=1 to prs.recordcount
bgColor="#efefef"
if i mod 2=0 then bgColor="#ffffff"
%>
<tr align="center" bgcolor="<%=bgColor%>">
<td height="25"><%=prs(0)%></td>
<td><%=prs(1)%></td>
<td><%=prs(2)%></td>
<td><%=prs(3)%></td>
</tr>
<%
prs.movenext
next
prs.close
set prs=nothing
%>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -