《小土豆》自动编程系统-V2015 用户手册 1 目 录
第1章 基础篇 ······················································································ 1 1.1 初次安装使用 ·················································································· 1
1.1.1 安装操作 ................................................................................................................................. 1 1.1.2 创建“用户项目” ................................................................................................................. 1 1.1.3 打开《小土豆》设计器 ......................................................................................................... 2 1.2《小土豆》设计器 ·············································································· 3 1.2.1 设计器结构 ............................................................................................................................. 4 1.2.2 图示化语言 ............................................................................................................................. 4 1.3 模块和流程图 ·················································································· 4 1.3.1、流程开始图标 ....................................................................................................................... 5 1.3.2“功能模块”和“流程线” ........................................................................................................ 5
第2章“主流程”事件································································ 8
2.1项目数据库 ······················································································ 8
2.1.1 使用“Access数据库” ......................................................................................................... 8 2.1.1 使用“SQL Server数据库” .................................................................................................... 9 2.1.4 连接“已有数据库”的重要说明 ....................................................................................... 11 2.1.5“数据库设置” ....................................................................................................................... 12 2.2 数据库基础知识 ············································································· 14 2.2.1 数据库和数据表 ................................................................................................................... 14 2.2.2 字段和记录 ........................................................................................................................... 15 2.3 数据表创建和编辑 ·········································································· 15 2.3.1“数据表”创建 ..................................................................................................................... 15 2.3.2“数据表”编辑 ..................................................................................................................... 16 2.3.3 应注意的问题 ....................................................................................................................... 18 2.4 更改项目数据库说明 ······································································· 18 2.4.1 更改数据库说明 ................................................................................................................... 18 2.4.2 系统表的“导出、导入” ................................................................................................... 19 2.5 关于避免网络冲突 ·········································································· 20 2.6“主流程”创建 ·················································································· 20 2.6.1“主流程”结构 .......................................................................................................................... 20 2.6.2“系统封面”和“主窗体” ................................................................................................... 21 2.7“系统设置” ·················································································· 21 2.7.1“项目密码”设置 ................................................................................................................... 21 2.7.2“系统图标”设置 ...................................................................................................................... 22
第3章 窗体“数据源” ······························································· 23
3.1“常规型”数据源 ············································································ 23
3.1.1“常规型”数据源创建 ........................................................................................................... 23 3.1.2“常规型”数据源的提交机制 ............................................................................................. 27 3.1.3 “数据源”应用说明 ........................................................................................................... 28 3.2“汇总型”数据源 ············································································ 28 3.2.1“合并汇总”数据源创建 ....................................................................................................... 28 3.2.2“交叉汇总”数据源创建 ..................................................................................................... 32 3.2.3“子串分组”的实例说明 .......................................................................................................... 38 3.2.4“汇总计算”的实例说明 ..................................................................................................... 42 3.3“数据源组”应用 ············································································· 43 3.3.1、原理说明 ............................................................................................................................. 43 3.3.2 创建“编辑数据”的数据源组 ........................................................................................... 44 3.3.3“连接字段”说明 ................................................................................................................. 46 3.3.4“约束修改和删除”说明 ..................................................................................................... 47 3.3.5 修改数据源“设置或连接”的操作 ................................................................................... 48 3.3.6 断开数据源组需要注意的问题 ........................................................................................... 49 3.4“数据源”的动态查询 ······································································ 49
2 《小土豆》自动编程系统-V2015 用户手册 3.4.1 使用“查询框”改变“条件公式” ........................................................................................ 49 3.4.2 使用“综合任务”改变“条件公式” .................................................................................. 51 3.4.2“汇总型、计算型”数据源的动态查询 ............................................................................. 54 3.5“条件公式”规则与实例 ······································································ 55 3.5.1 编辑规则 ............................................................................................................................... 55 3.5.2“逻辑表达式”应用 ............................................................................................................. 57 3.5.3“条件公式”应用实例 ........................................................................................................... 58 3.5.4“选择型”条件公式 .................................................................................................................. 59 3.6“高级型”数据源介绍 ······································································ 62 3.6.1“多表视图型”数据源（定制版-未开放） ........................................................................ 62 3.6.2“SQL型”数据源 ................................................................................................................... 64
第4章 窗体“设计操作” ·························································· 67
4.1 窗体“应用说明” ·········································································· 67
4.1.1“窗口框架区”说明 ............................................................................................................... 67
4.1.2 窗体保存为模板 ................................................................................................................... 67 4.1.3 窗体文件的交流 ................................................................................................................... 69 4.2 窗体“设计基础” ············································································· 70 4.2.1 控件的选用 ........................................................................................................................... 71 4.2.2 使用“帮助” ....................................................................................................................... 71 4.2.3 控件“属性设置” ............................................................................................................... 71 4.3“主窗体”设计 ················································································ 72 4.3.1“主窗体”结构设计 ............................................................................................................. 72 4.3.2“菜单项”事件设计 ............................................................................................................... 73 4.4“子窗体”设计 ··············································································· 74 4.4.1 窗体功能规划 ....................................................................................................................... 74 4.4.2 窗体功能的设计步骤 ........................................................................................................... 76 4.5 窗体“快速设计” ············································································· 77 4.5.1 编辑框－批量生成 ............................................................................................................... 77 4.5.2 表单框－设计向导 ............................................................................................................... 78 4.5.4 查询卡片－设计向导 ........................................................................................................... 79 4.6 窗体“智能化控制” ·········································································· 80 4.6.1“智能计算”应用 ................................................................................................................... 80 4.6.2“智能检测”应用 ................................................................................................................... 89 4.6.3“智能显示”应用 ................................................................................................................... 95 4.7 窗体“权限控制” ············································································· 99 4.7.1 编辑“用户权限” ............................................................................................................... 99 4.7.2“权限编辑器”的使用 ......................................................................................................... 99 4.7.3“权限控制”控件属性 ....................................................................................................... 100 4.7.4“权限控制”数据源条件 ................................................................................................... 102 4.8 窗体“应用设置” ············································································ 103 4.8.1“Tab键跳转次序” 设置 .................................................................................................... 103 4.8.2 窗体设计器“环境设置” ................................................................................................. 104 4.8.3“属性公式”编辑器 ........................................................................................................... 105 4.8.4 设计器“快捷操作键” ..................................................................................................... 110
第5章“窗体”事件定义·························································· 114
5.1 事件编辑基础 ··············································································· 114
5.1.1 “控件事件”的编辑方法 .................................................................................................... 114
5.1.2“窗体对象”事件编辑器 ..................................................................................................... 115 5.1.3 事件流程结构类型 ............................................................................................................. 115 5.2 表达式编辑基础 ············································································ 116 5.2.1 表达式分类 ......................................................................................................................... 116 5.2.2 编辑器结构 ......................................................................................................................... 117 5.2.3 表达式属性 ......................................................................................................................... 119 5.2.4“&()”函数应用 ...................................................................................................................... 120 5.2.5“如果：”应用 ........................................................................................................................ 121
《小土豆》自动编程系统-V2015 用户手册 3 5.2.6 编辑器“环境设置” ......................................................................................................... 121 5.3“子查询”应用 ·············································································· 122 5.3.1“子查询”应用实例 ........................................................................................................... 122 5.3.2“查询类型”说明 .................................................................................................................... 127 5.3.3“子查询”的引用 ............................................................................................................... 128 5.4“检测执行”模块 ··········································································· 129 5.4.1“程序分支”原理 ................................................................................................................. 129 5.4.2“检测执行”应用实例 ....................................................................................................... 129 5.4.3“检测执行”公式实例 ....................................................................................................... 133 5.5“导出数据”模块 ············································································ 134 5.5.1“数据备份”功能的实现 ........................................................................................................ 134 5.5.2“导出数据”高级选项 ......................................................................................................... 136 5.5.3“导出数据”的路径公式实例 ........................................................................................... 137 5.5.4“导出数据”模块说明 ....................................................................................................... 138 5.6“导入数据”模块 ············································································ 138 5.5.1“数据恢复”功能的实现 ................................................................................................... 138 5.6.2“导入数据”高级选项 ....................................................................................................... 140 5.6.3“导入数据”的路径公式实例 ........................................................................................... 141 5.6.4“导入数据”模块说明 ....................................................................................................... 142 5.7“流程标注”模块 ··········································································· 142 5.7.1“标注文本”编辑 ............................................................................................................... 142 5.7.2 位置和尺寸 ......................................................................................................................... 142 5.7.3 与“标注对象”的连接 .......................................................................................................... 142 5.8“已有事件”页使用说明 ·································································· 142
第6章“综合任务”应用 ····························································· 144
6.1“控件行为”的调用 ········································································ 144
6.1.1 为何调用“控件行为” ..................................................................................................... 144 6.1.2 应用实例 ............................................................................................................................. 144 6.2“已有事件”的引用 ········································································ 145 6.2.1 为何引用“已有事件” ..................................................................................................... 145 6.2.2 应用实例 ............................................................................................................................. 146 6.3“控件属性”的动态改变 ·································································· 146 6.3.1“标题、当前值、状态值”的改变 ........................................................................................ 146 6.3.2“文件、图片”的改变 ....................................................................................................... 148 6.3.3“字段值”的动态改变 ......................................................................................................... 149 6.3.4单元格“数据值、颜色字体”的动态改变 ......................................................................... 150 6.3.5 数据源“指针变动”事件 ................................................................................................. 152 6.3.6“路径名”的表达式编辑 ................................................................................................... 153 6.4“查询公式”的动态改变 ····································································· 154 6.4.1 编辑原理 ............................................................................................................................. 154 6.4.2 应用实例 ............................................................................................................................. 154 6.4.3“查询公式”规则与实例 ..................................................................................................... 156 6.5“定位公式”的动态改变 ····································································· 157 6.5.1 编辑原理 ............................................................................................................................. 157 6.5.2 应用实例 ............................................................................................................................. 157 6.5.3“定位公式”规则与实例 ..................................................................................................... 159 6.6“排序公式”的动态改变 ····································································· 160 6.6.1 编辑原理 ............................................................................................................................. 160 6.6.2 应用实例 ............................................................................................................................. 160 6.6.3“排序公式”规则与实例 ..................................................................................................... 161 6.7“可执行函数”的调用 ········································································ 161 6.7.1 可被调用的执行“函数” ................................................................................................. 161 6.7.2 应用实例 ............................................................................................................................. 162 6.8“变量”应用 ················································································· 162 4.8.8“变量、公有变量”应用 ..................................................................................................... 162
4 《小土豆》自动编程系统-V2015 用户手册 6.8.1 应用实例 ............................................................................................................................. 169 6.8.3“变量”应用说明 ............................................................................................................... 170 6.9“循环执行”表达式编辑 ·································································· 171 6.9.1“按条件循环：”子句的应用 ............................................................................................. 171 6.9.2“循环到条件：”子句的应用 ............................................................................................. 172 6.9.3“按变量循环：”子句的应用 ............................................................................................. 173 6.10“资源文件”的上传下载 ································································ 174 6.10.1“资源文件”应用基础 ..................................................................................................... 175 6.10.2 应用实例 ........................................................................................................................... 175
第7章“数据加工”应用 ··························································· 177
7.1“计算修改”模块 ·············································································· 177
7.1.1“表内计算”功能的实现 ..................................................................................................... 177
7.1.2“表外取值”功能的实现 ..................................................................................................... 182 7.1.3“横纵计算”功能的实现 ................................................................................................... 185 7.1.4“智能计算”规则与实例 ..................................................................................................... 188 7.1.5“计算修改”的高级选项 ................................................................................................... 192 7.2“生成记录”模块 ············································································ 193 7.2.1自动编号”功能的实现 ...................................................................................................... 193 7.2.2“自动行关联取值”的功能实现 ............................................................................................ 195 7.2.3“智能计算”规则与实例 ..................................................................................................... 198 7.2.4“记录条数”规则与实例 ................................................................................................... 198 7.2.5“生成记录”的高级选项 ........................................................................................................ 198 7.3“删除记录”模块 ············································································ 199 7.3.1“条件删除”功能的实现 ..................................................................................................... 199 7.3.2 “删除重复记录”功能的实现 ............................................................................................... 201 7.3.3“子查询条件”实现特殊删除 ........................................................................................... 204 7.3.4“删除记录”的高级选项 ................................................................................................... 207 7.4“复制记录”模块 ··········································································· 207 7.4.1“简单复制”功能的实现 ................................................................................................... 207 7.4.2“子查询条件”实现特殊复制 ............................................................................................. 210 7.4.3 复制后计算的实例 ............................................................................................................. 213 7.4.4“复制记录”的高级选项 ................................................................................................... 214 7.5“分组汇总”模块 ············································································ 214 7.5.1“简单汇总”功能的实现 ................................................................................................... 214 7.5.2 “子查询”实现特殊汇总 ................................................................................................. 217 7.5.3“子串分组”的实例说明 ................................................................................................... 220 7.5.5“分组汇总”的高级选项 ................................................................................................... 224 7.6“分组累计”模块 ············································································ 224 7.6.1“分组累计”原理说明 ....................................................................................................... 225 7.6.2“顺序排名”功能的实现 ................................................................................................... 225 7.6.3“销量累计”功能的实现 ................................................................................................... 230 7.6.4“子串分组”的实例说明 ................................................................................................... 233 7.6.5“累计递增值”说明 ............................................................................................................. 233 7.6.6“累计初始值”说明 ........................................................................................................... 233 7.6.7“分组累计”的高级选项 ................................................................................................... 234 7.7“行次整理”模块 ············································································ 234 7.7.1“次序整理”功能的实现 ..................................................................................................... 234 7.7.2“行次整理”的高级选项 ..................................................................................................... 237 7.9“综合应用”实例 ··········································································· 237 7.9.1“库存余量”的动态更新应用 ........................................................................................... 237 7.9.2 数据加工后“排序、定位”事件 ..................................................................................... 246
第8章 项目发布和运行 ··························································· 248
8.1 生成安装文件 ··············································································· 248
8.1.1“文件生成路径”设置 ............................................................................................................ 248
8.1.2“版权说明编辑” ................................................................................................................. 248
《小土豆》自动编程系统-V2015 用户手册 5 8.1.3“项目保护设置” .................................................................................................................... 249 8.1.4“资源文件打包”设置 ......................................................................................................... 249 8.1.5 生成的安装文件包 ............................................................................................................. 249 8.2 安装“用户项目” ··········································································· 249 8.2.1 使用“SETUP.EXE”文件安装 ......................................................................................... 250 8.2.2 使用“项目文件.EXE”文件 ............................................................................................ 250 8.3“数据库”和“资源文件”······························································· 250 8.3.1“项目数据库”的连通机制 ............................................................................................... 250 8.3.2 移植“资源文件” ............................................................................................................. 251 8.3.3 升级“用户项目” ............................................................................................................. 251 8.3.4 更改为“SQL Server”的方法 .......................................................................................... 251 8.3.5 动态更改“项目数据库”连接 ......................................................................................... 254 8.4 关于“注册码”加密 ········································································ 254 8.4.1 获得注册机器码 ................................................................................................................. 254 8.4.2 生成注册激活码 ................................................................................................................. 255 8.5 关于“USB卡”加密 ········································································· 255 8.5.1 生成安装文件： ................................................................................................................. 255 8.5.2“加密操作” ....................................................................................................................... 257 8.5.3 试运行 ................................................................................................................................. 260 8.5.4 再次制作USB加密卡 ....................................................................................................... 261 8.6 关于申请办理知识产权证书 ····························································· 262 8.6.1 代码文件的获得 ................................................................................................................. 262 8.6.2 其他 ..................................................................................................................................... 262
第9章 项目规划原理 ······························································ 263
9.1 管理软件的构成 ············································································ 263
9.1.1 数据库 ................................................................................................................................. 263
9.1.2 数据库操作 ......................................................................................................................... 263 9.1.3 窗体交互界面 ..................................................................................................................... 263 9.2数据表规划原理 ············································································· 263 9.2.1 数据表的建立 ..................................................................................................................... 263 9.2.2 数据表创建要诀 ................................................................................................................. 264 9.2.3 数据表的修改 ..................................................................................................................... 264 9.2.4 数据库规划的总结 ............................................................................................................. 265 9.3系统结构规划 ················································································ 265 9.3.1 结构规划方法 ..................................................................................................................... 265 9.3.2“系统功能”菜单项 ........................................................................................................... 265 9.3.3、“应用功能”菜单项(多列) ............................................................................................... 265 9.3.4“信息编辑”菜单项 ........................................................................................................... 265 9.3.5“帮助和其它”菜单项 ....................................................................................................... 265 9.4 系统功能实现 ··············································································· 265 9.4.1 系统功能分类 ..................................................................................................................... 266 9.4.2“数据采集”功能 ............................................................................................................... 266 9.4.3“数据加工”功能 ............................................................................................................... 267 9.4.4“数据输出”功能 ............................................................................................................... 268 9.5 项目开发过程规范 ········································································· 268 9.5.1 创建规划试验项目 ............................................................................................................. 268 9.5.2 正式开发项目 ..................................................................................................................... 270
第10章“控件”应用详解 ························································ 271
10.1“控件”的共有特性 ········································································ 271
10.1.1 控件的共有“属性” ......................................................................................................... 271
10.1.2控件的共有“事件” .......................................................................................................... 272 10.1.3控件的共有“行为” .......................................................................................................... 272 10.2“窗体和数据源” ········································································· 273 10.2.1“窗体”单元 ..................................................................................................................... 273 10.2.2“数据源”控件 ................................................................................................................... 276