基于C#+MySQL的人事工资管理系统源码+数据库（95分以上高分课程设计）.zip

/* SQLyog Enterprise v12.09 (64 bit) MySQL - 5.7.20 : Database - hr ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`hr` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `hr`; /*Table structure for table `department_info` */ DROP TABLE IF EXISTS `department_info`; CREATE TABLE `department_info` ( `id` int(6) NOT NULL AUTO_INCREMENT, `name` varchar(12) DEFAULT NULL COMMENT '部门名称', `basis` int(6) DEFAULT NULL COMMENT '基础工资', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*Data for the table `department_info` */ insert into `department_info`(`id`,`name`,`basis`) values (1,'技术部',2001),(2,'实习',1000),(3,'软件',2000); /*Table structure for table `staff_info` */ DROP TABLE IF EXISTS `staff_info`; CREATE TABLE `staff_info` ( `id` int(6) NOT NULL AUTO_INCREMENT, `name` varchar(12) DEFAULT NULL COMMENT '名称', `department_id` int(6) DEFAULT NULL COMMENT '部门编号', `password` varchar(12) DEFAULT NULL COMMENT '查询密码', `sex` varchar(1) DEFAULT NULL COMMENT '性别', `age` int(2) DEFAULT NULL COMMENT '年龄', `createdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间', `post` varchar(12) DEFAULT NULL COMMENT '职位', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; /*Data for the table `staff_info` */ insert into `staff_info`(`id`,`name`,`department_id`,`password`,`sex`,`age`,`createdate`,`post`) values (1,'张三',1,'456','男',22,'2019-12-08 15:21:19','基础'),(2,'历史',1,'456','男',23,'2019-12-08 15:21:07','无'),(6,'李四',1,'456','男',21,'2019-12-08 15:20:50','wu'),(7,'123',2,'123','女',21,'2019-11-25 18:47:38','无'),(8,'造请求',3,'123','男',21,'2019-12-20 08:06:30','无'); /*Table structure for table `user` */ DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(6) NOT NULL AUTO_INCREMENT, `name` varchar(12) DEFAULT NULL, `password` varchar(12) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; /*Data for the table `user` */ insert into `user`(`id`,`name`,`password`) values (1,'root','123'),(2,'张三','123'),(3,'李四','456'),(10,'王五','123'),(11,'赵六','123'); /*Table structure for table `wage_info` */ DROP TABLE IF EXISTS `wage_info`; CREATE TABLE `wage_info` ( `id` int(6) NOT NULL AUTO_INCREMENT, `staff_id` int(6) DEFAULT NULL COMMENT '职员编号', `basis` int(6) DEFAULT NULL COMMENT '基础工资', `attendance` int(6) DEFAULT NULL COMMENT '考勤工资', `performance` int(6) DEFAULT NULL COMMENT '效绩工资', `other` int(7) DEFAULT NULL COMMENT '其它', `reason` varchar(20) DEFAULT NULL COMMENT '原因', `total` int(6) DEFAULT NULL COMMENT '综合', `createdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*Data for the table `wage_info` */ insert into `wage_info`(`id`,`staff_id`,`basis`,`attendance`,`performance`,`other`,`reason`,`total`,`createdate`) values (1,1,2001,200,2000,100,'好',4301,'2019-11-25 20:34:11'),(2,2,2001,120,2000,-120,'差',4001,'2019-11-25 20:34:15'),(3,8,2000,120,450,100,'差',2670,'2019-12-20 08:07:15'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;