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