asp net MVC2.0项目模板源码

2010/5/14 11:32:21 SELECT CASE WHEN ( EXISTS (SELECT 1 AS [C1] FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent1] INNER JOIN [dbo].[Sys_Actions] AS [Extent2] ON [Extent1].[ActionId] = [Extent2].[Id] INNER JOIN [dbo].[Sys_Controllers] AS [Extent3] ON [Extent1].[ControllerId] = [Extent3].[Id] WHERE ([Extent2].[ActionName] = @p__linq__0) AND ([Extent3].[ControllerName] = @p__linq__1) AND ( EXISTS (SELECT 1 AS [C1] FROM [dbo].[Sys_UsersInRoles] AS [Extent4] INNER JOIN [dbo].[Sys_Users] AS [Extent5] ON [Extent4].[Sys_UsersId] = [Extent5].[Id] WHERE ([Extent1].[RoleId] = [Extent4].[Sys_RolesId]) AND ([Extent5].[UserName] = @p__linq__2) )) )) THEN cast(1 as bit) WHEN ( NOT EXISTS (SELECT 1 AS [C1] FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent6] INNER JOIN [dbo].[Sys_Actions] AS [Extent7] ON [Extent6].[ActionId] = [Extent7].[Id] INNER JOIN [dbo].[Sys_Controllers] AS [Extent8] ON [Extent6].[ControllerId] = [Extent8].[Id] WHERE ([Extent7].[ActionName] = @p__linq__0) AND ([Extent8].[ControllerName] = @p__linq__1) AND ( EXISTS (SELECT 1 AS [C1] FROM [dbo].[Sys_UsersInRoles] AS [Extent9] INNER JOIN [dbo].[Sys_Users] AS [Extent10] ON [Extent9].[Sys_UsersId] = [Extent10].[Id] WHERE ([Extent6].[RoleId] = [Extent9].[Sys_RolesId]) AND ([Extent10].[UserName] = @p__linq__2) )) )) THEN cast(0 as bit) END AS [C1] FROM ( SELECT 1 AS X ) AS [SingleRowTable1] -- p__linq__0 (dbtype=String, size=-1, direction=Input) = "Index" -- p__linq__1 (dbtype=String, size=-1, direction=Input) = "Information_Content" -- p__linq__2 (dbtype=String, size=-1, direction=Input) = "admin" 2010/5/14 11:32:21 SELECT [GroupBy1].[A1] AS [C1] FROM ( SELECT COUNT(1) AS [A1] FROM [dbo].[Information_Content] AS [Extent1] WHERE [Extent1].[Deleted] = @p__linq__0 ) AS [GroupBy1] -- p__linq__0 (dbtype=Boolean, size=0, direction=Input) = False 2010/5/14 11:32:22 SELECT TOP (20) [Project1].[Id] AS [Id], [Project1].[ChannelId] AS [ChannelId], [Project1].[Title] AS [Title], [Project1].[Content] AS [Content], [Project1].[AddDate] AS [AddDate], [Project1].[LastEditDate] AS [LastEditDate], [Project1].[IsRecommend] AS [IsRecommend], [Project1].[IsTop] AS [IsTop], [Project1].[UserId] AS [UserId], [Project1].[Hits] AS [Hits], [Project1].[Deleted] AS [Deleted] FROM ( SELECT [Project1].[Id] AS [Id], [Project1].[ChannelId] AS [ChannelId], [Project1].[Title] AS [Title], [Project1].[Content] AS [Content], [Project1].[AddDate] AS [AddDate], [Project1].[LastEditDate] AS [LastEditDate], [Project1].[IsRecommend] AS [IsRecommend], [Project1].[IsTop] AS [IsTop], [Project1].[UserId] AS [UserId], [Project1].[Hits] AS [Hits], [Project1].[Deleted] AS [Deleted], row_number() OVER (ORDER BY [Project1].[IsTop] DESC, [Project1].[AddDate] DESC) AS [row_number] FROM ( SELECT [Extent1].[Id] AS [Id], [Extent1].[ChannelId] AS [ChannelId], [Extent1].[Title] AS [Title], [Extent1].[Content] AS [Content], [Extent1].[AddDate] AS [AddDate], [Extent1].[LastEditDate] AS [LastEditDate], [Extent1].[IsRecommend] AS [IsRecommend], [Extent1].[IsTop] AS [IsTop], [Extent1].[UserId] AS [UserId], [Extent1].[Hits] AS [Hits], [Extent1].[Deleted] AS [Deleted] FROM [dbo].[Information_Content] AS [Extent1] WHERE [Extent1].[Deleted] = @p__linq__0 ) AS [Project1] ) AS [Project1] WHERE [Project1].[row_number] > 0 ORDER BY [Project1].[IsTop] DESC, [Project1].[AddDate] DESC -- p__linq__0 (dbtype=Boolean, size=0, direction=Input) = False 2010/5/14 11:32:22 SELECT [Extent1].[Id] AS [Id], [Extent1].[DisplayName] AS [DisplayName], [Extent1].[Abbreviate] AS [Abbreviate], [Extent1].[lft] AS [lft], [Extent1].[rgt] AS [rgt], [Extent1].[lvl] AS [lvl], [Extent1].[LastId] AS [LastId], [Extent1].[TemplateId] AS [TemplateId] FROM [dbo].[Information_Channel] AS [Extent1] WHERE [Extent1].[Id] = @EntityKeyValue1 -- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = 70b7eb4a-6dc0-4edf-8a64-7fb86b7ddc72 2010/5/14 11:32:22 SELECT [Extent1].[Id] AS [Id], [Extent1].[UserName] AS [UserName], [Extent1].[Password] AS [Password], [Extent1].[LastActivityDate] AS [LastActivityDate], [Extent1].[Description] AS [Description], [Extent1].[IP] AS [IP], [Extent1].[Email] AS [Email] FROM [dbo].[Sys_Users] AS [Extent1] WHERE [Extent1].[Id] = @EntityKeyValue1 -- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = d8bbe7ab-9728-4464-9e18-49a2e4fcd524 2010/5/14 11:32:22 SELECT [Extent1].[Id] AS [Id], [Extent1].[DisplayName] AS [DisplayName], [Extent1].[Abbreviate] AS [Abbreviate], [Extent1].[lft] AS [lft], [Extent1].[rgt] AS [rgt], [Extent1].[lvl] AS [lvl], [Extent1].[LastId] AS [LastId], [Extent1].[TemplateId] AS [TemplateId] FROM [dbo].[Information_Channel] AS [Extent1] WHERE [Extent1].[Id] = @EntityKeyValue1 -- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = 0a09c965-ef70-4659-aa7f-283b96ccd277 2010/5/14 11:33:17 SELECT CASE WHEN ( EXISTS (SELECT 1 AS [C1] FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent1] INNER JOIN [dbo].[Sys_Actions] AS [Extent2] ON [Extent1].[ActionId] = [Extent2].[Id] INNER JOIN [dbo].[Sys_Controllers] AS [Extent3] ON [Extent1].[ControllerId] = [Extent3].[Id] WHERE ([Extent2].[ActionName] = @p__linq__0) AND ([Extent3].[ControllerName] = @p__linq__1) AND ( EXISTS (SELECT 1 AS [C1] FROM [dbo].[Sys_UsersInRoles] AS [Extent4] INNER JOIN [dbo].[Sys_Users] AS [Extent5] ON [Extent4].[Sys_UsersId] = [Extent5].[Id] WHERE ([Extent1].[RoleId] = [Extent4].[Sys_RolesId]) AND ([Extent5].[UserName] = @p__linq__2) )) )) THEN cast(1 as bit) WHEN ( NOT EXISTS (SELECT 1 AS [C1] FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent6] INNER JOIN [dbo].[Sys_Actions] AS [Extent7] ON [Extent6].[ActionId] = [Extent7].[Id] INNER JOIN [dbo].[Sys_Controllers] AS [Extent8] ON [Extent6].[ControllerId] = [Extent8].[Id] WHERE ([Extent7].[ActionName] = @p__linq__0) AND ([Extent8].[ControllerName] = @p__linq__1) AND ( EXISTS (SELECT 1 AS [C1] FROM [dbo].[Sys_UsersInRoles] AS [Extent9] INNER JOIN [dbo].[Sys_Users] AS [Extent10] ON [Extent9].[Sys_UsersId] = [Extent10].[Id] WHERE ([Extent6].[RoleId] = [Extent9].[Sys_RolesId]) AND ([Extent10].[UserName] = @p__linq__2) )) )) THEN cast(0 as bit) END AS [C1] FROM ( SELECT 1 AS X ) AS [SingleRowTable1] -- p__linq__0 (dbtype=String, size=-1, direction=Input) = "Edit" -- p__linq__1 (dbtype=String, size=-1, direction=Input) = "Information_Content" -- p__linq__2 (dbtype=String, size=-1, direction=Input) = "admin" 2010/5/14 11:33:17 SELECT TOP (2) [Extent1].[Id] AS [Id], [Extent1].[ChannelId] AS [ChannelId], [Extent1].[Title] AS [Title], [Extent1].[Content] AS [Content], [Extent1].[AddDate] AS [AddDate], [Extent1].[LastEditDate] AS [LastEditDate], [Extent1].[IsRecommend] AS [IsRecommend], [Extent1].[IsTop] AS [IsTop], [Extent1].[UserId] AS [UserId], [Extent1].[Hits] AS [Hits], [Extent1].[Deleted] AS [Deleted] FROM [dbo].[Information_Content] AS [Extent1] WHERE [Extent1].[Id] = @p__linq__0 -- p__linq__0 (dbtype=Guid, size=0, direction=Input) = 013a31ad-64f7-4888-8355-dace4a28dc8a 2010/5/14 11:33:17 SELECT [Extent1].[Id] AS [Id], [Extent1].[DisplayName] AS [DisplayName], [Extent1].[Abbreviate] AS [Abbreviate], [Extent1].[lft] AS [lft], [Extent1].[rgt] AS [rgt], [Extent1].[lvl] AS [lvl], [Extent1].[LastId] AS [LastId], [Extent1].[TemplateId] AS [TemplateId] FROM [dbo].[Information_Channel] AS [Extent1] ORDER BY [Extent1].[lft] ASC 2010/5/14 11:33:24 SELECT TOP (2) [Extent1].[Id] AS [Id], [Extent1].[UserName] AS [UserName], [Extent1].[Password] AS [Password], [Extent1].[LastActivityDate] AS [LastActivityDate], [Extent1].[Description] AS [Description], [Extent1].[IP] AS [IP], [Extent1].[Email] AS [Email] FROM [dbo].[Sys_Users] AS [Extent1] WH