更新基础资料数据原创
金蝶云社区-独眼兽
独眼兽
8人赞赏了该文章 288次浏览 未经作者许可,禁止转载编辑于2023年09月12日 11:11:32
using System;
using System.Text;
using System.ComponentModel;
using System.Collections.Generic;
using Kingdee.BOS.Core.DynamicForm.PlugIn;
using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
using Kingdee.BOS.Core.Validation;
using Kingdee.K3.Core.FIN;
using Kingdee.BOS.Core;
using Kingdee.K3.SCM.App.Validator;
using Kingdee.K3.BD.Contracts.FIN;
using Kingdee.BOS.Orm.DataEntity;
using Kingdee.BOS.App.Data;
using Kingdee.BOS.Core.Metadata;
using Kingdee.BOS.Core.SqlBuilder;
using Kingdee.BOS.ServiceHelper;
using Kingdee.BOS;
using Kingdee.BOS.Log;
using Kingdee.BOS.Util;
namespace QJ.xunjia.plugIn
{
    [Description("审核操作更新物料"), HotUpdate]
    public class sss : AbstractOperationServicePlugIn
    {
        public override void OnPreparePropertys(PreparePropertysEventArgs e)//加载必要的字段属性
        {
            if (this.FormOperation.Operation.ToUpperInvariant() == "AUDIT")//审核
            {
                e.FieldKeys.Add("F_BEC_WL");
                e.FieldKeys.Add("F_BEC_Price1");
                return;
            }
        }

        public override void EndOperationTransaction(EndOperationTransactionArgs e)
        {
            if (this.FormOperation.Operation.ToUpperInvariant() == "AUDIT")//审核
            {
                foreach (DynamicObject entity in e.DataEntitys)
                {
                    if (entity != null)
                    {
                        DynamicObjectCollection obj = entity["FEntity"] as DynamicObjectCollection;
                        
                        for (int i = 0; i < obj.Count; i++)
                        {
                            string F_BEC_WL_Id = Convert.ToString(obj[i]["F_BEC_WL_Id"]);
                            string F_BEC_Price1 = Convert.ToString(obj[i]["F_BEC_Price1"]);

                            // 需要输出的字段集合,通过限定输出字段,减少数据传输量
                            List<SelectorItemInfo> goodsFields = new List<SelectorItemInfo>();
                            goodsFields.Add(new SelectorItemInfo("FMATERIALID"));
                            goodsFields.Add(new SelectorItemInfo("F_BEC_MODIFIERIDMC"));
                            goodsFields.Add(new SelectorItemInfo("F_BEC_TEXT"));
                            goodsFields.Add(new SelectorItemInfo("FREFCOST"));

                            OQLFilter filter = new OQLFilter();
                            filter.Add(new OQLFilterHeadEntityItem() { FilterString = string.Format(" FMASTERID  = '{0}' ", F_BEC_WL_Id) });
                            //数据库查询基础资料数据
                            DynamicObject[] materials = BusinessDataServiceHelper.Load(this.Context, "BD_MATERIAL", goodsFields, filter);
                            foreach (DynamicObject doItem in materials)
                            {
                                doItem["F_BEC_ModifierIdMC_Id"] = this.Context.UserId;
                                doItem["F_BEC_Text"] = DateTime.Now.ToString("yyyy/MM/dd");
                            }
                            //存储业务数据 
                            BusinessDataServiceHelper.Save(this.Context, materials);
                        }
                    }
                }
            }
        }
    }
}


图标赞 8
8人点赞
还没有人点赞,快来当第一个点赞的人吧!
图标打赏
0人打赏
还没有人打赏,快来当第一个打赏的人吧!

您的鼓励与嘉奖将成为创作者们前进的动力,如果觉得本文还不错,可以给予作者创作打赏哦!

请选择打赏金币数 *

10金币20金币30金币40金币50金币60金币
可用金币: 0