K3Cloud Python套打插件开发记录
2021-06-18 17:05
标签：this core objects text tao eid obj color entry 背景 费用报销单分录的报销未付款金额，客户需要打印出来一个汇总，不显示单据体。 1，拖一个金额字段冗余在单据头。 2，套打里面吧这个字段设置到对应的打印位置。 3，挂插件 4，完成。 K3Cloud Python套打插件开发记录 标签：this core objects text tao eid obj color entry 原文地址：https://www.cnblogs.com/jlz-s/p/9706417.html 1 import clr
2 clr.AddReference("System")
3 clr.AddReference("Kingdee.BOS.Core")
4 clr.AddReference("Kingdee.BOS.ServiceHelper")
5 from Kingdee.BOS import *
6 from Kingdee.BOS.Core import *
7 from Kingdee.BOS.ServiceHelper import *
8 from System import *
9
10 def OnPrepareNotePrintData(e):
11 if e.DataSourceId == "FBillHead":
12 qureyObjs = e.DataObjects
13 sql = "select sum(FREIMBNOTPAYAMOUNT) as FREIMBNOTPAYAMOUNT from t_ER_ExpenseReimbEntry where fid = " + str(qureyObjs[0][0])
14 dyc = DBServiceHelper.ExecuteDynamicObject(this.Context, sql)
15 if dyc != None:
16 Amount = dyc[0][0]
17 qureyObjs[0]["F_PAEZ_Amount"] = Amount;