用Python取当前物料最新的BOM

import clr
clr.AddReference('Kingdee.BOS.App')
from Kingdee.BOS.App.Data import *
    

def DataChanged(e):

    if e.Key=="FMaterialId":
        try:

            ID =str( this.Model.GetValue("FMaterialId",e.Row).Id) #取当前物料ID，需考虑清空字段的情况
        except:
            this.Model.SetValue('BOMID','',e.Row)
            return
                            
        sql = """  select     top 1 FNUMBER from T_ENG_BOM where  FDOCUMENTSTATUS='C' and FMATERIALID=%s 
                order by FNUMBER desc"""%ID
            
        Rdata = DBUtils.ExecuteEnumerable(this.Context,sql)        
        this.Model.SetValue('BOMID','',e.Row)
        
        for i in Rdata:
            this.Model.SetValue('BOMID',i['FNUMBER'],e.Row)