//=========================== 商品圖片刪除 =========================== // 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); }