YunTongJackYunTask/Reportapi/新建文本文档.txt

import clr
clr.AddReference('System')
clr.AddReference('Kingdee.BOS')
clr.AddReference('Kingdee.BOS.Core')
clr.AddReference('Kingdee.BOS.App.Core')
clr.AddReference('Kingdee.BOS.App')
clr.AddReference('Kingdee.BOS.DataEntity')
clr.AddReference('Kingdee.BOS.Business.DynamicForm')
clr.AddReference("Kingdee.BOS.ServiceHelper")
import sys
from System import *
from System import Type
from System import Array
from System.Text import *
from System.Collections.Generic import *
from Kingdee.BOS.App.Data import *
from Kingdee.BOS.Core.DynamicForm.PlugIn import *
from Kingdee.BOS.Core.Metadata.EntityElement import *
from Kingdee.BOS.Core.Metadata import *
from Kingdee.BOS.Orm.DataEntity import *
from Kingdee.BOS.ServiceHelper import *
from Kingdee.BOS.Util import *
from Kingdee.BOS.Core.Util import *

def BarItemClick(e):
	if (e.BarItemKey == "YTKJ_chongzhi"):
		SelectRows = this.View.SelectedDataRows
		Rowidlist = []
		if(SelectRows==None):
			this.View.ShowMessage("请先选择数据行")
			return
		for item in SelectRows:
			Rowid = "'"+item["主键"].ToString()+"'"	
			Rowidlist.append(Rowid)
		sql ="""/*dialect*/ UPDATE SysWorkProcess SET FuncStatus = 0 WHERE ID IN ({0}) """.format(",".join(Rowidlist))
		#raise Exception(sql)
		res=DBUtils.Execute(this.Context, sql)
		if res>0:
			this.View.InvokeFormOperation("Refresh")
			this.View.ShowMessage("重置了"+res.ToString()+"条数据")