<%@ Page Language="C#" AutoEventWireup="true"  CodeBehind="agentincomereport.aspx.cs" Inherits="AgentManager.admin.agentincomereport" %>

      <link rel="stylesheet" href="css/bootstrap/css/bootstrap.min.css"/>
      <link rel="stylesheet" href="css/AdminLTE.css" />
      <link rel="stylesheet" href="css/plugins/iCheck/flat/blue.css"/> 

<script src="js/jquery-1.9.1.min.js"></script>
<script src="css/bootstrap/js/bootstrap.min.js"></script>
<script src="css/My97DatePicker/WdatePicker.js"></script>
<script src="js/mainData.js"></script>
     <div class="content-wrapper">
       
<section class="content-header">
    <h1>
    流水报表
    <small></small>
    </h1>
   
</section>
         
         <form action="agentincomereport.aspx" method="post">


            


 <div class="col-md-6">




              <table class="table">



                  <tr>
<%--                      <td><label>账号</label></td>
                       <td>
       <input  name="username" id="username"  maxlength="15" autocomplete="off"   value="<%=username %>" class="form-control" list="a"/>

<datalist id="a"> 
  

                          <%foreach (var item in li)
                              {
                                

                                  %>

                              <option value="<%=item.Username %>"><%=item.Myname  %></option>

                          <%

                              } %>
</datalist>
                  

                       </td>--%>



                      <td><label>时间范围</label></td>
                    <td colspan="2">
                        <div class="btn-group">
                          <button type="button" class="btn btn-default" onclick="setAutoTime('1','starttime','endtime')">最近3天</button>
                          <button type="button" class="btn btn-default" onclick="setAutoTime('2','starttime','endtime')">最近7天</button>
                          <button type="button" class="btn btn-default" onclick="setAutoTime('3','starttime','endtime')">最近30天</button>
                        </div>
                    </td>
                  </tr>
                  <tr>
                      <td><label>开始时间</label></td>
                      <td><input name="starttime" type="text" id="starttime" maxlength="10" autocomplete="off" value="<%=start %>" class="form-control" onclick="WdatePicker()" /></td>
                      <td><label>结束时间</label></td>
                      <td><input name="endtime" type="text" id="endtime" maxlength="10" autocomplete="off" value="<%=end %>" class="form-control" onclick="WdatePicker()" /></td>
                      <td><input type="submit" name="Submit" value="搜索" class="btn btn-block btn-primary"/></td>
                  </tr>
              </table>
        </div>
         </form>
<section class="content">

