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