查询加数据权限
USE [MJ2009]
GO
/****** Object: StoredProcedure [dbo].[p_OrderInfo_Select] Script Date: 2014/4/3 16:17:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: cheng
-- Create date: 2012-06-12
-- Description: 订单表分页查询
-- =============================================
ALTER PROCEDURE [dbo].[p_OrderInfo_Select] (
***@where NVARCHAR(4000),
***@order NVARCHAR(200),
***@pagesize INT,
***@page INT,
***@totalcount INT OUTPUT,
***@userID INT,
***@departID VARCHAR(50),
***@Export INT = 0
)
AS
BEGIN
SET NOCOUNT ON;
DECLARE ***@rights VARCHAR(8000)
DECLARE ***@rightResult VARCHAR(8000)
SET ***@rightResult = (***@userID, ***@departID)
IF ( ***@userID = -1 OR ***@rightResult = 'all' )--管理员,不做任何操作
BEGIN
SET ***@rights = ''
END
ELSE
begin
IF ( ***@rightResult = '' )--本人权限
BEGIN
SET ***@rights = ' AND (=' + CONVERT(VARCHAR(100), ***@userID)
+ ' OR =' + CONVERT(VARCHAR(100), ***@userID) + ')' END
ELSE --设置权限
BEGIN
SET ***@rights = ' AND ( IN (' + ***@rightResult
+ ') OR =' + CONVERT(VARCHAR(100), ***@userID)
查询加数据权限 来自淘豆网www.taodocs.com转载请标明出处.