public async Task <ActionResult> GenerateServiceCode(int packageDetailId) { var isSuccess = false; var msg = string.Empty; var serviceCodes = BeautyServicePackageManager.GetBeautyServicePackageDetailCodesByPackageDetailId(packageDetailId); if (serviceCodes != null && serviceCodes.Any()) { msg = "之前已经生成服务码了"; } else { isSuccess = await BeautyServicePackageManager.GenerateServiceCodes(packageDetailId); if (!isSuccess) { msg = "生成服务码失败"; } else { isSuccess = true; msg = "服务码生成成功"; } } return(Json(new { IsSuccess = isSuccess, Msg = msg }, JsonRequestBehavior.AllowGet)); }
public FileResult ExportServiceCodes(int packageDetailId, string name) { var serviceCodes = BeautyServicePackageManager.GetBeautyServicePackageDetailCodesByPackageDetailId(packageDetailId); var workbook = new XSSFWorkbook(); var sheet = workbook.CreateSheet(); var row = sheet.CreateRow(0); var cell = null as ICell; var cellNum = 0; #region title row.CreateCell(cellNum++).SetCellValue("服务码"); row.CreateCell(cellNum++).SetCellValue("开始时间"); row.CreateCell(cellNum++).SetCellValue("结束时间"); cellNum = 0; sheet.SetColumnWidth(cellNum++, 20 * 256); sheet.SetColumnWidth(cellNum++, 20 * 256); sheet.SetColumnWidth(cellNum++, 20 * 256); #endregion #region content if (serviceCodes != null && serviceCodes.Any()) { var i = 0; foreach (var item in serviceCodes) { cellNum = 0; row = sheet.CreateRow(i + 1); row.CreateCell(cellNum++).SetCellValue(item.ServiceCode); row.CreateCell(cellNum++).SetCellValue(item.StartTime.ToString("yyyyMMdd")); row.CreateCell(cellNum++).SetCellValue(item.EndTime.ToString("yyyyMMdd")); i++; } } #endregion var ms = new MemoryStream(); workbook.Write(ms); return(File(ms.ToArray(), "application/x-xls", $"{name}_服务码_{DateTime.Now.ToString("yyyyMMdd HHmmss")}.xlsx")); }