文档中心 ›up6 ›整合

通达OA

整合发布于 2021-07-02更新于 2026-06-11 09:57

示例下载：asp.net-vs2013，asp.net-vs2010，jsp-eclipse，jsp-springboot，jsp-myeclipse，php，vue-cil，WinForm(C#)，C++(WTL)，
视频教程：php7测试，php5测试，vue-cli-测试，asp.net-IIS Express测试，asp.net-IIS测试，asp.net-阿里云(oss)测试，asp.net-华为云(obs)测试，jsp-springboot测试，sm4加密传输，压缩传输，Discuz集成，

源码编译：ActiveX(x86)，ActiveX(x64)，Windows(npapi)，NativeMessage，macOS，Linux(海光，兆芯)，arm(鲲鹏，飞腾)，龙芯mips，龙芯LoongArch，

ASP.NET教程：asp.net，IIS Express，IIS，IIS-Https，Oracle，minio，fastdfs，阿里云对象存储(oss)，华为云对象存储(obs)，
jsp-eclipse教程：测试教程，oracle，mysql，SQL Server，minio，fastdfs，阿里云对象存储(oss)，华为云对象存储(obs)，

jsp-springboot教程：测试教程，minio，fastdfs，阿里云对象存储(oss)，华为云对象存储(obs)，

jsp-myeclipse教程：mysql，oracle，SQL Server，fastdfs，

php教程：测试教程，minio，fastdfs，阿里云对象存储(oss)，

教程：WinForm(C#)测试，WTL(C++)测试，在vue.js中使用，在vue-cli中使用，eclipse导入up6，组件引用，自定义事件，自定义业务字段，自定义文件保存路径，授权码，加密存储，加密传输，使用Minio存储，使用FastDFS存储，使用达梦数据库，数据表字段设计，监控fd_create流程，监控f_create流程，监控f_list.jsp流程，

联系我们：QQ：1269085759(技术)，QQ：3040217208(售后)，QQ：1085617561(商务)，微信：13235643658，邮箱：1269085759@qq.com，1085617561@qq.com，qwl@ncmem.com，

资源下载地址：

通达OA 2015：http://pan.baidu.com/s/1qYMxsZU

mysql下载：http://pan.baidu.com/s/1c2oVI5y

整合文件：http://pan.baidu.com/s/1pLJHxYr

通达OA 2017整合教程：http://www.ncmem.com/doc/view.aspx?id=4a8ba6c8c1ba4f4a9bf83ada7b2ce65f

步骤：

1.安装通达OA

2.安装mysql管理工具（将mysql文件夹拷贝到webroot文件夹下）

3.将up6.2相关文件拷贝到webroot文件夹下

4.使用up6.2项目中的sql脚本创建数据表及存储过程

SQL初始化脚本：

SQL初始化代码：

-- 表的结构 'up6_files'

CREATE TABLE IF NOT EXISTS up6_files (

f_id int(11) NOT NULL AUTO_INCREMENT,

f_pid int(11) DEFAULT '0',

f_pidRoot int(11) DEFAULT '0',

f_fdTask tinyint(1) DEFAULT '0',

f_fdID int(11) DEFAULT '0',

f_fdChild tinyint(1) DEFAULT '0',

f_uid int(11) DEFAULT '0',

f_nameLoc varchar(255) DEFAULT '',

f_nameSvr varchar(255) DEFAULT '',

f_pathLoc varchar(255) DEFAULT '',

f_pathSvr varchar(255) DEFAULT '',

f_pathRel varchar(255) DEFAULT '',

f_md5 varchar(40) DEFAULT '',

f_lenLoc bigint(19) DEFAULT '0',

f_sizeLoc varchar(10) DEFAULT '0',

f_pos bigint(19) DEFAULT '0',

f_lenSvr bigint(19) DEFAULT '0',

f_perSvr varchar(7) DEFAULT '0%',

f_complete tinyint(1) DEFAULT '0',

f_time timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

f_deleted tinyint(1) DEFAULT '0',

PRIMARY KEY (f_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 表的结构 'up6_folders'

CREATE TABLE IF NOT EXISTS up6_folders (

fd_id int(11) NOT NULL AUTO_INCREMENT,

fd_name varchar(50) DEFAULT '',

fd_pid int(11) DEFAULT '0',

fd_uid int(11) DEFAULT '0',

fd_length bigint(19) DEFAULT '0',

fd_size varchar(50) DEFAULT '0',

fd_pathLoc varchar(255) DEFAULT '',

fd_pathSvr varchar(255) DEFAULT '',

fd_folders int(11) DEFAULT '0',

fd_files int(11) DEFAULT '0',

fd_filesComplete int(11) DEFAULT '0',

fd_complete tinyint(1) DEFAULT '0',

fd_delete tinyint(1) DEFAULT '0',

fd_json varchar(20000) DEFAULT '',

timeUpload timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

fd_pidRoot int(11) DEFAULT '0',

fd_pathRel varchar(255) DEFAULT '',

PRIMARY KEY (fd_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- Procedures

DELIMITER $$

CREATE DEFINER=root@localhost PROCEDURE fd_files_add_batch(

in fCount int

,in fdCount int)

begin

declare ids_f text default '0';

declare ids_fd text default '0';

declare ids_sort text default '0';

declare ids_content text default '0';

declare ids_attachment text default '0';

declare i int;

set i = 0;

while(i<fdCount) do

insert into up6_folders(fd_pid) values(0);

set ids_fd = concat( ids_fd,",",last_insert_id() );

set i = i + 1;

end while;

set ids_fd = substring(ids_fd,3);

set i = 0;

while(i<fCount) do

insert into up6_files(f_pid) values(0);

set ids_f = concat( ids_f,",",last_insert_id() );

set i = i + 1;

end while;

set ids_f = substring(ids_f,3);

set fCount = fCount - 1;

set i = 0;

while(i<fdCount) do

insert into file_sort(

SORT_PARENT

,SORT_NO

,SORT_NAME

,SORT_TYPE

,USER_ID

,NEW_USER

,MANAGE_USER

,DEL_USER

,DOWN_USER

,SHARE_USER

,OWNER

,SIGN_USER

,REVIEW

,DESCRIPTION

) values(

,''

,'');

set ids_sort = concat( ids_sort,",",last_insert_id() );

set i = i + 1;

end while;

set ids_sort = substring(ids_sort,3);

set i = 0;

while(i<fCount) do

insert into file_content(

SORT_ID

, SUBJECT

, CONTENT

, SEND_TIME

, ATTACHMENT_ID

, ATTACHMENT_NAME

, ATTACHMENT_DESC

, USER_ID

, CONTENT_NO

, NEW_PERSON

, READERS

, CREATER

, LOGS

, KEYWORD

)

values(

,now()

,0);

set ids_content = concat( ids_content,",",last_insert_id() );

set i = i + 1;

end while;

set ids_content = substring(ids_content,3);

set i = 0;

while(i<fCount) do

insert into attachment(

POSITION

, MODULE

, YM

, ATTACH_ID

, ATTACH_FILE

, ATTACH_NAME

, ATTACH_SIGN

, DEL_FLAG

)

values(0,0,0,0,0,0,0,0);

set ids_attachment = concat( ids_attachment,",",last_insert_id() );

set i = i + 1;

end while;

set ids_attachment = substring(ids_attachment,3);

select ids_f,ids_fd,ids_sort,ids_content,ids_attachment;

end$$

CREATE DEFINER=root@localhost PROCEDURE fd_process(in uidSvr int,in fd_idSvr int,in fd_lenSvr bigint(19),in perSvr varchar(6))

update up6_files set f_lenSvr=fd_lenSvr ,f_perSvr=perSvr where f_uid=uidSvr and f_id=fd_idSvr$$

CREATE DEFINER=root@localhost PROCEDURE fd_update(

in _name varchar(50)

,in _pid int

,in _uid int

,in _length bigint

,in _size varchar(50)

,in _pathLoc varchar(255)

,in _pathSvr varchar(255)

,in _folders int

,in _files int

,in _filesComplete int

,in _complete tinyint

,in _delete tinyint

,in _pidRoot int

,in _pathRel varchar(255)

,in _id int

)

update up6_folders set

fd_name = _name

,fd_pid = _pid

,fd_uid = _uid

,fd_length = _length

,fd_size = _size

,fd_pathLoc = _pathLoc

,fd_pathSvr = _pathSvr

,fd_folders = _folders

,fd_files = _files

,fd_filesComplete = _filesComplete

,fd_complete = _complete

,fd_delete = _delete

,fd_pidRoot = _pidRoot

,fd_pathRel = _pathRel

where

fd_id = _id$$

CREATE DEFINER=root@localhost PROCEDURE f_exist_batch(

in _md5s varchar(1000)

)

select

f_id

,f_uid

,f_nameLoc

,f_nameSvr

,f_pathLoc

,f_pathSvr

,f_pathRel

,f_md5

,f_lenLoc

,f_sizeLoc

,f_pos

,f_lenSvr

,f_perSvr

,f_complete

,f_time

,f_deleted

,max(f_lenSvr)

from up6_files

where find_in_set (f_md5 ,_md5s)

group by f_md5$$

CREATE DEFINER=root@localhost PROCEDURE f_process(in posSvr bigint(19),in lenSvr bigint(19),in perSvr varchar(6),in uidSvr int,in fidSvr int,in complete tinyint)

update up6_files set f_pos=posSvr,f_lenSvr=lenSvr,f_perSvr=perSvr,f_complete=complete where f_uid=uidSvr and f_id=fidSvr$$

CREATE DEFINER=root@localhost PROCEDURE f_update(

in _pid int

,in _pidRoot int

,in _fdTask tinyint

,in _fdChild tinyint

,in _uid int

,in _nameLoc varchar(255)

,in _nameSvr varchar(255)

,in _pathLoc varchar(255)

,in _pathSvr varchar(255)

,in _md5 varchar(40)

,in _lenLoc bigint

,in _lenSvr bigint

,in _perSvr varchar(7)

,in _sizeLoc varchar(10)

,in _complete tinyint

,in _id int

)

update up6_files set

f_pid = _pid

,f_pidRoot = _pidRoot

,f_fdTask = _fdTask

,f_fdChild = _fdChild

,f_uid = _uid

,f_nameLoc = _nameLoc

,f_nameSvr = _nameSvr

,f_pathLoc = _pathLoc

,f_pathSvr = _pathSvr

,f_md5 = _md5

,f_lenLoc = _lenLoc

,f_lenSvr = _lenSvr

,f_perSvr = _perSvr

,f_sizeLoc = _sizeLoc

,f_complete = _complete

where f_id = _id$$

CREATE DEFINER=root@localhost PROCEDURE update_attachment(

in _position tinyint

,in _module tinyint

,in _ym char(4)

,in _attach_id int

,in _attach_file varchar(200)

,in _attach_name varchar(200)

,in _attach_sign bigint

,in _del_flag tinyint

,in _aid int

)

update attachment set

position = _position

,module = _module

,ym = _ym

,attach_id = _attach_id

,attach_file = _attach_file

,attach_name = _attach_name

,attach_sign = _attach_sign

,del_flag = _del_flag

where

aid = _aid$$

CREATE DEFINER=root@localhost PROCEDURE update_content(

in _sort_id int

,in _subject varchar(200)

,in _content mediumtext

,in _send_time datetime

,in _attachment_id text

,in _attachment_name text

,in _attachment_desc varchar(100)

,in _user_id varchar(20)

,in _content_no int

,in _new_person varchar(100)

,in _readers text

,in _creater varchar(100)

,in _logs text

,in _keyword varchar(100)

,in _content_id int

)

update file_content set

sort_id = _sort_id

,subject = _subject

,content = _content

,send_time = _send_time

,attachment_id = _attachment_id

,attachment_name = _attachment_name

,attachment_desc = _attachment_desc

,user_id = _user_id

,content_no = _content_no

,new_person = _new_person

,readers = _readers

,creater = _creater

,logs = _logs

,keyword = _keyword

where

content_id = _content_id$$

CREATE DEFINER=root@localhost PROCEDURE update_sort(

in _SORT_ID int

, in _SORT_PARENT int

, in _SORT_NO varchar(20)

, in _SORT_NAME varchar(20)

, in _SORT_TYPE char(1)

, in _USER_ID text

, in _NEW_USER text

, in _MANAGE_USER text

, in _DEL_USER text

, in _DOWN_USER text

, in _SHARE_USER text

, in _OWNER text

, in _SIGN_USER text

, in _REVIEW text

, in _DESCRIPTION text

)

update file_sort set

SORT_PARENT = _SORT_PARENT

,SORT_NO = _SORT_NO

,SORT_NAME = _SORT_NAME

,SORT_TYPE = _SORT_TYPE

,USER_ID = _USER_ID

,NEW_USER = _NEW_USER

,MANAGE_USER = _MANAGE_USER

,DEL_USER = _DEL_USER

,DOWN_USER = _DOWN_USER

,SHARE_USER = _SHARE_USER

,OWNER = _OWNER

,SIGN_USER = _SIGN_USER

,REVIEW = _REVIEW

,DESCRIPTION = _DESCRIPTION

where

SORT_ID = _SORT_ID$$

DELIMITER ;

5.修改up6.js配置

6.修改数据库连接配置DbHelper.php

7.替换文件folder.php和public_folder.php

整合后的效果：

整合到文档中心

上传界面

上传后的层级结构

产品源代码

免费下载产品源代码，提供全平台控件安装包，提供主流开发语言示例，支持Java、C#、PHP、Python、vue等语言的SDK及详细API文档，

免费下载源代码：https://drive.weixin.qq.com/s?k=ACoAYgezAAwNxasjt3

免费下载授权器：https://drive.weixin.qq.com/s?k=ACoAYgezAAw0P06owX

免费下载方案：https://drive.weixin.qq.com/s?k=ACoAYgezAAwyaYbBL3

QQ群

由原厂产品开发团队提供7*24小时1对1专业技术支持服务

通达OA

整合相关文档