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