在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(); } } } }