/// <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="pageIndex">pageIndex</param>
/// <param name="pageSize">pageSize</param>
/// <returns></returns>
public JsonResult GetCustomerExclusiveSettings(int pageIndex = 1, int pageSize = 20)
{
var listCustomerExculusive = CustomersActivityManager.SelectCustomerExclusives(pageIndex, pageSize);
int totalCount = CustomersActivityManager.SelectCustomerExclusiveCount();
return(Json(new { data = listCustomerExculusive, totalCount = totalCount }, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateCustomerCouponStatus(CustomerExclusiveCouponModel customerExclusiveCouponModel)
{
int result = CustomersActivityManager.UpdateCustomerCouponStatus(customerExclusiveCouponModel, User.Identity.Name);
string message = "更新成功";
if (result == 0)
{
message = "更新失败";
}
return(Json(new { success = result == 1, msg = message }));
}
public JsonResult InsertCustomerExclusiveSetting(CustomerExclusiveSettingModel customerExclusiveSettingModel)
{
int result = CustomersActivityManager.InsertCustomerExclusiveSetting(customerExclusiveSettingModel, User.Identity.Name);
string message = "新增成功";
if (result == -9)
{
message = "限时抢购活动ID已经存在,请从新输入!";
}
else if (result == 0)
{
message = "新增失败";
}
return(Json(new { success = result == 1, msg = message }));
}
public JsonResult InsertCustomerCoupon(CustomerExclusiveCouponModel customerExclusiveCouponModel)
{
customerExclusiveCouponModel.CouponCode = customerExclusiveCouponModel.CouponCode?.Trim();
int result = CustomersActivityManager.InsertCustomerCoupon(customerExclusiveCouponModel, User.Identity.Name);
string message = "新增成功";
if (result == -9)
{
message = "券码已经存在,请重新输入!";
}
else if (result == 0)
{
message = "新增失败";
}
return(Json(new { success = result == 1, msg = message }));
}
/// <summary>
/// 调用服务端接口查询公司信息
/// </summary>
/// <returns></returns>
public JsonResult GetCompanyInfoDict()
{
var listCompanyInfo = CustomersActivityManager.GetCompanyInfoDict();
return(Json(new { data = listCompanyInfo }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCustomerExclusiveSettingLogs(string objeId, string source)
{
var result = new CustomersActivityManager().GetCustomerExclusiveSettingLog(objeId, source);
return(Json(result, 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"));
}
public JsonResult Upload(string customersSettingId, string activityExclusiveId)
{
var files = Request.Files;
string msg = "上传失败";
bool bolRet = false;
if (files.Count == 1)
{
var file = files[0];
if (file.ContentType != "application/vnd.ms-excel" &&
file.ContentType != "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
msg = "请上传Excel文件";
}
else
{
using (var stream = file.InputStream)
{
var buffer = new byte[stream.Length];
stream.Read(buffer, 0, buffer.Length);
var workBook = new XSSFWorkbook(new MemoryStream(buffer));
var sheet = workBook.GetSheetAt(0);
var convertResult = ConvertCustomerExclusiveCoupon(sheet, customersSettingId, activityExclusiveId);
if (!string.IsNullOrEmpty(convertResult.Item1))
{
msg = convertResult.Item1;
}
else if (convertResult.Item2 == null || !convertResult.Item2.Any())
{
msg = "文件不能为空";
}
else if (convertResult.Item2.Distinct().Count() != convertResult.Item2.Count)
{
msg = "存在重复数据";
}
else
{
string resultCoupons = string.Empty;
var result = CustomersActivityManager.InsertCustomerCoupons(convertResult.Item2, User.Identity.Name, out resultCoupons);
if (result == convertResult.Item2.Count)
{
msg = "批量上传成功";
}
else
{
msg = "部分上传成功,共：" + convertResult.Item2.Count + "; 上传成功："
+ result + ";剩余" + resultCoupons + ";券码已重复";
}
bolRet = true;
}
}
}
}
else
{
msg = "请先上传文件";
}
return(Json(new { msg = msg, success = bolRet }));
}
