【场景】联系人F8无法显示完整联系人列表
【数据准备】
【原因】
客户为分配型基础资料，这里仅显示了使用组织增加的联系人，没有显示原组织的联系人
【变通方案】
(0)扩展联系人表单 BD_CommonContact
(1)挂设插件干预F8查询
```python
import clr
clr.AddReference("mscorlib")
clr.AddReference("Kingdee.BOS")
clr.AddReference("Kingdee.BOS.ServiceHelper")
clr.AddReference("Kingdee.BOS.Core")
clr.AddReference("Kingdee.BOS.App")
clr.AddReference("Kingdee.BOS.App.Core")
clr.AddReference("System.Data")
clr.AddReference("System.Core")
clr.AddReference("Kingdee.BOS.DataEntity")
from Kingdee.BOS import *
from Kingdee.BOS.KDThread import *
from Kingdee.BOS.ServiceHelper import *
from Kingdee.BOS.App.Data import *
from Kingdee.BOS.App.Core import *
from Kingdee.BOS.ServiceHelper import *
from Kingdee.BOS.Core.DynamicForm.PlugIn import *
from Kingdee.BOS.Core.DynamicForm.PlugIn.Args import *
from Kingdee.BOS.Util import *
from System import *
from System.Collections.Generic import *
from System.Data import *
from Kingdee.BOS.DataEntity import *
from System.Reflection import *
def PrepareFilterParameter(e):
if (this.View.ParentFormView == None):
return;
parentFormId = this.View.ParentFormView.BusinessInfo.GetForm().Id;
if (parentFormId.Equals("BOS_SendMail", StringComparison.OrdinalIgnoreCase)):
filterStr = e.FilterString;
startIdx = filterStr.find("'");
custStr = filterStr[startIdx+1:len(filterStr)-1];
if not(custStr.isdecimal()):
return;
custId = int(custStr);
masterId = getMasterId(custId);
repairFilterString = 'FCOMPANY = '+ str(custId) + ' OR FCOMPANY = '+ str(masterId);
e.FilterString = repairFilterString;
def getMasterId(custId):
sql = 'select FCUSTID, FMASTERID from T_BD_CUSTOMER where FCUSTID = '+ str(custId);
ans = DBUtils.ExecuteDynamicObject(this.View.Context, sql);
if(ans.Count <= 0):
return custId;
masterId = int(ans[0]['FMASTERID']);
return masterId;
```
【效果】
F8显示的和客户详情保存一致
