history_count_detail_select.asp

1。超强文件读写锁定

<%'创建时间:2004/07/13
'创建人:
'功能:用于代理统计详细资料显示
'2004-07-22加多一个和局判断

%>
<!--#include file="Include/conn.asp"-->
<!--#include file="Include/Islogin.asp"-->
<% 
issue=request.querystring("issue")
second1=request.querystring("second")
type1=cstr(request.QueryString("type1"))
 set Count_rs=server.createobject("adodb.recordset")
 
select case type1
case ""
count_sql="select invest_name,in_money=sum(invest_money),fei_result=sum(i.fei_result),mem_result=sum(mem_result) ,fac_money=sum(i.fac_money) from (select invest_money,fac_money=invest_money*(1-invest_feico) ,mem_result=case when invest_result=1 then (invest_money*invest_rate-invest_money*(1-invest_feico))when invest_result=0 then -(invest_money*(1-invest_feico)) end ,fei_result=case when invest_result=1 then -(invest_money*invest_rate*invest_feizc-(invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc)))when invest_result=0 then invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc) end ,invest_name from invest where invest_second='"&second1&"' and invest_banlance=1 and invest_issue="&issue&" and invest_amount is null  union all SELECT Invest_money, fac_money = (CASE WHEN invest_type <> 4 THEN invest_money * (1 - invest_feico) WHEN invest_type = 4 THEN invest_money * invest_zs * (1 - invest_feico) END),  mem_result = CASE WHEN invest_type <> 4 THEN (CASE WHEN invest_result = 0 THEN - (invest_money * (1 - invest_feico)) WHEN invest_result = 1 THEN invest_money * invest_rate1 - invest_money * (1 - invest_feico) END) WHEN invest_type = 4 THEN (CASE WHEN invest_result = 0 THEN - (invest_money * (1 - invest_feico) * invest_zs) WHEN invest_result = 1 THEN invest_money * win_thow * invest_rate1 + invest_money * win_zhow * invest_rate2 - invest_money * invest_zs * (1 - invest_feico) END) END, fei_result = CASE WHEN invest_type <> 4 THEN (CASE WHEN invest_result =0 THEN invest_money * invest_agzc + invest_money * invest_mazc * invest_maco - invest_money * invest_agco * (invest_mazc + invest_agzc) WHEN invest_result = 1 THEN - (invest_money * invest_rate1 * invest_agzc - (invest_money * invest_agzc + invest_money * invest_mazc * invest_maco - invest_money * invest_agco * (invest_mazc + invest_agzc))) END) WHEN invest_type = 4 THEN (CASE WHEN invest_result = 0 THEN invest_money * invest_agzc + invest_money * invest_mazc * invest_maco - invest_money * invest_agco        * (invest_mazc + invest_agzc) WHEN invest_result = 1 THEN - ((invest_money * win_thow * invest_rate1 * invest_agzc + invest_money * win_zhow * invest_rate2 * invest_agzc) - (invest_money * invest_zs * invest_agzc + invest_money * invest_zs * invest_mazc * invest_maco - invest_money * invest_zs * invest_agco * (invest_mazc + invest_agzc))) END) END, Invest_name FROM Invest_l WHERE (Invest_issue ="&issue&") AND (invest_second='"&second1&"') AND (Invest_banlance = 1) AND (Invest_amount IS NULL) ) i group by invest_name "

case "1"
Count_sql="select invest_name,in_money=sum(invest_money),fei_result=sum(i.fei_result),mem_result=sum(mem_result) ,fac_money=sum(i.fac_money) from (select fac_money=invest_money*(1-invest_feico) ,mem_result=case when invest_result=1 then (invest_money*invest_rate-invest_money*(1-invest_feico)) when invest_result=0 then -(invest_money*(1-invest_feico)) end ,fei_result=case when invest_result=1 then -(invest_money*invest_rate*invest_feizc-(invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc)))when invest_result=0 then invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc) end ,invest_money,invest_name from invest where invest_second='"&second1&"' and invest_banlance=1 and invest_type="&type1&" and invest_issue="&issue&" and invest_amount is null ) i  group by invest_name"
case "2"
Count_sql="select invest_name,in_money=sum(invest_money),fei_result=sum(i.fei_result),mem_result=sum(mem_result) ,fac_money=sum(i.fac_money) from (select fac_money=invest_money*(1-invest_feico) ,mem_result=case when invest_result=1 then (invest_money*invest_rate-invest_money*(1-invest_feico)) when invest_result=0 then -(invest_money*(1-invest_feico)) end ,fei_result=case when invest_result=1 then -(invest_money*invest_rate*invest_feizc-(invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc)))when invest_result=0 then invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc) end ,invest_money,invest_name from invest where invest_second='"&second1&"' and invest_banlance=1 and invest_type="&type1&" and invest_issue="&issue&" and invest_amount is null ) i  group by invest_name"
case "3"
Count_sql="select invest_name,in_money=sum(invest_money),fei_result=sum(i.fei_result),mem_result=sum(mem_result) ,fac_money=sum(i.fac_money) from (select fac_money=invest_money*(1-invest_feico) ,mem_result=case when invest_result=1 then (invest_money*invest_rate-invest_money*(1-invest_feico)) when invest_result=0 then -(invest_money*(1-invest_feico)) end ,fei_result=case when invest_result=1 then -(invest_money*invest_rate*invest_feizc-(invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc)))when invest_result=0 then invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc) end ,invest_money,invest_name from invest where invest_second='"&second1&"' and invest_banlance=1 and invest_type="&type1&" and invest_issue="&issue&" and invest_amount is null ) i  group by invest_name"
case "4"
 count_sql="select invest_name,in_money=sum(invest_money),fei_result=sum(i.fei_result),mem_result=sum(mem_result) ,fac_money=sum(i.fac_money) from(select fac_money=invest_money*invest_zs*(1-invest_feico) , mem_result=invest_money*win_thow*invest_rate1+invest_money*win_zhow*invest_rate2-(invest_money*invest_zs*(1-invest_feico)),fei_result=-(invest_money*win_thow*invest_rate1*invest_feizc+invest_money*win_zhow*invest_rate2*invest_feizc-(invest_money*invest_zs*invest_feizc-invest_money*invest_zs*invest_feico+invest_money*invest_zs*invest_agco*(invest_agzc+invest_mazc))),invest_money=invest_money*invest_zs,invest_name from invest_l where invest_second='"&second1&"' and invest_banlance=1 and invest_issue="&issue&"and invest_type="&type1&") i group by invest_name "
