?? show_report_sellsumproduct.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>銷售統(tǒng)計報表</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"))
'組成查詢語句
sql="SELECT SellProduct,MAX(SellProductprice) AS sellproductprice, sum(SellProductnum) AS SellProductnum, sum(Sellmoney) AS sellmoney"
sql=sql&" from sell"
sql=sql&" where (sellCreatorID="&session("Session_User")&"or sellopenflag='1' ) "&textsql
sql=sql&"GROUP BY SellProduct"
%>
<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")
rs.open sql,conn,3
if not rs.eof then
rs.pagesize=30
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_sellsumproduct01.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 >
沒有相應(yīng)紀(jì)錄
<TD>
</TR>
<% end if%>
</TABLE>
</form>
</BODY>
</HTML>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -