public ActionResult addToBuyCar(int id)
{
if (Session["userLogin"] != null)
{
string uname = Session["userLogin"].ToString();
Models.BookShopEntities4 db = new Models.BookShopEntities4();
Models.bookInfo bi = db.bookInfo.Where(a => a.bookID == id && a.isDel != "Y").FirstOrDefault();
if (bi != null)
{
Models.buyCar bCar = db.buyCar.Where(b => b.booksID == id && b.buyUser == uname).FirstOrDefault();
string output = "";
if (bCar == null)
{
Models.buyCar newAdd = new Models.buyCar()
{
booksID = id,
buyNum = 1,
buyUser = Session["userLogin"].ToString()
};
db.buyCar.Add(newAdd);
output = "加入购物车成功";
}
else
{
Models.bookInfo binfo = db.bookInfo.Where(b => b.bookID == id).FirstOrDefault();
if (binfo.onlyBuy != null && bCar.buyNum >= binfo.onlyBuy)
{
bCar.buyNum = binfo.onlyBuy.Value;
output = "该商品有限购规则，仅允许购买" + binfo.onlyBuy.Value + "个，已将购物车中该商品数量调整为最大购买数量";
}
else
{
bCar.buyNum += 1;
output = "购物车中已存在该商品，商品数量加1";
}
}
db.SaveChanges();
return(Content(output));
}
else
{
return(Content("该商品已经下架或者商品不存在，无法加入购物车"));
}
}
else
{
return(Content("尚未登录，无法加入购物车，请先登录"));
}
}
public ActionResult OrderProcessing(string toName, string toAddress, string toPhone, string userPay)
{
if (Session["userLogin"] != null)
{
string uName = Session["userLogin"].ToString();
Models.BookShopEntities4 db = new Models.BookShopEntities4();
Models.orderInfo oi = new Models.orderInfo()
{
submitTime = System.DateTime.Now.ToString(),
toAddress = toAddress,
toName = toName,
toPhone = toPhone,
buyUser = uName,
orderState = "等待系统处理",
payType = userPay
};
db.orderInfo.Add(oi);
db.SaveChanges();
var deleteQuery = db.buyCar.Where(e => e.buyUser == uName);
// var orderId = db.buyCar.Where(e => e.buyUser == uName);
//Models. bCar = db.buyCar.Where(b => b.booksID == id && b.buyUser == uname).FirstOrDefault();
foreach (var item in deleteQuery)
{
Models.bookInfo binfo = db.bookInfo.Where(b => b.bookID == item.booksID).FirstOrDefault();
Models.orderDetails od = new Models.orderDetails()
{
orderId = oi.orderId,
bookId = item.booksID,
bookPrice = binfo.bookPrice,
buyNum = item.buyNum
};
db.orderDetails.Add(od);
db.buyCar.Remove(item);
}
db.SaveChanges();
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('订单提交成功',function (){location='/My/MyOrder'});}</script>");
return(View());
}
else
{
return(RedirectToAction("otherLogin", "Login", new { m = "My", a = "Settlement" }));
}
}
public ActionResult updateCartNum(int sysID, int newNum)
{
if (Session["userLogin"] != null)
{
string uname = Session["userLogin"].ToString();
Models.BookShopEntities4 db = new Models.BookShopEntities4();
Models.buyCar bCar = db.buyCar.Where(b => b.sysID == sysID && b.buyUser == uname).FirstOrDefault();
int id = bCar.booksID;
string output = "okay";
Models.bookInfo binfo = db.bookInfo.Where(b => b.bookID == id).FirstOrDefault();
if (binfo.isDel != "Y")
{
if (binfo.onlyBuy != null && newNum >= binfo.onlyBuy)
{
bCar.buyNum = binfo.onlyBuy.Value;
output = "该商品有限购规则，仅允许购买" + binfo.onlyBuy.Value + "个，已将购物车中该商品数量调整为最大购买数量";
}
else
{
bCar.buyNum = newNum;
output = "okay";
}
}
else
{
bCar.buyNum = 0;
output = "该商品已经下架或者不存在，数量自动调整为0个";
}
db.SaveChanges();
return(Content(output));
}
else
{
return(Content("会话已失效，请重新登陆后再操作"));
}
}