/// <summary> /// 查询大客户专享活动券码列表 /// </summary> /// <param name="pageIndex">pageIndex</param> /// <param name="pageSize">pageSize</param> /// <param name="queryString">查询条件</param> /// <param name="customersSettingId">活动专享配置表PKID</param> /// <param name="activityExclusiveId">活动专享ID</param> /// <returns></returns> public JsonResult SelectCustomerCoupons(string queryString, string customersSettingId, string activityExclusiveId, int pageIndex = 1, int pageSize = 20) { var listCustomerCoupons = CustomersActivityManager.SelectCustomerCoupons(queryString, customersSettingId, activityExclusiveId, pageIndex, pageSize); int totalCount = CustomersActivityManager.SelectCustomerCouponCount(queryString, customersSettingId, activityExclusiveId); return(Json(new { data = listCustomerCoupons, totalCount = totalCount }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 根据条件导出客户活动券码信息 /// </summary> /// <param name="queryString"></param> /// <param name="customersSettingId"></param> /// <param name="activityExclusiveId"></param> /// <returns></returns> public FileResult ExportCustomerCoupon(string queryString, string customersSettingId, string activityExclusiveId) { #region Init var workBook = new XSSFWorkbook(); var sheet = workBook.CreateSheet(); var row = sheet.CreateRow(0); var cellNum = 0; row.CreateCell(cellNum++).SetCellValue("活动专享ID"); row.CreateCell(cellNum++).SetCellValue("活动券码"); row.CreateCell(cellNum++).SetCellValue("姓名"); row.CreateCell(cellNum++).SetCellValue("手机号"); row.CreateCell(cellNum++).SetCellValue("UserId"); row.CreateCell(cellNum++).SetCellValue("创建时间"); row.CreateCell(cellNum++).SetCellValue("修改时间"); row.CreateCell(cellNum++).SetCellValue("状态"); cellNum = 0; sheet.SetColumnWidth(cellNum++, 18 * 256); sheet.SetColumnWidth(cellNum++, 18 * 256); sheet.SetColumnWidth(cellNum++, 18 * 256); sheet.SetColumnWidth(cellNum++, 18 * 256); sheet.SetColumnWidth(cellNum++, 18 * 256); sheet.SetColumnWidth(cellNum++, 18 * 256); sheet.SetColumnWidth(cellNum++, 18 * 256); sheet.SetColumnWidth(cellNum++, 18 * 256); #endregion Init #region 封装数据 var result = CustomersActivityManager.SelectCustomerCoupons(queryString, customersSettingId, activityExclusiveId, 1, 99999999); if (result != null && result.Any()) { for (var i = 0; i < result.Count(); i++) { cellNum = 0; NPOI.SS.UserModel.IRow rowTemp = sheet.CreateRow(i + 1); rowTemp.CreateCell(cellNum++).SetCellValue(result[i].ActivityExclusiveId); rowTemp.CreateCell(cellNum++).SetCellValue(result[i].CouponCode); rowTemp.CreateCell(cellNum++).SetCellValue(result[i].UserName); rowTemp.CreateCell(cellNum++).SetCellValue(result[i].Phone); rowTemp.CreateCell(cellNum++).SetCellValue(result[i].UserId + ""); rowTemp.CreateCell(cellNum++).SetCellValue(result[i].CreateTime.ToString()); rowTemp.CreateCell(cellNum++).SetCellValue(result[i].UpdateDatetime.ToString()); rowTemp.CreateCell(cellNum++).SetCellValue(result[i].Status == "0" ? "正常" : "删除"); } } #endregion 封装数据 var ms = new MemoryStream(); workBook.Write(ms); return(File(ms.ToArray(), "application/x-xls", $"{DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒")}.xlsx")); }