chart_service_gc.asp
来自「Activity——活动管理模块 Analyse——分析模块 Client—」· ASP 代码 · 共 64 行
ASP
64 行
<!--#include file="../conn.asp"-->
<!--#include file="../IsUser.asp"-->
<!--#include file="Private_fun.asp"-->
<!--#include file="../pub_fun.asp"-->
<script language="vBScript">
opener.close()
</script>
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office">
<!--[if !mso]>
<style>
v\:* { behavior: url(#default#VML) }
o\:* { behavior: url(#default#VML) }
.shape { behavior: url(#default#VML) }
</style>
<![endif]-->
<HEAD><title>服务构成分析</title>
<META NAME="Keywords" CONTENT="FastReport"/>
<META NAME="Description" CONTENT="The FastReport report"/>
<LINK href="../css.css" rel="stylesheet" type="text/css" media="all">
</head>
<body >
<%
''接受传递过来的查询条件和统计对象,并且组和成相应的查询语句
condition= decrypt(trim(request("condition")))
sql="select "
select case trim(request("kind"))
case "0"
sql=sql&" FeedBackSort as feedback, Count(*) as Total FROM FeedBack"
sql=sql& condition
sql=sql&" GROUP BY FeedBackSort"
case "1"
sql=sql&" FeedBackClientID as feedback, Count(*) as Total FROM FeedBack"
sql=sql& condition
sql=sql&" GROUP BY FeedBackClientID"
case "2"
sql=sql&" FeedBackProduct as feedback, Count(*) as Total FROM FeedBack"
sql=sql& condition
sql=sql&" GROUP BY FeedBackProduct"
end select
dim show_data(100,2)
set rs_s = server.createobject("adodb.recordset")
rs_s.open sql,conn,3
if not rs_s.eof then
total_no=rs_s.recordcount
for i=1 to total_no
show_data(i,1)=cdbl(rs_s("total"))
if trim(request("Kind"))="1" or trim(request("Kind"))="" then
show_data(i,2)=showclientname(rs_s("feedback"))
else
show_data(i,2)=rs_s("feedback")
end if
rs_s.movenext
next
end if
width=cint(total_no)*100
call table1(show_data,total_no,-20,40,8,15,width,400)
%>
</BODY></HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?