//=========================== 購物車更新 =========================== // public static void fn購物車更新(CCart cart) { string sql = $"EXEC 購物車更新 "; sql += $"@{CCartKey.fCartId},"; sql += $"@{CCartKey.fSubmitTime},"; sql += $"@{CCartKey.fMemberId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CCartKey.fCartId, cart.fCartId), new SqlParameter(CCartKey.fSubmitTime, (object)cart.fSubmitTime ?? DBNull.Value),//可NULL new SqlParameter(CCartKey.fMemberId, cart.fMemberId) }; CDbManager.executeSql(sql, paras); }
//=========================== 購物車新增 =========================== // public static CCart fn購物車新增(CMember member, CCart cart) { string sql = $"EXEC 購物車新增 "; sql += $"@{CCartKey.fSubmitTime},"; sql += $"@{CCartKey.fMemberId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CCartKey.fSubmitTime, (object)cart.fSubmitTime ?? DBNull.Value), //可NULL new SqlParameter(CCartKey.fMemberId, member.fMemberId) }; CDbManager.executeSql(sql, paras); CCart NewCart = fn購物車查詢(member).LastOrDefault(); return(NewCart); }
//=========================== 購物車商品新增 =========================== // 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); }