📄 a_count_detail.asp

📁 1。超强文件读写锁定
💻 ASP
字号:
<%'创建时间:2004/07/13
'创建人:
'功能:用于代理统计详细资料显示
%>
<!--#include file="Include/conn.asp"-->
<!--#include file="Include/Islogin.asp"-->
<% second1=request.querystring("second")
type1=cstr(request.QueryString("type1"))
 set Count_rs=server.createobject("adodb.recordset")
 '隐藏的是没加连码前的
 'if type1<>"" then
'Count_sql="select Invest_type,a.Invest_name,cs,sm,Invest_rate,invest_feico,Fact_money=sm*(invest_feico)from ( select Invest_type,Invest_name,Invest_feico,Invest_rate,cs=count(Invest_type),sm=sum(Invest_money) from Invest where Invest_second='"&second1&"' and Invest_type='"&type1&"' and Invest_banlance=0   group by  Invest_name,invest_feico,Invest_rate,Invest_type ) a	 order by a.Invest_name"
'response.write Count_sql
'else
'Count_sql="select Invest_type,a.Invest_name,cs,sm,Invest_rate,invest_feico,Fact_money=sm*(invest_feico)from ( select Invest_type,Invest_name,invest_feico,Invest_rate,cs=count(Invest_type),sm=sum(Invest_money) from Invest where Invest_second='"&second1&"' and Invest_banlance=0   group by Invest_name,Invest_rate,Invest_type,invest_feico ) a	 order by a.Invest_name"
'end if
select case type1
case ""
count_sql="select re=count(*), i.invest_name,total=sum(i.total),fact=sum(i.fact)  from (select invest_name,total=(invest_money),fact=(invest_money*(1-invest_feico)) from invest where invest_banlance=0 and invest_issue="&count_issue&" and invest_second='"&second1&"'union all select invest_name,total=(invest_money*invest_zs),fact=(invest_money*invest_zs*(1-invest_feico)) from invest_l where invest_banlance=0 and invest_issue="&count_issue&" and invest_second='"&second1&"') i group by invest_name "
case "1"
Count_sql="select re=count(*),invest_name,total=sum(invest_money),fact=sum(invest_money*(1-invest_feico)),invest_feico from invest where invest_banlance=0 and invest_issue="&count_issue&" and  invest_second='"&second1&"'  and invest_type="&type1&" group by invest_name,invest_feico"
case "2"
Count_sql="select re=count(*),invest_name,total=sum(invest_money),fact=sum(invest_money*(1-invest_feico)),invest_feico from invest where invest_banlance=0 and invest_issue="&count_issue&" and  invest_second='"&second1&"'  and invest_type="&type1&" group by invest_name,invest_feico"
case "3"
Count_sql="select re=count(*),invest_name,total=sum(invest_money),fact=sum(invest_money*(1-invest_feico)),invest_feico from invest where invest_banlance=0 and invest_issue="&count_issue&" and  invest_second='"&second1&"'  and invest_type="&type1&" group by invest_name,invest_feico"
case "4"
count_sql="select re=count(*),invest_name,total=sum(invest_money*invest_zs),fact=sum(invest_money*invest_zs*(1-invest_feico)),invest_feico from invest_l where invest_banlance=0 and invest_issue="&count_issue&" and invest_second='"&second1&"' group by invest_name,invest_feico"
case "5"
Count_sql="select re=count(*),invest_name,total=sum(invest_money),fact=sum(invest_money*(1-invest_feico)),invest_feico from invest where invest_banlance=0 and invest_issue="&count_issue&" and  invest_second='"&second1&"'  and invest_type="&type1&" group by invest_name,invest_feico"
case "6"
Count_sql="select re=count(*),invest_name,total=sum(invest_money),fact=sum(invest_money*(1-invest_feico)),invest_feico from invest_l where invest_banlance=0 and invest_issue="&count_issue&" and  invest_second='"&second1&"'  and invest_type="&type1&" group by invest_name,invest_feico"
case "8"
Count_sql="select re=count(*),invest_name,total=sum(invest_money),fact=sum(invest_money*(1-invest_feico)),invest_feico from invest_l where invest_banlance=0 and invest_issue="&count_issue&" and  invest_second='"&second1&"'  and invest_type="&type1&" group by invest_name,invest_feico"
end select

Count_rs.open Count_sql,conn,1,1

%>


