#二开案例# Python插件功能集合(持续更新)

Python插件功能集合：

=======下推获取即时库存表单服务插件 begin===========NEW

import clr

clr.AddReference('Kingdee.BOS')

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

from Kingdee.BOS.Core import *

from Kingdee.BOS.Core.Metadata import *

from Kingdee.BOS.Core.Bill import *

from Kingdee.BOS.Core.DynamicForm import *

def AfterCreateModelData(e):  # 适用于单据下推自动获取场景

    if this.View.OpenParameter.Status == OperationStatus.ADDNEW and this.View.OpenParameter.CreateFrom == CreateFrom.Push:

this.View.EntryBarItemClick('FSaleOrderEntry','tbGetInvStockNew')    //备注：FSaleOrderEntry为明细页签标识，tbGetInvStockNew为明细行按钮获取即时库存标识。

=======下推获取即时库存表单服务插件 end===========

=======点击按钮执行触发执行SQL语句 begin===========NEW

import clr

clr.AddReference('Kingdee.BOS')

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

clr.AddReference('Kingdee.BOS.App')

from Kingdee.BOS import *

from Kingdee.BOS.Core import *

from Kingdee.BOS.Core.Bill import *

from Kingdee.BOS.Core.DynamicForm.PlugIn import *

from Kingdee.BOS.Core.DynamicForm.PlugIn.ControlModel import *

from System import *

from Kingdee.BOS.App.Data import *

def BarItemClick(e):

    if e.BarItemKey=="tbButton_sql":

        DBUtils.Execute(this.Context,"UPDATE T_PUR_POORDER SET FCHANGEREASON='TEST002' WHERE FBILLNO = 'CGDD000019'")

        return

=======点击按钮执行触发执行SQL语句end============

=======单据保存、下推自动触发值更新begin===========NEW

import clr

clr.AddReference('System')

clr.AddReference('Kingdee.BOS')

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

from Kingdee.BOS.Core.DynamicForm.PlugIn import *

from Kingdee.BOS.Core.Metadata.EntityElement import *

from System import *

def AfterCreateNewData(e):

        this.View.InvokeFieldUpdateService("FCONTACTUNIT", 0);   //FCONTACTUNIT为需要触发值更新的字段名

=======单据保存、下推自动触发值更新end============

======python复制上一行begin======================NEW

import clr

clr.AddReference('Kingdee.BOS')

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

clr.AddReference('Kingdee.BOS.DataEntity')

from Kingdee.BOS.Util import *

from Kingdee.BOS.Core.DynamicForm import *

from Kingdee.BOS.JSON import *

from System import *

from Kingdee.BOS.Core.Bill.PlugIn import *

def AfterCreateNewEntryRow(e):

   if(e.Entity.Key.Equals("FQUOTATIONENTRY") and e.Row >0):

       this.View.Model.SetValue("FTaxPrice", this.View.Model.GetValue("FTaxPrice", e.Row - 1), e.Row);    //复制第一行，   直接把e.row-1删掉，然后写0，0表示第一行

========python复制上一行end=====================

=========表单插件设置行高python插件begin============

import clr 

clr.AddReference('System') 

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

from Kingdee.BOS.Core.DynamicForm import * 

from Kingdee.BOS.JSON import * 

def AfterBindData(e):    

  this.View.GetControl("FEntity").SetRowHeight(80);

=======表单插件设置行高python插件end================

=======表单插件设置批改python插件begin===============

import clr

clr.AddReference('Kingdee.BOS') 

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

from Kingdee.BOS.Core import * 

from Kingdee.BOS.Core.Bill import * 

from Kingdee.BOS.Core.Bill.PlugIn import *

def BarItemClick(e): 

    if e.BarItemKey=="ora_tbBulkEdit": 

        if this.ListView.CurrentSelectedRowInfo==None: 

            this.View.ShowErrMessage("请选择数据行") 

            return 

        param = BillShowParameter() 

        param.FormId = FormIdConst.BD_BulkEdit 

        this.View.ShowForm(param)

========表单插件设置批改python插件end===============

========表单插件自动提交python插件begin==============

import clr

clr.AddReference('System')

clr.AddReference('System.Data')

clr.AddReference('Kingdee.BOS')

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

clr.AddReference('Kingdee.BOS.WebApi.FormService')

clr.AddReference('Kingdee.BOS.ServiceFacade.KDServiceFx')

clr.AddRef