📄 show_report_client.asp
字号:
<%@ LANGUAGE="VBSCRIPT"%>
<!--#include file="../conn.asp"-->
<!--#include file="../isuser.asp"-->
<!--#include file="../pub_fun.asp"-->
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<TITLE>客户报表</TITLE></HEAD>
<link rel="STYLESHEET" href="../css.css" type="text/css">
<script language="VBScript">
sub page_onclick(page)
dim str
str = "<input type=hidden name=movepage value='"& page &"'>"
str = str & "<input type=hidden name=textsql value='"& window.frmMain.textsql.value &"'>"
ifmList01.form1.innerHtml = str
ifmList01.form1.submit()
end sub
</script>
<body >
<%
textsql=decrypt(request("sql"))
%>
<form method="POST" name="frmMain">
<TABLE border=0 cellPadding=0 cellSpacing=0 width="720">
<TR >
<TD height="20" align="center">
<%
set rs = server.createobject("adodb.recordset")
'组成查询语句
sql="select distinct client.*,touchman.touchmanname,touchman.touchmansection,touchman.touchmanduty,touchman.touchmanophone,touchman.touchmanmphone,touchman.touchmanemail"
sql=sql&" from client,touchman where client.clientid=touchman.touchmanclientid and touchman.touchmanmain=1 and (client.clientCreatorID="&session("Session_User")&" or client.clientOpenFlag=1) "&textsql
sql=sql&" order by client.clientid "
rs.open sql,conn,3
if not rs.eof then
''设置页面大小
rs.pagesize=5
''得到总页数
pcount = rs.pagecount
for i=1 to pcount
%>
<a style='cursor:hand' onclick='javascript:page_onclick("<%=i%>")'><%=i%></a>
<%
next
%>
<input type=hidden name=textsql value="<%=encrypt(textsql)%>">
<TD>
</TR>
<TR>
<TD align="center">
<iframe id="ifmList01" frameborder="0" height="610" width="715" src="show_report_client01.asp?textsql=<%=encrypt(textsql)%>" marginwidth="0" marginheight="0" framespacing="0"></iframe>
</TD>
</TR>
<TR >
<TD height="20" align="center">
<%
for i=1 to pcount
%>
<a style='cursor:hand' onclick='javascript:page_onclick("<%=i%>")'><%=i%></a>
<%
next
%>
<TD>
</TR>
<%else%>
<TR >
<TD >
没有相应纪录
<TD>
</TR>
<% end if%>
</TABLE>
</form>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -