//=========================== 購物車更新 =========================== //
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);
}
