更新基础资料数据原创
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