没有合适的资源?快使用搜索试试~ 我知道了~
用友U8 cloud V1.0-查询引擎技术红皮书.pdf
需积分: 5 0 下载量 167 浏览量
2024-02-16
12:47:51
上传
评论
收藏 7.57MB PDF 举报
温馨提示
![preview](https://dl-preview.csdnimg.cn/88838956/0001-fce623fa61b49aeedc8a5b93780c9b3b_thumbnail.jpeg)
![preview-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/scale.ab9e0183.png)
试读
153页
用友U8 cloud V1.0-查询引擎技术红皮书
资源推荐
资源详情
资源评论
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/release/download_crawler_static/88838956/bg1.jpg)
红皮书-1.0
查询引擎技术
![](https://csdnimg.cn/release/download_crawler_static/88838956/bg2.jpg)
新一代云 ERP 解决方案
2
一. 前言 ..................................................................................................................................................................... 1
1.1. 背景 .................................................................................................................................................... 1
1.2. 入门 .................................................................................................................................................... 2
1.3. 小结 .................................................................................................................................................... 9
二. 对象管理 ........................................................................................................................................................... 11
2.1. 对象树 .............................................................................................................................................. 11
2.1.1. 对象编辑 .......................................................................................................................................... 12
2.1.2. 对象导入导出 .................................................................................................................................. 12
2.2. 首选项 .............................................................................................................................................. 13
2.3. 资源权限 .......................................................................................................................................... 15
三. 查询模型 ........................................................................................................................................................... 17
3.1. 参数控制 .......................................................................................................................................... 18
3.2. SQL 设计 ......................................................................................................................................... 20
3.2.1. 数据字典 .......................................................................................................................................... 20
3.2.2. 向导设计 .......................................................................................................................................... 21
3.2.3. 手工设计 .......................................................................................................................................... 28
3.3. 数据交叉 .......................................................................................................................................... 30
3.3.1. 投影交叉 .......................................................................................................................................... 31
3.3.2. 旋转交叉 .......................................................................................................................................... 35
3.4. 代码嵌入 .......................................................................................................................................... 40
3.4.1. SQL 整理 ......................................................................................................................................... 40
![](https://csdnimg.cn/release/download_crawler_static/88838956/bg3.jpg)
新一代云 ERP 解决方案
3
3.4.2. 数据加工 .......................................................................................................................................... 43
3.4.3. 穿透规则 .......................................................................................................................................... 47
3.5. 查询执行 .......................................................................................................................................... 55
3.6. 查询集成 .......................................................................................................................................... 56
3.6.1. 复合查询 .......................................................................................................................................... 56
3.6.2. 物化查询 .......................................................................................................................................... 56
3.6.3. 合并查询 .......................................................................................................................................... 58
3.6.4. 数据权限 .......................................................................................................................................... 59
四. 格式模型 ........................................................................................................................................................... 61
4.1. 引用查询 .......................................................................................................................................... 62
4.2. 格式设计 .......................................................................................................................................... 63
4.2.1. 控件管理 .......................................................................................................................................... 63
4.2.2. 属性绑定 .......................................................................................................................................... 71
4.2.3. 行列格式设计 .................................................................................................................................. 73
4.2.4. 预定义数据处理 .............................................................................................................................. 77
4.3. 报表浏览 .......................................................................................................................................... 85
4.3.1. 界面初始化 ...................................................................................................................................... 85
4.3.2. 数据处理 .......................................................................................................................................... 87
4.3.3. 控件连动 .......................................................................................................................................... 92
4.3.4. 报表打印 .......................................................................................................................................... 93
五. 报表发布 ........................................................................................................................................................... 95
![](https://csdnimg.cn/release/download_crawler_static/88838956/bg4.jpg)
新一代云 ERP 解决方案
4
5.1. 发布为功能节点 .............................................................................................................................. 96
5.1.1. 手动挂接 .......................................................................................................................................... 96
5.1.2. 向导发布 .......................................................................................................................................... 97
六. 插件开发 ........................................................................................................................................................... 99
6.1. 生成插件 .......................................................................................................................................... 99
6.2. 设计插件 ........................................................................................................................................ 107
6.3. 管理插件 ........................................................................................................................................ 108
6.4. 开发小结 ........................................................................................................................................ 109
七. 查询引擎新特性 ............................................................................................................................................. 110
7.1. 新特性 ............................................................................................................................................ 110
7.2. 功能变更清单 ................................................................................................................................ 110
7.3. 功能变更清单 ................................................................................................................................ 111
7.4. 新增功能描述 ................................................................................................................................ 111
7.4.1. 参数重构 ........................................................................................................................................ 111
7.4.2. 分页技术 ........................................................................................................................................ 115
7.4.3. SQL 代码辅助器 ........................................................................................................................... 119
7.4.4. 数据字典级别权限控制 ................................................................................................................ 120
八. 附录 ................................................................................................................................................................. 124
8.1. 查询引擎 FAQ 之参数篇 .............................................................................................................. 124
8.2. 交叉表的使用样例 ........................................................................................................................ 127
8.3. 查询与格式对象安装盘预置方案 ................................................................................................ 133
![](https://csdnimg.cn/release/download_crawler_static/88838956/bg5.jpg)
新一代云 ERP 解决方案
5
8.4. 查询引擎报表联查业务节点应用方案......................................................................................... 134
8.5. 基于 QE 底层的查询个性化设计方案 ......................................................................................... 139
8.6. 个性化控制类(JAVADOC) ..................................................................................................... 144
剩余152页未读,继续阅读
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
![avatar](https://profile-avatar.csdnimg.cn/default.jpg!1)
![avatar-vip](https://csdnimg.cn/release/downloadcmsfe/public/img/user-vip.1c89f3c5.png)
用友开发
- 粉丝: 2
- 资源: 325
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)