public ActionResult OutFeeInfoToExecl(InFeeListFilterModel filterModel)
{
var model = ListExport(filterModel);
var titleList = new List <string> {
"WayBillNumber-运单号", "CustomerOrderNumber-客户订单号", "CustomerCode-客户代码", "InDateTime-收货时间",
"TrackingNumber-跟踪号", "ChineseName-发货国家", "InShippingName-运输方式", "SettleWeight-计费重量",
"Freight-运费", "Register-挂号费", "FuelCharge-燃油费", "Surcharge-附加费", "TotalFee-总费用"
};
ExportExcelByWeb.WriteToDownLoad(model.List, titleList, null);
return(View(model));
}
public ActionResult ToExecl(BillingViewModels param)
{
var viewModel = List(param.Filter);
var list = new List <BillingExecModel>();
viewModel.BillingList.InnerList.ForEach(p =>
{
var m = new BillingExecModel()
{
Balance = p.Balance,
CreatedOn = p.CreatedOn,
CustomerCode = p.CustomerCode,
MoneyChangeTypeShortName = p.MoneyChangeTypeShortName,
Remark = p.Remark,
SerialNumber = p.SerialNumber,
InCash = 0,
OutCash = 0
};
if (p.Amount.HasValue)
{
if (p.Amount.Value > 0)
{
m.InCash = p.Amount.Value;
}
else
{
m.OutCash = p.Amount.Value;
}
}
list.Add(m);
});
var titleList = new List <string> {
"CustomerCode-客户代码", "CreatedOn-日期", "MoneyChangeTypeShortName-费用类型", "Remark-费用说明", "InCash-进账金额", "OutCash-出账金额", "Balance-帐户结余"
};
ExportExcelByWeb.WriteToDownLoad(list, titleList, null);
return(View(viewModel));
}