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; using ZD.Cloud.Logger; namespace Demo.DynamicForm.PRD { [Description("[生产退料单-审核]按钮功能]")] [HotUpdate] public class Pro_SCTLSH : AbstractOperationServicePlugIn { public override void OnPreparePropertys(PreparePropertysEventArgs e) { base.OnPreparePropertys(e); e.FieldKeys.Add("FSrcBillType"); e.FieldKeys.Add("FSrcBillNo"); e.FieldKeys.Add("FID"); e.FieldKeys.Add("FTreeEntity_FEntryID"); e.FieldKeys.Add("FBillNo"); e.FieldKeys.Add("FBFLowId"); e.FieldKeys.Add("FMaterialId"); e.FieldKeys.Add("FBaseUnitQty"); e.FieldKeys.Add("FBaseJoinQty"); e.FieldKeys.Add("FDayPlanBillNo"); e.FieldKeys.Add("FDayPlanFentryId"); e.FieldKeys.Add("Qty"); } /// ///审核更新日计划用料清单领料数量 /// /// 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) { DynamicObjectCollection entryRows = entity.DynamicProperty.GetValue(billObj.DataEntity) as DynamicObjectCollection; foreach (var entryRow in entryRows) { string fentryId = entryRow["FDayPlanFentryId"].ToString(); if (fentryId == "0") continue; sql = string.Format($"/*dialect*/update Sc_DayPlanPPBomBillSub set FRetunrnQty = FRetunrnQty + {Convert.ToDecimal(entryRow["BaseQty"])} where FEntryID = {fentryId} "); //LogHelper.Info("领料单的日计划用料清单ID:" + fentryId); sqlList.Add(sql); sql = string.Format($"/*dialect*/update T_PRD_RETURNMTRLENTRY set FisFX = 1 where FentryId = {entryRow["Id"]}"); sqlList.Add(sql); } } DBServiceHelper.ExecuteBatch(Context, sqlList); } } }