Compute求当前页数据总和是这样用的,记住了

页面

								<td colspan="2">总金额: <%=dt.Compute("Sum(jexx)","") %>元</td>
								<td colspan="3" style="text-align: center">合计:</td>
		                        <td colspan="2">总金额: <%=dt.Compute("Sum(jexx)","") %>元</td>
                                <td colspan="2">预付款: <%=dt.Compute("Sum(yufuk)","") %>元</td>
                                <td>已结清: <%=dt.Compute("Sum(jexx)","mystatus=3") %>元</td>
                                <td colspan="1">    欠款: <%=decimal.Parse(dt.Compute("Sum(jexx)","").ToString())-decimal.Parse(dt.Compute("Sum(yufuk)","").ToString())-decimal.Parse(dt.Compute("Sum(jexx)","mystatus=3").ToString()) %>元  </td>
                                 

后台

string sql = "o.KeyId mainKeyid,od.KeyId detKeyId,o.comname,o.jpm,o.orderid,od.yspmc,od.sl,od.dj,od.je,o.jexx,o.yufuk,o.dept,o.status,o.mystatus";//需要显示的字段
 dt = SqlEasy.ExecuteDataTable("Select * FROM (SELECT ROW_NUMBER()Over(order by o.KeyId desc) as rowId," + sql + " from jydOrder as o,jydOrderDetail as od where od.orderid=o.OrderID "+searchSql+") as mytable WHERE rowId between " + start + " and " + end + "");