bom成本查询如果加工费来源于价目表，显示对应的委外供应商

在bom成本查询单据体增加供应商基础资料，

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using Kingdee.BOS.Core.Metadata.EntityElement;

using Kingdee.BOS.Orm.DataEntity;

using Kingdee.BOS.ServiceHelper;

using Kingdee.BOS.Util;

using Kingdee.K3.Core.MFG.EntityHelper;

using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;

using System.ComponentModel;

using Kingdee.BOS.Core.Permission;

using Kingdee.BOS.App.Data;

using System.Data;

using Kingdee.BOS.Core.Metadata;

namespace Kingdee.K3.MFG.ENG.Business.PlugIn.DynamicForm.BomQueryCost1

{

    [Description("获取委外加工供应商")]

    [HotUpdate]

    public class BomQueryCostExtend : BomQueryCost

    {

        public override void ButtonClick(ButtonClickEventArgs e)

        {

            base.ButtonClick(e);

            if(e.Key =="FREFRESH")

            {

                Entity entity = this.Model.BillBusinessInfo.GetEntryEntity("FBottomEntity");

                DynamicObjectCollection dataEntity = this.Model.GetEntityDataObject(entity);//获取单据体数据包

                foreach(var item in dataEntity)

                {

                    decimal price = Convert.ToDecimal(item["SubPrice"]);//获取委外加工单价

                    if (price > 0)

                    {

                        DynamicObject MaterialObj = (DynamicObject)item["MaterialId"];//获取物料数据包

                        string MaterialId = Convert.ToString(MaterialObj["ID"]);//获取物料ID

                        DynamicObject CurrObj = (DynamicObject)item["CurrId"];//获取币别数据包

                        string CurrId_Id = Convert.ToString(CurrObj["ID"]);//获取币别ID

                        //获取根据物料价格币别获取委外价目表里面的供应商

                        string Sql = string.Format(@"select  b.FSUPPLIERID from t_PUR_PriceListEntry a joi