//=========================== 購物車商品刪除 =========================== //
public static void fn購物車商品刪除(CCartProduct cartProduct)
{
string sql = $"EXEC 購物車商品刪除 ";
sql += $"@{CCartProductKey.fCartProductId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CCartProductKey.fCartProductId, cartProduct.fCartProductId),
};
CDbManager.executeSql(sql, paras);
}
//=========================== 購物車商品新增 =========================== //
public static CCartProduct fn購物車商品新增(CProduct product, CCart cart)
{
string sql = $"EXEC 購物車商品新增 ";
sql += $"@{CCartProductKey.fProductId},";
sql += $"@{CCartProductKey.fCartId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CCartProductKey.fProductId, product.fProductId),
new SqlParameter(CCartProductKey.fCartId, cart.fCartId)
};
CDbManager.executeSql(sql, paras);
CCartProduct NewCartProduct = fn購物車商品查詢().LastOrDefault();
return(NewCartProduct);
}