

hbsilva3
-
Content Count
0 -
Joined
-
Last visited
-
roslaw bom dia poderia me passar a query
USE [RF_World]
GO
/****** Object: Trigger [dbo].[RF_TimeUpdate] Script Date: 06/02/2016 19:37:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOCREATE TRIGGER [dbo].[RF_TimeUpdate]
ON [dbo].[tbl_general]
AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON;
DECLARE @GSerial INT;
DECLARE @GDCK BIT;
DECLARE @GPlay INT;
DECLARE @GMap INT;
DECLARE @BSerial INT;
DECLARE @BDCK BIT;
DECLARE @BAccountSerial INT;
DECLARE @BAccountName VARCHAR(17);
DECLARE @BLevel INT;
DECLARE @BLogLevel INT;
DECLARE @BPlay INT;
DECLARE @TimeDiff INT;
-- Binding Refresh Update for Column TotalPlayMin on tbl_general.
IF UPDATE([TotalPlayMin])
BEGIN
SELECT
@GSerial = [Serial],
@GDCK = [DCK],
@GPlay = [TotalPlayMin],
@GMap = [Map]
FROM INSERTED
IF (@GSerial > 0 AND @GDCK = 0)
BEGIN
SELECT
@BSerial = [Serial],
@BDCK = [DCK],
@BAccountSerial = [AccountSerial],
@BAccountName = [Account],
@BLevel = [Lv],
@BLogLevel = [LogLevel],
@BPlay = [LogPlay]
FROM [dbo].[tbl_base]
WHERE [Serial] = @GSerial
-- Calculating Time Different OldTimePlay and CurrentTimePlay.
SET @TimeDiff = @[email protected]
IF (@BSerial > 0 AND @BPlay > 0 AND @BLogLevel > 0 AND @BDCK = 0)
BEGIN
-- Executing Procedure RF_Autocash to Update Cashpoint Formula.
EXEC [BILLING].[dbo].[RF_Autocash]
@AName = @BAccountName,
@ALevel = @BLevel,
@ALevelLog = @BLogLevel,
@ATimeDiff = @TimeDiff,
@AMap = @GMap
END
IF (@BLogLevel < 1)
BEGIN
SET @BLevel = 1
END
-- Executing Procedure RF_LogTime to Update Log.
EXEC [RF_WORLD].[dbo].[RF_LogTime]
@USerial = @GSerial,
@UTimePlay = @GPlay,
@ULevel = @BLevel
END
END
END