case "5"
Count_sql="select invest_name,in_money=sum(invest_money),fei_result=sum(i.fei_result),mem_result=sum(mem_result) ,fac_money=sum(i.fac_money) from (select fac_money=invest_money*(1-invest_feico) ,mem_result=case when invest_result=1 then (invest_money*invest_rate-invest_money*(1-invest_feico)) when invest_result=0 then -(invest_money*(1-invest_feico)) end ,fei_result=case when invest_result=1 then -(invest_money*invest_rate*invest_feizc-(invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc)))when invest_result=0 then invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc) end ,invest_money,invest_name from invest where invest_second='"&second1&"' and invest_banlance=1 and invest_type="&type1&" and invest_issue="&issue&" and invest_amount is null ) i  group by invest_name"
case "6"
Count_sql="select invest_name,in_money=sum(invest_money),fei_result=sum(i.fei_result),mem_result=sum(mem_result) ,fac_money=sum(i.fac_money) from (select fac_money=invest_money*(1-invest_feico) ,mem_result=case when invest_result=1 then (invest_money*invest_rate1-invest_money*(1-invest_feico)) when invest_result=0 then -(invest_money*(1-invest_feico)) end ,fei_result=case when invest_result=1 then -(invest_money*invest_rate1*invest_feizc-(invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc)))when invest_result=0 then invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc) end ,invest_money,invest_name from invest_l where invest_second='"&second1&"' and invest_banlance=1 and invest_type="&type1&" and invest_issue="&issue&"  ) i  group by invest_name"
case "8"
Count_sql="select invest_name,in_money=sum(invest_money),fei_result=sum(i.fei_result),mem_result=sum(mem_result) ,fac_money=sum(i.fac_money) from (select fac_money=invest_money*(1-invest_feico) ,mem_result=case when invest_result=1 then (invest_money*invest_rate1-invest_money*(1-invest_feico)) when invest_result=0 then -(invest_money*(1-invest_feico)) end ,fei_result=case when invest_result=1 then -(invest_money*invest_rate1*invest_feizc-(invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc)))when invest_result=0 then invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc) end ,invest_money,invest_name from invest_l where invest_second='"&second1&"' and invest_banlance=1 and invest_type="&type1&" and invest_issue="&issue&"  ) i  group by invest_name"
case "7"
Count_sql="select invest_name,in_money=sum(invest_money),fei_result=sum(i.fei_result),mem_result=sum(mem_result) ,fac_money=sum(i.fac_money) from (select fac_money=invest_money*(1-invest_feico) ,mem_result=case when invest_result=1 then (invest_money*invest_rate1-invest_money*(1-invest_feico)) when invest_result=0 then -(invest_money*(1-invest_feico)) end ,fei_result=case when invest_result=1 then -(invest_money*invest_rate1*invest_feizc-(invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc)))when invest_result=0 then invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc) end ,invest_money,invest_name from invest_l where invest_second='"&second1&"' and invest_banlance=1 and invest_type="&type1&" and invest_issue="&issue&"  ) i  group by invest_name"
case "9"
Count_sql="select invest_name,in_money=sum(invest_money),fei_result=sum(i.fei_result),mem_result=sum(mem_result) ,fac_money=sum(i.fac_money) from (select fac_money=invest_money*(1-invest_feico) ,mem_result=case when invest_result=1 then (invest_money*invest_rate1-invest_money*(1-invest_feico)) when invest_result=0 then -(invest_money*(1-invest_feico)) end ,fei_result=case when invest_result=1 then -(invest_money*invest_rate1*invest_feizc-(invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc)))when invest_result=0 then invest_money*invest_feizc-invest_money*invest_feico+invest_money*invest_agco*(invest_agzc+invest_mazc) end ,invest_money,invest_name from invest_l where invest_second='"&second1&"' and invest_banlance=1 and invest_type="&type1&" and invest_issue="&issue&"  ) i  group by invest_name"


end select
'response.write count_sql
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> 第<%=issue%>期账户历史