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