public static CProduct fn商品新增(CMember member, CProduct product)
{
string sql = $"EXEC 商品新增 ";
sql += $"@{CProductKey.fName},";
sql += $"@{CProductKey.fDescription},";
sql += $"@{CProductKey.fContent},";
sql += $"@{CProductKey.fPrice},";
sql += $"@{CProductKey.fLaunchDate},";
sql += $"@{CProductKey.fTheRemovedDate},";
sql += $"@{CProductKey.fDownloadTimes},";
sql += $"@{CProductKey.fLikeCount},";
sql += $"@{CProductKey.fMemberSellerId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CProductKey.fName, product.fName),
new SqlParameter(CProductKey.fDescription, product.fDescription),
new SqlParameter(CProductKey.fContent, product.fContent),
new SqlParameter(CProductKey.fPrice, product.fPrice),
new SqlParameter(CProductKey.fLaunchDate, product.fLaunchDate),
new SqlParameter(CProductKey.fTheRemovedDate, (object)product.fTheRemovedDate ?? DBNull.Value), //可NULL
new SqlParameter(CProductKey.fDownloadTimes, product.fDownloadTimes),
new SqlParameter(CProductKey.fLikeCount, product.fLikeCount),
new SqlParameter(CProductKey.fMemberSellerId, member.fMemberId)
};
CDbManager.executeSql(sql, paras);
CProduct NewProduct = fn商品查詢().LastOrDefault();
return(NewProduct);
}
public static void fn商品更新(CProduct product)
{
string sql = $"EXEC 商品更新 ";
sql += $"@{CProductKey.fProductId},";
sql += $"@{CProductKey.fName},";
sql += $"@{CProductKey.fDescription},";
sql += $"@{CProductKey.fContent},";
sql += $"@{CProductKey.fPrice},";
sql += $"@{CProductKey.fLaunchDate},";
sql += $"@{CProductKey.fTheRemovedDate},";
sql += $"@{CProductKey.fDownloadTimes},";
sql += $"@{CProductKey.fLikeCount},";
sql += $"@{CProductKey.fMemberSellerId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CProductKey.fProductId, product.fProductId),
new SqlParameter(CProductKey.fName, product.fName),
new SqlParameter(CProductKey.fDescription, product.fDescription),
new SqlParameter(CProductKey.fContent, product.fContent),
new SqlParameter(CProductKey.fPrice, product.fPrice),
new SqlParameter(CProductKey.fLaunchDate, product.fLaunchDate),
new SqlParameter(CProductKey.fTheRemovedDate, (object)product.fTheRemovedDate ?? DBNull.Value), //可NULL
new SqlParameter(CProductKey.fDownloadTimes, product.fDownloadTimes),
new SqlParameter(CProductKey.fLikeCount, product.fLikeCount),
new SqlParameter(CProductKey.fMemberSellerId, product.fMemberSellerId)
};
CDbManager.executeSql(sql, paras);
}
//=========================== 商品瀏覽紀錄新增 =========================== //
public static void fn商品瀏覽紀錄新增(CProduct product, CProductBrowse productBorwse)
{
string sql = $"EXEC 商品瀏覽紀錄新增 ";
sql += $"@{CProductBrowseKey.fBrowseDataTime},";
sql += $"@{CProductBrowseKey.fProductId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CProductBrowseKey.fBrowseDataTime, productBorwse.fBrowseDataTime),
new SqlParameter(CProductBrowseKey.fProductId, product.fProductId)
};
CDbManager.executeSql(sql, paras);
}
//=========================== 商品類別對照新增 =========================== //
public static void fn商品類別對照新增(CProduct product, CProductCategory productCategory)
{
string sql = $"EXEC 商品類別對照新增 ";
sql += $"@{CProductCompareKey.fProductId},";
sql += $"@{CProductCompareKey.fCategoryId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CProductCompareKey.fProductId, product.fProductId),
new SqlParameter(CProductCompareKey.fCategoryId, productCategory.fCategoryId)
};
CDbManager.executeSql(sql, paras);
}
//=========================== 商品圖片新增 =========================== //
public static void fn商品圖片新增(CProduct product, CProductPicture productPicture)
{
string sql = $"EXEC 商品圖片新增 ";
sql += $"@{CProductPictureKey.fPicture},";
sql += $"@{CProductPictureKey.fProductId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CProductPictureKey.fPicture, productPicture.fPicture),
new SqlParameter(CProductPictureKey.fProductId, product.fProductId)
};
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);
}