Example #1
0
        /// <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;
            }
        }
Example #2
0
        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;
            });
        }