using System; using System.Collections.Generic; using Kingdee.BOS.Util; using Kingdee.BOS.Core.Metadata; using Kingdee.BOS.Core.Metadata.EntityElement; using Kingdee.BOS.Core.DynamicForm.PlugIn; using Kingdee.BOS.Core.DynamicForm.PlugIn.Args; using Kingdee.BOS.Orm.DataEntity; using Kingdee.BOS.Contracts; using Kingdee.BOS.App; using Kingdee.BOS.Core.Metadata.FieldElement; using System.ComponentModel; using Kingdee.BOS.ServiceHelper; using Kingdee.K3.SCM.App; namespace Demo.BillView.PRD { [Description("[日计划用料清单变更-反审核]按钮功能]")] [HotUpdate] public class Pro_RJHYLQDBGFSH : AbstractOperationServicePlugIn { public override void OnPreparePropertys(PreparePropertysEventArgs e) { base.OnPreparePropertys(e); e.FieldKeys.Add("FSrcBillType"); e.FieldKeys.Add("FSrcBillNo"); e.FieldKeys.Add("FBillNo"); e.FieldKeys.Add("FDayPlanId"); e.FieldKeys.Add("FDayPlanFentryId"); e.FieldKeys.Add("FHQtyMust"); e.FieldKeys.Add("FHQtyMustNew"); e.FieldKeys.Add("FUseRate"); e.FieldKeys.Add("FUseRateNew"); e.FieldKeys.Add("FHPPBomEntryID"); e.FieldKeys.Add("FDwyl"); } /// ///审核更新日计划用料清单领料数量 /// /// public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e) { base.AfterExecuteOperationTransaction(e); List sqlList = new List(); string sql = ""; //反审核时更新生产用料清单表明细领料数量 Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息 foreach (var billObj in e.SelectedRows) { sql = $"/*dialect*/ exec pr_FSHRjhylqdBgUpdate {billObj["Id"].ToString()}"; sqlList.Add(sql); } DBServiceHelper.ExecuteBatch(Context, sqlList); } } }