C#三层ATM-0.数据表设计

https://github.com/chenglingr/ATM-WinForm

1． 打开sqlserver创建数据库，命名为ATM

2． 数据表结构如下：

3． 执行下面的代码创建数据表

if exists (select * from sysobjects where id = OBJECT_ID('[cardinfo]') and OBJECTPROPERTY(id, 'IsUserTable') = 1)

DROP TABLE [cardinfo]

CREATE TABLE [cardinfo] (

[cardID] [varchar] (16) NOT NULL,

[curType] [varchar] (20) NULL DEFAULT (N'RMB'),

[savingType] [varchar] (20) NOT NULL,

[openDate] [datetime] NULL DEFAULT (getdate()),

[openMoney] [float] NOT NULL DEFAULT (0),

[balance] [float] NOT NULL DEFAULT (0),

[pass] [varchar] (6) NULL DEFAULT (888888),

[IsReportLoss] [bit] NULL DEFAULT (0),

[customerID] [int] NOT NULL)

ALTER TABLE [cardinfo] WITH NOCHECK ADD CONSTRAINT [PK_cardinfo] PRIMARY KEY NONCLUSTERED ( [cardID] )

INSERT [cardinfo] ([cardID],[curType],[savingType],[openDate],[openMoney],[balance],[pass],[IsReportLoss],[customerID]) VALUES ( N'1010357612121134',N'RMB',N'定期',N'2016/3/13 18:02:32',1,22712,N'111111',0,2)

INSERT [cardinfo] ([cardID],[curType],[savingType],[openDate],[openMoney],[balance],[pass],[IsReportLoss],[customerID]) VALUES ( N'1010357612121140',N'RMB',N'活期',N'2016/3/16 23:43:35',200,200,N'123456',0,4)

INSERT [cardinfo] ([cardID],[curType],[savingType],[openDate],[openMoney],[balance],[pass],[IsReportLoss],[customerID]) VALUES ( N'1010357612121154',N'RMB',N'活期',N'2016/3/16 23:54:57',800,800,N'666666',0,5)

INSERT [cardinfo] ([cardID],[curType],[savingType],[openDate],[openMoney],[balance],[pass],[IsReportLoss],[customerID]) VALUES ( N'1010357612121164',N'RMB',N'活期',N'2016/5/15 23:32:17',1,1,N'123456',0,4)

INSERT [cardinfo] ([cardID],[curType],[savingType],[openDate],[openMoney],[balance],[pass],[IsReportLoss],[customerID]) VALUES ( N'1010357612121174',N'RMB',N'定活两便',N'2016/5/15 23:35:23',1,1,N'333333',0,4)

INSERT [cardinfo] ([cardID],[curType],[savingType],[openDate],[openMoney],[balance],[pass],[IsReportLoss],[customerID]) VALUES ( N'1010357612345678',N'RMB',N'活期',N'2016/3/13 18:01:32',1000,1000,N'888888',0,1)

if exists (select * from sysobjects where id = OBJECT_ID('[transInfo]') and OBJECTPROPERTY(id, 'IsUserTable') = 1)

DROP TABLE [transInfo]

CREATE TABLE [transInfo] (

[transDate] [datetime] NOT NULL DEFAULT (getdate()),

[cardID] [varchar] (16) NOT NULL,

[transType] [nchar] (10) NOT NULL,

[transMoney] [float] NOT NULL,

[remark] [varchar] (100) NULL)

ALTER TABLE [transInfo] WITH NOCHECK ADD CONSTRAINT [PK_transInfo] PRIMARY KEY NONCLUSTERED ( [transDate] )

INSERT [transInfo] ([transDate],[cardID],[transType],[transMoney],[remark]) VALUES ( N'2016/3/16 23:43:35',N'1010357612121140',N'存入',200,N'开户存入')

INSERT [transInfo] ([transDate],[cardID],[transType],[transMoney],[remark]) VALUES ( N'2016/3/16 23:54:57',N'1010357612121154',N'存入',800,N'开户存入')

INSERT [transInfo] ([transDate],[cardID],[transType],[transMoney]) VALUES ( N'2016/3/18 21:19:31',N'1010357612121134',N'存入',1000)

INSERT [transInfo] ([transDate],[cardID],[transType],[transMoney]) VALUES ( N'2016/3/18 21:19:53',N'1010357612121134',N'支取',200)

INSERT [transInfo] ([transDate],[cardID],[transType],[transMoney]) VALUES ( N'2016/3/18 21:24:21',N'1010357612121134',N'存入',2000)

INSERT [transInfo] ([transDate],[cardID],[transType],[transMoney]) VALUES ( N'2016/3/18 21:24:29',N'1010357612121134',N'支取',111)

INSERT [transInfo] ([transDate],[cardID],[transType],[transMoney]) VALUES ( N'2016/3/18 21:24:35',N'1010357612121134',N'存入',20000)

INSERT [transInfo] ([transDate],[cardID],[transType],[transMoney]) VALUES ( N'2016/3/20 19:16:47',N'1010357612121134',N'存入',22)

INSERT [transInfo] ([transDate],[cardID],[transType],[transMoney],[remark]) VALUES ( N'2016/5/15 23:32:17',N'1010357612121164',N'存入',1,N'开户存入')

INSERT [transInfo] ([transDate],[cardID],[transType],[transMoney],[remark]) VALUES ( N'2016/5/15 23:35:23',N'1010357612121174',N'存入',1,N'开户存入')

if exists (select * from sysobjects where id = OBJECT_ID('[userInfo]') and OBJECTPROPERTY(id, 'IsUserTable') = 1)

DROP TABLE [userInfo]

CREATE TABLE [userInfo] (

[customerID] [int] IDENTITY (1, 1) NOT NULL,

[customerName] [varchar] (20) NOT NULL,

[pID] [varchar] (18) NOT NULL,

[telephone] [varchar] (13) NOT NULL,

[address] [varchar] (100) NULL)

ALTER TABLE [userInfo] WITH NOCHECK ADD CONSTRAINT [PK_userInfo] PRIMARY KEY NONCLUSTERED ( [customerID] )

SET IDENTITY_INSERT [userInfo] ON

INSERT [userInfo] ([customerID],[customerName],[pID],[telephone],[address]) VALUES ( 1,N'张三',N'123456789022212345',N'010-67898978',N'北京海淀')

INSERT [userInfo] ([customerID],[customerName],[pID],[telephone]) VALUES ( 2,N'李四',N'321245678912345678',N'0478-44443333')

INSERT [userInfo] ([customerID],[customerName],[pID],[telephone],[address]) VALUES ( 4,N'程程',N'342111198810191322',N'15976021214',N'中山')

INSERT [userInfo] ([customerID],[customerName],[pID],[telephone],[address]) VALUES ( 5,N'小贝壳',N'232323198901011632',N'15976021214',N'中山啦')

SET IDENTITY_INSERT [userInfo] OFF