6 《小土豆》自动编程系统-V2015 用户手册 10.3 常用控件组 ················································································· 281 10.3.1“面板”控件 ..................................................................................................................... 281 10.3.2“选项卡”控件 ................................................................................................................. 283 10.3.3“色块”控件 ....................................................................................................................... 284 10.3.4“线框”控件 ..................................................................................................................... 285 10.3.5“标签”控件 ..................................................................................................................... 285 10.3.6“长标签”控件 ................................................................................................................... 287 10.3.7“标题字”控件 ................................................................................................................. 288 10.3.8“图片”控件 ..................................................................................................................... 289 10.3.9“媒体播放”控件 ............................................................................................................. 291 10.3.10“按键”控件 ..................................................................................................................... 292 10.3.11“弹出式菜单”控件 ....................................................................................................... 293 10.3.12“树形菜单”控件 ........................................................................................................... 293 10.3.13“折叠式菜单”控件 ....................................................................................................... 294 10.4 数据控件组 ················································································· 295 10.4.1“编辑框”控件 ................................................................................................................. 295 10.4.2“表单框”控件 ................................................................................................................. 303 10.4.3“卡片框”控件 ................................................................................................................... 309 10.4.4“长编辑框”控件 ............................................................................................................... 310 10.4.5“选择框”控件 ................................................................................................................. 310 10.4.6“复选框”控件 ................................................................................................................. 311 10.4.7“单选钮”控件 ................................................................................................................. 312 10.4.8“单选框”控件 ................................................................................................................. 313 10.4.9“报表”控件 ..................................................................................................................... 314 10.4.10“图表”控件 ................................................................................................................... 315 10.4.11“查询框”控件 ............................................................................................................... 316 10.4.12“数据源控制键” ................................................................................................................ 319 10.5 其它控件组 ················································································· 320 10.5.1“USB摄像头”控件 ........................................................................................................... 320 10.5.2“串口设备控制”控件 ..................................................................................................... 321 10.5.3“文件选择框”控件 ......................................................................................................... 324 10.5.4“液晶数码屏”控件 ......................................................................................................... 325 10.5.5“计时钟”控件 ................................................................................................................. 325 10.6 专业控件组（USB版） ································································· 326 10.6.1“框架”控件 ..................................................................................................................... 326 10.6.2“折叠式面板”控件 ......................................................................................................... 328 10.6.3“分组框”控件 ................................................................................................................. 330 10.6.4“滚动式文本”控件 ......................................................................................................... 331 10.6.5“展示图片”控件 ............................................................................................................. 332 10.6.6“SWF动画播放”控件 ...................................................................................................... 333 10.6.7“窗体打印”控件 ............................................................................................................. 334 10.6.8“音频录放”控件 ............................................................................................................. 335 10.6.9“音量控制”控件 ............................................................................................................. 337 10.6.10“仪表盘”控件 ............................................................................................................... 337 10.6.11“刻度计”控件 ............................................................................................................... 337 10.6.12“存量指示器”控件 ....................................................................................................... 338 10.6.13“刻度尺”控件 ............................................................................................................... 338 10.6.14“进度条” ....................................................................................................................... 338 10.6.15“分隔条”控件 ............................................................................................................... 339 10.7 专业数据控件组（USB版） ··························································· 339 10.7.1“业务流管理”控件 ......................................................................................................... 339 10.7.2“字段列表树”控件 ......................................................................................................... 343 10.7.3“字段谱系树”控件 ......................................................................................................... 344 10.7.4“组合查询框”控件 ......................................................................................................... 347 10.7.5“查询树”控件 ................................................................................................................. 349 10.7.6“定位框”控件 ................................................................................................................. 352
《小土豆》自动编程系统-V2015 用户手册 7 10.7.7“排序框”控件 ................................................................................................................. 353 10.7.8“报表预览框”控件 ......................................................................................................... 353 10.7.9“Excel表”控件 ................................................................................................................. 354 10.7.10“显示Excel表”控件 .................................................................................................... 356 10.8高级专业控件组（USB定制版） ······················································ 357 10.8.1“二维码”控件 ................................................................................................................. 357 10.8.2“定时器”控件 ................................................................................................................. 358 10.8.3“并口通讯”控件 ............................................................................................................. 358 10.8.4“年历表”控件 ................................................................................................................. 359 10.9 文件操作控件组（USB定制版） ····················································· 364 10.9.1“驱动器选择”控件 ......................................................................................................... 364 10.9.2“文件夹列表框”控件 ..................................................................................................... 364 10.9.3“文件列表框”控件 ......................................................................................................... 365 10.9.4“文件过滤器”控件 ......................................................................................................... 366 10.6.5“文件名编辑框”控件 ..................................................................................................... 366 10.9.6“字体选择框” ................................................................................................................. 367 10.9.7“颜色选择框” ................................................................................................................. 367 10.9.8“读写外部文件”控件 ..................................................................................................... 368 10.10 网络应用控件组（USB定制版） ··················································· 370 10.10.1“网页浏览框”控件 ....................................................................................................... 370 10.10.2“邮件发送”控件 ........................................................................................................... 374 10.10.3“客户端信息收发”控件 ............................................................................................... 376 10.10.4“服务端信息收发”控件 ............................................................................................... 378
第11章“报表、图表”设计器 ·················································· 382
11.1“报表设计器”应用 ········································································ 382
11.1.1 报表设计基础 ................................................................................................................... 382
11.1.2 报表栏属性和设置 ........................................................................................................... 383 11.1.3 使用向导创建报表 ........................................................................................................... 388 11.1.4 自定义复杂报表 ............................................................................................................... 395 11.1.5 报表控件详述 ................................................................................................................... 396 11.1.6 报表设计时应注意的问题 ............................................................................................... 406 11.1.7“环境设置” ..................................................................................................................... 407 11.2“图表设计器”应用 ········································································ 407 11.2.1“图表类型”和“序列设置” ......................................................................................... 407 11.2.2“长条图”设置 ................................................................................................................. 408 11.2.3“横向长条图”设置 ......................................................................................................... 410 11.2.4“折线图”设置 ................................................................................................................. 411 11.2.5“圆饼图”设置 ................................................................................................................. 412 11.2.6“图例显示”设置 ............................................................................................................. 413
第12章“函数”详解 ······························································ 414
12.1“日期时间”函数组 ······································································ 414
12.1.1 取日期 ............................................................................................................................... 414
12.1.2 取时间 ............................................................................................................................... 415 12.1.3 取日期时间 ....................................................................................................................... 415 12.1.4 取年号 ............................................................................................................................... 415 12.1.5 取月号 ............................................................................................................................... 416 12.1.6 取日号 ............................................................................................................................... 416 12.1.7 取星期号 ........................................................................................................................... 416 12.1.8 取小时值 ........................................................................................................................... 417 12.1.9 取分钟值 ........................................................................................................................... 417 12.1.10 取秒值 ............................................................................................................................. 417 12.1.11 取毫秒值 ......................................................................................................................... 417 12.1.12 取日期时间差 ................................................................................................................. 417 12.1.13 取未来日期 ..................................................................................................................... 419 12.1.14 日期格式化 ..................................................................................................................... 419
8 《小土豆》自动编程系统-V2015 用户手册 12.1.15 检测闰年 ......................................................................................................................... 420 12.1.16互联网日期时间 .............................................................................................................. 420 12.2“字符处理”函数组 ······································································ 421 12.2.1 取字节长度 ....................................................................................................................... 421 12.2.2 取左起字节 ....................................................................................................................... 421 12.2.3 取右起字节 ....................................................................................................................... 421 12.2.4 去掉左空格 ....................................................................................................................... 421 12.2.5 去掉右空格 ....................................................................................................................... 422 12.2.6 取子串位置 ....................................................................................................................... 422 12.2.7 替换子串内容 ................................................................................................................... 422 12.2.8 取分隔串内容 ................................................................................................................... 422 12.2.9 取中文字母 ....................................................................................................................... 423 12.2.10 取身份证信息 ................................................................................................................. 423 12.2.11 检测含有字符 ................................................................................................................. 424 12.2.12 加密字符串 ..................................................................................................................... 424 12.2.13 解密字符串 ..................................................................................................................... 425 12.2.14 取随机字符串 ................................................................................................................. 425 12.2.15 异或运算 ......................................................................................................................... 425 12.2.16 正则表达式 ..................................................................................................................... 426 12.2.17 检测正则表达式 ............................................................................................................. 426 12.3“数字处理”函数组 ······································································ 429 12.3.1 取为整数 ........................................................................................................................... 429 12.3.2 取为小数 ........................................................................................................................... 429 12.3.3 取绝对值 ........................................................................................................................... 430 12.3.4 取自然数幂 ....................................................................................................................... 430 12.3.5 取幂运算 ........................................................................................................................... 430 12.3.6 取整除数 ........................................................................................................................... 430 12.3.7 %(取整除余数) .................................................................................................................. 431 12.3.8 取随机值 ........................................................................................................................... 431 12.3.9 取范围随机值 ................................................................................................................... 431 12.3.10 计算个调税 ..................................................................................................................... 431 12.4“类型转换”函数组 ······································································ 432 12.4.1 转为字符 ........................................................................................................................... 432 12.4.2 转为数字 ........................................................................................................................... 432 12.4.3 转为日期 ........................................................................................................................... 433 12.4.4 日期转中文 ....................................................................................................................... 433 12.4.5 日期转大写 ....................................................................................................................... 433 12.4.6 日期转农历 ....................................................................................................................... 433 12.4.7 转换字母大小写 ............................................................................................................... 434 12.4.8 字符转ASCII .................................................................................................................... 434 12.4.9 ASCII转字符 ..................................................................................................................... 434 12.4.10 字符串ASCII值互转（进制转换） ............................................................................. 435 12.4.11 数字转大写 ..................................................................................................................... 435 12.4.12 数字转币值大写 ............................................................................................................. 435 12.4.13 数字转中文 ..................................................................................................................... 435 12.4.14 数字格式化 ..................................................................................................................... 436 12.4.15 检测数据类型 ................................................................................................................. 437 12.5“列值计算”函数组 ······································································ 438 12.5.1 取合计值 ........................................................................................................................... 438 12.5.2 取最大值 ........................................................................................................................... 438 12.5.3 取最小值 ........................................................................................................................... 439 12.5.4 取平均值 ........................................................................................................................... 439 12.5.5 取记录数 ........................................................................................................................... 439 12.5.6 取自动编号 ....................................................................................................................... 439 12.5.7 取指定行字段值 ............................................................................................................... 440 12.5.8 取随机行字段值 ............................................................................................................... 441
《小土豆》自动编程系统-V2015 用户手册 9 12.5.9 取指定记录号字段值 ....................................................................................................... 441 12.5.10 检测字段值重复 ............................................................................................................. 441 12.6“外部文件”函数组 ········································································ 442 12.6.1 调用可执行文件 ............................................................................................................... 442 12.6.2 调用链接库文件 ............................................................................................................... 443 12.6.3 复制文件 ........................................................................................................................... 444 12.6.4 改变文件名 ....................................................................................................................... 445 12.6.5 删除文件 ........................................................................................................................... 445 12.6.6 文件名截取 ....................................................................................................................... 445 12.6.7 复制文件夹 ....................................................................................................................... 446 12.6.8 新增文件夹 ....................................................................................................................... 446 12.6.9 删除文件夹 ....................................................................................................................... 447 12.6.10 复制到剪贴板 ................................................................................................................. 447 12.6.11 剪贴板内容 ..................................................................................................................... 447 12.6.12 剪贴板存为文件 ............................................................................................................. 448 12.6.13 检测文件存在 ................................................................................................................. 448 12.6.14 检测文件夹存在 ............................................................................................................. 448 12.6.15 写注册表 ......................................................................................................................... 448 12.6.16 读注册表 ......................................................................................................................... 449 12.6.17 删除注册表项 ................................................................................................................. 449 12.6.18 写INI文件 ...................................................................................................................... 450 12.6.19 读INI文件 ...................................................................................................................... 450 12.6.20 取文件信息 ..................................................................................................................... 450 12.7“数据文件”函数组 ······································································ 450 12.7.1 数据源导出为文件 ........................................................................................................... 451 12.7.2 数据源复制到表 ............................................................................................................... 452 12.7.3 字段值导出为文件 ........................................................................................................... 452 12.7.4执行SQL语句 ................................................................................................................... 453 12.7.5 转换数据库 ....................................................................................................................... 455 12.7.6 转换数据库对话框 ........................................................................................................... 455 12.7.7 修复数据库 ....................................................................................................................... 455 12.7.8 检测数据库连通 ............................................................................................................... 456 12.7.9 检测数据库类型 ............................................................................................................... 456 12.7.10 资源上传 ......................................................................................................................... 456 12.7.11 资源下载 ......................................................................................................................... 457 12.7.12 资源删除 ......................................................................................................................... 457 12.7.13 导出系统表 ..................................................................................................................... 458 12.7.14 导入系统表 ..................................................................................................................... 458 12.8“权限管理”函数组 ······································································ 459 12.8.1 权限编辑器 ....................................................................................................................... 459 12.8.2 登录对话框 ....................................................................................................................... 461 12.8.3 取用户信息 ....................................................................................................................... 462 12.8.4 取当前用户数 ................................................................................................................... 462 12.8.5 日志浏览器 ....................................................................................................................... 463 12.8.6 修改密码对话框 ............................................................................................................... 464 12.8.7 登录检查站 ....................................................................................................................... 465 12.8.8 软件保护检测 ................................................................................................................... 466 12.9“系统信息”函数组 ······································································ 466 12.9.1 取本机IP地址 .................................................................................................................. 466 12.9.2 取本机网卡地址 ............................................................................................................... 466 12.9.3 取本机主硬盘号 ............................................................................................................... 467 12.9.4 取本机用户名 ................................................................................................................... 467 12.9.5 取本机计算机名 ............................................................................................................... 467 12.9.6 取项目文件信息 ............................................................................................................... 467 12.9.7 取宽度分辨率 ................................................................................................................... 467 12.9.8 取高度分辨率 ................................................................................................................... 468
10 《小土豆》自动编程系统-V2015 用户手册 12.9.9 取输入法信息 ................................................................................................................... 468 12.9.10 调用窗体 ......................................................................................................................... 468 12.10“系统操作”函数组 ······································································ 468 12.10.1 虚拟键盘操作 ................................................................................................................. 468 12.10.2 虚拟鼠标操作 ................................................................................................................. 469 12.10.3 虚拟鼠标位置 ................................................................................................................. 469 12.10.4 取鼠标左起点 ................................................................................................................. 470 12.10.5 取鼠标上起点 ................................................................................................................. 470 12.10.6 执行暂停 ......................................................................................................................... 470 12.10.7 读硬件端口 ..................................................................................................................... 470 12.10.8 写硬件端口 ..................................................................................................................... 470 12.11“其他功能”函数组 ······································································ 471 12.11.1 提示框 ............................................................................................................................. 471 12.11.2 提示对话框 ..................................................................................................................... 471 12.11.3 精灵式提示框 ................................................................................................................. 473 12.11.4 字体赋值 ......................................................................................................................... 474 12.11.5 颜色赋值 ......................................................................................................................... 474 12.11.6 取对象名 ......................................................................................................................... 474 12.11.7 检测按下键名 ................................................................................................................. 475 12.11.8 取按下键名 ..................................................................................................................... 475 12.11.9 取模块执行信息(暂未开放) ........................................................................................... 475 12.11.10 解析表达式 ................................................................................................................... 475 12.11.11 强制终止 ....................................................................................................................... 477 12.11.12 检测计算 ....................................................................................................................... 477 12.11.13调用窗体 ........................................................................................................................ 478 12.12 自定义函数原理 ········································································· 479 12.11.1 单行“变量函数”的构建原理 ..................................................................................... 479 12.11.2 多行“变量函数”的构建原理 ..................................................................................... 479