📄 detail.asp
字号:
<!--#include file="conn.asp"-->
<title>库存</title>
<style type="text/css">
<!--
.STYLE2 {font-size: 18px}
a:link {
color: #003366;
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #003366;
}
a:hover {
text-decoration: none;
color: #003366;
}
a:active {
text-decoration: none;
color: #003366;
}
body {
background-color: #ECF2FF;
margin-left: 0px;
margin-right: 0px;
}
.STYLE12 {font-size: 12px}
.STYLE13 {font-size: 12px; font-weight: bold; }
.STYLE25 {font-size: 14px; font-weight: bold; }
.STYLE3 { font-size: 18px;
font-weight: bold;
color: #FFFFFF;
}
.STYLE5 { font-size: 12px;
color: #000055;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<BODY leftmargin="10" topmargin="0">
<p align="center" class="STYLE2">
<table width="100%" height="35" border="0" background="image/top.gif" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center"><span class="STYLE3"><span class="STYLE3">客户详情</span></div></td>
</tr>
</table>
<%id=request("id")
exec="select * from company where id="&id
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<div align="center"><br>
<table width="579" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="28" colspan="4" background="image/headerbg.gif"><strong>基本信息</strong></td>
</tr>
<tr>
<td width="80" height=28 class="STYLE12" ><strong>销 售 员：</strong></td>
<td width="200" class="STYLE12"> <%=rs("seller")%></td>
<td width="80" class="STYLE13">是否共享：</td>
<td width="209" class="STYLE12"> <%=rs("share")%></td>
</tr>
<tr>
<td height="28" class="STYLE13">客户名称：</td>
<td colspan="3" class="STYLE12"> <%=rs("name")%></td>
</tr>
<tr>
<td height="28" class="STYLE13">客户简称：</td>
<td class="STYLE12"> <%=rs("short")%></td>
<td class="STYLE13">所属区域：</td>
<td class="STYLE12"> <%=rs("area")%></td>
</tr>
<tr>
<td height="28" class="STYLE13">单位地址：</td>
<td colspan="3" class="STYLE12"> <%=rs("address")%></td>
</tr>
<tr>
<td height="28" class="STYLE13">公司电话：</td>
<td class="STYLE12"> <%=rs("tel")%></td>
<td class="STYLE13">传<span class="STYLE12"> </span><span class="STYLE12"> </span>真：</td>
<td class="STYLE12"> <%=rs("fax")%></td>
</tr>
<tr>
<td height="28" class="STYLE13">网<span class="STYLE12"> </span><span class="STYLE12"> </span>址：</td>
<td class="STYLE12"> <%=rs("www")%></td>
<td class="STYLE13">邮<span class="STYLE12"> </span><span class="STYLE12"> </span>编：</td>
<td class="STYLE12"> <%=rs("post")%></td>
</tr>
<tr>
<td height="28" class="STYLE13">所属行业：</td>
<td class="STYLE12"> <%=rs("bus")%></td>
<td class="STYLE13">企业性质：</td>
<td class="STYLE12"> <%=rs("nature")%></td>
</tr>
<tr>
<td height="28" class="STYLE13">客户来源：</td>
<td class="STYLE12"> <%=rs("source")%></td>
<td class="STYLE13">客户类别：</td>
<td class="STYLE12"> <%=rs("cate")%></td>
</tr>
<tr>
<td height="28" class="STYLE13">企业描述：</td>
<td colspan="3" class="STYLE12"> <%=rs("des")%></td>
</tr>
</table>
<br>
<table width="579" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="28" colspan="5" background="image/headerbg.gif"><span class="STYLE25">相关情况</span></td>
</tr>
<tr>
<td height="28" colspan="2" class="STYLE12"><strong>企业人数：</strong></td>
<td width="200" class="STYLE12"><label>
<%
if rs("total")=10 then
response.write "10人以下"
else if rs("total")=30 then
response.write "10-29人"
end if
end if
%></label></td>
<td width="80" class="STYLE13">管理层人数：</td>
<td width="209" class="STYLE12"> <%=rs("high")%></td></tr>
<tr>
<td width="32" rowspan="2" class="STYLE13">上次体检</td>
<td width="46" height="28" class="STYLE13">时间：</td>
<td class="STYLE12"> <%=rs("last_time")%></td><td class="STYLE13">人数：</td>
<td class="STYLE12"> <%=rs("last_num")%></td></tr>
<tr>
<td height="28" class="STYLE13">医院：</td>
<td class="STYLE12"> <%=rs("last_hos")%></td><td class="STYLE13">价格：</td>
<td class="STYLE12"> <%=rs("last_price")%>元/人</td>
</tr>
<tr>
<td height="28" colspan="2" class="STYLE13">主管部门：</td>
<td class="STYLE12"> <%=rs("depart")%></td><td class="STYLE13">负责人：</td>
<td class="STYLE12"> <%=rs("charge")%></td></tr>
<tr>
<td height="28" colspan="2" class="STYLE13">职务：</td>
<td class="STYLE12"> <%=rs("charge_post")%></td><td class="STYLE13">手机：</td>
<td class="STYLE12"> <%=rs("charge_phone")%></td></tr>
<tr>
<td height="28" colspan="2" class="STYLE13">联系电话：</td>
<td class="STYLE12"> <%=rs("charge_tel")%></td><td class="STYLE13">邮箱：</td>
<td class="STYLE12"> <%=rs("charge_mail")%></td></tr>
<% if rs("second")<>"" then
%>
<tr>
<td height="28" colspan="2" class="STYLE13">其他联系人：</td>
<td class="STYLE12"> <%=rs("second")%></td><td class="STYLE13">职务：</td>
<td class="STYLE12"> <%=rs("second_post")%></td></tr>
<tr>
<td height="28" colspan="2" class="STYLE13">联系电话：</td>
<td class="STYLE12"> <%=rs("second_tel")%></td><td class="STYLE13"> </td>
<td class="STYLE12"> </td>
</tr>
<%end if%>
<% if rs("third")<>"" then
%><tr>
<td height="28" colspan="2" class="STYLE13">其他联系人：</td>
<td class="STYLE12"> <%=rs("third")%></td><td class="STYLE13">职务：</td>
<td class="STYLE12"> <%=rs("third_post")%></td></tr>
<tr>
<td height="28" colspan="2" class="STYLE13">联系电话：</td>
<td class="STYLE12"> <%=rs("third_tel")%></td><td class="STYLE12"> </td>
<td class="STYLE12"> </td>
</tr><%end if%>
</table>
<br>
<table width="579" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="28" colspan="4" background="image/headerbg.gif"><span class="STYLE25"><strong>备注</strong></td>
</tr>
<tr>
<td width="80" height="28" class="STYLE13">备<span class="STYLE12"> </span><span class="STYLE12"> </span>注：</td>
<td width="493" colspan="3" class="STYLE12">
<label></label>
<%=rs("remark")%></td>
</tr>
</table>
<%
idd=rs("id")
exe="select * from follow where company_id='"&idd&"'"
set ds=server.createobject("adodb.recordset")
ds.open exe,conn,1,1
Do While Not ds.Eof
%><br>
<table width="579" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="28" colspan="4" background="image/headerbg.gif"><span class="STYLE25">跟踪情况</span></td>
</tr>
<tr>
<td width="80" height=28 class="STYLE12" ><span class="STYLE19"><strong>拜访销售员：</strong></span></td>
<td width="200" class="STYLE12"><span class="STYLE19"> </span><%=ds("seller")%> </td>
<td width="80" class="STYLE12"><span class="STYLE19"><strong>拜访人：</strong></span></td>
<td width="209" class="STYLE12"><span class="STYLE19">
<%=ds("customer")%>
</span></td>
</tr>
<tr>
<td height="28" class="STYLE12"><span class="STYLE19"><strong>拜访时间：</strong></span></td>
<td class="STYLE12"><span class="STYLE19"> </span><%=ds("date")%><span class="STYLE19"> </span><%=ds("time1")%>-<%=ds("time2")%></td>
<td class="STYLE13">拜访方式：</td>
<td class="STYLE12"><span class="STYLE19"> </span><%=ds("mode")%></td>
</tr>
<tr>
<td height=28 class="STYLE12"><span class="STYLE19"><strong>拜访目的：</strong></span></td>
<td colspan="3" class="STYLE12"><span class="STYLE19"> </span><%=ds("aim")%></td>
</tr>
<tr>
<td height="28" class="STYLE12"><span class="STYLE19"><strong>拜访记录：</strong></span></td>
<td colspan="3" class="STYLE12"><span class="STYLE19"> </span><%=ds("record")%></td>
</tr>
<tr>
<td height="28" class="STYLE12"><span class="STYLE19"><strong>情况分析：</strong></span></td>
<td colspan="3" class="STYLE12"><span class="STYLE19"> </span><%=ds("ana")%></td>
</tr>
<tr>
<td height="28" class="STYLE12"><span class="STYLE19"><strong>跟踪计划：</strong></span></td>
<td colspan="3" class="STYLE12"><span class="STYLE19"> </span><%=ds("plan")%></td>
</tr>
</table>
<% ds.MoveNext
Loop %>
<br>
<%
idd=rs("id")
exe="select * from advice where company_id='"&idd&"'"
set ss=server.createobject("adodb.recordset")
ss.open exe,conn,1,1
Do While Not ss.Eof
%>
<table width="579" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="28" colspan="4" background="image/headerbg.gif"><strong class="STYLE25">部门建议</strong></td>
</tr>
<tr>
<td height="28" class="STYLE12"><strong>建议者：</strong></td>
<td width="200" class="STYLE12"> <%=ss("advicer")%></td>
<td width="80" class="STYLE13">建议时间：</td>
<td width="209" class="STYLE12"> <%=ss("time")%></td>
</tr>
<tr>
<td width="80" height="28" class="STYLE12"><span class="STYLE19"><strong>建议内容：</strong></span></td>
<td colspan="3" class="STYLE12"><span class="STYLE19"> </span><%=ss("advice")%></td>
</tr>
</table><br>
<% ss.MoveNext
Loop %>
</div>
<br>
<table width="100%" height="18" border="0" background="image/bottom.gif" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="bottom"><div align="center"><span class="STYLE5">版权所有 杰尔康</span><br />
</div></td>
</tr>
</table>
</BODY>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -