/// <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++;
}
