KBXFormStepByStepv02.docx

1、KBXFormStepByStepv02XForm开发范例技术文档BCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP

2、 ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP Co

3、nceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP Conce

4、ptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptB

5、CP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP

6、ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP Con

7、ceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP Concep

8、tBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBC

9、P ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP C

10、onceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP Conc

11、eptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP Concept

12、BCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP

13、 ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP Co

14、nceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP Conce

15、ptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptB

16、CP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP

17、ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP Con

18、ceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP Concep

19、tBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptBCP ConceptXForm开发范例技术文档1 目标 51.1 目标 51.2 环境 51.3 前提条件 52

20、 范例需求 62.1 功能说明 62.2 功能数据 62.3 功能操作 63 开发步骤 93.1 生成数据库表 93.2 开发基础配置 103.2.1 建立SOAP节点和连接器 103.2.2 生成相关Method 133.2.3 其它外部文件 193.3 基本设计开发 193.3.1 生成基础布局 193.3.2 页面布局定制 233.3.2.1 定制工具条 243.3.2.2 定制表单样式 273.3.2.3 定制表单列 283.3.2.4 定制表单布局 293.3.2.5 定制控制条 323.3.2.6 定制导航条 333.3.3 静态页面预览 333.4 数据展现定制 353.4.1

21、设置展现样式 353.4.2 设置动态关联数据显示 383.4.3 设置静态关联数据显示 463.5 添加数据操作 473.5.1 增加 483.5.1.1 界面展现 483.5.1.2 业务逻辑 503.5.1.3 主界面关联 533.5.1.4 发布 553.5.1.5 动态页面预览 553.5.2 编辑 573.5.3 删除 573.5.4 查询 573.6 最终结果 574 附录 574.1 其它相关表定义 574.1.1 用户信息表xu_user 574.2 表单相关定义 584.2.1 “产品定义管理”表单 584.2.2 “新建产品定义”表单 584.3 其它相关扩展脚本定义 5

22、94.3.1 common.js 594.3.2 GetUnicodeStrCapital.js 594.4 其它相关方法定义 594.4.1 Getxj_cpCountBycp_code 594.4.2 Getxj_cpCountBycp_cname 61Version noDateAuthorReviewed ByDescription0.12005-6-26Kun DaiGloria1-3.30.22005-6-28Kun DaiGloria3.4 3.51 目标1.1 目标针对常见的基于数据库表的增删改查的需求，提供XForm实现的详细步骤。1.2 环境Windows XP Profe

23、ssional, SP1, IIS 6.0Cordys 4.2 C1 Build 170 and above, with XForm2Microsoft SQL Server 20001.3 前提条件要想通过本文档学习XForm的开发，必须具备以下条件1. 已经创建了相关的组织（或使用System组织），具有Developer权限和Studio相关权限，并对Studio进行了正确的初始化2. 了解如何在BCP中创建菜单3. 大致了解如何创建Method4. 大致了解XForm的相关概念，如Model、Form、Grid等5. 具备简单的JScript开发能力6. 相关的独立脚本（如GetUni

24、codeStrCapital.js和common.js）和图片已开发完成7. 其它相关数据库表（如xu_user表）已经开发完成2 范例需求基础数据维护-产品定义2.1 功能说明定义销售的煤炭产品2.2 功能数据对象名称产品定义所属主题基础数据管理引用频度启用初高，启用后低数据增长率启用初高，启用后低数据项名称类型最小宽度可否为空取值范围来源去向编码字符2否序号自动生成名称字符20否录入拼音码字符20否录入备注字符60否录入录入人员字符6否录入/参照状态字符1否0启用1停用录入2.3 功能操作1) 用户界面 增加 修改 删除 帮助 退出序号编码名称拼音码是否停用录入人员备注 浏览界面 编辑界面

25、 编码： 名称：拼音码:是否停用： 录入人员：备注: 返回保存2) 输入列表及合法性输入项目名称输入方法合法性检查编码自动生成1、按序号自动增加2、编码要唯一名称录入名称要唯一拼音码录入备注录入录入人员录入/参照状态录入在0启用1停用中选择3) 操作说明进入【产品定义】，首先进入浏览界面，显示已经保存的产品信息。（1）增加进入编辑界面（2）修改 进入编辑界面（3）删除提示用户是否确认删除当前所选行的产品记录，并检验该条数据是否在其他业务数据中被引用，在用户确认删除以及未被其他业务数据引用时进行删除操作，并提示用户删除是否成功，刷新主界面的数据。进入编辑界面后，若是增加记录则是否停用默认为否。用

26、户录入产品名称后系统自动依据名称转化成拼音码，拼音码允许用户修改。（1）保存较验产品名称是否填写，产品名称是否唯一，产品编码是否唯一，进行保存操作，提示用户保存是否成功（2）返回 退出编辑界面，返回到主界面，并根据数据是否更新（包括增加或修改）对主界面的数据进行刷新操作。4) 业务规则/算法无5) 输出列表、输出格式及合法性6) 相关要求无3 开发步骤3.1 生成数据库表根据需求，建立相关表xj_cp，数据库表设计的建表脚本如下（默认SQL Server数据库名为mtxs_pm）if exists (select * from dbo.sysobjects where id = object_

27、id(Ndbo.xj_cp) and OBJECTPROPERTY(id, NIsUserTable) = 1)drop table dbo.xj_cpGOCREATE TABLE dbo.xj_cp ( cp_id numeric(19, 0) IDENTITY (1, 1) NOT NULL , cpdl_id numeric(18, 0) NULL , cp_code char (2) COLLATE Chinese_PRC_CI_AS NOT NULL , cp_cname char (20) COLLATE Chinese_PRC_CI_AS NOT NULL , cp_pym char (20) COLLATE Chinese_PRC_CI_AS NULL , cp_zl varchar (100) COLLATE Chinese_PRC_CI_AS NULL , unit_code char (20) COLLATE Chinese_PRC_CI_AS NULL , cp_avlrate decimal(18, 2) NULL , cp_rtnrate decimal(18, 2