Example #1
0
        /// <summary>
        /// 操作权限列表
        /// </summary>
        /// <param name="moduleId">模块主键</param>
        /// <returns>数据表</returns>
        private DataTable GetPermissionItemDT(string moduleId)
        {
            string commandText = @" SELECT  *
                                      FROM BasePermissionItem
                                     WHERE (Id IN
                                                (SELECT PermissionId
                                                   FROM BasePermission
                                                  WHERE (ResourceId = '" + moduleId + @"') 
                                                        AND (ResourceCategory = 'BaseModule') 
                                                        AND (DeletionStateCode = 0)))
                                            AND (Enabled = 1) 
                                            AND (DeletionStateCode = 0)
                                   ORDER BY SortCode ";

            BasePermissionItemManager permissionItemManager = new BasePermissionItemManager(this.UserInfo);

            return(permissionItemManager.Fill(commandText));
        }