#使用技巧#Python 更新付款单备注

业务需求是实现 在复核人网银复核时候，便于核对对应的凭证号，希望付款单备注（也就是提交网银摘要），包含备注+凭证期间+凭证号 举例 差旅费12-1111。从社区其他python学习贴获取到基本模板，修改而来。只是基本实现需求，未做更多条件判定。

实现代码如下：

#【Python】【表单插件】执行SQL

import clr

clr.AddReference("mscorlib")

clr.AddReference("Kingdee.BOS")

clr.AddReference("Kingdee.BOS.Core")

clr.AddReference("Kingdee.BOS.App")

clr.AddReference('System')

clr.AddReference("System.Data")

clr.AddReference('Kingdee.BOS.ServiceHelper')

clr.AddReference('Kingdee.BOS.DataEntity')

from Kingdee.BOS import *

from Kingdee.BOS.Core import *

from Kingdee.BOS.Core.Bill import *

from Kingdee.BOS.App.Data import *

from Kingdee.BOS.Core.DynamicForm.PlugIn import *

from Kingdee.BOS.Core.DynamicForm.PlugIn.Args import *

from Kingdee.BOS.Util import *

from Kingdee.BOS.Core.DynamicForm.PlugIn.ControlModel import *

from Kingdee.BOS.Core.List.PlugIn import *

from Kingdee.BOS.Core.SqlBuilder import *

from Kingdee.BOS.Core.Metadata import *

from System import *

from System.Collections.Generic import *

from System.Data import *

from Kingdee.BOS.Core.Bill import * 

from Kingdee.BOS.Core.Bill.PlugIn import *

from Kingdee.BOS.App.Data import *

from Kingdee.BOS.ServiceHelper import *

from System.Collections.Generic import List

def BarItemClick(e):

btnKey = e.BarItemKey.ToUpper();

if(btnKey=="TBSQL"):#列表自定义菜单按钮大写

selectedRowsInfo=this.ListView.SelectedRowsInfo;#列表勾选的数据集

datas=this.ListModel.GetData(selectedRowsInfo);#这句代码似乎选中的数据行超过1000多行，会报错，请做处理！

listEntryId=List[str]();

for row in selectedRowsInfo:

selectEntryId=str(row.EntryPrimaryKeyValue);

entityKey=str(row.EntryEntityKey);

        #列表一定要显示出需要更新的明细字段所在的单据体，不然无法获取明细行ID

if(selectEntryId=="" or selectEntryId==None or entityKey<>"FPAYBILLENTRY"):

this.View.ShowWarnningMessage("请在过滤里面显示单据体[FEntity]!");

return;

listEntryId.Add(selectEntryId);

rowIndexs = str.Join(',', listEntryId.ToArray());#将获取到的明细行ID构造成逗号隔开的字符串，

#this.View.ShowMessage("当前选中行：" + rowIndexs);

sql =( "/*dialect*/UPDATE t4 set t4.fcomment= t4.fcomment+convert (varchar ,t2.fperiod)+'-'+convert(varchar,t2.FVOUCHERGROUPNO) from  t_bas_voucher t1  left join  t_ap_paybill t3 on t1.FSOURCEBILLNO=t3.fbillno  left join  t_ap_paybillentry t4 on t3.fid=t4.fid  left join  t_gl_voucher t2 on t1.FGLVOUCHERID=t2.FVOUCHERID  where t4.fentryid in ({0})").format(rowIndexs);

#x=DBServiceHelper.Execute(this.Context,Sql);

# 执行SQL并返回受影响行数

returnValue = DBUtils.Execute(this.Context, sql);

msg = "受影响行数：" + returnValue.ToString()

this.View.ShowMessage(msg)

return