public Paras CreateCashFile([FromBody] Paras paras)
{
string webRootPath = _hostingEnvironment.WebRootPath;
var addrUrl = webRootPath + $@"\temp\{paras.FileName}";
if (System.IO.File.Exists(addrUrl))
{
System.IO.File.Delete(addrUrl);
}
string sqlstring = $"Select * from {paras.ViewName} where {paras.Where}";
var dataList = _context.Set <CashBill>().FromSql(sqlstring).ToList();
//创建Excel文件的对象
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
//添加一个sheet
NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1");
//获取list数据
NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
row1.CreateCell(0).SetCellValue("单号");
row1.CreateCell(1).SetCellValue("状态");
row1.CreateCell(2).SetCellValue("开票日期");
row1.CreateCell(3).SetCellValue("购买性质");
row1.CreateCell(4).SetCellValue("购买资质");
row1.CreateCell(5).SetCellValue("客户属性");
row1.CreateCell(6).SetCellValue("付款方式");
row1.CreateCell(7).SetCellValue("保险公司");
row1.CreateCell(8).SetCellValue("优惠金额");
row1.CreateCell(9).SetCellValue("新车款金额");
row1.CreateCell(10).SetCellValue("分期首付款金额");
row1.CreateCell(11).SetCellValue("保险费金额");
row1.CreateCell(12).SetCellValue("购置税金额");
row1.CreateCell(13).SetCellValue("金融服务费金额");
row1.CreateCell(14).SetCellValue("装饰费金额");
row1.CreateCell(15).SetCellValue("交车综合服务费");
row1.CreateCell(16).SetCellValue("安心服务费");
row1.CreateCell(17).SetCellValue("贴心服务费");
row1.CreateCell(18).SetCellValue("玻璃保障服务费");
row1.CreateCell(19).SetCellValue("刷卡费金额");
row1.CreateCell(20).SetCellValue("其他金额");
row1.CreateCell(21).SetCellValue("应收金额总计");
row1.CreateCell(22).SetCellValue("开票金额");
row1.CreateCell(23).SetCellValue("已付订金");
row1.CreateCell(24).SetCellValue("旧车置换金额");
row1.CreateCell(25).SetCellValue("金融分期尾款金额");
row1.CreateCell(26).SetCellValue("其他金额");
row1.CreateCell(27).SetCellValue("实收金额总计");
row1.CreateCell(28).SetCellValue("保险费");
row1.CreateCell(29).SetCellValue("装修费");
row1.CreateCell(30).SetCellValue("佣金");
row1.CreateCell(31).SetCellValue("维修费");
row1.CreateCell(32).SetCellValue("汽油费");
row1.CreateCell(33).SetCellValue("其他");
row1.CreateCell(34).SetCellValue("审核人");
row1.CreateCell(35).SetCellValue("审核结果");
row1.CreateCell(36).SetCellValue("审核意见");
row1.CreateCell(37).SetCellValue("审核时间");
row1.CreateCell(38).SetCellValue("备注");
//将数据逐步写入sheet1各个行
for (int i = 0; i < dataList.Count; i++)
{
NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1);
rowtemp.CreateCell(0).SetCellValue(dataList[i].OrderId);
rowtemp.CreateCell(1).SetCellValue(dataList[i].Status);
rowtemp.CreateCell(2).SetCellValue(dataList[i].InvoiceDate);
rowtemp.CreateCell(3).SetCellValue(dataList[i].BuyType);
rowtemp.CreateCell(4).SetCellValue(dataList[i].BuyLicense);
rowtemp.CreateCell(5).SetCellValue(dataList[i].CustAttr);
rowtemp.CreateCell(6).SetCellValue(dataList[i].PayType);
rowtemp.CreateCell(7).SetCellValue(dataList[i].InsureCompany);
rowtemp.CreateCell(8).SetCellValue(dataList[i].Discount);
rowtemp.CreateCell(9).SetCellValue((double)dataList[i].NewCarFee);
rowtemp.CreateCell(10).SetCellValue((double)dataList[i].FirstFee);
rowtemp.CreateCell(11).SetCellValue((double)dataList[i].InsureFee);
rowtemp.CreateCell(12).SetCellValue((double)dataList[i].BuyTaxFee);
rowtemp.CreateCell(13).SetCellValue((double)dataList[i].FinanceSerFee);
rowtemp.CreateCell(14).SetCellValue((double)dataList[i].DecorateFee);
rowtemp.CreateCell(15).SetCellValue((double)dataList[i].TakeAllFee);
rowtemp.CreateCell(16).SetCellValue((double)dataList[i].TakeCareFee);
rowtemp.CreateCell(17).SetCellValue((double)dataList[i].IntimateFee);
rowtemp.CreateCell(18).SetCellValue((double)dataList[i].GlassSerFee);
rowtemp.CreateCell(19).SetCellValue((double)dataList[i].CardCashFee);
rowtemp.CreateCell(20).SetCellValue((double)dataList[i].OtherFee);
rowtemp.CreateCell(21).SetCellValue((double)dataList[i].ShouldAllFee);
rowtemp.CreateCell(22).SetCellValue((double)dataList[i].InvoiceFee);
rowtemp.CreateCell(23).SetCellValue((double)dataList[i].Deposit);
rowtemp.CreateCell(24).SetCellValue((double)dataList[i].OldChangeFee);
rowtemp.CreateCell(25).SetCellValue((double)dataList[i].LastFee);
rowtemp.CreateCell(26).SetCellValue((double)dataList[i].OtherFee2);
rowtemp.CreateCell(27).SetCellValue((double)dataList[i].RealAllFee);
rowtemp.CreateCell(28).SetCellValue((double)dataList[i].BaoxianFee);
rowtemp.CreateCell(29).SetCellValue((double)dataList[i].ZhuangxFee);
rowtemp.CreateCell(30).SetCellValue((double)dataList[i].Commission);
rowtemp.CreateCell(31).SetCellValue((double)dataList[i].MaintainFee);
rowtemp.CreateCell(32).SetCellValue((double)dataList[i].GasFee);
rowtemp.CreateCell(33).SetCellValue((double)dataList[i].OtherFee3);
rowtemp.CreateCell(34).SetCellValue(dataList[i].Auditor);
rowtemp.CreateCell(35).SetCellValue(dataList[i].AuditResult);
rowtemp.CreateCell(36).SetCellValue(dataList[i].AuditSuggest);
rowtemp.CreateCell(37).SetCellValue(dataList[i].AuditTime);
rowtemp.CreateCell(38).SetCellValue(dataList[i].Remark);
}
// 写入到客户端
using (FileStream fs = new FileStream(addrUrl, FileMode.Create))
{
book.Write(fs);
}
book = null;
return(paras);
}
public virtual IEnumerable <T> GetAll()
{
return(_context.Set <T>().AsEnumerable());
}