SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblorderBook]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tblorderBook](
[orderID] [int] NOT NULL,
[bookID] [int] NOT NULL,
[quality] [int] NOT NULL,
[soldPrice] [numeric](18, 1) NOT NULL,
[paysum] [numeric](18, 1) NOT NULL,
CONSTRAINT [PK_tblorderBook] PRIMARY KEY CLUSTERED
(
[orderID] ASC,
[bookID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbluser]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbluser](
[userID] [int] IDENTITY(1,1) NOT NULL,
[userName] [nvarchar](50) NOT NULL,
[userPwd] [nvarchar](50) NOT NULL,
[trueName] [nvarchar](30) NULL,
[address] [nvarchar](80) NULL,
[telephone] [nvarchar](30) NULL,
[postcode] [nvarchar](20) NULL,
[sex] [char](2) NOT NULL CONSTRAINT [DF_tbluser_sex] DEFAULT ('男'),
[userType] [smallint] NOT NULL,
CONSTRAINT [PK_tbluser] PRIMARY KEY CLUSTERED
(
[userID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pinglun]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[pinglun](
[postID] [int] IDENTITY(1,1) NOT NULL,
[bookID] [int] NOT NULL,
[textname] [varchar](100) NOT NULL,
[userName] [nvarchar](50) NOT NULL,
[text] [varchar](1000) NOT NULL,
[speaktime] [datetime] NOT NULL,
CONSTRAINT [PK_pinglun] PRIMARY KEY CLUSTERED
(
[postID] ASC,
[bookID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblBook]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tblBook](
[bookID] [int] IDENTITY(1,1) NOT NULL,
[typeID] [int] NOT NULL,
[bookName] [nvarchar](50) NOT NULL,
[bookAuthor] [nvarchar](50) NULL,
[bookPrice] [numeric](18, 1) NOT NULL,
[publisher] [nvarchar](50) NULL,
[publishDate] [smalldatetime] NULL,
[bookImage] [nvarchar](50) NULL,
[IsSelling] [bit] NOT NULL CONSTRAINT [DF_tblBook_IsSelling] DEFAULT ((0)),
CONSTRAINT [PK_tblBook] PRIMARY KEY CLUSTERED
(
[bookID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1代表正在出售,0代表没有' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tblBook', @level2type=N'COLUMN', @level2name=N'IsSelling'
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblorder]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tblorder](
[orderID] [int] IDENTITY(1,1) NOT NULL,
[userID] [int] NOT NULL,
[orderTime] [smalldatetime] NOT NULL CONSTRAINT [DF_tblorder_orderTime] DEFAULT (getdate()),
[orderSum] [numeric](10, 1) NOT NULL,
[payment] [nvarchar](20) NOT NULL CONSTRAINT [DF_tblorder_payment] DEFAULT (N'银行支付'),
[ship] [nvarchar](20) NOT NULL CONSTRAINT [DF_tblorder_ship] DEFAULT (N'平邮'),
[buyerName] [nvarchar](30) NOT NULL,
[buyerEmail] [nvarchar](50) NOT NULL,
[buyerAddress] [nvarchar](60) NOT NULL,
[buyerCode] [nvarchar](30) NOT NULL,
[buyerTel] [nvarchar](30) NOT NULL,
[IsPayed] [smallint] NOT NULL CONSTRAINT [DF_tblorder_IsPayed] DEFAULT ((0)),
CONSTRAINT [PK_tblorder] PRIMARY KEY CLUSTERED
(
[orderID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblType]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tblType](
[typeID] [int] NOT NULL,
[typeName] [sysname] NOT NULL,
[fatherID] [int] NULL,�
没有合适的资源?快使用搜索试试~ 我知道了~
网上家具销售平台(不太完整)
共114个文件
cs:35个
aspx:25个
jpg:24个
需积分: 9 6 下载量 6 浏览量
2008-12-26
07:06:33
上传
评论
收藏 842KB RAR 举报
温馨提示
这一个东西做得不太完整,但是还可以下下来做一做,也可以通过这个学习一下!
资源推荐
资源详情
资源评论
收起资源包目录
网上家具销售平台(不太完整) (114个子文件)
Global.asax 1006B
bo.ascx 1KB
di.ascx 1KB
di2.ascx 757B
policy.aspx 18KB
login.aspx 14KB
register.aspx 11KB
userJiaju.aspx 11KB
userMain.aspx 10KB
jiaju.aspx 9KB
orderjiaju.aspx 6KB
shouhou.aspx 5KB
account.aspx 5KB
setuserinfo.aspx 4KB
jiajuBuy.aspx 4KB
speaking.aspx 4KB
addjiaju.aspx 4KB
userOrder.aspx 4KB
website.aspx 4KB
admin.aspx 3KB
userInfo.aspx 3KB
findjiaju.aspx 3KB
jiajuinfo.aspx 3KB
searchjiaju.aspx 2KB
adminSpeaking.aspx 2KB
user.aspx 946B
Default.aspx 448B
CheckCode.aspx 447B
Default2.aspx 263B
023.bmp 587KB
Web.Config 2KB
userMain.aspx.cs 4KB
userJiaju.aspx.cs 4KB
CheckCode.aspx.cs 4KB
jiajuBuy.aspx.cs 3KB
orderjiaju.aspx.cs 3KB
admin.aspx.cs 3KB
userOrder.aspx.cs 3KB
register.aspx.cs 3KB
login.aspx.cs 3KB
speaking.aspx.cs 2KB
jiaju.aspx.cs 2KB
setuserinfo.aspx.cs 2KB
searchjiaju.aspx.cs 2KB
addjiaju.aspx.cs 2KB
findjiaju.aspx.cs 2KB
Class1.cs 2KB
UserPage.master.cs 2KB
adminSpeaking.aspx.cs 1KB
userInfo.aspx.cs 1KB
jiajuinfo.aspx.cs 1KB
di.ascx.cs 904B
bo.ascx.cs 861B
orderinfo.cs 853B
user.aspx.cs 806B
jiajuPage.master.cs 416B
bottom.master.cs 413B
admin.master.cs 412B
jiaju.master.cs 412B
di2.ascx.cs 411B
Default2.aspx.cs 409B
account.aspx.cs 408B
shouhou.aspx.cs 408B
website.aspx.cs 408B
policy.aspx.cs 407B
Default.aspx.cs 383B
Thumbs.db 179KB
Thumbs.db 20KB
Thumbs.db 11KB
Thumbs.db 5KB
wd.gif 10KB
abc.gif 3KB
icbc.gif 3KB
cbc.gif 3KB
pic_newbooks.gif 1KB
productlist.gif 876B
list_bg.gif 657B
title_bg.gif 172B
23_wh1.gif 126B
dw.html 770B
100.jpg 54KB
1702652007729133944.jpg 47KB
20069182030615309.jpg 40KB
a副本.jpg 33KB
1142133483.jpg 29KB
20077817721.jpg 28KB
picture20077817721.jpg 28KB
B_hq12820071224201653.jpg 23KB
1112531331.jpg 22KB
08.jpg 20KB
7.jpg 18KB
1.jpg 16KB
4.jpg 15KB
5.jpg 12KB
6.jpg 10KB
3.jpg 8KB
023.JPG 7KB
2.jpg 7KB
xgnyy.jpg 7KB
xxfwjs.jpg 7KB
共 114 条
- 1
- 2
资源评论
caikui1118
- 粉丝: 0
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功