//=========================== 購物車商品刪除 =========================== // 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); }