C#代码BOM表正查
分享一个利用递归方式进行BOM表正查的代码,仅供参考,如有不足之处,请多多包涵!
private void GetBomAll(DynamicObject parentBomObj)
{
var bomTreeEntity = (DynamicObjectCollection)parentBomObj["TreeEntity"];
foreach (DynamicObject bomRowObj in bomTreeEntity)
{
//获取BOM行子件物料数据
var materialId = (DynamicObject)bomRowObj["MATERIALIDCHILD"];
//判断是否有子BOM版本
if (bomRowObj["BOMID"] != null)
{
//这里需要再获取一下BOM对象完整数据包
var bomObj = KEDUtils.GetQueryData(this.Context, "ENG_BOM",string.Format(@"FID = {0}", bomRowObj["BOMID_Id"]));
this.GetBomAll(bomObj);
}
else
{
//判断是否可为主产品
if (Convert.ToBoolean((materialId["MaterialProduce"] as DynamicObjectCollection)?[0]["IsMainPrd"]))
throw new KDException("", "部件:" + materialId["Name"] + " 未指定子BOM版本!");
}
//TODO 业务处理
}
}
/// <summary>
/// 取数方案,通过业务对象来获取单个数据,返回单个DynamicObject对象
/// </summary>
/// <param name="formId"></param>
/// <param name="queryWhere">查询条件</param>
/// <returns>返回单个DynamicObject对象</returns>
public static DynamicObject GetQueryData(Context ctx, string formId, string queryWhere)
{
FormMetadata meta = MetaDataServiceHelper.Load(ctx, formId) as FormMetadata;
QueryBuilderParemeter queryParam = new QueryBuilderParemeter();
queryParam.FormId = formId;
if (meta != null) queryParam.BusinessInfo = meta.BusinessInfo;
queryParam.FilterClauseWihtKey = queryWhere;
var dyDatas = BusinessDataServiceHelper.Load(ctx, meta.BusinessInfo.GetDynamicObjectType(), queryParam);
if (dyDatas.Length == 0) return null;
return dyDatas[0];
}
补充:为保证每个BOM表的子BOM版本都有录入,可以添加录入子项物料自动携带子BOM插件。
//物料清单单据插件-值更新事件
public override void DataChanged(DataChangedEventArgs e)
{
base.DataChanged(e);
if (e.Field.Key.Equals("FMATERIALIDCHILD"))
{
var subMatObj = (DynamicObject)this.View.Model.GetValue("FMATERIALIDCHILD", e.Row);
if(subMatObj == null) return;
var erpClsId = Convert.ToInt32(((DynamicObjectCollection)subMatObj["MaterialBase"])[0]["ErpClsID"]);
if(erpClsId != 1)
{
var subBomObj = KEDUtils.GetQueryData(this.Context, "ENG_BOM", string.Format(@"FMaterialId = {0} and FDocumentStatus='C' and FForbidStatus='A'", e.NewValue));
if(subBomObj == null) return;
this.Model.SetItemValueByID("FBOMID",subBomObj["Id"],e.Row);
}
}
}
C#代码BOM表正查
本文2024-09-16 18:31:32发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-22706.html