/*==============================================================*/
/* Database name: MemberSale */
/* DBMS name: sqlServer2000(Extend) */
/* Created on: 2006-8-18 10:10:03 */
/*==============================================================*/
/*==============================================================*/
/* Table: BackStock */
/*==============================================================*/
create table BackStock (
BackID int identity
/*BackID*/,
StockID nvarchar(20) null
/*StockID*/,
StockCount int not null
/*StockCount*/,
BackDate datetime not null
/*BackDate*/,
constraint PK_BACKSTOCK primary key (BackID)
)
go
/*==============================================================*/
/* Index: BackID */
/*==============================================================*/
create index BackID on BackStock (
BackID
)
go
/*==============================================================*/
/* Table: CardHistory */
/*==============================================================*/
create table CardHistory (
ConsumeID int identity
/*ConsumeID*/,
CardNum nvarchar(20) not null
/*CardNum*/,
Mark int not null
/*Mark*/,
Point numeric not null
/*Point*/,
HandleDate datetime not null
/*HandleDate*/,
constraint PK_CARDHISTORY primary key (ConsumeID)
)
go
/*==============================================================*/
/* Index: ConsumeID */
/*==============================================================*/
create index ConsumeID on CardHistory (
ConsumeID
)
go
/*==============================================================*/
/* Table: CardType */
/*==============================================================*/
create table CardType (
CardID int identity
/*CardID*/,
CardTypeName nvarchar(20) not null
/*CardTypeName*/,
CardRule int not null
/*CardRule*/,
constraint PK_CARDTYPE primary key (CardID)
)
go
/*==============================================================*/
/* Index: CardID */
/*==============================================================*/
create index CardID on CardType (
CardID
)
go
/*==============================================================*/
/* Table: FreeStock */
/*==============================================================*/
create table FreeStock (
FreeID int identity
/*FreeID*/,
StockID nvarchar(20) null
/*StockID*/,
FreeDate datetime not null
/*FreeDate*/,
constraint PK_FREESTOCK primary key (FreeID)
)
go
/*==============================================================*/
/* Index: FreeID */
/*==============================================================*/
create index FreeID on FreeStock (
FreeID
)
go
/*==============================================================*/
/* Table: GiftRule */
/*==============================================================*/
create table GiftRule (
RuleID int identity
/*RuleID*/,
StockID nvarchar(20) null
/*StockID*/,
CardCount numeric not null
/*CardCount*/,
constraint PK_GIFTRULE primary key (RuleID)
)
go
/*==============================================================*/
/* Index: RuleID */
/*==============================================================*/
create index RuleID on GiftRule (
RuleID
)
go
/*==============================================================*/
/* Table: MemberInfo */
/*==============================================================*/
create table MemberInfo (
MemberID int identity
/*MemberID*/,
CardID int not null
/*CardID*/,
CardNum nvarchar(20) not null
/*CardNum*/,
CustName nvarchar(20) not null
/*CustName*/,
custIdentity nvarchar(20) not null
/*custIdentity*/,
CustPhone nvarchar(20) null
/*CustPhone*/,
CustAddress nvarchar(100) null
/*CustAddress*/,
CardDate datetime not null
/*CardDate*/,
constraint PK_MEMBERINFO primary key (MemberID, CardNum)
)
go
/*==============================================================*/
/* Index: MemberID */
/*==============================================================*/
create index MemberID on MemberInfo (
MemberID
)
go
/*==============================================================*/
/* Table: Sale */
/*==============================================================*/
create table Sale (
SaleID int identity
/*SaleID*/,
StockID nvarchar(20) null
/*StockID*/,
StockCount int not null
/*StockCount*/,
SaleDate datetime not null
/*SaleDate*/,
constraint PK_SALE primary key (SaleID)
)
go
/*==============================================================*/
/* Index: SaleID */
/*==============================================================*/
create index SaleID on Sale (
SaleID
)
go
/*==============================================================*/
/* Table: Stock */
/*==============================================================*/
create table Stock (
StockID nvarchar(20) not null
/*StockID*/,
StockName nvarchar(50) not null
/*StockName*/,
StockPrice float not null
/*StockPrice*/,
StockCount int not null
/*StockCount*/,
constraint PK_STOCK primary key (StockID)
)
go
/*==============================================================*/
/* Index: StockID */
/*==============================================================*/
create index StockID on Stock (
StockID
)
go
alter table BackStock
add constraint FK_BACKSTOC_REFERENCE_STOCK foreign key (StockID)
references Stock (StockID)
go
alter table FreeStock
add constraint FK_FREESTOC_REFERENCE_STOCK foreign key (StockID)
references Stock (StockID)
go
alter table GiftRule
add constraint FK_GIFTRULE_REFERENCE_STOCK foreign key (StockID)
references Stock (StockID)
go
alter table MemberInfo
add constraint FK_MEMBERIN_REFERENCE_CARDTYPE foreign key (CardID)
references CardType (CardID)
go
alter table Sale
add constraint FK_SALE_REFERENCE_STOCK foreign key (StockID)
references Stock (StockID)
go
没有合适的资源?快使用搜索试试~ 我知道了~
ASP.NET 经典项目例子
共161个文件
cs:72个
aspx:30个
ascx:24个
4星 · 超过85%的资源 需积分: 11 36 下载量 191 浏览量
2009-05-31
17:47:09
上传
评论
收藏 652KB RAR 举报
温馨提示
会员积分系统包含数据库 VS03,VS05两个版本
资源推荐
资源详情
资源评论
收起资源包目录
ASP.NET 经典项目例子 (161个子文件)
Register.ascx 6KB
Register.ascx 6KB
InsertMemberUC.ascx 4KB
InsertMemberUC.ascx 4KB
GiftRule.ascx 4KB
GiftRule.ascx 4KB
CardTypeSet.ascx 4KB
CardTypeSet.ascx 4KB
StockSale.ascx 3KB
StockSale.ascx 3KB
GetMember.ascx 3KB
GetMember.ascx 3KB
FreeStock.ascx 3KB
FreeStock.ascx 3KB
EditMemberInfo.ascx 3KB
EditMemberInfo.ascx 3KB
HistoryHandle.ascx 1KB
HistoryHandle.ascx 1KB
GetHistory.ascx 1KB
GetHistory.ascx 1KB
CardCount.ascx 1KB
CardCount.ascx 1KB
login.ascx 258B
login.ascx 258B
test2.aspx 4KB
test2.aspx 4KB
ErrorPage.aspx 1KB
ErrorPage.aspx 1KB
CardTypePage.aspx 468B
CardTypePage.aspx 468B
HistoryHandlePage.aspx 462B
HistoryHandlePage.aspx 462B
FreeStockPage.aspx 458B
FreeStockPage.aspx 458B
InsertMemberPage.aspx 440B
InsertMemberPage.aspx 440B
EditMemberPage.aspx 436B
EditMemberPage.aspx 436B
StockSalePage.aspx 434B
CardCountPage.aspx 434B
StockSalePage.aspx 434B
GetMemberPage.aspx 434B
GetMemberPage.aspx 434B
CardCountPage.aspx 434B
GiftRulePage.aspx 430B
GiftRulePage.aspx 430B
GetHistotyPage.aspx 420B
GetHistotyPage.aspx 420B
RegisterPage.aspx 408B
RegisterPage.aspx 408B
loginPage.aspx 390B
loginPage.aspx 390B
Default.aspx 346B
Default.aspx 346B
web.config 2KB
web.config 2KB
web.config 264B
web.config 264B
web.config 260B
web.config 260B
SqlHelper.cs 12KB
SqlHelper.cs 12KB
MemberInfoDA.cs 10KB
MemberInfoDA.cs 10KB
CardTypeDA.cs 9KB
CardTypeDA.cs 9KB
StockDA.cs 8KB
StockDA.cs 8KB
CardCountInfo.cs 6KB
CardCountInfo.cs 6KB
CardTypeSet.ascx.cs 4KB
CardTypeSet.ascx.cs 4KB
test2.aspx.cs 3KB
test2.aspx.cs 3KB
GetMember.ascx.cs 3KB
GetMember.ascx.cs 3KB
MemberInfoEntity.cs 2KB
MemberInfoEntity.cs 2KB
FreeStock.ascx.cs 2KB
FreeStock.ascx.cs 2KB
GetHistory.ascx.cs 1KB
GetHistory.ascx.cs 1KB
InsertMemberUC.ascx.cs 1KB
InsertMemberUC.ascx.cs 1KB
CardTypeEntity.cs 1KB
CardTypeEntity.cs 1KB
StockSale.ascx.cs 1KB
StockSale.ascx.cs 1KB
CardCount.ascx.cs 1002B
CardCount.ascx.cs 1002B
GiftRule.ascx.cs 987B
GiftRule.ascx.cs 987B
StockEntity.cs 951B
StockEntity.cs 951B
HistoryHandle.ascx.cs 920B
HistoryHandle.ascx.cs 920B
login.ascx.cs 910B
login.ascx.cs 910B
Register.ascx.cs 619B
Register.ascx.cs 619B
共 161 条
- 1
- 2
资源评论
- l11412006322015-02-15比较详细,很实用
- fish19me2012-07-19项目比较简单,适合刚入门的asp.net的程序员,以及想了解asp.net的常用开发模式的程序员。
深蓝色_1900
- 粉丝: 0
- 资源: 5
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功