asp.net考勤信息管理系统

/*管理员信息表*/ CREATE TABLE [dbo].[admin] ( [adminUsername] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , /*管理员帐号*/ [adminPassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL /*管理员密码*/ ) ON [PRIMARY] /*员工信息表*/ CREATE TABLE [dbo].[employeeInfo] ( [employeeNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , //员工编号 [employeeName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , //员工姓名 [employeePassword] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , //员工登陆密码 [employeeSex] [nchar] (1) COLLATE Chinese_PRC_CI_AS NULL , //员工性别 [employeeBirthday] [datetime] NULL , //员工生日 [employeeDepartmentId] [int] NULL , //部门编号 [employeeWorkTypeId] [int] NULL , //工作职位类别编号 [employeeEducationId] [int] NULL , //教育层次编号 [employeeHomeTel] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , //家庭电话 [employeeMobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , //移动电话 [employeeCard] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , //身份证号 [employeeEmail] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , //邮件地址 [employeeAddress] [nvarchar] (80) COLLATE Chinese_PRC_CI_AS NULL //居住地址 ) ON [PRIMARY] /*部门信息表*/ CREATE TABLE [dbo].[departmentInfo] ( [departmentId] [int] IDENTITY (1, 1) NOT NULL , //部门编号 [departmentName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL //部门名称 ) ON [PRIMARY] /*教育层次信息表*/ CREATE TABLE [dbo].[educationInfo] ( [educationId] [int] IDENTITY (1, 1) NOT NULL , //教育层次编号 [educationName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL //教育层次名称 ) ON [PRIMARY] /*工作职位类型表*/ CREATE TABLE [dbo].[workTypeInfo] ( [workTypeId] [int] IDENTITY (1, 1) NOT NULL , //职位类别编号 [workTypeName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , //职位类别名称 [workStartHour] [int] NULL , //上班开始时间小时 [workStartMinute] [int] NULL , //上班开始时间分钟 [workEndHour] [int] NULL , //下班时间小时 [workEndMinute] [int] NULL //下班时间分钟 ) ON [PRIMARY] /*考勤信息表*/ CREATE TABLE [dbo].[attendanceInfo] ( [attendanceId] [int] IDENTITY (1, 1) NOT NULL , /*考勤信息编号*/ [attendanceEmployeeNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , /*员工编号*/ [attendanceYear] [int] NULL , /*考勤年份*/ [attendanceMonth] [int] NULL , /*考勤月份*/ [attendanceDay] [int] NULL , /*考勤日期*/ [attendanceStartTime] [datetime] NULL , /*上班签到时间*/ [attendanceEndTime] [datetime] NULL , /*下班签退时间*/ [attendanceStartFlag] [smallint] NULL , /*是否已经上班签到*/ [attendanceEndFlag] [smallint] NULL /*是否已经下班签退*/ ) ON [PRIMARY]