/// <summary> /// 已分配查询 - 商品总库存信息 /// </summary> /// <param name="queryFilter"></param> /// <param name="callback"></param> public void QueryItemAllocatedCardInventoryTotal(InventoryAllocatedCardQueryVM model, Action <int, List <dynamic> > callback) { InventoryQueryFilter filter; model.CompanyCode = CPApplication.Current.CompanyCode; filter = model.ConvertVM <InventoryAllocatedCardQueryVM, InventoryQueryFilter>(); filter.IsShowTotalInventory = true; string relativeUrl = "/InventoryService/Inventory/QueryProductInventory"; restClient.QueryDynamicData(relativeUrl, filter, (obj, args) => { int totalCount = 0; List <dynamic> vmList = null; if (!args.FaultsHandle()) { if (!(args.Result == null || args.Result.Rows == null)) { totalCount = args.Result.TotalCount; vmList = args.Result.Rows.ToList(); } callback(totalCount, vmList); } }); }
private void dgItemCardQueryResult_ExportAllClick(object sender, EventArgs e) { if (!AuthMgr.HasFunctionPoint(AuthKeyConst.Inventory_ItemAllocatedCardQuery_ExportExcellAll)) { Window.Alert("对不起,你没有权限进行此操作!"); return; } if (this.dgItemCardQueryResult == null | this.dgItemCardQueryResult.TotalCount == 0) { Window.Alert("没有可供导出的数据!"); return; } //导出全部: if (null != PageView.QueryInfo) { InventoryAllocatedCardQueryVM exportQueryRequest = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <InventoryAllocatedCardQueryVM>(PageView.QueryInfo); exportQueryRequest.PagingInfo = new QueryFilter.Common.PagingInfo() { PageIndex = 0, PageSize = ConstValue.MaxRowCountLimit }; ColumnSet columnSet = new ColumnSet() .Add("OrderNameString", ResItemAllocatedCardQuery.GridHeader_OrderName, 40) .Add("OrderSysNo", ResItemAllocatedCardQuery.GridHeader_OrderCode, 40) .Add("OrderTime", ResItemAllocatedCardQuery.GridHeader_OrderTime, 20) .Add("OrderQty", ResItemAllocatedCardQuery.GridHeader_OrderQty, 20) .Add("OrderThenQty", ResItemAllocatedCardQuery.GridHeader_OrderThenQty, 20); new ItemAllocatedCardQueryFacade(this).ExportExcelForItemAllocatedCardOrders(exportQueryRequest, new ColumnSet[] { columnSet }); } }
/// <summary> /// 导出查询结果 /// </summary> /// <param name="model"></param> /// <param name="columns"></param> public void ExportExcelForItemAllocatedCardOrders(InventoryAllocatedCardQueryVM model, ColumnSet[] columns) { InventoryAllocatedCardQueryFilter queryFilter; model.CompanyCode = CPApplication.Current.CompanyCode; queryFilter = model.ConvertVM <InventoryAllocatedCardQueryVM, InventoryAllocatedCardQueryFilter>(); string relativeUrl = "InventoryService/InventoryStock/QueryAllocatedItemOrders"; restClient.ExportFile(relativeUrl, queryFilter, columns); }