📄 money50.asp

📁 mlm双轨制直销系统V8.0免费版可用于： 1、直拨、回拨电话卡公司。 2、保健品、药品公司。 3、在线销售商品等等。 4、其他类型用到双轨制模式的线上开盘公司。
💻 ASP
字号:
<!-- #include file="include/adovbs.inc" -->
<!-- #include file="include/dataconn.asp" -->
<!-- #include file="include/checksession.asp" -->
<!-- #include file="common.asp" -->
<%
Response.Buffer =false
Response.Expires=-1
'thistoday =year(now)&"-"&month(now)&"-"&day(now)

 dtfrom=trim(request("dtfrom"))
 dtto=trim(request("dtto"))
 if len(dtfrom)=0 then
 	dtfrom=year(now)&"-"& mm &"-01"
 end if
  if len(dtto)=0 then
 	dtto=thistoday
 end if

set HyRs=server.CreateObject("adodb.recordset")
sql = "SELECT  HyNumber,sum(AllMoney) as MoneyCount FROM HyMoneyLog"
sql =sql & " where computetime>='"&dtfrom&"' and computetime<='"&dtto&"'"
sql =sql & " group by HyNumber  order by sum(AllMoney) desc"
	HyRs.Open sql,conn
	j=HyRs.RecordCount 
%>
<html>
<head>
<meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<link rel="stylesheet" href="include/e1.css" type="text/css">
<script>
	function fPopUpCalendarDlg(ctrlobj)
	{
		showx = event.screenX - event.offsetX - 4 - 210 ; // + deltaX;
		showy = event.screenY - event.offsetY + 18; // + deltaY;
		newWINwidth = 210 + 4 + 18;

		retval = window.showModalDialog("Include/CalendarDlg.htm", "", "dialogWidth:197px; dialogHeight:210px; dialogLeft:"+showx+"px; dialogTop:"+showy+"px; status:no; directories:yes;scrollbars:no;Resizable=no; "  );
		if( retval != null ){
			ctrlobj.value = retval;
		}else{
			//alert("canceled");
		}
	}
</script>
</head>
<body leftmargin="10" topmargin="10" marginwidth="0" marginheight="0">

<form method="post" action="Money50.asp" id="form1" name="form1">
  <table width="100%" border="0" height="21" cellpadding="0" cellspacing="0">
    <tr> 
      <td width="76%"> <div align="center"><font color="#FFFFFF"><font color="#000000">从</font></font> 
          <input id="dtfrom" name="dtfrom" readonly value="<% =dtfrom %>" size="12">
          <img src="image/datetime.gif" style="cursor:hand;" align="absmiddle" alt="弹出日历下拉菜单" onClick="fPopUpCalendarDlg(document.form1.dtfrom);return false" width="16"> 
          到 
          <input id="dtto" name="dtto" readonly value="<% =dtto %>" size="12">
          <img src="image/datetime.gif" style="cursor:hand;" align="absmiddle" alt="弹出日历下拉菜单" onClick="fPopUpCalendarDlg(document.form1.dtto);return false" width="16"> 
          &nbsp; 
          <input type="image" value="submit" src="Image/027.gif" id="image1" name="image1">
          &nbsp;</div></td>
      <td width="24%"><a href="ExportMoney50.asp?dtfrom=<%=dtfrom%>&dtto=<%=dtto%>"><img src="Image/l1.gif" width="13" height="11" border="0">导出到Excel</a></td>
    </tr>
  </table>
  </form>
<%
    if j>0 then
    dim i 
    i=1
    const pagesize=100
           
    HyRs.PageSize = pagesize
    total=HyRs.PageCount 
	pageno=Request("pageno")
	if pageno="" then pageno=1
    if not isnumeric(pageno) and pageno<>"" then
	 %>
<script>alert("请输入正确的页码");
		window.history.back();</script>
<%Response.End
	End if
	if (pageno-1)*pagesize>=j then
        if (j mod pagesize)=0 then
            pageno= j \ pagesize
        else
            pageno= j \ pagesize + 1
       end if
    end if		
	if pageno<1 then 
	 %>
<script>alert("页码数不能小于１");
		window.history.back();</script>
<%Response.End
	End if	
	if (pageno>65535) then
	%>
<script>alert("页码数不能大于总数！");
		window.history.back();</script>
<%Response.End 
	end if
	
	
	if (clng(pageno)>clng(total)) then %>
<script>alert("页码数不能大于总数！");
		window.history.back();</script>
<%	
   Response.End 
	end if
    pageno=cint(pageno)	
%>

  


<table border="1" cellpadding="0" cellspacing="0" width="98%" bordercolordark="#e0f4ff" bordercolorlight="#162d6b">
  <tr class="td3"> 
    <td width="4%"> <div align="center"><font color="#FFFFFF">序号</font></div></td>
    <td width="6%"> <div align="center"><font color="#FFFFFF">姓名</font></div></td>
    <td width="6%"> <div align="center"><font color="#FFFFFF">会员编号</font></div></td>
    <td width="8%"> <div align="center"><font color="#FFFFFF">当月奖金</font></div></td>
  </tr>
  <%
    HyRs.absolutepage=pageno     
    dim x
	i=1
    x=2
    while (not HyRs.eof) and (i<=pagesize) 
      if x mod 2 then
 %>
  <tr class="td1"> 
    <%
 else
 %>
  <tr height="25"> 
    <%
 end if
 %>
    <td> <div align="center"> 
        <% =i%>
      </div></td>
    <td><div align="center">
        <%=GetNameByNumber(HyRs("HyNumber"))%>&nbsp;&nbsp;</div></td>
    <td><div align="center"><%=HyRs("HyNumber")%>&nbsp;</div></td>
    <td> <div align="center"> 
        <% =HyRs("MoneyCount")%>
        &nbsp;</div></td>
    <%
	HyRs.movenext
	i=i+1
	x=x+1
	wend %>
  </tr>
  <%
  else
	Response.Write "奖金还没有计算！<a href='javascript:history.back()'>返回</a>"
 end if%>
</table>
<p></p>
<%if j>0 then%>
<table align="center">
  <tr> 
    <form name="thisform1" method="Post" action="Money50.asp?findcontent=<%=content%>">
      <td>到第 
        <input type="text" name="pageno" value="<% =pageno%>" size="3">
        页<a onclick="javascript:thisform1.submit();">GO</a> </font></td>
    </form>
    <td>第 
      <% =pageno %>页
      /共 
      <% =total%>
      页</font></td>
    <% if pageno<=1 then %>
    <td><font color="#cccccc">首页</font></td>
    <td><font color="#cccccc">上一页</font></td>
    <% else %>
    <td><a href="Money50.asp?pageno=1&amp;findcontent=<%=content%>"><font face="Webdings" color="#FFFFFF">9</font>首页</font></a></td>
    <td><a href="Money50.asp?pageno=<%=pageno-1%>&amp;findcontent=<%=content%>">上一页</font></a></td>
    <%end if%>
    <% if pageno>=total then %>
    <td><font color="#cccccc">下一页</font></td>
    <td><font color="#cccccc">尾页</font></td>
    <%else%>
    <td><a href="Money50.asp?pageno=<%=pageno+1%>&amp;findcontent=<%=content%>">下一页</font></a></td>
    <td><a href="Money50.asp?pageno=<%=total%>&amp;findcontent=<%=content%>">尾页</font></a></td>
    <% end if%>
    
  </tr>
</table>
<%end if%>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -