/// <summary> /// 导出报表数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgQueryResult_ExportAllClick(object sender, EventArgs e) { if (!AuthMgr.HasFunctionPoint(AuthKeyConst.EIMS_AccruedByRule_Export)) { Window.Alert(ResEIMSAccrued.Msg_HasNoRight); return; } if (dgQueryResult.ItemsSource != null) { m_queryRequest.PagingInfo = new PagingInfo() { PageSize = ConstValue.MaxRowCountLimit, PageIndex = 0, SortBy = string.Empty }; AccruedReportFacade facade = new AccruedReportFacade(this); ColumnSet col = new ColumnSet(dgQueryResult); col.Insert(5, "BeginBalanceAccrued", "期初余额_应计金额", 20); col.Insert(6, "BeginBalanceTax", "期初余额_税金", 20); col.Insert(7, "BeginBalance", "期初余额_总额", 20); col.Insert(8, "curAccruedAmount", "当期返利_应计金额", 20); col.Insert(9, "AccruedAmountTax", "当期返利_税金", 20); col.Insert(10, "AccruedAmount", "当期返利_总额", 20); col.Insert(11, "ReceivedPO", "已收返利金额(含税金额)_PO单扣减", 20); col.Insert(12, "ReceivedConsign", "已收返利金额(含税金额)_代销结算单扣减", 20); col.Insert(13, "ReceivedCash", "已收返利金额(含税金额)_现金", 20); col.Insert(14, "ReceivedAcctDeduct", "已收返利金额(含税金额)_帐扣", 20); col.Insert(15, "ReceivedVoteBuckle", "已收返利金额(含税金额)_票扣", 20); col.Insert(16, "ReceivedAmount", "已收返利金额(含税金额)_总计", 20); col.Insert(17, "EndBalanceAccrued", "期末余额_应计金额", 20); col.Insert(18, "EndBalanceTax", "期末余额_税金", 20); col.Insert(19, "EndBalance", "期末余额_总额", 20); facade.ExportAccruedByRule(m_queryRequest, new ColumnSet[] { col }); } else { Window.Alert(ResEIMSAccrued.Msg_PleaseQueryData); return; } }
private void dgQueryResult_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e) { m_queryRequest.PagingInfo = new PagingInfo() { PageSize = e.PageSize, PageIndex = e.PageIndex, SortBy = e.SortField }; AccruedReportFacade facade = new AccruedReportFacade(this); facade.AccruedByRule(m_queryRequest, (obj, args) => { if (args.FaultsHandle()) { return; } this.dgQueryResult.TotalCount = args.Result.TotalCount; this.dgQueryResult.ItemsSource = args.Result.Rows; }); }