/// <summary> /// 获取喷漆打折配置 /// </summary> /// <param name="servicePid"></param> /// <param name="carNoPrefix"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public ActionResult SelectPaintConfig(string servicePid, int packageId = 0, int pageIndex = 1, int pageSize = 20) { var manager = new PaintDiscountConfigManager(); var result = manager.SelectPaintDiscountConfig(packageId, servicePid, pageIndex, pageSize); return(Json(new { Status = result != null && result.Item1 != null, Data = result.Item1, TotalCount = result.Item2 }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出数据至Excel /// </summary> /// <returns></returns> public ActionResult ExportExcel() { var workbook = new XSSFWorkbook(); var sheet = workbook.CreateSheet(); var row = sheet.CreateRow(0); var cell = null as ICell; var cellNum = 0; row.CreateCell(cellNum++).SetCellValue("PID"); row.CreateCell(cellNum++).SetCellValue("面数"); 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++, 8 * 256); sheet.SetColumnWidth(cellNum++, 18 * 256); sheet.SetColumnWidth(cellNum++, 50 * 256); sheet.SetColumnWidth(cellNum++, 50 * 256); sheet.SetColumnWidth(cellNum++, 28 * 256); var manager = new PaintDiscountConfigManager(); var result = manager.SelectPaintDiscountConfig("", 1, 10000); if (result != null && result.Item1 != null && result.Item1.Any()) { int modelRowCount = 1; foreach (var model in result.Item1) { int modelCol = 0; var modelRow = sheet.CreateRow(modelRowCount); modelRow.CreateCell(modelCol++).SetCellValue(model.ServicePid); modelRow.CreateCell(modelCol++).SetCellValue(model.SurfaceCount); modelRow.CreateCell(modelCol++).SetCellValue((double)model.ActivityPrice); modelRow.CreateCell(modelCol++).SetCellValue(model.ActivityName); modelRow.CreateCell(modelCol++).SetCellValue(model.ActivityExplain); modelRow.CreateCell(modelCol++).SetCellValue(model.ActivityImage); modelRowCount++; } } var ms = new MemoryStream(); workbook.Write(ms); return(File(ms.ToArray(), "application/x-xls", $"喷漆打折配置 {DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒")}.xlsx")); }