📄 biao.asp
字号:
<!--#include file="../0.asp"-->
<!--#include file="../../../conn/conn.asp"-->
<!--#include file="../../../conn/nosql.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../css/css.css" rel="stylesheet" type="text/css">
<STYLE>
BODY {
SCROLLBAR-FACE-COLOR: #799ae1;
SCROLLBAR-HIGHLIGHT-COLOR: #799ae1;
SCROLLBAR-SHADOW-COLOR: #799ae1;
SCROLLBAR-3DLIGHT-COLOR: #799ae1;
SCROLLBAR-ARROW-COLOR: #fcfcfc;
SCROLLBAR-TRACK-COLOR: #aabfec;
SCROLLBAR-DARKSHADOW-COLOR: #799ae1;
SCROLLBAR-BASE-COLOR: #799ae1;
background-color: #CAD7F7;
}
.STYLE5 {color: #FFFFFF; font-weight: bold; }
</STYLE>
</head>
<body>
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
//set todays date
Now = new Date();
NowDay = Now.getDate();
NowMonth = Now.getMonth();
NowYear = Now.getYear();
if (NowYear < 2000) NowYear += 1900; //for Netscape
//function for returning how many days there are in a month including leap years
function DaysInMonth(WhichMonth, WhichYear)
{
var DaysInMonth = 31;
if (WhichMonth == "4" || WhichMonth == "6" || WhichMonth == "9" || WhichMonth == "11") DaysInMonth = 30;
if (WhichMonth == "2" && (WhichYear/4) != Math.floor(WhichYear/4)) DaysInMonth = 28;
if (WhichMonth == "2" && (WhichYear/4) == Math.floor(WhichYear/4)) DaysInMonth = 29;
return DaysInMonth;
}
//function to change the available days in a months
function ChangeOptionDays(Which)
{
DaysObject = eval("document.form2." + Which + "Day");
MonthObject = eval("document.form2." + Which + "Month");
YearObject = eval("document.form2." + Which + "Year");
Month = MonthObject[MonthObject.selectedIndex].text;
Year = YearObject[YearObject.selectedIndex].text;
DaysForThisSelection = DaysInMonth(Month, Year);
CurrentDaysInSelection = DaysObject.length;
if (CurrentDaysInSelection > DaysForThisSelection)
{
for (i=0; i<(CurrentDaysInSelection-DaysForThisSelection); i++)
{
DaysObject.options[DaysObject.options.length - 1] = null
}
}
if (DaysForThisSelection > CurrentDaysInSelection)
{
for (i=0; i<(DaysForThisSelection-CurrentDaysInSelection); i++)
{
NewOption = new Option(DaysObject.options.length + 1);
DaysObject.add(NewOption);
}
}
if (DaysObject.selectedIndex < 0) DaysObject.selectedIndex == 0;
}
//function to set options to today
function SetToToday(Which)
{
DaysObject = eval("document.form2." + Which + "Day");
MonthObject = eval("document.form2." + Which + "Month");
YearObject = eval("document.form2." + Which + "Year");
YearObject[0].selected = true;
MonthObject[NowMonth].selected = true;
ChangeOptionDays(Which);
DaysObject[NowDay-1].selected = true;
}
//function to write option years plus x
function WriteYearOptions(YearsAhead)
{
line = "";
for (i=0; i<YearsAhead; i++)
{
line += "<OPTION>";
line += NowYear + i;
}
return line;
}
// End -->
</script>
<form name="form2" method="post" action="?">
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr valign="middle">
<td height="30" colspan="2" align="center" bgcolor="#E8F1FF">销售报表：对一定会计期间（一月,一天）的<font color="#FF3333">网上</font>销售数量，金额，商品进行统计查询，并可导入Excel文件。 </td>
</tr>
<tr valign="middle">
<td height="30" colspan="2" align="center" bgcolor="#E8F1FF"> 自
<select name="FirstSelectYear" class="wenbenkuang" onChange="ChangeOptionDays('FirstSelect')">
<script language="JavaScript">document.write(WriteYearOptions(50));</script>
</select>
年
<select name="FirstSelectMonth" class="wenbenkuang" onChange="ChangeOptionDays('FirstSelect')">
<option>1
<option>2
<option>3
<option>4
<option>5
<option>6
<option>7
<option>8
<option>9
<option>10
<option>11
<option>12
</select>
月
<select name="FirstSelectDay" class="wenbenkuang">
<option>1
<option>2
<option>3
<option>4
<option>5
<option>6
<option>7
<option>8
<option>9
<option>10
<option>11
<option>12
<option>13
<option>14
<option>15
<option>16
<option>17
<option>18
<option>19
<option>20
<option>21
<option>22
<option>23
<option>24
<option>25
<option>26
<option>27
<option>28
<option>29
<option>30
<option>31
</select>
日至
<select name="FirstSelecteYear" class="wenbenkuang" onChange="ChangeOptionDays('FirstSelecte')">
<script language="JavaScript">document.write(WriteYearOptions(50));</script>
</select>
年
<select name="FirstSelecteMonth" class="wenbenkuang" onChange="ChangeOptionDays('FirstSelecte')">
<option>1
<option>2
<option>3
<option>4
<option>5
<option>6
<option>7
<option>8
<option>9
<option>10
<option>11
<option>12
</select>
月
<select name="FirstSelecteDay" class="wenbenkuang">
<option>1
<option>2
<option>3
<option>4
<option>5
<option>6
<option>7
<option>8
<option>9
<option>10
<option>11
<option>12
<option>13
<option>14
<option>15
<option>16
<option>17
<option>18
<option>19
<option>20
<option>21
<option>22
<option>23
<option>24
<option>25
<option>26
<option>27
<option>28
<option>29
<option>30
<option>31
</select>
日
<input name="Submit3" type="submit" value="查询显示">
<input name="Submit3" type="button" value="结果导入excel" onClick="window.location='excel.asp?name=<%=session("www.wygk.cn")%>&FirstSelectYear=<%=request("FirstSelectYear")%>&FirstSelectMonth=<%=request("FirstSelectMonth")%>&FirstSelectDay=<%=request("FirstSelectDay")%>&FirstSelecteYear=<%=request("FirstSelecteYear")%>&FirstSelecteMonth=<%=request("FirstSelecteMonth")%>&FirstSelecteDay=<%=request("FirstSelecteDay")%>'">
</td>
</tr>
</table>
</form>
<table width="99%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF" id="data">
<tr valign="middle" bgcolor="#f1f1f1">
<td width="100" height="25" align="center" background="../../../images/admin_bg_11.gif" bgcolor="#f1f1f1"><span class="STYLE5"><font size="2">订单号</font></span></td>
<td height="25" align="center" background="../../../images/admin_bg_11.gif" bgcolor="#f1f1f1"><span class="STYLE5"><font size="2">产品名称</font></span></td>
<td width="75" height="25" align="center" background="../../../images/admin_bg_11.gif" bgcolor="#f1f1f1"><span class="STYLE5"><font size="2">会员价格</font></span></td>
<td width="75" height="25" align="center" background="../../../images/admin_bg_11.gif" bgcolor="#f1f1f1"><span class="STYLE5"><font size="2">购物数量</font></span></td>
<td width="100" height="25" align="center" background="../../../images/admin_bg_11.gif" bgcolor="#f1f1f1"><span class="STYLE5"><font size="2">小计</font></span></td>
</tr>
<%
if request("submit3")="查询显示" then
qishi="0:00:00"
FirstSelect=nosql(request("FirstSelectYear"))&"-"&nosql(request("FirstSelectMonth"))&"-"&nosql(request("FirstSelectDay"))&" "&qishi
FirstSelecte=nosql(request("FirstSelecteYear"))&"-"&nosql(request("FirstSelecteMonth"))&"-"&nosql(request("FirstSelecteDay"))&" "&qishi
set rs1 = conn.execute("select bh from cart where userid in(select id from user_name where name='"&nosql(session("www.wygk.cn"))&"') and sj between '"&replace(FirstSelect,"'","")&"' and '"&replace(FirstSelecte,"'","")&"' order by id desc")
if rs1.eof then
Response.Write("<p align=center><br>该查询条件下无记录</p>")
end if
do while not rs1.eof
Set s= Server.CreateObject("abodb.recordset")
set rs = conn.execute("select * from list where bh='"&rs1("bh")&"' order by id desc")
do while not rs.eof
zs = zs + rs("sl")
zj = zj + csng(rs("jg2")) * rs("sl")
%>
<tr valign="middle" bgcolor="#FFFFFF">
<td width="100" height="20" align="center" bgcolor="#E8F1FF"><%=rs1("bh")%></td>
<td height="20" bgcolor="#E8F1FF"><%=rs("mc")%></td>
<td width="75" height="20" align="center" bgcolor="#E8F1FF"><%=rs("jg2")%></td>
<td width="75" height="20" align="center" bgcolor="#E8F1FF"><%=rs("sl")%></td>
<td width="100" height="20" align="center" bgcolor="#E8F1FF"><%=rs("jg2")*rs("sl")%></td>
</tr>
<%rs.movenext
loop
rs.close
rs1.movenext
loop
rs1.close
Response.Write("<tr align=right valign=middle bgcolor=#FFFFFF><td height=20 colspan=5>本查询日期阶段共销售:"&zs&"件产品，销售总额:"&zj&"元 </td></tr>")
end if%>
</table>
<br><br>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -