1、用友TurboCRM打印模板制作講明V2.0變動記錄日期變更內(nèi)容操作人2009-6-25增加引用對象屬性的取值方法李鵬1、保存格式CRM6.0的打印模板文件保存格式為 *.xlsx 即Excel2007的默認(rèn)保存格式2、編寫格式打印模板能夠輸出CRM系統(tǒng)對象查看頁面的主表信息（包括表頭和子表）。表頭變量格式：#系統(tǒng)變量子表變量格式：#=系統(tǒng)變量如上圖所示，依照用戶實際需要配置模板的布局顯示，各字段所需變量可從數(shù)據(jù)庫中查詢，查詢語句見HYPERLINK l _4、查詢語句4、查詢語句。 在模板中，除了填寫系統(tǒng)變量獵取數(shù)據(jù)庫中信息以外，還能夠使用Excel自己的函數(shù)實現(xiàn)一些有用的功能，比如字段值的

2、運算，當(dāng)前日期等。在子表里，需要使用#=BEGIN 和 #=END 來括住子表信息，如圖示。#=BEGIN子表字段信息#=END3、引用對象的字段取值舉例講明：系統(tǒng)中創(chuàng)建了自定義對象“車輛治理”對象名是“car”，在訂單中創(chuàng)建了引用字段“車輛”字段名是“cheliang”并引用“車輛治理”對象。這時假如想在訂單的打印模板中打印車輛治理對象中的創(chuàng)建人屬性，變量寫法是：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.%本例中，找到的車輛創(chuàng)建人變量是 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 將此變量應(yīng)用到訂單的打印模板中就能夠打印出引用的車輛屬性。4、查詢語句由于系統(tǒng)會存在若干自定義字段，因此打印模板所需字段要在數(shù)據(jù)庫中查詢。-客戶字段select a.attr_name as 客戶字段,d.label as 中文標(biāo)簽 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 中文標(biāo)簽 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-聯(lián)系人字段select a.attr_name as 聯(lián)系人字段,d.label as 中文標(biāo)簽 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 中文標(biāo)簽 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 中文標(biāo)簽 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-競爭產(chǎn)品字段select a.attr_name as 競爭產(chǎn)品字段,d.label as 中文標(biāo)簽 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 中文標(biāo)簽 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 中文標(biāo)簽 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 中文標(biāo)簽 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 中文標(biāo)簽 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 中文標(biāo)簽 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 中文標(biāo)簽 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 中文標(biāo)簽 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 中文標(biāo)簽 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-預(yù)收字段select a.attr_name as 訂單字段,d.label as 中文標(biāo)簽 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 中文標(biāo)簽 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 中文標(biāo)簽 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 中文標(biāo)簽 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 中文標(biāo)簽 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-發(fā)票字段select a.attr_name as 發(fā)票字段,d.label as 中文標(biāo)簽 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-發(fā)票子表字段select a.attr_name as 發(fā)票子表字段,d.label as 中文標(biāo)簽 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-服務(wù)打算select a.attr_name as 服務(wù)打算字段,d.label as 中文標(biāo)簽 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-服務(wù)請求select a.attr_name as 服務(wù)請求字段,d.label as 中文標(biāo)簽 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