//=========================== 商品圖片刪除 =========================== //
public static void fn商品圖片刪除(CProductPicture productPicture)
{
string sql = $"EXEC 商品圖片刪除 ";
sql += $"@{CProductPictureKey.fProductPictureId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CProductPictureKey.fProductPictureId, productPicture.fProductPictureId),
};
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);
}