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 Pur_Receive : 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("FActReceiveQty"); e.FieldKeys.Add("FTLENTRYID"); e.FieldKeys.Add("FTLISFX"); } /// ///保存更新提料计划单 收料数量 /// /// public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e) { base.AfterExecuteOperationTransaction(e); List sqlList = new List(); string sql = ""; //审核时更新生产用料清单表明细领料数量 Entity entity = this.BusinessInfo.GetEntity("FDetailEntity");//获取明细信息 foreach (var billObj in e.SelectedRows) { DynamicObjectCollection entryRows = entity.DynamicProperty.GetValue(billObj.DataEntity) as DynamicObjectCollection; foreach (var entryRow in entryRows) { string fentryId = entryRow["FTLENTRYID"].ToString(); bool fisfx = Convert.ToBoolean(entryRow["FTLISFX"]); if (fentryId == "0" || fisfx) continue; sql = string.Format($"/*dialect*/update Cg_PODemandPlanBillSub set FReciveCount = FReciveCount + {Convert.ToDecimal(entryRow["ActReceiveQty"])} where FEntryID = {fentryId} "); ////LogHelper.Info("领料单的日计划用料清单ID:" + fentryId); sqlList.Add(sql); sql = string.Format($"/*dialect*/update T_PUR_ReceiveEntry set FTlisfx = 1 where FentryId = {entryRow["Id"]}"); sqlList.Add(sql); } } DBServiceHelper.ExecuteBatch(Context, sqlList); } } }