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);
}
