| | |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | | IList<Sys_Permissions_UserCase> result = _dataBase.SelectModel<Sys_Permissions_UserCase>(" a.* ", " dbo.Sys_Permissions_UserCase AS a LEFT JOIN dbo.Sys_Permissions_Menu AS b ON a.MenuId = b.Keyid LEFT JOIN dbo.Sys_Permissions_RoleMenuRelation AS c ON b.Keyid = c.MenuIdThree ", string.Format(" b.MenuPath='{0}' AND c.RoleId ='{1}' AND CHARINDEX(CONVERT(VARCHAR(20),a.Keyid),c.FuncId)=0 ", MenuPath, RoleId)) as IList<Sys_Permissions_UserCase>;//执行查询 |
|---|
| | | IList<Sys_Permissions_UserCase> result = _dataBase.SelectModel<Sys_Permissions_UserCase>(" a.* ", " dbo.Sys_Permissions_UserCase AS a LEFT JOIN dbo.Sys_Permissions_Menu AS b ON a.MenuId = b.Keyid LEFT JOIN dbo.Sys_Permissions_RoleMenuRelation AS c ON b.Keyid = c.MenuIdThree ", string.Format(" b.MenuPath like '%{0}' AND c.RoleId ='{1}' AND CHARINDEX(CONVERT(VARCHAR(20),a.Keyid),c.FuncId)>=0 ", MenuPath, RoleId)) as IList<Sys_Permissions_UserCase>;//执行查询 |
|---|
| | | |
|---|
| | | return result; |
|---|
| | | } |
|---|
