Python按钮插件调用存储过程原创
金蝶云社区-小飞虾
小飞虾
131人赞赏了该文章 1,044次浏览 未经作者许可,禁止转载编辑于2024年05月19日 08:27:21

import clr
clr.AddReference("mscorlib")
clr.AddReference("Kingdee.BOS")
clr.AddReference("Kingdee.BOS.Core")
clr.AddReference("Kingdee.BOS.App")
clr.AddReference("System.Data")
from Kingdee.BOS 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 System import *
from System.Collections.Generic import *
from System.Data import *

def AfterExecuteOperationTransaction(e):
    for billObj in e.DataEntitys:
        billId=billObj["Id"];
        billNo=billObj["BillNo"];
        
    #存储过程名称

    procedureName = "P_Sub_OrderToOA"
    sqlParameterList = List[SqlParam]()


    #存储过程参数

    sqlParameterList.Add(SqlParam("@FBillNo", KDDbType.AnsiString, billNo))
    DBUtils.ExecuteStoreProcedure(this.Context, procedureName, sqlParameterList)    
    

    #显示结果信息    
    #result=OperateResult()
    #result.SuccessStatus=True
    #result.PKValue = billId
    #result.Number = billNo
    #result.Message = "通知OA发起对应流程,单据号:"+billNo
    #this.OperationResult.OperateResult.Add(result)

赞 131