public ActionResult Delete(int id)
{
try
{
ExchangGiftsBLL bll = new ExchangGiftsBLL();
ExchangGifts u = bll.Find(id);
bll.Remove(u);
bll.SaveChanges();
return Json(new { result = "ok" }, JsonRequestBehavior.AllowGet);
}
catch
{
return Json(new { result = "error" }, JsonRequestBehavior.AllowGet);
}
}
public ActionResult Create(ExchangGifts eGift)
{
try
{
HttpPostedFileBase file = Request.Files[0];
if (file.ContentLength > 0)
{
string fileName = Path.GetFileName(file.FileName);
file.SaveAs(Request.MapPath("/Filters/" + fileName));
eGift.EG_Photo = fileName;
}
ExchangGiftsBLL bll = new ExchangGiftsBLL();
eGift.S_ID = (Session["user"] as Users).S_ID;
eGift.EG_ExchangNum = 0;
bll.Add(eGift);
bll.SaveChanges();
return Content("ok");
}
catch
{
return Content("error");
}
}
public ActionResult Edit(ExchangGifts eGift)
{
try
{
HttpPostedFileBase file = Request.Files[0];
string[] cols;
if (file.ContentLength > 0)
{
string fileName = Path.GetFileName(file.FileName);
file.SaveAs(Request.MapPath("/Filters/" + fileName));
eGift.EG_Photo = fileName;
cols = new string[] { "EG_GiftName", "EG_Photo", "EG_Point", "EG_Number", "EG_Remark" };
}
else
{
cols = new string[] { "EG_GiftName", "EG_Point", "EG_Number", "EG_Remark" };
}
ExchangGiftsBLL bll = new ExchangGiftsBLL();
bll.Edit(eGift, cols);
bll.SaveChanges();
return Content("ok");
}
catch
{
return Content("error");
}
}
/// <summary>
/// 礼品管理数据显示
/// </summary>
public ActionResult GiftInfo()
{
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 ExchangGiftsBLL().GetGifts(pageIndex, pageSize, (int)u.S_ID, 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" });
}
}
