SELECT TOP (2)
[Extent1].[Id] AS [Id],
[Extent1].[ParameterName] AS [ParameterName],
[Extent1].[parameters] AS [parameters]
FROM [dbo].[Sys_Parameter] AS [Extent1]
WHERE [Extent1].[ParameterName] = @p__linq__0
-- p__linq__0 (dbtype=String, size=-1, direction=Input) = "系统主名称"
SELECT TOP (2)
[Extent1].[Id] AS [Id],
[Extent1].[ParameterName] AS [ParameterName],
[Extent1].[parameters] AS [parameters]
FROM [dbo].[Sys_Parameter] AS [Extent1]
WHERE [Extent1].[ParameterName] = @p__linq__0
-- p__linq__0 (dbtype=String, size=-1, direction=Input) = "系统副名称"
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]
WHERE ([Extent1].[UserName] = @p__linq__0) AND ([Extent1].[Password] = @p__linq__1)
-- p__linq__0 (dbtype=String, size=-1, direction=Input) = "admin"
-- p__linq__1 (dbtype=String, size=-1, direction=Input) = "admin"
update [dbo].[Sys_Users]
set [LastActivityDate] = @0, [IP] = @1
where ([Id] = @2)
-- @0 (dbtype=DateTime2, size=0, direction=Input) = 2010/6/8 10:08:24
-- @1 (dbtype=String, size=50, direction=Input) = "127.0.0.1"
-- @2 (dbtype=Guid, size=0, direction=Input) = d8bbe7ab-9728-4464-9e18-49a2e4fcd524
SELECT
[Project6].[Id] AS [Id],
[Project6].[DisplayName] AS [DisplayName],
[Project6].[ControllerName] AS [ControllerName],
[Project6].[LastId] AS [LastId],
[Project6].[IntOrder] AS [IntOrder]
FROM ( SELECT
[Extent1].[Id] AS [Id],
[Extent1].[DisplayName] AS [DisplayName],
[Extent1].[ControllerName] AS [ControllerName],
[Extent1].[LastId] AS [LastId],
[Extent1].[IntOrder] AS [IntOrder]
FROM [dbo].[Sys_Controllers] AS [Extent1]
WHERE ([Extent1].[LastId] IS NULL) AND ( EXISTS (SELECT
1 AS [C1]
FROM ( SELECT
[Extent2].[Id] AS [Id]
FROM [dbo].[Sys_Controllers] AS [Extent2]
WHERE [Extent1].[Id] = [Extent2].[LastId]
) AS [Project1]
WHERE EXISTS (SELECT
1 AS [C1]
FROM ( SELECT
[Extent3].[RoleId] AS [RoleId]
FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent3]
WHERE [Project1].[Id] = [Extent3].[ControllerId]
) AS [Project2]
WHERE 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 ([Project2].[RoleId] = [Extent4].[Sys_RolesId]) AND ([Extent5].[UserName] = @p__linq__0)
)
)
))
) AS [Project6]
ORDER BY [Project6].[IntOrder] ASC
-- p__linq__0 (dbtype=String, size=-1, direction=Input) = "admin"
SELECT
[Extent1].[Id] AS [Id],
[Extent1].[DisplayName] AS [DisplayName],
[Extent1].[ControllerName] AS [ControllerName],
[Extent1].[LastId] AS [LastId],
[Extent1].[IntOrder] AS [IntOrder]
FROM [dbo].[Sys_Controllers] AS [Extent1]
WHERE [Extent1].[LastId] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = a2406a34-7fa2-4c6f-95ff-8ae819762199
SELECT
[Extent1].[ActionId] AS [ActionId],
[Extent1].[ControllerId] AS [ControllerId],
[Extent1].[RoleId] AS [RoleId]
FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent1]
WHERE [Extent1].[ControllerId] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = 5c4ade5c-babe-4e5c-849b-2024ddcdebb8
SELECT
[Extent1].[Id] AS [Id],
[Extent1].[RoleName] AS [RoleName],
[Extent1].[Description] AS [Description]
FROM [dbo].[Sys_Roles] AS [Extent1]
WHERE [Extent1].[Id] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = d5f9d408-caa1-4905-b70e-ce0ba3314818
SELECT
[Extent1].[Id] AS [Id],
[Extent1].[Sys_UsersId] AS [Sys_UsersId],
[Extent1].[Sys_RolesId] AS [Sys_RolesId]
FROM [dbo].[Sys_UsersInRoles] AS [Extent1]
WHERE [Extent1].[Sys_RolesId] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = d5f9d408-caa1-4905-b70e-ce0ba3314818
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
SELECT
[Extent1].[ActionId] AS [ActionId],
[Extent1].[ControllerId] AS [ControllerId],
[Extent1].[RoleId] AS [RoleId]
FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent1]
WHERE [Extent1].[ControllerId] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = 7138d757-8ce4-4fb7-9137-2de8175a8653
SELECT
[Extent1].[ActionId] AS [ActionId],
[Extent1].[ControllerId] AS [ControllerId],
[Extent1].[RoleId] AS [RoleId]
FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent1]
WHERE [Extent1].[ControllerId] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = 1d41349c-e0f1-4c07-85dc-9bf91ac6bd27
SELECT
[Extent1].[ActionId] AS [ActionId],
[Extent1].[ControllerId] AS [ControllerId],
[Extent1].[RoleId] AS [RoleId]
FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent1]
WHERE [Extent1].[ControllerId] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = 898d08d9-5eb2-407d-99f0-bac0a8f5b7f0
SELECT
[Extent1].[Id] AS [Id],
[Extent1].[DisplayName] AS [DisplayName],
[Extent1].[ControllerName] AS [ControllerName],
[Extent1].[LastId] AS [LastId],
[Extent1].[IntOrder] AS [IntOrder]
FROM [dbo].[Sys_Controllers] AS [Extent1]
WHERE [Extent1].[LastId] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = a5223b86-1630-4f6e-9196-facb8f83b83e
SELECT
[Extent1].[ActionId] AS [ActionId],
[Extent1].[ControllerId] AS [ControllerId],
[Extent1].[RoleId] AS [RoleId]
FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent1]
WHERE [Extent1].[ControllerId] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = 761c5f83-de35-4ead-9c1f-197897b0fde9
SELECT
[Extent1].[ActionId] AS [ActionId],
[Extent1].[ControllerId] AS [ControllerId],
[Extent1].[RoleId] AS [RoleId]
FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent1]
WHERE [Extent1].[ControllerId] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = a6ecd709-c188-40d1-bae1-1df142715889
SELECT
[Extent1].[ActionId] AS [ActionId],
[Extent1].[ControllerId] AS [ControllerId],
[Extent1].[RoleId] AS [RoleId]
FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent1]
WHERE [Extent1].[ControllerId] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = 2a9fca61-ea40-4efb-a9a8-58ab0a204be6
SELECT
[Extent1].[ActionId] AS [ActionId],
[Extent1].[ControllerId] AS [ControllerId],
[Extent1].[RoleId] AS [RoleId]
FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent1]
WHERE [Extent1].[ControllerId] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = 7d5249e0-185a-402f-86df-8e9614094751
SELECT
[Extent1].[ActionId] AS [ActionId],
[Extent1].[ControllerId] AS [ControllerId],
[Extent1].[RoleId] AS [RoleId]
FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent1]
WHERE [Extent1].[ControllerId] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = c17989ec-39bf-4e66-9399-a7175c3c1a83
SELECT
[Extent1].[ActionId] AS [ActionId],
[Extent1].[ControllerId] AS [ControllerId],
[Extent1].[RoleId] AS [RoleId]
FROM [dbo].[Sys_ActionsInControllersInRoles] AS [Extent1]
WHERE [Extent1].[ControllerId] = @EntityKeyValue1
-- EntityKeyValue1 (dbtype=Guid, size=0, direction=Input) = 3ae827ec-1e48-4e99-9067-b578576da3c4
SELECT
CASE WHEN ( EXISTS (SELECT
1 AS [C1]
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
MVC2.0项目模板0.2版源码 2010年06月08日 更新 增加用户选择主题功能,暂时无缩略图 2010年05月20日 更新 增加了一个文章管理模块(实例) 增加左右树结构分类 增加初期模板功能 增加文件上传功能 增加Ckeditor编辑器,在Ajax下使用 增加 用户操作日志记录 修正登陆界面,美化 修正数据Update方式 修正部分由于路径造成的不能运行问题 更新 EF 4.0 缓存 更新 EF 4.0 日志存储方式(文本保存 实际部署项目时请手工禁用 读写文本文件访问量大有性能问题) 数据库修改为SQL Server 2008 R2 Express (以防用户没有安装SQL Server 2008 R2) 增加 Metadata 产生默认值 如Id、Adddate等 2010年04月27日 项目创建 开发环境及工具: VS2010+SQL Server 2008 体现功能: MVC 2.0 MVC 2.0 权限控制 MVC 2.0 模板 MVC 2.0 Area 主题 EF 4.0 缓存 EF 4.0 日志 分页 Jquery UI Jquery Layout 等等 本例子仅仅涉及到一些基本的功能,您可以随意扩充和使用,基本的操作方法都已覆盖。 开发日期:2010年04月27日 数据库sql2008
资源推荐
资源详情
资源评论
收起资源包目录
MVC2.0项目模板0.2版源码 (2000个子文件)
Global.asax 95B
Edit.ascx 6KB
Edit.ascx 3KB
Edit.ascx 3KB
Index.ascx 3KB
Edit.ascx 3KB
Edit.ascx 2KB
Index.ascx 2KB
Edit.ascx 2KB
Edit.ascx 1KB
Index.ascx 1KB
Index.ascx 1KB
Details.ascx 1KB
Edit.ascx 1KB
Object.ascx 1KB
Index.ascx 1KB
Index.ascx 972B
Index.ascx 972B
Index.ascx 852B
Index.ascx 844B
Index.ascx 732B
Button_Search.ascx 630B
MultilineText.ascx 448B
ImageUrl.ascx 417B
FileUrl.ascx 409B
Ajax_Link_Delete.ascx 401B
Edit.ascx 388B
Edit.ascx 385B
Button_Back_List.ascx 338B
Button_Create.ascx 337B
Ajax_Link_Details.ascx 327B
Ajax_Link_Edit.ascx 324B
DateTime.ascx 320B
Theme.ascx 264B
Error.ascx 199B
Sys_Roles_MultipleSelect.ascx 144B
SelectList.ascx 119B
ImageUrl.ascx 97B
Upload.ashx 98B
Index.aspx 5KB
LogOn.aspx 4KB
desktop.aspx 1KB
fffe33.aspx 372B
111.aspx 372B
.aspx 372B
2010-05-13 首页.aspx 372B
fdsafsafff.aspx 372B
首页.aspx 372B
fdsafsa.aspx 372B
444.aspx 372B
4444333.aspx 372B
2010-05-11 文章模板-02.aspx 372B
fff.aspx 372B
3333.aspx 372B
2010-05-11 文章模板-01.aspx 372B
文章模板.aspx 372B
ffff.aspx 372B
432432432.aspx 372B
文章模板-01.aspx 372B
文章模板-02.aspx 372B
Index.aspx 367B
11222.aspx 2B
DesignTimeResolveAssemblyReferencesInput.cache 230KB
DesignTimeResolveAssemblyReferences.cache 149KB
ResolveAssemblyReference.cache 93KB
ResolveAssemblyReference.cache 79KB
ResolveAssemblyReference.cache 65KB
ResolveAssemblyReference.cache 51KB
ResolveAssemblyReference.cache 28KB
ResolveAssemblyReference.cache 25KB
StyleCop.Cache 7KB
DesignTimeResolveAssemblyReferencesInput.cache 7KB
DesignTimeResolveAssemblyReferencesInput.cache 6KB
DesignTimeResolveAssemblyReferencesInput.cache 6KB
DesignTimeResolveAssemblyReferencesInput.cache 6KB
DesignTimeResolveAssemblyReferencesInput.cache 6KB
StyleCop.Cache 6KB
DesignTimeResolveAssemblyReferencesInput.cache 6KB
DesignTimeResolveAssemblyReferencesInput.cache 6KB
StyleCop.Cache 4KB
Web.config 3KB
Web.config 2KB
Web.config 2KB
Web.Release.config 1KB
Web.Debug.config 1KB
Model.dll.config 524B
App.Config 524B
DBModel.Designer.cs 124KB
DbCommandTreeScanner.cs 25KB
InMemoryCache.cs 16KB
DbProviderServicesBase.cs 14KB
DbConnectionWrapper.cs 13KB
EntityConnectionWrapperUtils.cs 11KB
EFCachingDataReaderBase.cs 10KB
EFCachingCommand.cs 9KB
DbProviderManifestWrapper.cs 9KB
DbCommandWrapper.cs 8KB
EFCachingCommandDefinition.cs 8KB
EFCachingDataReaderCacheWriter.cs 7KB
EFTracingConnection.cs 6KB
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
ss_geng
- 粉丝: 319
- 资源: 3219
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功