自定义了一个单据，在保存前做了校验，非作废的单据生效日期失效日期不能重叠。现在想在反作废的服务插件中也做相同检验。

代码如下：

import clr
clr.AddReference('System')
clr.AddReference('Kingdee.BOS')
clr.AddReference('Kingdee.BOS.Core')
#clr.AddReference('Kingdee.BOS.App')？？？
from System import *
from Kingdee.BOS import *
#from Kingdee.BOS.App.Data import *？？？
from Kingdee.BOS.Core import *
from Kingdee.BOS.Core.Validation import *
def OnPreparePropertys(e):
    e.FieldKeys.Add("FValiEndDate");
    e.FieldKeys.Add("FValiStartDate");
    e.FieldKeys.Add("FCustID");
    e.FieldKeys.Add("FOrgId");
def OnAddValidators(e):
    validator = CustomValidator();
    validator.EntityKey = "FBillHead";
    validator.AlwaysValidate = True;
    e.Validators.Add(validator);
class CustomValidator(AbstractValidator):
    def Validate(self, dataEntities, validateContext,ctx):
        for bill in dataEntities:
            billId= str(bill["Id"]);
            billNo= str(bill["BillNo"]);
            endDate=str(bill["ValiEndDate"]);
            startDate=str(bill["ValiStartDate"]);
            custID=str(bill["CustID"]["Id"]);
            orgID=str(bill["OrgId"]["Id"]);
            sql="""/*dialect*/SELECT FBILLNO FROM T_PQQB_STORAGEORDER WHERE FORGID = {0} AND FCUSTID = {1} AND FCANCELSTATUS = 'A' AND FVALISTARTDATE <= '{2}' AND FVALIENDDATE >= '{3}' AND FID != {4}""".format(orgID,custID,endDate,startDate,billId);
            if "A"=="A":
                info = ValidationErrorInfo("",billId, bill.DataEntityIndex,bill.RowIndex,billId,sql,"校验",ErrorLevel.Error);
                validateContext.AddError(None,info);

#            WrongFid=DBUtils.ExecuteScalar(this.Context,sql);
#            if WrongFid != None and WrongFid.Length > 0:
#                info = ValidationErrorInfo("",billId, bill.DataEntityIndex,bill.RowIndex,billId,WrongFid,"校验",ErrorLevel.Error);
#                validateContext.AddError(None,info);

直到这一步都是对的，输出的sql如图：

现在只差最后一步调用DBUtils，这一步引用会报错，见注释掉的部分，请问是哪里不对？附上源码和报错

invalid syntax

在 Microsoft.Scripting.Hosting.ErrorListenerProxySink.Add(SourceUnit sourceUnit, String message, SourceSpan span, Int32 errorCode, Severity severity)

在 IronPython.Compiler.Parser.ReportSyntaxError(Int32 start, Int32 end, String message, Int32 errorCode)

在 IronPython.Compiler.Parser.ParseRelativeModuleName()

在 IronPython.Compiler.Parser.ParseFromImportStmt()

在 IronPython.Compiler.Parser.ParseSimpleStmt()

在 IronPython.Compiler.Parser.ParseFileWorker(Boolean makeModule, Boolean returnValue)

在 IronPython.Compiler.Parser.ParseFile(Boolean makeModule, Boolean returnValue)

在 IronPython.Runtime.PythonContext.ParseAndBindAst(CompilerContext context)

在 IronPython.Runtime.PythonContext.CompilePythonCode(SourceUnit sourceUnit, CompilerOptions options, ErrorSink errorSink)

在 IronPython.Runtime.PythonContext.CompileSourceCode(SourceUnit sourceUnit, CompilerOptions options, ErrorSink errorSink)

在 Microsoft.Scripting.Hosting.ScriptSource.CompileInternal(CompilerOptions compilerOptions, ErrorListener errorListener)

在 Kingdee.BOS.DomainModelDesigner.PropertyEditor.frmPythonScriptEdit.GenerateCompiledPython()

在 Kingdee.BOS.DomainModelDesigner.PropertyEditor.frmPythonScriptEdit.InitializeScope()

在 Kingdee.BOS.DomainModelDesigner.PropertyEditor.frmPythonScriptEdit.ButtonItem_Click(Object sender, EventArgs e)

产品问题Python服务插件调用DBUtils报错

100 产品问题 Python服务插件调用DBUtils报错

恭喜您！

产品问题
Python服务插件调用DBUtils报错