?? show1.asp
字號:
<%
session("sql")=""
if request("opstatus")="query" then
if request("start_time")<>"" and request("end_time")<>"" then
sqlwhere=" where selldate between '"&request("start_time")&"' and '"&request("end_time")&"'"
end if
sql="select "
select case request("S_time")
case 0
sql=sql&"YEAR(SellDate) AS selldate, SUM(Sellmoney) AS totalmoney, SUM(SellProductnum) AS totalnum FROM Sell"
sql=sql& sqlwhere
sql=sql&" GROUP BY YEAR(SellDate)"
case 1
sql=sql&" RTRIM(YEAR(SellDate)) + '-' + RTRIM(MONTH(SellDate)) AS selldate, SUM(Sellmoney) AS totalmoney, SUM(SellProductnum) AS totalnum, CONVERT(datetime, RTRIM(YEAR(SellDate)) + '-' + RTRIM(MONTH(SellDate)) + '-1') AS selloder from sell"
sql=sql& sqlwhere
sql=sql&" GROUP BY RTRIM(YEAR(SellDate)) + '-' + RTRIM(MONTH(SellDate)), CONVERT(datetime, RTRIM(YEAR(SellDate)) + '-' + RTRIM(MONTH(SellDate)) + '-1') ORDER BY selloder"
case 2
sql=sql&" SellDate, SUM(Sellmoney) AS totalmoney, SUM(SellProductnum) AS totalnum FROM Sell"
sql=sql& sqlwhere
sql=sql&" GROUP BY SellDate"
end select
else
sql="select "
sql=sql&" RTRIM(YEAR(SellDate)) + '-' + RTRIM(MONTH(SellDate)) AS selldate, SUM(Sellmoney) AS totalmoney, SUM(SellProductnum) AS totalnum, CONVERT(datetime, RTRIM(YEAR(SellDate)) + '-' + RTRIM(MONTH(SellDate)) + '-1') AS selloder from sell"
sql=sql&" GROUP BY RTRIM(YEAR(SellDate)) + '-' + RTRIM(MONTH(SellDate)), CONVERT(datetime, RTRIM(YEAR(SellDate)) + '-' + RTRIM(MONTH(SellDate)) + '-1') ORDER BY selloder"
end if
session("sql")=sql
%>
<script language="JavaScript">
childwin=open("print.asp","","location=no,menubar=0,status=no,scrollbars,titlebar=no,resizable=1,toolbar=no,width=1024,height=420,top=0,left=0");
</script>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -