⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 report_class.asp

📁 1。超强文件读写锁定
💻 ASP
📖 第 1 页 / 共 3 页
字号:
🔍
123 
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "6"
show_wtype="正码"%>
  <TR class=m_rig>
    <TD align=middle>正码</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=6&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "7"
show_wtype="总和:单双"%>
  <TR class=m_rig>
    <TD align=middle>总和:单双</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=7&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "8"
show_wtype="总和:大小"%>
  <TR class=m_rig>
    <TD align=middle>总和:大小</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=8&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "9"
show_wtype="正码1-6:单双"%>
  <TR class=m_rig>
    <TD align=middle>正码1-6:单双</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=9&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "10"
show_wtype="正码1-6:大小"%>
  <TR class=m_rig>
    <TD align=middle>正码1-6:大小</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=10&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "11"
show_wtype="正码1-6:色波"%>
  <TR class=m_rig>
    <TD align=middle>正码1-6:色波</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=11amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "12"
show_wtype="三全中"%>
  <TR class=m_rig>
    <TD align=middle>三全中</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=12&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "13"
show_wtype="三中二"%>
  <TR class=m_rig>
    <TD align=middle>三中二</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=13&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "14"
show_wtype="二全中"%>
  <TR class=m_rig>

    <TD align=middle>二全中</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=14&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "15"
show_wtype="二中特"%>
  <TR class=m_rig>
    <TD align=middle>二中特</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=15&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "16"
show_wtype="特串"%>
  <TR class=m_rig>
    <TD align=middle>特串</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=16&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "17"
show_wtype="正码过关"%>
  <TR class=m_rig>
    <TD align=middle>正码过关</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=17&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "18"
show_wtype="生肖"%>
  <TR class=m_rig>
    <TD align=middle>生肖</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=18&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "19"
show_wtype="一肖"%>
  <TR class=m_rig>
    <TD align=middle>一肖</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=19&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case "20"
show_wtype="特码补牌"%>
  <TR class=m_rig>
    <TD align=middle>特码补牌</TD>
    <TD><%=Showmember_detail(5,0)%></TD>
    <TD><a  href="report_game.asp?wtype=20&amp;pay_type=<%=request("pay_type")%>&amp;bet_type=<%=request("bet_type")%>&amp;DATE_START=<%=request("DATE_START")%>&amp;DATE_END=<%=request("DATE_END")%>"><%=replace(formatnumber(Showmember_detail(0,0),2,-1),",","")%></A></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(2,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(3,0),2,-1),",","")%></TD>
    <TD><%=replace(formatnumber(Showmember_detail(1,0)+Showmember_detail(4,0),2,-1),",","")%></TD>
    <TD>&nbsp;</TD></TR>
<%
case else
'show_wtype="全部"
coun_num=0
	 mem_result=0
	 mem_ds=0
	 ag_ds=0
	 zong_ds=0
	 sum_money=0
for k=1 to 20%>
<%SQL6="SELECT sum_m = isnull(SUM(sum_m), 0), mem_result = isnull(SUM(mem_result), 0),mem_ds = isnull(SUM(mem_ds), 0), ag_ds = isnull(SUM(ag_ds), 0),zong_ds = isnull(SUM(zong_ds), 0), re = COUNT(*) FROM (SELECT sum_m,mem_ds = CASE WHEN banlance = 0 or amount='和局' THEN 0 ELSE sum_m * rake / 100 END, mem_result = CASE WHEN banlance = 0 or amount='和局' THEN 0 ELSE CASE WHEN result = 0 THEN - sum_m WHEN result > 0 THEN (CASE WHEN sort = '连码' THEN sum_m / count_l* rate * result - sum_m ELSE sum_m * (rate - 1) END) END END, ag_ds = CASE WHEN banlance = 0 or amount='和局' THEN 0 ELSE sum_m * dai_ds / 100 END, zong_ds = CASE WHEN banlance = 0 or amount='和局' THEN 0 ELSE sum_m * zong_ds / 100 END FROM m_chilp WHERE chilp_time >='"&date_start&"' and chilp_time <='"&date_end&"' "
	'if session("SK2F")<>"0" then
	'SQL6=SQL6&" Agent_first = '"&session("SK2B")&"'"
	'else
	'SQL6=SQL6&" Agent_second = '"&session("SK2B")&"'"
	'end if
select case trim(cstr(k))
case "1"
SQL6=SQL6&" and sort = '特别号' and chilp_value<>'单' and chilp_value<>'双' and chilp_value<>'大' and chilp_value<>'小' and chilp_value<>'合单' and chilp_value<>'合双'"
'show_wtype="特别号"
case "2"
SQL6=SQL6&" and sort = '正码' and chilp_value<>'总单' and chilp_value<>'总双' and chilp_value<>'总大' and chilp_value<>'总小'"
'show_wtype="正码"
case "3"
SQL6=SQL6&" and sort = '正码过关'"
'show_wtype="正码过关"
case "4"
SQL6=SQL6&" and sort = '特别号' and (chilp_value='单' or chilp_value='双')"
'show_wtype="特别号:单双"
case "5"
SQL6=SQL6&" and sort = '特别号' and (chilp_value='大' or chilp_value='小')"
'show_wtype="特别号:大小"
case "6"
'show_wtype="色波"
SQL6=SQL6&" and sort = '色波'"
case "7"
SQL6=SQL6&" and (chilp_value = '总单' or chilp_value = '总双')"
'show_wtype="总和:单双"
case "8"
SQL6=SQL6&" and (chilp_value = '总大' or chilp_value = '总小')"
'show_wtype="总和:大小"
case "9"
SQL6=SQL6&" and chilp_types = '三全中'"
'show_wtype="三全中"
case "10"
SQL6=SQL6&" and chilp_types = '三中二'"
'show_wtype="三中二"
case "11"
SQL6=SQL6&" and chilp_types = '二全中'"
'show_wtype="二全中"
case "12"
SQL6=SQL6&" and chilp_types = '二中特'"
'show_wtype="二中特"
case "13"
SQL6=SQL6&" and chilp_types = '特串'"
'show_wtype="特串"
case "14"
SQL6=SQL6&" and sort = '十二生肖'"
'show_wtype="生肖"
case "15"
SQL6=SQL6&" and sort = '正码1-6' and (chilp_value='单' or chilp_value='双')"
'show_wtype="正码1-6:单双"
case "16"
SQL6=SQL6&" and sort = '正码1-6' and (chilp_value='大' or chilp_value='小')"
'show_wtype="正码1-6:大小"
case "17"
SQL6=SQL6&" and sort = '正码1-6' and (chilp_value='红波' or chilp_value='绿波' or chilp_value='蓝波')"
'show_wtype="正码1-6:色波"
case "18"
SQL6=SQL6&" and sort = '特别号' and (chilp_value='合单' or chilp_value='合双')"
'show_wtype="特别号:合数单双"
case "19"
SQL6=SQL6&" and sort = '一肖'"
'show_wtype="一肖"
case "20"
SQL6=SQL6&" and sort = '特码补牌'"
'show_wtype="特码补牌"
case else
'show_wtype="全部"
end select
	SQL6=SQL6&" ) i "
	'response.write SQL6
	Set Rs6=Conn.Execute(SQL6)
	If Not Rs6.Eof and Rs6("re")>0 Then
     Showmember_detail=Rs6.GetRows(-1)
123

⌨️ 快捷键说明

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