USE [master]
GO
CREATE DATABASE [Shop] ON PRIMARY
( NAME = N'Shop', FILENAME = N'E:\Developer\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Shop.mdf' , SIZE = 2304KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'Shop_log', FILENAME = N'E:\Developer\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Shop_log.ldf' , SIZE = 832KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [Shop] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Shop].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Shop] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Shop] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Shop] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Shop] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Shop] SET ARITHABORT OFF
GO
ALTER DATABASE [Shop] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [Shop] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [Shop] SET AUTO_SHRINK ON
GO
ALTER DATABASE [Shop] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Shop] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Shop] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [Shop] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Shop] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Shop] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Shop] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Shop] SET DISABLE_BROKER
GO
ALTER DATABASE [Shop] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [Shop] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Shop] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Shop] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Shop] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Shop] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [Shop] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [Shop] SET RECOVERY SIMPLE
GO
ALTER DATABASE [Shop] SET MULTI_USER
GO
ALTER DATABASE [Shop] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Shop] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'Shop', N'ON'
GO
USE [Shop]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BasketItems](
[BasketItemId] [int] IDENTITY(1,1) NOT NULL,
[ProductId] [int] NOT NULL,
[Qty] [int] NOT NULL,
[BasketId] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_BasketItems] PRIMARY KEY CLUSTERED
(
[BasketItemId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Baskets](
[BasketId] [uniqueidentifier] NOT NULL,
[DeliveryOptionId] [int] NOT NULL,
CONSTRAINT [PK_Baskets] PRIMARY KEY CLUSTERED
(
[BasketId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Brands](
[BrandId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Brands] PRIMARY KEY CLUSTERED
(
[BrandId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Categories](
[CategoryId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Categories] PRIMARY KEY CLUSTERED
(
[CategoryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Colors](
[ColorId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Colors] PRIMARY KEY CLUSTERED
(
[ColorId] ASC
)WITH (P�
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
☆☆ 资源说明:☆☆ ☆ 框架说明 ☆ 本框架取自于《[清华大学出版社] ASP.NET设计模式》([Wrox] Professional ASP.NET Design Patterns)中的基于MVC的电子商务网站框架,本框架采用七层架构,使用了NHibernate、StructureMap、AutoMapper等多种开源技术; (PS: 《ASP.NET设计模式》是一本很不错的讲解.NET项目框架中设计模式运用的图书,极力推荐阅读) ☆ 框架层次 ☆ Model Layer Infrastructure Layer ORM NHibernate Layer Services Layer Services Cache Layer Controllers Layer MVC Layer ☆ 类库版本 ☆ AutoMapper -- 1.0.0.155 Iesi.Collections -- 1.0.1.0 LinFu.DynamicProxy -- 1.0.3.14911 log4net -- 1.2.10.0 NHibernate -- 2.1.0.2002 NHibernate.ByteCode.LinFu -- 2.1.0.2002 StructureMap -- 2.5.3.0 ☆ 开发环境 ☆ 开发工具:Microsoft Visual Studio 2010 数 据 库: Microsoft SQL Server 2008
资源推荐
资源详情
资源评论
收起资源包目录
[源代码] .NET学架构之框架赏析 基于七层架构的MVC模式电子商务网站 (362个子文件)
Global.asax 119B
SiteFooter.ascx 2KB
AddressEdit.ascx 1024B
JanrainLogin.ascx 900B
BasketSummary.ascx 670B
Categories.ascx 505B
CustomerMenu.ascx 458B
ProductSearchResults.aspx 23KB
View.aspx 10KB
Detail.aspx 3KB
Detail.aspx 3KB
ConfirmOrder.aspx 2KB
Register.aspx 2KB
Register.aspx 2KB
Index.aspx 2KB
LogOn.aspx 2KB
LogOn.aspx 2KB
List.aspx 1KB
Detail.aspx 1KB
DeliveryAddresses.aspx 1KB
PaymentPost.aspx 1KB
AddDeliveryAddress.aspx 827B
EditDeliveryAddress.aspx 719B
AddDeliveryAddress.aspx 706B
Default.aspx 516B
PaymentCancel.aspx 503B
PaymentComplete.aspx 488B
Error.aspx 444B
DesignTimeResolveAssemblyReferences.cache 184KB
DesignTimeResolveAssemblyReferencesInput.cache 14KB
DesignTimeResolveAssemblyReferencesInput.cache 7KB
DesignTimeResolveAssemblyReferencesInput.cache 6KB
DesignTimeResolveAssemblyReferencesInput.cache 6KB
DesignTimeResolveAssemblyReferencesInput.cache 6KB
DesignTimeResolveAssemblyReferencesInput.cache 6KB
DesignTimeResolveAssemblyReferencesInput.cache 6KB
Web.config 4KB
Web.config 2KB
Web.Release.config 1KB
Web.Debug.config 1KB
PayPalPaymentService.cs 8KB
BasketController.cs 8KB
CachedProductCatalogueService.cs 6KB
ProductController.cs 6KB
CustomerService.cs 6KB
BasketService.cs 6KB
AccountRegisterController.cs 6KB
BootStrapper.cs 6KB
Order.cs 5KB
CustomerController.cs 5KB
AccountLogOnController.cs 5KB
CheckoutController.cs 5KB
ProductMapper.cs 4KB
ProductCatalogService.cs 4KB
OrderService.cs 4KB
Basket.cs 3KB
PaymentController.cs 3KB
AutoMapperBootStrapper.cs 3KB
QueryTranslator.cs 3KB
Repository.cs 2KB
AspMembershipAuthentication.cs 2KB
OrderController.cs 2KB
Customer.cs 2KB
ProductSearchRequestQueryGenerator.cs 2KB
BaseAccountController.cs 2KB
Global.asax.cs 2KB
JanrainAuthenticationService.cs 2KB
BaseController.cs 2KB
EntityBase.cs 2KB
OrderItem.cs 2KB
AutoMapperBootStrapper.cs 2KB
BasketItem.cs 2KB
JsonDtoMapper.cs 2KB
Payment.cs 2KB
NHUnitOfWork.cs 1KB
OrderSubmittedHandler.cs 1KB
AssemblyInfo.cs 1KB
AssemblyInfo.cs 1KB
AssemblyInfo.cs 1KB
AssemblyInfo.cs 1KB
AssemblyInfo.cs 1KB
AssemblyInfo.cs 1KB
DeliveryOption.cs 1KB
AssemblyInfo.cs 1KB
SessionFactory.cs 1KB
OrderBusinessRules.cs 1KB
Criterion.cs 1KB
CustomerRepository.cs 1KB
HomeController.cs 1KB
AgathaHtmlHelper.cs 1KB
Address.cs 1KB
WebConfigApplicationSettings.cs 1KB
ThreadSessionStorageContainer.cs 1KB
ProductCatalogBaseController.cs 992B
ShippingService.cs 980B
ValueObjectBase.cs 959B
Product.cs 934B
HttpSessionContainer.cs 899B
AddressBusinessRules.cs 885B
OrderItemBusinessRules.cs 883B
共 362 条
- 1
- 2
- 3
- 4
GATTACA2011
- 粉丝: 313
- 资源: 1997
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
- 4
- 5
- 6
前往页