/// <summary>
/// 删除购物车中的商品信息
/// </summary>
/// <param name="shoppingCartId">购物车ID</param>
/// <returns></returns>
public bool DeleteShoppingCartByProductIdUserID(int shoppingCartId)
{
var holycaDb = new HolycaEntities();
Sale_ShoppingCart queryTxt = holycaDb.Sale_ShoppingCart.Where(c => c.intShopCartID == shoppingCartId).FirstOrDefault();
holycaDb.DeleteObject(queryTxt);
holycaDb.SaveChanges();
return true;
}
/// <summary>
/// 清除购物车数据
/// </summary>
/// <param name="userId"></param>
public void ClearShoppingCart(int userId)
{
using (var db = new HolycaEntities())
{
var queryTxt = from a in db.Sale_ShoppingCart
where a.intUserID == userId
select a;
var shoppingCartList = queryTxt.ToList();
foreach (var saleShoppingCart in shoppingCartList)
{
db.Sale_ShoppingCart.DeleteObject(saleShoppingCart);
}
db.SaveChanges();
}
}
/// <summary>
/// 增加购物车商品信息
/// </summary>
/// <param name="shoppingCartEntity">购物车信息实体</param>
/// <returns></returns>
public bool AddShoppingCartProductInfo(ShoppingCartEntity shoppingCartEntity)
{
var holycaDb = new HolycaEntities();
Sale_ShoppingCart sale_ShoppingCart = new Sale_ShoppingCart();
MCvHelper.ObjectCopyTo(shoppingCartEntity, sale_ShoppingCart);
try
{
holycaDb.Sale_ShoppingCart.AddObject(sale_ShoppingCart);
holycaDb.SaveChanges();
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 设置购物车商品数量
/// </summary>
/// <param name="user_id"></param>
/// <param name="guid"></param>
/// <param name="shoppingCartId"></param>
/// <param name="num"></param>
/// <returns></returns>
public bool SetShoppingCartGoodsNum(int user_id, string guid, int shoppingCartId, int num)
{
var result = false;
if (num > 0)
{
using (var holycaDb = new HolycaEntities())
{
var shoppingCartEntity = holycaDb.Sale_ShoppingCart.First(s => s.intShopCartID == shoppingCartId);
if (shoppingCartEntity != null)
{
try
{
shoppingCartEntity.intBuyCount = num;
holycaDb.SaveChanges();
result = true;
}
catch (Exception)
{
holycaDb.Refresh(RefreshMode.ClientWins, shoppingCartEntity);
holycaDb.SaveChanges();
result = false;
}
}
}
}
return result;
}