金蝶云 生产订单第三方下推,委外订单第三方下推
在BOS中增加生产用料清单下推调拨申请单。在生产订单下推时能选到对应规则,但下推失败。
提示“共选择了1行数据进行下推;有1行数据不满足下推数据筛选条件:插件在事件中增加的条件”第三方下推,如何理解:如生产用料清单可以直接下推调拨申请单,现在要使用生产订单下推调拨申请单,其实就是下推关系的替换,通过生产订单找到生产用料清单的内码,做到生产用料清单下推调拨申请单,这样的下推称为第三方。
如何实现:
1、新增生产用料清单到调拨申请单的单据转换,做到生产用料清单可以成功下推调拨申请单。
2、在生产订单的客户端代码(包括单据和列表)的OnTargetBillChanged的方法中,补充判断,实现源单内码替换为PPBom的内码(需要二开处理),继承BaseControlEdit,为表单下推;
继承BaseControlList,为列表下推。
已包含以下情况。
代码通过测试,可正常使用。
1.委外用料清单表单下推
2.委外用料清单列表下推
3.生产用料清单表单下推
4.生产用料清单列表下推
using Kingdee.BOS.Core.DynamicForm;
using Kingdee.BOS.Core.List;
using Kingdee.BOS.Core.List.PlugIn.Args;
using Kingdee.BOS.Orm.DataEntity;
using Kingdee.K3.MFG.SUB.Business.PlugIn;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Kingdee.K3.Core.MFG.EntityHelper;
using Kingdee.K3.MFG.ServiceHelper.PRD;
using System.ComponentModel;
using Kingdee.K3.MFG.ServiceHelper.SUB;
namespace KINGDEE.MSL
{
[Description("委外用料清单表单下推")]
public class customBILLSUB_PPBOM : BaseControlEdit
{
public override void OnTargetBillChanged(TargetBillChangedEventArgs e)
{
if (e.ConvertOperation == FormOperationEnum.Push && (e.TargetFormId == ("STK_TRANSFERAPPLY"))) //STK_TRANSFERAPPLY是调拨申请单的formid
{
List<long> moEntryIds = null;
bool isEnityKey = GetSelectRowsKeyList(e.SelectedRows, out moEntryIds);
List<long> ppBomEntrykeys = SUBPPBOMServiceHelper.GetPPBOMEntryIdesBySUBEntryID(this.Context, moEntryIds, isEnityKey);
if (ppBomEntrykeys.Count <= 0) return;
DynamicObjectCollection ppBomDatas = SUBPPBOMServiceHelper.GetPPBomEntityForSort(this.Context, ppBomEntrykeys);
var sortDatas = ppBomDatas.OrderBy(o => o.GetDynamicValue<string>("FSubReqId")).ThenBy(o => o.GetDynamicValue<string>("FSubReqEntryId")).ThenBy(o => o.GetDynamicValue<int>("FSEQ")).ToList();
List<ListSelectedRow> PPBomRows = new List<ListSelectedRow>();
foreach (DynamicObject ppBomDat in sortDatas)
{
PPBomRows.Add(new ListSelectedRow(ppBomDat.GetDynamicValue<string>("FID"), ppBomDat.GetDynamicValue<string>("FENTRYID"), 0, "SUB_PPBOM") { EntryEntityKey = "FEntity" });
}// 把源单内码替换为PPBom的内码
e.SelectedRows = PPBomRows.ToArray();
}
}
}
[Description("委外用料清单列表下推")]
public class customLISTSUB_PPBOM : BaseControlList
{
public override void OnTargetBillChanged(TargetBillChangedEventArgs e)
{
if (e.ConvertOperation == FormOperationEnum.Push && (e.TargetFormId == ("STK_TRANSFERAPPLY"))) //STK_TRANSFERAPPLY是调拨申请单的formid
{
List<long> moEntryIds = null;
bool isEnityKey = GetSelectRowsKeyList(e.SelectedRows, out moEntryIds);
List<long> ppBomEntrykeys = SUBPPBOMServiceHelper.GetPPBOMEntryIdesBySUBEntryID(this.Context, moEntryIds, isEnityKey);
if (ppBomEntrykeys.Count <= 0) return;
DynamicObjectCollection ppBomDatas = SUBPPBOMServiceHelper.GetPPBomEntityForSort(this.Context, ppBomEntrykeys);
var sortDatas = ppBomDatas.OrderBy(o => o.GetDynamicValue<string>("FSubReqId")).ThenBy(o => o.GetDynamicValue<string>("FSubReqEntryId")).ThenBy(o => o.GetDynamicValue<int>("FSEQ")).ToList();
List<ListSelectedRow> PPBomRows = new List<ListSelectedRow>();
foreach (DynamicObject ppBomDat in sortDatas)
{
PPBomRows.Add(new ListSelectedRow(ppBomDat.GetDynamicValue<string>("FID"), ppBomDat.GetDynamicValue<string>("FENTRYID"), 0, "SUB_PPBOM") { EntryEntityKey = "FEntity" });
}// 把源单内码替换为PPBom的内码
e.SelectedRows = PPBomRows.ToArray();
}
}
}
[Description("生产用料清单表单下推")]
public class customBILLPRD_PPBOM : BaseControlEdit
{
public override void OnTargetBillChanged(TargetBillChangedEventArgs e)
{
if (e.ConvertOperation == FormOperationEnum.Push && (e.TargetFormId == ("STK_TRANSFERAPPLY"))) //STK_TRANSFERAPPLY是调拨申请单的formid
{
List<long> moEntryIds = null;
bool isEnityKey = GetSelectRowsKeyList(e.SelectedRows, out moEntryIds);
List<long> ppBomEntrykeys = PPBOMServiceHelper.GetPPBOMEntryIdesByMOEntryID(this.Context, moEntryIds, isEnityKey);
if (ppBomEntrykeys.Count <= 0) return;
DynamicObjectCollection ppBomDatas = PPBOMServiceHelper.GetPPBomEntityForSort(this.Context, ppBomEntrykeys);
var sortDatas = ppBomDatas.OrderBy(o => o.GetDynamicValue<string>("FMOID")).ThenBy(o => o.GetDynamicValue<string>("FMOENTRYID")).ThenBy(o => o.GetDynamicValue<int>("FSEQ")).ToList();
List<ListSelectedRow> PPBomRows = new List<ListSelectedRow>();
foreach (DynamicObject ppBomDat in sortDatas)
{
PPBomRows.Add(new ListSelectedRow(ppBomDat.GetDynamicValue<string>("FID"), ppBomDat.GetDynamicValue<string>("FENTRYID"), 0, "PRD_PPBOM") { EntryEntityKey = "FEntity" });
}// 把源单内码替换为PPBom的内码
e.SelectedRows = PPBomRows.ToArray();
}
}
}
[Description("生产用料清单列表下推")]
public class customLISTPRD_PPBOM : BaseControlList
{
public override void OnTargetBillChanged(TargetBillChangedEventArgs e)
{
if (e.ConvertOperation == FormOperationEnum.Push && (e.TargetFormId == ("STK_TRANSFERAPPLY"))) //STK_TRANSFERAPPLY是调拨申请单的formid
{
List<long> moEntryIds = null;
bool isEnityKey = GetSelectRowsKeyList(e.SelectedRows, out moEntryIds);
List<long> ppBomEntrykeys = PPBOMServiceHelper.GetPPBOMEntryIdesByMOEntryID(this.Context, moEntryIds, isEnityKey);
if (ppBomEntrykeys.Count <= 0) return;
DynamicObjectCollection ppBomDatas = PPBOMServiceHelper.GetPPBomEntityForSort(this.Context, ppBomEntrykeys);
var sortDatas = ppBomDatas.OrderBy(o => o.GetDynamicValue<string>("FMOID")).ThenBy(o => o.GetDynamicValue<string>("FMOENTRYID")).ThenBy(o => o.GetDynamicValue<int>("FSEQ")).ToList();
List<ListSelectedRow> PPBomRows = new List<ListSelectedRow>();
foreach (DynamicObject ppBomDat in sortDatas)
{
PPBomRows.Add(new ListSelectedRow(ppBomDat.GetDynamicValue<string>("FID"), ppBomDat.GetDynamicValue<string>("FENTRYID"), 0, "PRD_PPBOM") { EntryEntityKey = "FEntity" });
}// 把源单内码替换为PPBom的内码
e.SelectedRows = PPBomRows.ToArray();
}
}
}
}