用友U9全部 课程讲解资料V3.0

（结合视频教学资料使用）

1.UBF路径配置

（视频160）

2.解决方案建立规则

目录层次：解决方案>>项目>>组件

同一模块，所有BE、BP、SV项目放在（同）一个解决方案内

同一模块，所有BE，只用一个项目，即只生成一个BE的DLL

同一模块，所有BP、SV，只用一个项目，即只生成一个BP、SV的DLL

同一模块，可以所有枚举放在（同）一个BE组件内

同一模块，所有UI项目放在一个解决方案内

一个档案或单据UI，及其相关的查找参照UI，用（同）一个项目，即一个档案或单据，生成一个UI的DLL 同一模块，所有列表UI，用（同）一个项目

同一模块，所有参照UI，用（同）一个项目

3.命名规范

配件名：UFIDA.U9.Cust.XM（地区）.HXPP（公司）.EX（模块）BE

表名：Cust_XM（地区）_HXPP（公司）_EX（模块）_XXXX

4.档案开发需求

（视频170，180）

考核模块（EX）>>科目（Subject）

名称显示名称类型备注

Org 组织组织机构业务主键，不可空

Code 编码字符串业务主键，不可空，长50

Name 科目名称字符串不可空，长200

SubjectType 科目类型科目类型枚举枚举值：辅料、主要材料、产值、费用，对

账差异，营销可比利润，调节项，其他收入，

税后利润，考核税前利润

Effective 状态状态

Memo 备注字符串长500

DescFlexField 扩展字段实体扩展字段集合

5.BE Code与Model对比

6.组件、类实体、属性关系查询（SQL语句）

select a. Name as ComponentName ,at. DisplayName as ComponentName_CN,a. AssemblyName,a .Kind

,b. Name as ClassName , bt. DisplayName as ClassName_CN,b. FullName,b .Discriminator

,c. Name as AttributeName ,ct. DisplayName as AttributeName_CN

from UBF_MD_Component a

left outer join UBF_MD_Component_Trl at on a. Local_ID=at .Local_ID and at.SysMLFlag= 'zh-cn'

left outer join UBF_MD_Class b on a. ID=b .MD_Component_ID

left outer join UBF_MD_Class_Trl bt on b. Local_ID=bt .Local_ID and bt.SysMLFlag= 'zh-cn'

left outer join UBF_MD_Attribute c on b. ID=c .MD_Class_ID

left outer join UBF_MD_Attribute_Trl ct on c. Local_ID=ct .Local_ID and ct.SysMLFlag= 'zh-cn'

where (1 =1)

and bt. DisplayName='科目'

7.UI Code与Model对比

8.UIForm、Part、Page的关系查询（SQL语句）

select at .DisplayName as UIFormDisplayName , a .name as UIFormName ,c. name as PageName

,a. uid as [UID(FormID)], b.PageCode

,a. uri as [PartID(UIFormURI)], c.uri as PageURI

,a. AssemblyName , a.ClassName

,a. Width,a .Height, as ApplicationName

from ubf_md_uiform a

left outer join ubf_assemble_part b on a.uid =b. component

left outer join ubf_assemble_page c on b.page =c. id

left outer join base_application_trl dt on c.application =dt. id and dt. sysmlflag='zh-cn'

left outer join ubf_md_uiform_trl at on a.id =at. id and at. sysmlflag='zh-cn'

where (1 =1)

and at.DisplayName='科目'

9.同步枚举脚本

以补丁包方式更新/安装，则不需要下面的脚本，因为be的bulk中会处理；

delete from ubf_sys_extenumtype

delete from ubf_sys_extenumtype_trl

delete from ubf_sys_extenumvalue

delete from ubf_sys_extenumvalue_trl

GO

insert into ubf_sys_extenumtype select local_id as id,'20060612' ,'u9zhangheng', '20060612','u9zhangheng' ,0, fullname as code, isextend,id as uid,0 as IsRefView from ubf_md_class where classtype=3

insert into ubf_sys_extenumtype_trl select a .local_id as id ,'zh-CN', b.[displayname] as [name],b .[Description] from ubf_md_class a left join ubf_RES_resourcevalue b on cast( a.[iD] as nvarchar(255 )) = b. resourcename where classtype =3 insert into ubf_sys_extenumvalue select a .local_id as id,'20060612' ,'u9zhangheng', '20060612','u9zhangheng' ,0, a.[Local_Class_ID] as ExtEnumType , a.[name] as code,a .defaultvalue as evalue ,issystem, md_class_id as ExtEnumTypeUID from ubf_md_attribute as a inner join ubf_md_class as b on a. md_class_id=b .id where classtype =3