我新增使用这个去更新生产用料变更单数据包 bgentry.Add(saleEntry);//附加行自动下推就不会生成单据，不加bgentry.Add(saleEntry);//附加行可以自动下推单据，

修改值没问题就是不能新增行

服务插件要怎么新增行呢有大佬知道吗？

namespace Kingdee.Bos.Test.ServicePlugln

{

[Description("自动下推功能")]

[Kingdee.BOS.Util.HotUpdate]

//继承操作服务插件

public class OnAddValidatorsHead : AbstractOperationServicePlugIn

{

public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e)

{

base.AfterExecuteOperationTransaction(e);

int i;

// FNO 用料单据编号 materialId = 物料编码, sFitem = 源单编号, sql2 = ""

string FNO = "", materialId = "", sFitem = "", sql2 = "";

DynamicObjectCollection bgentry = null; DynamicObject saleEntry = null;

//读取全部的单据,for循环,转换成DynamicObject类型

foreach (DynamicObject entity in e.DataEntitys)

{ //如果不为空,开始循环

if (entity != null)

{

//单据转换,上游单据是什么,下游单据是什么

// var rules = ConvertServiceHelper.GetConvertRules(this.Context, "PUR_PurchaseOrder", "PUR_ReceiveBill");

//PUR_PurchaseOrder - PUR_ReceiveBill 采购订单下推收料通知单

// string convertRuleld = "PUR_PurchaseOrder-PUR_ReceiveBill";//SCP_InStockTOPayableMap为标识

//生产用料清单下推生产用料清单变更单

// string convertRuleld = "d1e48949-8b34-4dc2-8aa7-a965aa1c4662"; PRD_PPBOM - PRD_PPBOMChange，

//var rule = ConvertServiceHelper.GetConvertRule(this.Context, convertRuleld).Rule;

var rules = ConvertServiceHelper.GetConvertRules(this.Context, "PRD_PPBOM", "PRD_PPBOMChange");

//默认的单据转换

var rule = rules.FirstOrDefault(t => t.IsDefault);

//获取每个单据体,获取分录ID,判断是哪一行

DynamicObjectCollection entry = (DynamicObjectCollection)entity["PPBomEntry"];

i = 0;

ConvertOperationResult operationResult = null;

ListSelectedRow[] selectedRows = new ListSelectedRow[entry.Count];

//把选中的单据体ID,循环,全部读取出来

foreach (DynamicObject HHentity in entry)

{

selectedRows[i] = new ListSelectedRow(Convert.ToString(entity["id"]), Convert.ToString(HHentity["id"]), i, "PRD_PPBOM");

i++;

}

Dictionary<string, object> custParams = new Dictionary<string, object>();

//下推事件

PushArgs pushArgs = new PushArgs(rule, selectedRows)

{

// 请设定目标单据单据类型。如无单据类型，可以空字符

TargetBillTypeId = "6a4321986af642c895449a7671e4d10f",

// 请设定目标单据主业务组织。如无主业务组织，可以为0

TargetOrgId = 0,

// 可以传递额外附加的参数给单据转换插件，如无此需求，可以忽略

CustomParams = custParams,

};

operationResult = ConvertServiceHelper.Push(this.Context, pushArgs, OperateOption.Create());

// 获取生成的目标单据数据包

DynamicObject[] objs = (from p in operationResult.TargetDataEntities

select p.DataEntity).ToArray();

// 读取目标单据元数据

var targetBillMeta = MetaDataServiceHelper.Load(this.Context, "PRD_PPBOMChange") as FormMetadata;

OperateOption saveOption = OperateOption.Create();

//修改单据数据

foreach (DynamicObject entitybg in objs)

{

if (entity != null)

{ //如果不为空,获取供应商supplierId_Id

FNO = Convert.ToString(entitybg["SALEORDERNO"]);

//获取单据体,for循环,分别提前物料编码,含税单价

bgentry = (DynamicObjectCollection)entitybg["PPBomEntry"]; //单据体

foreach (DynamicObject HHentity in bgentry)

{

materialId = Convert.ToString(HHentity["MaterialId"]);

sFitem = Convert.ToString(HHentity["PPBOMNo"]);

//更新采购价目表,把参数传过来

if (sql2 == "")

{

//查找源订单编号

sql2 = string.Format(@"/*dialect*/select c.FSRCBILLNO, FMATERIALID from T_SAL_ORDER A LEFT JOIN T_SAL_ORDERENTRY B ON A.FID = B.FID LEFT JOIN T_SAL_ORDERENTRY_R C ON B.FENTRYID = C.FENTRYID where FBILLNO = '" + FNO + "'");

//sqlArray.Add(sql2);

}

break;

}

#pragma warning disable CS0618 // 类型或成员已过时

DataTable ds = DBUtils.ExecuteDataSet(this.Context, sql2).Tables[0]; //查找整改前订单号

#pragma warning restore CS0618 // 类型或成员已过时

string YDH, YWLBM;

if (ds != null && ds.Rows.Count > 0)

{

YDH = ds.Rows[0]["FSRCBILLNO"].ToString(); // 假设只获取第一条记录的结果

YWLBM = ds.Rows[0]["FMATERIALID"].ToString();

}

else

{

YDH = ""; // 如果没有查询到结果，‌则赋值为空字符串

YWLBM = "";

}

string sq3 = @"/*dialect*/SELECT COALESCE(zh.FMATERIALID, zq.FMATERIALID) AS FMATERIALID, zh.FBILLNO,zh.fseq , CASE

WHEN zh.FNUMBER IS NULL AND zq.FNUMBER IS NOT NULL THEN '退料'

WHEN zh.FNUMBER IS NOT NULL AND zq.FNUMBER IS NULL THEN '领料'

WHEN zh.FNUMBER IS NOT NULL AND zq.FNUMBER IS NOT NULL AND zh.FNUMERATOR <> zq.FNUMERATOR THEN '共有'

ELSE 'Same'

END AS 是否退料领料,

COALESCE(zh.FNUMBER, zq.FNUMBER) AS FNUMBER,

zh.FNUMERATOR AS 整改后,

zq.FNUMERATOR AS 整改前

FROM (SELECT B.FMATERIALID,C.FNUMBER, FNUMERATOR,a.FBILLNO,b.fseq FROM T_PRD_PPBOM A

LEFT JOIN T_PRD_PPBOMENTRY B ON A.FID = B.FID

LEFT JOIN T_BD_MATERIAL C ON B.FMATERIALID = C.FMATERIALID WHERE A.FSALEORDERNO ='" + FNO + "') zh FULL OUTER JOIN (SELECT B.FMATERIALID,C.FNUMBER, FNUMERATOR FROM T_PRD_PPBOM A " +

"LEFT JOIN T_PRD_PPBOMENTRY B ON A.FID = B.FID LEFT JOIN T_BD_MATERIAL C ON B.FMATERIALID = C.FMATERIALID WHERE A.FSALEORDERNO ='" + YDH + "') zq ON zh.FNUMBER = zq.FNUMBER";

#pragma warning disable CS0618 // 类型或成员已过时

DataTable dt = DBUtils.ExecuteDataSet(this.Context, sq3).Tables[0];

#pragma warning restore CS0618 // 类型或成员已过时

for (int ii = 0; ii < dt.Rows.Count; ii++)

{

if (dt.Rows[ii]["是否退料领料"].ToString() == "退料")

{

//取单据体

//DynamicObject saleEntry = null;

//long mid;

//获取退料单据内码

string mid = dt.Rows[ii]["FMATERIALID"].ToString();

long mida = Convert.ToInt64(mid);

//获取当前行数

int xzqhangshu= bgentry.Count;

//新增行数

saleEntry = bgentry.DynamicCollectionItemPropertyType.CreateInstance() as DynamicObject; //新增行

//获取新增后行数

int hangshu = bgentry.Count;

//复制最后一行数据到新增行

saleEntry[hangshu] =entitybg[xzqhangshu];

//赋值物料内码

saleEntry["MaterialID_Id"] = mida;

//赋值分子数量

saleEntry["NUMERATOR"] = 0;

bgentry.Add(saleEntry);//附加行

}

if (dt.Rows[ii]["是否退料领料"].ToString() == "共有" || dt.Rows[ii]["是否退料领料"].ToString() == "Same")

{

//DynamicObjectCollection entry = (DynamicObjectCollection)entity["PPBomEntry"];

int fseq = Convert.ToInt32(dt.Rows[ii]["fseq"]);

int ffid = Convert.ToInt32(dt.Rows[ii]["FMATERIALID"]);

fseq = fseq - 1;

bgentry[fseq + fseq + 1]["NUMERATOR"] = 0;

}

// 忽略全部需要交互性质的提示，直接保存；调用保存事件

var saveResult = BusinessDataServiceHelper.Save(this.Context, targetBillMeta.BusinessInfo, objs, saveOption, "Save");

}

产品问题自定义按钮 服务插件 自动下推 单据 要怎么样新增单据体数据呢？

20 产品问题 自定义按钮 服务插件 自动下推 单据 要怎么样新增单据体数据呢？

恭喜您！

产品问题
自定义按钮服务插件自动下推单据要怎么样新增单据体数据呢？

20 产品问题自定义按钮服务插件自动下推单据要怎么样新增单据体数据呢？