背景:
源单单据头上多选辅助资料字段F_JD_MulAssistant,需要携带到目标单单据头同名字段上,但是单据转换规则不支持多选辅助资料的携带。
因此需要通过单据转换插件实现;
难点:
多选辅助资料字段与多选基础资料字段的存储,与普通字段截然不同,正因为此,导致此两种字段不能直接携带;
那么如何读取源单上多选辅助资料字段值,如何填写到目标单多选辅助资料字段上?
示例代码如下,本地验证OK:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.ComponentModel;
using Kingdee.BOS;
using Kingdee.BOS.Util;
using Kingdee.BOS.App;
using Kingdee.BOS.Core;
using Kingdee.BOS.Core.Metadata;
using Kingdee.BOS.Core.Metadata.FieldElement;
using Kingdee.BOS.Core.Metadata.EntityElement;
using Kingdee.BOS.Core.Metadata.ConvertElement;
using Kingdee.BOS.Core.Metadata.ConvertElement.PlugIn;
using Kingdee.BOS.Core.Metadata.ConvertElement.PlugIn.Args;
using Kingdee.BOS.Orm.DataEntity;
using Kingdee.BOS.Contracts;
using Kingdee.BOS.Core.SqlBuilder;
namespace JDSample.ServicePlugIn.BillConvert
{
///
/// 演示在下推时携带多选辅助资料字段
///
///
/// 案例说明:
/// 源单单据头多选辅助资料字段F_JD_MulAssistant需要携带到目标单单据头同名字段上
/// 但是单据转换规则不支持多选辅助资料的携带
/// 需要通过单据转换插件实现
///
[Description("演示在下推时携带多选辅助资料字段")]
public class S150803TakeMulAssiConvPlug : AbstractConvertPlugIn
{
///
/// 单据转换完毕事件
///
///
///
/// 在此事件中,进行一些收尾工作
///
public override void AfterConvert(AfterConvertEventArgs e)
{
// 找到目标单单据关联主实体
var targetForm = e.TargetBusinessInfo.GetForm();
if (targetForm.LinkSet == null
|| targetForm.LinkSet.LinkEntitys == null
|| targetForm.LinkSet.LinkEntitys.Count == 0)
{
// 目标单未设置关联主实体,无法获取目标单的源单信息,携带不了
return;
}
// 关联主实体
Entity entity = e.TargetBusinessInfo.GetEntity(
targetForm.LinkSet.LinkEntitys[0].ParentEntityKey);
// 关联Link子实体
Entity linkEntity = e.TargetBusinessInfo.GetEntity(
targetForm.LinkSet.LinkEntitys[0].Key);
// 收集全部源单内码
HashSet
// Dictionary(目标单索引, HashSet(源单内码))
Dictionary
var entryRows = e.Result.FindByEntityKey(entity.Key);
foreach (var entryRow in entryRows)
{
int dataIndex = entryRow.DataEntityIndex;
if (dctDataIndexToSrcBillId.ContainsKey(dataIndex) == false)
{
dctDataIndexToSrcBillId.Add(dataIndex, new HashSet
}
var linkRows = linkEntity.DynamicProperty.GetValue(entryRow.DataEntity) as DynamicObjectCollection;
foreach (var linkRow in linkRows)
{
long srcBillId = Convert.ToInt64(linkRow["SBillId"]);
if (srcBillIds.Contains(srcBillId) == false)
{
srcBillIds.Add(srcBillId);
}
// 记录每条目标单,其引用的源单集合
if (dctDataIndexToSrcBillId[dataIndex].Contains(srcBillId) == false)
{
dctDataIndexToSrcBillId[dataIndex].Add(srcBillId);
}
}
}
// 读取源单上的多选辅助资料信息
IViewService viewService = ServiceHelper.GetService
// 仅加载源单内码、多选辅助资料内码
List
selectItems.Add(new SelectorItemInfo(e.SourceBusinessInfo.GetForm().PkFieldName));
selectItems.Add(new SelectorItemInfo("F_JD_MulAssistant"));
string filter = string.Format("{0} IN ({1})",
e.SourceBusinessInfo.GetForm().PkFieldName,
string.Join(",", srcBillIds));
var srcObjs = viewService.Load(this.Context,
e.SourceBusinessInfo, selectItems,
OQLFilter.CreateHeadEntityFilter(filter));
// 收集源单上全部的辅助资料内码
MulAssistantField sourceFld = e.SourceBusinessInfo.GetField("F_JD_MulAssistant") as MulAssistantField;
HashSet
// Dictionary(源单内码, HashSet(辅助资料内码))
Dictionary
foreach (var srcObj in srcObjs)
{
long srcBillId = Convert.ToInt64(srcObj[0]);
var srcAssiRows = sourceFld.RefEntityDynamicProperty.GetValue(srcObj) as DynamicObjectCollection;
foreach (var srcAssiRow in srcAssiRows)
{
string assId = Convert.ToString(sourceFld.RefIDDynamicProperty.GetValue(srcAssiRow));
if (assIds.Contains(assId) == false)
{
assIds.Add(assId);
}
if (dctSrcBillIdToAssIds.ContainsKey(srcBillId) == false)
{
dctSrcBillIdToAssIds.Add(srcBillId, new HashSet
}
if (dctSrcBillIdToAssIds[srcBillId].Contains(assId) == false)
{
dctSrcBillIdToAssIds[srcBillId].Add(assId);
}
}
}
// 加载辅助资料详情
MulAssistantField targetFld = e.TargetBusinessInfo.GetField("F_JD_MulAssistant") as MulAssistantField;
var assObjs = viewService.Load(
this.Context,
(from p in assIds select (object)p).ToArray(),
targetFld.RefFormDynamicObjectType);
// Dictionary(辅助资料内码, 辅助资料数据包)
Dictionary
foreach (var assObj in assObjs)
{
string assId = Convert.ToString(assObj[0]);
dctAssObjs.Add(assId, assObj);
}
// 向目标单填写辅助资料
var headObjs = e.Result.FindByEntityKey(targetFld.EntityKey);
foreach (var item in dctDataIndexToSrcBillId)
{
int dataIndex = item.Key;
DynamicObject headObj = headObjs[dataIndex].DataEntity;
var mulAssiRows = targetFld.RefEntityDynamicProperty.GetValue(headObj) as DynamicObjectCollection;
foreach (var srcBillId in item.Value)
{
if (dctSrcBillIdToAssIds.ContainsKey(srcBillId) == false) continue;
foreach (var assId in dctSrcBillIdToAssIds[srcBillId])
{
if (dctAssObjs.ContainsKey(assId) == false) continue;
DynamicObject newAssiRow = new DynamicObject(targetFld.RefEntityDynamicObjectType);
mulAssiRows.Add(newAssiRow);
targetFld.RefIDDynamicProperty.SetValue(newAssiRow, assId);
targetFld.DynamicProperty.SetValue(newAssiRow, dctAssObjs[assId]);
}
}
}
}
}
}
推荐阅读