③秘密信息严禁泄露importclr#添加对cloud插件开发的常用组件的引用clr.AddReference('Kingdee.BOS')clr.AddReference('Kingdee.BOS.Core')clr.AddReference('Kingdee.BOS.App')fromKingdee.BOS.App.Dataimport*fromSystemimport*defOnPrepareNotePrintData(e):ife.DataSourceId.Equals("FEntity",StringComparison.OrdinalIgnoreCase):fn0='';forpropine.DataObjects[1].DynamicObjectType.Properties:if(prop.Name=='FText'):fn0=prop.Namebreak;if(fn0==''):#如果套打模板没有找到现金流量字段，则不继续执行return;id0=e.DataObjects[0]["FVOUCHERID"]sql='selecta.FVCHENTRYID,a.FVCHOPPOENTRYID,d.FNUMBERFITEMNUMBER,b.FNAMEFITEMNAME,e.FNUMBERFSUBITEMNUMBER,c.FNAMEFSUBITEMNAME,a.FAMOUNTFOR,a.FAMOUNTfromT_GL_CASHFLOWBALa'sql+='leftjoinT_GL_CASHFLOW_Lbonb.fid=a.FITEMIDandb.FLOCALEID=2052'sql+='leftjoinT_GL_CASHFLOW_Lconc.fid=a.FSUBITEMIDandc.FLOCALEID=2052'sql+='leftjoinT_GL_CASHFLOWdond.fid=a.FITEMID'sql+='leftjoinT_GL_CASHFLOWeone.fid=a.FSUBITEMID'sql+='whereFVOUCHERID=('+str(id0)+')'#this.View.ShowErrMessage(sql)cf=DBUtils.ExecuteDynamicObject(this.Context,sql)forobjine.DataObjects:eid0=obj["FEntryID"]strcf0=''foriinrange(0,len(cf)):if(cf[i]["FVCHOPPOENTRYID"]==eid0):if(strcf0<>''):strcf0+=chr(13)if(notcf[i]["FITEMNUMBER"]isNone):strcf0+='主表项目：'+cf[i]["FITEMNUMBER"]+'-'+cf[i]["FITEMNAME"]if(notcf[i]["FSUBITEMNAME"]isNone):strcf0+='附表项目：'+cf[i]["FSUBITEMNUMBER"]+'-'+cf[i]1/2③秘密信息严禁泄露["FSUBITEMNAME"]strcf0+='金额：'+str(round(cf[i]["FAMOUNT"],2))obj["FText"]=strcf02/2
