采购对账单携带对应源业务单据二开字段实现参考示例原创
10人赞赏了该文章
665次浏览
编辑于2024年06月14日 16:16:20
采购对账生成对账单时会调用对账单保存,可以在保存操作插件里面实现二开字段携带 以下示例是新增对账单保存操作插件,在插件里面实现将采购入库单的明细备注更新到对账单的对账备注 [Description("二开字段携带到对账单参考示例")] public class Save : AbstractOperationServicePlugIn { public override void BeginOperationTransaction(BOS.Core.DynamicForm.PlugIn.Args.BeginOperationTransactionArgs e) { if (e.DataEntitys == null || e.DataEntitys.Count() <= 0) { return; } List<long> billIds = new List<long>(); foreach (DynamicObject item in e.DataEntitys) { billIds.Add(Convert.ToInt64(item["id"])); } //示例:将采购入库单的明细备注更新到对账单的对账备注 DBUtils.Execute(this.Context, string.Format( @"MERGE INTO T_PUR_RECONCILIATIONENTRY TD USING ( select TE.FENTRYID,TSE.FNOTE from T_PUR_RECONCILIATIONENTRY TE INNER JOIN T_STK_INSTOCKENTRY TSE ON TE.FSID=TSE.FENTRYID AND TE.FSRCBILLTYPE='STK_InStock' WHERE TE.FID IN ({0}) ) TS ON (TS.FENTRYID=TD.FENTRYID) WHEN MATCHED THEN UPDATE SET TD.FCONFIRMREMARK=TS.FNOTE;", string.Join(",", billIds))); } }
推荐阅读