public void QueryAdjustRequest(AdjustRequestQueryVM model, Action <int, List <dynamic> > callback) { AdjustRequestQueryFilter filter; model.CompanyCode = CPApplication.Current.CompanyCode; filter = model.ConvertVM <AdjustRequestQueryVM, AdjustRequestQueryFilter>(); string relativeUrl = "/InventoryService/AdjustRequest/QueryAdjustRequest"; restClient.QueryDynamicData(relativeUrl, filter, (obj, args) => { if (!args.FaultsHandle()) { List <dynamic> result = null; int totalCount = 0; if (!(args.Result == null || args.Result.Rows == null)) { result = args.Result.Rows.ToList(); totalCount = args.Result.TotalCount; } if (callback != null) { callback(totalCount, result); } } }); }
private void dgAdjustQueryResult_ExportAllClick(object sender, EventArgs e) { //if (!AuthMgr.HasFunctionPoint(AuthKeyConst.Inventory_AdjustRequestQuery_ExportExcell)) //{ // Window.Alert("对不起,你没有权限进行此操作!"); // return; //} if (this.dgAdjustQueryResult == null || this.dgAdjustQueryResult.TotalCount == 0) { Window.Alert("没有可供导出的数据!"); return; } //导出全部: if (null != PageView.QueryInfo) { AdjustRequestQueryVM exportQueryRequest = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <AdjustRequestQueryVM>(PageView.QueryInfo); exportQueryRequest.PagingInfo = new QueryFilter.Common.PagingInfo() { PageIndex = 0, PageSize = ConstValue.MaxRowCountLimit }; ColumnSet columnSet = new ColumnSet() .Add("RequestID", ResAdjustRequestQuery.Grid_AdjustID, 40) .Add("RequestStatus", ResAdjustRequestQuery.Grid_Status, 20) .Add("ConsignFlag", ResAdjustRequestQuery.Grid_ConsignFlag, 40) .Add("CreateDate", ResAdjustRequestQuery.Grid_CreateTime, 30) .Add("AuditDate", ResAdjustRequestQuery.Grid_AuditTime, 30) .Add("OutStockDate", ResAdjustRequestQuery.Grid_OutTime, 30); new AdjustRequestQueryFacade(this).ExportExcelForAdjustRequest(exportQueryRequest, new ColumnSet[] { columnSet }); } }
/// <summary> /// 导出查询结果 /// </summary> /// <param name="model"></param> /// <param name="columns"></param> public void ExportExcelForAdjustRequest(AdjustRequestQueryVM model, ColumnSet[] columns) { AdjustRequestQueryFilter queryFilter; model.CompanyCode = CPApplication.Current.CompanyCode; queryFilter = model.ConvertVM <AdjustRequestQueryVM, AdjustRequestQueryFilter>(); string relativeUrl = "/InventoryService/AdjustRequest/QueryAdjustRequest"; restClient.ExportFile(relativeUrl, queryFilter, columns); }