Python案例--根据子物料编码查询携带替代方案备注到BOM备注
import clr clr.AddReference('System') clr.AddReference('Kingdee.BOS') clr.AddReference('Kingdee.BOS.Core') clr.AddReference('Kingdee.BOS.DataEntity') clr.AddReference('System.Data') clr.AddReference('Kingdee.BOS') clr.AddReference('Kingdee.BOS.App') from System import * from System.Collections.Generic import * from Kingdee.BOS.Core.Bill.PlugIn import * from Kingdee.BOS.Core.DynamicForm import * from Kingdee.BOS.Orm.DataEntity import * from Kingdee.BOS.Core.DynamicForm.PlugIn.Args import * from Kingdee.BOS.Util import* from Kingdee.BOS.Core.DynamicForm.PlugIn.ControlModel import * from System import DateTime from System.Data import * from Kingdee.BOS import * from Kingdee.BOS.App.Data import * def AfterBindData(e): entryDC = this.View.Model.DataObject["SlaveRelationEntry"] ct=entryDC.Count for i in range(0,ct): material_id=entryDC[i]["SLAVERELATION_id"]; #this.View.ShowMessage(str(material_id)); orgSQL=("""/*dialect*/select cmaterial_l.FMEMO,cmaterial.FEFFECTDATE from T_ENG_SUBSTITUTEMAINITEMS pmaterial inner join T_ENG_SUBSTITUTESUBITEMS cmaterial on pmaterial.FID=cmaterial.FID inner join T_ENG_SUBSTITUTESUBITEMS_L cmaterial_l on cmaterial.FENTRYID=cmaterial_l.FENTRYID and cmaterial_l.FLOCALEID=2052 where pmaterial.FMaterialID={0} order by cmaterial.FEFFECTDATE """).format(material_id); dataRows=DBUtils.ExecuteDynamicObject(this.Context,orgSQL); for dr in dataRows: this.Model.SetValue("FRP_FChildrenMemo",dr["FMEMO"],i); def DataChanged(e): fldKey=e.Field.Key.ToUpperInvariant();#字段标识大写 if(fldKey=="FSLAVERELATION"):#FSlaveMat row=e.Row; material_obj=this.Model.GetValue("FSLAVERELATION",row); material_id=material_obj["id"]; orgSQL=("""/*dialect*/select cmaterial_l.FMEMO,cmaterial.FEFFECTDATE from T_ENG_SUBSTITUTEMAINITEMS pmaterial inner join T_ENG_SUBSTITUTESUBITEMS cmaterial on pmaterial.FID=cmaterial.FID inner join T_ENG_SUBSTITUTESUBITEMS_L cmaterial_l on cmaterial.FENTRYID=cmaterial_l.FENTRYID and cmaterial_l.FLOCALEID=2052 where pmaterial.FMaterialID={0} order by cmaterial.FEFFECTDATE """).format(material_id); #this.View.ShowMessage(orgSQL); dataRows=DBUtils.ExecuteDynamicObject(this.Context,orgSQL); for dr in dataRows: this.Model.SetValue("FRP_FChildrenMemo",dr["FMEMO"],row);
Python案例--根据子物料编码查询携带替代方案备注到BOM备注
import clrclr.AddReference('System')clr.AddReference('Kingdee.BOS')clr.AddReference('Kingdee.BOS.Core')clr.AddReference('Kingdee.B...
点击下载文档
上一篇:协同开发平台中扩展的备份与恢复下一篇:对新手小白做二开很有帮助的常用语句
本文2024-09-16 18:26:12发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-22129.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章