源代码中不存在提前定义的内容

import clr

#添加对cloud插件开发的常用组件的引用

clr.AddReference("System")

clr.AddReference("System.Core")

clr.AddReference("Kingdee.BOS")

clr.AddReference("Kingdee.BOS.Core")

from Kingdee.BOS import *

from Kingdee.BOS.Core import *

from System import

def AfterDoOperation(e):

billObj = this.View.Model.DataObject

billNo=billObj["BillNo"]

confirmdate=billObj["F_GBKJ_DATE2"]

if e.Operation.Operation.upper() == "Save" and e.OperationResult != None and confirmdate != None:

detailsql = ("""/*dialect*/MERGE INTO T_SAL_ORDERENTRY soe USING (SELECT so.FID,soe.FENTRYID,wx.FBILLNO,wx.F_PRSH_BASE3,

CASE

WHEN wx.F_PRSH_BASE3 = 1 THEN WX.F_GBKJ_Decimal10

ELSE F_GBKJ_Decimal19

END F_TWOF_MAINTENANCEFEENOTAX,

CASE

WHEN wx.F_PRSH_BASE3 = 1 THEN WX.F_GBKJ_Decimal12

ELSE F_GBKJ_Decimal21

END F_TWOF_MAINTENANCEFEESFOR,

CASE

WHEN wx.F_PRSH_BASE3 = 1 THEN WX.F_GBKJ_Decimal11

ELSE F_GBKJ_Decimal20

END F_TWOF_MAINTENANCEFEESTAX,wx.F_GBKJ_Decimal38,wx.F_GBKJ_Decimal26,wx.F_GBKJ_Decimal33,wx.F_GBKJ_Decimal36,wx.F_GBKJ_Decimal24,

wx.F_GBKJ_Decimal31,wx.F_GBKJ_Decimal35,wx.F_GBKJ_Decimal23,wx.F_GBKJ_Decimal30,wx.F_GBKJ_Decimal39,wx.F_GBKJ_Decimal27

,wx.F_GBKJ_Decimal34,wx.F_GBKJ_Decimal37,wx.F_GBKJ_Decimal25,wx.F_GBKJ_Decimal32,wx.F_TWOF_EQUIPMENTDISCNOTAX,

wx.F_TWOF_EQUIPMENTDISCTAX,wx.F_TWOF_EQUIPMENTDISCALLTAX,wx.F_TWOF_MANHOURDISCNOTAX,wx.F_TWOF_MANHOURDISCTAX

,wx.F_TWOF_MANHOURDISCALLTAX,wx.F_PRSH_AMOUNT4,wx.F_PRSH_AMOUNT2,wx.F_PRSH_AMOUNT3,wx.F_GBKJ_Decimal15,wx.F_PRSH_ASSISTANT1,

wx.F_GBKJ_TEXT18,wx.F_PRSH_COMBO61

FROM

T_SAL_ORDER so

INNER JOIN T_SAL_ORDERENTRY soe ON so.FID = soe.FID

INNER JOIN T_PRD_MOENTRY MS ON ms.FSRCBILLENTRYID = soe.FENTRYID

AND ms.FSALEORDERID = soe.FID

INNER JOIN T_PRD_MO MT ON MT.FID = MS.FID

AND FFORMID = 'PRD_MO'

INNER JOIN GBKJ_T_WEIXIUBAOJIA WX ON WX.F_PRSH_Text7 = MT.FBILLNO

AND WX.FDOCUMENTSTATUS = 'C' --维修报价单

WHERE

1 = 1

AND wx.F_GBKJ_DATE2 is not null

AND soe.F_TWOF_TRANSPORTATIONFOR = 0

AND wx.FBILLNO=('{0}')

) map ON (

soe.FID = map.FID

AND map.FENTRYID = soe.FENTRYID

)

WHEN matched THEN

UPDATE

SET

soe.F_TWOF_TRANSPORTATIONFOR = map.F_GBKJ_Decimal38,

soe.F_TWOF_TRANSPORTATIONNOTAX = map.F_GBKJ_Decimal26,

soe.F_TWOF_TRANSPORTATIONTAX = map.F_GBKJ_Decimal33,

soe.F_TWOF_MANHOURFOR = map.F_GBKJ_Decimal36,

soe.F_TWOF_MANHOURNOTAX = map.F_GBKJ_Decimal24,

soe.F_TWOF_MANHOURTAX = map.F_GBKJ_Decimal31,

soe.F_TWOF_EQUIPMENTFOR = map.F_GBKJ_Decimal35,

soe.F_TWOF_EQUIPMENTNOTAX = map.F_GBKJ_Decimal23,

soe.F_TWOF_EQUIPMENTTAX = map.F_GBKJ_Decimal30,

soe.F_TWOF_WARRANTYFOR = map.F_GBKJ_Decimal39,

soe.F_TWOF_WARRANTYNOTAX = map.F_GBKJ_Decimal27,

soe.F_TWOF_WARRANTYTAX = map.F_GBKJ_Decimal34,

soe.F_TWOF_MAINTENANCEFEESFOR = map.F_TWOF_MAINTENANCEFEESFOR,

soe.F_TWOF_MAINTENANCEFEENOTAX = map.F_TWOF_MAINTENANCEFEENOTAX,

soe.F_TWOF_MAINTENANCEFEESTAX = map.F_TWOF_MAINTENANCEFEESTAX,

soe.F_TWOF_SPECIALREPAIRFOR = map.F_GBKJ_Decimal37,

soe.F_TWOF_SPECIALREPAIRNOTAX = map.F_GBKJ_Decimal25,

soe.F_TWOF_SPECIALREPAIRTAX = map.F_GBKJ_Decimal32,

soe.F_TWOF_EQUIPMENTDISCNOTAX = map.F_TWOF_EQUIPMENTDISCNOTAX,

soe.F_TWOF_EQUIPMENTDISCTAXFOR = map.F_TWOF_EQUIPMENTDISCTAX,

soe.F_TWOF_EQUIPMENTDISCOFOR = map.F_TWOF_EQUIPMENTDISCALLTAX,

soe.F_TWOF_MANHOURDISCNOTAX = map.F_TWOF_MANHOURDISCNOTAX,

soe.F_TWOF_MANHOURDISCTAXFOR = map.F_TWOF_MANHOURDISCTAX,

soe.F_TWOF_MANHOURDISCFOR = map.F_TWOF_MANHOURDISCALLTAX,

soe.F_TWOF_PREFERENTIAL = map.F_PRSH_AMOUNT4,

soe.F_TWOF_DISCOUNTFEE = map.F_PRSH_AMOUNT2,

soe.F_TWOF_TAXBREAK = map.F_PRSH_AMOUNT3,

soe.F_TWOF_EQUIPMENTFEES = map.F_GBKJ_Decimal15,

soe.F_TWOF_TYPEMODELS = map.F_PRSH_ASSISTANT1,

soe.F_TWOF_TYPESERIALS = map.F_GBKJ_TEXT18,

soe.F_TWOF_ISBACKREPAIR = map.F_PRSH_COMBO61;""").format(billNo)

raise NameError(detailsql)

#count = DBUtils.Execute(this.Context,detailsql)

#if count is not None:

#this.View.ShowMessage("更新成功")

产品问题Local variable 'detailsql' referenced before assignment.

产品问题 Local variable 'detailsql' referenced before assignment.

恭喜您！

产品问题
Local variable 'detailsql' referenced before assignment.