<html>
<head>
<link href="include/css.css" rel="stylesheet" type="text/css">

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.style2 {color: #FF9900}
.style3 {
	color: #FF6600;
	font-weight: bold;
}
a:link {
	color: #FF6600;
	text-decoration: none;
}
a:visited {
	color: #CC9900;
	text-decoration: none;
}
a:hover {
	color: #FF6600;
	text-decoration: none;
}
a:active {
	text-decoration: underline;
}-->
</style>
</head>

<body style="background-color: #F2F2F2">
<table border="1" width="739" cellspacing="0" cellpadding="0" bordercolor="#E0E0E0" style="border-collapse: collapse" height="10%">
  <tr>
    <td width="731" valign="top">
<center>
<table width="96%" border="1" cellspacing="1" bordercolor="#F2F2F2" bordercolorlight="#F2F2F2" bordercolordark="#9D9CA4" height="84">
  <tr align="center" bgcolor="#E5EAEE">
    <td height="20" colspan="6"><span class="style2">
    <a  href="#" onClick="javascript:history.go(-1)"> </a></span>
      <form name="form1" method="post" action="">
        <span class="style2"><a  href="#" onClick="javascript:history.go(-1)">
        <input type="hidden" name="hiddenField">
        <font color="#FF9900">返回 </font> </a> 
        <input name="radio" type="radio" onclick="javascript:self.location.href='A_count_detail.asp?second=<%=second1%>'" <%if type1="" then response.write "checked"%>>
        全部　<input type="radio" name="radio" onclick="javascript:self.location.href='A_count_detail.asp?type1=1&second=<%=second1%>'" <%if type1="1" then response.write "checked"%>>
特码 
<input type="radio" name="radio"  onclick="javascript:self.location.href='A_count_detail.asp?type1=2&second=<%=second1%>'" <%if type1="2" then response.write "checked"%>>
正码 
<input type="radio" name="radio"  onclick="javascript:self.location.href='A_count_detail.asp?type1=3&second=<%=second1%>'" <%if type1="3" then response.write "checked"%>>
两面　<input type="radio" name="radio" onclick="javascript:self.location.href='A_count_detail.asp?type1=5&second=<%=second1%>'" <%if type1="5" then response.write "checked"%>>
波色　<input type="radio" name="radio"  onclick="javascript:self.location.href='A_count_detail.asp?type1=4&second=<%=second1%>'" <%if type1="4" then response.write "checked"%>> 连码</span><font color="#FF9900">
        <input type="radio" name="radiobutton" onclick="javascript:self.location.href='A_count_detail.asp?type1=8&second=<%=second1%>'" <%if type1="8" then response.write "checked"%>>
正码过关  
<input type="radio" name="radiobutton" onclick="javascript:self.location.href='A_count_detail.asp?type1=6&second=<%=second1%>'" <%if type1="6" then response.write "checked"%>> 
生肖 </font>   
      </form></td>
  </tr>
  <tr align="center" bgcolor="#CCCCCC">
    <td width="11%" bgcolor="#BCD5E4" height="20">投注会员</td>
    <td width="12%" bgcolor="#BCD5E4" height="20">投注金额</td>
    <td width="11%" bgcolor="#BCD5E4" height="20">实投</td>
    <%if type1<>"" then%>
    <td width="8%" height="20" bgcolor="#BCD5E4">返水</td>
    <td width="16%" height="20" bgcolor="#BCD5E4">彩金</td>
    <%end if%>
    <td width="13%" bgcolor="#BCD5E4" height="20">期数</td>
  </tr>
   <%
  do while not Count_rs.eof
 %>
  <tr align="center" bgcolor="#f2f2f2">
    <td height="12"><a href="Person_detail.asp?name=<%=Count_rs("Invest_name")%>"><%=Count_rs("Invest_name")%></a></td>
    <td height="12"><%=Count_rs("total")%></td>
    <td height="12"><font color="#ff0000"><%=Count_rs("Fact")%></font></td>
    <%if type1<>"" then%>
    <td height="12"><%=formatnumber(count_rs("invest_feico"),3,-1)%></td>
    <td height="12"><%=Count_rs("total")*count_rs("invest_feico")%></td>
	<% 	end if%>
    <td height="12"><%=count_issue%></td>
  </tr> 
   <%Total=Total+Count_rs("total")
   Fact=Fact+Count_rs("Fact")
   Count_rs.movenext
  loop%>
</table>
</body>
</html>
💿 文件大小 1123 K
👤 上传用户 liubixing
📂 所属分类数据库系统
🏷️ 相关标签

#读写
⌨️ 快捷键说明

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