
采购订单上根据采购员获取其对应的用户
1、新增用户字段
2、注册python表单插件,复制下面的脚本,修改`F_ABC_UserId`为自己新增的用户标识
```python
import clr
clr.AddReference('mscorlib')
clr.AddReference('Kingdee.BOS.App')
from System import *
from Kingdee.BOS.App.Data import *
def DataChanged(e):
#采购员值更新
if e.Field.Key == "FPurchaserId":
pur = this.View.Model.GetValue("FPurchaserId",0)
purId = 0#采购员内码
if pur != None:
purId = pur["Id"]
userId = GetUserIdByCGY(purId)
this.View.Model.SetValue("F_ABC_UserId",userId,0)#设置用户字段,二开修改F_ABC_UserId标识即可
#根据采购员获取绑定的用户
def GetUserIdByCGY(cgyId):
org= this.View.Model.GetValue("FPurchaseOrgId",0)
orgId = 0#采购组织内码
if org != None:
orgId = org["Id"]
sql = """select t1.FUSERID from T_SEC_USER