<div id="mainbox">
<form id="form1" name="form1" method="post">

     <table class="box">
  <tr>
    <td rowspan="2"><strong>帐号</strong></td>
    <td rowspan="2"><strong>姓名</strong></td>
    <td rowspan="2"><strong>总下注次数</strong></td>
    <td rowspan="2"><strong>总反水</strong></td>
    <td colspan="8"><strong>投注总金额</strong></td>
    <td colspan="8"><strong>输赢总金额</strong></td>
    <td colspan="8"><strong>有效投注总金额</strong></td>
    <td  rowspan="2"><strong>时间范围</strong></td>
     
    </tr>
    <tr>
        <td  style="background-color: #367fa9;color:#fff;">真人</td>
        <td  style="background-color: #367fa9;color:#fff;">电子</td>
        <td  style="background-color: #367fa9;color:#fff;">体育</td>
        <td  style="background-color: #367fa9;color:#fff;">捕鱼</td>
        <td  style="background-color: #367fa9;color:#fff;">棋牌</td>
        <td  style="background-color: #367fa9;color:#fff;">彩票</td>
        <td  style="background-color: #367fa9;color:#fff;">六合彩</td> 
        <td  style="background-color: #367fa9;color:#fff;">总和</td> 
       
        <td  style="background-color: #367fa9;color:#fff;">真人</td>
        <td  style="background-color: #367fa9;color:#fff;">电子</td>
        <td  style="background-color: #367fa9;color:#fff;">体育</td>
        <td  style="background-color: #367fa9;color:#fff;">捕鱼</td>
        <td  style="background-color: #367fa9;color:#fff;">棋牌</td>
        <td  style="background-color: #367fa9;color:#fff;">彩票</td>
        <td  style="background-color: #367fa9;color:#fff;">六合彩</td> 
       <td  style="background-color: #367fa9;color:#fff;">总和</td> 

        <td  style="background-color: #367fa9;color:#fff;">真人</td>
        <td  style="background-color: #367fa9;color:#fff;">电子</td>
        <td  style="background-color: #367fa9;color:#fff;">体育</td>
        <td  style="background-color: #367fa9;color:#fff;">捕鱼</td>
        <td  style="background-color: #367fa9;color:#fff;">棋牌</td>
        <td  style="background-color: #367fa9;color:#fff;">彩票</td>
        <td  style="background-color: #367fa9;color:#fff;">六合彩</td> 
       <td  style="background-color: #367fa9;color:#fff;">总和</td> 

       
        
        </tr>
         <%foreach (var item in li1)
             {%>
         <tr>
             <td><strong><%=item.username %></strong></td>
             <td><strong><%=item.myname %></strong></td>
             <td><strong><%=item.betcount %></strong></td>
             <td><strong><%=GetZFS(item.username) %></strong></td>

             <td><strong><%=item.zrbetsum %></strong></td>
             <td><strong><%=item.dzbetsum %></strong></td>
             <td><strong><%=item.tybetsum %></strong></td>
             <td><strong><%=item.bybetsum %></strong></td>
             <td><strong><%=item.qpbetsum %></strong></td>
             <td><strong><%=item.cpbetsum %></strong></td>
             <td><strong><%=item.lhcbetsum %></strong></td>
             <td  style="color:red"><strong><%=item.zrbetsum+item.dzbetsum+item.tybetsum+item.bybetsum+item.qpbetsum+item.cpbetsum+item.lhcbetsum %></strong></td>   
             
             <td><strong><%=item.zrwinsum %></strong></td>
             <td><strong><%=item.dzwinsum %></strong></td>
             <td><strong><%=item.tywinsum %></strong></td>
             <td><strong><%=item.bywinsum %></strong></td>
             <td><strong><%=item.qpwinsum %></strong></td>
             <td><strong><%=item.cpwinsum %></strong></td>
             <td><strong><%=item.lhcwinsum %></strong></td>
             <td  style="color:red"><strong><%=item.zrwinsum+item.dzwinsum+item.tywinsum+item.bywinsum+item.qpwinsum+item.cpwinsum+item.lhcwinsum %></strong></td>           
             
             <td><strong><%=item.zrvalisum %></strong></td>
             <td><strong><%=item.dzvalisum %></strong></td>
             <td><strong><%=item.tyvalisum %></strong></td>
             <td><strong><%=item.byvalisum %></strong></td>
             <td><strong><%=item.qpvalisum %></strong></td>
             <td><strong><%=item.cpvalisum %></strong></td>
             <td><strong><%=item.lhcvalisum %></strong></td>
             <td style="color:red"><strong> <%=item.zrvalisum+item.dzvalisum+item.tyvalisum+item.byvalisum+item.qpvalisum+item.cpvalisum+item.lhcvalisum %></strong></td>

             <td><strong><%=start %>至<%=end %></strong></td>

         </tr>
         
         
         <%

             } %>

         <tr>
             <td  style="color:red"><strong>总和</strong></td>
             <td  style="color:red"><strong>-</strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>Convert.ToInt32(u.betcount)) %></strong></td>
             <td  style="color:red"><strong><%=SumZFS %></strong></td>

             <td  style="color:red"><strong><%=li1.Sum(u=>u.zrbetsum) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.dzbetsum) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.tybetsum ) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.bybetsum ) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.qpbetsum) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.cpbetsum) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.lhcbetsum) %></strong></td>

             <td  style="color:red"><strong><%= li1.Sum(u=>u.zrbetsum)+li1.Sum(u=>u.dzbetsum)+li1.Sum(u=>u.tybetsum)+li1.Sum(u=>u.bybetsum)+li1.Sum(u=>u.qpbetsum)+li1.Sum(u=>u.cpbetsum)+li1.Sum(u=>u.lhcbetsum) %></strong></td>
             
             <td  style="color:red"><strong><%=li1.Sum(u=>u.zrwinsum) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.dzwinsum) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.tywinsum ) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.bywinsum ) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.qpwinsum) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.cpwinsum) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.lhcwinsum) %></strong></td>

             <td  style="color:red"><strong><%= li1.Sum(u=>u.zrwinsum)+li1.Sum(u=>u.dzwinsum)+li1.Sum(u=>u.tywinsum)+li1.Sum(u=>u.bywinsum)+li1.Sum(u=>u.qpwinsum)+li1.Sum(u=>u.cpwinsum)+li1.Sum(u=>u.lhcwinsum) %></strong></td>
              
             <td  style="color:red"><strong><%=li1.Sum(u=>u.zrvalisum) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.dzvalisum) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.tyvalisum ) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.byvalisum ) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.qpvalisum) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.cpvalisum) %></strong></td>
             <td  style="color:red"><strong><%=li1.Sum(u=>u.lhcvalisum) %></strong></td>

             <td  style="color:red"><strong><%= li1.Sum(u=>u.zrvalisum)+li1.Sum(u=>u.dzvalisum)+li1.Sum(u=>u.tyvalisum)+li1.Sum(u=>u.byvalisum)+li1.Sum(u=>u.qpvalisum)+li1.Sum(u=>u.cpvalisum)+li1.Sum(u=>u.lhcvalisum) %></strong></td>

             <td><strong><%=start %>至<%=end %></strong></td>
       

         </tr>
         </table>
    <br />
    <div>
        <b>您的盈利：<b style="color:red"><%=Convert.ToDecimal(Convert.ToDecimal(winsum)<0?Convert.ToDecimal(winsum)*-1:Convert.ToDecimal(winsum)) %></b></b><br />
        <b>您的盈利计算公式：<b style="color:red"><%=wintext %></b></b>

    </div>
</form>

</div>

</section>



</div>
<script>


</script>





