?? report.asp
字號(hào):
<!--#include file="chk.asp"-->
<!--#include file="db_conn.asp"-->
<html>
<head>
<title>銷售報(bào)表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="style.css" rel=stylesheet type=text/css>
</head>
<body>
<!--#include file="TopManu.asp"-->
<p>
<script language="javascript">
<!--//
function checksignup() {
if ( document.myform.lbid.value == '' ) {
window.alert('請(qǐng)選擇產(chǎn)品分類!!');
document.myform.lbid.focus();
}
else if ( document.myform.xlbid.value == '' ) {
window.alert('您是通過后退按扭回到本網(wǎng)頁，請(qǐng)先涮新本網(wǎng)頁，或重新選擇產(chǎn)品類別！');
document.myform.xlbid.focus();
}
else {
return true;
}
return false;
}
//-->
</script>
</p>
<div align="center">
<table border="0" width="100%" id="table1" cellspacing="0" style="border-collapse: collapse" cellpadding="0">
<tr>
<td background="image/admintoptdbg.gif">
<p align="left">
<img border="0" src="image/title_arrow.bmp" width="17" height="27" align="absmiddle"><font color="#808080"><b>產(chǎn)品銷售報(bào)表</b></font></td>
</tr>
</table>
<table width="100%" style="border: 1px solid #CCCCCC; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px; border-collapse:collapse" cellpadding="4">
<form action="report_list.asp" method="get" name="myform" id="myform">
<tr valign="middle" bgcolor="#f1f1f1">
<td align="right" bgcolor="#FFFFFF" width="194">開始時(shí)間：</td>
<td bgcolor="#FFFFFF" width="559"> <select size="1" name="byear">
<%
for i=2005 to 2015
response.write "<option value="&i&">"&i&"</option>"
next
%></select>年<select size="1" name="bmonth">
<%
for ii=1 to 12
response.write "<option value="&ii&">"&ii&"</option>"
next
%></select>月<select size="1" name="bday">
<%
for iii=1 to 31
response.write "<option value="&iii&">"&iii&"</option>"
next
%></select>日</td>
</tr>
<tr valign="middle" bgcolor="#f1f1f1">
<td align="right" bgcolor="#FFFFFF" width="194">結(jié)束時(shí)間：</td>
<td bgcolor="#FFFFFF" width="559"> <select size="1" name="eyear">
<%
for p=2005 to 2015
response.write "<option value="&p&">"&p&"</option>"
next
%></select>年<select size="1" name="emonth">
<%
for pp=1 to 12
response.write "<option value="&pp&">"&pp&"</option>"
next
%></select>月<select size="1" name="eday">
<%
for ppp=1 to 31
response.write "<option value="&ppp&">"&ppp&"</option>"
next
%></select>日</td>
</tr>
<tr valign="middle" bgcolor="#f1f1f1">
<td align="right" bgcolor="#FFFFFF" width="194">報(bào)表范圍：</td>
<td bgcolor="#FFFFFF" width="559"> <%dim rs
dim count
set rs = conn.execute("select * from small_class order by id asc")
%> <script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
count = 0
do while not rs.eof
%>
subcat[<%=count%>] = new Array("<%= trim(rs("txt_small_class"))%>","<%= trim(rs("iid"))%>","<%= trim(rs("id"))%>");
<%
count = count + 1
rs.movenext
loop
rs.close
%>
onecount=<%=count%>;
function changelocation(locationid)
{
document.myform.xlbid.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.myform.xlbid.options[document.myform.xlbid.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
</script> <%
set rs = conn.execute("select * from big_class")
if rs.eof and rs.bof then
response.write "請(qǐng)先添加類別。"
response.end
else
%> <select name="lbid" size="1" onChange="changelocation(document.myform.lbid.options[document.myform.lbid.selectedIndex].value)">
<option value="0" selected>全部大類別</option>
<%do while not rs.eof%>
<option value="<%=trim(rs("id"))%>"><%=trim(rs("txt_big_class"))%></option>
<%
rs.movenext
loop
end if
rs.close
set rs = nothing
conn.Close
set conn = nothing
%>
</select> <select name="xlbid">
<option value="0" selected>全部小類別</option>
</select></td>
</tr>
<tr valign="middle" bgcolor="#f1f1f1">
<td width="194" align="right" bgcolor="#FFFFFF">排序方式(按時(shí)間)：</td>
<td width="559" bgcolor="#FFFFFF"> <INPUT type=radio CHECKED value=desc name=fs onFocus=this.blur()>
降序
<INPUT type=radio value=asc name=fs onFocus=this.blur()>
升序</td>
</tr>
<tr valign="middle" bgcolor="#f1f1f1">
<td align="center" bgcolor="#FFFFFF" width="753" colspan="2">
<input name="Submit" type="submit" value="立即執(zhí)行" onFocus="this.blur()" onClick="javascript:return checksignup()"></td>
</tr>
</form>
</table>
</div>
<div align="center">
<table border="1" width="100%" id="table1" cellspacing="1" style="border-collapse: collapse" bordercolor="#F1F1F1">
<tr>
<td>
<ul>
<li><font color="#FF0000">請(qǐng)注意以下事項(xiàng)</font></li>
<li>當(dāng)要選擇所有產(chǎn)品類別時(shí)，大類別和小類別均選擇“全部大類別”和“全部小類別”。</li>
<li>要分類別統(tǒng)計(jì)報(bào)表時(shí)，請(qǐng)正確選擇大類別和小類別。</li>
<li>默認(rèn)為全部類別(產(chǎn)品)的報(bào)表。</li>
<li>如果看不到小類別(除了沒添加小類別)，請(qǐng)先涮新本網(wǎng)頁，或重新選擇產(chǎn)品類別。</li>
</ul>
</td>
</tr>
</table>
</div>
<table border="0" width="760" id="table3" cellspacing="0" cellpadding="0" align=center>
<tr>
<td align=right><input TYPE="button" VALUE="刷新本頁" ONCLICK="location.reload()"> </td>
</tr>
</table>
</body>
</html>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -