我想在下面加一行合计,把上面几行的数据统计出来,不知道从哪下手...

解决方案 »

  1.   

    怎么发图片阿?,  这样讲看不到效果 ,不是Sql语句那么简单的 ..
      

  2.   

        
     
    销售动态表
    请选择公司: 请选择项目公司 33 gs gs1 请选择项目: 请选择项目名称 xm1 
    工期 总户数 已售户数 总销售款(万元) 应收销售款(万元) 剩余销售款(万元) 已收销售款(万元) 待收销售款(万元) 
    首付款(万元) 徽商银行  
    申报户数 申报金额 待放金额 
     其它银行  
    申报户数 申报金额 待放金额 
     中国工商银行  
    申报户数 申报金额 待放金额 
     中国邮政储蓄银行  
    申报户数 申报金额 待放金额 
     
     未办理  
    户数 金额 
    gq1  32  9  0.0407  0.0002  0.0042  12392.3131  19.9989   1   1212.121    12382.312      0    0   1   70    12382.312   1   12312.312    12382.312  
      0  
    gq2  4  2  0.0004  0  0.0002  11.131  0.0301      0    0   1   0.1    11.111   1   11.111    11.111      0    0  
     1  0.1  
      

  3.   

    blog-》发表文章-》贴图,复制图片地址
      

  4.   

    参见完整的代码
    http://topic.csdn.net/u/20120315/16/2c625f4b-2e6d-433f-9e1e-631dd56fac69.html客户端、服务器端2种实现方法
      

  5.   

    <%@ Page Language="C#" AutoEventWireup="true" CodeFile="DongTai.aspx.cs" Inherits="SDYG_DongTai" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <title>销售动态</title>
        <link href="/css/site_css.css" rel="stylesheet" type="text/css" />
        <style type="text/css">
            .T_table{border:1px solid #000000; border-collapse:collapse;}
            .T_table td{border:1px solid #000000;text-align:center;}
            .T_table1{border:0px; }
            .T_table1 td{border:1px solid #000000;}
        </style>    <script type="text/javascript">
            window.onload = function() {
        }
        </script></head>
    <body>
        <form id="form1" runat="server">
            <div style="text-align: center;">
                <h1>
                    销售动态表</h1>
            </div>
            <div style="padding: 10px;">
                请选择公司:<asp:DropDownList ID="ddlXMCompany" runat="server" OnSelectedIndexChanged="ddlXMCompany_SelectedIndexChanged"
                    AutoPostBack="True">
                </asp:DropDownList>
                请选择项目:<asp:DropDownList ID="ddlXMName" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlXMName_SelectedIndexChanged">
                </asp:DropDownList>
            </div>
            <table border="0" cellpadding="0" cellspacing="0" class="T_table" width="1400">
                <tr height="30">
                    <td rowspan="3" style="width: 30px;">
                        工期</td>
                    <td rowspan="3" style="width: 100px;">
                        总户数</td>
                    <td rowspan="3" style="width: 100px;">
                        已售户数</td>
                    <td rowspan="3" style="width: 100px;">
                        总销售款(万元)</td>
                    <td rowspan="3" style="width: 100px;">
                        应收销售款(万元)</td>
                    <td rowspan="3" style="width: 100px;">
                        剩余销售款(万元)</td>
                    <td rowspan="3" style="width: 100px;">
                        已收销售款(万元)</td>
                    <td colspan="4">
                        待收销售款(万元)</td>
                </tr>
                <tr>
                    <td rowspan="2" style="width: 100px;">
                        首付款(万元)</td>
                    <td rowspan="2">
                        <asp:DataList ID="dlBankInfo" runat="server" RepeatDirection="Horizontal">
                            <ItemTemplate>
                                <table border="0" cellpadding="0" cellspacing="0" style="border: 0px;">
                                    <tr height="30">
                                        <td colspan="3" style="border-top: 0px; border-left: 0px; border-right: 0px;">
                                            <%#Eval("SellList_MortgageBank") %>
                                        </td>
                                    </tr>
                                    <tr height="30">
                                        <td width="100" style="border-left: 0px; border-bottom: 0px;">
                                            申报户数</td>
                                        <td width="100" style="border-bottom: 0px;">
                                            申报金额</td>
                                        <td width="100" style="border-right: 0px; border-bottom: 0px;">
                                            待放金额</td>
                                    </tr>
                                </table>
                            </ItemTemplate>
                        </asp:DataList>
                    </td>
                    <td colspan="2" style="width: 200px;">
                        未办理&nbsp;</td>
                </tr>
                <tr>
                    <td style="width: 100px;">
                        户数</td>
                    <td style="width: 100px">
                        金额</td>
                </tr>
                <asp:Repeater ID="rptGQInfo" runat="server" OnItemDataBound="rptGQInfo_ItemDataBound">
                    <ItemTemplate>
                        <tr style="height: 30px;">
                            <td rowspan="1" style="width: 240px;">
                                <%#Eval("SellList_GQ") %>
                            </td>
                            <td rowspan="1">
                                <%#Eval("ALLHu") %>
                            </td>
                            <td rowspan="1">
                                <%#Eval("ForSaleHu")%>
                            </td>
                            <td rowspan="1">
                                <%#FmtMoney(Eval("ForSalePrimaryTotalPrice"))%>
                            </td>
                            <td rowspan="1">
                                <%#FmtMoney(Eval("ForSalePactTotalPrice"))%>
                            </td>
                            <td rowspan="1">
                                <%#FmtMoney(Eval("ForNoSalePrimaryTotalPrice"))%>
                            </td>
                            <td rowspan="1">
                                <%# FmtMoney((Convert.ToInt32(Eval("YiShouShouFu")))+
                                    (Convert.ToInt32(Eval("YiShouFangKuan"))) )%>
                            </td>
                            <td rowspan="1">
                                <%#FmtMoney(Eval("NoPayFirst"))%>
                            </td>
                            <td rowspan="1">
                                <table border="0" cellpadding="0" cellspacing="0" class="T_table1" width="<%=myAllWidth %>">
                                    <tr height="30">
                                        <asp:Repeater ID="Repeater1" runat="server">
                                            <ItemTemplate>
                                                <td width="<%=myWidth %>" style="border-left: 0px; border-bottom: 0px; border-top: 0px;
                                                    text-align: right;">
                                                    &nbsp;<%#Eval("SBHu")%></td>
                                                <td width="<%=myWidth %>" style="border-left: 0px; border-bottom: 0px; border-top: 0px;
                                                    text-align: right;">
                                                    &nbsp;
                                                    <%#FmtMoney(Eval("SHMoney"))%>
                                                </td>
                                                <td width="<%=myWidth %>" style="border-left: 0px; border-bottom: 0px; border-top: 0px;
                                                    text-align: right;">
                                                    &nbsp;
                                                    <%#FmtMoney(Eval("YiShouFangKuan"))%>
                                                </td>
                                            </ItemTemplate>
                                        </asp:Repeater>
                                    </tr>
                                </table>
                            </td>
                            <td>
                                <%#Eval("WeiBanLiHu")%>
                            </td>
                            <td style="width: 42px">
                                <%#FmtMoney(Eval("WeiBanLiFangKuan"))%>
                            </td>
                        </tr>
                    </ItemTemplate>
                </asp:Repeater>
            </table>
        </form>
    </body>
    </html>