asp.net权限管理 系统源码

2013-09-23 10:57:14,324 [9984] DEBUG Sys - select name from dbo.sysobjects where id = object_id(N'[dbo].[fun_getPY]') and xtype in (N'FN', N'IF', N'TF') 2013-09-23 10:57:14,507 [9984] DEBUG Sys - select name from dbo.sysobjects where id = object_id(N'[dbo].[fun_getPY]') and xtype in (N'FN', N'IF', N'TF') 2013-09-23 10:57:14,515 [9984] DEBUG Mms - select name from dbo.sysobjects where id = object_id(N'[dbo].[fun_getPY]') and xtype in (N'FN', N'IF', N'TF') 2013-09-23 10:57:14,592 [9984] DEBUG Mms - select name from dbo.sysobjects where id = object_id(N'[dbo].[fun_getPY]') and xtype in (N'FN', N'IF', N'TF') 2013-09-23 11:23:40,085 [5940] DEBUG Servicesys_user - 获取实体对象 2013-09-23 11:23:40,152 [5940] DEBUG Sys - select sys_user.* from sys_user where UserCode = 'lhs'and Password = 'lhs'and IsEnable = 'True' 2013-09-23 11:23:40,318 [5940] DEBUG Sys - update sys_user set LoginCount = isnull(LoginCount,0) + 1 ,LastLoginDate = getdate() where UserCode = 'lhs' 2013-09-23 11:23:40,370 [5940] DEBUG Sys - insert into sys_loginHistory([UserCode],[UserName],[HostName],[HostIP],[LoginCity],[LoginDate]) values('lhs','刘会胜','LHS-PC','ILData[0]/localhost','福建省厦门市','2013-09-23 11:23:40') 2013-09-23 11:23:40,376 [5940] DEBUG Servicemms_project - 获取实体对象 2013-09-23 11:23:40,381 [5940] DEBUG Mms - select mms_project.* from mms_project where ProjectCode = '201306030001' 2013-09-23 11:23:40,621 [13376] DEBUG Sys - select * from sys_userSetting where UserCode='lhs' 2013-09-23 11:23:44,667 [12892] DEBUG Sys - --角色的菜单 select distinct B.* from sys_roleMenuMap A inner join sys_menu B on B.MenuCode = A.MenuCode where B.IsEnable='1' and RoleCode in ( select RoleCode from sys_userRoleMap where UserCode = 'lhs' --用户的角色 union all select RoleCode from sys_organizeRoleMap where OrganizeCode in --机构的角色 ( select OrganizeCode from sys_userOrganizeMap where UserCode = 'lhs' ) ) order by B.MenuSeq,B.MenuCode 2013-09-23 11:23:47,491 [5940] DEBUG Sys - select 1 from sys_roleMenuMap A left join sys_userRoleMap B on B.RoleCode = A.RoleCode left join sys_menu C on C.MenuCode = A.MenuCode where B.UserCode = 'lhs' and C.URL in ('/Sys/generator/Index','/Sys/generator') 2013-09-23 11:23:54,787 [5940] DEBUG Sys - SELECT Name as TableName FROM sys.tables order by Name 2013-09-23 11:23:54,800 [13376] DEBUG Sys - SELECT sys.columns.name AS ColumnName, type_name(sys.columns.system_type_id) AS SqlTypeName, sys.columns.max_length AS MaxLength, sys.columns.is_nullable AS IsNullable, sys.columns.is_identity AS IsIdentity, (case when exists(select 1 from syscolumns join sysindexkeys on syscolumns.id =sysindexkeys.id and syscolumns.colid=sysindexkeys.colid and syscolumns.id=sys.columns.object_id join sysindexes on syscolumns.id =sysindexes.id and sysindexkeys.indid=sysindexes.indid join sysobjects on sysindexes.name=sysobjects.name and sysobjects.xtype= 'PK ' where syscolumns.name = sys.columns.name) then 1 else 0 end) AS IsPrimaryKey, (select value from sys.extended_properties where sys.extended_properties.major_id = sys.columns.object_id and sys.extended_properties.minor_id = sys.columns.column_id) as Description FROM sys.columns WHERE sys.columns.object_id = object_id('undefined') ORDER BY sys.columns.column_id 2013-09-23 11:23:54,809 [2004] DEBUG Sys - SELECT sys.columns.name AS ColumnName, type_name(sys.columns.system_type_id) AS SqlTypeName, sys.columns.max_length AS MaxLength, sys.columns.is_nullable AS IsNullable, sys.columns.is_identity AS IsIdentity, (case when exists(select 1 from syscolumns join sysindexkeys on syscolumns.id =sysindexkeys.id and syscolumns.colid=sysindexkeys.colid and syscolumns.id=sys.columns.object_id join sysindexes on syscolumns.id =sysindexes.id and sysindexkeys.indid=sysindexes.indid join sysobjects on sysindexes.name=sysobjects.name and sysobjects.xtype= 'PK ' where syscolumns.name = sys.columns.name) then 1 else 0 end) AS IsPrimaryKey, (select value from sys.extended_properties where sys.extended_properties.major_id = sys.columns.object_id and sys.extended_properties.minor_id = sys.columns.column_id) as Description FROM sys.columns WHERE sys.columns.object_id = object_id('undefined') ORDER BY sys.columns.column_id 2013-09-23 11:23:56,106 [12892] DEBUG Sys - SELECT sys.columns.name AS ColumnName, type_name(sys.columns.system_type_id) AS SqlTypeName, sys.columns.max_length AS MaxLength, sys.columns.is_nullable AS IsNullable, sys.columns.is_identity AS IsIdentity, (case when exists(select 1 from syscolumns join sysindexkeys on syscolumns.id =sysindexkeys.id and syscolumns.colid=sysindexkeys.colid and syscolumns.id=sys.columns.object_id join sysindexes on syscolumns.id =sysindexes.id and sysindexkeys.indid=sysindexes.indid join sysobjects on sysindexes.name=sysobjects.name and sysobjects.xtype= 'PK ' where syscolumns.name = sys.columns.name) then 1 else 0 end) AS IsPrimaryKey, (select value from sys.extended_properties where sys.extended_properties.major_id = sys.columns.object_id and sys.extended_properties.minor_id = sys.columns.column_id) as Description FROM sys.columns WHERE sys.columns.object_id = object_id('sys_log') ORDER BY sys.columns.column_id 2013-09-23 11:23:56,111 [2004] DEBUG Sys - SELECT sys.columns.name AS ColumnName, type_name(sys.columns.system_type_id) AS SqlTypeName, sys.columns.max_length AS MaxLength, sys.columns.is_nullable AS IsNullable, sys.columns.is_identity AS IsIdentity, (case when exists(select 1 from syscolumns join sysindexkeys on syscolumns.id =sysindexkeys.id and syscolumns.colid=sysindexkeys.colid and syscolumns.id=sys.columns.object_id join sysindexes on syscolumns.id =sysindexes.id and sysindexkeys.indid=sysindexes.indid join sysobjects on sysindexes.name=sysobjects.name and sysobjects.xtype= 'PK ' where syscolumns.name = sys.columns.name) then 1 else 0 end) AS IsPrimaryKey, (select value from sys.extended_properties where sys.extended_properties.major_id = sys.columns.object_id and sys.extended_properties.minor_id = sys.columns.column_id) as Description FROM sys.columns WHERE sys.columns.object_id = object_id('sys_log') ORDER BY sys.columns.column_id 2013-09-23 11:24:12,509 [5940] DEBUG Sys - SELECT sys.columns.name AS ColumnName, type_name(sys.columns.system_type_id) AS SqlTypeName, sys.columns.max_length AS MaxLength, sys.columns.is_nullable AS IsNullable, sys.columns.is_identity AS IsIdentity, (case when exists(select 1 from syscolumns join sysindexkeys on syscolumns.id =sysindexkeys.id and syscolumns.colid=sysindexkeys.colid and syscolumns.id=sys.columns.object_id join sysindexes on syscolumns.id =sysindexes.id and sysindexkeys.indid=sysindexes.indid join sysobjects on sysindexes.name=sysobjects.name and sysobjects.xtype= 'PK ' where syscolumns.name = sys.columns.name) then 1 else 0 end) AS IsPrimaryKey, (select value from sys.extended_properties where sys.extended_properties.major_id = sys.columns.object_id and sys.extended_properties.minor_id = sys.columns.column_id) as Description FROM sys.columns WHERE sys.columns.object_id = object_id('sys_organize') ORDER BY sys.columns.column_id 2013-09-23 11:24:12,519 [13376] DEBUG Sys - SELECT sys.columns.name AS ColumnName, type_name(sys.columns.system_type_id) AS SqlTypeName, sys.columns.max_length AS MaxLength, sys.columns.is_nullable AS IsNullable, sys.columns.is_identity AS IsIdentity, (case when exists(select 1 f