private void dgVirtualRequestMemoQueryResult_ExportAllClick(object sender, EventArgs e) { if (!AuthMgr.HasFunctionPoint(AuthKeyConst.Inventory_VirtualRequestMemoQuery_ExportExcell)) { Window.Alert("对不起,你没有权限进行此操作!"); return; } if (this.dgVirtualRequestMemoQueryResult == null || this.dgVirtualRequestMemoQueryResult.TotalCount == 0) { Window.Alert("没有可供导出的数据!"); return; } //导出全部: if (null != PageView.QueryInfo) { VirtualRequestQueryVM exportQueryRequest = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <VirtualRequestQueryVM>(PageView.QueryInfo); exportQueryRequest.PagingInfo = new QueryFilter.Common.PagingInfo() { PageIndex = 0, PageSize = ConstValue.MaxRowCountLimit }; ColumnSet columnSet = new ColumnSet() .Add("ProductID", ResVirtualRequestMemoQuery.Grid_ProductID, 40) .Add("ProductName", ResVirtualRequestMemoQuery.Grid_ProductName, 40) .Add("VirtualQuantity", ResVirtualRequestMemoQuery.Grid_AdjustVirtualQty, 40) .Add("VirtualType", ResVirtualRequestMemoQuery.Grid_VirtualType, 40) .Add("CreateUserName", ResVirtualRequestMemoQuery.Grid_OperationUser, 40) .Add("CreateDate", ResVirtualRequestMemoQuery.Grid_OperationDate, 30) .Add("Note", ResVirtualRequestMemoQuery.Grid_ActionMemo, 30); new VirtualRequestQueryFacade(this).ExportExcelForVirtualRequestMemo(exportQueryRequest, new ColumnSet[] { columnSet }); } }
/// <summary> /// 导出虚库日志 /// </summary> /// <param name="model"></param> /// <param name="columns"></param> public void ExportExcelForVirtualRequestMemo(VirtualRequestQueryVM model, ColumnSet[] columns) { VirtualRequestQueryFilter queryFilter; model.CompanyCode = CPApplication.Current.CompanyCode; queryFilter = model.ConvertVM <VirtualRequestQueryVM, VirtualRequestQueryFilter>(); string relativeUrl = "/InventoryService/VirtualRequest/QueryVirtualRequestMemoList"; restClient.ExportFile(relativeUrl, queryFilter, columns); }
public override void OnPageLoad(object sender, EventArgs e) { base.OnPageLoad(sender, e); queryVM = new VirtualRequestQueryVM(); inventoryInfoVM = new List <VirtualRequestInventoryInfoVM>(); queryFilter = new VirtualRequestQueryFilter(); queryFacade = new VirtualRequestQueryFacade(this); this.DataContext = queryVM; BindComboBoxData(); if (ProductSysNo.HasValue) { //queryVM.ProductSysNo = ProductSysNo.ToString(); queryVM.ProductSysNo = ProductSysNo; btnSearchInventory_Click(null, null); } }
/// <summary> /// 查询虚库日志 /// </summary> /// <param name="queryFilter"></param> /// <param name="callback"></param> public void QueryVirtualRequestMemo(VirtualRequestQueryVM model, Action <int, List <dynamic> > callback) { VirtualRequestQueryFilter queryFilter; queryFilter = model.ConvertVM <VirtualRequestQueryVM, VirtualRequestQueryFilter>(); queryFilter.CompanyCode = CPApplication.Current.CompanyCode; string relativeUrl = "/InventoryService/VirtualRequest/QueryVirtualRequestMemoList"; restClient.QueryDynamicData(relativeUrl, queryFilter, (obj, args) => { if (!args.FaultsHandle()) { int totalCount = 0; List <dynamic> vmList = null; if (!(args.Result == null || args.Result.Rows == null)) { totalCount = args.Result.TotalCount; vmList = args.Result.Rows.ToList(); } callback(totalCount, vmList); } }); }
public VirtualRequestQuery() { InitializeComponent(); queryVM = new VirtualRequestQueryVM(); queryFilter = new VirtualRequestQueryFilter(); }