考勤管理系统vb+sql

use master go if exists (select * from dbo.sysdatabases where name = 'DBWorkCheck') drop database DBWorkCheck GO create database DBWorkCheck go use DBWorkCheck go if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbUser] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbLeaveKind]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbLeaveKind] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbOverKind]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbOverKind] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbDep]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbDep] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbEmployee]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbEmployee] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbCheckRule]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbCheckRule] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbOverTime]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbOverTime] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbLeave]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbLeave] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbOnWork]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbOnWork] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbWorkRecord]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbWorkRecord] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbOverRecord]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbOverRecord] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbLeaveRecord]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tbLeaveRecord] GO CREATE TABLE [dbo].[tbUser] ( UserId char(8) NOT NULL , UserPassword char(8) NOT NULL , UserKind varchar(20) NOT NULL, PRIMARY KEY (UserId) ) GO CREATE TABLE [dbo].[tbLeaveKind] ( LeaveKindId char(2) NOT NULL , LeaveKindName varchar(20) NOT NULL , LeaveKindDes varchar(100) NULL , PRIMARY KEY (LeaveKindId ) ) GO CREATE TABLE [dbo].[tbOverKind] ( OverKindId char(2) NOT NULL, OverKindName varchar(20) NOT NULL, OverKindDes varchar(100) NULL, PRIMARY KEY (OverKindId) ) GO CREATE TABLE [dbo].[tbDep] ( DepId char(8) NOT NULL , DepName varchar(30) NOT NULL , Describe varchar(100) NULL , PRIMARY KEY (DepId) ) GO CREATE TABLE [dbo].[tbEmployee] ( EmpId char(8) NOT NULL , EmpName varchar(30) NOT NULL , Gender char(2) NULL, Age int NULL, NationName varchar(20) NULL , Birthday datetime NULL, PoliticalParty varchar(20) NULL, MaritalCon varchar(6) NULL , DepId char(8) NULL, HireDate datetime NULL, EduName varchar(20) NOT NULL , FamilyPlace varchar(20) NULL, IdCard varchar(20) NULL, Email varchar(30) NULL, Officephone varchar(20) NULL, Homephone varchar(20) NULL, Mobile varchar(20) NULL, State varchar(20) NOT NULL , Residence varchar(100) NULL, Postcode varchar(10) NULL, DutyName varchar(20) NULL , RecorId char(10) NULL, PRLocation varchar(50) NULL, EmpIdRecord varchar(30) NULL, RuleId char(8) NULL, PRIMARY KEY (EmpId) ) GO CREATE TABLE [dbo].[tbCheckRule] ( RuleId char(8) NOT NULL, RuleName varchar(30) NOT NULL, DutyTimeFrom char(8) NULL, DutyTimeTo char(8) NULL , Mode varchar(10) NULL, DaysPresiMonth int NULL, PRIMARY KEY (RuleId) ) GO CREATE TABLE [dbo].[tbOverTime] ( DateWork char(10) NOT NULL , EmpId char(8) NOT NULL , OverKindId char(2) NULL , TimeFrom char(8) NULL , TimeTo char(8) NULL , Hour int NULL, Description varchar(50) NULL, Flag varchar(8) NULL, CheckMan varchar(30) NULL, PRIMARY KEY (DateWork,EmpId) ) GO CREATE TABLE [dbo].[tbLeave] ( DateWork char(10) NOT NULL , EmpId char(8) NOT NULL , LeaveKindId char(2) NULL , TimeFrom char(10) NULL , TimeTo char(10) NULL , Days int NULL, Description varchar(50) NULL, Flag varchar(8) NULL, CheckMan varchar(30) NULL, PRIMARY KEY (DateWork,EmpId) ) GO CREATE TABLE [dbo].[tbOnWork] ( DateWork char(8) NOT NULL , EmpId char(8) NOT NULL , DepId char(8) NULL , OnWorkFrom datetime NULL, OnWorkTo datetime NULL, WorkHour int NULL, Flag varchar(8) NULL, CheckMan varchar(30) NULL, LateFlag varchar(8) NULL, LateCount int NULL, EarlyCount int NULL, PRIMARY KEY (DateWork,EmpId) ) GO CREATE TABLE [dbo].[tbWorkRecord] ( RecordYear char(4) NOT NULL , RecordMonth char(2) NOT NULL , EmpId char (8) NOT NULL, DepId char(8) NULL , DaysPresiMonth int NULL , AbsentDays int NULL , LateDays int NULL , LeaveEarlyDays int NULL , Hours int NULL , PRIMARY KEY (RecordYear,RecordMonth,EmpId) ) GO CREATE TABLE [dbo].[tbOverRecord] ( RecordYear char(4) NOT NULL , RecordMonth char(2) NOT NULL , EmpId char (8) NOT NULL, DepId char(8) NULL , OverKindId char(2) NULL , Hours int NULL , PRIMARY KEY (RecordYear,RecordMonth,EmpId) ) GO CREATE TABLE [dbo].[tbLeaveRecord] ( RecordYear char(4) NOT NULL , RecordMonth char(2) NOT NULL , EmpId char (8) NOT NULL, DepId char(8) NULL , LeaveKindId char(2) NULL , LeaveDays int NULL , PRIMARY KEY (RecordYear,RecordMonth,EmpId) ) GO