Notes

[MainThread]
SleepTerm = 0
SleepValue = 0
SleepIgnore = 1

        

[DQSThread]
SleepTerm = 0
SleepValue = 0
SleepIgnore = 1

        

                            
/* HGK BILLING */
USE [BILLING]
GO
ALTER PROCEDURE pAddCashAmount
    @s_userid varchar(20),
    @s_subsystem_name varchar(64),
    @s_cash float
AS
BEGIN
    SET NOCOUNT ON;
    DECLARE @before_amount float = -1
    DECLARE @after_amount float = -1

    UPDATE [dbo].[tbl_UserStatus]
    SET  @before_amount = [Cash], [Cash] += @s_cash, @after_amount = [Cash] + @s_cash
    WHERE [id] = CONVERT(binary,@s_userid);

    INSERT INTO [dbo].[tbl_change_amount] ([userid],[subsystem_name],[change],[before_amount],[after_amount],[Date])
    VALUES (@s_userid,@s_subsystem_name,@s_cash,@before_amount,@after_amount,GETDATE())

    SELECT 1 as operation_status;
END
GO

USE [BILLING]
GO
ALTER PROCEDURE pAddPcBangTime
    @s_userid varchar(20),
    @s_subsystem_name varchar(64),
    @addhour int
AS
BEGIN
    SET NOCOUNT ON;
    IF (SELECT Status As BillType FROM [tbl_UserStatus] WHERE Id = CONVERT(binary,@s_userid)) = 2
        UPDATE [tbl_UserStatus] SET DTEndPrem = DATEADD(HOUR, @addhour, DTEndPrem) WHERE Id = CONVERT(binary,@s_userid);
    ELSE
        UPDATE [tbl_UserStatus] SET Status = 2, DTEndPrem = DATEADD(HOUR, @addhour, GETDATE()) WHERE Id = CONVERT(binary,@s_userid);

    SELECT 1 as operation_status;
END
GO

USE [BILLING]
GO
ALTER PROCEDURE [dbo].[pGetPcBangTime]
    @s_userid varchar(20)
AS
BEGIN
    SET NOCOUNT ON;
    SELECT DTEndPrem as pc_bang_end FROM [tbl_UserStatus] WHERE Id = CONVERT(binary,@s_userid);
END
GO

USE [BILLING]
GO
ALTER PROCEDURE pSubCashAmount
    @s_userid varchar(20),
    @s_subsystem_name varchar(64),
    @s_cash float
AS
BEGIN
    SET NOCOUNT ON;
    BEGIN TRANSACTION;
    BEGIN TRY
        IF @s_cash <= 0
            SELECT 0 as operation_status;
        ELSE BEGIN
            DECLARE @before_amount float = -1
            DECLARE @after_amount float = -1

            UPDATE [dbo].[tbl_UserStatus]
            SET  @before_amount = [Cash], [Cash] -= @s_cash, @after_amount = [Cash] - @s_cash
            WHERE [Id] = CONVERT(binary,@s_userid);

            INSERT INTO [dbo].[tbl_change_amount] ([userid],[subsystem_name],[change],[before_amount],[after_amount],[Date])
            VALUES (@s_userid, @s_subsystem_name, -@s_cash, @before_amount, @after_amount, GETDATE())

            SELECT
                CASE
                    WHEN @after_amount < 0 THEN 0
                    ELSE 1
                END as operation_status;

            IF @after_amount < 0
                RAISERROR (15600,-1,-1, 'pSubCashAmount');
        END
    END TRY
    BEGIN CATCH
        IF @@TRANCOUNT > 0
            ROLLBACK TRANSACTION;
    END CATCH;

    IF @@TRANCOUNT > 0
        COMMIT TRANSACTION;
END
GO
/*END OF LINE HGK */
                            
                        

                            
USE [BILLING]
GO
ALTER PROCEDURE [dbo].[RF_CheckBalance]
    @Login varchar(13),
    @Balance bigint = 0 OUTPUT
AS
BEGIN
    SET NOCOUNT ON;

    IF NOT EXISTS (SELECT Cash FROM [dbo].[tbl_UserStatus] WITH (NOLOCK) WHERE id = CONVERT(binary, @Login)) BEGIN
        INSERT INTO [dbo].[tbl_UserStatus] (Id, Status, Cash, DTStartPrem, DTEndPrem) VALUES (CONVERT(binary, @Login), 1, 0, GETDATE(), GETDATE());
        SET @Balance = 0;
    END
    ELSE BEGIN
        SET @Balance = (SELECT [Cash] FROM [dbo].[tbl_UserStatus] WITH (NOLOCK) WHERE [Id] = CONVERT(binary, @Login));
    END
END
GO