python表单插件:双击单据编号,打开单据原创
金蝶云社区-碎银几两
碎银几两
2人赞赏了该文章 95次浏览 未经作者许可,禁止转载编辑于2024年02月18日 08:23:44

场景:

字段存储了另一单据类型的单据编号,实现双击打开指定单据

import clr
clr.AddReference("System")
clr.AddReference("System.Core")
clr.AddReference("Kingdee.BOS")
clr.AddReference('Kingdee.BOS.App')
clr.AddReference("Kingdee.BOS.Core")
clr.AddReference("Kingdee.BOS.DataEntity")
clr.AddReference("Kingdee.BOS.Contracts")
from Kingdee.BOS import *
from Kingdee.BOS.App.Data import *
from Kingdee.BOS.JSON import *
from Kingdee.BOS.Core import *
from Kingdee.BOS.Core.Const import *
from Kingdee.BOS.Core.Bill import *
from Kingdee.BOS.Core.List import *
from Kingdee.BOS.Log import *
from System import *
from System.Collections.Generic import *
from System.Linq import *
def EntityRowDoubleClick(e):
    fldKey=e.ColKey.ToUpperInvariant();
    if fldKey=="F_XVKJ_MUNO":
        bilno =str(this.Model.GetValue("F_XVKJ_muno",e.Row))
        showParam = BillShowParameter()
        #根据单据编号获取单据内码
        sql="SELECT FID FROM T_SAL_QUOTATION with(nolock) WHERE FBILLNO='"+bilno+"'"
        bilid=str(DBUtils.ExecuteScalar(this.Context,sql,None))
        #this.View.ShowMessage(bilid)
        showParam.PKey=bilid
        showParam.OpenStyle.ShowType = ShowType.MainNewTabPage
        showParam.PageId = Guid.NewGuid().ToString()
        showParam.FormId = "SAL_QUOTATION"
        showParam.Status = OperationStatus.EDIT
        this.View.ShowForm(showParam)


赞 2