金蝶云星空,点击禁用和反禁用时候,触发服务插件,调用存储过程操作后台数据

点击禁用和反禁用时候,触发服务插件

clr.AddReference('System')
clr.AddReference('System.Data')
clr.AddReference('Kingdee.BOS')
clr.AddReference('Kingdee.BOS.Core')
clr.AddReference('Kingdee.BOS.App')
clr.AddReference('Kingdee.BOS.ServiceHelper')

from Kingdee.BOS import *
from Kingdee.BOS.Core import *
from Kingdee.BOS.Core.Bill import *
from Kingdee.BOS.Core.DynamicForm.PlugIn import *
from Kingdee.BOS.Core.DynamicForm.PlugIn.ControlModel import *
from Kingdee.BOS.Core.List 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.Data import *
from Kingdee.BOS.App.Data import *
from System.Collections.Generic import List
from Kingdee.BOS.ServiceHelper import *

def EndOperationTransaction(e):

for billObj in e.DataEntitys:
FNumber = str(billObj["Number"]);
sql = "exec XXXX_DemandALUpdateStatus '"+FNumber+"'";
DBUtils.ExecuteScalar(this.Context,sql,None);

posted @ 2026-06-29 08:28  虚拟过客之IT老男人  阅读(14)  评论(0)    收藏  举报