public ActionResult ExchangeGift(int id)
{
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 idorm = Request.Form["CardOrMobile"];
string beginDate = Request.Form["BeginDate"];
string endDate = Request.Form["EndDate"];
Users u = Session["user"] as Users;
int totalRow; var pagelist = new ExchangLogsBLL().GetGiftOrders(pageIndex, pageSize, (int)u.S_ID, idorm, beginDate, endDate, 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" });
}
}
public ActionResult History(int id)
{
string idorm = Request.Form["idorm"];
int pageSize = 0, pageIndex = 0;
if (Request.Form["rows"] != null)
{
pageSize = Convert.ToInt32(Request.Form["rows"]);
}
if (Request.Form["page"] != null)
{
pageIndex = Convert.ToInt32(Request.Form["page"]);
}
Users u = Session["user"] as Users;
int totalRow; var pagelist = new ExchangLogsBLL().GetOrders(pageIndex, pageSize, (int)u.S_ID, idorm, out totalRow);
return Json(new { total = totalRow, rows = pagelist }, JsonRequestBehavior.AllowGet);
}
