人事管理系统delphi开发案例

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[出差信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[出差信息] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[加班信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[加班信息] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[培训经历]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[培训经历] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[基本信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[基本信息] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[奖惩记录]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[奖惩记录] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工作经历]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[工作经历] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[应聘信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[应聘信息] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[招聘信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[招聘信息] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[日常考勤]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[日常考勤] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[用户清单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[用户清单] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[社会关系]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[社会关系] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[部门信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[部门信息] GO CREATE TABLE [dbo].[出差信息] ( [条目号] [int] IDENTITY (1, 1) NOT NULL , [员工编号] [int] NOT NULL , [姓名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [日期] [datetime] NULL , [返回日期] [datetime] NULL , [地点] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [任务] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[加班信息] ( [条目号] [int] IDENTITY (1, 1) NOT NULL , [员工编号] [int] NOT NULL , [姓名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [日期] [datetime] NULL , [时间] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [原因] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[培训经历] ( [条目号] [int] IDENTITY (1, 1) NOT NULL , [员工编号] [int] NOT NULL , [培训课程] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [期限] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [开始时间] [datetime] NULL , [结束时间] [datetime] NULL , [培训单位] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [证书] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[基本信息] ( [编号] [int] IDENTITY (1, 1) NOT NULL , [姓名] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [性别] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [出生日期] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [民族] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [部门编号] [int] NULL , [部门] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [工种] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [职称] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [省市] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [学历] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [专业] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [身份证号] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [档案号] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [政治面貌] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [技术等级] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [婚姻状况] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [录用时间] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [健康状况] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [合同期限] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [起止时间] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [邮政编码] [char] (10) COLLATE Chines