/// <summary> /// 数据全部导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void QueryResultGrid2_ExportAllClick(object sender, EventArgs e) { if (filterReply == null || this.QueryResultGrid2.TotalCount < 1) { Window.Alert(ResComment.Information_ExportFailed); return; } ColumnSet col = new ColumnSet(); col.Add("Status", "回复状态"); col.Add("ReplyContent", "回复内容"); col.Add("TopicContent", "回复主题"); col.Add("VendorName", "商品所属商家"); col.Add("IsTop", "是否置顶"); col.Add("Type", "回复者类型"); col.Add("InUser", "创建人"); col.Add("InDate", "创建时间"); col.Add("EditUser", "更新人"); col.Add("EditDate", "更新时间"); filterReply = modelReply.ConvertVM <ProductConsultReplyQueryVM, ProductConsultReplyQueryFilter>(); filterReply.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo() { PageSize = ConstValue.MaxRowCountLimit, PageIndex = 0, SortBy = string.Empty }; facade.ExportReplyExcelFile(filterReply, new ColumnSet[] { col }); }
public override void AddRequiredColumns(IDictionary <string, DataSource> dataSources, IDictionary <string, Type> parameterTypes, IList <string> requiredColumns) { var mappings = ColumnSet.Where(col => !col.AllColumns).ToDictionary(col => col.OutputColumn, col => col.SourceColumn); ColumnSet.Clear(); // Map the aliased names to the base names for (var i = 0; i < requiredColumns.Count; i++) { if (requiredColumns[i].StartsWith(Alias + ".")) { requiredColumns[i] = requiredColumns[i].Substring(Alias.Length + 1); if (!mappings.TryGetValue(requiredColumns[i], out var sourceCol)) { sourceCol = requiredColumns[i]; } ColumnSet.Add(new SelectColumn { SourceColumn = sourceCol, OutputColumn = requiredColumns[i] }); requiredColumns[i] = sourceCol; } } Source.AddRequiredColumns(dataSources, parameterTypes, requiredColumns); }
public void width() { var set = new ColumnSet(3); var line = set.Add("aaaaa", "bbb", "cc"); // the default padding between columns is 5 spaces line.Width.ShouldEqual(20); }
public void adding_a_line_with_the_wrong_counts_throws_exception() { Exception <ArgumentOutOfRangeException> .ShouldBeThrownBy(() => { var set = new ColumnSet(3); set.Add("a", "b"); }); }
/// <summary> /// 数据全部导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ProductDiscussReplyList_ExportAllClick(object sender, EventArgs e) { if (filterReplyVM == null || this.ProductDiscussReplyList.TotalCount < 1) { Window.Alert(ResComment.Information_ExportFailed); return; } ColumnSet col = new ColumnSet(); col.Add("Title", "讨论标题", 15); col.Add("ProductID", "商品ID", 15); col.Add("Content", "回复内容", 20); col.Add("InUser", "创建人", 15); col.Add("InDate", "创建时间", 15); col.Add("EditUser", "更新人", 15); col.Add("EditDate", "更新时间", 15); filterReply = modelReply.ConvertVM <ProductDiscussReplyQueryVM, ProductDiscussReplyQueryFilter>(); filterReply.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo() { PageSize = ConstValue.MaxRowCountLimit, PageIndex = 0, SortBy = string.Empty }; facade.ExportReplyExcelFile(filterReplyVM, new ColumnSet[] { col }); }
public void write_a_line() { var set = new ColumnSet(3); var line = set.Add("a", "b", "c"); var writer = new StringWriter(); line.Write(writer); var text = "a*****b*****c\r\n".Replace("*", " "); writer.ToString().ShouldEqualWithLineEndings(text); }
/// <summary> /// 导出RO /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExportRO_Click(object sender, RoutedEventArgs e) { if (lastQueryVM == null || this.dgSaleIncomeQueryResult.TotalCount <= 0) { Window.Alert(ResCommon.Message_NoData2Export); return; } var flag = ValidationManager.Validate(this.gridQueryBuilder); if (flag) { if (lastQueryVM.OrderType != SOIncomeOrderType.RO) { lastQueryVM.ValidationErrors.Add(new System.ComponentModel.DataAnnotations.ValidationResult(ResSaleIncomeQuery.Message_PlsChooseROTypeDlgTitle , new string[] { "OrderType" })); Window.Alert(ResSaleIncomeQuery.Message_PlsChooseROTypeDlgTitle); return; } else if (!lastQueryVM.RORefundDateFrom.HasValue && !lastQueryVM.RORefundDateTo.HasValue) { lastQueryVM.ValidationErrors.Add(new System.ComponentModel.DataAnnotations.ValidationResult(ResSaleIncomeQuery.Message_PlsChooseROReturnTimeDlgTitle , new string[] { "RORefundDateFrom", "RORefundDateTo" })); Window.Alert(ResSaleIncomeQuery.Message_PlsChooseROReturnTimeDlgTitle); return; } ColumnSet col = new ColumnSet(); col.Add("RefundID", ResSaleIncomeQuery.Grid_RefundID, 20); col.Add("CashAmt", ResSaleIncomeQuery.Grid_RefundCashAmt); col.Add("RefoundTime", ResSaleIncomeQuery.Grid_RefundTime); col.Add("SOSysNo", ResSaleIncomeQuery.Grid_SOSysNo); col.Add("OutTime", ResSaleIncomeQuery.Grid_OutTime); soIncomeFacade.ExportROExcelFile(lastQueryVM, new ColumnSet[] { col }); } }
/// <summary> /// 数据全部导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void QueryResultGrid_ExportAllClick(object sender, EventArgs e) { if (filterVM == null || this.QueryResultGrid.TotalCount < 1) { Window.Alert(ResComment.Msg_ExportError); return; } if (this.QueryResultGrid.TotalCount > 10000) { Window.Alert(ResComment.Msg_ExportExceedsLimitCount); return; } ColumnSet col = new ColumnSet(); col.Add("Title", "评论标题"); col.Add("Prons", "优点"); col.Add("Cons", "缺点"); col.Add("Service", "其他"); col.Add("Score", "总评分数"); col.Add("ProductID", "商品ID"); col.Add("InUser", "创建人"); col.Add("InDate", "创建时间"); col.Add("EditUser", "更新人"); col.Add("EditDate", "更新时间"); //filter = model.ConvertVM<ProductReviewQueryVM, ProductReviewQueryFilter>(); filter.PageInfo = new ECCentral.QueryFilter.Common.PagingInfo() { PageSize = ConstValue.MaxRowCountLimit, PageIndex = 0, SortBy = string.Empty }; facade.ExportExcelFile(filter, new ColumnSet[] { col }); }
private void dgPostIncomeQueryResult_ExportAllClick(object sender, EventArgs e) { if (lastQueryVM == null || this.dgPostIncomeQueryResult.TotalCount <= 0) { Window.Alert(ResCommon.Message_NoData2Export); return; } ColumnSet col = new ColumnSet(this.dgPostIncomeQueryResult); col.Add("IncomeAmt", ResPostIncomeQuery.Grid_IncomeAmt); col.Add("HandleStatusDesc", ResPostIncomeQuery.Grid_HandleStatus); col.Add("OrderTime", ResPostIncomeQuery.Grid_OrderTime); col.Add("OutTime", ResPostIncomeQuery.Grid_OutTime); col.Add("CreateDate", ResPostIncomeQuery.Grid_CreateDate, "yyyy-MM-dd", 12); col.Add("ModifyDate", ResPostIncomeQuery.Grid_ModifyDate, "yyyy-MM-dd", 12); col.Add("IncomeDate", ResPostIncomeQuery.Grid_IncomeDate, "yyyy-MM-dd", 12); col.Add("ConfirmDate", ResPostIncomeQuery.Grid_ConfirmDate, "yyyy-MM-dd", 12); facade.ExportExcelFile(lastQueryVM, new ColumnSet[] { col }); }
private void QueryResultGrid_ExportAllClick(object sender, EventArgs e) { //权限控制: //导出全部数据: if (!AuthMgr.HasFunctionPoint(AuthKeyConst.PO_Consign_ExportConsignList)) { Window.Alert("对不起,你没有权限进行此操作!"); return; } //导出全部: if (null == queryFilter || this.QueryResultGrid.ItemsSource == null || this.QueryResultGrid.TotalCount == 0) { Window.Alert("没有可供导出的数据!"); return; } CollectionPaymentFilter exportQueryRequest = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <CollectionPaymentFilter>(queryFilter); exportQueryRequest.PageInfo = new QueryFilter.Common.PagingInfo() { PageIndex = 0, PageSize = ConstValue.MaxRowCountLimit }; foreach (DataGridColumn col in QueryResultGrid.Columns) { if (col.Visibility == Visibility.Collapsed) { if (col is Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn) { (col as Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn).NeedExport = false; } else if (col is Newegg.Oversea.Silverlight.Controls.Data.DataGridTemplateColumn) { (col as Newegg.Oversea.Silverlight.Controls.Data.DataGridTemplateColumn).NeedExport = false; } } } ColumnSet columnSet = new ColumnSet(QueryResultGrid); columnSet.Add("Status", ResConsignQuery.GridHeader_Status); //serviceFacade.ExportExcelFroConsignSettlementList(exportQueryRequest, new ColumnSet[] { columnSet }); }
private void dgInvoiceQueryResult_ExportAllClick(object sender, EventArgs e) { if (lastQueryVM == null || this.dgInvoiceQueryResult.TotalCount <= 0) { Window.Alert(ResCommon.Message_NoData2Export); return; } ColumnSet col = new ColumnSet(this.dgInvoiceQueryResult); col.Add("OrderSysNo", ResInvoiceQuery.DataGrid_OrderSysNo); col.Add("PayTypeSysNo", ResInvoiceQuery.Grid_PayTypeSysNo); col.Add("OutUser", ResInvoiceQuery.DataGrid_OutUser); col.Add("OutTime", ResInvoiceQuery.DataGrid_OutTime); col.Add("InvoiceCreateTime", ResInvoiceQuery.DataGrid_InvoiceCreateTime); col.Add("IncomeAmt", ResInvoiceQuery.DataGrid_IncomeAmt); col.Add("SOSysNo", ResInvoiceQuery.DataGrid_SOSysNo); invoiceFacade.ExportExcelFile(lastQueryVM, new ColumnSet[] { col }); }
private void dgQueryResult_ExportAllClick(object sender, EventArgs e) { if (this.dgQueryResult == null || this.dgQueryResult.TotalCount == 0) { Window.Alert("没有可供导出的数据!"); return; } m_queryRequest.PagingInfo = new PagingInfo() { PageSize = ConstValue.MaxRowCountLimit, PageIndex = 0, SortBy = string.Empty }; FinancialFacade facade = new FinancialFacade(this); ColumnSet col = new ColumnSet(dgQueryResult, true); col.Add("RMACountDescription", ResFinanceQuery.DataGrid_Column_Head_IsVendorRepairParts); facade.ExportFinance(m_queryRequest, new ColumnSet[] { col }); }
private void QueryResultGrid_ExportAllClick(object sender, EventArgs e) { //权限控制: if (!AuthMgr.HasFunctionPoint(AuthKeyConst.PO_VirtualPO_Export)) { Window.Alert("对不起,你没有权限进行此操作! "); return; } //导出全部: if (null != queryFilter) { VirtualPurchaseOrderQueryFilter exportQueryRequest = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <VirtualPurchaseOrderQueryFilter>(queryFilter); exportQueryRequest.PageInfo = new QueryFilter.Common.PagingInfo() { PageIndex = 0, PageSize = ConstValue.MaxRowCountLimit }; foreach (DataGridColumn col in QueryResultGrid.Columns) { if (col.Visibility == Visibility.Collapsed) { if (col is Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn) { (col as Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn).NeedExport = false; } else if (col is Newegg.Oversea.Silverlight.Controls.Data.DataGridTemplateColumn) { (col as Newegg.Oversea.Silverlight.Controls.Data.DataGridTemplateColumn).NeedExport = false; } } } ColumnSet columnSet = new ColumnSet(QueryResultGrid); columnSet.Add("Status", ResVirtualStockPurchaseOrderQuery.GridHeader_Status); serviceFacade.ExportExcelForVirtualPurchaseOrders(exportQueryRequest, new ColumnSet[] { columnSet }); } }
private void dgAuditRefundQueryResult_ExportAllClick(object sender, EventArgs e) { if (lastQueryVM == null || this.dgAuditRefundQueryResult.TotalCount <= 0) { Window.Alert(ResCommon.Message_NoData2Export); return; } ColumnSet col = new ColumnSet(this.dgAuditRefundQueryResult); col.Add("RefundStatusDesc", ResAuditRefundQuery.Grid_RMARefundStatus); col.Add("RefundCashAmt", ResAuditRefundQuery.Grid_RefundAmount); col.Add("CreateUser", ResAuditRefundQuery.Grid_CreateUser); col.Add("CreateTime", ResAuditRefundQuery.Grid_CreateTime); col.Add("AuditUser", ResAuditRefundQuery.Grid_AuditUser); col.Add("AuditTime", ResAuditRefundQuery.Grid_AuditTime); auditRefundFacade.ExportExcelFile(lastQueryVM, new ColumnSet[] { col }); }
private void PullDataFromAttributeAuditDetail(AttributeAuditDetail attributeDetail, Microsoft.Office.Interop.Excel._Worksheet workSheet, string title) { var AttributeColl = attributeDetail.OldValue.Attributes; if (ColumnCount != AttributeColl.Count) { // Add Columns foreach (var ColumnName in AttributeColl.Keys) { if (!ColumnSet.ContainsKey(ColumnName)) { ColumnCount++; string attributeType = AttributeColl[ColumnName].GetType().ToString(); if (attributeType == "Microsoft.Xrm.Sdk.EntityReference") { ColumnSet.Add(ColumnName, new List <ColumnDetail>() { new ColumnDetail() { AttributeName = ColumnName, Column = ColumnName + "_GUID", position = ColumnCount }, new ColumnDetail() { AttributeName = ColumnName, Column = ColumnName + "_Name", position = (ColumnCount + 1) } }); workSheet.Cells[1, ExcelColumns[ColumnCount + 1]] = ColumnName + "_GUID"; workSheet.Cells[1, ExcelColumns[ColumnCount + 2]] = ColumnName + "_Name"; ColumnCount++; } else { ColumnSet.Add(ColumnName, new List <ColumnDetail>() { new ColumnDetail() { AttributeName = ColumnName, Column = ColumnName, position = ColumnCount } }); workSheet.Cells[1, ExcelColumns[ColumnCount + 1]] = ColumnName; } } } } workSheet.Cells[rowCount, "A"] = title; foreach (KeyValuePair <string, List <ColumnDetail> > item in ColumnSet) { string cellValue = ""; if (AttributeColl.ContainsKey(item.Key)) { var attribute = AttributeColl[item.Key]; switch (attribute.GetType().ToString()) { case "Microsoft.Xrm.Sdk.OptionSetValue": cellValue = ((OptionSetValue)attribute).Value.ToString(); break; case "Microsoft.Xrm.Sdk.EntityReference": var ref_ = (EntityReference)attribute; workSheet.Cells[rowCount, ExcelColumns[item.Value[1].position + 1]] = ref_.Name; cellValue = ref_.Id.ToString(); break; default: cellValue = attribute.ToString(); break; } workSheet.Cells[rowCount, ExcelColumns[item.Value[0].position + 1]] = cellValue; } } rowCount++; }