python与存储过程的调用

栏目:云星空知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

python与存储过程的调用

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)    


python与存储过程的调用

import clrclr.AddReference("mscorlib")clr.AddReference("Kingdee.BOS")clr.AddReference("Kingdee.BOS.Core")clr.AddReference("Kingdee...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息