show1.asp

来自「Activity——活动管理模块 Analyse——分析模块 Client—」· ASP 代码 · 共 35 行

<%
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>