📄 d_jxsfenxilevelfrm.asp
字号:
<!--#include file="../include/Pubconn.asp"-->
<!--#include file="../include/PubConnCode.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title><link href="../cread.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFFF" >
<%hzb="战略客户,价值客户,一般客户,"
zzb=""
set rs=server.createobject("adodb.recordset")
if rs.state=1 then rs.close
rs.open "select * from D_clientinfo where tag='hbdealer' and [level]='战略客户' and delflag='0'",pubconn,1,3%>
<%set rs2=server.createobject("adodb.recordset")
if rs2.state=1 then rs2.close
rs2.open "select * from D_clientinfo where tag='hbdealer' and [level]='价值客户' and delflag='0'",pubconn,1,3%>
<%set rs3=server.createobject("adodb.recordset")
if rs3.state=1 then rs3.close
rs3.open "select * from D_clientinfo where tag='hbdealer' and [level]='一般客户' and delflag='0'",pubconn,1,3%>
<%total=rs.recordcount+rs2.recordcount+rs3.recordcount%>
<table border="0" cellpadding="0" cellspacing="0" width="93%">
<tr>
<td width="100%"><b><font size="3"><img border="0" src="../pic/it_22.gif">
</font><font size="2">经销商级别分析</font></b><hr width="40%" size="1" align="left">
</td>
</tr>
</table>
<br><br><br><br>
<center><table border=1 cellspacing=0 width="80%">
<tr>
<td align="center" bgcolor="#DDD2C4">经销商级别</td>
<td align="center" bgcolor="#DDD2C4">数量</td>
<td align="center" bgcolor="#DDD2C4">百分比(%)</td>
</tr>
<tr bgcolor="#EDEBEC">
<td align="center">战略客户</td>
<%zzb=zzb&rs.recordcount&","%>
<td align="center"><%=rs.recordcount%></td>
<td align="center"><%=round((rs.recordcount/total)*100,2)%></td>
</tr>
<tr bgcolor="#f7f7f7">
<td align="center">价值客户</td>
<%zzb=zzb&rs2.recordcount&","%>
<td align="center"><%=rs2.recordcount%></td>
<td align="center"> <%=round((rs2.recordcount/total)*100,2)%></td>
</tr>
<tr bgcolor="#EDEBEC">
<td align="center">一般客户</td>
<%zzb=zzb&rs3.recordcount&","%>
<td align="center"><%=rs3.recordcount%></td>
<td align="center"><%=round((rs3.recordcount/total)*100,2)%></td>
</tr>
<tr bgcolor="#f7f7f7">
<td align="center">合计</td>
<td align="center"><%=rs.recordcount+rs2.recordcount+rs3.recordcount%></td>
<td align="center">100</td>
</tr>
<%rs.close
rs2.close
rs3.close%>
</table></center><br>
<%temp="经销商级别分析"%>
<center><a href="khtx.asp?hzb=<%=hzb%>&zzb=<%=zzb%>&bz=1&unit=&tablename=经销商级别分析"><font size="2">图形</font></a><font size="2">     <a href="D_FenXiMainFrm.asp">返回</a></font></center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -