public List <VM.Common.PermissionLevel> GetPermissionLevelList(int userID)
{
var sp = new MD.StoredProcedure.usp_GetUserPermissionLevel()
{
UserID = userID
};
var perms = ctx.InvokeStoredProcedure <MD.StoredProcedure.usp_GetUserPermissionLevel, VM.Common.PermissionLevel>(sp);
return(perms);
}
public List <VM.Common.PermissionLevel> GetPermissionLevelList(int userID)
{
var sp = new MD.StoredProcedure.usp_GetUserPermissionLevel()
{
UserID = userID
};
//var perms = ctx.InvokeStoredProcedure<MD.StoredProcedure.usp_GetUserPermissionLevel, VM.Common.PermissionLevel>(sp);
/*
* ALTER PROCEDURE[dbo].[usp_GetUserPermissionLevel]
* @UserID int
* AS
* BEGIN
* -- SET NOCOUNT ON added to prevent extra result sets from
* -- interfering with SELECT statements.
* SET NOCOUNT ON;
* SELECT DISTINCT
* FPL.[FunctionName]
* , FPL.[PermissionLevel] AS[LevelName]
* FROM[dbo].[Common_Authen_RoleFunctionPermission]
* AS RFP
* INNER JOIN[dbo].[Common_Authen_FunctionPermissionLevel]
* AS FPL
* ON RFP.[PermissionLevelID] = FPL.ID
* INNER JOIN [dbo].[Common_Authen_RoleUser] AS ARU
* ON ARU.[RoleID] = RFP.[RoleID]
* WHERE ARU.[UserID] = @UserID
* END
*/
var perms = from fpl in ctx.Common_Authen_FunctionPermissionLevel
join rfp in ctx.Common_Authen_RoleFunctionPermission on fpl.ID equals rfp.PermissionLevelID into pls
from pl in pls
join aru in ctx.Common_Authen_RoleUser on pl.RoleID equals aru.RoleID
where aru.UserID == userID
select new VM.Common.PermissionLevel
{
ID = -1, //无用
Available = true, //无用
FunctionName = fpl.FunctionName,
LevelName = fpl.PermissionLevel
};
return(perms.ToList());
}
