import clr
#添加对cloud插件开发的常用组件的引用
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.DataEntity')
clr.AddReference('Kingdee.BOS.Contracts')
clr.AddReference('Kingdee.BOS.ServiceHelper')
clr.AddReference('Newtonsoft.Json')
#导入cloud基础库中的常用实体对象（分命名空间导入，不会递归导入）
from Kingdee.BOS import *
from Kingdee.BOS.Core import *
from Kingdee.BOS.Contracts import *
from Kingdee.BOS.Orm.DataEntity import *
from Kingdee.BOS.DataEntity import *
from Kingdee.BOS.Core.Bill import *
from Kingdee.BOS.Core.DynamicForm import *
from Kingdee.BOS.Core.DynamicForm.PlugIn import *
from Kingdee.BOS.Core.DynamicForm.PlugIn.ControlModel 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 *
from Newtonsoft.Json import JsonConvert
from Newtonsoft.Json.Linq import *
from Kingdee.BOS.Log import *
from Kingdee.BOS.Resource import *
from Kingdee.BOS.Core.Validation import *
def OnPreparePropertys (e):
    e.FieldKeys.Add("FID")
    e.FieldKeys.Add("FBILLTYPEID")
    e.FieldKeys.Add("FORDERNUMBER")
    e.FieldKeys.Add("FSOURCETYPE")
    e.FieldKeys.Add("FORDERENTRYID")
    e.FieldKeys.Add("FSetAccountType")
    e.FieldKeys.Add("AP_PAYABLEENTRY")
def OnAddValidators(e):
    extMoProducTypeValidator=ExtMoProducTypeValidator()
    extMoProducTypeValidator.EntityKey="FEntityDetail"
    extMoProducTypeValidator.TimingPointString=",Save"
    e.Validators.Add(extMoProducTypeValidator)
class ExtMoProducTypeValidator(AbstractValidator):
    def Validate(self,dataEntities,validateContext,ctx):
        if len(dataEntities)==0:
            return
        for bill in dataEntities:
            billid = int(bill["Id"])
            #entryData = bill.DataEntity["AP_PAYABLEENTRY"]
            entryData = bill["AP_PAYABLEENTRY"]
            ordernumber = str(bill["FORDERNUMBER"])
            orderentryid = int(bill["FOrderEntryID"])
            sourcetype = str(bill["FSOURCETYPE"])
            if sourcetype == 'STK_InStock':
                sqlmrb = ("/*dialect*/select count(DIStinct(FENTRYID)) from T_PUR_MRBENTRY where FORDERNO={0} and FPOORDERENTRYID={1}").format(ordernumber,orderentryid)
                #returnvalue = DBUtils.Execute(this.Context,sqlmrb).Tables[0]
                returnvalue = DBUntils.ExecuteDynamicObject(ctx,sqlmrb)
                if returnvalue is not None and len(returnvalue)>0:
                        sqlfinap = ("/*dialect*/select abs(isnull(sum(FPRICEQTY),0)) from T_AP_PAYABLEENTRY where FORDERNUMBER='{0}' and FORDERENTRYID={1} and FROOTSOURCETYPE='PUR_MRB'").format(ordernumber,orderentryid)
                        dy = DBUntils.ExecuteDynamicObject(this.Context,sqlfinap)
                        if dy is not None and len(dy)>0:
                            pass
                        else:
                            errorInfo=ValidationErrorInfo(" ",billId,bill.DataEntityIndex,bill.RowIndex,billId,"存在未生成财务应付的退料单，不允许保存","",ErrorLevel.Error)
                            validateContext.AddError(None,errorInfo)
                else:
                    pass

老师，我改成这个以后，提示我：global name 'DBUntils' is not defined ；但是DBUntils是有导入的呀

产品问题python脚本遍历单据提示：iteration over non-sequence of type NoneType

20 产品问题 python脚本遍历单据提示：iteration over non-sequence of type NoneType

恭喜您！

产品问题
python脚本遍历单据提示：iteration over non-sequence of type NoneType