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]) 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 , //部门编号 [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].[chargeManInfo] ( [chargeUsername] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , //负责人登陆帐号 [chargeName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , //负责人姓名 [chargePassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , //负责人登陆密码 [departmentId] [int] 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].[dayTaskInfo] ( [dayTaskId] [int] IDENTITY (1, 1) NOT NULL , /*系统记录编号*/ [employeeNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , /*员工编号*/ [dayTaskTitle] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL , /*任务标题*/ [dayTaskContent] [text] COLLATE Chinese_PRC_CI_AS NULL , /*任务内容*/ [dayTaskDate] [datetime] NULL , /*任务所属日期*/ [dayTaskIsFinished] [nchar] (1) COLLATE Chinese_PRC_CI_AS NULL , /*任务是否已经完成*/ [dayTaskAddTime] [datetime] NULL , /*任务下达时间*/ [dayTaskUpdateTime] [datetime] NULL /*任务更新时间*/ ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /*员工日志信息表*/ CREATE TABLE [dbo].[journalInfo] ( [journalId] [int] IDENTITY (1, 1) NOT NULL , /*日志记录编号*/ [employeeNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , /*员工编号*/ [journalTitle] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL , /*日志标题*/ [journalContent] [text] COLLATE Chinese_PRC_CI_AS NULL , /*日志内容*/ [journalEvaluate] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , /*部门负责人对员工日志的评价*/ [journalDate] [datetime] NULL , /*日志所属日期*/ [journalAddTime] [datetime] NULL , /*日志加入时间*/ [journalUpdateTime] [datetime] NULL /*日志更新时间*/ ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /*部门月度任务信息表*/ CREATE TABLE [dbo].[monthTaskInfo] ( [monthTaskId] [int] IDENTITY (1, 1) NOT NULL , /*系统记录编号*/ [departmentId] [int] NULL , /*部门编号*/ [monthTaskTitle] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL , /*任务标题*/ [monthTaskContent] [text] COLLATE Chinese_PRC_CI_AS NULL , /*任务内容*/ [monthTaskYear] [int] NULL , /*任务所在年份*/ [monthTaskMonth] [int] NULL , /*任务所在月份*/ [monthTaskIsFinished] [nchar] (1) COLLATE Chinese_PRC_CI_AS NULL , /*任务是否已经完成*/ [monthTaskAddTime] [datetime] NULL , /*任务下达时间*/ [monthTaskUpdateTime] [datetime] NULL /*任务更新时间*/ ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /* 部门季度任务信息表*/ CREATE TABLE [dbo].[quarterTaskInfo] ( [quarterTaskId] [int] IDENTITY (1, 1) NOT NULL , /*系统记录编号*/ [departmentId] [int] NULL , /*部门编号*/ [quarterTaskTitle] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL , /*任务标题*/ [quarterTaskContent] [text] COLLATE Chinese_PRC_CI_AS NULL , /*任务内容*/ [quarterTaskYear] [int] NULL , /*任务所在年份*/ [quarterNumber] [int] NULL , /*第几季度*/ [quarterTaskIsFinished] [nchar] (1) COLLATE Chinese_PRC_CI_AS NULL , /*任务是否已经完成*/ [quarterTaskAddTime] [datetime] NULL , /*任务下达时间*/ [quarterTaskUpdateTime] [datetime] NULL /*任务更新时间*/ ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /*上传文件信息*/ CREATE TABLE [dbo].[upfileInfo] ( [upfileId] [int] IDENTITY (1, 1) NOT NULL , /*系统记录编号*/ [employeeNo] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , /*员工编号*/ [upfileTitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , /*文件标题信息*/ [upfilePath] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , /*上传文件路径*/ [upfileSize] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , /*上传文件大小*/ /*文件大小*/ [uploadTime] [datetime] NULL , /*上传时间*/ ) ON [PRIMARY] /*新闻信息表*/ CREATE TABLE [dbo].[newsInfo] ( [newId] [int] IDENTITY (1, 1) NOT NULL , //系统记录编号 [newTitle] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL , //新闻标题 [newContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL , //新闻内容 [newFrom] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , //新闻来源 [newWriter] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , //新闻发布者 [newAddTime] [datetime] NULL , //新闻加入时间 [newUpdateTime] [datetime] NULL //新闻更新时间 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]