王 垚
2022-09-29 fef143d04fc39ee5fce167fe22d727da1d042c5d
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
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_RJHYLQDBGSH : 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");
        }
        /// <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("FEntity");//获取明细信息
            foreach (var billObj in e.SelectedRows)
            {
                sql = $"/*dialect*/ exec pr_SHRjhylqdBgUpdate {billObj["Id"].ToString()}";
                sqlList.Add(sql);
            }
            DBServiceHelper.ExecuteBatch(Context, sqlList);
        }
    }
}