点击回首页
我的浏览记录 | | 帮助?
当前位置:
首页>> 企业应用>> Winform 自定义换肤界面OA管理系统源码>> 源文件浏览
[商业版 150RMB] WinForm,下载次数:5 次 | 关键字: 皮肤 控件 oa

源码截图

源码目录树

;
当前路径:OfficeAutomation/Data/cooldb.sql
/*
 Navicat Premium Data Transfer

 Source Server         : MySql
 Source Server Type    : MySQL
 Source Server Version : 50168
 Source Host           : 192.168.1.135:3306
 Source Schema         : cooldb

 Target Server Type    : MySQL
 Target Server Version : 50168
 File Encoding         : 65001

 Date: 28/08/2019 18:01:11
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bumenguanli5
-- ----------------------------
DROP TABLE IF EXISTS `bumenguanli5`;
CREATE TABLE `bumenguanli5`  (
  `autoid` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  PRIMARY KEY (`autoid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for cheliangguanli15
-- ----------------------------
DROP TABLE IF EXISTS `cheliangguanli15`;
CREATE TABLE `cheliangguanli15`  (
  `autoid` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号',
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
  `gouchetime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购车日期',
  `baoyang` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上次保养',
  `lichengshu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '里程数',
  `state` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`autoid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for field
-- ----------------------------
DROP TABLE IF EXISTS `field`;
CREATE TABLE `field`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `menu_id` int(11) NOT NULL COMMENT '菜单编号',
  `field` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表字段',
  `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 285 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of field
-- ----------------------------
INSERT INTO `field` VALUES (1, 1, 'name', '名称');
INSERT INTO `field` VALUES (2, 2, 'type', '类型');
INSERT INTO `field` VALUES (3, 2, 'title', '标题');
INSERT INTO `field` VALUES (4, 2, 'caption', '说明');
INSERT INTO `field` VALUES (5, 2, 'createtime', '创建时间');
INSERT INTO `field` VALUES (6, 3, 'id', '编号');
INSERT INTO `field` VALUES (7, 3, 'degree', '程度');
INSERT INTO `field` VALUES (8, 3, 'title', '标题');
INSERT INTO `field` VALUES (9, 3, 'note', '当前节点');
INSERT INTO `field` VALUES (10, 3, 'starttime', '发起时间');
INSERT INTO `field` VALUES (11, 3, 'endtime', '到期时间');
INSERT INTO `field` VALUES (12, 3, 'state', '状态');
INSERT INTO `field` VALUES (13, 4, 'id', '编号');
INSERT INTO `field` VALUES (14, 4, 'degree', '程度');
INSERT INTO `field` VALUES (15, 4, 'title', '标题');
INSERT INTO `field` VALUES (16, 4, 'note', '当前节点');
INSERT INTO `field` VALUES (17, 4, 'initiator', '发起人');
INSERT INTO `field` VALUES (18, 4, 'starttime', '发起时间');
INSERT INTO `field` VALUES (19, 4, 'endtime', '到期时间');
INSERT INTO `field` VALUES (20, 4, 'state', '状态');
INSERT INTO `field` VALUES (21, 5, 'id', '编号');
INSERT INTO `field` VALUES (22, 5, 'degree', '程度');
INSERT INTO `field` VALUES (23, 5, 'title', '标题');
INSERT INTO `field` VALUES (24, 5, 'note', '当前节点');
INSERT INTO `field` VALUES (25, 5, 'initiator', '发起人');
INSERT INTO `field` VALUES (26, 5, 'starttime', '发起时间');
INSERT INTO `field` VALUES (27, 5, 'endtime', '到期时间');
INSERT INTO `field` VALUES (28, 5, 'state', '状态');
INSERT INTO `field` VALUES (29, 6, 'id', '编号');
INSERT INTO `field` VALUES (30, 6, 'degree', '程度');
INSERT INTO `field` VALUES (31, 6, 'title', '标题');
INSERT INTO `field` VALUES (32, 6, 'note', '当前节点');
INSERT INTO `field` VALUES (33, 6, 'initiator', '发起人');
INSERT INTO `field` VALUES (34, 6, 'starttime', '发起时间');
INSERT INTO `field` VALUES (35, 6, 'endtime', '到期时间');
INSERT INTO `field` VALUES (36, 6, 'state', '状态');
INSERT INTO `field` VALUES (37, 7, 'type', '类型');
INSERT INTO `field` VALUES (38, 7, 'name', '客户名称');
INSERT INTO `field` VALUES (39, 7, 'level', '级别');
INSERT INTO `field` VALUES (40, 7, 'kehutype', '客户类型');
INSERT INTO `field` VALUES (41, 7, 'kehustate', '客户状态');
INSERT INTO `field` VALUES (42, 7, 'yuangongshuliang', '员工数量');
INSERT INTO `field` VALUES (43, 7, 'shengshi', '省市');
INSERT INTO `field` VALUES (44, 7, 'addr', '详细地址');
INSERT INTO `field` VALUES (45, 7, 'lianxiren', '联系人');
INSERT INTO `field` VALUES (46, 7, 'fuzeren', '负责人');
INSERT INTO `field` VALUES (47, 7, 'createtime', '创建时间');
INSERT INTO `field` VALUES (48, 7, 'endtime', '到期时间');
INSERT INTO `field` VALUES (49, 7, 'tixingtime', '提醒时间');
INSERT INTO `field` VALUES (50, 7, 'genjin', '跟进');
INSERT INTO `field` VALUES (51, 7, 'lianxi', '联系');
INSERT INTO `field` VALUES (52, 7, 'state', '状态');
INSERT INTO `field` VALUES (53, 8, 'type', '类型');
INSERT INTO `field` VALUES (54, 8, 'title', '标题');
INSERT INTO `field` VALUES (55, 8, 'kehu', '客户');
INSERT INTO `field` VALUES (56, 8, 'lianxiren', '联系人');
INSERT INTO `field` VALUES (57, 8, 'shouji', '手机');
INSERT INTO `field` VALUES (58, 8, 'fuzeren', '负责人');
INSERT INTO `field` VALUES (59, 8, 'genjintime', '跟进日期');
INSERT INTO `field` VALUES (60, 8, 'genjinnext', '下次跟进');
INSERT INTO `field` VALUES (61, 8, 'createtime', '创建时间');
INSERT INTO `field` VALUES (62, 8, 'state', '状态');
INSERT INTO `field` VALUES (63, 9, 'type', '类型');
INSERT INTO `field` VALUES (64, 9, 'kehu', '客户');
INSERT INTO `field` VALUES (65, 9, 'lianxiren', '联系人');
INSERT INTO `field` VALUES (66, 9, 'sex', '性别');
INSERT INTO `field` VALUES (67, 9, 'birthday', '生日');
INSERT INTO `field` VALUES (68, 9, 'mobilephone', '手机');
INSERT INTO `field` VALUES (69, 9, 'call', '电话');
INSERT INTO `field` VALUES (70, 9, 'email', '邮件');
INSERT INTO `field` VALUES (71, 9, 'addr', '地址');
INSERT INTO `field` VALUES (72, 9, 'createtime', '创建时间');
INSERT INTO `field` VALUES (73, 9, 'state', '状态');
INSERT INTO `field` VALUES (74, 14, 'id', '编号');
INSERT INTO `field` VALUES (75, 14, 'name', '名称');
INSERT INTO `field` VALUES (76, 14, 'authority', '权限值');
INSERT INTO `field` VALUES (77, 15, 'id', '编号');
INSERT INTO `field` VALUES (78, 15, 'name', '名称');
INSERT INTO `field` VALUES (79, 15, 'phone', '电话');
INSERT INTO `field` VALUES (80, 15, 'email', '邮箱');
INSERT INTO `field` VALUES (81, 16, 'id', '编号');
INSERT INTO `field` VALUES (82, 16, 'name', '名称');
INSERT INTO `field` VALUES (83, 16, 'level', '层级');
INSERT INTO `field` VALUES (84, 17, 'id', '编号');
INSERT INTO `field` VALUES (85, 17, 'bumen', '部门');
INSERT INTO `field` VALUES (86, 17, 'name1', '真实姓名');
INSERT INTO `field` VALUES (87, 17, 'name2', '用户名');
INSERT INTO `field` VALUES (88, 17, 'juese', '角色');
INSERT INTO `field` VALUES (89, 17, 'dainhua', '电话');
INSERT INTO `field` VALUES (90, 17, 'gongzi', '工资');
INSERT INTO `field` VALUES (91, 18, 'name', '姓名');
INSERT INTO `field` VALUES (92, 18, 'bumen', '部门');
INSERT INTO `field` VALUES (93, 18, 'uid', '用户名');
INSERT INTO `field` VALUES (94, 18, 'juese', '角色');
INSERT INTO `field` VALUES (95, 18, 'dianhua', '电话');
INSERT INTO `field` VALUES (96, 18, 'state', '状态');
INSERT INTO `field` VALUES (97, 18, 'time', '最后更新');
INSERT INTO `field` VALUES (98, 19, 'id', '编号');
INSERT INTO `field` VALUES (99, 19, 'type', '类型');
INSERT INTO `field` VALUES (100, 19, 'time', '时间');
INSERT INTO `field` VALUES (137, 19, 'ip', 'IP地址');
INSERT INTO `field` VALUES (138, 19, 'beizhu', '备注');
INSERT INTO `field` VALUES (139, 19, 'state', '状态');
INSERT INTO `field` VALUES (140, 20, 'bumen', '部门');
INSERT INTO `field` VALUES (141, 20, 'chengyuan', '成员');
INSERT INTO `field` VALUES (142, 20, 'yi', '星期一');
INSERT INTO `field` VALUES (143, 20, 'er', '星期二');
INSERT INTO `field` VALUES (144, 20, 'san', '星期三');
INSERT INTO `field` VALUES (145, 20, 'si', '星期四');
INSERT INTO `field` VALUES (146, 20, 'wu', '星期五');
INSERT INTO `field` VALUES (147, 20, 'liu', '星期六');
INSERT INTO `field` VALUES (148, 20, 'qi', '星期日');
INSERT INTO `field` VALUES (149, 21, 'bumen', '部门');
INSERT INTO `field` VALUES (150, 21, 'chengyuan', '成员');
INSERT INTO `field` VALUES (151, 21, 'shangban', '上班');
INSERT INTO `field` VALUES (152, 21, 'xiaban', '下班');
INSERT INTO `field` VALUES (153, 21, 'waichu', '外出');
INSERT INTO `field` VALUES (154, 21, 'qingjia', '请假');
INSERT INTO `field` VALUES (155, 21, 'jiaban', '加班');
INSERT INTO `field` VALUES (156, 21, 'zhengchang', '正常');
INSERT INTO `field` VALUES (157, 21, 'chidao', '迟到');
INSERT INTO `field` VALUES (158, 21, 'zaotui', '早退');
INSERT INTO `field` VALUES (159, 21, 'kuanggong', '旷工');
INSERT INTO `field` VALUES (160, 22, 'type', '类型');
INSERT INTO `field` VALUES (161, 22, 'title', '标题');
INSERT INTO `field` VALUES (162, 22, 'shenqingren', '申请人');
INSERT INTO `field` VALUES (163, 22, 'shenqingtime', '申请时间');
INSERT INTO `field` VALUES (164, 22, 'state', '状态');
INSERT INTO `field` VALUES (165, 22, 'fujian', '附件');
INSERT INTO `field` VALUES (166, 24, 'type', '类型');
INSERT INTO `field` VALUES (167, 24, 'title', '标题');
INSERT INTO `field` VALUES (168, 24, 'shenqingren', '申请人');
INSERT INTO `field` VALUES (169, 24, 'shenqingtime', '申请时间');
INSERT INTO `field` VALUES (170, 24, 'state', '状态');
INSERT INTO `field` VALUES (171, 24, 'fujian', '附件');
INSERT INTO `field` VALUES (172, 25, 'id', '编号');
INSERT INTO `field` VALUES (173, 25, 'type', '类型');
INSERT INTO `field` VALUES (174, 25, 'title', '标题');
INSERT INTO `field` VALUES (175, 25, 'fabutime', '发布时间');
INSERT INTO `field` VALUES (176, 25, 'faburen', '发布人');
INSERT INTO `field` VALUES (177, 25, 'bumen', '部门');
INSERT INTO `field` VALUES (178, 25, 'state', '状态');
INSERT INTO `field` VALUES (179, 25, 'fujian', '附件');
INSERT INTO `field` VALUES (180, 26, 'id', '编号');
INSERT INTO `field` VALUES (181, 26, 'type', '类型');
INSERT INTO `field` VALUES (182, 26, 'title', '标题');
INSERT INTO `field` VALUES (183, 26, 'fabutime', '发布时间');
INSERT INTO `field` VALUES (184, 26, 'faburen', '发布人');
INSERT INTO `field` VALUES (185, 26, 'bumen', '部门');
INSERT INTO `field` VALUES (186, 26, 'state', '状态');
INSERT INTO `field` VALUES (187, 26, 'fujian', '附件');
INSERT INTO `field` VALUES (188, 27, 'id', '编号');
INSERT INTO `field` VALUES (189, 27, 'type', '类型');
INSERT INTO `field` VALUES (190, 27, 'uid', '账号名');
INSERT INTO `field` VALUES (191, 27, 'createtime', '创建时间');
INSERT INTO `field` VALUES (192, 27, 'state', '状态');
INSERT INTO `field` VALUES (193, 29, 'id', '编号');
INSERT INTO `field` VALUES (194, 29, 'type', '类型');
INSERT INTO `field` VALUES (195, 29, 'title', '标题');
INSERT INTO `field` VALUES (196, 29, 'fabutime', '发布时间');
INSERT INTO `field` VALUES (197, 29, 'faburen', '发布人');
INSERT INTO `field` VALUES (198, 29, 'bumen', '部门');
INSERT INTO `field` VALUES (199, 29, 'state', '状态');
INSERT INTO `field` VALUES (200, 29, 'fujian', '附件');
INSERT INTO `field` VALUES (201, 30, 'id', '编号');...
完整源码文件,请先购买后再查看
关于我们 | 顾问团队 | 发展历程 | 联系我们 | 源码上传
联系电话(Tel):4008-010-151(免长途)
地址:北京市海淀区大恒科技大厦五层 邮编:100080
Floor 5th,Daheng Building,Zhongguancun,Beijing,China,100080
51Aspx.com 版权所有 CopyRight © 2006-2022. 京ICP备09089570号 | 京公网安备11010702000869号