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_MoSave : AbstractOperationServicePlugIn
|
{
|
public override void OnPreparePropertys(PreparePropertysEventArgs e)
|
{
|
base.OnPreparePropertys(e);
|
e.FieldKeys.Add("FTreeEntity_FEntryID");
|
e.FieldKeys.Add("FDayPlanQty");
|
e.FieldKeys.Add("FDayPlanRemainQty");
|
}
|
/// <summary>
|
///
|
/// </summary>
|
/// <param name="e"></param>
|
public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e)
|
{
|
base.AfterExecuteOperationTransaction(e);
|
List<string> sqlList = new List<string>();
|
string sql = "";
|
//审核时更新生产用料清单表明细领料数量
|
Entity entity = this.BusinessInfo.GetEntity("FTreeEntity");//获取明细信息
|
foreach (var billObj in e.SelectedRows)
|
{
|
DynamicObjectCollection entryRows = entity.DynamicProperty.GetValue(billObj.DataEntity)
|
as DynamicObjectCollection;
|
foreach (var entryRow in entryRows)
|
{
|
var FDayPlanQty = entryRow["FDayPlanQty"];
|
var FDayPlanRemainQty = entryRow["FDayPlanRemainQty"];
|
var fentryId = entryRow["Id"];
|
if (Convert.ToDecimal(FDayPlanQty) == 0 && Convert.ToDecimal(FDayPlanRemainQty) == 0)
|
{
|
sql = string.Format($"/*dialect*/update T_PRD_MOENTRY set FDayPlanRemainQty = FQTY where FentryId = {fentryId}");
|
DBServiceHelper.Execute(Context, sql);
|
}
|
else
|
continue;
|
}
|
}
|
}
|
}
|
}
|
