📄 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" >
<%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%>
<br><br><br><br><h4><center><b>经销商级别分析</b></center></h4><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>
<td align="center"><%=rs.recordcount%></td>
<td align="center"><%=round((rs.recordcount/total)*100,2)%></td>
</tr>
<tr bgcolor="#f7f7f7">
<td align="center">价值客户</td>
<td align="center"><%=rs2.recordcount%></td>
<td align="center"> <%=round((rs2.recordcount/total)*100,2)%></td>
</tr>
<tr bgcolor="#EDEBEC">
<td align="center">一般客户</td>
<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="D_JXSFenXiGraphic.asp?jxs=<%=temp%>"><font size="2">图形</font></a><font size="2">     <a href="../Customer/D_JXSFenXiMainFrm.asp">返回</a></font></center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -