asp.net购物车分层含代码

create database BookShop go use BookShop go --图书表 create table Book ( BookID int identity(1,1) primary key, BookName varchar(20), BookAuthor varchar(20), BookPrice money, BookPublisher varchar(20) ) --用户表 go create table Users ( UserID int identity(1,1) primary key, UserName varchar(20), ) --购书表 go create table BuyBooks ( BuyID int identity(1,1) primary key, UserID int foreign key references Users(UserID), BookID int foreign key references Book(BookID), Num int, OrderID int references BookOrders(OrderID) ) go --订单表 create table BookOrders ( OrderID int identity(1,1) primary key, OrderCode varchar(50), UserID int foreign key references Users(UserID), OrderMoney money, OrderDate datetime )