/// <summary>
/// 下载excel-轮胎pid列表
/// </summary>
/// <returns></returns>
public ActionResult ExportExcelTireActivity(int tireActivityID)
{
var workbook = new XSSFWorkbook();
var sheet = workbook.CreateSheet();
var index = 0;
var row = sheet.CreateRow(index++);
var num = 0;
row.CreateCell(num++).SetCellValue("PID");
num = 0;
sheet.SetColumnWidth(num++, 16 * 256);
var exm = new TireActivityManage();
var list = exm.GetTireActivityPIDList(tireActivityID);
foreach (var item in list)
{
row = sheet.CreateRow(index++);
num = 0;
row.CreateCell(num++).SetCellValue(item.PID);
}
var ms = new MemoryStream();
workbook.Write(ms);
var model = TireActivityManager.GetTireActivityModel(tireActivityID);
#region 日志记录
using (var client = new ConfigLogClient())
{
var response = client.InsertDefaultLogQueue("CommonConfigLog", JsonConvert.SerializeObject(new
{
ObjectId = tireActivityID,
ObjectType = "TireActivity",
BeforeValue = JsonConvert.SerializeObject(model),
AfterValue = JsonConvert.SerializeObject(model),
Remark = "下载",
Creator = User.Identity.Name,
}));
}
#endregion
//等待1秒，写库同步到读库
Thread.Sleep(1000);
return(File(ms.ToArray(), "application/x-xls", $"轮胎活动列表-{DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒")}.xlsx"));
}
/// <summary>
/// 下载每一次上传的excel
/// </summary>
/// <param name="updateID"></param>
/// <returns></returns>
public ActionResult ExportEachExcel(int updateID)
{
var workbook = new XSSFWorkbook();
var sheet = workbook.CreateSheet();
var index = 0;
var row = sheet.CreateRow(index++);
var num = 0;
row.CreateCell(num++).SetCellValue("小保养套餐PID");
row.CreateCell(num++).SetCellValue("原价");
row.CreateCell(num++).SetCellValue("一条轮胎优惠价");
row.CreateCell(num++).SetCellValue("二条轮胎优惠价");
row.CreateCell(num++).SetCellValue("三条轮胎优惠价");
row.CreateCell(num++).SetCellValue("四条轮胎优惠价");
num = 0;
sheet.SetColumnWidth(num++, 16 * 256);
sheet.SetColumnWidth(num++, 16 * 256);
sheet.SetColumnWidth(num++, 16 * 256);
sheet.SetColumnWidth(num++, 16 * 256);
sheet.SetColumnWidth(num++, 16 * 256);
sheet.SetColumnWidth(num++, 16 * 256);
var exm = new TireActivityManage();
var paklist = exm.GetEachMaintenancePackageList(updateID);
var validPackgeList = paklist.GroupBy(x => new { x.PID }).Select(x => x.OrderBy(y => y.PKID).Last()).ToList();
foreach (var item in validPackgeList)
{
row = sheet.CreateRow(index++);
num = 0;
row.CreateCell(num++).SetCellValue(item.PID);
row.CreateCell(num++).SetCellValue((double)item.Price);
row.CreateCell(num++).SetCellValue((double)item.OnetirePrice);
row.CreateCell(num++).SetCellValue((double)item.TwotirePrice);
row.CreateCell(num++).SetCellValue((double)item.ThreetirePrice);
row.CreateCell(num++).SetCellValue((double)item.FourtirePrice);
}
var ms = new MemoryStream();
workbook.Write(ms);
return(File(ms.ToArray(), "application/x-xls", $"小保养套餐优惠价格列表-{DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒")}.xlsx"));
}
