1 #引入clr运行库
 2 import clr
 3 clr.AddReference("Kingdee.BOS.Core")
 4 clr.AddReference("Kingdee.BOS.App")
 5 clr.AddReference("Kingdee.BOS")
 6 #添加对cloud插件开发的常用组件的引用
 7 from Kingdee.BOS.Core.Bill.PlugIn import *
 8 from Kingdee.BOS.Core.Bill.PlugIn.Args import *
 9 from Kingdee.BOS.Core.DynamicForm.PlugIn.Args import *
10 from Kingdee.BOS.App.Data import *                
11 def AfterBarItemClick(e):
12         #判断点击审核按钮（菜单和列表一致）
13         if (e.BarItemKey=="tbSplitApprove" or e.BarItemKey=="tbApprove"):
14                 #执行MSSQL语句
15                 DBUtils.Execute(this.Context, "/*dialect*/update a set a.AA=b.AA from (select id,AA from TableA)a,(select id,AA from TableB)b where a.id=b.id");
16                 #执行MSSQL存储过程
17                 DBUtils.Execute(this.Context, "/*dialect*/exec 存储过程名字");
18                 #this.View.ShowMessage("项目更新成功！");