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