/// <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"));
}