用友TurboCRM打印范本制作说明

1、用友TurboCRM打印模板制作讲明V2.0变动记录日期变更内容操作人2009-6-25增加引用对象属性的取值方法李鹏1、保存格式CRM6.0的打印模板文件保存格式为 *.xlsx 即Excel2007的默认保存格式2、编写格式打印模板能够输出CRM系统对象查看页面的主表信息（包括表头和子表）。表头变量格式：#系统变量子表变量格式：#=系统变量如上图所示，依照用户实际需要配置模板的布局显示，各字段所需变量可从数据库中查询，查询语句见HYPERLINK l _4、查询语句4、查询语句。 在模板中，除了填写系统变量猎取数据库中信息以外，还能够使用Excel自己的函数实现一些有用的功能，比如字段值的

2、运算，当前日期等。在子表里，需要使用#=BEGIN 和 #=END 来括住子表信息，如图示。#=BEGIN子表字段信息#=END3、引用对象的字段取值举例讲明：系统中创建了自定义对象“车辆治理”对象名是“car”，在订单中创建了引用字段“车辆”字段名是“cheliang”并引用“车辆治理”对象。这时假如想在订单的打印模板中打印车辆治理对象中的创建人属性，变量写法是：Contract.cheliang. CreatedBy讲明：1、使用查询语句先找出车辆治理对象的属性名（本例中是“car”依照实际情况指定对象名）select * from dd_dict_str where org_id = 1

3、 and lang_id = 2 and 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. CreatedB

4、y 将此变量应用到订单的打印模板中就能够打印出引用的车辆属性。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 _id = 1 and _id = 1and d.lang_id = 2and a.attr_name like account.%and not a.attr_name like ac

5、count.%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 _id = 1 and _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_a

6、ttribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere _id = 1 and _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

7、_namewhere _id = 1 and _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 _id = 1 and _id = 1and d.lang_id =

8、2and a.attr_name like 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 _id = 1 and _id = 1and d.lang_id = 2and a.attr_name like CmptProd.%and not a.attr_name

9、 like CmptProd%.%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 _id = 1 and _id = 1and d.lang_id = 2and a.attr_name like CmptCntrt.%and not a.attr_name like CmptCntrt%.%id-竞争订单子表字段select a.attr_name as 竞争订

10、单子表字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere _id = 1 and _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 ainne

11、r join dd_dict_str d on a.attr_name = d.dict_namewhere _id = 1 and _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_

12、namewhere _id = 1 and _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 _id = 1 and _id = 1an

13、d d.lang_id = 2and 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 _id = 1 and _id = 1and d.lang_id = 2and a.attr_name like quoteitem.%and not a.att

14、r_name like quoteitem.%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 _id = 1 and _id = 1and d.lang_id = 2and a.attr_name like contract.%and not a.attr_name like contract.%id-订单子表字段select a.attr_name as 订单字段

15、,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere _id = 1 and _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_di

16、ct_str d on a.attr_name = d.dict_namewhere _id = 1 and _id = 1and d.lang_id = 2and a.attr_name like beforetake.%and not a.attr_name like beforetake.%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 _id = 1

17、and _id = 1and d.lang_id = 2and a.attr_name like payment.%and not a.attr_name like payment.%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 _id = 1 and _id = 1and d.lang_id = 2and a.attr_name like paym

18、entitem.%and not a.attr_name like paymentitem.%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 _id = 1 and _id = 1and d.lang_id = 2and a.attr_name like inventory.%and not a.attr_name like inventory.%id-交付子表字段se

19、lect a.attr_name as 交付子表字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere _id = 1 and _id = 1and d.lang_id = 2and a.attr_name like inventoryitem.%and not a.attr_name like inventoryitem.%id-发票字段select a.attr_name as 发票字段,d.label as 中文标签 from dd

20、_attribute ainner join dd_dict_str d on a.attr_name = d.dict_namewhere _id = 1 and _id = 1and d.lang_id = 2and a.attr_name like invoice.%and not a.attr_name like invoice.%id-发票子表字段select a.attr_name as 发票子表字段,d.label as 中文标签 from dd_attribute ainner join dd_dict_str d on a.attr_name = d.di

21、ct_namewhere _id = 1 and _id = 1and d.lang_id = 2and a.attr_name like invoiceitem.%and not a.attr_name like invoiceitem.%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 _id = 1 and _id = 1and d.lang

22、_id = 2and a.attr_name like serviceplan.%and not a.attr_name like serviceplan.%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 _id = 1 and _id = 1and d.lang_id = 2and a.attr_name like servicerequest.%and not a.attr_name like servicerequest.%i