USE [RanUser]
Go
/****** Object: StoredProcedure [dbo].[gm_login] Script Date: 4/3/2021 12:09:26 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[gm_login]
@userId Char(50),
@userPass Char(50),
@authenticate Char(50),
@nReturn int OUTPUT
AS
DECLARE @nUserNum int,
@nUserType int
SET NOCOUNT ON
SET @nReturn = 0
SET @nUserNum = 0
SELECT @nUserNum = GSUserInfo.UserNum, @nUserType= GSUserInfo.UserType
FROM GSUserInfo
WHERE UserID = @userId AND UserPass = @userPass AND UserAvailable = 1 AND UserType>=20
-- PRINT @nUserNum
-- ID / PWD 체크...
IF @nUserNum = 0
BEGIN
-- ID / PWD 불일치 또는 사용불가능상태
SET @nReturn = 0
END
ELSE
BEGIN
-- ID / PWD 일치
SET @nReturn = @nUserType
-- 접속로그 남기기
INSERT INTO LogGmCmd (UserNum, GmCmd, UserIP)
VALUES (@nUserNum, 'LOGIN GMTOOL UserID:' + @userId, @userId)
END
SET NOCOUNT OFF
RETURN @nReturn