毕业设计完整源码基于C#开发的KopSoft仓库管理系统(带sql数据库和说明文档).zip

/* Navicat Premium Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 50739 Source Host : localhost:3306 Source Schema : kopsoftwms Target Server Type : MySQL Target Server Version : 50739 File Encoding : 65001 Date: 08/12/2022 20:46:25 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for sys_dept -- ---------------------------- DROP TABLE IF EXISTS `sys_dept`; CREATE TABLE `sys_dept` ( `DeptId` bigint(20) NOT NULL, `DeptNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DeptName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IsDel` tinyint(4) NOT NULL COMMENT '1未删除 0删除', `Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `CreateDate` datetime NULL DEFAULT NULL COMMENT '创建时间', `ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人', `ModifiedDate` datetime NULL DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`DeptId`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_dept -- ---------------------------- -- ---------------------------- -- Table structure for sys_dict -- ---------------------------- DROP TABLE IF EXISTS `sys_dict`; CREATE TABLE `sys_dict` ( `DictId` bigint(20) NOT NULL, `DictNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DictName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DictType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IsDel` tinyint(4) NOT NULL COMMENT '1未删除 0删除', `Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `CreateDate` datetime NULL DEFAULT NULL COMMENT '创建时间', `ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人', `ModifiedDate` datetime NULL DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`DictId`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_dict -- ---------------------------- -- ---------------------------- -- Table structure for sys_log -- ---------------------------- DROP TABLE IF EXISTS `sys_log`; CREATE TABLE `sys_log` ( `LogId` bigint(20) NOT NULL, `LogType` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `Description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `Url` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `Browser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `CreateDate` datetime NULL DEFAULT NULL COMMENT '创建时间', `ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人', `ModifiedDate` datetime NULL DEFAULT NULL COMMENT '修改时间', `LogIp` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`LogId`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_log -- ---------------------------- -- ---------------------------- -- Table structure for sys_menu_wms -- ---------------------------- DROP TABLE IF EXISTS `sys_menu_wms`; CREATE TABLE `sys_menu_wms` ( `MenuId` bigint(20) NOT NULL, `MenuName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `MenuUrl` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `MenuIcon` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `MenuParent` bigint(20) NULL DEFAULT NULL, `Sort` int(11) NULL DEFAULT NULL, `Status` tinyint(4) NULL DEFAULT NULL COMMENT '启用1 禁用0', `MenuType` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'menu btn', `IsDel` tinyint(4) NOT NULL COMMENT '1未删除 0删除', `Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `CreateDate` datetime NULL DEFAULT NULL COMMENT '创建时间', `ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人', `ModifiedDate` datetime NULL DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`MenuId`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_menu_wms -- ---------------------------- INSERT INTO `sys_menu_wms` VALUES (1, '系统管理', '#', NULL, -1, 1, 1, 'menu', 1, NULL, NULL, '2018-09-24 12:10:42', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (2, '用户管理', '/User', NULL, 1, 4, 1, 'menu', 1, NULL, NULL, '2018-09-24 12:12:56', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (3, '部门管理', '/Dept', NULL, 1, 3, 1, 'menu', 1, NULL, NULL, '2018-09-24 12:14:38', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (4, '角色管理', '/Role', NULL, 1, 2, 1, 'menu', 1, NULL, NULL, '2018-09-24 12:14:57', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (5, '数据字典', '/Dict', NULL, 1, 5, 1, 'menu', 1, NULL, NULL, '2018-10-21 14:44:30', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (6, '基础资料', '#', NULL, -1, 6, 1, 'menu', 1, NULL, NULL, '2018-09-24 12:19:07', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (7, '物料管理', '/Material', NULL, 6, 7, 1, 'menu', 1, NULL, NULL, '2018-10-09 08:50:37', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (8, '客户管理', '/Customer', NULL, 6, 8, 1, 'menu', 1, NULL, NULL, '2018-10-09 08:50:44', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (9, '供应商管理', '/Supplier', NULL, 6, 9, 1, 'menu', 1, NULL, NULL, '2018-10-21 10:25:53', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (10, '承运商管理', '/Carrier', NULL, 6, 10, 1, 'menu', 1, NULL, NULL, '2018-10-21 10:25:58', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (11, '仓库管理', '#', NULL, -1, 11, 1, 'menu', 1, NULL, NULL, '2018-12-18 23:01:36', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (12, '仓库管理', '/Warehouse', NULL, 11, 12, 1, 'menu', 1, NULL, NULL, '2018-10-09 08:48:09', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (13, '库区管理', '/ReservoirArea', NULL, 11, 13, 1, 'menu', 1, NULL, NULL, '2018-10-09 08:49:11', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (14, '货架管理', '/StorageRack', '', 11, 14, 1, 'menu', 1, NULL, NULL, '2018-10-09 08:49:14', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (15, '设备管理', '#', '', -1, 15, 1, 'menu', 1, NULL, NULL, '2018-11-25 22:32:33', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (16, '设备单元', '/Device', NULL, 15, 16, 1, 'menu', 1, NULL, NULL, '2018-11-26 22:28:25', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (17, '生产管理', '#', '', -1, 17, 1, 'menu', 1, NULL, NULL, '2018-11-30 21:22:54', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (18, '生产工单', '/ProductionOrder', NULL, 17, 18, 1, 'menu', 1, NULL, NULL, '2018-11-30 21:24:22', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (19, '工艺管理', '#', NULL, -1, 19, 1, 'menu', 1, NULL, NULL, '2018-12-06 15:43:58', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (20, 'BOM管理', '/BOM', NULL, 19, 20, 1, 'menu', 1, NULL, NULL, '2018-12-06 15:44:58', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (21, '工艺路线', '/Routing', NULL, 19, 21, 1, 'menu', 1, NULL, NULL, '2018-12-17 23:04:45', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (22, '日志管理', '#', '', -1, 22, 1, 'menu', 1, NULL, NULL, '2018-10-09 08:50:51', NULL, NULL); INSERT INTO `sys_menu_wms` VALUES (23, '系统日