protected void rpOrderList_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { Order order = e.Item.DataItem as Order; FollowUpTop3UserControl followUp = e.Item.FindControl("followUpTop3UserControl") as FollowUpTop3UserControl; UIUtility.BindUserControl(followUp, SysConst.SourceTypeOrder, order.Order_No); Label lblContractAmount = e.Item.FindControl("lblContractAmount") as Label; Label lblSettlementAmount = e.Item.FindControl("lblSettlementAmount") as Label; Label lblReceivedAmount = e.Item.FindControl("lblReceivedAmount") as Label; Label lblNeedAmount = e.Item.FindControl("lblNeedAmount") as Label; LineItemDAL lineDAL = new LineItemDAL(); SettlementDAL stDAL = new SettlementDAL(); ReceiptDAL rDAL = new ReceiptDAL(); var contractAmount = lineDAL.GetLineItemsBySource(order.Order_Id, SysConst.SourceTypeOrder).Sum(l => l.UnitPrice * l.Quantity); var stAmount = stDAL.GetSettlementByOrderNo(order.Order_No).Sum(s => s.TotalAmount); var receivedAmount = rDAL.GetReceiptBySource(SysConst.SourceTypeOrder, order.Order_No).Sum(r => r.ReceivedAmount); lblContractAmount.Text = contractAmount.ToString(); lblSettlementAmount.Text = stAmount.ToString(); lblReceivedAmount.Text = receivedAmount.ToString(); var needAmount = stAmount != 0 ? (stAmount - receivedAmount) : (contractAmount - receivedAmount); lblNeedAmount.Text = needAmount.ToString(); totalContract += contractAmount.GetValueOrDefault(); totalSt += stAmount.GetValueOrDefault(); totalRec += receivedAmount.GetValueOrDefault(); totalNeed += needAmount.GetValueOrDefault(); } if (e.Item.ItemType == ListItemType.Footer) { var lblTotalContract = e.Item.FindControl("lblTotalContract") as Label; var lblTotalST = e.Item.FindControl("lblTotalST") as Label; var lblTotalRec = e.Item.FindControl("lblTotalRec") as Label; var lblTotalNeed = e.Item.FindControl("lblTotalNeed") as Label; lblTotalContract.Text = totalContract.ToString(); lblTotalNeed.Text = totalNeed.ToString(); lblTotalRec.Text = totalRec.ToString(); lblTotalST.Text = totalSt.ToString(); } }
public override void BindControl() { ReceiptDAL dal = new ReceiptDAL(); Utility.BindDataToRepeater(rpItems, dal.GetReceiptBySource(SourceType, SourceNo)); }