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