private void dgProductQueryResult_ExportAllDataSource(object sender, EventArgs e)
{
ProductQueryFacade facade = new ProductQueryFacade(this);
var _vm = (ProductQueryExVM)this.DataContext;
if (_vm != null && _vm.PMUserCondition <= 0)
{
setPMUserCondition(_vm);
}
ColumnSet columnSet = new ColumnSet(this.ucProductQueryResult.dgProductQueryResult);
//SysNo GroupID ProductID ProductTitle
columnSet.Insert(0, new ColumnData()
{
FieldName = "C3SysNo", Title = "三级类别"
});
columnSet.Insert(0, new ColumnData()
{
FieldName = "C2SysNo", Title = "二级类别"
});
columnSet.Insert(0, new ColumnData()
{
FieldName = "C1SysNo", Title = "一级类别"
});
if (columnSet["MerchantNameDisplay"] != null)
{
columnSet["MerchantNameDisplay"].FieldName = "MerchantName";
}
facade.ExportAllProductToExcel(_vm, new ColumnSet[] { columnSet });
}
/// <summary>
/// 导出卡号
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExport_Click(object sender, RoutedEventArgs e)
{
//CreateGiftCardInfoList
//ResetGiftCardFabrication
//GiftCardFabricationMaster item = new GiftCardFabricationMaster();
//item = VM.ConvertVM<GiftCardFabricationVM, GiftCardFabricationMaster>();
//foreach (GiftCardFabricationItemVM gift in gridVM)
//{
// item.GiftCardFabricationList.Add(gift.ConvertVM <GiftCardFabricationItemVM, GiftCardFabrication>());
//}
facade.GetAddGiftCardInfoList(VM.SysNo.Value, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
if (args.Result)
{
ColumnSet col = new ColumnSet();
col.Insert(0, "TransactionNumber", ResGiftCardInfo.Column_SysNo);
col.Insert(1, "Code", ResGiftCardInfo.Column_CardSysNo);
col.Insert(2, "Password", ResGiftCardInfo.Column_Password);
col.Insert(3, "BarCode", ResGiftCardInfo.Column_BarCard);
col.Insert(4, "TotalAmount", ResGiftCardInfo.Column_Amount);
facade.ExportGiftCardExcelFile(VM.SysNo.Value, new ColumnSet[] { col });
if (Dialog != null)
{
Dialog.ResultArgs.Data = null;
Dialog.ResultArgs.DialogResult = DialogResultType.OK;
Dialog.Close();
}
}
else
{
CPApplication.Current.CurrentPage.Context.Window.Alert(ResGiftCardInfo.Information_GiftCardIsInProcess, MessageType.Warning);
}
//??????????
//facade.ResetGiftCardFabrication(item.SysNo.Value, (obj2, args2) =>
//{
// if (args2.FaultsHandle())
// return;
// CPApplication.Current.CurrentPage.Context.Window.Alert("操作成功！", MessageType.Information);
//});
});
}
private void dgSaleIncomeQueryResult_ExportAllClick(object sender, EventArgs e)
{
if (lastQueryVM == null || this.dgSaleIncomeQueryResult.TotalCount <= 0)
{
Window.Alert(ResCommon.Message_NoData2Export);
return;
}
ColumnSet col = new ColumnSet(this.dgSaleIncomeQueryResult);
col.Insert(3, "OrderType", ResSaleIncomeQuery.Grid_OrderType);
//col.Insert(7, "PayTypeName", ResSaleIncomeQuery.Grid_PayType);
// col.Insert(8, "ShipTypeName", ResSaleIncomeQuery.Grid_ShipType);
col.Insert(17, "ReturnCashAmt", ResSaleIncomeQuery.Grid_ReturnCash);
col.Insert(19, "ReturnPointAmt", ResSaleIncomeQuery.Grid_ReturnPoint);
col.Insert(20, "ToleranceAmt", ResSaleIncomeQuery.Grid_ToleranceAmt);
col.Insert(28, "BankInfo", ResSaleIncomeQuery.Grid_BankInfo);
soIncomeFacade.ExportExcelFile(lastQueryVM, new ColumnSet[] { col });
}
private void dgVendorByGroupQueryResult_ExportAllClick(object sender, EventArgs e)
{
m_queryRequest.PagingInfo = new PagingInfo()
{
PageSize = ConstValue.MaxRowCountLimit,
PageIndex = 0,
SortBy = string.Empty
};
FinancialFacade facade = new FinancialFacade(this);
ColumnSet col = new ColumnSet(dgVendorByGroupQueryResult);
col.Insert(10, "R4", "未扣减的EIMS-票扣", 20);
col.Insert(11, "R2", "未扣减的EIMS-帐扣", 20);
col.Insert(12, "R0", "未扣减的EIMS-PO单扣减", 20);
col.Insert(13, "R3", "未扣减的EIMS-代销结算单扣减", 20);
facade.ExportFinanceVendorByGroup(m_queryRequest, new ColumnSet[] { col });
}
private void DataGrid_ExportAllClick(object sender, EventArgs e)
{
if (_lastQueryVM == null || this.DataGrid.TotalCount <= 0)
{
Window.Alert(ResCommon.Message_NoData2Export);
return;
}
ColumnSet col = new ColumnSet(this.DataGrid);
col.Insert(2, "InvoiceType", "发票类型");
_facade.ExportAllInvoiceExcelFile(_lastQueryVM, new ColumnSet[] { col });
}
//按查询条件导出数据到Excel
private void QueryResultGrid_ExportAllClick(object sender, EventArgs e)
{
if (!AuthMgr.HasFunctionPoint(AuthKeyConst.SO_ExcelExport))
{
Window.Alert(ResSO.Msg_Error_Right, MessageType.Error);
return;
}
m_queryRequest.PagingInfo = new PagingInfo()
{
PageSize = ConstValue.MaxRowCountLimit,
PageIndex = 0,
SortBy = string.Empty
};
SOQueryFacade facade = new SOQueryFacade(this);
ColumnSet col = new ColumnSet(QueryResultGrid);
col.Insert(0, "CSConfirmComplainType", ResSO.DataGrid_CSConfirmComplainType);
col.Insert(1, "CSConfirmComplainTypeDetail", ResSO.DataGrid_CSConfirmComplainTypeDetail);
facade.ExportComplain(m_queryRequest, new ColumnSet[] { col });
}
/// <summary>
/// 导出付款单列表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgPayItemQueryResult_ExportAllClick(object sender, EventArgs e)
{
if (lastQueryVM == null || this.dgPayItemQueryResult.TotalCount <= 0)
{
Window.Alert(ResCommon.Message_NoData2Export);
return;
}
ColumnSet col = new ColumnSet(this.dgPayItemQueryResult);
col.Insert(15, "InvoiceUpdate", ResPayItemQuery.Grid_InvoiceUpdate);
col.SetFormat("EstimatePayTime", ConstValue.Invoice_ShortTimeFormat);
facade.ExportExcelFile(lastQueryVM, new ColumnSet[] { col });
}
private void ProductShowResult_ExportAllClick(object sender, EventArgs e)
{
ProductShowFacade facade = new ProductShowFacade();
ColumnSet col = new ColumnSet();
col.Insert(0, "ProductID", "产品号");
col.Insert(1, "ProductTitle", "产品描述");
col.Insert(2, "Category1Name", "产品一级类");
col.Insert(3, "Category2Name", "产品二级类");
col.Insert(4, "Category3Name", "产品三级类");
col.Insert(5, "FirstOnlineTime", "上架时间");
col.Insert(6, "EditDate", "更新时间");
col.Insert(7, "Status", "状态");
facade.ExprotExecl(model, new ColumnSet[] { col });
}
private void DataGrid_QueryResult_ExportAllClick(object sender, EventArgs e)
{
if (lastQueryVM == null || this.DataGrid_QueryResult.TotalCount <= 0)
{
Window.Alert(ResCommon.Message_NoData2Export);
return;
}
ColumnSet col = new ColumnSet(this.DataGrid_QueryResult);
col.Remove("SapImportedStatusDesc");
col.Insert(2, "Status", ResInvoiceInputQuery.Grid_Status, 10)
.SetWidth("VendorName", 40);
facade.ExportExcelFile(lastQueryVM, new ColumnSet[] { col });
}
/// <summary>
/// 导出报表数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgQueryResult_ExportAllClick(object sender, EventArgs e)
{
if (!AuthMgr.HasFunctionPoint(AuthKeyConst.EIMS_AccruedByPM_Export))
{
Window.Alert(ResEIMSAccrued.Msg_HasNoRight);
return;
}
if (dgQueryResult.ItemsSource != null)
{
m_queryRequest.PagingInfo = new PagingInfo()
{
PageSize = ConstValue.MaxRowCountLimit,
PageIndex = 0,
SortBy = string.Empty
};
AccruedReportFacade facade = new AccruedReportFacade(this);
ColumnSet col = new ColumnSet(dgQueryResult);
col.Insert(3, "curAccruedAmount", "当期返利_应计金额", 20);
col.Insert(4, "AccruedAmountTax", "当期返利_税金", 20);
col.Insert(5, "AccruedAmount", "当期返利_总额", 20);
col.Insert(6, "ReceivedPO", "已收返利金额(含税金额)_PO单扣减", 20);
col.Insert(7, "ReceivedConsign", "已收返利金额(含税金额)_代销结算单扣减", 20);
col.Insert(8, "ReceivedCash", "已收返利金额(含税金额)_现金", 20);
col.Insert(9, "ReceivedAcctDeduct", "已收返利金额(含税金额)_帐扣", 20);
col.Insert(10, "ReceivedVoteBuckle", "已收返利金额(含税金额)_票扣", 20);
col.Insert(11, "ReceivedAmount", "已收返利金额(含税金额)_总计", 20);
facade.ExportAccruedByPM(m_queryRequest, new ColumnSet[] { col });
}
else
{
Window.Alert(ResEIMSAccrued.Msg_PleaseQueryData);
return;
}
}
private void dataGridSo_ExportAllClick(object sender, EventArgs e)
{
if (this.dataGridSo.ItemsSource == null || this.dataGridSo.TotalCount == 0)
{
Window.Alert(ResCustomerCalingQuery.Msg_NoData);
return;
}
InitExportFilter();
ColumnSet col = new ColumnSet(this.dataGridSo);
col.Insert(0, "SOID", ResCustomerCalingQuery.Grid_So_SoSysNo, 15);
col.SetWidth("CustomerID", 20);
col.SetWidth("IsFPSO", 15);
col.SetWidth("TotalAmount", 15);
col.SetWidth("UpdatedMan", 20);
facade.ExportSOList(filter, new ColumnSet[] { col });
}
/// <summary>
/// 导出所有数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgQueryResult_ExportAllClick(object sender, EventArgs e)
{
if (!AuthMgr.HasFunctionPoint(AuthKeyConst.EIMS_Comprehensive_Export))
{
Window.Alert(ResEIMSComprehensive.Msg_HasNoRight);
return;
}
if (dgQueryResult.ItemsSource == null)
{
Window.Alert(ResEIMSComprehensive.Msg_PleaseQueryData);
return;
}
m_queryRequest.PagingInfo = new PagingInfo()
{
PageSize = ConstValue.MaxRowCountLimit,
PageIndex = 0,
SortBy = string.Empty
};
ComprehensiveReportFacade facade = new ComprehensiveReportFacade(this);
ColumnSet col = new ColumnSet(dgQueryResult);
col.Insert(9, "BeginBalanceAccrued", "期初余额_应计金额", 20);
col.Insert(10, "BeginBalanceTax", "期初余额_税金", 20);
col.Insert(11, "BeginBalance", "期初余额_总额", 20);
col.Insert(12, "EndBalanceAccrued", "期末余额_应计金额", 20);
col.Insert(13, "EndBalanceTax", "期末余额_税金", 20);
col.Insert(14, "EndBalance", "期末余额_总额", 20);
col.Insert(20, "InvoiceAmountAccrued", "单据金额_应计金额", 20);
col.Insert(21, "InvoiceAmountTax", "单据金额_税金", 20);
col.Insert(22, "InvoiceAmount", "单据金额_总额", 20);
facade.ExportComprehensive(m_queryRequest, new ColumnSet[] { col });
}
private void DataGrid_RMAItem_ResultList_ExportAllClick(object sender, EventArgs e)
{
if (lastQueryVM == null || this.DataGrid_RMAItem_ResultList.TotalCount < 1)
{
Window.Alert(ResRMAReports.Msg_ExportError);
return;
}
if (this.DataGrid_RMAItem_ResultList.TotalCount > 10000)
{
Window.Alert(ResRMAReports.Msg_ExportExceedsLimitCount);
return;
}
ColumnSet col = new ColumnSet(this.DataGrid_RMAItem_ResultList);
col.Insert(0, "SysNo", ResRMAReports.Excel_RegisterSysNo, 12)
.SetWidth("ProductID", 15)
.SetWidth("ProductName", 48);
facade.ExportRMAItemExcelFile(lastQueryVM, new ColumnSet[] { col });
}
private void btnExcelOutput_Click(object sender, RoutedEventArgs e)
{
ColumnSet col = new ColumnSet();
col.Insert(0, "CategoryInfo.CategoryName.Content", "类别", 15)
.Insert(1, "Manufacturer.ManufacturerNameLocal.Content", "生产商", 15)
.Insert(2, "Brand.BrandNameLocal.Content", "品牌", 20)
.Insert(3, "ProductGroupMode", "型号系列", 25)
.Insert(4, "ProductName", "商品名称", 25)
.Insert(5, "ProductModel", "具体型号", 25)
.Insert(6, "SellerName", "供应商", 25)
.Insert(7, "PMUser.UserDisplayName", "PM", 25)
.Insert(8, "SellerSite", "厂商链接", 25)
.Insert(9, "VirtualPrice", "泰隆优选供价", 25)
.Insert(10, "CurrentPrice", "泰隆优选售价", 25)
.Insert(11, "Margin", "毛利率(不含优惠券赠品)", 25)
.Insert(12, "BasicPrice", "线下市场价", 25)
.Insert(13, "IsConsign", "代销属性", 25)
.Insert(14, "IsTakePictures", "是否拍照", 25)
.Insert(15, "Keywords", "搜索关键字", 25)
.Insert(16, "Weight", "重量（单位：g）", 25)
.Insert(17, "Length", "包装尺寸（长度，单位：mm）", 25)
.Insert(18, "Width", "包装尺寸（宽度，单位：mm）", 25)
.Insert(19, "PackageList", "包装清单", 25)
.Insert(20, "HostWarrantyDay", "主件保修期（天）", 25)
.Insert(21, "PartWarrantyDay", "附件保修期（天）", 25)
.Insert(22, "Warranty", "保修细则", 25)
.Insert(23, "ServicePhone", "厂商售后电话", 25)
.Insert(24, "MinPackNumber", "最小包装数量", 25)
.Insert(25, "Note", "备注", 25);
model = (SellerProductRequestQueryVM)this.DataContext;
var facade = new SellerProductRequestQueryFacade(this);
facade.ExportSellerProductRequestExcelFile(model, new ColumnSet[] { col });
}
private void QueryResultGrid_ExportAllClick(object sender, EventArgs e)
{
//权限控制:
if (!AuthMgr.HasFunctionPoint(AuthKeyConst.PO_VendorRefund_Export))
{
Window.Alert("对不起，你没有权限进行此操作!");
return;
}
//导出全部:
if (null != queryFilter)
{
VendorRMARefundQueryFilter exportQueryRequest = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <VendorRMARefundQueryFilter>(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.Insert(1, "Status", ResVendorRMARefundQuery.GridHeader_Status);
serviceFacade.ExportExcelForVendorRMARefundList(exportQueryRequest, new ColumnSet[] { columnSet });
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnExcelExporter_Click(object sender, RoutedEventArgs e)
{
dynamic d = this.ProductAccessoriesResult.SelectedItem as dynamic;
bool IsTreeQuery = d.IsTreeQuery == "Y";
ColumnSet col = new ColumnSet();
List <ProductAccessoriesQueryConditionVM> ConditionList = new List <ProductAccessoriesQueryConditionVM>();
//根据SysNo得到所有条件，动态生成列名
facade.GetAccessoriesQueryConditionBySysNo((int)d.SysNo, (obj, arg) =>
{
if (arg.FaultsHandle())
{
return;
}
foreach (var item in arg.Result.Rows)
{
ConditionList.Add(new ProductAccessoriesQueryConditionVM()
{
Condition = new AccessoriesQueryCondition()
{
ConditionName = item.ConditionName, Priority = (PriorityType)item.Level, SysNo = item.SysNo
},
ParentCondition = new AccessoriesQueryCondition()
{
ConditionName = item.ParentConditionName, SysNo = item.ParentSysNo
},
Priority = (PriorityType)item.Level
});
}
int index = 0;
if (IsTreeQuery)
{
foreach (var item in ConditionList)
{
string title = item.Condition.ConditionName + "编号";
if (index == 0)
{
col.Insert(0, "FirstSysNo", title, 15);
col.Insert(1, "FirstValue", item.Condition.ConditionName, 25);
}
if (index == 1)
{
col.Insert(2, "SecondSysNo", title, 15);
col.Insert(3, "SecondValue", item.Condition.ConditionName, 25);
}
if (index == 2)
{
col.Insert(4, "ThirdSysNo", title, 15);
col.Insert(5, "ThirdValue", item.Condition.ConditionName, 25);
}
if (index == 3)
{
col.Insert(6, "FourthSysNo", title, 15);
col.Insert(7, "FourthValue", item.Condition.ConditionName, 25);
}
index = index + 1;
}
}
else
{
col.Insert(0, "ConditionSysNo", "条件编号");
col.Insert(1, "ConditionName", "条件");
col.Insert(2, "ConditionValueSysNo", "选项值编号");
col.Insert(3, "ConditionValue", "选项值");
col.Insert(4, "Producut", "商品");
}
if (ConditionList.Count > 0 && IsTreeQuery)
{
col.Insert(ConditionList.Count * 2, "Producut", "商品");
}
facade.GetAccessoriesQueryExcelOutput((int)d.SysNo, (string)d.IsTreeQuery, new ColumnSet[] { col });
});
}
/// <summary>
/// 导出报表数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgQueryResult_ExportAllClick(object sender, EventArgs e)
{
if (!AuthMgr.HasFunctionPoint(AuthKeyConst.EIMS_ReceiveByYear_Export))
{
Window.Alert(ResEIMSReceiveReport.Msg_HasNoRight);
return;
}
if (dgQueryResult.ItemsSource == null)
{
Window.Alert(ResEIMSReceiveReport.Msg_PleaseQueryData);
return;
}
m_queryRequest.PagingInfo = new PagingInfo()
{
PageSize = ConstValue.MaxRowCountLimit,
PageIndex = 0,
SortBy = string.Empty
};
ReceivedReportFacade facade = new ReceivedReportFacade(this);
ColumnSet col = new ColumnSet();
col.Insert(0, "VendorNumber", "供应商编号", 10);
col.Insert(1, "VendorName", "供应商名称", 25);
col.Insert(2, "TotalReceiveAmount", "总收款金额", 25);
col.Insert(3, "RAJanuary", "1月", 10);
col.Insert(4, "RAFebruary", "2月", 10);
col.Insert(5, "RAMarch", "3月", 10);
col.Insert(6, "RAApril", "4月", 10);
col.Insert(7, "RAMay", "5月", 10);
col.Insert(8, "RAJune", "6月", 10);
col.Insert(9, "RAJuly", "7月", 10);
col.Insert(10, "RAAugust", "8月", 10);
col.Insert(11, "RASeptember", "9月", 10);
col.Insert(12, "RAOctober", "10月", 10);
col.Insert(13, "RANovember", "11月", 10);
col.Insert(14, "RADecember", "12月", 10);
facade.ExportReceiveByYear(m_queryRequest, new ColumnSet[] { col });
}