private async void ExportExcel()
{
if (WebSiteCashierSearchDtos == null || !WebSiteCashierSearchDtos.Any())
{
await MvvmUtility.ShowMessageAsync("没有要导出的对账明细");
return;
}
var columnDefinitions = new List <ColumnDefinition <WebSiteCashierSearchDto> >
{
new ColumnDefinition <WebSiteCashierSearchDto>("门店", dto => dto.StoreName),
new ColumnDefinition <WebSiteCashierSearchDto>("订单号", dto => dto.OrderNo),
new ColumnDefinition <WebSiteCashierSearchDto>("渠道订单号", dto => dto.OrderChannelNo),
new ColumnDefinition <WebSiteCashierSearchDto>("销售单号", dto => dto.SalesOrderNo),
new ColumnDefinition <WebSiteCashierSearchDto>("支付方式", dto => dto.PaymentMethodName),
new ColumnDefinition <WebSiteCashierSearchDto>("订单来源", dto => dto.OrderSouce),
new ColumnDefinition <WebSiteCashierSearchDto>("购买时间", dto => dto.BuyDate),
new ColumnDefinition <WebSiteCashierSearchDto>("门店", dto => dto.StoreName),
new ColumnDefinition <WebSiteCashierSearchDto>("品牌", dto => dto.Brand),
new ColumnDefinition <WebSiteCashierSearchDto>("款号", dto => dto.StyleNo),
new ColumnDefinition <WebSiteCashierSearchDto>("规格", dto => dto.Size),
new ColumnDefinition <WebSiteCashierSearchDto>("色码", dto => dto.Color),
new ColumnDefinition <WebSiteCashierSearchDto>("数量", dto => dto.Count),
new ColumnDefinition <WebSiteCashierSearchDto>("零售价", dto => dto.LabelPrice),
new ColumnDefinition <WebSiteCashierSearchDto>("销售价", dto => dto.SalePrice),
new ColumnDefinition <WebSiteCashierSearchDto>("销售金额", dto => dto.SaleTotalPrice),
new ColumnDefinition <WebSiteCashierSearchDto>("专柜码", dto => dto.SectionCode),
new ColumnDefinition <WebSiteCashierSearchDto>("收银流水号", dto => dto.CashNum),
new ColumnDefinition <WebSiteCashierSearchDto>("退货收银流水号", dto => dto.RmaCashNum)
};
ExcelUtility.Export(WebSiteCashierSearchDtos, columnDefinitions, "对账明细");
}
private async void OnExport()
{
if (StatisticsDtos == null || !StatisticsDtos.Any())
{
await MvvmUtility.ShowMessageAsync("没有要导出的佣金明细");
return;
}
var columnDefinitions = new List <ColumnDefinition <CashedCommissionStatisticsDto> >
{
new ColumnDefinition <CashedCommissionStatisticsDto>("门店", dto => dto.StoreName),
new ColumnDefinition <CashedCommissionStatisticsDto>("专柜名称", dto => dto.SectionName),
new ColumnDefinition <CashedCommissionStatisticsDto>("专柜码", dto => dto.SectionCode),
new ColumnDefinition <CashedCommissionStatisticsDto>("迷你银账号", dto => dto.MiniSilverNo),
new ColumnDefinition <CashedCommissionStatisticsDto>("提取时间", dto => dto.PickUpDate),
new ColumnDefinition <CashedCommissionStatisticsDto>("提取金额", dto => dto.PickUpAmount),
new ColumnDefinition <CashedCommissionStatisticsDto>("提取人", dto => dto.PickUpPerson),
new ColumnDefinition <CashedCommissionStatisticsDto>("提取人联系方式", dto => dto.Contact),
new ColumnDefinition <CashedCommissionStatisticsDto>("所属银行", dto => dto.BankName),
new ColumnDefinition <CashedCommissionStatisticsDto>("银行卡号", dto => dto.BankCardNo),
new ColumnDefinition <CashedCommissionStatisticsDto>("手续费", dto => dto.Fee),
new ColumnDefinition <CashedCommissionStatisticsDto>("税金", dto => dto.Taxes)
};
ExcelUtility.Export(StatisticsDtos, columnDefinitions, "已提取佣金明细");
}
private void OnExport()
{
if (SaleList == null || !SaleList.Any())
{
MvvmUtility.ShowMessageAsync("没有要导出的销售单");
return;
}
var columnDefinitions = new List <ColumnDefinition <SaleDto> >
{
new ColumnDefinition <SaleDto>("订单号", dto => dto.OrderNo),
new ColumnDefinition <SaleDto>("销售单号", dto => dto.SaleOrderNo),
new ColumnDefinition <SaleDto>("渠道订单号", dto => dto.TransNo),
new ColumnDefinition <SaleDto>("订单渠道", dto => dto.OrderSource),
new ColumnDefinition <SaleDto>("销售状态", dto => dto.SaleStatus),
new ColumnDefinition <SaleDto>("销售单状态", dto => dto.StatusName),
new ColumnDefinition <SaleDto>("收银状态", dto => dto.CashStatusName),
new ColumnDefinition <SaleDto>("销售时间", dto => dto.SellDate),
new ColumnDefinition <SaleDto>("销售单金额", dto => dto.SalesAmount),
new ColumnDefinition <SaleDto>("销售单数量", dto => dto.SalesCount),
new ColumnDefinition <SaleDto>("门店", dto => dto.StoreName),
new ColumnDefinition <SaleDto>("收银流水号", dto => dto.CashNum),
new ColumnDefinition <SaleDto>("收银时间", dto => dto.CashDate)
};
ExcelUtility.Export(SaleList, columnDefinitions, "销售单");
}
private async void OnExport()
{
if (StatisticsDtos == null || !StatisticsDtos.Any())
{
await MvvmUtility.ShowMessageAsync("没有要导出的礼品卡销售明细");
return;
}
var columnDefinitions = new List <ColumnDefinition <GiftCardStatisticsDto> >
{
new ColumnDefinition <GiftCardStatisticsDto>("礼品卡编号", dto => dto.GiftCardNo),
new ColumnDefinition <GiftCardStatisticsDto>("渠道订单号", dto => dto.TransNo),
new ColumnDefinition <GiftCardStatisticsDto>("支付方式", dto => dto.PaymentMethodName),
new ColumnDefinition <GiftCardStatisticsDto>("购买时间", dto => dto.BuyDate),
new ColumnDefinition <GiftCardStatisticsDto>("门店", dto => dto.StoreName),
new ColumnDefinition <GiftCardStatisticsDto>("金额", dto => dto.Amount),
new ColumnDefinition <GiftCardStatisticsDto>("销售金额", dto => dto.SalesAmount),
new ColumnDefinition <GiftCardStatisticsDto>("是否充值", dto => dto.Recharge)
};
ExcelUtility.Export(StatisticsDtos, columnDefinitions, "礼品卡销售明细");
}
private async void OnExport()
{
if (StatisticsDtos == null || !StatisticsDtos.Any())
{
await MvvmUtility.ShowMessageAsync("没有要导出的佣金明细");
return;
}
var columnDefinitions = new List <ColumnDefinition <UncashedCommissionStatisticsDto> >
{
new ColumnDefinition <UncashedCommissionStatisticsDto>("门店", dto => dto.StoreName),
new ColumnDefinition <UncashedCommissionStatisticsDto>("专柜名称", dto => dto.SectionName),
new ColumnDefinition <UncashedCommissionStatisticsDto>("专柜码", dto => dto.SectionCode),
new ColumnDefinition <UncashedCommissionStatisticsDto>("迷你银账号", dto => dto.MiniSilverNo),
new ColumnDefinition <UncashedCommissionStatisticsDto>("联系方式", dto => dto.Contact),
new ColumnDefinition <UncashedCommissionStatisticsDto>("未提现金额", dto => dto.NoPickUpAmount),
new ColumnDefinition <UncashedCommissionStatisticsDto>("不可提现金额", dto => dto.LockedPickUpAmount),
new ColumnDefinition <UncashedCommissionStatisticsDto>("申请中金额", dto => dto.ApplicationPickUpAmount)
};
ExcelUtility.Export(StatisticsDtos, columnDefinitions, "未提取佣金明细");
}
private async void ExportExcel()
{
if (WebSiteReturnGoodsStatisticsDtos == null || !WebSiteReturnGoodsStatisticsDtos.Any())
{
await MvvmUtility.ShowMessageAsync("没有要导出的退货明细");
return;
}
var columnDefinitions = new List <ColumnDefinition <WebSiteReturnGoodsStatisticsDto> >
{
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("退货单号", dto => dto.RMANo),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("订单号", dto => dto.OrderNo),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("渠道订单号", dto => dto.OrderChannelNo),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("支付方式", dto => dto.PaymentMethodName),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("订单来源", dto => dto.OrderSouce),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("退货状态", dto => dto.RmaStatusName),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("购买时间", dto => dto.BuyDate),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("门店", dto => dto.StoreName),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("品牌", dto => dto.Brand),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("款号", dto => dto.StyleNo),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("规格", dto => dto.Size),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("色码", dto => dto.Color),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("退货数量", dto => dto.ReturnGoodsCount),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("零售价", dto => dto.LabelPrice),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("销售价", dto => dto.SalePrice),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("退货总金额", dto => dto.RmaAmount),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("专柜码", dto => dto.SectionCode),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("退货时间", dto => dto.RmaDate),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("退货申请时间", dto => dto.ApplyRmaDate),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("运费", dto => dto.OrderTransFee),
new ColumnDefinition <WebSiteReturnGoodsStatisticsDto>("销售编码", dto => dto.SalesCode)
};
ExcelUtility.Export(WebSiteReturnGoodsStatisticsDtos, columnDefinitions, "退货明细");
}
