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)