PRINT '# 创建存储过程 proGetPanelID...'
GO
IF EXISTS (SELECT 1 FROM sysobjects WHERE name LIKE 'proGetPanelID')
DROP PROCEDURE proGetPanelID
GO
CREATE PROCEDURE proGetPanelID
(
@UserID INT
)
WITH ENCRYPTION
AS
BEGIN
--DECLARE @retRANDS VARCHAR(35),@retKi VARCHAR(32)
BEGIN TRANSACTION
SELECT A.ID ,A.Ver from CfgPanel A, CfgUser B
WHERE B.ID=@UserID and A.UserID = B.ID
COMMIT TRANSACTION
END
GO
GRANT EXECUTE ON proGetPanelID TO PUBLIC
GO
PRINT '# 创建存储过程 proGetPanelInfo...'
GO
IF EXISTS (SELECT 1 FROM sysobjects WHERE name LIKE 'proGetPanelInfo')
DROP PROCEDURE proGetPanelInfo
GO
CREATE PROCEDURE proGetPanelInfo
(
@PID INT
)
WITH ENCRYPTION
AS
BEGIN
--DECLARE @retRANDS VARCHAR(35),@retKi VARCHAR(32)
BEGIN TRANSACTION
SELECT PATH from CfgPanel where ID=@PID
Select PIC_PATH from CfgPanelPic where PID=@PID
COMMIT TRANSACTION
END
GO
GRANT EXECUTE ON proGetPanelInfo TO PUBLIC
GO