/// <summary>
/// 更新券码状态
/// </summary>
/// <param name="pkid"></param>
/// <param name="status"></param>
/// <returns></returns>
public JsonResult UpdateContinentalConfigStatus(long pkid, int status)
{
MaPaiVipManager manager = new MaPaiVipManager();
var result = false;
result = manager.UpdateContinentalConfigStatus(pkid, status, HttpContext.User.Identity.Name);
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 马牌券码
/// </summary>
/// <param name="keyword"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public ActionResult _MaPaiVipCouponCode(string keyword, int pageIndex = 1, int pageSize = 20)
{
MaPaiVipManager manager = new MaPaiVipManager();
var result = manager.GetContinentalActivityList(keyword.Trim(), pageIndex, pageSize);
ViewBag.TotalCount = (result != null && result.Any()) ? result.FirstOrDefault().Total : 0;
return(View(result));
}
/// <summary>
/// 批量删除券码
/// </summary>
/// <param name="pkidStr"></param>
/// <returns></returns>
public JsonResult BatchDeleteConfig(string pkidStr)
{
MaPaiVipManager manager = new MaPaiVipManager();
var result = false;
if (!string.IsNullOrEmpty(pkidStr))
{
result = manager.BatchDeleteConfig(pkidStr);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 批量操作券码
/// </summary>
/// <param name="couponCodeInfo"></param>
/// <returns></returns>
public JsonResult BatchOperatorCouponCodeConfig(string couponCodeInfo)
{
MaPaiVipManager manager = new MaPaiVipManager();
var result = false;
if (!string.IsNullOrEmpty(couponCodeInfo))
{
var data = JsonConvert.DeserializeObject <List <MaPaiVipModel> >(couponCodeInfo);
result = manager.BatchOperatorCouponCodeConfig(data);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 上传文件
/// </summary>
/// <returns></returns>
public JsonResult UploadFile()
{
var success = new List <MaPaiVipModel>();
var error = new List <MaPaiVipModel>();
var msg = string.Empty;
MaPaiVipManager manager = new MaPaiVipManager();
var data = new List <MaPaiVipModel>();
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
DataTable dataTable = null;
string fileExtension = Path.GetExtension(file.FileName); // 文件扩展名
bool isxlsx = fileExtension.Equals(".xlsx");
bool isxls = fileExtension.Equals(".xls");
if (file != null && (isxls || isxlsx))
{
using (Stream writer = file.InputStream)
{
if (isxlsx)
{
dataTable = RenderDataTableForXLSX(writer, 0);
}
if (isxls)
{
dataTable = RenderDataTableForXLS(writer, 0);
}
}
data = ConvertList(dataTable);
var verifyData = manager.VerifyData(data);
success = verifyData.Item1;
error = verifyData.Item2;
msg = verifyData.Item3;
}
else
{
msg = "文件为空或是文件上传格式不正确";
}
}
return(Json(new { SuccessData = success, ErrorData = error, msg = msg }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 增加券码
/// </summary>
/// <param name="couponCode"></param>
/// <returns></returns>
public JsonResult InsertCouponCodeConfig(string couponCode)
{
MaPaiVipManager manager = new MaPaiVipManager();
var result = false;
var msg = "券码已存在";
var data = manager.SelectContinentalConfigInfoByCouponCode(couponCode.Trim());
if (data == null)
{
result = manager.InsertCouponCodeConfig(couponCode.Trim(), HttpContext.User.Identity.Name);
msg = result ? "操作成功" : "操作失败";
}
if (result)
{
return(Json(new { status = "success", msg = msg }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "fail", msg = msg }, JsonRequestBehavior.AllowGet));
}
}
