cs_Feed_GetAll
ALTER PROC [dbo].cs_Feed_GetAll
(
@SettingsID int
)
AS
/**//*查询全部引用,好象越来越像是引用的意思了.*/
SELECT FeedId,
Url,
Title,
Link,
Language,
Generator,
SubscribeDate,
LastUpdateDate,
FeedStateId,
LastModified,
ETag
FROM cs_Feed
WHERE SettingsID = @SettingsID
GO
ALTER PROC [dbo].cs_Feed_GetAll
(
@SettingsID int
)
AS
/**//*查询全部引用,好象越来越像是引用的意思了.*/
SELECT FeedId,
Url,
Title,
Link,
Language,
Generator,
SubscribeDate,
LastUpdateDate,
FeedStateId,
LastModified,
ETag
FROM cs_Feed
WHERE SettingsID = @SettingsID
GO
cs_Feed_AddFeed
ALTER PROC [dbo].cs_Feed_AddFeed --应该是引用
@FolderId INT = NULL,
@UserId INT,
@Url NVARCHAR(255),
@SettingsID INT,
@FeedId INT OUTPUT
AS
DECLARE @NewFeedId INT
-----------------------------------------------------------------------------
/**//*因为还不是很确定那个FEED到底是什么意思,所以暂时以RSS或者引用的意思来代替,反正就是
一个什么意思吧.不要太在意了.等我明白什么意思了在改,或者某人指点下*/
-----------------------------------------------------------------------------
-- First, let's see if the feed is already registered.
--先查询是否此引用是否存在.
SELECT @NewFeedId = FeedId
FROM cs_Feed
WHERE Url = @Url and SettingsID = @SettingsID
-- If it's not, let's insert it and grab the FeedId.
-- 如果不存在则插入此引用并获取此ID
IF (@NewFeedId IS NULL)
BEGIN
-- Insert it.
INSERT INTO cs_Feed
(
Url,
SettingsID
)
VALUES
(
@Url,
@SettingsID
)
-- Grab the identity generated.
--获取ID
SELECT @NewFeedId = @@IDENTITY
/**//*@@IDENTITY返回最后插入的标识值。*/
END
-- Add the feed to the user's folder.
-- 添加引用到用户的文件夹
INSERT INTO cs_FolderFeed
(
UserId,
FolderId,
FeedId,
SettingsID
)
VALUES
(
@UserId,
@FolderId,
@NewFeedId,
@SettingsID
)
SELECT @FeedId = @NewFeedId
--返回ID
GO
ALTER PROC [dbo].cs_Feed_AddFeed --应该是引用
@FolderId INT = NULL,
@UserId INT,
@Url NVARCHAR(255),
@SettingsID INT,
@FeedId INT OUTPUT
AS
DECLARE @NewFeedId INT
-----------------------------------------------------------------------------
/**//*因为还不是很确定那个FEED到底是什么意思,所以暂时以RSS或者引用的意思来代替,反正就是
一个什么意思吧.不要太在意了.等我明白什么意思了在改,或者某人指点下*/
-----------------------------------------------------------------------------
-- First, let's see if the feed is already registered.
--先查询是否此引用是否存在.
SELECT @NewFeedId = FeedId
FROM cs_Feed
WHERE Url = @Url and SettingsID = @SettingsID
-- If it's not, let's insert it and grab the FeedId.
-- 如果不存在则插入此引用并获取此ID
IF (@NewFeedId IS NULL)
BEGIN
-- Insert it.
INSERT INTO cs_Feed
(
Url,
SettingsID
)
VALUES
(
@Url,
@SettingsID
)
-- Grab the identity generated.
--获取ID
SELECT @NewFeedId = @@IDENTITY
/**//*@@IDENTITY返回最后插入的标识值。*/
END
-- Add the feed to the user's folder.
-- 添加引用到用户的文件夹
INSERT INTO cs_FolderFeed
(
UserId,
FolderId,
FeedId,
SettingsID
)
VALUES
(
@UserId,
@FolderId,
@NewFeedId,
@SettingsID
)
SELECT @FeedId = @NewFeedId
--返回ID
GO