/// <summary> /// 查询蓄电池券后价展示配置 /// </summary> /// <param name="brand"></param> /// <returns></returns> public async Task <ActionResult> SelectConfig(string brand) { var manager = new BatteryCouponPriceDisplayManager(User.Identity.Name); var result = await manager.SelectBatteryCouponPriceDisplay(brand); return(Json(new { Status = result != null, Data = result }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> ExportExcel(string brand) { var workbook = new XSSFWorkbook(); var sheet = workbook.CreateSheet(); var row = sheet.CreateRow(0); var cellNum = 0; row.CreateCell(cellNum++).SetCellValue("商品PID"); row.CreateCell(cellNum++).SetCellValue("商品名称"); row.CreateCell(cellNum++).SetCellValue("券后价"); row.CreateCell(cellNum++).SetCellValue("可用券"); row.CreateCell(cellNum).SetCellValue("是否展示券后价"); cellNum = 0; sheet.SetColumnWidth(cellNum++, 14 * 256); sheet.SetColumnWidth(cellNum++, 28 * 256); sheet.SetColumnWidth(cellNum++, 8 * 256); sheet.SetColumnWidth(cellNum++, 18 * 256); sheet.SetColumnWidth(cellNum, 5 * 256); var manager = new BatteryCouponPriceDisplayManager(User.Identity.Name); var result = await manager.SelectBatteryCouponPriceDisplay(brand); if (result != null && result.Any()) { int modelRowCount = 1; foreach (var model in result) { int modelCol = 0; var modelRow = sheet.CreateRow(modelRowCount); modelRow.CreateCell(modelCol++).SetCellValue(model.Pid); modelRow.CreateCell(modelCol++).SetCellValue(model.DisplayName); modelRow.CreateCell(modelCol++).SetCellValue((double)model.Price); modelRow.CreateCell(modelCol++).SetCellValue(string.Join(",", model.Coupons)); modelRow.CreateCell(modelCol).SetCellValue(model.IsShow ? "是" : "否"); modelRowCount++; } } var ms = new MemoryStream(); workbook.Write(ms); return(File(ms.ToArray(), "application/x-xls", $"{brand}蓄电池券后价查询 {DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒")}.xlsx")); }