public override void OnPageLoad(object sender, EventArgs e) { base.OnPageLoad(sender, e); PageQueryFacade = new InventoryQueryFacade(this); PageQueryView = new StockAgeReportQueryVM(); this.SearchBuilder.DataContext = PageQueryView; this.dpStatisticDate.SelectedDate = DateTime.Today.AddDays(-1); CodeNamePairHelper.GetList(ConstValue.DomainName_Inventory, "StockAge", CodeNamePairAppendItemType.All, (_, args) => { PageQueryView.StockAgeTypeList = args.Result.Convert <CodeNamePair, SelectionOptionVM>((s, t) => { t.Text = s.Name; t.Value = s.Code; t.Selected = true; }); if (PageQueryView.StockAgeTypeList != null && PageQueryView.StockAgeTypeList.Count > 0) { PageQueryView.StockAgeTypeList.ForEach(item => { item.PropertyChanged += item_PropertyChanged; }); } this.SetSelectionText(); }); }
/// <summary> /// 商品库龄报表查询 /// </summary> /// <param name="model"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="sortField"></param> /// <param name="callback"></param> public void QueryStockAgeReport(StockAgeReportQueryVM model, int pageIndex, int pageSize, string sortField, EventHandler <RestClientEventArgs <dynamic> > callback) { StockAgeReportQueryFilter filter = EntityConverter <StockAgeReportQueryVM, StockAgeReportQueryFilter> .Convert(model, (s, t) => { t.StockAgeTypeList = s.StockAgeTypeList.Where(x => x.Value != null && x.Selected).Select(x => x.Value).ToList(); }, "StockAgeTypeList"); filter.PagingInfo = new QueryFilter.Common.PagingInfo() { PageIndex = pageIndex, PageSize = pageSize, SortBy = sortField }; string relativeUrl = "/InventoryService/Inventory/QueryStockAgeReport"; restClient.QueryDynamicData(relativeUrl, filter, (_, args) => { if (args.FaultsHandle()) { return; } callback(this, new RestClientEventArgs <dynamic>(args.Result, this.page)); }); }
/// <summary> /// 商品库龄报表导出 /// </summary> /// <param name="model"></param> /// <param name="columnSet"></param> public void ExportExcelForStockAgeReport(StockAgeReportQueryVM model, ColumnSet[] columnSet) { StockAgeReportQueryFilter filter = EntityConverter <StockAgeReportQueryVM, StockAgeReportQueryFilter> .Convert(model, (s, t) => { t.StockAgeTypeList = s.StockAgeTypeList.Where(x => x.Value != null && x.Selected).Select(x => x.Value).ToList(); }, "StockAgeTypeList"); filter.PagingInfo = new QueryFilter.Common.PagingInfo() { PageIndex = 0, PageSize = int.MaxValue, }; //List<TextInfo> textInfoList = new List<TextInfo>(); //textInfoList.Add(new TextInfo() { Title = "Neticom (Hong Kong) Limited", Memo = string.Empty }); //textInfoList.Add(new TextInfo() { Title = "As at", Memo = filter.StatisticDate.ToString("dd/MM/yyyy") }); //textInfoList.Add(new TextInfo() { Title = "Reporting currency:", Memo = "RMB / HKD" }); string relativeUrl = "/InventoryService/Inventory/QueryStockAgeReport"; restClient.ExportFile(relativeUrl, filter, columnSet); }