protected void AddToCartButton_Click(object sender, EventArgs e)
{
using (LiBoClothesShopEntities context = new LiBoClothesShopEntities())
{
String CurrentUserName = ((Site1)Page.Master).CurrentUserName;
int colorId = Convert.ToInt32(DropDownListColor.SelectedItem.Value);
int sizeId = Convert.ToInt32(DropDownListSize.SelectedValue);
//查找用户是否有购物车
var query = from cart in context.CartInfoes
where cart.UserName == CurrentUserName
select cart;
CartInfo myCart;
if (query.Count() == 0)
{
myCart = new CartInfo()
{
UserName = CurrentUserName,
TotalPrice = 0
};
context.AddToCartInfoes(myCart);
context.SaveChanges();
}
else
{
myCart = query.FirstOrDefault();
}
//查找是否已有该购物车明细
var query1 = from p in context.CartDetails
where p.CartInfo.UserName == CurrentUserName
&& p.ColorId == colorId
&& p.SizeId == sizeId
&& p.ClothId == CurrentProduct.Id
select p;
CartDetail myCartDetail;
if (query1.Count() == 0)
{
//如果没有，新增
myCartDetail = new CartDetail();
myCartDetail.CartId = myCart.ID;
myCartDetail.SizeId = sizeId;
myCartDetail.ColorId = colorId;
myCartDetail.ClothId = CurrentProduct.Id;
myCartDetail.QTY = 1;
context.AddToCartDetails(myCartDetail);
}
else
{
//如果有，修改数量
myCartDetail = query1.First();
myCartDetail.QTY += 1;
}
//修改总价
myCart.TotalPrice += CurrentProduct.Price;
context.SaveChanges();
}
}
/// <summary>
/// Create a new CartDetail object.
/// </summary>
/// <param name="id">Initial value of the ID property.</param>
/// <param name="qTY">Initial value of the QTY property.</param>
public static CartDetail CreateCartDetail(global::System.Int32 id, global::System.Int32 qTY)
{
CartDetail cartDetail = new CartDetail();
cartDetail.ID = id;
cartDetail.QTY = qTY;
return cartDetail;
}
/// <summary>
/// Deprecated Method for adding a new object to the CartDetails EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToCartDetails(CartDetail cartDetail)
{
base.AddObject("CartDetails", cartDetail);
}