public ActionResult Cashback(int id) { string cardId = Request.Form["CardId"]; string recash = Request.Form["Recash"]; string point = Request.Form["Point"]; string gavePoint = Request.Form["GavePoint"]; try { ConsumeOrders cos = new ConsumeOrders(); MemCardsBLL mcll = new MemCardsBLL(); ConsumeOrdersBLL coll = new ConsumeOrdersBLL(); cos.CO_GavePoint = Convert.ToInt32(gavePoint); cos.CO_Recash = (float)Convert.ToDouble(recash); cos.MC_CardID = cardId; MemCards mc = mcll.SelectWhere(m => m.MC_CardID == cardId).FirstOrDefault(); using (TransactionScope ts = new TransactionScope()) { //添加消费记录 coll.Add(cos); coll.SaveChanges(); //更新用户卡信息 mc.MC_Point = Convert.ToInt32(point); mcll.SaveChanges(); ts.Complete(); } return Json(new { result = "ok", data = point }); } catch { return Json(new { result = "error", data = "系统异常,兑换失败!" }); } }
/// <summary> /// 挂失/锁定 /// </summary> public ActionResult CardState(int id) { MemCards mc = new MemCardsBLL().Find(id); //状态 var state = new CategoryItemsBLL().SelectWhere(m => m.C_Category == "MC_State"); ViewBag.MC_State = new SelectList(state, "CI_ID", "CI_Name", mc.MC_State); return View(mc); }
public ActionResult CardState(MemCards mc) { try { MemCardsBLL bll = new MemCardsBLL(); bll.Edit(mc, "MC_State"); bll.SaveChanges(); return Json(new { result = "ok" }); } catch { return Json(new { result = "error" }); } }
/// <summary> /// 会员信息 /// </summary> public ActionResult MemberInfo() { string idorm = Request.QueryString["idorm"]; Users u = Session["user"] as Users; var mc = new MemCardsBLL().SelectWhere (m => (m.S_ID == u.S_ID) && (m.MC_State != 4) && (m.MC_CardID == idorm || m.MC_Mobile == idorm)).Select (m => new { m.MC_Name, m.MC_Point, m.MC_State, m.CardLevels.CL_LevelName, m.MC_TotalMoney, m.CardLevels.CL_Percent, m.CardLevels.CL_Point, m.MC_CardID }).FirstOrDefault(); if (mc != null) { if (mc.MC_State == 2) return Json(new { state = 2 }, JsonRequestBehavior.AllowGet); if (mc.MC_State == 3) return Json(new { state = 3 }, JsonRequestBehavior.AllowGet); } return Json(mc, JsonRequestBehavior.AllowGet); }
public ActionResult Create(MemCards mc) { try { MemCardsBLL bll = new MemCardsBLL(); MemCards refererMc = new MemCards(); Users user = Session["user"] as Users; mc.S_ID = user.S_ID; mc.MC_Password = mc.MC_Password ?? "123456"; mc.MC_IsPast = Request.Form["MC_IsPast"] == "on" ? true : false; mc.MC_IsPointAuto = Request.Form["MC_IsPointAuto"] == "on" ? true : false; //积分兑换等级 if (mc.MC_IsPointAuto == true) { var level = bll.MenCardLevel(mc); mc.CL_ID = level.CL_ID; } if (mc.MC_RefererName != null) { mc.MC_RefererID = bll.GetExchange(mc.MC_RefererCard).MC_ID; //被推荐人增加积分 mc.MC_Point = mc.MC_Point + 100; //推荐人增加积分 refererMc.MC_Point = bll.GetExchange(mc.MC_RefererCard).MC_Point + 100; refererMc.MC_ID = bll.GetExchange(mc.MC_RefererCard).MC_ID; bll.Edit(refererMc, "MC_Point"); } mc.MC_TotalCount = 0; mc.MC_TotalMoney = 0; mc.MC_CreateTime = DateTime.Now; bll.Add(mc); bll.SaveChanges(); return Json(new { result = "ok" }); } catch { return Json(new { result = "error" }); } }
public ActionResult UpExcel() { HttpPostedFileBase upfile = Request.Files[0]; if (upfile.ContentLength > 0) { string fileName = Path.GetFileName(upfile.FileName); string fileExt = Path.GetExtension(fileName); if (fileExt.Equals(".xls") || fileExt.Equals(".xlsx")) { string path = Request.MapPath("/Filters/" + fileName); upfile.SaveAs(path); using (FileStream file = System.IO.File.OpenRead(path)) { try { // 根据文件名后缀加载IWorkbook IWorkbook workbook = fileExt == ".xls" ? new HSSFWorkbook(file) : workbook = new XSSFWorkbook(file); ISheet sheet = workbook.GetSheetAt(0); List<MemCards> mcList = new List<MemCards>(); for (int i = sheet.FirstRowNum + 1; i <= sheet.LastRowNum; i++) { IRow row = sheet.GetRow(i); MemCards mc = new MemCards(); mc.MC_CardID = row.Cells[0].ToString(); mc.MC_Name = row.Cells[1].ToString(); mc.MC_Sex = row.Cells[2].ToString() == "男" ? 1 : 0; mc.MC_Mobile = row.Cells[3].ToString(); mc.MC_Point = (int)row.Cells[4].NumericCellValue; mc.MC_TotalMoney = (float)row.Cells[5].NumericCellValue; mc.MC_TotalCount = (int)row.Cells[6].NumericCellValue; int state = 1; if (row.Cells[7].ToString() == "挂失") state = 2; else if (row.Cells[7].ToString() == "锁定") state = 3; mc.MC_State = state; mc.CL_ID = (int)row.Cells[8].NumericCellValue; mc.MC_CreateTime = Convert.ToDateTime(row.Cells[9].ToString()); mc.S_ID = (Session["user"] as Users).S_ID; mc.MC_Password = "******"; mcList.Add(mc); } MemCardsBLL bll = new MemCardsBLL(); foreach (MemCards mc in mcList) { bll.Add(mc); } bll.SaveChanges(); return Content("ok"); } catch { return Content("error"); } } } return Content("no"); } return Content("none"); }
public ActionResult Transfer(string TL_FromMC_CardID, string TL_ToMC_CardID, int TL_TransferMoney, string TL_Remark) { MemCardsBLL mcBll = new MemCardsBLL(); TransferLogsBLL tfBll = new TransferLogsBLL(); TransferLogs tf = new TransferLogs(); MemCards mcTo = new MemCards(); MemCards mcFrom = new MemCards(); try { MemCards uTo = mcBll.GetExchange(TL_ToMC_CardID); MemCards uFrom = mcBll.GetExchange(TL_FromMC_CardID); Users user = Session["user"] as Users; using (TransactionScope ts = new TransactionScope()) { //修改转出卡号信息 mcTo.MC_ID = uFrom.MC_ID; mcTo.MC_Point = uFrom.MC_Point - TL_TransferMoney; //修改转入卡号信息 mcFrom.MC_ID = uTo.MC_ID; mcFrom.MC_Point = uTo.MC_Point + TL_TransferMoney; mcBll.Edit(mcFrom, "MC_Point"); mcBll.Edit(mcTo, "MC_Point"); mcBll.SaveChanges(); //转账信息表添加数据 tf.S_ID = user.S_ID; tf.U_ID = user.U_ID; tf.TL_FromMC_ID = mcBll.SelectWhere(m => m.MC_CardID == TL_FromMC_CardID).Select(m => m.MC_ID).FirstOrDefault(); tf.TL_FromMC_CardID = TL_FromMC_CardID; tf.TL_ToMC_ID = mcBll.SelectWhere(m => m.MC_CardID == TL_ToMC_CardID).Select(m => m.MC_ID).FirstOrDefault(); tf.TL_ToMC_CardID = TL_ToMC_CardID; tf.TL_TransferMoney = TL_TransferMoney; tf.TL_Remark = TL_Remark; tf.TL_CreateTime = DateTime.Now; tfBll.Add(tf); tfBll.SaveChanges(); ts.Complete(); } return Json(new { result = "ok" }); } catch { return Json(new { result = "error" }); } }
/// <summary> /// 会员转账 /// </summary> /// <returns></returns> public ActionResult Transfer(int id) { Session["memCard"] = new MemCardsBLL().Find(id); return View(); }
/// <summary> /// 修改会员信息 /// </summary> public ActionResult Edit(int id) { MemCards mc = new MemCardsBLL().Find(id); //会员等级 var lvs = new CardLevelsBLL().SelectWhere(m => true); ViewBag.CL_ID = new SelectList(lvs, "CL_ID", "CL_LevelName", mc.CL_ID); //状态 var state = new CategoryItemsBLL().SelectWhere(m => m.C_Category == "MC_State"); ViewBag.MC_State = new SelectList(state, "CI_ID", "CI_Name", mc.MC_State); //性别 List<SelectListItem> genderList = new List<SelectListItem>(); genderList.Add(new SelectListItem { Text = "未知", Value = "2" }); genderList.Add(new SelectListItem { Text = "男", Value = "1" }); genderList.Add(new SelectListItem { Text = "女", Value = "0" }); ViewBag.MC_Sex = new SelectList(genderList, "Value", "Text", mc.MC_Sex); List<SelectListItem> monthList = new List<SelectListItem>(); monthList.Add(new SelectListItem { Text = "请选择", Value = "" }); for (int i = 1; i <= 12; i++) { monthList.Add(new SelectListItem { Text = "" + i + "", Value = "" + i + "" }); } ViewBag.MC_Birthday_Month = new SelectList(monthList, "Value", "Text", mc.MC_Birthday_Month); ViewBag.MC_CardID = mc.MC_CardID; ViewBag.MC_IsPast = mc.MC_IsPast == true ? "checked='checked'" : ""; ViewBag.MC_IsPointAuto = mc.MC_IsPointAuto == true ? "checked='checked'" : ""; ViewBag.MC_CardID = mc.MC_CardID; ViewBag.PWD = mc.MC_Password; return View(mc); }
/// <summary> /// 查询推荐会员姓名 /// </summary> public ActionResult GetNamebyCardID(string MC_CardID) { MemCardsBLL bll = new MemCardsBLL(); string mcList = bll.SelectWhere(m => m.MC_CardID == MC_CardID).Select(m => m.MC_Name).FirstOrDefault(); return Content(mcList); }
/// <summary> /// 获取当前输入会员信息 /// </summary> public ActionResult GetMemByCardID(string FromCardID, string ToCardID) { MemCardsBLL bll = new MemCardsBLL(); Users u = Session["user"] as Users; var mcList = bll.SelectWhere(m => (m.S_ID == u.S_ID) && (m.MC_State != 4) && (m.MC_CardID == ToCardID)); if (!mcList.Any()) return Content("NO"); if (!bll.GetState(ToCardID)) return Content("NOState"); if (!bll.GetLevels(FromCardID, ToCardID)) return Content("NOLevels"); var cards = mcList.Select(m => new { m.MC_CardID, m.MC_Name, m.MC_ID, m.MC_Point, m.MC_TotalMoney }).FirstOrDefault(); return Json(cards, JsonRequestBehavior.AllowGet); }
public ActionResult ExchangeCard(int MC_ID, string MC_Password, string MC_CardID) { MemCardsBLL fromMc = new MemCardsBLL(); //判断卡号和密码是否正确 if (fromMc.IsTruePwd(MC_ID, MC_Password)) { try { MemCardsBLL bll = new MemCardsBLL(); MemCards toMc = new MemCards(); toMc.MC_ID = MC_ID; toMc.MC_Password = toMc.MC_Password ?? "1"; toMc.MC_CardID = MC_CardID; bll.Edit(toMc, "MC_CardID", "MC_Password"); bll.SaveChanges(); return Json(new { result = "ok" }); } catch { return Json(new { result = "error" }); } } return Json(new { result = "no" }); }
/// <summary> ///会员换卡 /// </summary> public ActionResult ExchangeCard(int id) { Session["memCard"] = new MemCardsBLL().Find(id); ViewBag.MC_CardID = Convert.ToInt32(new MemCardsBLL().SelectWhere(m => true).Select(m => m.MC_CardID).Max()) + 1; return View(); }
/// <summary> /// 导出Excel /// </summary> public ActionResult ExcelOut() { Users u = Session["user"] as Users; var mcList = new MemCardsBLL().SelectWhere(m => m.S_ID == u.S_ID && m.MC_State != 4).Select( m => new { m.MC_CardID, m.MC_Name, m.MC_Sex, m.MC_Mobile, m.MC_Point, m.MC_TotalMoney, m.MC_TotalCount, m.MC_State, m.CL_ID, m.MC_CreateTime }).ToList(); try { string path = string.Format("/Filters/{0}.xlsx", DateTime.Now.ToString("yyyyMMddhhmmss")); using (FileStream file = System.IO.File.OpenWrite(Server.MapPath(path))) { IWorkbook workbook = new XSSFWorkbook(); ISheet sheet = workbook.CreateSheet(); // 设置表格的列名 string[] cols = { "会员卡号", "会员姓名", "性别", "手机号码", "当前积分", "累计消费", "消费次数", "会员卡状态", "当前等级", "登记时间" }; IRow rowHead = sheet.CreateRow(0); for (int i = 0; i < cols.Length; i++) { rowHead.CreateCell(i).SetCellValue(cols[i]); } for (int i = 0; i < mcList.Count; i++) { IRow row = sheet.CreateRow(i + 1); row.CreateCell(0).SetCellValue(mcList[i].MC_CardID); row.CreateCell(1).SetCellValue(mcList[i].MC_Name); row.CreateCell(2).SetCellValue(mcList[i].MC_Sex == 0 ? "女" : "男"); row.CreateCell(3).SetCellValue(mcList[i].MC_Mobile); row.CreateCell(4).SetCellValue((int)mcList[i].MC_Point); row.CreateCell(5).SetCellValue((double)mcList[i].MC_TotalMoney); row.CreateCell(6).SetCellValue((int)mcList[i].MC_TotalCount); string state = "正常"; if (mcList[i].MC_State == 2) state = "挂失"; else if (mcList[i].MC_State == 3) state = "锁定"; row.CreateCell(7).SetCellValue(state); row.CreateCell(8).SetCellValue((int)mcList[i].CL_ID); row.CreateCell(9).SetCellValue(((DateTime)mcList[i].MC_CreateTime).ToString("yyyy-MM-dd hh:mm:ss")); } workbook.Write(file); } // 返回成功状态和生成的Excel地址 return Json(new { result = "ok", tourl = path }, JsonRequestBehavior.AllowGet); } catch { return Json(new { result = "error" }, JsonRequestBehavior.AllowGet); } }
public ActionResult Edit(MemCards mc) { try { MemCardsBLL bll = new MemCardsBLL(); mc.MC_Password = mc.MC_Password ?? Request.Form["PWD"]; mc.MC_IsPast = Request.Form["MC_IsPast"] == "on" ? true : false; bll.Edit(mc, "CL_ID", "MC_Password", "MC_Name", "MC_Sex", "MC_Mobile", "MC_Photo", "MC_Birthday_Month", "MC_Birthday_Day", "MC_BirthdayType", "MC_IsPast", "MC_PastTime", "MC_Money", "MC_State"); bll.SaveChanges(); return Json(new { result = "ok" }); } catch { return Json(new { result = "error" }); } }
/// <summary> /// 查询 /// </summary> public ActionResult MemberInfo() { int pageIndex = 0, pageSize = 0; if (!string.IsNullOrEmpty(Request.Form["rows"])) { pageSize = Convert.ToInt32(Request.Form["rows"]); } if (!string.IsNullOrEmpty(Request.Form["page"])) { pageIndex = Convert.ToInt32(Request.Form["page"]); } string cardId = Request.Form["MC_CardID"]; string mobile = Request.Form["MC_Mobile"]; string name = Request.Form["MC_Name"]; string level = Request.Form["CL_ID"]; string state = Request.Form["MC_State"]; Users user = Session["user"] as Users; int totalRow; var pagelist = new MemCardsBLL().GetMembers(pageIndex, pageSize, (int)user.S_ID, cardId, mobile, name, level, state, out totalRow); return Json(new { total = totalRow, rows = pagelist }, JsonRequestBehavior.AllowGet); }
public ActionResult ExchangeInfo() { string row = Request.Form["rows"]; Users user = Session["user"] as Users; JavaScriptSerializer serializer = new JavaScriptSerializer(); List<ExchangLogs> logList = serializer.Deserialize<List<ExchangLogs>>(row); List<ExchangGifts> giftList = serializer.Deserialize<List<ExchangGifts>>(row); try { ExchangLogs el = new ExchangLogs(); MemCardsBLL mcBll = new MemCardsBLL(); ExchangLogsBLL elBll = new ExchangLogsBLL(); ExchangGiftsBLL exBll = new ExchangGiftsBLL(); //事务处理,优点:确保数据统一完整;缺点:锁表 using (TransactionScope ts = new TransactionScope()) { string idorm = Request.Form["idorm"]; MemCards mc = mcBll.SelectWhere(s => s.MC_CardID == idorm || s.MC_Mobile == idorm).FirstOrDefault(); double percent = (double)mc.CardLevels.CL_Percent; double sum = 0; int total = (int)mc.MC_Point; for (int i = 0; i < logList.Count; i++) { int point = Convert.ToInt32(giftList[i].EG_Point); int number = Convert.ToInt32(logList[i].EL_Number); //添加兑换记录表 el.S_ID = user.S_ID; el.U_ID = user.U_ID; el.MC_ID = mc.MC_ID; el.MC_CardID = idorm; el.MC_Name = mc.MC_Name; el.EG_ID = giftList[i].EG_ID; el.EG_GiftCode = logList[i].EG_GiftCode; el.EG_GiftName = logList[i].EG_GiftName; el.EL_Number = number; el.EL_Point = point * number; el.EL_CreateTime = DateTime.Now; elBll.Add(el); sum += (double)point * number * percent; //更新礼品表 int eId = Convert.ToInt32(logList[i].EG_ID); ExchangGifts eGift = exBll.SelectWhere(m => m.EG_ID == eId).FirstOrDefault(); eGift.EG_ExchangNum = number + eGift.EG_ExchangNum; } if (total >= Math.Ceiling(sum)) { //更新会员表 int subpoint = (int)(mc.MC_Point - sum); mc.MC_Point = subpoint; //保存 mcBll.SaveChanges(); elBll.SaveChanges(); exBll.SaveChanges(); ts.Complete(); return Json(new { result = "ok", data = subpoint }); } return Json(new { result = "no", data = "可兑换积分不足" + Math.Ceiling(sum) + "!" }); } } catch { return Json(new { result = "error" }); } }
/// <summary> /// 删除会员信息 /// </summary> public ActionResult Delete(int id) { try { MemCardsBLL bll = new MemCardsBLL(); MemCards mc = new MemCards(); mc.MC_ID = id; mc.MC_State = 4; bll.Edit(mc, "MC_State"); bll.SaveChanges(); return Json(new { result = "ok" }, JsonRequestBehavior.AllowGet); } catch { return Json(new { result = "error" }, JsonRequestBehavior.AllowGet); } }