/// <summary>
/// 导出Excel模版
/// </summary>
/// <returns></returns>
public ActionResult ExportExcel(string productType)
{
var zhName = new VendorProductCommonManager().GetZhNameByProductType(productType);
var workbook = new XSSFWorkbook();
var sheet = workbook.CreateSheet();
var row = sheet.CreateRow(0);
var cellNum = 0;
row.CreateCell(cellNum++).SetCellValue("省份名称");
row.CreateCell(cellNum++).SetCellValue("城市名称");
row.CreateCell(cellNum++).SetCellValue("区域名称");
row.CreateCell(cellNum++).SetCellValue("品牌");
row.CreateCell(cellNum++).SetCellValue("是否启用TRUE/FALSE");
row.CreateCell(cellNum).SetCellValue("备注(选填)");
cellNum = 0;
sheet.SetColumnWidth(cellNum++, 10 * 256);
sheet.SetColumnWidth(cellNum++, 10 * 256);
sheet.SetColumnWidth(cellNum++, 10 * 256);
sheet.SetColumnWidth(cellNum++, 14 * 256);
sheet.SetColumnWidth(cellNum++, 20 * 256);
sheet.SetColumnWidth(cellNum, 28 * 256);
var ms = new MemoryStream();
workbook.Write(ms);
return(File(ms.ToArray(), "application/x-xls", $"{zhName}覆盖区域模版 {DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒")}.xlsx"));
}
public async Task <JsonResult> GetAllBrands(string productType)
{
var manager = new VendorProductCommonManager();
var managerResult = await manager.GetAllBrandsFromCache(productType);
return(Json(new { Status = managerResult.Item1 != null, Data = managerResult.Item1, Msg = managerResult.Item2 },
JsonRequestBehavior.AllowGet));
}
