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