cs_Feed_Update
ALTER PROC [dbo].cs_Feed_Update
@FeedId INT,
@Url NVARCHAR(255),
@Title NVARCHAR(255),
@Link NVARCHAR(255),
@Language NVARCHAR(10),
@Generator NVARCHAR(255),
@SubscribeDate DATETIME,
@LastUpdateDate DATETIME,
@FeedStateId INT,
@LastModified DATETIME,
@ETag nvarchar(256) = NULL
AS
UPDATE cs_Feed
SET Url = @Url,
Title = @Title,
Link = @Link,
Language = @Language,
Generator = @Generator,
SubscribeDate = @SubscribeDate,
LastUpdateDate = @LastUpdateDate,
FeedStateId = @FeedStateId,
LastModified = @LastModified,
ETag = @ETag
WHERE FeedId = @FeedId
/**//*同样是更新,表不同而已*/
ALTER PROC [dbo].cs_Feed_Update
@FeedId INT,
@Url NVARCHAR(255),
@Title NVARCHAR(255),
@Link NVARCHAR(255),
@Language NVARCHAR(10),
@Generator NVARCHAR(255),
@SubscribeDate DATETIME,
@LastUpdateDate DATETIME,
@FeedStateId INT,
@LastModified DATETIME,
@ETag nvarchar(256) = NULL
AS
UPDATE cs_Feed
SET Url = @Url,
Title = @Title,
Link = @Link,
Language = @Language,
Generator = @Generator,
SubscribeDate = @SubscribeDate,
LastUpdateDate = @LastUpdateDate,
FeedStateId = @FeedStateId,
LastModified = @LastModified,
ETag = @ETag
WHERE FeedId = @FeedId
/**//*同样是更新,表不同而已*/
cs_Feed_MoveFeed
ALTER PROC [dbo].cs_Feed_MoveFeed
@FolderFeedId INT,
@NewFolderId INT = NULL
AS
UPDATE cs_FolderFeed
SET FolderId = @NewFolderId
WHERE FolderFeedId = @FolderFeedId
/**//*更新*/
ALTER PROC [dbo].cs_Feed_MoveFeed
@FolderFeedId INT,
@NewFolderId INT = NULL
AS
UPDATE cs_FolderFeed
SET FolderId = @NewFolderId
WHERE FolderFeedId = @FolderFeedId
/**//*更新*/
cs_Feed_GetUsers
ALTER PROC [dbo].cs_Feed_GetUsers
@SettingsID INT
AS
SELECT U.*
FROM cs_vw_Users_FullUser U
WHERE U.SettingsID = @SettingsID
and U.cs_UserID in (select distinct UserID from cs_Folder where SettingsID = @SettingsID)
/**//*查询在那个范围内的用户 in */
ALTER PROC [dbo].cs_Feed_GetUsers
@SettingsID INT
AS
SELECT U.*
FROM cs_vw_Users_FullUser U
WHERE U.SettingsID = @SettingsID
and U.cs_UserID in (select distinct UserID from cs_Folder where SettingsID = @SettingsID)
/**//*查询在那个范围内的用户 in */
cs_Feed_GetProperties
ALTER PROC [dbo].cs_Feed_GetProperties
@FeedId INT
AS
/**//*省略…………*/
SELECT cf.Url,
cf.Title,
cf.Link,
cf.Language,
cf.Generator,
cf.SubscribeDate,
cf.LastUpdateDate,
cfs.StateName,
cfs.Description,
[SubscribeCount] = (SELECT COUNT(*) FROM cs_FolderFeed WHERE FeedId = cf.FeedId),
[PostCount] = (SELECT COUNT(*) FROM cs_FeedPost WHERE FeedId = cf.FeedId)
FROM cs_Feed cf,
cs_FeedState cfs
WHERE cf.FeedStateId = cfs.FeedStateId
AND cf.FeedId = @FeedId
ALTER PROC [dbo].cs_Feed_GetProperties
@FeedId INT
AS
/**//*省略…………*/
SELECT cf.Url,
cf.Title,
cf.Link,
cf.Language,
cf.Generator,
cf.SubscribeDate,
cf.LastUpdateDate,
cfs.StateName,
cfs.Description,
[SubscribeCount] = (SELECT COUNT(*) FROM cs_FolderFeed WHERE FeedId = cf.FeedId),
[PostCount] = (SELECT COUNT(*) FROM cs_FeedPost WHERE FeedId = cf.FeedId)
FROM cs_Feed cf,
cs_FeedState cfs
WHERE cf.FeedStateId = cfs.FeedStateId
AND cf.FeedId = @FeedId