repeater嵌套以及合计问题

来源：互联网发布：数据恢复专业版编辑：程序博客网时间：2024/05/16 18:20

这次是做免费品订单的详情页面，根据需求，要做如下展示

看着还行，就是repeater里面嵌套一个repeater呗，因为之前做过类似的，代码实现不是什么大问题，存储过程也都可以搞定，第二层的repeater这么绑定就可以了

protected void rptSapOrderList_ItemDataBound(object sender, RepeaterItemEventArgs e)        {            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)            {                Repeater rep = e.Item.FindControl("rptSapOrderDetail") as Repeater;                Model.FreeGoodsDetail md = (Model.FreeGoodsDetail)e.Item.DataItem;                List<Model.FreeGoodsDetail> list = biz.GetOrderReceiptInfo(md.PurchaseOrderNo, md.CustCode, md.DeliveryNo);                rep.DataSource = list;                rep.DataBind();            }        }

问题是需要第一层的repeater内显示第二层的合计数，以及记录的条数，经过单MM的帮助，存储过程里求出来即可

SELECT DISTINCT CustCode  , CustName  , PurchaseOrderNo  , SapOrderNo  , DeliveryNo  , DeliveryDate  , SUM(OrderQuantity) AS  TotalAmount  , COUNT(*) AS TotalCount  , CASE ISDATE(SapOrderDate) WHEN 1 THEN CONVERT(CHAR(10), CAST(SapOrderDate AS DATETIME),121) ELSE SapOrderDate END AS SapOrderDate FROM OrderReceiptInfoWHERE PurchaseOrderNo=@PurchaseOrderNo AND CustCode=@CustCodeGROUP BY CustCode,CustName, PurchaseOrderNo, SapOrderNo, DeliveryNo, DeliveryDate,SapOrderDate

基本就这样了，好了又该忙了，妈蛋啊

0 0