/index_lcid_129.html'>养老服务
文化、娱乐和体育服务
-
-
-
-
IFIER ;
EXEC [CreateChunkSegment]
@SnapshotId = @SnapshotId,
@IsPermanent = @IsPermanentSnapshot,
@ChunkId = @ChunkId,
@Content = @SegmentData,
@StartByte = 0,
@Length = @SegmentByteCount,
@LogicalByteCount = @SegmentByteCount,
@SegmentId = @SegmentId out
END
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PPPP < r& IH < J~[ 8
CREATE PROCEDURE [dbo].[CreateDataDrivenNotification]
@SubscriptionID uniqueidentifier,
@ActiveationID uniqueidentifier,
@ReportID uniqueidentifier,
@ReportZone int,
@ExtensionSettings ntext,
@Locale nvarchar(128),
@Parameters ntext,
@LastRunTime datetime,
@DeliveryExtension nvarchar(260),
@OwnerSid varbinary (85) = null,
@OwnerName nvarchar(260),
@OwnerAuthType int,
@Version int
AS
declare @OwnerID as uniqueidentifier
EXEC GetUserID @OwnerSid,@OwnerName, @OwnerAuthType, @OwnerID OUTPUT
-- Verify if subscription is being deleted
if exists (select 1 from [dbo].[SubscriptionsBeingDeleted] where [SubscriptionID]=@SubscriptionID)
BEGIN
RAISERROR( N'The subscription is being deleted', 16, 1)
return;
END
-- Verify if subscription was deleted or deactivated
if not exists (select 1 from [dbo].[Subscriptions] where [SubscriptionID]=@SubscriptionID and [InactiveFlags] = 0)
BEGIN
RAISERROR( N'The subscription was deleted or deactivated', 16, 1)
return;
END
-- Insert into the notification table
insert into [Notifications]
(
[NotificationID],
[SubscriptionID],
[ActivationID],
[ReportID],
[ReportZone],
[SnapShotDate],
[ExtensionSettings],
[Locale],
[Parameters],
[NotificationEntered],
[SubscriptionLastRunTime],
[DeliveryExtension],
[SubscriptionOwnerID],
[IsDataDriven],
[Version]
)
values
(
NewID(),
@SubscriptionID,
@ActiveationID,
@ReportID,
@ReportZone,
NULL,
@ExtensionSettings,
@Locale,
@Parameters,
GETUTCDATE(),
@LastRunTime,
@DeliveryExtension,
@OwnerID,
1,
@Version
)
< tC[ 8
CREATE PROCEDURE [dbo].[ReadChunkPortion]
@ChunkPointer binary(16),
@IsPermanentSnapshot bit,
@DataIndex int,
@Length int
AS
IF @IsPermanentSnapshot != 0 BEGIN
READTEXT ChunkData.Content @ChunkPointer @DataIndex @Length
END ELSE BEGIN
READTEXT [ReportServer$SQLEXPRESSTempDB].dbo.ChunkData.Content @ChunkPointer @DataIndex @Length
END
< \ 8
CREATE PROCEDURE [dbo].[CreateNewActiveSubscription]
@ActiveID uniqueidentifier,
@SubscriptionID uniqueidentifier
AS
-- Insert into the activesubscription table
insert into [ActiveSubscriptions]
(
[ActiveID],
[SubscriptionID],
[TotalNotifications],
[TotalSuccesses],
[TotalFailures]
)
values
(
@ActiveID,
@SubscriptionID,
NULL,
0,
0
)
< Y[ 8
CREATE PROCEDURE [dbo].[GetExecutionOptions]
@Path nvarchar(425)
AS
SELECT ExecutionFlag,
S.[ScheduleID],
S.[Name],
S.[StartDate],
S.[Flags],
S.[NextRunTime],
S.[LastRunTime],
S.[EndDate],
S.[RecurrenceType],
S.[MinutesInterval],
S.[DaysInterval],
S.[WeeksInterval],
S.[DaysOfWeek],
S.[DaysOfMonth],
S.[Month],
S.[MonthlyWeek],
S.[State],
S.[LastRunStatus],
S.[ScheduledRunTimeout],
S.[EventType],
S.[EventData],
S.[Type],
S.[Path]
FROM Catalog
LEFT OUTER JOIN ReportSchedule ON Catalog.ItemID = ReportSchedule.ReportID AND ReportSchedule.ReportAction = 1
LEFT OUTER JOIN [Schedule] S ON S.ScheduleID = ReportSchedule.ScheduleID
LEFT OUTER JOIN [Users] Owner on Owner.UserID = S.[CreatedById]
WHERE Catalog.Path = @Path
0 /[ k8
CREATE PROCEDURE [dbo].[PromoteSnapshotInfo]
@SnapshotDataID as uniqueidentifier,
@IsPermanentSnapshot as bit,
@PageCount as int,
@HasDocMap as bit,
@PaginationMode as smallint,
@ProcessingFlags as int
AS
-- HasDocMap: Processing engine may not
-- compute this flag in all cases, which
-- can lead to it being false when passed into
-- this proc, however the server needs this
-- flag to be true if it was ever set to be
-- true in order to communicate that there is a
-- document map to the viewer control.
IF @IsPermanentSnapshot = 1
BEGIN
UPDATE SnapshotData SET
PageCount = @PageCount,
HasDocMap = COALESCE(@HasDocMap | HasDocMap, @HasDocMap),
PaginationMode = @PaginationMode,
ProcessingFlags = @ProcessingFlags
WHERE SnapshotDataID = @SnapshotDataID
END ELSE BEGIN
UPDATE [ReportServer$SQLEXPRESSTempDB].dbo.SnapshotData SET
PageCount = @PageCount,
HasDocMap = COALESCE(@HasDocMap | HasDocMap, @HasDocMap),
PaginationMode = @PaginationMode,
ProcessingFlags = @ProcessingFlags
WHERE SnapshotDataID = @SnapshotDataID
END
0 h\ D8
CREATE PROCEDURE [dbo].[UpdateSnapshotPaginationInfo]
@SnapshotDataID as uniqueidentifier,
@IsPermanentSnapshot as bit,
@PageCount as int,
@PaginationMode as smallint
AS
IF @IsPermanentSnapshot = 1
BEGIN
UPDATE SnapshotData SET
PageCount = @PageCount,
PaginationMode = @PaginationMode
WHERE SnapshotDataID = @SnapshotDataID
END ELSE BEGIN
UPDATE [ReportServer$SQLEXPRESSTempDB].dbo.SnapshotData SET
PageCount = @PageCount,
PaginationMode = @PaginationMode
WHERE SnapshotDataID = @SnapshotDataID
END
0 c[ 8
CREATE PROCEDURE [dbo].[GetSnapshotChunks]
@SnapshotDataID uniqueidentifier,
@IsPermanentSnapshot bit
AS
IF @IsPermanentSnapshot != 0 BEGIN
SELECT ChunkName, ChunkType, ChunkFlags, MimeType, Version, datalength(Content)
FROM ChunkData
WHERE
SnapshotDataID = @SnapshotDataID
END ELSE BEGIN
SELECT ChunkName, ChunkType, ChunkFlags, MimeType, Version, datalength(Content)
FROM [ReportServer$SQLEXPRESSTempDB].dbo.ChunkData
WHERE
SnapshotDataID = @SnapshotDataID
END
0 >W\ Z8
CREATE PROCEDURE [dbo].[SetDrillthroughReports]
@ReportID uniqueidentifier,
@ModelID uniqueidentifier,
@ModelItemID nvarchar(425),
@Type tinyint
AS
SET NOCOUNT OFF
INSERT INTO ModelDrill (ModelDrillID, ModelID, ReportID, ModelItemID, [Type])
VALUES (newid(), @ModelID, @ReportID, @ModelItemID, @Type)
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!kkkk B < S b < ^ 8
CREATE PROCEDURE [dbo].[DeleteOneChunk]
@SnapshotID uniqueidentifier,
@IsPermanentSnapshot bit,
@ChunkName nvarchar(260),
@ChunkType int
AS
SET NOCOUNT OFF
-- for segmented chunks we just need to
-- remove the mapping, the cleanup thread
-- will pick up the rest of the pieces
IF @IsPermanentSnapshot != 0 BEGIN
DELETE ChunkData
WHERE
SnapshotDataID = @SnapshotID AND
ChunkName = @ChunkName AND
ChunkType = @ChunkType
DELETE SegmentedChunk
WHERE
SnapshotDataId = @SnapshotID AND
ChunkName = @ChunkName AND
ChunkType = @ChunkType
END ELSE BEGIN
DELETE [ReportServer$SQLEXPRESSTempDB].dbo.ChunkData
WHERE
SnapshotDataID = @SnapshotID AND
ChunkName = @ChunkName AND
ChunkType = @ChunkType
DELETE [ReportServer$SQLEXPRESSTempDB].dbo.SegmentedChunk
WHERE
SnapshotDataId = @SnapshotID AND
ChunkName = @ChunkName AND
ChunkType = @ChunkType
END
< .^ $8
CREATE PROCEDURE [dbo].[CreateCacheUpdateNotifications]
@ReportID uniqueidentifier,
@LastRunTime datetime
AS
update [Subscriptions]
set
[LastRunTime] = @LastRunTime
from
[Subscriptions] S
where
S.[Report_OID] = @ReportID and S.EventType = 'SnapshotUpdated' and InactiveFlags = 0
-- Find all valid subscriptions for the given report and create a new notification row for
-- each subscription
insert into [Notifications]
(
[NotificationID],
[SubscriptionID],
[ActivationID],
[ReportID],
[ReportZone],
[SnapShotDate],
[ExtensionSettings],
[Locale],
[Parameters],
[NotificationEntered],
[SubscriptionLastRunTime],
[DeliveryExtension],
[SubscriptionOwnerID],
[IsDataDriven],
[Version]
)
select
NewID(),
S.[SubscriptionID],
NULL,
S.[Report_OID],
S.[ReportZone],
NULL,
S.[ExtensionSettings],
S.[Locale],
S.[Parameters],
GETUTCDATE(),
S.[LastRunTime],
S.[DeliveryExtension],
S.[OwnerID],
0,
S.[Version]
from
[Subscriptions] S inner join Catalog C on S.[Report_OID] = C.[ItemID]
where
C.[ItemID] = @ReportID and S.EventType = 'SnapshotUpdated' and InactiveFlags = 0 and
S.[DataSettings] is null
-- Create any data driven subscription by creating a data driven event
insert into [Event]
(
[EventID],
[EventType],
[EventData],
[TimeEntered]
)
select
NewID(),
'DataDrivenSubscription',
S.SubscriptionID,
GETUTCDATE()
from
[Subscriptions] S inner join Catalog C on S.[Report_OID] = C.[ItemID]
where
C.[ItemID] = @ReportID and S.EventType = 'SnapshotUpdated' and InactiveFlags = 0 and
S.[DataSettings] is not null
< ^ N8
CREATE PROCEDURE [dbo].[CreateChunkAndGetPointer]
@SnapshotDataID uniqueidentifier,
@IsPermanentSnapshot bit,
@ChunkName nvarchar(260),
@ChunkType int,
@MimeType nvarchar(260) = NULL,
@Version smallint,
@Content image,
@ChunkFlags tinyint = NULL,
@ChunkPointer binary(16) OUTPUT
AS
DECLARE @ChunkID uniqueidentifier
SET @ChunkID = NEWID()
IF @IsPermanentSnapshot != 0 BEGIN
DELETE ChunkData
WHERE
SnapshotDataID = @SnapshotDataID AND
ChunkName = @ChunkName AND
ChunkType = @ChunkType
INSERT
INTO ChunkData
(ChunkID, SnapshotDataID, ChunkName, ChunkType, MimeType, Version, ChunkFlags, Content)
VALUES
(@ChunkID, @SnapshotDataID, @ChunkName, @ChunkType, @MimeType, @Version, @ChunkFlags, @Content)
SELECT @ChunkPointer = TEXTPTR(Content)
FROM ChunkData
WHERE ChunkData.ChunkID = @ChunkID
END ELSE BEGIN
DELETE [ReportServer$SQLEXPRESSTempDB].dbo.ChunkData
WHERE
SnapshotDataID = @SnapshotDataID AND
ChunkName = @ChunkName AND
ChunkType = @ChunkType
INSERT
INTO [ReportServer$SQLEXPRESSTempDB].dbo.ChunkData
(ChunkID, SnapshotDataID, ChunkName, ChunkType, MimeType, Version, ChunkFlags, Content)
VALUES
(@ChunkID, @SnapshotDataID, @ChunkName, @ChunkType, @MimeType, @Version, @ChunkFlags, @Content)
SELECT @ChunkPointer = TEXTPTR(Content)
FROM [ReportServer$SQLEXPRESSTempDB].dbo.ChunkData AS CH
WHERE CH.ChunkID = @ChunkID
END
0 t^ 8
-- add new record to History table
CREATE PROCEDURE [dbo].[AddHistoryRecord]
@HistoryID uniqueidentifier,
@ReportID uniqueidentifier,
@SnapshotDate datetime,
@SnapshotDataID uniqueidentifier,
@SnapshotTransientRefcountChange int
AS
INSERT
INTO History (HistoryID, ReportID, SnapshotDataID, SnapshotDate)
VALUES (@HistoryID, @ReportID, @SnapshotDataID, @SnapshotDate)
IF @@ERROR = 0
BEGIN
UPDATE SnapshotData
-- Snapshots, when created, have transient refcount set to 1. Here create permanent reference
-- here so we need to increase permanent refcount and decrease transient refcount. However,
-- if it was already referenced by the execution snapshot, transient refcount was already
-- decreased. Hence, there's a parameter @SnapshotTransientRefcountChange that is 0 or -1.
SET PermanentRefcount = PermanentRefcount + 1, TransientRefcount = TransientRefcount + @SnapshotTransientRefcountChange
WHERE SnapshotData.SnapshotDataID = @SnapshotDataID
END
0 ?^ E8
CREATE PROCEDURE [dbo].[GetDrillthroughReports]
@ModelID uniqueidentifier,
@ModelItemID nvarchar(425)
AS
SELECT
ModelDrill.Type,
Catalog.Path
FROM ModelDrill INNER JOIN Catalog ON ModelDrill.ReportID = Catalog.ItemID
WHERE ModelID = @ModelID
AND ModelItemID = @ModelItemID
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!