📄 adminproductsale.asp
字号:
<%dim nowplace
nowplace="product"
dim dbpath
dbpath="../"
%>
<!--#include file="chk.asp"-->
<!--#include file="../db_conn.asp" -->
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>销售报表</title>
<link href=AdminStyle.css rel=stylesheet type=text/css>
<script src="jsdate.js"></script>
<script language="javascript">
<!--
function checkdata()
{
if(form1.bid.value==''){
alert("请选择商品大类！");
form1.bid.focus();
return false;
}
if(form1.sid.value==''){
alert("请选择商品小类！");
form1.sid.focus();
return false;
}
if(form1.startime.value==''){
alert("请选择开始时间！");
form1.startime.focus();
return false;
}
if(form1.endtime.value==''){
alert("请选择结束时间！");
form1.endtime.focus();
return false;
}
document.form1.B1.disabled=true
document.form1.B1.value="生成生成中……"
}
//-->
</script>
</head>
<%
dim count
set rs=server.createobject("adodb.recordset")
sql = "select * from small_class order by addtime desc"
rs.open sql,conn,1,1
%>
<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.form1.sid.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.form1.sid.options[document.form1.sid.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
</script>
<body>
<table border="0" width="100%" id="table1" cellspacing="1" cellpadding="4" style="border: 1px solid #183789; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px">
<form action=Adminproductsale.asp method=post name=form1 onsubmit="return checkdata();"><tr>
<td background="Image/admin_bg_1.gif" height="25" colspan="2">
<font color="#FFFFFF"><b>销售报表</b></font></td>
</tr>
<tr>
<td width="27%" align="right">选择类别：</td>
<td width="71%"><select size="1" name="bid" onChange="changelocation(document.form1.bid.options[document.form1.bid.selectedIndex].value)">
<option value="">≡≡请选择大类≡≡</option>
<%sql="select id,txt_big_class from big_class order by addtime"
set rs=conn.execute (sql)
set id=rs("id")
set big_class=rs("txt_big_class")
do while not rs.eof
%>
<option value="<%=id%>"><%=big_class%></option>
<%rs.movenext
loop
%>
</select> <select name="sid" style='width:147;background-color:white;font-size:12;color:black; height:18' size="1">
<option selected value="">≡≡请选择小类≡≡</option></select></td>
</tr>
<tr>
<td width="27%" align="right">选择产品：</td>
<td width="71%"><input type="text" readonly name="pname" size="25"><input onclick="javascript:window.open('selectproduct.asp',null,'width=450,height=400')" type="button" value="弹出子窗口>>浏览"><br>
<font color="#FF0000"><u>此项可选，如果不选就是当前类别下的所有统计，如果选择就是针对某一个产品的统计。</u></font></td>
</tr>
<tr>
<td width="27%" align="right">开始日期：</td>
<td width="71%">
<input type="text" name="startime" size="18" readonly><a href="#SelectDate" onclick="SD(this,'document.form1.startime')"><img border="0" src="Image/button.gif" width="34" height="21"></a></td>
</tr>
<tr>
<td width="27%" align="right">结束日期：</td>
<td width="71%">
<input type="text" name="endtime" size="18" readonly><a href="#SelectDate" onclick="SD(this,'document.form1.endtime')"><img border="0" src="Image/button.gif" width="34" height="21"></a></td>
</tr>
<tr>
<td width="27%" align="right">排序（按照时间排）：</td>
<td width="71%"><input type="radio" value="asc" checked name="px">升序
<input type="radio" value="desc" name="px">降序</td>
</tr>
<tr>
<td colspan="2"><input type=hidden name=pid>
<p align="center"><input type="submit" value="生成报表" name="B1"></td>
</tr></form>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -