智能通道系统之(5) 添加测试数据

 

让知识更加联贯让技术走进生活

我的博客       我的程序我的网络

               ------郑紫至

               E-mail:zhengzizhi@yahoo.com.cn

智能通道系统

本系统全面地展示了Socket与多线程，数据库，工业上采用的CRC查表校验信息码

等综合技术的完整代码，从代码的角度展示了工控通讯的完整过程，本系统可以改装成

 地铁、火车站、海关、商场、旅游景点，智能小区、大型集团公司，大型停车场，

等等需要刷卡通行智能验证平台，本系统使用了软终端从理论的角度模拟出单片机终

端设备的通讯过程。

开发工具:Visual Studio 2008.NET(C#) + Microsoft SQL Server 2005

 

智能通道系统之(5) 添加测试数据

1．          创建IRS系统运行时需要的数据环境

    

 

--清空表中所有的数据

TRUNCATE TABLE dbo.AbnormityCard

TRUNCATE TABLE dbo.Department

TRUNCATE TABLE dbo.DiningClass

TRUNCATE TABLE dbo.DiningClassTime

TRUNCATE TABLE dbo.Employee

TRUNCATE TABLE dbo.ReadCard

-- 添加部门测试数据

INSERT INTO Department(DeptNo,DeptName)

SELECT '01',N'电脑部' UNION ALL

SELECT '02',N'人事部' UNION ALL

SELECT '03',N'销售部' UNION ALL

SELECT '04',N'采购部'

-- 添加卡号分发给员工的测试数据

INSERT INTO Employee(EmpNo,EmpName,DeptNo,CardNo,DimissionNo,DimissionDate)

(SELECT '00000538',N'万里','01','0013776138',null,null)UNION ALL

(SELECT '00000789',N'杨帆','02','0008619437',null,null)UNION ALL

(SELECT '00000419',N'白雪','03','0000198062',null,null)UNION ALL

(SELECT '00000666',N'田野','01','0001031159',null,null)UNION ALL

(SELECT '00000511',N'周密','04','0010504946',null,null)

-- 添加一天中所排班次就餐的时间和价格测试数据

INSERT INTO DiningClassTime(ClassNo,ClassName,Time_B,IsNight_B,Time_E,IsNight_E,Price)

 SELECT 'A1',N'早餐','06:45',0,'07:15',0,1.00 UNION ALL

 SELECT 'A2',N'早餐','07:30',0,'07:45',0,1.00 UNION ALL

 SELECT 'B1',N'午餐','11:45',0,'12:05',0,2.50 UNION ALL

 SELECT 'B2',N'午餐','11:55',0,'12:15',0,2.50 UNION ALL

 SELECT 'B3',N'午餐','12:05',0,'12:25',0,2.50 UNION ALL

 SELECT 'B4',N'午餐','12:15',0,'12:35',0,2.50 UNION ALL

 SELECT 'B5',N'午餐','12:25',0,'12:45',0,2.50 UNION ALL

 SELECT 'B6',N'午餐','12:35',0,'12:55',0,2.50 UNION ALL

 SELECT 'B7',N'午餐','12:45',0,'13:05',0,2.50 UNION ALL

 SELECT 'B8',N'午餐','12:55',0,'13:20',0,2.50 UNION ALL

 SELECT 'C1',N'晚餐','18:00',0,'18:20',0,2.50 UNION ALL

 SELECT 'C2',N'晚餐','18:20',0,'19:00',0,2.50 UNION ALL

 SELECT 'C3',N'晚餐','19:00',0,'19:30',0,2.50 UNION ALL

 SELECT 'C4',N'晚餐','19:30',0,'19:45',0,2.50 UNION ALL

 SELECT 'D1',N'夜宵','23:10',1,'23:40',1,1.00 UNION ALL

 SELECT 'D2',N'夜宵','00:00',1,'00:20',1,1.00

-- 添加员工定餐测试数据

INSERT INTO DiningClass(EmpNo,DiningDate,DiningClassA,DiningClassB,DiningClassC,DiningClassD)

SELECT '00000538',CONVERT(varchar(10),GETDATE(), 121),'A2','B5','C1','D2' UNION ALL

SELECT '00000538',CONVERT(varchar(10),DATEADD(day,1,GETDATE()), 121),'A1','B8','C4','D1' UNION ALL

SELECT '00000538',CONVERT(varchar(10),DATEADD(day,2,GETDATE()), 121),'A1','B1','C1','D1' UNION ALL

SELECT '00000789',CONVERT(varchar(10),GETDATE(), 121),'A1','B3','C1','D1' UNION ALL

SELECT '00000789',CONVERT(varchar(10),DATEADD(day,1,GETDATE()), 121),'A1','B6','C2','D1' UNION ALL

SELECT '00000789',CONVERT(varchar(10),DATEADD(day,2,GETDATE()), 121),'A2','B1','C2','D2' UNION ALL

SELECT '00000419',CONVERT(varchar(10),GETDATE(), 121),'A1','B5','C3','D1' UNION ALL

SELECT '00000419',CONVERT(varchar(10),DATEADD(day,1,GETDATE()), 121),'A2','B6','C4','D1' UNION ALL

SELECT '00000419',CONVERT(varchar(10),DATEADD(day,2,GETDATE()), 121),'A2','B7','C2','D2' UNION ALL

SELECT '00000511',CONVERT(varchar(10),GETDATE(), 121),'A1','B5','C3','D1' UNION ALL

SELECT '00000511',CONVERT(varchar(10),DATEADD(day,1,GETDATE()), 121),'A2','B6','C4','D1' UNION ALL

SELECT '00000511',CONVERT(varchar(10),DATEADD(day,2,GETDATE()), 121),'A2','B7','C2','D2'