《《精编》用友TurboCRM打印模板制作说明》由会员分享，可在线阅读，更多相关《《精编》用友TurboCRM打印模板制作说明（9页珍藏版）》请在金锄头文库上搜索。
1、用友TurboCRM打印模板制作说明V2.0变动记录日期变更内容操作人2009-6-25增加引用对象属性的取值方法李鹏1、保存格式CRM6.0的打印模板文件保存格式为 *.xlsx 即Excel2007的默认保存格式2、编写格式打印模板可以输出CRM系统对象查看页面的主表信息（包括表头和子表）。表头变量格式：#系统变量子表变量格式：#=系统变量如上图所示，根据用户实际需要配置模板的布局显示，各字段所需变量可从数据库中查询，查询语句见4、查询语句。 在模板中，除了填写系统变量获取数据库中信息以外，还可以使用Excel自己的函数实现一些实用的功能，比如字段值的运算，当前日期等。在子表里，需要使用#
2、=BEGIN 和 #=END 来括住子表信息，如图示。#=BEGIN子表字段信息#=END3、引用对象的字段取值举例说明：系统中创建了自定义对象“车辆管理”对象名是“car”，在订单中创建了引用字段“车辆”字段名是“cheliang”并引用“车辆管理”对象。这时如果想在订单的打印模板中打印车辆管理对象中的创建人属性，变量写法是：Contract.cheliang. CreatedBy说明：1、使用查询语句先找出车辆管理对象的属性名（本例中是“car”根据实际情况指定对象名）select * from dd_dict_str where org_id = 1 and lang_id = 2 an
3、d not label like %ID and dict_name like Car.%本例中，找到的车辆创建人变量是 Car. CreatedBy2、使用查询语句找出订单中“车辆”的属性名select * from dd_dict_str where org_id = 1 and not label like %ID and lang_id = 2 and dict_name like contract.%本例中，找到的名称是 Contract.cheliang3、把两次查询得到的名称拼在一起，如下Contract.cheliang. CreatedBy 将此变量应用到订单的打印模板中就可
4、以打印出引用的车辆属性。4、查询语句由于系统会存在若干自定义字段，因此打印模板所需字段要在数据库中查询。-客户字段select a.attr_name as 客户字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id = 1 and d.org_id = 1and d.lang_id = 2and a.attr_name like account.%and not a.attr_name like account.%id-线索字段selec
5、t a.attr_name as 线索字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id = 1 and d.org_id = 1and d.lang_id = 2and a.attr_name like lead.%and not a.attr_name like lead.%id-联系人字段select a.attr_name as 联系人字段,d.label as 中文标签 from dd_attribute ainner joi
6、n dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id = 1 and d.org_id = 1and d.lang_id = 2and a.attr_name like contact.%and not a.attr_name like contact.%id-市场活动字段select a.attr_name as 市场活动字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id
7、 = 1 and d.org_id = 1and d.lang_id = 2and a.attr_name like campaign.%and not a.attr_name like campaign.%id-竞争对手字段select a.attr_name as 竞争对手字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id = 1 and d.org_id = 1and d.lang_id = 2and a.attr_name li
8、ke Competitor.%and not a.attr_name like Competitor%.%id-竞争产品字段select a.attr_name as 竞争产品字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id = 1 and d.org_id = 1and d.lang_id = 2and a.attr_name like CmptProd.%and not a.attr_name like CmptProd%.%id
9、-竞争订单字段select a.attr_name as 竞争订单字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id = 1 and d.org_id = 1and d.lang_id = 2and a.attr_name like CmptCntrt.%and not a.attr_name like CmptCntrt%.%id-竞争订单子表字段select a.attr_name as 竞争订单子表字段,d.label as 中文
10、标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id = 1 and d.org_id = 1and d.lang_id = 2and a.attr_name like CmptCntrtitem.%and not a.attr_name like CmptCntrtitem%.%id-销售机会字段select a.attr_name as 销售机会字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str
11、d on a.attr_name = d.dict_namewhere a.org_id = 1 and d.org_id = 1and d.lang_id = 2and a.attr_name like opportunity.%and not a.attr_name like opportunity%.%id-销售机会子表字段select a.attr_name as 销售机会子表字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id
12、= 1 and d.org_id = 1and d.lang_id = 2and a.attr_name like opportunityitem.%and not a.attr_name like opportunityitem%.%id-报价单主表字段select a.attr_name as 报价单字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id = 1 and d.org_id = 1and d.lang_id = 2and
13、a.attr_name like quote.%and not a.attr_name like quote.%id-报价单子表字段select a.attr_name as 报价单子表字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id = 1 and d.org_id = 1and d.lang_id = 2and a.attr_name like quoteitem.%and not a.attr_name like quoteit
14、em.%id-订单主表字段select a.attr_name as 订单字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id = 1 and d.org_id = 1and d.lang_id = 2and a.attr_name like contract.%and not a.attr_name like contract.%id-订单子表字段select a.attr_name as 订单字段,d.label as 中文标签 fr
15、om dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id = 1 and d.org_id = 1and d.lang_id = 2and a.attr_name like contractitem.%and not a.attr_name like contractitem.%id-预收字段select a.attr_name as 订单字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere a.org_id = 1 and d.org_id = 1and d.lang_id = 2and
